IBM Support

PJ35283: STRING DATA RIGHT TRUNCATION ERROR AFTER MODIFYING STRING SIZE O F A DATA FIELD IN DB2 DATABASE.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • String data right truncation error after modifying string size
    of a data field in DB2 database.
    The data field (Doc_Source) was a String with a length of 4
    which was later changed to 6 characters using Process Config
    Console. This change was attempted on all the queues that had
    this data field and the changes were committed successfully.
    But later we found that the changes did not get affected in the
    database tables corresponding to these queues.
    THe work items also gets stuck in the ISI queue.
    The elogs reports the below error:
    ErrorMsg = [IBM][CLI Driver] CLI0109E  String data right
    truncation. SQLSTATE=22001
    VW (vwisi) (Region=1): ISI Exception processing work object
    number 28ACB084B52511DDA6D100145E473C0D : [Err=790afffe]
    Encountered DB2 error which was not from data source.
    

Local fix

  • The workaround is to figure out which table the string truncatio
    n is happening on.  There are a few ways to do that:
    1) If they remember which table they modified the string data fi
    eld on.
    2) look at the elog, see which F_Wobnums are getting the errors,
     check which table those wobnums are in.
    3) dump out all of the queue configs, dump out all of the table
    describe from DB2, compare the 2 to find the difference
    After you have found out which column does not match, in the PE
    config and the DB2 table, we will need to manually modify the da
    tabase table.
    This is done by issuing a SQL statement on that table:
    ALTER TABLE f_sw.<Table Name> ALTER COLUMN <Column Name> SET DAT
    A TYPE VARCHAR(<Size>)
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users using DB2 as PE DB                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * String data right truncation error after modifying string    *
    * size of a data field in DB2 database.                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Install P8PE4.0.3-002 or later relerases.                    *
    ****************************************************************
    

Problem conclusion

  • Fixed in P8PE4.0.3-002 and later releases.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PJ35283

  • Reported component name

    PROCESS ENGINE

  • Reported component ID

    5724R7607

  • Reported release

    401

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-12-05

  • Closed date

    2009-05-27

  • Last modified date

    2009-05-27

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    PROCESS ENGINE

  • Fixed component ID

    5724R7607

Applicable component levels

  • R403 PSY

       UP



Document information

More support for: Case Foundation
Process Engine

Software version: 401

Reference #: PJ35283

Modified date: 27 May 2009


Translate this page: