Fixes are available
APAR status
Closed as program error.
Error description
bootstrap fails against a database with decimal=comma set up on DB2/z
Local fix
no
Problem summary
**************************************************************** * USERS AFFECTED: IBM BPM V8.5.0.1 Advanced ¯ ’Standard and * Express * **************************************************************** * PROBLEM DESCRIPTION: The bootstrapProcessServerData.sh * * command fails when run against a DB2 * * for z/OS database with decimal=comma * * set * **************************************************************** * RECOMMENDATION: * **************************************************************** When IBM BPM uses a DB2 for z/OS database with the decimal=comma setting, bootstrapProcessServerData.sh fails with the following BadSqlGrammarException error message: org.springframework.jdbc.BadSqlGrammarE xception: PreparedStatementCallback; bad SQL grammar [insert into LSW_ACL_ENTRY(acl_entry_id,group_id,po_ type,po_id,mask) values(1,3,5000,?,127)]; nested exception is com.ibm.db2.jcc.am.SqlSyntaxErrorExcept ion: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=,5000;MICROSECONDS MICROSECOND SECONDS SECOND MINUTES MINUTE HOURS, DRIVER=4.11.69
Problem conclusion
A fix for IBM BPM V8.5.0.1 is available that updates the SQL so that the error is eliminated and the bootstrapProcessServerData.sh script runs cleanly against a DB2 for z/OS database with decimal=comma configured. On Fix Central (http://www.ibm.com/support/fixcentral), search for JR48745: 1. Select the product group, product, installed version, and platform, and click Continue. 2. Select APAR or SPR, enter JR48745, and click Continue. When downloading fix packages, ensure that you also download the readme file for each fix. Review each readme file for additional installation instructions and information about the fix. After you apply the fix, rerun the boostrapProcessServerData.sh command.
Temporary fix
Comments
APAR Information
APAR number
JR48745
Reported component name
BPM ADVANCED
Reported component ID
5725C9400
Reported release
850
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-12-08
Closed date
2014-01-15
Last modified date
2014-01-15
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
BPM ADVANCED
Fixed component ID
5725C9400
Applicable component levels
R800 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
12 October 2021