Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Issue with Delta Mode

82 views
Skip to first unread message

mallic...@gmail.com

unread,
May 6, 2014, 12:22:12 AM5/6/14
to
Hi TDI Gurus,

I have configured Domino Change Detection Connector in Local Client Session Type and copied user id file to TDI solution directory.

However, when I run the AL i am getting below error message Syntax Error.

CTGDIS266E Error in NextIteratorEntry. Exception occurred: java.sql.SQLSyntaxErrorException: Syntax error:


1. Feed => ibmdi.DominoChangeDetectionConnector, able to connect successfully without any errors.

2. Data Flow => ibmdi.Database, able to connect successfully without any errors. This component is set in Update Mode Add & Mod set to True.

Please help to resolve the issue.

Thanks & Regards,
P. Mallik Ram Sharma

mallic...@gmail.com

unread,
May 6, 2014, 1:28:26 AM5/6/14
to
[DSTDOUProductionUpdates] CTGDIS004I *** Finished dumping Entry
10:54:04,584 INFO - [DSTDOUProductionUpdates] CTGDIS495I handleException , get, java.sql.SQLSyntaxErrorException: Syntax error: Encountered "DOU" at line 1, column 39.
10:54:04,586 ERROR - [DSTDOUProductionUpdates] CTGDIS810E handleException - cannot handle exception , get
java.sql.SQLSyntaxErrorException: Syntax error: Encountered "DOU" at line 1, column 39.
at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.client.am.Statement.execute(Unknown Source)
at com.ibm.di.store.StoreFactory.verifyTable(StoreFactory.java:401)
at com.ibm.di.store.DeltaStore.<init>(DeltaStore.java:154)
at com.ibm.di.store.DeltaStore.<init>(DeltaStore.java:100)
at com.ibm.di.store.DeltaSysTable.getDeltaStore(DeltaSysTable.java:54)
at com.ibm.di.fc.DeltaFC.initDelta(DeltaFC.java:288)
at com.ibm.di.fc.DeltaFC.checkInitialized(DeltaFC.java:435)
at com.ibm.di.fc.DeltaFC.perform(DeltaFC.java:463)
at com.ibm.di.server.CSDeltaTaskComponent.getnext(CSDeltaTaskComponent.java:318)
at com.ibm.di.server.AssemblyLine.msGetNextIteratorEntry(AssemblyLine.java:3662)
at com.ibm.di.server.AssemblyLine.executeMainStep(AssemblyLine.java:3371)
at com.ibm.di.server.AssemblyLine.executeMainLoop(AssemblyLine.java:2984)
at com.ibm.di.server.AssemblyLine.executeMainLoop(AssemblyLine.java:2967)
at com.ibm.di.server.AssemblyLine.executeAL(AssemblyLine.java:2936)
at com.ibm.di.server.AssemblyLine.run(AssemblyLine.java:1317)
Caused by: org.apache.derby.client.am.SqlException: Syntax error: Encountered "DOU" at line 1, column 39.
at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
at org.apache.derby.client.am.Statement.completeExecuteImmediate(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parseEXCSQLIMMreply(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.readExecuteImmediate(Unknown Source)
at org.apache.derby.client.net.StatementReply.readExecuteImmediate(Unknown Source)
at org.apache.derby.client.net.NetStatement.readExecuteImmediate_(Unknown Source)
at org.apache.derby.client.am.Statement.readExecuteImmediate(Unknown Source)
at org.apache.derby.client.am.Statement.flowExecute(Unknown Source)
at org.apache.derby.client.am.Statement.executeX(Unknown Source)
... 15 more
10:54:04,587 ERROR - CTGDIS266E Error in NextIteratorEntry. Exception occurred: java.sql.SQLSyntaxErrorException: Syntax error: Encountered "DOU" at line 1, column 39.
java.sql.SQLSyntaxErrorException: Syntax error: Encountered "DOU" at line 1, column 39.
at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.client.am.Statement.execute(Unknown Source)
at com.ibm.di.store.StoreFactory.verifyTable(StoreFactory.java:401)
at com.ibm.di.store.DeltaStore.<init>(DeltaStore.java:154)
at com.ibm.di.store.DeltaStore.<init>(DeltaStore.java:100)
at com.ibm.di.store.DeltaSysTable.getDeltaStore(DeltaSysTable.java:54)
at com.ibm.di.fc.DeltaFC.initDelta(DeltaFC.java:288)
at com.ibm.di.fc.DeltaFC.checkInitialized(DeltaFC.java:435)
at com.ibm.di.fc.DeltaFC.perform(DeltaFC.java:463)
at com.ibm.di.server.CSDeltaTaskComponent.getnext(CSDeltaTaskComponent.java:318)
at com.ibm.di.server.AssemblyLine.msGetNextIteratorEntry(AssemblyLine.java:3662)
at com.ibm.di.server.AssemblyLine.executeMainStep(AssemblyLine.java:3371)
at com.ibm.di.server.AssemblyLine.executeMainLoop(AssemblyLine.java:2984)
at com.ibm.di.server.AssemblyLine.executeMainLoop(AssemblyLine.java:2967)
at com.ibm.di.server.AssemblyLine.executeAL(AssemblyLine.java:2936)
at com.ibm.di.server.AssemblyLine.run(AssemblyLine.java:1317)
Caused by: org.apache.derby.client.am.SqlException: Syntax error: Encountered "DOU" at line 1, column 39.
at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
at org.apache.derby.client.am.Statement.completeExecuteImmediate(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parseEXCSQLIMMreply(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.readExecuteImmediate(Unknown Source)
at org.apache.derby.client.net.StatementReply.readExecuteImmediate(Unknown Source)
at org.apache.derby.client.net.NetStatement.readExecuteImmediate_(Unknown Source)
at org.apache.derby.client.am.Statement.readExecuteImmediate(Unknown Source)
at org.apache.derby.client.am.Statement.flowExecute(Unknown Source)
at org.apache.derby.client.am.Statement.executeX(Unknown Source)
... 15 more

Eddie Hartman

unread,
May 9, 2014, 6:24:32 AM5/9/14
to
Looks like the error is coming from your database Connector and that the SQL being issued is incorrect. Have you tried running with Detailed Log enabled for the Connector. That way it should log the actual SQL be used.

-Eddie

mallic...@gmail.com

unread,
May 10, 2014, 1:33:03 AM5/10/14
to
Eddie,

The problem still persists, however the above error message occurs for Update Mode. The moment it is changed to Delta Mode by establishing link criteria the problem got resolved.

Thanks,
P. Mallik Ram Sharma

mallic...@gmail.com

unread,
May 10, 2014, 1:45:48 AM5/10/14
to
Delta Mode displays error message.

18:55:57,577 INFO - [DSTDOUProductionUpdates] CTGDIS058I Connector com.ibm.di.connector.DominoChangeDetectionConnector inherits from [parent].
18:55:57,577 INFO - [DSTDOUProductionUpdates] CTGDIS187I Loaded com.ibm.di.connector.DominoChangeDetectionConnector, 2.0-di7.1.1 1.61, 2011/08/02.
18:55:57,578 INFO - [DSTDOUProductionUpdates] CTGDIS064I Loading Attribute Map.
18:55:57,578 INFO - [DSTDOUProductionUpdates] CTGDIS065I Load Hooks.
18:55:57,579 INFO - [DB2] CTGDIS058I Connector com.ibm.di.connector.JDBCConnector inherits from [parent].
18:55:57,579 INFO - [DB2] CTGDIS187I Loaded com.ibm.di.connector.JDBCConnector, 2.3-di7.1.1 1.74.1.67, 2012/07/06.
18:55:57,579 INFO - [DB2] CTGDIS064I Loading Attribute Map.
18:55:57,580 INFO - [DB2] CTGDIS065I Load Hooks.
18:55:57,581 INFO - [DSTDOUProductionUpdates] CTGDIS044I Initializing Connector.
18:55:57,582 INFO - [DSTDOUProductionUpdates] CTGDIE092W The iterator state key is not specified. No state will be stored. The Start At parameter's value will be used.
18:55:57,597 INFO - [DSTDOUProductionUpdates] CTGDJE074I Local Client Session successfully created.
18:55:57,598 INFO - [DSTDOUProductionUpdates] CTGDJE013I Successfully connected to Domino Server: Name='', Version='Release 8.5.3FP5SHF238|December 19, 2013', Platform='Windows/32'.
18:55:57,621 INFO - [DSTDOUProductionUpdates] CTGDIS495I handleException , initialize, java.lang.Exception: CTGDIZ901E Delta key attribute not defined.
18:55:57,623 ERROR - [DSTDOUProductionUpdates] CTGDIS810E handleException - cannot handle exception , initialize
java.lang.Exception: CTGDIZ901E Delta key attribute not defined.
at com.ibm.di.fc.DeltaFC.setKeyAttributes(DeltaFC.java:363)
at com.ibm.di.fc.DeltaFC.initialize(DeltaFC.java:224)
at com.ibm.di.server.CSDeltaTaskComponent.initDeltaFC(CSDeltaTaskComponent.java:119)
at com.ibm.di.server.CSDeltaTaskComponent.doInitialize(CSDeltaTaskComponent.java:182)
at com.ibm.di.server.AssemblyLineComponent.initialize(AssemblyLineComponent.java:1151)
at com.ibm.di.server.AssemblyLine.initConnectors(AssemblyLine.java:1909)
at com.ibm.di.server.AssemblyLine.msInitConn(AssemblyLine.java:3549)
at com.ibm.di.server.AssemblyLine.executeMainStep(AssemblyLine.java:3359)
at com.ibm.di.server.AssemblyLine.executeMainLoop(AssemblyLine.java:2984)
at com.ibm.di.server.AssemblyLine.executeMainLoop(AssemblyLine.java:2967)
at com.ibm.di.server.AssemblyLine.executeAL(AssemblyLine.java:2936)
at com.ibm.di.server.AssemblyLine.run(AssemblyLine.java:1317)
18:55:57,624 ERROR - CTGDIS266E Error in InitConnectors. Exception occurred: java.lang.Exception: CTGDIZ901E Delta key attribute not defined.
java.lang.Exception: CTGDIZ901E Delta key attribute not defined.
at com.ibm.di.fc.DeltaFC.setKeyAttributes(DeltaFC.java:363)
at com.ibm.di.fc.DeltaFC.initialize(DeltaFC.java:224)
at com.ibm.di.server.CSDeltaTaskComponent.initDeltaFC(CSDeltaTaskComponent.java:119)
at com.ibm.di.server.CSDeltaTaskComponent.doInitialize(CSDeltaTaskComponent.java:182)
at com.ibm.di.server.AssemblyLineComponent.initialize(AssemblyLineComponent.java:1151)
at com.ibm.di.server.AssemblyLine.initConnectors(AssemblyLine.java:1909)
at com.ibm.di.server.AssemblyLine.msInitConn(AssemblyLine.java:3549)
at com.ibm.di.server.AssemblyLine.executeMainStep(AssemblyLine.java:3359)
at com.ibm.di.server.AssemblyLine.executeMainLoop(AssemblyLine.java:2984)
at com.ibm.di.server.AssemblyLine.executeMainLoop(AssemblyLine.java:2967)
at com.ibm.di.server.AssemblyLine.executeAL(AssemblyLine.java:2936)
at com.ibm.di.server.AssemblyLine.run(AssemblyLine.java:1317)
18:55:57,625 INFO - CTGDIS100I Printing the Connector statistics.
18:55:57,625 INFO - [DSTDOUProductionUpdates] Errors:1
18:55:57,625 INFO - [DB2] Not used
18:55:57,626 INFO - CTGDIS104I Total: Errors:2.
18:55:57,626 INFO - CTGDIS101I Finished printing the Connector statistics.
18:55:57,626 ERROR - CTGDIS077I Failed with error: CTGDIZ901E Delta key attribute not defined..

Eddie Hartman

unread,
May 13, 2014, 5:27:54 AM5/13/14
to
Seeing this error: CTGDIZ901E Delta key attribute not defined
Makes me think your Delta configuration is not complete, Pervela.

-Eddie
0 new messages