Can you post the XML you are using to do the delete XREF.
This issue is usually caused because the PKEY was a concatenation of four columns and the final value was not available in any PKEY value. Provide the correct PKEY value in the request, taking care of spaces.
Can you check :
a. Whether this pkey = ABCD|001050000|112AAC|ZZZZ value even exist in the XREF table.
b. If this is a timeline enabled BO, then there are huge chances of multiple xref with same pkey.
c. Or better you can try passing rowid xref as well in the request.
Try to pass the below as the RecordKey in the XML
Sorry but I could not spot the difference between the xml which I had sent and the xml tags which you sent.
Am I missing anything ?
I just removed the null tags
Ok. Thanks. BUt it gives the same error.
I am just wondering why is the error caused when PKEY and source name is enough to identify a record in xref.
If I add the rowid along with the source key value, it deletes all the xref for that Rowid. Not able to solve the issue.
Just got it resolved by viewing the log fles in debug mode.
The select statement was using Interaction id value as null. Removed the interaction id tag, it worked.
Its always advisable to remove unused tags.
Thanks for your reply Prashant.
In my case, the interaction id was generating a non-null value which was getting added to the query. When I removed the interaction id tag from soap UI request, I was able to delete the xref record.