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

Document ID : KB000087875
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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.
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.