Loading DB2 initial data error: U00003592 UCUDB - Status: '42601' NativeError: '-104' Msg: ' SQL0104N, SQLSTATE=42601

Article Id: 87875

Status: Published

Updated On: 03-05-2018 18:14

Legacy Id: 000008647

Products:

CA Automic Workload Automation - Automation Engine AUTOMIC WORKLOAD AUTOMATION

Issue/Introduction:

Error Message :
U00003592 UCUDB - Status: '42601' Native error: '-104' Msg: ' SQL0104N An unexpected token ")" was found following "INSERT INTO OFS (". Expected tokens may include: "". SQLSTATE=42601'

Error when loading initial data on a new DB2 in all V11 versions:

20160126/161004.961 - U00029108 UCUDB: SQL_FEHLER Database-Handles DB-HENV: 1 DB-HDBC: 1
20160126/161004.961 - U00003591 UCUDB - DB-Fehler-Info: Opc: 'SQLExecDirect' Rückgabewert: 'ERROR'
20160126/161004.961 - U00003592 UCUDB - Status: '42601' NativeError: '-104' Msg: ' SQL0104N Auf "INSERT INTO OFS (" folgte das unerwartete Token ")". Mögliche Tokens: "<space>". SQLSTATE=42601
'
20160126/161004.961 - U00003594 UCUDB-Ret: '3590' Opcode: 'INSR' SQL-Stmnt: 'INSERT INTO OFS () VALUES ()'
20160126/161004.992 - U00003590 UCUDB - DB-Fehler: 'SQLExecDirect', 'ERROR ', '42601', ' SQL0104N Auf "INSERT INTO OFS (" folgte das unerwartete Token ")". Mögliche Tokens: "<space>". SQLSTATE=42601'
20160126/161016.225 - U00003590 UCUDB - DB-Fehler: '', '', '', ''

Reference

AE 12.0 Documentation
Administration Guide > Administering the Automation Engine > Configuration > AE DB Load

Cause:

Cause type: Defect
Root Cause: DBLoad uses the whole UID string for this selection (because of 'O' on the 6. position). UID has the form: \.Default DB2 schema name is equal to for this Domain User. That is why DBLoad does not find any columns in created tables.

Environment:

Release: AUTWAB99000-11.0-Automic Workload Automation-Base Edition
Component:

Resolution:

Fix Status: Released

Fix Version(s):
Automation Engine 11.2.2 - Available
Automation Engine 11.1.3 - Available

Additional Information:

Workaround :
Only for DB2: In the connection string (ODBCVAR) of AE Utilities use "N" at the 6. position, when the UID for database access is a domain user.The documentation has been updated accordingly.