Loading DB2 initial data error: U00003592 UCUDB - Status: '42601' NativeError: '-104' Msg: ' SQL0104N, SQLSTATE=42601
Article ID: 87875
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:
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: '', '', '', ''
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
Environment
Release: AUTWAB99000-11.0-Automic Workload Automation-Base Edition
Component:
Component:
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.
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
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.
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.
Feedback
Yes
No
Powered by
