APAR status
Closed as program error.
Error description
Metadata Workbench has an issue with the usage of paramters within Insert and Update Statements The issue related to the display of warnings or errors witihin the log, giving the impression the Stage was being ignored during the Automated Services. The issue was found that either Default Values where missing, or the Default Value contained an incomplete SQL statment. It may be possibly that only using operational metadata - where the SQL statment (parameterized) passed can be parsed successfuly.
Local fix
Problem summary
Lineage is not working while using user defined SQL with insert and update statements
Problem conclusion
Applying the patch will address the specific issue of user defined SQL within DS which references an insert and update script.
Temporary fix
Comments
APAR Information
APAR number
JR43363
Reported component name
METADATA WORKBE
Reported component ID
5724S4100
Reported release
850
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-07-09
Closed date
2012-07-27
Last modified date
2012-07-27
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
METADATA WORKBE
Fixed component ID
5724S4100
Applicable component levels
R850 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SS3GFL","label":"InfoSphere Metadata Workbench"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
27 July 2012