APAR status
Closed as fixed if next.
Error description
In DataStage Designer, browsing sub-folders in the Repository tree view can fail with "Repository Access Failure: An error occurred when retrieving the folder content for '<folder path>'. Failure in repository access interface". This error has only been encountered when Oracle is used for the Metadata Server (XMeta) repository database. The underlying problem is an Oracle bug which causes the following error when XMeta executes an SQL query that contains a LIKE clause, the LIKE pattern is specified as a parameter, and the pattern contains multiple escaped backslashes: "java.sql.SQLException: [IBM][Oracle JDBC Driver][Oracle]ORA-01424: missing or illegal character following the escape character". This APAR is to work around the Oracle bug that is causing this error.
Local fix
Problem summary
**************************************************************** USERS AFFECTED: Users of DataStage Designer **************************************************************** PROBLEM DESCRIPTION: In DataStage Designer, browsing sub-folders in the Repository tree view can fail with "Repository Access Failure: An error occurred when retrieving the folder content for '<folder path>'.Failure in repository access interface". This error has only been encountered when Oracle is used for the Metadata Server (XMeta) repository database. The underlying problem is an Oracle bug which causes the following error when XMeta executes an SQL query that contains a LIKE clause, the LIKE pattern is specified as a parameter, and the pattern contains multiple escaped backslashes: "java.sql.SQLException: [IBM][Oracle JDBC Driver][Oracle]ORA-01424: missing or illegal character followingthe escape character". **************************************************************** RECOMMENDATION: Apply JR33055 patch. This fix is included in 81 Fp1 ****************************************************************
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
JR33055
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
810
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-05-21
Closed date
2010-01-21
Last modified date
2010-01-21
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
R810 PSN
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
21 January 2010