Transaction Synchronization/ETL Fails With Error 'ORA-01017: invalid username/password; logon denied'
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.
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
The issue can be reproduced at will with the following steps:
- Log in to TCG and navigate to Administration > Data Administration and select the data source.
- 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.
The issue has the following business impact:
Due to this issue, users cannot Synchronize the datasource.
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