Error 2147217833 in TestStand

Updated May 14, 2018

Reported In

Software

  • TestStand

Issue Details

I am trying to write to a database from TestStand but am encountering error 2147217833. Why is this error occurring and how can I fix it?

Solution

The description for error 2147217833 states that "String or binary data would be truncated". This indicates that the database schema is not set up correctly to handle a piece of incoming data. (e.g. a column in a table in the database is set to be CHAR(5) but a 6-letter string is being paced to it). To resolve this error, the schema for the database must be set up to correctly handle the incoming data. To narrow down the piece of data that is causing the issue, there are a few options outline below.

1. Enable On-the-fly logging so that the database will be updated as your sequence runs. This may make it easier to narrow down which piece of test data is causing the error to occur.
2. Set the TestStand configuration to ignore errors and add in a post-action to the step that writes to the database which displays the piece of data being written. This should allow you to see exactly which piece of data is causing the error.
3. Examine the difference between the format of the database schema and the piece of data to determine why the error occurred and change the database schema to allow the format of the data to be passed without error.

 

WAS THIS ARTICLE HELPFUL?

Not Helpful