Transaction Synchronization/ETL Fails With Error 'ORA-01017: invalid username/password; logon denied' (Doc ID 2043968.1)

Last updated on AUGUST 13, 2015

Applies to:

Oracle Transaction Controls Governor - Version 8.5.1 and later
Information in this document applies to any platform.

Symptoms

In Oracle Transaction Controls Governor (TCG) , when attempting to run Transaction Synchronization it fails.

Error in Log:

ERROR [GrcExecutorThread-221] DataSourceService:790 Error in testDSConnection
java.sql.SQLException: ORA-01017: invalid username/password; logon denied
ERROR [GrcExecutorThread-221] TcgEtlJob:507 Error occured in TcgEtlJob
oracle.apps.grc.extensibility.connector.exception.DataSourceConnectionException: Failed testing datasource connection
Caused by: oracle.apps.grc.dataaccessfacade.exception.ConnectionFailedException

Steps:


The issue can be reproduced at will with the following steps:

For 8.6.3:

  1. Log in to TCG and navigate to Administration > Data Administration and select the data source.
  2. Run Synchronization from Administration > Data Administration, select the data source and click on Synchronize > Transaction > Run Now.

For 8.6.4 or higher:

1. Log-in to GRC application and Go to Navigator > Setup and Administration > Manage Application Datasources and select the datasource.
2. Click on Actions > Synchronize Transaction.

Business Impact:
-----------------------
The issue has the following business impact:
Due to this issue, users cannot Synchronize the datasource.

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