Tuesday, 15 April 2014

Interesting exception seen whilst starting IBM Business Process Manager 8.5.0.1

So I saw this exception: -

[15/04/14 19:25:40:071 BST] 00000001 WsServerImpl  E   WSVR0009E: Error occurred during startup
com.ibm.ws.exception.RuntimeError: Exception while verifying the datasource version: failed to get stardard DB version by jndi jdbc/PerformanceDB

( Yes, that's correct - it did say stardard DB version !! )

This occurred whilst I was starting the Support cluster of an IBM BPM 8.5.0.1 Advanced environment.

From a bit of digging about, it looks like I failed to completely create the required databases schemata, tables etc.

It looks like I had at least one missing table - LSW_SYSTEM_SCHEMA.

Once I ran the appropriate scripts to create the Performance Data Warehouse (PDW) DB schemas: -

db2 -tvf createSchema_Advanced.sql 

I was able to validate the existence and contents of the missing table: -

DB2 "SELECT PROPVALUE FROM LSW_SYSTEM_SCHEMA WHERE PROPNAME = 'DatabaseSchemaVersion' "

which now returns: -

PROPVALUE                                                                                                                                                                                              
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
8.5.0                                                                                                                                                                                                  

  1 record(s) selected.


Now the cluster starts nicely, which is nice.

Memo to self - remember to create all the database objects, not just the containers themselves :-)

No comments: