I receive this message in the event log on my aos box four times every 10 minutes (approx).
Object Server 03: The database reported (session 18 (Admin)): [Microsoft][SQL Server Native Client 10.0][SQL Server]String or binary data would be truncated.. The SQL statement was: "UPDATE T1 SET NAME=T3.NAME,RECVERSION=? FROM tempdb."DBO".t12143_3BB1D74518EC4A90B85299D5A8FF49E4 T1 CROSS JOIN CUSTTABLE T2 CROSS JOIN DIRPARTYTABLE T3 WHERE (T1.PARTITION=?) AND (((T2.PARTITION=?) AND (T2.DATAAREAID=?)) AND (T1.ACCOUNTNUM=T2.ACCOUNTNUM)) AND ((T3.PARTITION=?) AND (T2.PARTY=T3.RECID))"
The session number and the table change each time [dbo.t12143_xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx].
There are approx 1500 dbo.t12143_xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx tables in the tempdb, each one is empty.
Any idea
1) what process triggers the error.
2) resolution. (i believe that the error is in relation to field length being written to, but this doesnt help as I suspect that these tables are being created).
How do I diagnose this error effectively?
Many thanks
(R2 CU7)
*This post is locked for comments