[midPoint] livesync task error causes suspend

[Ivan Noris]

Hi Andy,

not sure if this is directly possible, but I hope someone else will
know. (I assume everything can be done using hooks, but I have no
experience with that yet)

What I know is that you can have a notification if a task suspends
because of permanent error:

https://wiki.evolveum.com/display/midPoint/Task+notifications

...

|        ||<||simpleTaskNotifier||>|
|            ||<||operation||>delete</||operation||>    ||<!-- DELETE
means finishing task handler execution -->|
|            ||<||category||>taskEvent</||category||>|
|            ||<||expressionFilter||>|
|                ||<||script||>                     ||<!-- any situation
that results in the task being suspended -->|
|                    ||<||code||>event.isPermanentError()</||code||>|
|                ||</||script||>|
|            ||</||expressionFilter||>|
|            ||<||transport||>sms</||transport||>|
|        ||</||simpleTaskNotifier||>
...
|

The example is not specific to Livesync task.

Hope this helps, at least until a real answer to your question arrives.

Best regards,

Ivan


On 22.08.2018 02:40, Andrew Morgan wrote:
> 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
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com
> http://lists.evolveum.com/mailman/listinfo/midpoint

-- 
Ivan Noris
Senior Identity Engineer
evolveum.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20180822/eb08a18a/attachment.htm>