Powered By

Skin Design:
Free Blogger Skins

Powered by Blogger

Cari Blog Ini

02 Agustus 2023

Dynamics AX 2012 Workflow Stopped error: The SQL database has issued an error.

 Terjadi error workflow dengan tampilan seperti ini:

Stopped (error): session 113 (Sync) UPDATE T1 SET ACCOUNTINGEVENT=5638165117,RECVERSION=786788108 FROM ACCOUNTINGDISTRIBUTION T1 WITH (INDEX(I_7452SOURCEDOCUMENTHEADERIDX)) CROSS JOIN SOURCEDOCUMENTLINE T2 WHERE (((T1.PARTITION=5637144576) AND (T1.ACCOUNTINGEVENT=0) AND (T1.ACCOUNTINGDATE={ d''})) AND (T1.SOURCEDOCUMENTHEADER=5638834650)) AND ((T2.RECID=T1.SOURCEDOCUMENTLINE) AND (T2.ACCOUNTINGSTATUS=4 OR T2.ACCOUNTINGSTATUS=6)) AND (T2.PARTITION=5637144576) [Microsoft][SQL Server Native Client 10.0][SQL Server]Conversion failed when converting date and/or 
time from character string. Object Server 01:  Cannot execute the required database operation.
The SQL database has issued an error.

Penyebabnya adalah tidak disetnya AccountingDate pada tabel PurchReqTable dan PurchReqLine. Kenapa terjadi seperti itu? Tidak tau. Karena secara default harusnya accounting date terisi dengan tanggal saat dibuat.

Solusinya:

Isi accounting date di kedua table tersebut dan pada tabel AccountingDistribution yang berhubungan. (Link melalui table SourceDocumentHeader dan SourceDocumentLine).


Referensi dan ide:

sql server - Dynamics AX 2012: Conversion failed when converting date and/or time from character string - Stack Overflow