<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hi Andy,</p>
<p>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)<br>
</p>
<p>What I know is that you can have a notification if a task
suspends because of permanent error:</p>
<p><a class="moz-txt-link-freetext" href="https://wiki.evolveum.com/display/midPoint/Task+notifications">https://wiki.evolveum.com/display/midPoint/Task+notifications</a></p>
<p>...</p>
<div class="line number11 index10 alt2"><code class="xml spaces"> </code><code
class="xml plain"><</code><code class="xml keyword">simpleTaskNotifier</code><code
class="xml plain">></code></div>
<div class="line number12 index11 alt1"><code class="xml spaces"> </code><code
class="xml plain"><</code><code class="xml keyword">operation</code><code
class="xml plain">>delete</</code><code class="xml
keyword">operation</code><code class="xml plain">> </code><code
class="xml comments"><!-- DELETE means finishing task handler
execution --></code></div>
<div class="line number13 index12 alt2"><code class="xml spaces"> </code><code
class="xml plain"><</code><code class="xml keyword">category</code><code
class="xml plain">>taskEvent</</code><code class="xml
keyword">category</code><code class="xml plain">></code></div>
<div class="line number14 index13 alt1"><code class="xml spaces"> </code><code
class="xml plain"><</code><code class="xml keyword">expressionFilter</code><code
class="xml plain">></code></div>
<div class="line number15 index14 alt2"><code class="xml spaces"> </code><code
class="xml plain"><</code><code class="xml keyword">script</code><code
class="xml plain">> </code><code
class="xml comments"><!-- any situation that results in the
task being suspended --></code></div>
<div class="line number16 index15 alt1"><code class="xml spaces"> </code><code
class="xml plain"><</code><code class="xml keyword">code</code><code
class="xml plain">>event.isPermanentError()</</code><code
class="xml keyword">code</code><code class="xml plain">></code></div>
<div class="line number17 index16 alt2"><code class="xml spaces"> </code><code
class="xml plain"></</code><code class="xml keyword">script</code><code
class="xml plain">></code></div>
<div class="line number18 index17 alt1"><code class="xml spaces"> </code><code
class="xml plain"></</code><code class="xml keyword">expressionFilter</code><code
class="xml plain">></code></div>
<div class="line number19 index18 alt2"><code class="xml spaces"> </code><code
class="xml plain"><</code><code class="xml keyword">transport</code><code
class="xml plain">>sms</</code><code class="xml keyword">transport</code><code
class="xml plain">></code></div>
<div class="line number20 index19 alt1"><code class="xml spaces"> </code><code
class="xml plain"></</code><code class="xml keyword">simpleTaskNotifier</code><code
class="xml plain">><br>
...<br>
</code></div>
<p>The example is not specific to Livesync task.</p>
<p>Hope this helps, at least until a real answer to your question
arrives.</p>
<p>Best regards,</p>
<p>Ivan<br>
</p>
<br>
<div class="moz-cite-prefix">On 22.08.2018 02:40, Andrew Morgan
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:alpine.DEB.2.11.1808211729110.839@shell.onid.oregonstate.edu">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.
<br>
<br>
The Results tab of the task shows these 2 lines:
<br>
<br>
Token
<br>
1000000000001518137
<br>
Operation
<br>
com.evolveum.midpoint.common.operation.liveSync
<br>
Status
<br>
FATAL_ERROR
<br>
Message
<br>
Internal Error: java.sql.SQLException: Listener refused the
connection with the following error:
<br>
ORA-12514, TNS:listener does not currently know of service
requested in connect descriptor
<br>
<br>
Token
<br>
1000000000001518138
<br>
Operation
<br>
com.evolveum.midpoint.provisioning.api.ProvisioningService.synchronize
<br>
Status
<br>
FATAL_ERROR
<br>
Message
<br>
java.sql.SQLException: Listener refused the connection with the
following error:
<br>
ORA-12514, TNS:listener does not currently know of service
requested in connect descriptor
<br>
<br>
<br>
There are no errors on the Errors tab.
<br>
<br>
<br>
The Progress tab has the usual stuff, and this:
<br>
<br>
Last error when processing object
<br>
SystemException: could not execute batch
<br>
<br>
<br>
The task settings are:
<br>
<br>
Recurring task: yes
<br>
Tightly bound: no
<br>
Schedule interval: 60 seconds
<br>
Schedule cron-line specification: <none>
<br>
Do not start before: <none>
<br>
Do not start after: <none>
<br>
Misfire action: Execute immediately
<br>
Thread stop action: Restart
<br>
<br>
<br>
The midpoint.log file has the database error in it. It ends with:
<br>
<br>
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)
<br>
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.
<br>
<br>
<br>
Generally, the database is back online after a few hours. Is
there a way I can get the livesync task to keep trying?
<br>
<br>
Thanks,
<br>
<br>
Andy Morgan
<br>
Systems Administrator, Identity & Access Management
<br>
Information Services | Oregon State University
<br>
541-737-8877 | is.oregonstate.edu
<br>
_______________________________________________
<br>
midPoint mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a>
<br>
<a class="moz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
<br>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Ivan Noris
Senior Identity Engineer
evolveum.com
</pre>
</body>
</html>