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

book

Article ID: 87875

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

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
 

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.