SAP Knowledge Base Article - Preview

3229984 - DB2 SQL Error: SQLCODE=-551 when attempting to create first remote subscription with SDI DB2LTLAdapter

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.