Direct link to fix
APAR status
Closed as fixed if next.
Error description
When the latest IBM DB2 JDBC driver from the DB2 installation path is used, running the DBUpgrade might fail with the following error: [Jul 5, 2018 11:08:47 AM] 00000001 SEVERE: com.lombardisoftware.tools.dbupgrade.UpgradeDatabase.main - Exception while verifying your database configuration [Jul 5, 2018 11:08:47 AM] 00000001 SEVERE: com.lombardisoftware.tools.dbupgrade.UpgradeDatabase.main - Check the log files for details [Jul 5, 2018 11:08:47 AM] 00000001 FINE: com.lombardisoftware.tools.dbupgrade.UpgradeDatabase.main - Could not connect to your Process Server database. java.lang.RuntimeException: Could not connect to your Process Server database. at com.lombardisoftware.tools.dbupgrade.steps.TestDatabases.execute (TestDatabases.java:43) at com.lombardisoftware.tools.dbupgrade.UpgradeDatabase.main(Upgrad eDatabase.java:135) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessor Impl.java:90) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod AccessorImpl.java:55) at java.lang.reflect.Method.invoke(Method.java:508) at org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:2 17) at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.ja va:152) at org.apache.tools.ant.taskdefs.Java.run(Java.java:764) at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:218) at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:132) at org.apache.tools.ant.taskdefs.Java.execute(Java.java:105) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java: 288) at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod AccessorImpl.java:55) at java.lang.reflect.Method.invoke(Method.java:508) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtil s.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1 337) at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(S ingleCheckExecutor.java:38) at org.apache.tools.ant.Project.executeTargets(Project.java:1189) at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:416) at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java :105) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java: 288) at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod AccessorImpl.java:55) at java.lang.reflect.Method.invoke(Method.java:508) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtil s.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java :62) at net.sf.antcontrib.logic.IfTask.execute(IfTask.java:217) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessor Impl.java:90) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod AccessorImpl.java:55) at java.lang.reflect.Method.invoke(Method.java:508) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtil s.java:106) at org.apache.tools.ant.TaskAdapter.execute(TaskAdapter.java:154) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java: 288) at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod AccessorImpl.java:55) at java.lang.reflect.Method.invoke(Method.java:508) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtil s.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1 337) at org.apache.tools.ant.Project.executeTarget(Project.java:1306) at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(Defau ltExecutor.java:41) at org.apache.tools.ant.Project.executeTargets(Project.java:1189) at org.apache.tools.ant.Main.runBuild(Main.java:758) at org.apache.tools.ant.Main.startAnt(Main.java:217) at org.apache.tools.ant.Main.start(Main.java:179) at org.apache.tools.ant.Main.main(Main.java:268) Caused by: java.lang.RuntimeException: com.ibm.db2.jcc.am.SqlException: [jcc][t4][10262][11223][4.24.92] Unexpected Throwable caught: com.ibm.dataaccess.ByteArrayUnmarshaller. ERRORCODE=-4228, SQLSTATE=null at com.lombardisoftware.tools.dbupgrade.UpgradeContext.getDataSourc e(UpgradeContext.java:137) at com.lombardisoftware.tools.dbupgrade.UpgradeContext.getConnectio n(UpgradeContext.java:102) at com.lombardisoftware.tools.dbupgrade.steps.TestDatabases.execute (TestDatabases.java:39) ... 54 more
Local fix
1) Add the jar dataaccess.jar to the DBUPgrade class path. 1a) Find the file <BPM_ROOT>/util/dbUpgrade/upgrade.xml, backup the file. 1b) Add dataaccess.jar to it. <fileset dir="${was.jre.home}/lib" > <include name="ibmcfw.jar" /> <include name="ibmorb.jar" /> <include name="dataaccess.jar" /> </fileset>
Problem summary
No additional information is available.
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
JR59751
Reported component name
BPM
Reported component ID
5737A5700
Reported release
860
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-07-12
Closed date
2018-09-05
Last modified date
2018-09-05
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSFPJS","label":"IBM Business Process Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.6.0.0","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
14 September 2022