Administering the Sun Business Process Manager Database

Viewing and Modifying Database Scripts in Enterprise Designer

You can open the database scripts and view, modify, and run them within the Project Explorer. Consult your database administrator when making changes to the database scripts. Some of the changes you might need to make include:

ProcedureTo modify a database script

  1. In the Project Explorer, expand Sum BPM.

  2. Make sure Run Database Scripts is checked out, and then expand the folder.

  3. Under Database Scripts, right-click the script you want to modify, and then click Open.

  4. For Oracle 8.1.7 only, reduce the maximum key length for correlation keys from 4000 to 3166. The correlationvalue parameter belongs to the correlationengine and correlationbpinstance tables. The following code examples show the changes.

    create table bpm60 correlationengine ( correlationvalue varchar(3166) UNIQUE, applicationreference varchar(255), ...); ... create table bpm60.correlationbpinstance ( correlationvalue varchar(3166) UNIQUE, bpid varchar(50), ...);

  5. Make any other necessary changes to the script. Do not change any of the table or field names.

  6. To run the database script, right-click the script name and click Run. The database instance must be running in order to perform this step.

  7. To save your changes, right-click inside the script file and click Save, or close the file. You are prompted to save or discard your changes. To keep your changes, click Save; otherwise, click Discard.