IBM BPM, V8.0.1, All platforms > Install and configure IBM BPM > IBM BPM Advanced: Process Server > Install and configure IBM BPM Advanced: Process Server > On Windows > Network deployment environment jQuery.noConflict(); $("#tabs").tabs({ selected: 0 }); });

Loading the database with system information in an ND environment

If you are creating an ND environment, run the command before you try to start or use Process Server.

Before you begin

Important: Before you run the bootstrap command, apply Mandatory Interim Fix JR44669. See Required interim fix for APAR JR44669. To download the fix, see Required interim fixes for IBM BPM.

About this task

When you run the bootstrapProcessServerData command, configuration data for the BPM applications is loaded into the Process Server database. This data is required for the BPM applications to run correctly

Procedure

Run the bootstrap utility from the command line. The bootstrap utility is found in the dmgr profile directory.

For example:

Run the bootstrap utility using one of the following commands:

where:

The parameters are case-sensitive. Important: For SQL Server only: Ensure that the databases you create for Process Server and Performance Data Warehouse are case insensitive. The letters CI in the COLLATE attribute value specifies this. Ensure this variable looks like this: SQL_Latin1_General_CP1_CI_AS (not SQL_Latin1_General_CP1_CS_AS). Failure to do so can result in an error like the following:

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'message.routingCache' 
defined in class path resource [registry.xml]: Instantiation of bean failed; nested exception is 
org.springframework.beans.BeanInstantiationException: Could not instantiate bean class 
[com.lombardisoftware.bpd.runtime.engine.message.DefaultMessageRoutingCache]: Constructor threw exception; 
nested exception is org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; 
bad SQL grammar [select "value" from lsw_system where "key"=?]; nested exception is 
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'lsw_system'.

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'lsw_system'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:281)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:205)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:648)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591)
[...]

Results

You have loaded the database with system information before successfully starting the IBM BPM server. The log information for the bootstrap operation is saved to the USER_INSTALL_ROOT/logs/ directory in a file called bootstrapProcessServerData.clusterName.timestamp.log or bootstrapProcessServerData.nodeName.serverName.timestamp.log depending on the target you specified. The console displays a subset of the logged information.

Example

Bootstrap data onto a server that is part of an ND environment but not part of a cluster:
bootstrapProcessServerData
Bootstrap data onto a cluster that hosts the Process Server:
bootstrapProcessServerData -clusterName myAppCluster


Related tasks:
Encrypt passwords


Related reference:
Troubleshooting: Error running bootstrap command or creating profiles with SQL Server databases
Database privileges