Showing results for 
Search instead for 
Did you mean: 

Oracle execute snap retry if database is offline

New Contributor

We have a pipeline to add a transaction to an Oracle database. The pipeline is invoked by a trigger task and can run at any time day or night. The database goes offline for backups for about an hour each week and if the pipeline is invoked during this downtime, it will fail with a “com.snaplogic.snap.api.SnapDataException: Failed to retrieve a database connection.” error.

Although I configured the snap to retry multiple times, it appears that this error doesn’t lead to any retry attempts. Is that correct? Thanks.