Database Servers

In the Database Servers tab, you configure the distribution and connection information for the SBM databases. You typically configure the Database Servers tab in wizard mode after you install SBM.

Initially, the Database Servers tab contains a single server (Server 1). By default, all of the SBM databases are listed on this server. You can define additional servers by dragging and dropping SBM databases into the space below Server 1. Alternatively, right-click any database and select the option Move to new server.

To use the SBM sample database, select the Use sample database check box and configure the database server settings for the server that will host the sample database. For more information, see About the Sample Database. If you installed Microsoft SQL Server Express locally to host the sample database, this check box is selected by default. For more information, see SQL Server Express Sample Database.

Entering Database Server Information

To connect to your database server, provide the following information:

Field Name Description
Application Engine ODBC data source Displays the current ODBC data source that is used to connect to the Application Engine database. Click Change to create a new data source, rename the default data source, or select an existing data source. For more information, see About Data Sources.
Type Select the type of DBMS you are using (SQL Server, Oracle, or PostgreSQL). The database type that you select determines which of the following fields appear.
Windows Authentication Select this check box to use Windows Authentication instead of SQL Authentication. For more information, see About Windows Authentication.
Host Enter the host name of your database server.
Instance Name Enter the SQL Server instance name. Provide a name if more than one instance exists in SQL Server.
Service Name Enter the Oracle Service Name. This identifies the service name that hosts your Oracle schema.
Important: If you performing an upgrade from a previous version of SBM and previously designated a SID for Oracle, then that SID is automatically used in the service name field. Ensure that the correct service name is specified here.
Port Enter the database server port number.

If you are using SQL Server or PostgreSQL and you want to encrypt connections made from the SBM components on this server to your DBMS, select Use secure connection on the SSL tab and configure the required settings. For details, see Configuring Data Encryption Options.

Entering Database Connection Information

After you enter your database server information, enter connection information for each SBM database. A warning message appears for each required field that is not completed.

Note the following important information:

To connect your databases, provide the following information:

Field Name Description
Database Enter the name of the database space you created in SQL Server.
Note: You can specify the same name if one or more components will share the same database. If you plan to have separate databases for each component, consider naming the database after the component. For example, "SBM Application Engine Database."
Schema/User name Enter the name of a privileged DBMS user account.
Note: For SQL Server databases, enter a SQL Server user account, not a Windows user account.
Password Enter the user's password.
Confirm password Enter the password again to confirm.
Connection After you have entered the connection information, you can test the connection to the database. If the test fails, review the information and make sure the database is online. You can also test the connection from an outside source like Microsoft's ODBC Data Source Administrator or Oracle's SQLPlus.

Retrying Orchestration Engine Upgrades and Clearing Warnings

The information in this section only applies to upgrades from versions prior to 11.0.

The Orchestration Engine database upgrade is performed by the renew utility that is installed with SBM Orchestration Engine. (For detailed information about the renew utility, refer to the SBM Orchestration Guide.) The renew utility is responsible for restoring existing data from the JBPM tables into the new BPEL tables that are used by the Apache ODE BPEL engine. Existing data in the event manager tables is preserved to ensure that orchestrations continue to run as they did prior to the upgrade.

When the renew utility is launched, all process apps that contain orchestrations are redeployed. If any failures are encountered, a message appears and presents the following options:

Use the list in fail_out.xml in combination with the detail from the upgrade.log to investigate any failures. Depending on the failures, you have the following options:

For example, if the schema version in a process app needs to be upgraded, NOT_SUPPORTED_VERSION appears as the cause in the fail_out.xml file. This means the process app schema version needs to be upgraded by redeploying from SBM Composer. You can either redeploy from SBM Composer and run the database upgrade again, or if you do not want to redeploy at this time, but you want to finish the database upgrade now, click Upgrade Database again, and then click Clear Warnings.

The database upgrade will report failures if the target server information in your environments is missing or cannot be verified. For example, if you are testing the production database upgrade by moving the database to a different environment, the upgrade process will report failures related to your environment definition in Application Repository. You can either update the endpoint and target server information and click Retry Upgrade or click Clear Warnings to proceed without making the changes to finish the upgrade.

Note: You can optionally pass the fail_out.xml file as an argument with the following -redeploy options:
-redeployInFile fail_out.xml

This option redeploys the process apps that are listed in fail_out.xml.

-failOutputFile fail_out.xml

This option recreates the fail_out.xml if it is deleted or missing.

For more examples on these options, refer to the renew command "-redeploy" in the SBM Orchestration Guide.

Related Topics

About the Sample Database

SQL Server Express Sample Database

About Data Sources

About Windows Authentication