TempDB insert issue in Dynamics AX 2012 R3

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 ProjItemTrans to 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