Server Installation, Configuration, and Deployment

9.2.6
- 9.2.7
- 9.2.5
- 9.2.4.6

Back Next

WebLogic Configuration

This section leads you through configuration of the resources required for Process Server. You must configure your database, Apache Tomcat Server and Process Server before deploying and running Process Server. The sections below provide information for completing the configuration.

Configuration Instructions

Before running the Configuration utility, perform the following pre-configuration steps:

Create a database (or tablespace) where Process Server persistence information will be stored

Create a default user with administrative rights to the computer and database for use by Process Server

Create a JDBC Data source as described below.

Configuring a JDBC Data Source

You must configure a JDBC Data Source in WebLogic in order to provide details of database connectivity for the Process Server database. Use the WebLogic Server® Administration Console to select Services > JDBC > Data Sources
, and provide the required details, including the following:

Property	Description
Data Source Name	The Data Source name ActiveVOS will use to connect to the database, such as ActiveVOS.
JNDI Name	The Data Source name ActiveVOS will use to connect to the database, such as ActiveVOS.
Database Type and Database Driver	You must select one of the supported types: MySQL MS SQL SERVER ORACLE DB2 Select a recommended database driver, as described in Prerequisites.
Connection Properties	Database Name is ActiveVOS (default, as defined in the DDL script) Database User Name and Password . The suggested credentials during configuration are bpeluser/bpel . URL . The format of the URL varies by JDBC driver. For mySQL you must configure character encoding in the URL as follows: jdbc:mysql://localhost:3306/ActiveVOS?useUnicode=true&characterEncoding=UTF-8&characterSetResults=utf8

Configuring a Work Manager

To ensure optimal server performance, we highly recommend that you configure a WebLogic Work Manager. A Work Manager is a mechanism that prioritizes work and allocates execution threads for work requests. As your test and production versions of Process Server get underway, a Work Manager helps you tune performance. WebLogic provides a comprehensive set of components to configure a Work Manager in the WebLogic Administration Console. Refer to an overview of Oracle WebLogic 10.3 Work Manager
documentation. For configuration in the Oracle WegLogic 10.3 Administration Console, see
Create global Work Managers
and Create application-scoped Work Managers
.

If there is no Work Manager configured when you execute the Config-Deploy utility, Process Server provides its own internal work manager. The internal work manager is configured with a basic set of minimum and maximum execution threads.

First Time or New Install

If you are performing a clean installation, that is, a first-time install or a new database, you can use the Configuration utility to automatically install the database schema.

Manual Install or Update of Database Schema

It is strongly recommended that you automatically install the database schema; however, you can manually install it. Customers migrating from an earlier version should follow the instructions below.

Migrating from an earlier release of ActiveVOS to Process Server

If you are migrating from ActiveVOS, perform the following steps:

Manually update the Process Server database schema using the DDL patches provided in

{install_dir}/server/tomcat_config/ddls/updates

Run the Configuration utility

Review the Release Notes for late breaking migration information

Review the Process Developer help topic, Migrating from Earlier Versions

Process Server can be configured to use an RDBMS database.

Relational Database Schemas

These instructions are generalized to make sure they can be followed for each database. When creating the database schema for Process Server, you can either create a new database definition or upgrade an existing definition.

Refer to the install a new database schema section for a new installation.

Refer to upgrade a database schema when performing a version upgrade.

Install a new database schema

Identify your DDL. Use the information provided in the table below to locate the correct DDL file.

Database Server	DDL File Name and Location	Notes
MYSQL	{install_dir}/server /weblogic_config/ddls/ ActiveBPEL-Enterprise-MYSQL.SQL	The default database name, ActiveVOS is defined within the DDL file. If you edit this name, ensure that you do not replace ActiveVOS Enterprise, a name that is inserted into the AeMetaInfo table.
MS SQL SERVER	{install_dir}/server /weblogic_config/ddls/ ActiveBPEL-Enterprise-SQLSERVER.SQL	The default database name, ActiveVOS is defined within the DDL file. If you edit this name, ensure that you do not replace ActiveVOS Enterprise, a name that is inserted into the AeMetaInfo table.
ORACLE	{install_dir}/server/weblogic_config/ddls/ActiveBPEL-Enterprise-ORACLE.SQL	Create a tablespace prior to running the DDL.
DB2	{install_dir}/server/weblogic_config/ddls/ ActiveBPEL-Enterprise-DB2.SQL

Copy the DDL file from above, and rename it.

Note:
The original files must remain unchanged for the Configuration utility to work properly

(Optional) Modify the database name. Be sure to see the notes above.

Execute the DDL script.

Permissions must be set for Process Server to access your schema. For example,

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE

If Process Server does not have the permissions it needs, you will see an error message that begins as follows: Failed to get version info from the AeMetaInfo table

Each database server provides its own mechanism or utility for executing a DDL script file. Execute the DDL script file using the appropriate utility. For example, if you are using Oracle, the utility to execute the DDL script file would be SQL Plus.

Upgrade an Existing Database Schema

To upgrade your Process Server database to be compatible with the new version of software, follow the instructions below:

Shutdown Process Server before executing a database upgrade.

Make a backup copy of your database.

Identify your current running version of Process Server. Database upgrades are provided to upgrade from one version back at a time. This means that more than one upgrade script may need to be applied to your database. For example, if you are running ActiveVOS version 8.0.x, you must go to the updates
folder, and apply all patch scripts with higher numbers, starting with

[database name]-Patch-9.0.sql

. Be sure to run the patch scripts in ascending
order. Do not run any upgrade script with a version number equal to or less than your current running version.

For each upgrade that needs to be applied perform the following:

Identify your DDL. Use the information provided in the table below to locate the correct DDL file. Note: The updates must be applied in ascending order.

MYSQL: {install_dir}/server/weblogic_config/ddls/updates/enterprise/ActiveBPEL-Enterprise-MYSQL-PATCH-{patch number}.SQL
MS SQL SERVER: {install_dir}/server/weblogic_config/ddls/updates/enterprise/ActiveBPEL-Enterprise-SQLSERVER-PATCH-{patch number}.SQL
ORACLE: {install_dir}/server/weblogic_config/ddls/updates/enterprise/ActiveBPEL-Enterprise-ORACLE-PATCH-{patch number}.SQL
DB2: {install_dir}/server/weblogic_config/ddls/updates/enterprise/ActiveBPEL-Enterprise-DB2-PATCH-{patch number}.SQL

Execute the DDL script.

Each database server provides its own mechanism or utility for executing a DDL script file. Execute the DDL upgrade script file using the appropriate utility. For example, if you are using Oracle, the utility to execute the DDL script file would be SQL Plus.

Versions of WebLogic Prior to 12.2 Have File Upload Issues

Versions of WebLogic prior to 12.2 have file upload issues and you may see one or more of the following:

Cannot deploy bpr.

Cannot import the identity configuration settings: after you import the configuration file, the data does not get filled.

Cannot add an attachment using a Task Screenflow > Add attachment
automated action where the screen allows you to browse a file. The guide hangs in this step. You get the message "the Guide session is not available and cannot be used"

This is a known issue with weblogic 12.1.1. You either need to install a later versio or obtain the patch 13657792 and install it. If you wish to install the patch, enter this value in the Patch Number Search field on the Patches > Updates tab of My Oracle Support.

A second Weblogic problem is that that Servlet 3.0 file upload is enabled by default and cannot be disabled using a flag in the WebLogic Server. This causes problems when using other file upload frameworks.

Multisite Configuration

For details, see Process Server MultiSite Configuration
.

Security Configuration

You can find details on configuring Process Server security roles in Process Developer Help or in the Infocenter.

Configuration for Headless Mode

Process Server relies on GUI components from the Java's SWT package, such as Fonts. If you are running on a headless server (i.e., the server does not have a graphic subsystem), you may see one of the following errors in the stack trace:

java.lang.NoClassDefFoundError: sun/awt/X11GraphicsEnvironment

Can't connect to X11 window server using ':0.0' as the value of the DISPLAY variable

org.eclipse.birt.report.service.api.ReportServiceException

Use one of the following techniques to correct errors:

Configure the JVM system property

java.awt.headless=true

and at the command line, start the JVM with the argument:

-Djava.awt.headless=true

Run a X-windows virtual frame buffer (Xvfb)

Using the Configuration Utility

The Configuration utility walks through the steps required to provide the property values for Process Server and selected resources.

Note:
Before running the utility, ensure that your server container is stopped.

Starting the Configuration Utility

Execute one of the following utilities based on your operating system:

Windows: {install_dir}/server/weblogic_config/bin/config_deploy.bat
Linux: {install_dir}/server/weblogic_config/bin/config_deploy.sh

If You Have Manually Installed or Updated the Database Schema

If you have manually installed or updated the database schema, when prompted, you must not select the "Install Database Schema" checkbox.

Running the Configuration Utility in Different Modes

The Configuration utility can be run with a graphical interface (default), in console mode or silently. When you run the utility your configuration options are automatically written to the install.properties file and they will be used as the defaults the next time the application is configured. One of the following parameters is accepted by the Configuration utility:

Help:

help

. This option displays the usage for console and silent modes.

Console mode:

console

. Runs the Configuration utility in text mode within a command window.

Silent mode:

silent

. Runs in the background requiring no user interaction. This option requires that you have already run the Configuration utility in default mode, which sets configuration options in the install.properties file.

An example of running the Configuration utility from the command line is:

config_deploy help

Configuration Help

The Configuration utility contains online help for each panel of the utility. Access Help by clicking the Help button on each panel. Additionally you can access the help from

Rename Saved Search

Table of Contents

Server Installation, Configuration, and Deployment

Server Installation, Configuration, and Deployment

WebLogic Configuration

WebLogic Configuration

Configuration Instructions

Configuring a JDBC Data Source

Configuring a Work Manager

First Time or New Install

Manual Install or Update of Database Schema

Versions of WebLogic Prior to 12.2 Have File Upload Issues

Multisite Configuration

Security Configuration

Configuration for Headless Mode

Using the Configuration Utility