How to resolve Dataldr.log SQL Error in SCCM 2012

Nicolas PilonHardware Inventory, SCCM4 Comments

0
(0)

Are you having inventory issue in SCCM where machines information from the hardware inventory were not updated on the site server? This problem can affect your various systems that use data, such as license management or reports. You can read more about the basics of client inventory and hardware inventory process.

This post explains how to resolve the message dataldr.log SQL Error in SCCM 2012. Log file dataldr.log on the site server manages inventory received from clients. If the log file inventoryagent.log on the client shows no evidence of failure and you have this error, your hardware inventory won’t be updated in the SQL database.

dataldr.log SQL Error In

The string or binary data would be truncated. : dINSTALLED_SOFTWARE_DATA

ERROR – SQL Error in

ERROR – is NOT retyrable

There’s no real explanation of this purpose, but it is a SQL issue for sure. Even with a full hardware inventory scan on the client, the data is not reset. We also tried to disable Asset Intelligence class to see if the SQL table will be deleted, but without success.

Solution

There’s a work around that resolve the problem is to delete the device in SCCM, that will flush data of this device in SQL database.

  • Open the directory Configuration Manager\Logs on the site server and open dataldr.log with CMTrace
  • Scroll down in the file and note each devices that have the issue
  • Open SCCM Console and navigate to Assets and Compliance / Devices 
  • Search for the machine name from your list, right click on the device and select Uninstall Client with the Right-Click Tools
  • Right click on the device and select Delete
  • Repeat for each devices.

At this point, use your favorite way to discover and install the client on all theses devices. Next time the machine will do an hardware inventory, site server will receive correctly the inventory and SCCM database will be updated.

 

dataldr.log SQL Error

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

4 Comments on “How to resolve Dataldr.log SQL Error in SCCM 2012”

  1. Hello Nicolas, Thanks for theses information. Do you have any solution when the computer is not on SCCM / AD ?
    I have this issue with messages like
    The record for machine XXX (GUID:XXX) was not found in the database. in statesys.log
    SQL MESSAGE: spAddInventoryLog – Inventory Log for machine:xxx,Message:could not validate machine. in Dataldr.log

    Thank you for your help.

Leave a Reply