PDA

View Full Version : Error retrieving a published P&ID



gmanca
01-13-2011, 04:05 AM
Hello,
I'm trying to retrieve a published P&ID on a satellite, but I keep getting an error: the log file shows this information:

==============================
Application Name: SmartPlantPID
Active Document: Recovery, WorkShare And Projects/AsBuilt Driver
11/01/2011 - 09:54:01
==============================
Error in SPDataPile::ISPBufferedData_Flush ORA-02091: transaction rolled back
ORA-02290: check constraint (P738455PID.NOTE_ITEMNOTE_NOTNULL) violated
- described as: SPDataPile::ISPBufferedData_Flush ORA-02091: transaction rolled back
ORA-02290: check constraint (P738455PID.NOTE_ITEMNOTE_NOTNULL) violated
, Error Number is: -2147221504
Error in SPDataPile::ISPBufferedData_Flush SPDataPile::ISPBufferedData_Flush ORA-02091: transaction rolled back
ORA-02290: check constraint (P738455PID.NOTE_ITEMNOTE_NOTNULL) violated
- described as: SPDataPile::ISPBufferedData_Flush ORA-02091: transaction rolled back
ORA-02290: check constraint (P738455PID.NOTE_ITEMNOTE_NOTNULL) violated
, Error Number is: -2147221504
Error in SPDataPile::ISPDataPile_CommitTransSPDataPile::ISP BufferedData_Flush ORA-02091: transaction rolled back
ORA-02290: check constraint (P738455PID.NOTE_ITEMNOTE_NOTNULL) violated
- described as: SPDataPile::ISPBufferedData_Flush ORA-02091: transaction rolled back
ORA-02290: check constraint (P738455PID.NOTE_ITEMNOTE_NOTNULL) violated
, Error Number is: -2147221504
Error in SmartPlantPID - described as: ::ISPDrawing_WSGetLatest()

How can I solve the problem?

Thanks in advance,
Giuseppe

smartman
01-14-2011, 12:33 AM
Ask Host admin take ownership back for that drawing, run DB cleanup , DB constraint report. Take required actions.
Then publish again.