TDM Publish Exception: StatementCallback; bad SQL grammar ORA-00907
Article ID: 368628
Updated On:
Products
Issue/Introduction
Just installed the new version of TDM package (4.11.71.0).
Done some tests using the TDM Portal and all tests failed:
Publish using Self Service fails in the creation of an internal table (something in the SQL statement generates the error).
=======================================================================================================
2024-05-17 08:57:04.479 UTC [INFO ] [taskExecutor-2 ] --- [U:][M:][P:] c.c.t.p.l.TDMPublishLog: ERROR: Publish failed for job 149915, StatementCallback; bad SQL grammar [CREATE TABLE PG_149915_111612(C2500110 NUMBER(16) NOT NULL,C2500111 VARCHAR2(28) NOT NULL,C2500112 VARCHAR2(28),CONSTRAINT PG_149915_111612_PK PRIMARY KEY (C2500110),CONSTRAINT PG_149915_111612_UK0 UNIQUE (C2500110)CONSTRAINT PG_149915_111612_UK0 UNIQUE (C2500111),CONSTRAINT PG_149915_111612_UK1 UNIQUE (C2500112))]
2024-05-17 08:57:04.480 UTC [INFO ] [taskExecutor-2 ] --- [U:][M:][P:] c.c.t.p.l.TDMPublishLog: End date and time: 2024/05/17 10:57:04
2024-05-17 08:57:04.703 UTC [INFO ] [taskExecutor-2 ] --- [U:][M:][P:] c.c.t.p.t.TDMPublishStatusSender: Successfully sent status update for job 149915 to Job Engine Service, Status Code: 200 OK
2024-05-17 08:57:04.704 UTC [ERROR] [taskExecutor-2 ] --- [U:][M:][P:] c.c.t.p.m.TDMPublishJobStart: doPublish error, jobId=149915, Exception: StatementCallback; bad SQL grammar [CREATE TABLE PG_149915_111612(C2500110 NUMBER(16) NOT NULL,C2500111 VARCHAR2(28) NOT NULL,C2500112 VARCHAR2(28),CONSTRAINT PG_149915_111612_PK PRIMARY KEY (C2500110),CONSTRAINT PG_149915_111612_UK0 UNIQUE (C2500110)CONSTRAINT PG_149915_111612_UK0 UNIQUE (C2500111),CONSTRAINT PG_149915_111612_UK1 UNIQUE (C2500112))]
2024-05-17 08:57:04.705 UTC [ERROR] [taskExecutor-2 ] --- [U:][M:][P:] c.c.t.p.l.TDMPublishLog: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [CREATE TABLE PG_149915_111612(C2500110 NUMBER(16) NOT NULL,C2500111 VARCHAR2(28) NOT NULL,C2500112 VARCHAR2(28),CONSTRAINT PG_149915_111612_PK PRIMARY KEY (C2500110),CONSTRAINT PG_149915_111612_UK0 UNIQUE (C2500110)CONSTRAINT PG_149915_111612_UK0 UNIQUE (C2500111),CONSTRAINT PG_149915_111612_UK1 UNIQUE (C2500112))]
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:103)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:107)
at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1548)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:408)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:444)
at com.ca.tdm.publ.model.TDMPublishJobStartAccessor.createTable(TDMPublishJobStartAccessor.java:591)
at com.ca.tdm.publ.store.TDMPublishStoreTable.createTable(TDMPublishStoreTable.java:140)
at com.ca.tdm.publ.store.TDMPublishStoreTable.<init>(TDMPublishStoreTable.java:93)
at com.ca.tdm.publ.objs.TDMPublishTable.createStoreTableIfNotExist(TDMPublishTable.java:417)
at com.ca.tdm.publ.genduplicate.TDMPublishGenDuplicateChecker.<init>(TDMPublishGenDuplicateChecker.java:58)
at com.ca.tdm.publ.model.TDMPublishJobStart.prePublishTables(TDMPublishJobStart.java:925)
at com.ca.tdm.publ.model.TDMPublishJobStart.doPublish(TDMPublishJobStart.java:564)
at com.ca.tdm.publ.publthread.TDMPublishThread.run(TDMPublishThread.java:46)
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis
==============================================================================================================
All these tests done yesterday with the old version of the TDM Portal (4.10.246.0) and all tests worked fine.
TDM Package Version installed: 4.11.71.0
TDM Portal version installed: 4.11.71.0
Javelin version installed: 4.11.0.57
TDM Datamaker version installed: 4.11.15.0(Runtime: 22.0.0.1900)
Environment
TDM Portal 4.11.71
Cause
Product defect.
Resolution
Issue fixed in TDM Portal version 4.11.72.
Feedback
