Skip to Content

Checkin - S1000 (SQLSTATE [Oracle][ODBC][Ora]ORA-01407

Is anyone else seeing the below message when checking in an EAM in version 16.6. SP03? The workaround was/is to check the Model in as a baseline version, however this is pretty fundamental and the concern is this will "break" something later during an update. This is quite consistent and occurs every time a check-in is performed for this Model.

S1000 (SQLSTATE [Oracle][ODBC][Ora]ORA-01407: cannot update ("USER_DB_OWNER"."PMXRSH"."TRGT") to NULL
)
Query: update PMXRSH set TRGT=(select T.NUM2 from PMTMP2 T where T.SESS=172893476 and T.NUM1=PMXRSH.SRCE) where RTYP=2 and SRCE in (285515 , 285516 , 285517)S1000 (SQLSTATE [Oracle][ODBC][Ora]ORA-01407: cannot update ("USER_DB_OWNER"."PMXRSH"."TRGT") to NULL
)
Query: update PMXRSH set TRGT=(select T.NUM2 from PMTMP2 T where T.SESS=172893476 and T.NUM1=PMXRSH.SRCE) where RTYP=2 and SRCE in (285515 , 285516 , 285517)
Unexpected error while updating the repository document.
The check in of the document has been cancelled.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 22 at 08:26 PM

    If you use v16.6, try the following:

    1. Right-click the model in the repository, and select Check Out to check the previous version out into the local workspace.
    2. Select the model in the local workspace and click File > Save as New Model.
    3. Select an appropriate folder and filename and click Save to create the duplicate model.
    4. Right-click the duplicate model and select Check In to check the model into.
    Add comment
    10|10000 characters needed characters exceeded