Skip to Content
0

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

Jan 16 at 02:05 PM

30

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Phillip Lam
Jan 22 at 08:26 PM
0

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.
Share
10 |10000 characters needed characters left characters exceeded