JR59751: RUNNING THE DBUPGRADE COMMAND FAILS IF YOU USE THE LATEST IBM DB2 JDBC DRIVER

workflow.18002.delta.repository

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 is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels