Issue:  After upgrading to Insight v7.9.2, I receive the following error message when opening an existing DTS file to resolve the connection:

Unhandled exception has occurred in a component in your application.  If you click Continue, the application will ignore this error and attempt to continue.
 [22001] String or binary data would be truncated. The statement has been terminated.
Error occurs after upgrading to TIBCO Scribe Insight 7.9.2 and attempting to resolve an existing connection.
    

Resolution:  With the introduction of Global Connections to Scribe Insight with version 7.9.0, two tables were added to the SCRIBEINTERNAL database to store connection information:

• DATAPROVIDERS
• DRSPROPERTIES

This error message occurs when the existing connection field value previously stored in the DTS file is larger than the associated field in the SCRIBEINTERNAL database table.

Follow these steps to resolve:

1. Backup the SCRIBEINTERNAL database.
2. Turn on Workbench tracing and reproduce the error.
3. Open the TWorkbench.log in Notepad and search for the error message

            [22001] String or binary data would be truncated

4. Find the INSERT statement prior to the error to identify the table and column affected  (for example, “INSERT into SCRIBE.DRSPROPERTIES values”)
5. In SQL Server Management Studio, open the SCRIBEINTERNAL database and view the Columns for the affected table.

              

6. Run a SQL query to modify the affected field size.  For example:

           ALTER TABLE SCRIBE.DATAPROVIDERS ALTER COLUMN NAME NVARCHAR(2048);
           ALTER TABLE SCRIBE.DRSPROPERTIES ALTER COLUMN VALUE NVARCHAR(2048);
 

Connection value stored in DTS prior to v7.9.0 is larger than the associated table field in the SCRIBEINTERNAL database. When updating the DTS and resolving the connection, error [22001] displays.

TIBCO Scribe Insight