SQLCODE=-104 SQLSTATE=42601, SQLERRMC END-OF-STATEMENT INTO . CONCAT || / MICROSECONDS MICROSECOND (Errors & Solutions #24)

Error

My Case: I got this error while using IBM JDBC Adapter create operation

"SQLCODE=-104" SQLSTATE=42601, SQLERRMC END-OF-STATEMENT INTO . CONCAT || / MICROSECONDS MICROSECOND"

Solution

I found that it is due to invalid "UID" value (auto increment option for the PK field) in the Adapter business object's ASI

Specifying a valid sequence name or "AUTO" for the UID attribute solved this error for me


note: I feel what you feel ... the error has nothing to do with the root cause i know

Tweet