The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
The community will be in read-only from Monday 11:59pm (PT) to Wednesday 7:30am (PT)
Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC error when saving a Change Having Workorders

Highlighted
Santosh Sharma_
Occasional Advisor

JDBC error when saving a Change Having Workorders

Hi Every One.

When I m trying to Save a CHANGE Having Multiple Workorders it is giving folloing Error.but when i click on the "OK" button on the Error Screen it is saving the Change as well as the Workorders.

Any Help to debug it.

Thanks
San


ERROR DETAILS
--------------------------

JDBC error 1: ORA-00001: unique constraint (SERVICEDESK.WOR_PK) violated
, SQL state: 23000 for query: INSERT INTO itsm_workorders
( wor_maximumduration
,wor_attachment_exists
,wor_requestor_per_oid
,slc_wor_per_oid
,wor_tem_oid
,wor_planduration
,wor_cha_oid
,wor_oid
,reg_created_by_oid
,reg_created
,wor_planfinish
,wor_deadline
,wor_planstart
,wor_sta_oid
,wor_cisupdated
,wor_cat_oid
,wor_description
,wor_id
,wor_cod_oid
,ass_wog_from_oid
,ass_assignstatus
,ass_per_from_oid
,ass_workgroup
,wor_lockseq
) VALUES ( ?
,0
,?
,?
,?
,?
,?
,?
,?
,TO_DATE(?,'YYYY/MM/DD HH24:MI:SS')
,TO_DATE(?,'YYYY/MM/DD HH24:MI:SS')
,TO_DATE(?,'YYYY/MM/DD HH24:MI:SS')
,TO_DATE(?,'YYYY/MM/DD HH24:MI:SS')
,?
,0
,?
,?
,?
,?
,?
,?
,?
,?
,?)
Values:
5.000009039351426
281591643717264
281591643717264
281597379741505
100.0
281620252656314
281620252656608
281614407303545
2006/2/13 15:31:23
2006/5/24 15:31:23
2006/2/18 15:31:23
2006/2/13 15:31:23
3095134438
281481043836945
Create new web environment
198201
633318698189791
281478803751389
3095986178
281591643717264
281478222577692
1
------------------------------------------
2 REPLIES
Santosh Sharma_
Occasional Advisor

Re: JDBC error when saving a Change Having Workorders

Hi ,

The Above error is occuring when i have 2 Workorders having Sucessor-Predecessor Relation for Saving the Sucessor Workorder.

Thanks
San
Ramaprasad N
Esteemed Contributor

Re: JDBC error when saving a Change Having Workorders

Sometimes, this error may be due to caching problems. Kindly clear your cache and try to save the Change/WO.

-Ram
//Add this to "OnDomLoad" event