JR32621: MNS STAGE WITH INPUT COUNTRY ISO CODE BE IS CRASHING WITH "CONVERT TABLE NOT FOUND"

APAR status

• Closed as program error.

Error description

• IS 8.0.1.1 on AIX  5.3 (repo on DB2 9.1)
  MNS stage with input country code BE is crashing the job with
  following errors :
  
  "MDMQSAddressStandardize.MNS,0: Convert table not found"
  
  "MDMQSAddressStandardize.MNS,0: Error occurred on line 2035 of
  file
  /products/IBM/InformationServer/Server/PXEngine/bin/Apps/MNV/Con
  trols/COUNTRY/BE/BEMNAD.PAT
   Pattern File line: OVERRIDE_D Text @$APPCLIB/BEMNAD.ITO Return
  VALUE"
  

Local fix

• Workaround :
  1. In the Designer, open the Waves Rules > BE and double click
  on the
  SET:BEMNAD entry to bring up the Rules Management GUI
  2. Double click on the Overrides folder to bring up the
  "Classification
  - BEMNAD" window : click OK on this windows as well as on the
  next
  window. This rewrites all the files
  3. Open the job and open
  the MNS
  stage, click OK to close it. Save the shared container
  4. Recompile your job calling the shared container.
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Shared container MNS job fails when executed.
  ****************************************************************
  PROBLEM DESCRIPTION:
  Shared container MNS job fails when executed due to tables not
  found
  ****************************************************************
  RECOMMENDATION:
  Patch is available and is recommended it be applied
  ****************************************************************
  

Problem conclusion

• WAR is to open the job and recompile it to get the files to be
  propagated.
  

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

• SERVER
  

Fix information

• Fixed component name

  WIS QUALITYSTAG

• Fixed component ID

  5724Q36QS

Applicable component levels

• R801 PSY

     UP