JR51322: REPORT ERROR WHEN USING INPUT PARAMETERS WITH AN ATTRIBUTE OF TYPE INTEGER AND REMOVING THE ATTRIBUTE VALUE.

APAR status

• Closed as program error.

Error description

• Preface:
  --------
  For a report a script input spec is defined with an attribute
  of type integer.
  
  Current situation:
  -------------------
  Without setting a value for the integer input parameter the
  report works.
  After setting an integer value the report works too.
  But after removing the integer value and saving the input
  parameter the report throws an exception.
  

Local fix

• After deleting the document attribute for the input spec
  attribute of type integer the report will work again.
  
  SQL statements to find the document and the document attributes:
  select * from dhi where dhi_doc_path = '/params/<script input
  spec>/<report name>'
  select * from doa where doa_doc_id=<dhi_doc_id>
  
  SQL statement to delete the document attribute for the input
  spec attribute of type integer:
  delete from doa where doa_doc_id=<dhi_doc_id> and DOA_NAME =
  '<input spec name>/<attribute name>'
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Master Data Management Collaboration Server              *
  * implementation are affected by this issue.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * For a report a script input spec is defined with an          *
  * attribute of type integer.                                   *
  * Current situation:                                           *
  * Without setting a value for the integer input parameter the  *
  * report works. After setting an integer value the report      *
  * works too. But after removing the integer value and saving   *
  * the input parameter the report throws an exception.          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Customers facing the issue reported by this APAR apply IBM   *
  * InfoSphere Master Data Management Collaboration Server       *
  * version 11 Fix Pack 007 to gain resolution to this problem.  *
  ****************************************************************
  

Problem conclusion

• A fix for this problem has been included in IBM InfoSphere
  Master Data Management Collaboration Server, Version 11 Fix Pack
  007.
  

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

  MDM SERVER FOR

• Fixed component ID

  5724V5100

Applicable component levels

• RB00 PSY

     UP