Service Desk Practitioners Forum
cancel

JDBC error 547

Highlighted
Vasily Kamenev
Acclaimed Contributor.

JDBC error 547

Hi.
We use SD4.5+ sp13.
I have every time the error:
JDBC error 547: [SQL]DELETE statement
conflicted with COLUMN REFERENCE constraint 'WOR_SER_OID_FK'. The conflict occu
rred in database 'orgiginal_sdDB', table 'ITSM_WORKORDERS', column 'WOR_SER_OID'
., SQL state: 23000 for query: DELETE itsm_servicecalls
WHERE ((((ser_oid = 281478235816406)
AND (ser_lockseq = 7))))

when try delete WO(s) from CH.
The same proble come if I try delete releted WO(s) from SC . Caches from Server and client cleared - not help. Install a one new DB with demo - result the same. Is anybody has the same problem and solutions?
Thx,
Vasily
2 REPLIES
Mike Bush
Acclaimed Contributor.

Re: JDBC error 547

Vasily - the error you have given us shows a SERVICE CALL being deleted when it has a WORKORDER attached? Not quite what you describe?
Vasily Kamenev
Acclaimed Contributor.

Re: JDBC error 547

Hi
Error come when try delete any SC orc CH with related WO(s).

Vasily