When Trying To Change The Field "Inherit from Program" Using the value "CONSULTINGDIV" On Asset Integration Rules - Getting Error - SQL Error In PC_AM_RULE_SBR.PC_AM_CAP_SW.SaveEdit CLI0109E String Data Right Truncation. (Doc ID 2227705.1)

Last updated on JANUARY 30, 2017

Applies to:

Symptoms

On : 9.2 version, Functionality

In DB2 environment, when trying to modify the the "Inherit from Program" field in Asset Integration Rules on a project, the following error occurs

ERROR
-----------------------
COM Stmt=SELECT B.PROJECT_ID FROM PS_PC_AM_PROJ_DEFN A, PS_PC_AM_PROJ_DEFN B, PS_PC_AM_RULE_PRJ C, PS_PROJECT D WHERE A.PROJECT_ID = :1 AND B.PROJECT_ID <> :2 AND A.BUSINESS_UNIT_AM = B.BUSINESS_UNIT_AM AND A.ASSET_ID = B.ASSET_ID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.PROJECT_ID = C.PROJECT_ID AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.PROJECT_ID = D.PROJECT_ID AND D.MANAGED_BY_WO <> :3 AND C.PC_AM_CAP_SW = 'Y' AND (C.PROJECT_ID_2 <> :4 OR :5 = ' ') AND :6 = 'Y'
PSAPPSRV.3972 (136) 1-991 16.05.57 0.024000 Cur#1.3972.E920G4KU RC=0 Dur=0.000000 Bind-1 type=2 length=2 value=VJ
PSAPPSRV.3972 (136) 1-992 16.05.57 0.000000 Cur#1.3972.E920G4KU RC=0 Dur=0.000000 Bind-2 type=2 length=2 value=VJ
PSAPPSRV.3972 (136) 1-993 16.05.57 0.000000 Cur#1.3972.E920G4KU RC=0 Dur=0.000000 Bind-3 type=2 length=1 value=X
PSAPPSRV.3972 (136) 1-994 16.05.57 0.000000 Cur#1.3972.E920G4KU RC=0 Dur=0.000000 Bind-4 type=2 length=13 value=CONSULTINGDIV
PSAPPSRV.3972 (136) 1-995 16.05.57 0.000000 Cur#1.3972.E920G4KU RC=0 Dur=0.000000 Bind-5 type=2 length=13 value=CONSULTINGDIV
PSAPPSRV.3972 (136) 1-996 16.05.57 0.000000 Cur#1.3972.E920G4KU RC=0 Dur=0.000000 Bind-6 type=2 length=1 value=Y
PSAPPSRV.3972 (136) 1-997 16.05.57 0.003000 SQL error. Function: SQLExec

  Error Position: 0

  Return: 8601 - [IBM][CLI Driver] CLI0109E String data right truncation. SQLSTATE=22001 (SQLSTATE 22001) -99999

  Statement: SELECT B.PROJECT_ID FROM PS_PC_AM_PROJ_DEFN A, PS_PC_AM_PROJ_DEFN B, PS_PC_AM_RULE_PRJ C, PS_PROJECT D WHERE A.PROJECT_ID = :1 AND B.PROJECT_ID <> :2 AND A.BUSINESS_UNIT_AM = B.BUSINESS_UNIT_AM AND A.ASSET_ID = B.ASSET_ID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.PROJECT_ID = C.PROJECT_ID AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.PROJECT_ID = D.PROJECT_ID AND D.MANAGED_BY_WO <> :3 AND C.PC_AM_CAP_SW = 'Y' AND (C.PROJECT_ID_2 <> :4 OR :5 = ' ') AND :6 = 'Y'

  Original Statement: SELECT B.PROJECT_ID FROM PS_PC_AM_PROJ_DEFN A, PS_PC_AM_PROJ_DEFN B, PS_PC_AM_RULE_PRJ C, PS_PROJECT D WHERE A.PROJECT_ID = :1 AND B.PROJECT_ID <> :1 AND A.BUSINESS_UNIT_AM = B.BUSINESS_UNIT_AM AND A.ASSET_ID = B.ASSET_ID AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.PROJECT_ID = C.PROJECT_ID AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.PROJECT_ID = D.PROJECT_ID AND D.MANAGED_BY_WO <> :2 AND C.PC_AM_CAP_SW = 'Y' AND (C.PROJECT_ID_2 <> :3 OR :3 = ' ') AND :4 = 'Y'
PSAPPSRV.3972 (136) 1-998 16.05.57 0.000000 ErrorReturn-> 280 - SQL error in Exec. (2,280) PC_AM_RULE_SBR.PC_AM_CAP_SW.SaveEdit PCPC:2367 Statement:27

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Main Menu > Project Costing > Project Defintion > General Information.
2. Add a new project and save
3. Click on Asset Integration Rules tab and try to populate the field "Inherit from Program" using the value "CONSULTINGDIV"

The above error is returned.

Cause