[midPoint] ScriptedSQL Reconciliation
Dilek Gider
dilek.gider at basistek.com
Thu Jan 5 09:57:56 CET 2017
Hi,
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?
I had an error with task type "Reconciliation" -->
"UnsupportedOperationException" as below:
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
java.lang.UnsupportedOperationException: null
at
org.forgerock.openicf.misc.scriptedcommon.ScriptedConnector.executeQuery(ScriptedConnector.java:414)
~[na:na]
at
org.forgerock.openicf.misc.scriptedcommon.ScriptedConnector.executeQuery(ScriptedConnector.java:80)
~[na:na]
at
org.identityconnectors.framework.impl.api.local.operations.SearchImpl.rawSearch(SearchImpl.java:171)
~[connector-framework-internal-1.4.2.16.jar:na]
at
org.identityconnectors.framework.impl.api.local.operations.SearchImpl.search(SearchImpl.java:130)
~[connector-framework-internal-1.4.2.16.jar:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.8.0_101]
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
~[na:1.8.0_101]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
~[na:1.8.0_101]
at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_101]
at
org.identityconnectors.framework.impl.api.local.operations.ConnectorAPIOperationRunnerProxy.invoke(ConnectorAPIOperationRunnerProxy.java:98)
~[connector-framework-internal-1.4.2.16.jar:na]
at com.sun.proxy.$Proxy169.search(Unknown Source) ~[na:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.8.0_101]
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
~[na:1.8.0_101]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
~[na:1.8.0_101]
at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_101]
at
org.identityconnectors.framework.impl.api.local.operations.ThreadClassLoaderManagerProxy.invoke(ThreadClassLoaderManagerProxy.java:96)
~[connector-framework-internal-1.4.2.16.jar:na]
at com.sun.proxy.$Proxy169.search(Unknown Source) ~[na:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.8.0_101]
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
~[na:1.8.0_101]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
~[na:1.8.0_101]
at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_101]
at
org.identityconnectors.framework.impl.api.BufferedResultsProxy$BufferedResultsHandler.run(BufferedResultsProxy.java:165)
~[connector-framework-internal-1.4.2.16.jar:na]
2017-01-05 10:29:35,278 [] [midPointScheduler_Worker-8] ERROR
(com.evolveum.midpoint.provisioning.impl.ProvisioningServiceImpl): null
java.lang.UnsupportedOperationException: null
at
org.forgerock.openicf.misc.scriptedcommon.ScriptedConnector.executeQuery(ScriptedConnector.java:414)
~[na:na]
at
org.forgerock.openicf.misc.scriptedcommon.ScriptedConnector.executeQuery(ScriptedConnector.java:80)
~[na:na]
at
org.identityconnectors.framework.impl.api.local.operations.SearchImpl.rawSearch(SearchImpl.java:171)
~[connector-framework-internal-1.4.2.16.jar:na]
at
org.identityconnectors.framework.impl.api.local.operations.SearchImpl.search(SearchImpl.java:130)
~[connector-framework-internal-1.4.2.16.jar:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.8.0_101]
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
~[na:1.8.0_101]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
~[na:1.8.0_101]
at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_101]
at
org.identityconnectors.framework.impl.api.local.operations.ConnectorAPIOperationRunnerProxy.invoke(ConnectorAPIOperationRunnerProxy.java:98)
~[connector-framework-internal-1.4.2.16.jar:na]
at com.sun.proxy.$Proxy169.search(Unknown Source) ~[na:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.8.0_101]
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
~[na:1.8.0_101]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
~[na:1.8.0_101]
at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_101]
at
org.identityconnectors.framework.impl.api.local.operations.ThreadClassLoaderManagerProxy.invoke(ThreadClassLoaderManagerProxy.java:96)
~[connector-framework-internal-1.4.2.16.jar:na]
at com.sun.proxy.$Proxy169.search(Unknown Source) ~[na:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.8.0_101]
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
~[na:1.8.0_101]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
~[na:1.8.0_101]
at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_101]
at
org.identityconnectors.framework.impl.api.BufferedResultsProxy$BufferedResultsHandler.run(BufferedResultsProxy.java:165)
~[connector-framework-internal-1.4.2.16.jar:na]
2017-01-05 10:29:35,280 [] [midPointScheduler_Worker-8] ERROR
(com.evolveum.midpoint.model.impl.sync.ReconciliationTaskHandler):
Reconciliation: Internal Error: null
java.lang.UnsupportedOperationException: null
at
org.forgerock.openicf.misc.scriptedcommon.ScriptedConnector.executeQuery(ScriptedConnector.java:414)
~[na:na]
at
org.forgerock.openicf.misc.scriptedcommon.ScriptedConnector.executeQuery(ScriptedConnector.java:80)
~[na:na]
at
org.identityconnectors.framework.impl.api.local.operations.SearchImpl.rawSearch(SearchImpl.java:171)
~[connector-framework-internal-1.4.2.16.jar:na]
at
org.identityconnectors.framework.impl.api.local.operations.SearchImpl.search(SearchImpl.java:130)
~[connector-framework-internal-1.4.2.16.jar:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.8.0_101]
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
~[na:1.8.0_101]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
~[na:1.8.0_101]
at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_101]
at
org.identityconnectors.framework.impl.api.local.operations.ConnectorAPIOperationRunnerProxy.invoke(ConnectorAPIOperationRunnerProxy.java:98)
~[connector-framework-internal-1.4.2.16.jar:na]
at com.sun.proxy.$Proxy169.search(Unknown Source) ~[na:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.8.0_101]
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
~[na:1.8.0_101]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
~[na:1.8.0_101]
at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_101]
at
org.identityconnectors.framework.impl.api.local.operations.ThreadClassLoaderManagerProxy.invoke(ThreadClassLoaderManagerProxy.java:96)
~[connector-framework-internal-1.4.2.16.jar:na]
at com.sun.proxy.$Proxy169.search(Unknown Source) ~[na:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.8.0_101]
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
~[na:1.8.0_101]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
~[na:1.8.0_101]
at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_101]
at
org.identityconnectors.framework.impl.api.BufferedResultsProxy$BufferedResultsHandler.run(BufferedResultsProxy.java:165)
~[connector-framework-internal-1.4.2.16.jar:na]
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
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
java.lang.OutOfMemoryError: GC overhead limit exceeded
at
com.sun.org.apache.xerces.internal.dom.DeferredDocumentImpl.createChunk(Unknown
Source) ~[na:1.8.0_101]
at
com.sun.org.apache.xerces.internal.dom.DeferredDocumentImpl.ensureCapacity(Unknown
Source) ~[na:1.8.0_101]
at
com.sun.org.apache.xerces.internal.dom.DeferredDocumentImpl.createNode(Unknown
Source) ~[na:1.8.0_101]
at
com.sun.org.apache.xerces.internal.dom.DeferredDocumentImpl.createDeferredTextNode(Unknown
Source) ~[na:1.8.0_101]
at
com.sun.org.apache.xerces.internal.parsers.AbstractDOMParser.characters(Unknown
Source) ~[na:1.8.0_101]
at
com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown
Source) ~[na:1.8.0_101]
at
com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown
Source) ~[na:1.8.0_101]
at
com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown
Source) ~[na:1.8.0_101]
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown
Source) ~[na:1.8.0_101]
at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(Unknown
Source) ~[na:1.8.0_101]
at
com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(Unknown
Source) ~[na:1.8.0_101]
at javax.xml.parsers.DocumentBuilder.parse(Unknown Source) ~[na:1.8.0_101]
at com.evolveum.midpoint.util.DOMUtil.parseDocument(DOMUtil.java:226)
~[util-3.4.1.jar:na]
at com.evolveum.midpoint.prism.parser.DomParser.parse(DomParser.java:112)
~[prism-3.4.1.jar:na]
at
com.evolveum.midpoint.prism.PrismContext.parseObject(PrismContext.java:249)
~[prism-3.4.1.jar:na]
at
com.evolveum.midpoint.repo.sql.helpers.ObjectRetriever.updateLoadedObject(ObjectRetriever.java:455)
~[repo-sql-impl-3.4.1.jar:na]
at
com.evolveum.midpoint.repo.sql.helpers.ObjectRetriever.getObjectInternal(ObjectRetriever.java:216)
~[repo-sql-impl-3.4.1.jar:na]
at
com.evolveum.midpoint.repo.sql.helpers.ObjectRetriever.getObjectAttempt(ObjectRetriever.java:119)
~[repo-sql-impl-3.4.1.jar:na]
at
com.evolveum.midpoint.repo.sql.SqlRepositoryServiceImpl.getObject(SqlRepositoryServiceImpl.java:146)
~[repo-sql-impl-3.4.1.jar:na]
at
com.evolveum.midpoint.repo.cache.RepositoryCache.getObject(RepositoryCache.java:121)
~[repo-cache-3.4.1.jar:na]
at
com.evolveum.midpoint.provisioning.impl.ProvisioningServiceImpl.getObject(ProvisioningServiceImpl.java:175)
~[provisioning-impl-3.4.1.jar:na]
at
com.evolveum.midpoint.model.impl.ModelObjectResolver.getObject(ModelObjectResolver.java:157)
~[model-impl-3.4.1.jar:na]
at
com.evolveum.midpoint.model.impl.controller.ModelController.getObject(ModelController.java:240)
~[model-impl-3.4.1.jar:na]
at sun.reflect.GeneratedMethodAccessor462.invoke(Unknown Source) ~[na:na]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
~[na:1.8.0_101]
at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_101]
at
org.apache.wicket.proxy.LazyInitProxyFactory$JdkHandler.invoke(LazyInitProxyFactory.java:507)
~[wicket-ioc-7.3.0.jar:7.3.0]
at com.sun.proxy.$Proxy148.getObject(Unknown Source) ~[na:na]
at
com.evolveum.midpoint.gui.api.util.WebModelServiceUtils.loadObject(WebModelServiceUtils.java:238)
~[classes/:na]
at
com.evolveum.midpoint.gui.api.util.WebModelServiceUtils.resolveReferenceRaw(WebModelServiceUtils.java:120)
~[classes/:na]
at
com.evolveum.midpoint.gui.api.util.WebModelServiceUtils.resolveReferenceName(WebModelServiceUtils.java:94)
~[classes/:na]
at
com.evolveum.midpoint.web.page.admin.server.dto.TaskDto.getTaskObjectName(TaskDto.java:270)
~[classes/:na]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20170105/e593b82f/attachment.htm>
More information about the midPoint
mailing list