Job_ExtractICON failed (DBError=UNCATEGORIZED; Incorrect syntax near '1'..)

[longcao]

Hi, Guys,

I run Job_ExtractICON to extract configuration data from IDB to Infomart, but Job_ExtractICON failed,

SQLSTATE=S0001; error code=102; DBError=UNCATEGORIZED; Incorrect syntax near '1'.. what does it  mean?


Caused by: com.genesyslab.gim.etl.exceptions.UncategorizedSQLException: executeUpdate; Uncategorized SQLException for SQL [INSERT INTO dbo.TMP_GC_SCRIPT WITH(TABLOCK) (ID,NAME,TENANTID,FOLDERID,TYPE,STATE,STATUS,CREATED,DELETED,LASTCHANGE,CREATED_TS,CREATED_TCODE,DELETED_TS,DELETED_TCODE,LASTCHANGE_TS,LASTCHANGE_TCODE,GSYS_DOMAIN,GSYS_PARTITION,GSYS_SYS_ID,GSYS_SEQ,GSYS_USEQ,GSYS_TS,GSYS_TC,GSYS_EXT_VCH1,GSYS_EXT_VCH2,GSYS_EXT_INT1,GSYS_EXT_INT2,DATA_SOURCE_KEY,CREATE_AUDIT_KEY,UPDATE_AUDIT_KEY) SELECT ID,NAME,TENANTID,FOLDERID,TYPE,STATE,STATUS,CREATED,DELETED,LASTCHANGE,CREATED_TS,CREATED_TCODE,DELETED_TS,DELETED_TCODE,LASTCHANGE_TS,LASTCHANGE_TCODE,GSYS_DOMAIN,GSYS_PARTITION,GSYS_SYS_ID,GSYS_SEQ,GSYS_USEQ,GSYS_TS,GSYS_TC,GSYS_EXT_VCH1,GSYS_EXT_VCH2,GSYS_EXT_INT1,GSYS_EXT_INT2,(1) DATA_SOURCE_KEY,(102) CREATE_AUDIT_KEY,(0) UPDATE_AUDIT_KEY FROM 1Icon.dbo.GIM_GC_SCRIPT_LTS WHERE LASTCHANGE_TS BETWEEN 1262304001 AND 1313438110]; SQLSTATE=S0001; error code=102; DBError=UNCATEGORIZED; Incorrect syntax near '1'.
at com.genesyslab.gim.etl.exceptions.SQLExceptionTranslator.translate(SQLExceptionTranslator.java:31)
at com.genesyslab.gim.etl.util.jdbc.SQLUtils.executeUpdate(SQLUtils.java:836)
at com.genesyslab.gim.etl.util.jdbc.SQLUtils.executeUpdate(SQLUtils.java:896)
at com.genesyslab.gim.etl.util.jdbc.SQLUtils.executeUpdate(SQLUtils.java:916)
at com.genesyslab.gim.etl.jobs.extract.DefaultCmdExecutor.executeUpdate(DefaultCmdExecutor.java:306)
at com.genesyslab.gim.etl.jobs.extract.DefaultCmdExecutor.executeUsingDbLinks(DefaultCmdExecutor.java:249)
at com.genesyslab.gim.etl.jobs.extract.DefaultCmdExecutor.execute(DefaultCmdExecutor.java:205)
at com.genesyslab.gim.etl.jobs.extract.Worker.runCoreSelectInsertSteps(Worker.java:225)
at com.genesyslab.gim.etl.jobs.extract.Worker.runStep(Worker.java:125)
... 15 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '1'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:775)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:676)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(SQLServerStatement.java:633)
at com.genesyslab.gim.etl.util.jdbc.SQLUtils$StatementSQLCmd.update(SQLUtils.java:229)
at com.genesyslab.gim.etl.util.jdbc.SQLUtils.executeUpdate(SQLUtils.java:822)
... 22 more

00:29:44.921 Trc 30000 BunchExecutorService.doCancelAll (15,MINUTES) - enter
00:29:44.921 Trc 30000 BunchExecutorService.doCancelAll - exit returning true
00:29:44.921 Std 20049 Job step 'EXTRACT' failed com.genesyslab.gim.etl.exceptions.TaskExecutionException: com.genesyslab.gim.etl.exceptions.UncategorizedSQLException: executeUpdate; Uncategorized SQLException for SQL [INSERT INTO dbo.TMP_GC_SCRIPT WITH(TABLOCK) (ID,NAME,TENANTID,FOLDERID,TYPE,STATE,STATUS,CREATED,DELETED,LASTCHANGE,CREATED_TS,CREATED_TCODE,DELETED_TS,DELETED_TCODE,LASTCHANGE_TS,LASTCHANGE_TCODE,GSYS_DOMAIN,GSYS_PARTITION,GSYS_SYS_ID,GSYS_SEQ,GSYS_USEQ,GSYS_TS,GSYS_TC,GSYS_EXT_VCH1,GSYS_EXT_VCH2,GSYS_EXT_INT1,GSYS_EXT_INT2,DATA_SOURCE_KEY,CREATE_AUDIT_KEY,UPDATE_AUDIT_KEY) SELECT ID,NAME,TENANTID,FOLDERID,TYPE,STATE,STATUS,CREATED,DELETED,LASTCHANGE,CREATED_TS,CREATED_TCODE,DELETED_TS,DELETED_TCODE,LASTCHANGE_TS,LASTCHANGE_TCODE,GSYS_DOMAIN,GSYS_PARTITION,GSYS_SYS_ID,GSYS_SEQ,GSYS_USEQ,GSYS_TS,GSYS_TC,GSYS_EXT_VCH1,GSYS_EXT_VCH2,GSYS_EXT_INT1,GSYS_EXT_INT2,(1) DATA_SOURCE_KEY,(102) CREATE_AUDIT_KEY,(0) UPDATE_AUDIT_KEY FROM 1Icon.dbo.GIM_GC_SCRIPT_LTS WHERE LASTCHANGE_TS BETWEEN 1262304001 AND 1313438110]; SQLSTATE=S0001; error code=102; DBError=UNCATEGORIZED; Incorrect syntax near '1'..
00:29:44.937 Std 20044 Job 'Job_ExtractICON' completed unsuccessfully.

Thanks in advance.

[Allan]

Hi,
My response to your other post will apply to this. Resynch the data and try again
Allan

[longcao]

Thanks.

I found where the problem is,  DBname like 1XXX can be accepted by mssql, but not supported by Genesys apps.

[aj]

Actually it looks like it's the MS SQLServer JDBC library choking on the '1'.