English

Error: GSE0008E An unexpected SQL error ("SQL0818N A timestamp conflict occurred. SQLSTATE=51003 ")

Error Message

After installing DB2 UDB and ArcSDE for DB2, the following error is returned during any operation:

"GSE0008E An unexpected SQL error ("SQL0818N A timestamp conflict occurred. SQLSTATE=51003 ") has occurred. SQLSTATE=00000

Cause

The sdesrvsp.bnd file is out of sync with one of the stored procedures.

Solution or Workaround

Re-bind the sdesrvsp.bnd file.

  1. From Command Prompt:
    cd %SDEHOME%\lib
  2. db2 connect to sde as user sde using <sde password>
  3. db2 bind sdesrvsp.bnd blocking unambig isolation CS
  4. db2 disconnect sde