REP-501: Unable to Connect to the Specified Database when Running WAM Reports from SIA Modules (Doc ID 466396.1)

Last updated on OCTOBER 16, 2016

Applies to:

Oracle Utilities Work and Asset Management - Version 1.7.15 and later
Information in this document applies to any platform.

Symptoms

Reports are not running from Daily/Weekly Schedule screens.  The Report runs fine from the Report Administration form. When running Reports from SIA, the following error message is received:
REP-501: Unable to connect to the specified database

Changes

The 1.7.15 install guide was followed for the Required Environment Changes (section 6)

Step 6 of the Installation Guide requires the creation of a User that has sufficient rights to run reports in
the application.

When this User is created via the User Enrollment Wizard, if the Encrypt
Pass-word indicator IS selected,the User's pass-word is encrypted. When the
SIA reports are run, the following error occurs since the User does not have
privileges to connect to the database due to pass-word encryption:

REP-501: Unable to connect to specified database

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms