SQLSTATE=42601 ,SQLCODE=-104 while running HCAT_SYNC_OBJECTS procedure in IBM Db2 BigSQL

Troubleshooting

Problem

While running HCAT_SYNC_OBJECTS procedure in BigSQL it fails with following ERROR code

SQLSTATE=42601 ,SQLCODE=-104

Symptom

The following stack trace and ERROR message is observed in bigsql.log file

com.ibm.db2.jcc.am.SqlSyntaxErrorException: An unexpected token "name" was found following "emp.name as Employee". Expected tokens may include: "<space>".. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.22.29
        at com.ibm.db2.jcc.am.ld.a(ld.java:810)
        at com.ibm.db2.jcc.am.ld.a(ld.java:66)
        at com.ibm.db2.jcc.am.ld.a(ld.java:140)
        at com.ibm.db2.jcc.am.up.c(up.java:2796)
        at com.ibm.db2.jcc.am.up.d(up.java:2784)
        at com.ibm.db2.jcc.am.up.b(up.java:2146)
        at com.ibm.db2.jcc.t4.bb.j(bb.java:233)
        at com.ibm.db2.jcc.t4.bb.c(bb.java:48)
        at com.ibm.db2.jcc.t4.p.b(p.java:38)
        at com.ibm.db2.jcc.t4.vb.h(vb.java:124)
        at com.ibm.db2.jcc.am.up.kb(up.java:2141)
        at com.ibm.db2.jcc.am.up.a(up.java:3336)
        at com.ibm.db2.jcc.am.up.c(up.java:768)
        at com.ibm.db2.jcc.am.up.executeUpdate(up.java:747)
        at com.ibm.biginsights.biga.udf.HCAT_SYNC_OBJECTS.synchronizeObject(HCAT_SYNC_OBJECTS.java:1782)
        at com.ibm.biginsights.biga.udf.HCAT_SYNC_OBJECTS.synchronizeTable(HCAT_SYNC_OBJECTS.java:648)
        at com.ibm.biginsights.biga.udf.HCAT_SYNC_OBJECTS.syncTables(HCAT_SYNC_OBJECTS.java:564)
        at com.ibm.biginsights.biga.udf.HCAT_SYNC_OBJECTS.exec(HCAT_SYNC_OBJECTS.java:314)

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCRJT","label":"IBM Db2 Big SQL"},"Component":"","Platform":[{"code":"PF016","label":"Linux"}],"Version":"5.0.x","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

To view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use the link to actual document below to access the full document. You will be asked to log on if you are not already logged in. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

link to actual document

Was this topic helpful?

Document Information

More support for:
IBM Db2 Big SQL

Software version:
5.0.x

Operating system(s):
Linux

Document number:
744661

Modified date:
08 April 2021

UID

ibm10744661

IBM Support

Tips