JR52643: Fail to update Layout using Composer tool in DB2 environment.

APAR status

• Closed as program error.

Error description

• Fail to update Layout using Composer tool in DB2 environment.
  
  Widgets cannot be added to the layout using composer tool.
  Listing of widgets will result in SQL Exception on DB2
  environment. This issue is specific to DB2, and it works well in
   Oracle environment.
  
  When includeInActiveWidgets parameter value is passed as
  "false", one of the queries which uses CAST function to convert
  to CHAR(4) was failing with insufficient length error, though it
   works well in Oracle.
  

Local fix

Problem summary

• USERS AFFECTED:
  Customers who have installed JR 51844 on DB2 environment will
  not be able to create new layouts or modify existing layouts.
  
  PROBLEM ABSTRACT:
  Fail to update Layout using Composer tool in DB2 environment.
  
  
  BUSINESS IMPACT:
  Business users will not be able to create new layouts or modify
  existing layouts.
  
  RECOMMENDATION:
  

Problem conclusion

• To fix the issue, the CAST function will now convert
  includeInActiveWidgets parameter value to CHAR(5).
  
  
  The APAR updates the query in wc-query-WidgetDefinition-get.tpl
  related to following XPath:
  
   name=/WidgetDefinition[@includeInactiveWidgets= and
  WidgetType=]
  
  Specifically a clause in WHERE  condition is updated
  
  FROM:
        (CAST((?includeInactiveWidgets.1?) as CHAR(4)) = 'true')
  
  TO:
        (CAST((?includeInactiveWidgets.1?) as CHAR(5)) = 'true')
  

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

  WC BUS EDITION

• Fixed component ID

  5724I3800

Applicable component levels

• R700 PSY

     UP