PH59193: OPTIM.MASK() ERROR ON ODPP LOOKUP WITH A LARGE NUMBER OF FLDDEFs

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Customer is performing optim.mask() processing using the ODPP
  LOOKUP provider with a single source and 13 destination
  values.
  
  Optim will abort processing reporting the following error:
  
  The Following Error was Encountered during CONVERT Processing:
    CM PROCEDURE aborted with the following error:
    <table-name>(<column-name>): Column: <column-name>:
    Error in Column Map procedure or expression:  while executing
    cm_transform():String "cm_transform"¨:53: Unexpected internal
    error. Contact Optim support.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Optim users performing Column Map(CM)        *
  *                 processing using a CM PROCEDURE and ODPP via *
  *                 optim.mask() function using the Lookup       *
  *                 provider.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: See Error Description.                  *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  When Optim generates SQL for the lookup and there is a large
  number of columns, the generated SQL overflows a buffer.
  

Problem conclusion

• The buffer overflow issue has been corrected.
  

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:

  UI95336

Modules/Macros

• IOQBIND  IOQDPEXT IOQDPIBM IOQLKB   IOQLKO   IOQNOTC  IOQODPPZ
  IOQSHCMD IOQSHCMP IOQSHDFD IOQSHECB IOQSHERR IOQSHKVP IOQSHOPD
  IOQSHPPG IOQSHPU  IOQSHRUN IOQSHRWD IOQSHRWS IOQSHSCR IOQSHSVC
  IOQSHWAP IOQUALTN IOQUCSQL IOQUINST IOQUINSV IOQWACPT IOQWALOC
  IOQWAPLY IOQWDDEF IOQWEDIT IOQWISMK IOQWMKDR IOQWRECV IOQWSMPE
  IOQYMASK
  

Fix information

• Fixed component name

  INF OP TDM SOL

• Fixed component ID

  5655DG401

Applicable component levels

• RB30 PSY UI95336

     UP24/01/20 P F401

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.