Issue : Data Source validation is fine. But Access Synchronization/Transaction Synchronization is failing.
Cause : Caching
Fix:
- Shutdown GRC Application.
- Shutdown GRC database.
- Take backup of GRC database and application.
- Startup GRC database.
- Run the below query to see if there are any tables in GRC schema with name SNP_
- select owner,table_name from dba_tables where table_name like 'SNP_%' and owner='GRC';
- If the above query returns any rows, drop those tables under GRC schema.
- Make sure there are no tables with SNP_% under GRC schema by running above select query again.
- Go to Application Tier and Clear Cache
- In case of Weblogic based, take backup and delete the contents of tmp and cache folders.
- Take backup of ETL directory and remove the "temp.repository" folder alone under ETL directory.
- Startup the GRC application.
- Validate the Data source.
- Run the Access Synchronization first followed by Transaction Synchronization.
