You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@seatunnel.apache.org by "ll996960921 (via GitHub)" <gi...@apache.org> on 2026/01/26 07:12:50 UTC

[I] Unable to create a source for identifier 'Oracle-CDC' [seatunnel]

ll996960921 opened a new issue, #10397:
URL: https://github.com/apache/seatunnel/issues/10397

   ### Search before asking
   
   - [x] I had searched in the [issues](https://github.com/apache/seatunnel/issues?q=is%3Aissue+label%3A%22bug%22) and found no similar issues.
   
   
   ### What happened
   
   试了2.3.5,2.3.10,2.3.11版本都报这个错
   
   ### SeaTunnel Version
   
   Seatunnel-2.3.12
   
   ### SeaTunnel Config
   
   ```conf
   env {
     parallelism = 1
     job.mode = "STREAMING"
     checkpoint.interval = 5000
   }
   
   source {
     Oracle-CDC {
       driver = "oracle.jdbc.OracleDriver"
       username = "LOGMINER_USER"
       password = "******"
       table-names = ["LOGMINER_USER.USER"]
       base-url = "jdbc:oracle:thin:@175.24.47.111:1521/XE"
       cdc.scan.startup.mode = "initial"
       source.reader.close.timeout = 120000
     }
   }
   
   sink {
       Jdbc {
           url = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&rewriteBatchedStatements=true"
           driver = "com.mysql.cj.jdbc.Driver"
           user = "root"
           password = "root123456"
           query = "INSERT INTO user (name, pwd, gender,create_time,update_time) VALUES (?,?,?,?,?)"
       }
   }
   ```
   
   ### Running Command
   
   ```shell
   ./bin/seatunnel.sh -c ./config/oracle_cdc.conf
   ```
   
   ### Error Exception
   
   ```log
   2026-01-26 14:25:53,639 ERROR [o.a.s.c.s.SeaTunnel           ] [main] - 
   
   ===============================================================================
   
   
   2026-01-26 14:25:53,639 ERROR [o.a.s.c.s.SeaTunnel           ] [main] - Fatal Error, 
   
   2026-01-26 14:25:53,639 ERROR [o.a.s.c.s.SeaTunnel           ] [main] - Please submit bug report in https://github.com/apache/seatunnel/issues
   
   2026-01-26 14:25:53,640 ERROR [o.a.s.c.s.SeaTunnel           ] [main] - Reason:SeaTunnel job executed failed 
   
   2026-01-26 14:25:53,642 ERROR [o.a.s.c.s.SeaTunnel           ] [main] - Exception StackTrace:org.apache.seatunnel.core.starter.exception.CommandExecuteException: SeaTunnel job executed failed
   	at org.apache.seatunnel.core.starter.seatunnel.command.ClientExecuteCommand.execute(ClientExecuteCommand.java:228)
   	at org.apache.seatunnel.core.starter.SeaTunnel.run(SeaTunnel.java:40)
   	at org.apache.seatunnel.core.starter.seatunnel.SeaTunnelClient.main(SeaTunnelClient.java:40)
   Caused by: org.apache.seatunnel.api.table.factory.FactoryException: ErrorCode:[API-06], ErrorDescription:[Factory initialize failed] - Unable to create a source for identifier 'Oracle-CDC'.
   	at org.apache.seatunnel.api.table.factory.FactoryUtil.restoreAndPrepareSource(FactoryUtil.java:168)
   	at org.apache.seatunnel.api.table.factory.FactoryUtil.createAndPrepareSource(FactoryUtil.java:86)
   	at org.apache.seatunnel.engine.core.parse.MultipleTableJobConfigParser.parseSource(MultipleTableJobConfigParser.java:394)
   	at org.apache.seatunnel.engine.core.parse.MultipleTableJobConfigParser.parse(MultipleTableJobConfigParser.java:244)
   	at org.apache.seatunnel.engine.client.job.ClientJobExecutionEnvironment.getLogicalDag(ClientJobExecutionEnvironment.java:123)
   	at org.apache.seatunnel.engine.client.job.ClientJobExecutionEnvironment.execute(ClientJobExecutionEnvironment.java:191)
   	at org.apache.seatunnel.core.starter.seatunnel.command.ClientExecuteCommand.execute(ClientExecuteCommand.java:165)
   	... 2 more
   Caused by: org.apache.seatunnel.common.utils.SeaTunnelException: Can not find catalog table with factoryId [Oracle]
   	at org.apache.seatunnel.api.table.catalog.CatalogTableUtil.lambda$getCatalogTables$0(CatalogTableUtil.java:131)
   	at java.util.Optional.map(Optional.java:215)
   	at org.apache.seatunnel.api.table.catalog.CatalogTableUtil.getCatalogTables(CatalogTableUtil.java:118)
   	at org.apache.seatunnel.api.table.catalog.CatalogTableUtil.getCatalogTables(CatalogTableUtil.java:98)
   	at org.apache.seatunnel.connectors.seatunnel.cdc.oracle.source.OracleIncrementalSourceFactory.lambda$restoreSource$2(OracleIncrementalSourceFactory.java:117)
   	at org.apache.seatunnel.api.table.factory.FactoryUtil.createAndPrepareSource(FactoryUtil.java:180)
   	at org.apache.seatunnel.api.table.factory.FactoryUtil.restoreAndPrepareSource(FactoryUtil.java:136)
   	... 8 more
    
   2026-01-26 14:25:53,642 ERROR [o.a.s.c.s.SeaTunnel           ] [main] - 
   ===============================================================================
   
   
   
   Exception in thread "main" org.apache.seatunnel.core.starter.exception.CommandExecuteException: SeaTunnel job executed failed
   	at org.apache.seatunnel.core.starter.seatunnel.command.ClientExecuteCommand.execute(ClientExecuteCommand.java:228)
   	at org.apache.seatunnel.core.starter.SeaTunnel.run(SeaTunnel.java:40)
   	at org.apache.seatunnel.core.starter.seatunnel.SeaTunnelClient.main(SeaTunnelClient.java:40)
   Caused by: org.apache.seatunnel.api.table.factory.FactoryException: ErrorCode:[API-06], ErrorDescription:[Factory initialize failed] - Unable to create a source for identifier 'Oracle-CDC'.
   	at org.apache.seatunnel.api.table.factory.FactoryUtil.restoreAndPrepareSource(FactoryUtil.java:168)
   	at org.apache.seatunnel.api.table.factory.FactoryUtil.createAndPrepareSource(FactoryUtil.java:86)
   	at org.apache.seatunnel.engine.core.parse.MultipleTableJobConfigParser.parseSource(MultipleTableJobConfigParser.java:394)
   	at org.apache.seatunnel.engine.core.parse.MultipleTableJobConfigParser.parse(MultipleTableJobConfigParser.java:244)
   	at org.apache.seatunnel.engine.client.job.ClientJobExecutionEnvironment.getLogicalDag(ClientJobExecutionEnvironment.java:123)
   	at org.apache.seatunnel.engine.client.job.ClientJobExecutionEnvironment.execute(ClientJobExecutionEnvironment.java:191)
   	at org.apache.seatunnel.core.starter.seatunnel.command.ClientExecuteCommand.execute(ClientExecuteCommand.java:165)
   	... 2 more
   Caused by: org.apache.seatunnel.common.utils.SeaTunnelException: Can not find catalog table with factoryId [Oracle]
   	at org.apache.seatunnel.api.table.catalog.CatalogTableUtil.lambda$getCatalogTables$0(CatalogTableUtil.java:131)
   	at java.util.Optional.map(Optional.java:215)
   	at org.apache.seatunnel.api.table.catalog.CatalogTableUtil.getCatalogTables(CatalogTableUtil.java:118)
   	at org.apache.seatunnel.api.table.catalog.CatalogTableUtil.getCatalogTables(CatalogTableUtil.java:98)
   	at org.apache.seatunnel.connectors.seatunnel.cdc.oracle.source.OracleIncrementalSourceFactory.lambda$restoreSource$2(OracleIncrementalSourceFactory.java:117)
   	at org.apache.seatunnel.api.table.factory.FactoryUtil.createAndPrepareSource(FactoryUtil.java:180)
   	at org.apache.seatunnel.api.table.factory.FactoryUtil.restoreAndPrepareSource(FactoryUtil.java:136)
   	... 8 more
   ```
   
   ### Zeta or Flink or Spark Version
   
   _No response_
   
   ### Java or Scala Version
   
   _No response_
   
   ### Screenshots
   
   试了2.3.5,2.3.10,2.3.11版本都报这个错
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@seatunnel.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] Unable to create a source for identifier 'Oracle-CDC' [seatunnel]

Posted by "DanielCarter-stack (via GitHub)" <gi...@apache.org>.
DanielCarter-stack commented on issue #10397:
URL: https://github.com/apache/seatunnel/issues/10397#issuecomment-3798633241

   <!-- code-pr-reviewer -->
   This issue is caused by incorrect configuration rather than a code bug. The error occurs because:
   
   1. **Wrong parameter name**: `base-url` does not exist. The correct parameter is `url` (see `OracleIncrementalSourceFactory.java:54-79`).
   
   2. **Missing required parameters**: `database-names` and `schema-names` are required for Oracle Catalog creation. Without them, `CatalogFactory.createCatalog()` fails, causing `catalog.getTables()` to return an empty list and throwing the error at `CatalogTableUtil.java:131`.
   
   3. **Incomplete table-names format**: The code expects `${database}.${schema}.${table}` (3 parts) or `${schema}.${table}` (2 parts) as validated in `OracleSourceConfigFactory.java:200-205`.
   
   Your fix in the comments is correct. For reference, see the valid E2E test config at `seatunnel-e2e/seatunnel-connector-v2-e2e/connector-cdc-oracle-e2e/src/test/resources/oraclecdc_to_oracle.conf:30-36`.
   
   Consider closing this issue and creating a documentation improvement task to clarify the required parameters.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@seatunnel.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] Unable to create a source for identifier 'Oracle-CDC' [seatunnel]

Posted by "yzeng1618 (via GitHub)" <gi...@apache.org>.
yzeng1618 commented on issue #10397:
URL: https://github.com/apache/seatunnel/issues/10397#issuecomment-3798417588

   Correct the configuration parameter: change base-url to url, then test to see if the issue is resolved.
   <img width="1385" height="563" alt="Image" src="https://github.com/user-attachments/assets/0758abae-c199-44e8-9681-c1856ca8ac1f" />
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@seatunnel.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] Unable to create a source for identifier 'Oracle-CDC' [seatunnel]

Posted by "ll996960921 (via GitHub)" <gi...@apache.org>.
ll996960921 commented on issue #10397:
URL: https://github.com/apache/seatunnel/issues/10397#issuecomment-3798531272

   问题已解决,修改了这块的配置后,可以了
     database-names = ["XE"],
     schema-names = ["LOGMINER_USER"],
     table-names = ["XE.LOGMINER_USER.USER"]


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@seatunnel.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] Unable to create a source for identifier 'Oracle-CDC' [seatunnel]

Posted by "LiJie20190102 (via GitHub)" <gi...@apache.org>.
LiJie20190102 closed issue #10397: Unable to create a source for identifier 'Oracle-CDC'
URL: https://github.com/apache/seatunnel/issues/10397


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@seatunnel.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org