JR34266: NLS MAPPING ERROR. CUSTOMER GET "ORA-12899: VALUE TOO LARGE FOR COLUMN" ERROR ON LINUX ENVIRONMENT."

APAR status

• Closed as program error.

Error description

• Customer has a job which selects data from Oracle and INSERT to
  another table.
  When SELECTing item defined as Type:Char, Size:3 and INSERTing
  it to the item defined as
  Type:VarChar, Size:3, the following error happens:
     ORA-12899: value too large for column
  "GS_HIKE"."TEST_CHAR"."X" (actual: 6, maximum: 3)
  

Local fix

• This fix is included in 8.0.1 fixpack 3
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  ORACLE OCI stage
  ****************************************************************
  PROBLEM DESCRIPTION:
  NLS MAPPING ERROR.  CUSTOMER GET "ORA-12899: VALUE TOO LARGE
  FOR
  COLUMN" ERROR ON LINUX ENVIRONMENT."
  ****************************************************************
  RECOMMENDATION:
  Apply apar JR34266
  This change is included in 8.1 Fix Pack 1.
  ****************************************************************
  

Problem conclusion

• Apply apar JR34266
  

Temporary fix

Comments

APAR Information

• 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

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R810 PSN

     UP