Friday 2 September 2016

IBM BPM 8.5.7 - WSVR0009E during startup

I saw this after a clean build of an IBM BPM Advanced 8.5.7 Deployment Environment ( this is a single-server deployment, for an IBM Integration Designer build ): -

...
[02/09/16 12:39:36:799 BST] 00000001 WsServerImpl  E   WSVR0009E: Error occurred during startup
com.ibm.ws.exception.RuntimeError: Failed to query the BPM version from database [jdbc/PerformanceDB]. Please check the ffdc log for detail information. 
For fresh installation scenario, please run the database initialization scripts under the corresponding database schema first; for upgrade or migration scenario, please upgrade your database to match with current product version first.
at com.ibm.bpm.migration.database.ValidateDatabaseVersion.verifyStandardDB(ValidateDatabaseVersion.java:400)


in C:\IBM\WebSphere\AppServer\profiles\AppSrv01\logs\server1\SystemOut.log.

I checked the content of the Performance Data Warehouse (PDW) DB: -

db2 connect to pdwdb user db2admin
db2 list tables for all | more

and realised that, whilst I had plenty of artefacts in the SYSCAT and SYSIBM schemas: -

...
ATTRIBUTES                      SYSCAT          V     2016-09-02-09.26.30.903022
AUDITPOLICIES                   SYSCAT          V     2016-09-02-09.26.30.919007
AUDITUSE                        SYSCAT          V     2016-09-02-09.26.30.919015
BUFFERPOOLDBPARTITIONS          SYSCAT          V     2016-09-02-09.26.30.935005
DUAL                            SYSIBM          V     2016-09-02-09.26.30.810011
...
PARAMETERS                      SYSIBM          V     2016-09-02-09.26.30.857002
PARAMETERS_S                    SYSIBM          V     2016-09-02-09.26.30.857010
REFERENTIAL_CONSTRAINTS         SYSIBM          V     2016-09-02-09.26.30.825006
REF_CONSTRAINTS                 SYSIBM          V     2016-09-02-09.26.30.825014

there was NOTHING in the DB2ADMIN schema.

This is a manual build of IID, rather than one using the Launchpad, and, of course, I'd made a mistake.

Whilst I had created the database: -

cd c:\IBM\WebSphere\AppServer\profiles\AppSrv01\dbscripts\PSCell1.ProcessServer\DB2\PDWDB
createDatabase.bat

I'd forgotten to create the tables etc.: -

db2 connect to pdwdb
db2 -tvf createSchema_Advanced.sql
db2 terminate


Once I did the needful, it started working: -

[02/09/16 12:49:35:797 BST] 00000001 WsServerImpl  A   WSVR0001I: Server server1 open for e-business


No comments:

Visual Studio Code - Wow 🙀

Why did I not know that I can merely hit [cmd] [p]  to bring up a search box allowing me to search my project e.g. a repo cloned from GitHub...