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

   ### 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
   
   API-06 [Factory initialize failed] - Unable to create a source for 
identifier 'SqlServer-CDC'
   └─ java.lang.IllegalArgumentException:
      Cannot get split 'LIS6.0.dbo.LIS_ITEM' to get databaseName and tableName
         at TablePath.of(TablePath.java:69)
         at Catalog.buildCatalogTablesWithErrorCheck(Catalog.java:223)
         at SqlServerIncrementalSourceFactory.lambda$createSource$1(:123)
   
   ### SeaTunnel Version
   
   Seatunnel 3.0
   
   ### SeaTunnel Config
   
   ```conf
   env {
     parallelism = 2
     job.mode = "STREAMING"
     checkpoint.interval = 30000
   }
   
   source {
     SqlServer-CDC {
       plugin_output = "cdc_lis6"
   
       url = 
"jdbc:sqlserver://10.11.11.133:1433;databaseName=LIS6.0;encrypt=false;trustServerCertificate=true"
       username = "st"
       password = "st133"
   
       database-names = ["LIS6.0"]
       table-names = [
         "LIS6.0.dbo.LIS_ITEM",
         "LIS6.0.dbo.LIS_HISITEM"
       ]
   
     
       startup.mode = "initial"        # ★ 先全量快照,自动切增量
       server-time-zone = "Asia/Shanghai"
   
       snapshot.split.size = 8096
       snapshot.fetch.size = 1024
       incremental.parallelism = 1
       connect.timeout = 30s
       connect.max-retries = 3
     }
   }
   
   transform {
     TableRename {
       plugin_input  = ["cdc_lis6"]
       plugin_output = "cdc_lis6_upper"
       convert_case  = "UPPER"          # ★ 产出 LIS_ITEM / LIS_HISITEM
     }
   }
   
   sink {
     Jdbc {
       plugin_input = ["cdc_lis6_upper"]
   
       url      = "jdbc:oracle:thin:@//10.10.11.45:1521/ods"
       driver   = "oracle.jdbc.OracleDriver"
       username = "ods"
       password = "ods2026"
       database = "ODS"
       table    = "${table_name}"
   
       generate_sink_sql = true
       schema_save_mode  = "CREATE_SCHEMA_WHEN_NOT_EXIST"
       data_save_mode    = "APPEND_DATA"
       primary_keys      = ["${primary_key}"]
   
       batch_size  = 1000
       max_retries = 3
     }
   }
   ```
   
   ### Running Command
   
   ```shell
   seatunnel.sh --async -n cdc_mssql_lis1
   ```
   
   ### Error Exception
   
   ```log
   API-06 [Factory initialize failed] - Unable to create a source for 
identifier 'SqlServer-CDC'
   └─ java.lang.IllegalArgumentException:
      Cannot get split 'LIS6.0.dbo.LIS_ITEM' to get databaseName and tableName
         at TablePath.of(TablePath.java:69)
         at Catalog.buildCatalogTablesWithErrorCheck(Catalog.java:223)
         at SqlServerIncrementalSourceFactory.lambda$createSource$1(:123)
   ```
   
   ### Zeta or Flink or Spark Version
   
   Zeta
   
   ### Java or Scala Version
   
   jdk11
   
   ### Screenshots
   
   _No response_
   
   ### 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to