Fixes are available
8.5.5.5: WebSphere Application Server V8.5.5 Fix Pack 5
8.5.5.6: WebSphere Application Server V8.5.5 Fix Pack 6
8.5.5.7: WebSphere Application Server V8.5.5 Fix Pack 7
8.5.5.8: WebSphere Application Server V8.5.5 Fix Pack 8
8.5.5.9: WebSphere Application Server V8.5.5 Fix Pack 9
8.5.5.10: WebSphere Application Server V8.5.5 Fix Pack 10
8.5.5.11: WebSphere Application Server V8.5.5 Fix Pack 11
8.5.5.12: WebSphere Application Server V8.5.5 Fix Pack 12
8.5.5.13: WebSphere Application Server V8.5.5 Fix Pack 13
8.5.5.14: WebSphere Application Server V8.5.5 Fix Pack 14
8.5.5.15: WebSphere Application Server V8.5.5 Fix Pack 15
8.5.5.14: WebSphere Application Server V8.5.5 Fix Pack 14
8.5.5.17: WebSphere Application Server V8.5.5 Fix Pack 17
8.5.5.20: WebSphere Application Server V8.5.5.20
8.5.5.18: WebSphere Application Server V8.5.5 Fix Pack 18
8.5.5.19: WebSphere Application Server V8.5.5 Fix Pack 19
8.5.5.16: WebSphere Application Server V8.5.5 Fix Pack 16
APAR status
Closed as program error.
Error description
An unneeded line break causes a SQLException to be thrown when running CreateLRSCHEDTablesOracle.ddl or updateSchedulerDBForJobClassRecoveryOracle.ddl This line break was not present in 8.5.5.1 but appears in 8.5.5.2
Local fix
Remove extra line break after CREATE statements
Problem summary
**************************************************************** * USERS AFFECTED: Users of IBM WebSphere Application Server * * V8.5. * **************************************************************** * PROBLEM DESCRIPTION: A SQLException is being thrown when * * running two Oracle DLL files. * **************************************************************** * RECOMMENDATION: * **************************************************************** Two line breaks, one in each file, were causing the SQLException
Problem conclusion
Removed the line breaks causing the errors in CreateLRSCHEDTablesOracle.ddl and updateSchedulerDBForJobClassRecoveryOracle.ddl The fix for this APAR is currently targeted for inclusion in fix pack 8.5.5.5. Please refer to the Recommended Updates page for delivery information: http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980
Temporary fix
An interim fix is available upon request.
Comments
APAR Information
APAR number
PI25359
Reported component name
WEBSPHERE APP S
Reported component ID
5724J0800
Reported release
850
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2014-09-09
Closed date
2015-01-09
Last modified date
2015-02-09
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
WEBSPHERE APP S
Fixed component ID
5724J0800
Applicable component levels
R850 PSY
UP
Document Information
Modified date:
12 January 2022