Article - CS258155

Oracle error "ORA-02292" occurring with B100 delete feed record/message caused partial data to be deleted in Servigistics Click Parts Planning

Modified: 19-Feb-2020   


Applies To

  • Servigistics Click Parts Planning 7.6.6

Description

  • B100 delete eXtensible Markup Language (xml) message run through Advanced Integration Module (AIM) message encountered Oracle integrity constraint error
  • B100 delete feed record processed through startfeed caused Oracle integrity constraint error
    • Oracle Error: ORA-02292: integrity constraint (xxx.FK_ORDERBOOK_PART) violated - child record found
      Cannot delete Part xxx it is referenced by Optimization records
      Failed to delete PART(xxx).​
    • Partial part data left in database
This is a printer-friendly version of Article 258155 and may be out of date. For the latest version click CS258155