AACG 8.6 – Datasource Sync Error (Failed)

(oracle.apps.grc.common.job.JobExecutionException: oracle.apps.grc.dataservices.exception.DataServiceException: Datasource synch failed )

Symptom:-
If you get a below error like this in weblogic adminserver.log file.Please follow the below troubleshooting.
Navigate to $WLS_HOME/user_projects/domains/grc_Domain/servers/AdminServer/logs/Adminserver.log

2015-04-09 16:28:52,384 DEBUG [Thread-100] EtlService:642 sync Id :362
2015-04-09 16:28:52,384 DEBUG [Thread-100] EtlService:643 sync TotalTransformCount :139
2015-04-09 16:28:52,384 DEBUG [Thread-100] EtlService:644 sync ExecutedTransformCount:6
2015-04-09 16:28:52,384 DEBUG [Thread-100] EtlService:649 getProgressPercentage :4.31654676%
2015-04-09 16:28:52,836 INFO [GrcExecutorThread-8] OdiSyncConnector:71 OdiSyncConnector().synchronize(): setting progress handler to finished.
2015-04-09 16:28:52,837 DEBUG [GrcExecutorThread-8] EtlJob:295 END OF AACG ETL
2015-04-09 16:28:52,837 ERROR [GrcExecutorThread-8] EtlJob:297 Access Sync Failed – Tcg Etl will be skipped
oracle.apps.grc.dataservices.exception.DataServiceException: Datasource synch failed
at oracle.apps.grc.dataaccessfacade.etl.OdiTransaction$1.sessionStatusChanged(OdiTransaction.java:692)
at oracle.apps.grc.dataaccessfacade.etl.OdiSessionMonitor.run(OdiSessionMonitor.java:156)
at java.lang.Thread.run(Thread.java:745)
2015-04-09 16:28:52,840 ERROR [GrcExecutorThread-8] EtlJob:323 Error occured in EtlJob
oracle.apps.grc.common.job.JobExecutionException: oracle.apps.grc.dataservices.exception.DataServiceException: Datasource synch failed
at oracle.apps.grc.appservices.EtlJob.runJob(SourceFile:315)
at oracle.apps.grc.scheduler.job.AbstractJob.run(SourceFile:391)
at oracle.apps.grc.common.executor.GrcExecutor$GrcRunnable.run(GrcExecutor.java:185)
at java.lang.Thread.run(Thread.java:745)
Caused by: oracle.apps.grc.dataservices.exception.DataServiceException: Datasource synch failed
at oracle.apps.grc.dataaccessfacade.etl.OdiTransaction$1.sessionStatusChanged(OdiTransaction.java:692)
at oracle.apps.grc.dataaccessfacade.etl.OdiSessionMonitor.run(OdiSessionMonitor.java:156)
… 1 more
2015-04-09 16:28:52,934 ERROR [GrcExecutorThread-8] AbstractJob:436 JobExecutionException for job [jobName=EtlJob1428622077484, jobId=19603, jobRunId=7984, jobStatus=STARTED, jobType=ETL]
oracle.apps.grc.common.job.JobExecutionException: Error occured during Sync Job
Troubleshooting:-
Check whether you’re TNS and Login credentials or correct.
Or
Check your User (except apps) have access to FND and UMX schema and tables
Or
Check if you’re EBS and AACG are in same network segment
Solution:-
1. Stop the AACG Application Server.
2. Kill any pending java process if still active for Weblogic server.
3. Take the backup of GRC schema and the TCG ETL directory.
4. Connect to the GRC database as the GRC user and drop all the tables with name starting with SNP_.
eg. drop table SNP_COND cascade constraints;
select ‘drop table ‘|| table_name || ‘ cascade constraints;’ from all_tables where table_name like ‘SNP_%’;
5. Make sure following query returns 0:
select count (*) from all_tables where table_name like ‘SNP_%’;
6. Stop the EGRC DB.
7. Start the EGRC DB.
8. Rename the existing grc.log
9. Clear Application sever Cache.
For Weblogic: backup and delete Log and tmp folders for AdminServer
cd $MW_HOME/user_projects/domains/<grc_domain>/bin
rm -rf ../servers/AdminServer/tmp/*
rm -rf ../servers/AdminServer/logs/*
rm -rf ../servers/AdminServer/cache/*
10. Start the Application Server.
11. Check the credentials of Datasource on one of the datasources eg UAT. Test Connect to make sure the connection is successful.
12. Retest Access Synchronization.
13. If still an issue, upload the grc.log and Adminserver logs.

 

Leave a Reply

Your email address will not be published.