GRC (AACG) Transaction Synchronization/Access Synchronization Failing

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.