IBM Support

Build Forge error: CLI0109E String data right truncation. SQLSTATE=22001

Troubleshooting


Problem

In IBM Rational Build Forge, adapter steps with Kanji and Windows chcp 932 get this error: CLI0109E  String data right truncation. SQLSTATE=22001

Symptom

Details:
The operating system is Microsoft Windows 2000 service pack 3 - Japanese
Windows charste - 932 - does not reproduce on 437, only on 932
IBM DB2 backend
db2set DB2CODEPAGE=1208
User attached project with appropriate Kanji characters.
The environment has Japanese Kanji in the names and values.
The step name is Japanese Kanji instead of alphabet.
The project calls an adapter.

The following error appears on the foreground:
DBD::DB2::st execute failed: [IBM][CLI Driver] CLI0109E  String data right truncation. SQLSTATE=22001 at /PerlApp/BuildForge/DB/Handle.pm line 309, <$sock> line 313.
24/03/2010 5:33:30 PM Database: 14352: CRRBFEEEEE: DBD::DB2::st execute failed: [IBM][CLI Driver] CLI0109E  String data right truncation. SQLSTATE=22001 at /PerlApp/BuildForge/DB/Handle.pm line 309, <$sock> line 313.

24/03/2010 5:33:33 PM Database: 14352: CRRBF0551I: StackTrace from Process id [14352] called from [
  BuildForge::DB::db2(./PerlApp/BuildForge/DB/db2.pm:65)
  BuildForge::Store(./PerlApp/BuildForge/Store.pm:117)
  BuildForge::Project::StepCommand(./PerlApp/BuildForge/Project/StepCommand.pm:315)
  BuildForge::Project::StepCommand(./PerlApp/BuildForge/Project/StepCommand.pm:278)
  BuildForge::Project::StepCommand::Streamer(./PerlApp/BuildForge/Project/StepCommand/Streamer.pm:56)
  BuildForge::Project::StepCommand(./PerlApp/BuildForge/Project/StepCommand.pm:136)
  BuildForge::Build::Activity(./PerlApp/BuildForge/Build/Activity.pm:146)
]
24/03/2010 5:33:33 PM Database: 14352: CRRBF0556I: Trying to call [execute] on a non-existant database handle

[{"Product":{"code":"SSB2MV","label":"Rational Build Forge"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Engine: Adaptors","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.1.1.3","Edition":"Enterprise;Standard","Line of Business":{"code":"LOB77","label":"Automation 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.

Document Information

More support for:
Rational Build Forge

Software version:
7.1.1.3

Operating system(s):
Windows

Document number:
403739

Modified date:
20 April 2020

UID

swg21426206

Manage My Notification Subscriptions