ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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


Article ID: 87875


Updated On:


CA Automic Workload Automation - Automation Engine


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: '', '', '', ''



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.


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


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.