Symptom
When attempting to create the first subscription with Smart Data Integration (SDI) using the DB2LTLAdaper, the framework.trc shows the following errors:
- [ERROR] [4aff0fd8-bf82-4a66-a240-1021b402d11616865] MetadataQuerier | MetadataQuerier.getTableMetadata - Failed to query CCSID and FOREIGNKEY from system table SYSIBM.SYSCOLUMNS for tbcreator [<owner>] and tbname [<table name>] and column name [<column name>].
- Context: DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501, SQLERRMC=<User>;SELECT;SYSIBM.SYSCOLUMNS, DRIVER=4.21.29
- com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501, SQLERRMC=<User>;SELECT;SYSIBM.SYSCOLUMNS, DRIVER=4.21.29
- at com.ibm.db2.jcc.am.kd.a(kd.java:810)
- at com.ibm.db2.jcc.am.kd.a(kd.java:66)
- at com.ibm.db2.jcc.am.kd.a(kd.java:140)
- at com.ibm.db2.jcc.am.sp.c(sp.java:2796)
- at com.ibm.db2.jcc.am.sp.d(sp.java:2784)
- at com.ibm.db2.jcc.am.sp.a(sp.java:2212)
- at com.ibm.db2.jcc.am.tp.a(tp.java:7997)
- at com.ibm.db2.jcc.am.sp.a(sp.java:2188)
- at com.ibm.db2.jcc.t4.bb.i(bb.java:143)
- at com.ibm.db2.jcc.t4.bb.b(bb.java:41)
- at com.ibm.db2.jcc.t4.p.a(p.java:32)
- at com.ibm.db2.jcc.t4.vb.i(vb.java:145)
- at com.ibm.db2.jcc.am.sp.kb(sp.java:2181)
- at com.ibm.db2.jcc.am.tp.yc(tp.java:3698)
- at com.ibm.db2.jcc.am.tp.a(tp.java:4578)
- at com.ibm.db2.jcc.am.tp.b(tp.java:4173)
- at com.ibm.db2.jcc.am.tp.lc(tp.java:770)
- at com.ibm.db2.jcc.am.tp.executeQuery(tp.java:735)
- at com.sap.hana.dp.db2mainframeltladapter.MetadataQuerier.getTableMetadata(MetadataQuerier.java:656)
- at com.sap.hana.dp.db2mainframeltladapter.DB2LTLAdapter.importMetadata(DB2LTLAdapter.java:2441)
- at com.sap.hana.dp.adapter.sdk.decorator.AdapterCDCDelegate.importMetadata(AdapterCDCDelegate.java:133)
- at com.sap.hana.dp.adapter.framework.core.WorkerThread.processImportMetadata(WorkerThread.java:1750)
- at com.sap.hana.dp.adapter.framework.core.WorkerThread.processRequest(WorkerThread.java:273)
- at com.sap.hana.dp.adapter.framework.core.WorkerThread.run(WorkerThread.java:2072)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:836)
- Failed to query CCSID and FOREIGNKEY from system table SYSIBM.SYSCOLUMNS for tbcreator [<owner>] and tbname [<table name>] and column name [<column name>].
- Context: DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501, SQLERRMC=[<user>];SELECT;SYSIBM.SYSCOLUMNS, DRIVER=4.21.29
- at com.sap.hana.dp.db2mainframeltladapter.MetadataQuerier.getTableMetadata(MetadataQuerier.java:677)
- at com.sap.hana.dp.db2mainframeltladapter.DB2LTLAdapter.importMetadata(DB2LTLAdapter.java:2441)
- at com.sap.hana.dp.adapter.sdk.decorator.AdapterCDCDelegate.importMetadata(AdapterCDCDelegate.java:133)
- at com.sap.hana.dp.adapter.framework.core.WorkerThread.processImportMetadata(WorkerThread.java:1750)
- at com.sap.hana.dp.adapter.framework.core.WorkerThread.processRequest(WorkerThread.java:273)
- at com.sap.hana.dp.adapter.framework.core.WorkerThread.run(WorkerThread.java:2072)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
- at java.lang.Thread.run(Thread.java:836)
- Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501, SQLERRMC=<User>;SELECT;SYSIBM.SYSCOLUMNS, DRIVER=4.21.29
- at com.ibm.db2.jcc.am.kd.a(kd.java:810)
- at com.ibm.db2.jcc.am.kd.a(kd.java:66)
- at com.ibm.db2.jcc.am.kd.a(kd.java:140)
- at com.ibm.db2.jcc.am.sp.c(sp.java:2796)
- at com.ibm.db2.jcc.am.sp.d(sp.java:2784)
- at com.ibm.db2.jcc.am.sp.a(sp.java:2212)
- at com.ibm.db2.jcc.am.tp.a(tp.java:7997)
- at com.ibm.db2.jcc.am.sp.a(sp.java:2188)
- at com.ibm.db2.jcc.t4.bb.i(bb.java:143)
- at com.ibm.db2.jcc.t4.bb.b(bb.java:41)
- at com.ibm.db2.jcc.t4.p.a(p.java:32)
- at com.ibm.db2.jcc.t4.vb.i(vb.java:145)
- at com.ibm.db2.jcc.am.sp.kb(sp.java:2181)
- at com.ibm.db2.jcc.am.tp.yc(tp.java:3698)
- at com.ibm.db2.jcc.am.tp.a(tp.java:4578)
- at com.ibm.db2.jcc.am.tp.b(tp.java:4173)
- at com.ibm.db2.jcc.am.tp.lc(tp.java:770)
- at com.ibm.db2.jcc.am.tp.executeQuery(tp.java:735)
- at com.sap.hana.dp.db2mainframeltladapter.MetadataQuerier.getTableMetadata(MetadataQuerier.java:656)
Read more...
Environment
- SAP HANA Smart Data Integration
- SDI DB2 Mainframe ADAPTER 2.6 and higher
- REP AGENT SDI DB2 MAIN ADAPTER 2.6.2 and Higher
Product
SAP HANA smart data integration 2.0
Keywords
DB2LTLAdapter, -551, "DB2 LTL Mainframe Adapter", SYSIBM, SYSCOLUMNS , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.