<div dir="ltr">Hi,<div><br></div><div>Can I use ScriptedSQL Connector with task type "Reconciliation" instead "Live Syncronization"? I tried this, but got error. If it is possible, is there any trick on the configuration?</div><div><br></div><div>I had an error with task type "Reconciliation" --> "UnsupportedOperationException" as below:</div><div><br></div><div><div>2017-01-05 10:29:35,276 [] [midPointScheduler_Worker-8] ERROR (com.evolveum.midpoint.provisioning.ucf.impl.IcfUtil): ICF Exception java.lang.UnsupportedOperationException in connector:447d1b4d-577f-40be-b986-924bf3921ce1(ICF org.forgerock.openicf.connectors.scriptedsql.ScriptedSQLConnector v1.1.2.0.em3): resource:ef2bc59b-76e0-48e2-86d6-3d4f02d420db(TirsanScriptedSQLResource): null</div><div>java.lang.UnsupportedOperationException: null</div><div><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>at org.forgerock.openicf.misc.scriptedcommon.ScriptedConnector.executeQuery(ScriptedConnector.java:414) ~[na:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">       </span>at org.forgerock.openicf.misc.scriptedcommon.ScriptedConnector.executeQuery(ScriptedConnector.java:80) ~[na:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">        </span>at org.identityconnectors.framework.impl.api.local.operations.SearchImpl.rawSearch(SearchImpl.java:171) ~[connector-framework-internal-1.4.2.16.jar:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">        </span>at org.identityconnectors.framework.impl.api.local.operations.SearchImpl.search(SearchImpl.java:130) ~[connector-framework-internal-1.4.2.16.jar:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">   </span>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>at org.identityconnectors.framework.impl.api.local.operations.ConnectorAPIOperationRunnerProxy.invoke(ConnectorAPIOperationRunnerProxy.java:98) ~[connector-framework-internal-1.4.2.16.jar:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">        </span>at com.sun.proxy.$Proxy169.search(Unknown Source) ~[na:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>at org.identityconnectors.framework.impl.api.local.operations.ThreadClassLoaderManagerProxy.invoke(ThreadClassLoaderManagerProxy.java:96) ~[connector-framework-internal-1.4.2.16.jar:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">      </span>at com.sun.proxy.$Proxy169.search(Unknown Source) ~[na:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>at org.identityconnectors.framework.impl.api.BufferedResultsProxy$BufferedResultsHandler.run(BufferedResultsProxy.java:165) ~[connector-framework-internal-1.4.2.16.jar:na]</div><div>2017-01-05 10:29:35,278 [] [midPointScheduler_Worker-8] ERROR (com.evolveum.midpoint.provisioning.impl.ProvisioningServiceImpl): null</div><div>java.lang.UnsupportedOperationException: null</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">    </span>at org.forgerock.openicf.misc.scriptedcommon.ScriptedConnector.executeQuery(ScriptedConnector.java:414) ~[na:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">       </span>at org.forgerock.openicf.misc.scriptedcommon.ScriptedConnector.executeQuery(ScriptedConnector.java:80) ~[na:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">        </span>at org.identityconnectors.framework.impl.api.local.operations.SearchImpl.rawSearch(SearchImpl.java:171) ~[connector-framework-internal-1.4.2.16.jar:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">        </span>at org.identityconnectors.framework.impl.api.local.operations.SearchImpl.search(SearchImpl.java:130) ~[connector-framework-internal-1.4.2.16.jar:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">   </span>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>at org.identityconnectors.framework.impl.api.local.operations.ConnectorAPIOperationRunnerProxy.invoke(ConnectorAPIOperationRunnerProxy.java:98) ~[connector-framework-internal-1.4.2.16.jar:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">        </span>at com.sun.proxy.$Proxy169.search(Unknown Source) ~[na:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>at org.identityconnectors.framework.impl.api.local.operations.ThreadClassLoaderManagerProxy.invoke(ThreadClassLoaderManagerProxy.java:96) ~[connector-framework-internal-1.4.2.16.jar:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">      </span>at com.sun.proxy.$Proxy169.search(Unknown Source) ~[na:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>at org.identityconnectors.framework.impl.api.BufferedResultsProxy$BufferedResultsHandler.run(BufferedResultsProxy.java:165) ~[connector-framework-internal-1.4.2.16.jar:na]</div><div>2017-01-05 10:29:35,280 [] [midPointScheduler_Worker-8] ERROR (com.evolveum.midpoint.model.impl.sync.ReconciliationTaskHandler): Reconciliation: Internal Error: null</div><div>java.lang.UnsupportedOperationException: null</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">    </span>at org.forgerock.openicf.misc.scriptedcommon.ScriptedConnector.executeQuery(ScriptedConnector.java:414) ~[na:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">       </span>at org.forgerock.openicf.misc.scriptedcommon.ScriptedConnector.executeQuery(ScriptedConnector.java:80) ~[na:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">        </span>at org.identityconnectors.framework.impl.api.local.operations.SearchImpl.rawSearch(SearchImpl.java:171) ~[connector-framework-internal-1.4.2.16.jar:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">        </span>at org.identityconnectors.framework.impl.api.local.operations.SearchImpl.search(SearchImpl.java:130) ~[connector-framework-internal-1.4.2.16.jar:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">   </span>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>at org.identityconnectors.framework.impl.api.local.operations.ConnectorAPIOperationRunnerProxy.invoke(ConnectorAPIOperationRunnerProxy.java:98) ~[connector-framework-internal-1.4.2.16.jar:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">        </span>at com.sun.proxy.$Proxy169.search(Unknown Source) ~[na:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>at org.identityconnectors.framework.impl.api.local.operations.ThreadClassLoaderManagerProxy.invoke(ThreadClassLoaderManagerProxy.java:96) ~[connector-framework-internal-1.4.2.16.jar:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">      </span>at com.sun.proxy.$Proxy169.search(Unknown Source) ~[na:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>at org.identityconnectors.framework.impl.api.BufferedResultsProxy$BufferedResultsHandler.run(BufferedResultsProxy.java:165) ~[connector-framework-internal-1.4.2.16.jar:na]</div><div>2017-01-05 10:31:56,442 [] [ClusterManagerThread] INFO (org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl): HHH000010: On release of batch it still contained JDBC statements</div><div>2017-01-05 10:32:06,756 [] [catalina-exec-5] ERROR (com.evolveum.midpoint.web.util.MidPointProfilingServletFilter): Encountered exception: java.lang.OutOfMemoryError: GC overhead limit exceeded</div><div>java.lang.OutOfMemoryError: GC overhead limit exceeded</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">  </span>at com.sun.org.apache.xerces.internal.dom.DeferredDocumentImpl.createChunk(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>at com.sun.org.apache.xerces.internal.dom.DeferredDocumentImpl.ensureCapacity(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">  </span>at com.sun.org.apache.xerces.internal.dom.DeferredDocumentImpl.createNode(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">      </span>at com.sun.org.apache.xerces.internal.dom.DeferredDocumentImpl.createDeferredTextNode(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">  </span>at com.sun.org.apache.xerces.internal.parsers.AbstractDOMParser.characters(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">  </span>at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">  </span>at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">   </span>at javax.xml.parsers.DocumentBuilder.parse(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>at com.evolveum.midpoint.util.DOMUtil.parseDocument(DOMUtil.java:226) ~[util-3.4.1.jar:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>at com.evolveum.midpoint.prism.parser.DomParser.parse(DomParser.java:112) ~[prism-3.4.1.jar:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">        </span>at com.evolveum.midpoint.prism.PrismContext.parseObject(PrismContext.java:249) ~[prism-3.4.1.jar:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">   </span>at com.evolveum.midpoint.repo.sql.helpers.ObjectRetriever.updateLoadedObject(ObjectRetriever.java:455) ~[repo-sql-impl-3.4.1.jar:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">   </span>at com.evolveum.midpoint.repo.sql.helpers.ObjectRetriever.getObjectInternal(ObjectRetriever.java:216) ~[repo-sql-impl-3.4.1.jar:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">    </span>at com.evolveum.midpoint.repo.sql.helpers.ObjectRetriever.getObjectAttempt(ObjectRetriever.java:119) ~[repo-sql-impl-3.4.1.jar:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>at com.evolveum.midpoint.repo.sql.SqlRepositoryServiceImpl.getObject(SqlRepositoryServiceImpl.java:146) ~[repo-sql-impl-3.4.1.jar:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">  </span>at com.evolveum.midpoint.repo.cache.RepositoryCache.getObject(RepositoryCache.java:121) ~[repo-cache-3.4.1.jar:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>at com.evolveum.midpoint.provisioning.impl.ProvisioningServiceImpl.getObject(ProvisioningServiceImpl.java:175) ~[provisioning-impl-3.4.1.jar:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">       </span>at com.evolveum.midpoint.model.impl.ModelObjectResolver.getObject(ModelObjectResolver.java:157) ~[model-impl-3.4.1.jar:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>at com.evolveum.midpoint.model.impl.controller.ModelController.getObject(ModelController.java:240) ~[model-impl-3.4.1.jar:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">  </span>at sun.reflect.GeneratedMethodAccessor462.invoke(Unknown Source) ~[na:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">      </span>at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_101]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>at org.apache.wicket.proxy.LazyInitProxyFactory$JdkHandler.invoke(LazyInitProxyFactory.java:507) ~[wicket-ioc-7.3.0.jar:7.3.0]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre"> </span>at com.sun.proxy.$Proxy148.getObject(Unknown Source) ~[na:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">  </span>at com.evolveum.midpoint.gui.api.util.WebModelServiceUtils.loadObject(WebModelServiceUtils.java:238) ~[classes/:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">    </span>at com.evolveum.midpoint.gui.api.util.WebModelServiceUtils.resolveReferenceRaw(WebModelServiceUtils.java:120) ~[classes/:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">   </span>at com.evolveum.midpoint.gui.api.util.WebModelServiceUtils.resolveReferenceName(WebModelServiceUtils.java:94) ~[classes/:na]</div><div><span class="gmail-Apple-tab-span" style="white-space:pre">   </span>at com.evolveum.midpoint.web.page.admin.server.dto.TaskDto.getTaskObjectName(TaskDto.java:270) ~[classes/:na]</div></div></div>