Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to deserialize an object

Highlighted
Jitka Urbanikov
Regular Collector

Unable to deserialize an object

Hi all,

we are on SD4.5 sp9. After deleting an change with WO related, error message in server log appears

St, 23/08/2006 08:09:12 JDBC error 2292: ORA-02292: narušené referenčné obmedzenie (SERVICEDESK.WOR_CHA_OID_FK) - nenašiel sa kľúč potomka
, SQL state: 23000 for query: DELETE itsm_changesWHERE ((((cha_oid = 281519337766913)AND (cha_lockseq = 1))))St, 23/08/2006 08:09:12 Unexpected EOF.St, 23/08/2006 08:09:12 Unable to deserialize an object (com.hp.ifc.rep.AppException).null

Thank in advance for any help

Jitka
3 REPLIES
Jitka Urbanikov
Regular Collector

Re: Unable to deserialize an object

Sorry for special characters...

St, 23/08/2006 08:09:12 JDBC error 2292: ORA-02292: narusene referencne obmedzenie (SERVICEDESK.WOR_CHA_OID_FK) - nenasiel sa kluc potomka
(integrity constraint violated - child record found)

, SQL state: 23000 for query: DELETE itsm_changesWHERE ((((cha_oid = 281519337766913)AND (cha_lockseq = 1))))St, 23/08/2006 08:09:12 Unexpected EOF.St, 23/08/2006 08:09:12 Unable to deserialize an object (com.hp.ifc.rep.AppException).null

Jitka
Jitka Urbanikov
Regular Collector

Re: Unable to deserialize an object

More info:
The changes were created using template with WO related and "Wait for WO completion" checked. Time dependency is On
The explanation for error from Oracle site is:
ORA-02292: integrity constraint (string.string) violated - child record found
Cause: attempted to delete a parent key value that had a foreign key dependency.
Action: delete dependencies first then parent or disable constraint.

I have tried to delete WOs first, error still appeares in server log.
Any idea, what else to try?

Maybe...
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=1016186

Jitka
Jitka Urbanikov
Regular Collector

Re: Unable to deserialize an object

The "Unable to deserialize an object" message in log appears, when trying to delete an item with another item related to it. In our case it was change with related work order.
First we had to unrelate workorder, save change and after that we were able to delete change without error in server log.
//Add this to "OnDomLoad" event