[midPoint] livesync task error causes suspend

[Andrew Morgan]

I have a livesync task that runs against our DatabaseTable resource using 
a changeLogColumn to track changes.  This works great until the database 
is taken offline each Saturday morning for cold backups and maintenance. 
When I view the task on Monday, it is suspended.

The Results tab of the task shows these 2 lines:

Token
   1000000000001518137
Operation
   com.evolveum.midpoint.common.operation.liveSync
Status
   FATAL_ERROR
Message
   Internal Error: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

Token
   1000000000001518138
Operation
   com.evolveum.midpoint.provisioning.api.ProvisioningService.synchronize
Status
   FATAL_ERROR
Message
   java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor


There are no errors on the Errors tab.


The Progress tab has the usual stuff, and this:

Last error when processing object
   SystemException: could not execute batch


The task settings are:

Recurring task: yes
Tightly bound: no
Schedule interval: 60 seconds
Schedule cron-line specification: <none>
Do not start before: <none>
Do not start after: <none>
Misfire action: Execute immediately
Thread stop action: Restart


The midpoint.log file has the database error in it.  It ends with:

2018-08-11 00:08:13,416 [] [midPointScheduler_Worker-2] INFO (com.evolveum.midpoint.task.quartzimpl.execution.JobExecutor): Task encountered permanent error, suspending the task. Task = Task(id:1532454439530-0-1, name:GYBONID LiveSync, oid:5283f927-87aa-4493-96e0-e886867a8627)
2018-08-11 00:08:13,417 [] [midPointScheduler_Worker-2] INFO (com.evolveum.midpoint.task.quartzimpl.TaskManagerQuartzImpl): Suspending tasks [Task(id:1532454439530-0-1, name:GYBONID LiveSync, oid:5283f927-87aa-4493-96e0-e886867a8627)]; do not stop tasks.


Generally, the database is back online after a few hours.  Is there a way 
I can get the livesync task to keep trying?

Thanks,

Andy Morgan
Systems Administrator, Identity & Access Management
Information Services | Oregon State University
541-737-8877 | is.oregonstate.edu