IBM BPM, V8.0.1, All platforms > Install IBM BPM > IBM BPM Advanced > Install IBM BPM Advanced > On AIX > Stand-alone environment > Custom installation and configuration > Configure profiles and databases > SQL database server > Create database design files

Troubleshooting the database design tool

If you have errors in your database scripts, you can use the diagnostic and validation information provided by the database design tool to diagnose the problems.


Required property is empty errors

When the required userName and password properties are not set, you might see messages of the following type in the output:

[status] WBI_BSPACE is not complete with 2 remaining item(s):
[ 1 ] BSpace.WBI_BSPACE : authAlias : required property 'userName' for userId is empty.
[ 2 ] BSpace.WBI_BSPACE : authAlias : required property 'password' for DB_PASSWORD is empty.


Sample output of running a validation of the existing database design

When you run a validation of the existing database design, you might see warnings of the following type in the output:

DbDesignGenerator.bat -v SQL Server-
...
[WARNING] 2 potential problems are found in the scripts. They are DB_USER @ line 46 in file configCommonDB.bat
DB_USER @ line 80 in file configCommonDB.sh


Contents of the database design tool log file

When you run the database design tool, a dbDesignGenerator.log file is created in the location from which the database design tool command is run. The log contains all the prompts and values entered. The log file does not contain any additional trace output.

Create database design files for SQL Server