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.