PH51997: CM PROC PROCESSING: ERROR CONVERTING DATA FROM CCSID 1208 TO CCSID 37

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Customer is performing Column Map processing for CONVERT. The
  data involves a UTF-8 Unicode column.
  The process ends with the following error:
  
  <table>(<column>): Column Map Procedure set on column
  <column> in destination table <table>
  encountered an error at line 729 while processing row 39:
  encountered error converting data from CCSID 1208 to CCSID 37.
  
  Customer has specified ALLOW_CONVERSION_ERRORS YES to suppress
  all data conversion (between CCSIDs) errors.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Optim users performing Column Map        *
  *                 processing.                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: See Error Description.                  *
  ****************************************************************
  Optim is incorrectly handling Unicode data with malformed or
  truncated characters when there is a need for data conversions
  between CCSID, for example, when using certain function in a
  CM PROCEDURE.
  

Problem conclusion

• Optim processing will be corrected.
  The corrupt characters will be detected during data conversion.
  The ALLOW_CONVERSION_ERRORS control statement (in BATCH), or
  the respective site and user options, determines how Optim will
  handle such invalid data:
  
  When ALLOW_CONVERSION_ERRORS YES has been specified, the data
  converted successfully for a column, up to the corrupt character
  will be passed on for further processing and the corrupt
  character, and any following characters, ignored.
  The following messages will appear in the Optim Process Report:
  
  *** Note: ALLOW_CONVERSION_ERRORS option is set to YES
            and 1 CONVERSION ERROR(S),
            caused by malformed or corrupted characters,
            have been detected and ignored.
            Invalid character, and any characters following it,
            have been discarded.
            The rows with the error have been accepted for
            processing.
            The count indicates number of failed conversion
            attempts. There can be multiple conversion attempts
            per column or row.
  
  When ALLOW_CONVERSION_ERRORS NO has been specified, the rows
  will be marked as having a "data conversion error" and discarded
  or excluded from further processing.
  

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:

Modules/Macros

• FOP00203 FOP00303 FOP9APIM FOPCFPMN FOPCXLIB FOPD2    FOPD2V61
  FOPD2V71 FOPD2V81 FOPD2V85 FOPD2V91 FOPD2VA5 FOPD2VC5 FOPHSTM
  FOPMADDE FOPMAIN  FOPMARCN FOPMCMAI FOPMCOFN FOPMCOLA FOPMCOLP
  FOPMDDDL FOPMDMAI FOPMDPRC FOPMDXTR FOPMECMN FOPMEMAI FOPMIXMM
  FOPMMCMR FOPMMJBS FOPMMUNU FOPMMUTL FOPOMN   FOPRS10  FOPTOP76
  FOPTUO45 FOPZFMMN
  

Fix information

• Fixed component name

  OPTIM MOVE FOR

• Fixed component ID

  5655V0700

Applicable component levels

• RB70 PSY UI90272

     UP23/01/27 P F301

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.