TIBCO iProcess Technology Plug-in EAI_BW steps fail to execute.

TIBCO iProcess Technology Plug-in EAI_BW steps fail to execute.

book

Article ID: KB0093541

calendar_today

Updated On:

Products Versions
TIBCO iProcess Technology Plug-ins -
Not Applicable -

Description

Description:
EAI_BW steps fails to execute. The EAIJAVA logs contain the error:

2015-07-21 07:32:42,355 [ERROR]b0bd7dede4c6069affffff0c01ff48d8 SWAliasControlDAO - Unable to obtain database connection
java.sql.SQLException: ORA-01005: null password given; logon denied

The issue also occurs when modelling EAI_BW steps in a iProcess Workspace (Windows) Client.

Symptoms:
TIBCO iProcess Technology Plug-in EAI_BW steps fail to execute

The EAIJAVA logs contain the error:

2015-07-21 07:32:42,355 [ERROR]b0bd7dede4c6069affffff0c01ff48d8 SWAliasControlDAO - Unable to obtain database connection
java.sql.SQLException: ORA-01005: null password given; logon denied
Cause:
The encryption algorithm was strengthened in the TIBCO iProcess Technology Plug-in 11.4.0 .

The encrypted password for the database user is contained in the iProcess configuration files:
SWDIR/eaijava/jms/config.xml
SWDIR/eaijava/eaijavaplugin.properties

The issue occurs as the iProcess Technology Plug-in 11.4.0 Installer encrypts the password using the old algorithm.

Issue/Introduction

TIBCO iProcess Technology Plug-in EAI_BW steps fail to execute.

Resolution

Perform the following actions:

1).  Stop iProcess.

2).  Install the iProcess Technology Plug-in 11.4.0- Hot Fix 01 into the iProcess engine.

3).  Generate the encrypted password for the database user configured in the plug-in. The mechanism to do this is documented in the TIBCO iProcess Technology Plug-in 11.4.0 Installation Guide.

4).  Update the following files with the new encrypted password:

    SWDIR/eaijava/eaijavaplugin.properties
    SWDIR/eaijava/jmx/config.xml

5).  Start iProcess.

Additional Information

TIBCO iProcess Technology Plug-in 11.4.0 Installation Guide