Updating a record when action name has long double byte characters results in SQL error

Troubleshooting

Problem

Attempts to execute an action whose name is a long double byte characters results in the error ' SQL statement = "insert into history ...." ' when updating a record in the IBM Rational ClearQuest.

Symptom

Open a schema in Rational ClearQuest Designer.
Create a new action with over 15 double byte character long in a record type.
Test or Upgrade the schema in a vendor database (IBM DB2, Oracle or Microsoft SQL server).
Log on the associated user dabase in ClearQuest Client.
Open a record and execute the new action.
See one of following errors and not able to proceed the action.

For Microsoft SQL server:

SQL statement = "insert into history ...."
  [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. 
  [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.

For Oracle server:

ERROR! SQLExecDirect RETCODE=-1, State=S1000, Native Error=12899 SQL statement="insert into history (dbid.entity, dbid.entitydef_id, entityde_name, user_name, action_timesstamp.old_state, new_state.comments) values (33554505, 33554435,16777224,'Defect','admin',' << ACTION_NAME >> ', {ts '2009-03-05 21:59:02'}, 'Submitted','Submitted', 'AP1 +09:00')"                                                          
  [DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-12899: value too large for column "CQJAUSER"."HISTORY","ACTION_NAME" (actual:50, Maximum:30)

An error occurs for IBM DB2 server, but you might see a different error message.

[{"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Designer - States and Actions","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.0.0.1;7.0.0.2;7.0.0.3;7.0.0.4;7.0.0.5;7.0.0.6;7.0.0.7;7.0.0.8;7.0.0.9;7.0.1;7.0.1.1;7.0.1.10;7.0.1.11;7.0.1.12;7.0.1.2;7.0.1.3;7.0.1.4;7.0.1.5;7.0.1.6;7.0.1.7;7.0.1.8;7.0.1.9;7.1;7.1.0.1;7.1.0.2;7.1.1;7.1.1.1;7.1.1.2;7.1.1.3;7.1.1.4;7.1.1.5;7.1.1.6;7.1.1.7;7.1.1.8;7.1.2;7.1.2.1;7.1.2.2;7.1.2.3;7.1.2.4;7.1.2.5","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

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 the link to actual document below to access the full document. You will be asked to log on if you are not already logged in. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

link to actual document

Was this topic helpful?

Document Information

More support for:
Rational ClearQuest

Software version:
7.0.0.1, 7.0.0.2, 7.0.0.3, 7.0.0.4, 7.0.0.5, 7.0.0.6, 7.0.0.7, 7.0.0.8, 7.0.0.9, 7.0.1, 7.0.1.1, 7.0.1.10, 7.0.1.11, 7.0.1.12, 7.0.1.2, 7.0.1.3, 7.0.1.4, 7.0.1.5, 7.0.1.6, 7.0.1.7, 7.0.1.8, 7.0.1.9, 7.1, 7.1.0.1, 7.1.0.2, 7.1.1, 7.1.1.1, 7.1.1.2, 7.1.1.3, 7.1.1.4, 7.1.1.5, 7.1.1.6, 7.1.1.7, 7.1.1.8, 7.1.2, 7.1.2.1, 7.1.2.2, 7.1.2.3, 7.1.2.4, 7.1.2.5

Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows

Document number:
352189

Modified date:
29 September 2018

UID

swg21273006

IBM Support

Tips