Wednesday, January 17, 2018

Cannot execute a data definition language command on

While posting a timesheet, one of my users received the following error:

Cannot execute a data definition language command on Source document line (SourceDocumentLineTmpJournalize). Reference table ID: 0, None.
The record already exists.

INSERT INTO tempdb."DBO".t101281_3FFE3B67AFC840C6A35FBD063AF9DA46 (ISFINAL,TYPEENUMNAME,TYPEENUMVALUE,STATUS,SOURCEDOCUMENTHEADER,PARENTSOURCEDOCUMENTLINE,SOURCERELATIONTYPE,EXCHANGERATEDATE,SOURCEDOCUMENTLINE,ACCOUNTINGDATE,RECVERSION,PARTITION) SELECT T1.ISFINAL,T1.TYPEENUMNAME,T1.TYPEENUMVALUE,T1.ACCOUNTINGSTATUS,T1.SOURCEDOCUMENTHEADER,T1.PARENTSOURCEDOCUMENTLINE,T1.SOURCERELATIONTYPE,T1.EXCHANGERATEDATE,T1.RECID,T2.ACCOUNTINGDATE,1,5637144576 FROM SOURCEDOCUMENTLINE T1 CROSS JOIN tempdb."DBO".t100010_A652A6A3D1EF4EE9A039F442E3BCEC58 T2 WHERE ((T1.PARTITION=5637144576) AND (T1.SOURCEDOCUMENTHEADER=5638078273)) AND ((T2.PARTITION=5637144576) AND (T2.SOURCEDOCUMENTLINE=T1.RECID))

Very interesting error.  Based on this blog post, it seems an AOS restart may fix the issue.  I will try it here shortly...

UPDATE:
AOS Restart did not fix the issue.... Continuing on...

UPDATE:
Not sure why, but creating a new time sheet did the trick.  Posted perfectly.

No comments:

Post a Comment