IBM Support

GTP failed: unable to update recordset

Troubleshooting


Problem

error when doing a GTP over an application with the underlying database having SQLServer replication set.

Symptom

The Go to Production Process Failed

The transactional phase of GTP has been rolled back. The application is still functional, but the DEVELOPMENT model has not been moved to
PRODUCTION.

Unable to update the recordset with SQL of: SELECT definition, definitiondt, appstateguid
FROM andrxplan_2008..applicationstate
WHERE appstateguid='{2FEC1034-D887-48B7-A96B-FF2972499EA6}'

The BLOB with 966813 characters was being written to field 'andrxplan_2008..applicationstate.definitiondt'.

Length of text, ntext, or image data (966813) to be replicated exceeds configured maximum 65536.Length of text, ntext, or image data (966813) to be replicated exceeds configured maximum 65536., Error number -2147217900 was raised by Microsoft OLE DB Provider for SQL Server. Native RDBMS error 7139Thestatement has been terminated.,Error number -2147217900 was raised by Microsoft OLE DB Provider for SQL Server. Native RDBMS error 3621

[{"Product":{"code":"SS9S5U","label":"Cognos 8 Planning"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":"Contributor","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSPN2D","label":"Cognos Planning"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Contributor","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

1035265

Document Information

Modified date:
09 May 2025

UID

swg21371100

Page Feedback