SAP Knowledge Base Article - Preview

3230012 - DB2 SQL Error: SQLCODE=-551 when attempting to create first subscription SDI

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=DNEWTH;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 version 2.05 and higher
  • SDI DB2 Mainframe ADAPTER 2.6 and higher
  • REP AGENT SDI DB2 MAIN ADAPTER 2.6.2 and higher

Keywords

DB2LTLAdapter, -551, "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.