<div dir="ltr">I ended up getting to the cause or at least it is working now, and for some reason it worked before with it for a year straight without fail. It was the last else statement in my sync script, I went ahead and removed it and now live sync works. The statement is below, which is 86-89 left over from the sample when I first setup the scriptedsql resource.<div><br></div><div><div><span style="white-space:pre">  </span>log.ok("Sync script: found "+result.size()+" events to sync")</div><div><span style="white-space:pre">     </span>return result;</div><div>} else { // action not implemented</div><div><span style="white-space:pre">       </span>log.error("Sync script: action '"+action+"' is not implemented in this script")</div><div><span style="white-space:pre">   </span>return null;</div><div>}</div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr">JASON</div></div></div>
<br><div class="gmail_quote">On Thu, Aug 31, 2017 at 8:00 PM, Jason Everling <span dir="ltr"><<a href="mailto:jeverling@bshp.edu" target="_blank">jeverling@bshp.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>Our sql server had crashed and the live sync task in midpoint failed because the resource was down but now I cannot get live sync to work again.</div><div><br></div><div>I have ran a full reconcile on the resource, no errors or problems, deleted the original live sync task and still get this same error. Deleted the live sync token also.</div><div><br></div><div>Any ideas, logs at trace/debug do not give any insights. I can send fresh debug logs but the logs contain student information so I would rather send off list.<br></div><div><br></div>Internal Error: Subresult com.evolveum.midpoint.provisio<wbr>ning.ucf.api.ConnectorInstance<wbr>.fetchChanges of operation com.evolveum.midpoint.provisio<wbr>ning.api.ProvisioningService.s<wbr>ynchronize is still UNKNOWN during cleanup; during handling of exception java.lang.NullPointerException<br><br>2017-08-31 19:48:31,054 [] [midPointScheduler_Worker-8] ERROR (com.evolveum.midpoint.<wbr>provisioning.impl.<wbr>ProvisioningServiceImpl): Synchronization error: unexpected problem: null<br>java.lang.<wbr>NullPointerException: null<br>    at com.evolveum.midpoint.<wbr>provisioning.ucf.impl.<wbr>ConnectorInstanceIcfImpl.<wbr>getChangesFromSyncDeltas(<wbr>ConnectorInstanceIcfImpl.java:<wbr>2541) ~[provisioning-impl-3.2.jar:<wbr>na]<br>    at com.evolveum.midpoint.<wbr>provisioning.ucf.impl.<wbr>ConnectorInstanceIcfImpl.<wbr>fetchChanges(<wbr>ConnectorInstanceIcfImpl.java:<wbr>2054) ~[provisioning-impl-3.2.jar:<wbr>na]<br>    at com.evolveum.midpoint.<wbr>provisioning.impl.<wbr>ResourceObjectConverter.<wbr>fetchChanges(<wbr>ResourceObjectConverter.java:<wbr>1458) ~[provisioning-impl-3.2.jar:<wbr>na]<br>    at com.evolveum.midpoint.<wbr>provisioning.impl.ShadowCache.<wbr>synchronize(ShadowCache.java:<wbr>1067) ~[provisioning-impl-3.2.jar:<wbr>na]<br>    at com.evolveum.midpoint.<wbr>provisioning.impl.<wbr>ProvisioningServiceImpl.<wbr>synchronize(<wbr>ProvisioningServiceImpl.java:<wbr>426) ~[provisioning-impl-3.2.jar:<wbr>na]<br>    at com.evolveum.midpoint.model.<wbr>impl.sync.LiveSyncTaskHandler.<wbr>run(LiveSyncTaskHandler.java:<wbr>187) [model-impl-3.2.jar:na]<br>    at com.evolveum.midpoint.task.<wbr>quartzimpl.execution.<wbr>JobExecutor.executeHandler(<wbr>JobExecutor.java:479) [task-quartz-impl-3.2.jar:na]<br>    at com.evolveum.midpoint.task.<wbr>quartzimpl.execution.<wbr>JobExecutor.<wbr>executeRecurrentTask(<wbr>JobExecutor.java:359) [task-quartz-impl-3.2.jar:na]<br>    at com.evolveum.midpoint.task.<wbr>quartzimpl.execution.<wbr>JobExecutor.execute(<wbr>JobExecutor.java:162) [task-quartz-impl-3.2.jar:na]<br>    at org.quartz.core.JobRunShell.<wbr>run(JobRunShell.java:213) [quartz-2.1.3.jar:na]<br>    at org.quartz.simpl.<wbr>SimpleThreadPool$WorkerThread.<wbr>run(SimpleThreadPool.java:557) [quartz-2.1.3.jar:na]<br>2017-08-31 19:48:31,055 [] [midPointScheduler_Worker-8] ERROR (com.evolveum.midpoint.model.<wbr>impl.sync.LiveSyncTaskHandler)<wbr>: Live Sync: Internal Error:<br>java.lang.<wbr>IllegalStateException: Subresult com.evolveum.midpoint.<wbr>provisioning.ucf.api.<wbr>ConnectorInstance.fetchChanges of operation com.evolveum.midpoint.<wbr>provisioning.api.<wbr>ProvisioningService.<wbr>synchronize is still UNKNOWN during cleanup; during handling of exception java.lang.NullPointerException<br>    at com.evolveum.midpoint.schema.<wbr>result.OperationResult.<wbr>cleanupResult(OperationResult.<wbr>java:1274) ~[schema-3.2.jar:na]<br>    at com.evolveum.midpoint.<wbr>provisioning.util.<wbr>ProvisioningUtil.<wbr>recordFatalError(<wbr>ProvisioningUtil.java:419) ~[provisioning-impl-3.2.jar:<wbr>na]<br>    at com.evolveum.midpoint.<wbr>provisioning.impl.<wbr>ProvisioningServiceImpl.<wbr>synchronize(<wbr>ProvisioningServiceImpl.java:<wbr>452) ~[provisioning-impl-3.2.jar:<wbr>na]<br>    at com.evolveum.midpoint.model.<wbr>impl.sync.LiveSyncTaskHandler.<wbr>run(LiveSyncTaskHandler.java:<wbr>187) ~[model-impl-3.2.jar:na]<br>    at com.evolveum.midpoint.task.<wbr>quartzimpl.execution.<wbr>JobExecutor.executeHandler(<wbr>JobExecutor.java:479) [task-quartz-impl-3.2.jar:na]<br>    at com.evolveum.midpoint.task.<wbr>quartzimpl.execution.<wbr>JobExecutor.<wbr>executeRecurrentTask(<wbr>JobExecutor.java:359) [task-quartz-impl-3.2.jar:na]<br>    at com.evolveum.midpoint.task.<wbr>quartzimpl.execution.<wbr>JobExecutor.execute(<wbr>JobExecutor.java:162) [task-quartz-impl-3.2.jar:na]<br>    at org.quartz.core.JobRunShell.<wbr>run(JobRunShell.java:213) [quartz-2.1.3.jar:na]<br>    at org.quartz.simpl.<wbr>SimpleThreadPool$WorkerThread.<wbr>run(SimpleThreadPool.java:557) [quartz-2.1.3.jar:na]<br>Caused by: java.lang.<wbr>NullPointerException: null<br>    at com.evolveum.midpoint.<wbr>provisioning.ucf.impl.<wbr>ConnectorInstanceIcfImpl.<wbr>getChangesFromSyncDeltas(<wbr>ConnectorInstanceIcfImpl.java:<wbr>2541) ~[provisioning-impl-3.2.jar:<wbr>na]<br>    at com.evolveum.midpoint.<wbr>provisioning.ucf.impl.<wbr>ConnectorInstanceIcfImpl.<wbr>fetchChanges(<wbr>ConnectorInstanceIcfImpl.java:<wbr>2054) ~[provisioning-impl-3.2.jar:<wbr>na]<br>    at com.evolveum.midpoint.<wbr>provisioning.impl.<wbr>ResourceObjectConverter.<wbr>fetchChanges(<wbr>ResourceObjectConverter.java:<wbr>1458) ~[provisioning-impl-3.2.jar:<wbr>na]<br>    at com.evolveum.midpoint.<wbr>provisioning.impl.ShadowCache.<wbr>synchronize(ShadowCache.java:<wbr>1067) ~[provisioning-impl-3.2.jar:<wbr>na]<br>    at com.evolveum.midpoint.<wbr>provisioning.impl.<wbr>ProvisioningServiceImpl.<wbr>synchronize(<wbr>ProvisioningServiceImpl.java:<wbr>426) ~[provisioning-impl-3.2.jar:<wbr>na]<br>    ... 6 common frames omitted<span class="HOEnZb"><font color="#888888"><br><div><br></div><div><br></div><div><br clear="all"><div><div class="m_-5047824744693584695gmail-m_-4567626858474616940gmail_signature"><div dir="ltr">JASON</div></div></div>
</div></font></span></div>
</blockquote></div><br></div></div>