SAP Knowledge Base Article - Preview

3631449 - Error: "SQLCODE=-552, SQLSTATE=42502" while trying to replicate from DB2 source system - SAP HANA Smart Data Integration

Symptom

  • DB2 SQL Error: SQLCODE=-552, SQLSTATE=42502, SQLERRMC=<DB2_USER_NAME>;CREATE TABLE, DRIVER=4.33.32
  • Failed to add the first subscription, error: com.sap.hana.dp.cdcadaptercommons.triggerbased.initializeitem.InitializeException: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-552, SQLSTATE=42502, SQLERRMC=<DB2_USER_NAME>;CREATE TABLE, DRIVER=4.33.32


Read more...

Environment

SAP HANA Smart Data Integration (SDI)

Keywords

DB2, SQLCODE=-552, SQLSTATE=42502, create table, SAP HANA, smart data integration, SDI, data replication, permissions, GRANT DBADM, remote source, subscription, error message, troubleshooting , 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.