GP Publisher connection fails with [22001] SQL call failed error

GP Publisher connection fails with [22001] SQL call failed error

book

Article ID: KB0078169

calendar_today

Updated On:

Products Versions
TIBCO Scribe Insight 7.9.1, 4.4.1

Description

Issue:  The password for the SQL user was changed, and now I am unable to reconnect the GP Adapter Publisher.  The Global Connections for the GP adapter were updated successfully in the Workbench with the new credentials, but I’m receiving the following error when attempting to reconnect the GP Adapter Publisher:

Error:  GP Publisher - Error processing messages: Initializing Adp ConnectionServerName = 'xxxx', DbName = 'xxxx' UserName = 'sa' Password = '********' ConnectParams = "AccessLib = 'adpSQLServerLib' AdapterDbID = 'OpenAdapter.Datbase' Flags = '8' Error: System.Runt
[22001] SQL call failed. String or binary data would be truncated. The statement has been terminated.

Resolution:   The password value for the GP Publisher connection in the SCRIBEINTERNAL.BRIDGES table was corrupt.  Replace the password value with "" and reconnect the GP Publisher.

  Steps to resolve:
  1. In SQL Management Studio, EDIT the BRIDGES table.
  2. Select the record for the GP Publisher.
  3. Copy the SETTINGS field value to Notepad.
  4. Find the Connection password value and replace with “”.
  5. Paste the updated text back into the SETTINGS field in the BRIDGES table.
  6. Restart the Scribe Services.
  7. In the Scribe Console, select the GP Publisher and reconnect.
kA20e000000Cjr4CAC_en_US_1_0

kA20e000000Cjr4CAC_en_US_1_1

Issue/Introduction

The GP Adapter Publisher connection fails with the following message: [22001] SQL call failed. String or binary data would be truncated. The statement has been terminated.

Environment

TIBCO Scribe Insight
Powered by Wolken Software