web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / Dynamics AX Bits and Bytes From Syed / TempDB insert issue in Dyna...

TempDB insert issue in Dynamics AX 2012 R3

Views (0)
Community Member Profile Picture Community Member
I recently had an experience of an unknown issue while creating estimate for a Project in Project management and accounting module. The error displayed was


Initially, I was expecting it to be an issue with TempDB. I was in an impression that tempDB table is not refreshed or it can be linked with known issues as mentioned here

http://blogs.msdn.com/b/axinthefield/archive/2014/02/27/errors-in-aos-event-log-after-sql-server-cluster-failover-or-alwayson-availability-groups-failover.aspx

However, When I started to debug the code There is a statement which doing bulk inserts from ProjItemTrans to tmpProjControlActual table. While copying text field from ProjItemTransto tmpProjControlActual, it throws error if you have specified more than 60 characters.

Table
Field
Length
ProjItemTrans
Txt
1000 (EDT: ItemFreeTxt)
tmpProjControlActual
Txt
60 (EDT: TransTxt)

That is why if you try to copy more than 60 characters into a 60 character field, AX will throw error.


















I found it is a bug in AX 2012 R3 because txt field should have same length.
In order to fix the issue, I had to manually update tmpProjControlActual.txt field to 1000 characters.
Remember to restart SQL service and then AOS service as TempDB won’t refresh until you restart SQL service.

Happy DAXing

This was originally posted here.

Comments

*This post is locked for comments