Hi Matteo,
please find the scripts attached to this email.
Thank you again!
Best Regards,
Sergio Muriel
------------------------------------------------------------------------
*From:* Matteo Alessandroni <skylar...@apache.org>
*Sent:* Friday, September 15, 2017 2:25 AM
*To:* user@syncope.apache.org
*Subject:*
Hi Sergio,
could please add the "SakaiUserSearchScript.groovy" too?
I need to see whether the "eid" field is set correctly and does always
return a value that will be mapped to "username".
Regards,
Matteo
On 2017-09-14 18:20, Sergio Muriel <sergio...@hotmail.com> wrote:
> Hi Matteo,
>
> please find the screenshots attached to this email.
>
>
> Thank you in advance!
>
>
> PD: If is not pictured then values are by default.
>
> Best Regards,
> Sergio Muriel
>
>
> ________________________________
> From: Matteo Alessandroni <matteo.alessandr...@tirasa.net>
> Sent: Thursday, September 14, 2017 2:23 AM
> To: user@syncope.apache.org
> Subject: Re: Scripted SQL Pull Task Error
>
> Hi Sergio,
>
> At this point could you please attach a screenshot of your mapping
and also the Connector and Resource configuration?
>
> Regards,
> Matteo
>
> On 14/09/2017 00:02, Sergio Muriel wrote:
>
> Hi Matteo,
>
> * "username" is mapped in my resource. The "Purpose" column for
"username" is set to the icon with both pull and push arrows. (That is
Sync, I believe).
> * All users have a valid non blank username value. Indeed, I
checked with a query, and it has been checked also by Sakai itself.
>
> So far I have the same problem. This is what the logs say:
>
> core-persistence.log shows this for each user creation attempt:
> 16:29:19.947 WARN
org.apache.syncope.core.persistence.jpa.validation.entity.EntityValidationListener
- Bean validation errors found:
[ConstraintViolationImpl{rootBean=JPAUser[null],
propertyPath='username', message='Blank username',
leafBean=JPAUser[null], value=null}]
>
>
> core.log shows this for each user creation attempt:
> 16:26:28.884 ERROR
org.apache.syncope.core.provisioning.api.pushpull.SyncopeResultHandler
- Could not create USER f84440b0-3cc7-4d83-ae02-951c81faf2e22
>
org.apache.syncope.core.persistence.api.attrvalue.validation.InvalidEntityException:
JPAUser [Standard]
> at
org.apache.syncope.core.persistence.jpa.validation.entity.EntityValidationListener.validate(EntityValidationListener.java:73)
~[syncope-core-persistence-jpa-2.0.4.jar:2.0.4]
> at sun.reflect.GeneratedMethodAccessor517.invoke(Unknown Source) ~[?:?]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
~[?:1.8.0_71]
> at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_71]
> at
org.apache.openjpa.event.BeanLifecycleCallbacks.makeCallback(BeanLifecycleCallbacks.java:85)
~[openjpa-kernel-2.4.2.jar:2.4.2]
> at
org.apache.openjpa.persistence.PersistenceListenerAdapter.makeCallback(PersistenceListenerAdapter.java:71)
~[openjpa-persistence-2.4.2.jar:2.4.2]
> at
org.apache.openjpa.persistence.PersistenceListenerAdapter.beforePersist(PersistenceListenerAdapter.java:85)
~[openjpa-persistence-2.4.2.jar:2.4.2]
> at
org.apache.openjpa.event.LifecycleEventManager.fireEvent(LifecycleEventManager.java:404)
~[openjpa-kernel-2.4.2.jar:2.4.2]
> at
org.apache.openjpa.event.LifecycleEventManager.fireEvent(LifecycleEventManager.java:308)
~[openjpa-kernel-2.4.2.jar:2.4.2]
> at
org.apache.openjpa.kernel.BrokerImpl.fireLifecycleEvent(BrokerImpl.java:814)
~[openjpa-kernel-2.4.2.jar:2.4.2]
> at
org.apache.openjpa.kernel.VersionAttachStrategy.attach(VersionAttachStrategy.java:140)
~[openjpa-kernel-2.4.2.jar:2.4.2]
> at
org.apache.openjpa.kernel.AttachManager.attach(AttachManager.java:252)
~[openjpa-kernel-2.4.2.jar:2.4.2]
> at
org.apache.openjpa.kernel.AttachManager.attach(AttachManager.java:105)
~[openjpa-kernel-2.4.2.jar:2.4.2]
> at org.apache.openjpa.kernel.BrokerImpl.attach(BrokerImpl.java:3508)
~[openjpa-kernel-2.4.2.jar:2.4.2]
> at
org.apache.openjpa.kernel.DelegatingBroker.attach(DelegatingBroker.java:1213)
~[openjpa-kernel-2.4.2.jar:2.4.2]
> at
org.apache.openjpa.persistence.EntityManagerImpl.merge(EntityManagerImpl.java:879)
~[openjpa-persistence-2.4.2.jar:2.4.2]
> at
org.apache.syncope.core.persistence.jpa.dao.AbstractAnyDAO.save(AbstractAnyDAO.java:543)
~[syncope-core-persistence-jpa-2.0.4.jar:2.0.4]
> at
org.apache.syncope.core.persistence.jpa.dao.JPAUserDAO.save(JPAUserDAO.java:437)
~[syncope-core-persistence-jpa-2.0.4.jar:2.0.4]
> at
org.apache.syncope.core.persistence.jpa.dao.JPAUserDAO.save(JPAUserDAO.java:84)
~[syncope-core-persistence-jpa-2.0.4.jar:2.0.4]
> at sun.reflect.GeneratedMethodAccessor527.invoke(Unknown Source) ~[?:?]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
~[?:1.8.0_71]
> at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_71]
> at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
~[spring-aop-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
~[spring-aop-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at com.sun.proxy.$Proxy85.save(Unknown Source) ~[?:?]
> at
org.apache.syncope.core.workflow.java.DefaultUserWorkflowAdapter.doCreate(DefaultUserWorkflowAdapter.java:84)
~[syncope-core-workflow-java-2.0.4.jar:2.0.4]
> at
org.apache.syncope.core.workflow.java.AbstractUserWorkflowAdapter.create(AbstractUserWorkflowAdapter.java:91)
~[syncope-core-workflow-java-2.0.4.jar:2.0.4]
> at sun.reflect.GeneratedMethodAccessor524.invoke(Unknown Source) ~[?:?]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
~[?:1.8.0_71]
> at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_71]
> at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
~[spring-aop-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
~[spring-aop-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
~[spring-aop-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
~[spring-tx-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
~[spring-tx-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
~[spring-tx-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at
org.apache.syncope.core.persistence.jpa.spring.DomainTransactionInterceptor.invoke(DomainTransactionInterceptor.java:64)
~[syncope-core-persistence-jpa-2.0.4.jar:2.0.4]
> at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
~[spring-aop-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
~[spring-aop-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at com.sun.proxy.$Proxy101.create(Unknown Source) ~[?:?]
> at
org.apache.syncope.core.provisioning.java.DefaultUserProvisioningManager.create(DefaultUserProvisioningManager.java:101)
~[syncope-core-provisioning-java-2.0.4.jar:2.0.4]
> at sun.reflect.GeneratedMethodAccessor523.invoke(Unknown Source) ~[?:?]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
~[?:1.8.0_71]
> at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_71]
> at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
~[spring-aop-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
~[spring-aop-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
~[spring-aop-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
~[spring-tx-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
~[spring-tx-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
~[spring-tx-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at
org.apache.syncope.core.persistence.jpa.spring.DomainTransactionInterceptor.invoke(DomainTransactionInterceptor.java:64)
~[syncope-core-persistence-jpa-2.0.4.jar:2.0.4]
> at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
~[spring-aop-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
~[spring-aop-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at com.sun.proxy.$Proxy109.create(Unknown Source) ~[?:?]
> at
org.apache.syncope.core.provisioning.java.pushpull.UserPullResultHandlerImpl.doCreate(UserPullResultHandlerImpl.java:96)
~[syncope-core-provisioning-java-2.0.4.jar:2.0.4]
> at
org.apache.syncope.core.provisioning.java.pushpull.AbstractPullResultHandler.create(AbstractPullResultHandler.java:266)
~[syncope-core-provisioning-java-2.0.4.jar:2.0.4]
> at
org.apache.syncope.core.provisioning.java.pushpull.AbstractPullResultHandler.provision(AbstractPullResultHandler.java:231)
~[syncope-core-provisioning-java-2.0.4.jar:2.0.4]
> at
org.apache.syncope.core.provisioning.java.pushpull.AbstractPullResultHandler.doHandle(AbstractPullResultHandler.java:733)
~[syncope-core-provisioning-java-2.0.4.jar:2.0.4]
> at
org.apache.syncope.core.provisioning.java.pushpull.AbstractPullResultHandler.handle(AbstractPullResultHandler.java:130)
~[syncope-core-provisioning-java-2.0.4.jar:2.0.4]
> at sun.reflect.GeneratedMethodAccessor520.invoke(Unknown Source) ~[?:?]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
~[?:1.8.0_71]
> at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_71]
> at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
~[spring-aop-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
~[spring-aop-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
~[spring-aop-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
~[spring-tx-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
~[spring-tx-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
~[spring-tx-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at
org.apache.syncope.core.persistence.jpa.spring.DomainTransactionInterceptor.invoke(DomainTransactionInterceptor.java:64)
~[syncope-core-persistence-jpa-2.0.4.jar:2.0.4]
> at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
~[spring-aop-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
~[spring-aop-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at com.sun.proxy.$Proxy292.handle(Unknown Source) ~[?:?]
> at
org.apache.syncope.core.provisioning.java.ConnectorFacadeProxy$1.handle(ConnectorFacadeProxy.java:355)
~[syncope-core-provisioning-java-2.0.4.jar:2.0.4]
> at
org.apache.syncope.core.provisioning.java.ConnectorFacadeProxy$2.handle(ConnectorFacadeProxy.java:448)
~[syncope-core-provisioning-java-2.0.4.jar:2.0.4]
> at
org.identityconnectors.framework.impl.api.SearchResultsHandlerLoggingProxy.handle(SearchResultsHandlerLoggingProxy.java:64)
~[connector-framework-internal-1.4.2.0.jar:?]
> at
org.identityconnectors.framework.impl.api.StreamHandlerUtil$ObjectStreamHandlerAdapter.handle(StreamHandlerUtil.java:101)
~[connector-framework-internal-1.4.2.0.jar:?]
> at
org.identityconnectors.framework.impl.api.BufferedResultsProxy.invoke(BufferedResultsProxy.java:262)
~[connector-framework-internal-1.4.2.0.jar:?]
> at
org.identityconnectors.framework.impl.api.DelegatingTimeoutProxy.invoke(DelegatingTimeoutProxy.java:94)
~[connector-framework-internal-1.4.2.0.jar:?]
> at com.sun.proxy.$Proxy294.search(Unknown Source) ~[?:?]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[?:1.8.0_71]
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
~[?:1.8.0_71]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
~[?:1.8.0_71]
> at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_71]
> at
org.identityconnectors.framework.impl.api.LoggingProxy.invoke(LoggingProxy.java:83)
~[connector-framework-internal-1.4.2.0.jar:?]
> at com.sun.proxy.$Proxy294.search(Unknown Source) ~[?:?]
> at
org.identityconnectors.framework.impl.api.AbstractConnectorFacade.search(AbstractConnectorFacade.java:178)
~[connector-framework-internal-1.4.2.0.jar:?]
> at
org.apache.syncope.core.provisioning.java.ConnectorFacadeProxy.search(ConnectorFacadeProxy.java:436)
~[syncope-core-provisioning-java-2.0.4.jar:2.0.4]
> at
org.apache.syncope.core.provisioning.java.ConnectorFacadeProxy.filteredReconciliation(ConnectorFacadeProxy.java:350)
~[syncope-core-provisioning-java-2.0.4.jar:2.0.4]
> at
org.apache.syncope.core.provisioning.java.ConnectorFacadeProxy.fullReconciliation(ConnectorFacadeProxy.java:339)
~[syncope-core-provisioning-java-2.0.4.jar:2.0.4]
> at
org.apache.syncope.core.provisioning.java.pushpull.PullJobDelegate.doExecuteProvisioning(PullJobDelegate.java:278)
~[syncope-core-provisioning-java-2.0.4.jar:2.0.4]
> at
org.apache.syncope.core.provisioning.java.pushpull.PullJobDelegate.doExecuteProvisioning(PullJobDelegate.java:60)
~[syncope-core-provisioning-java-2.0.4.jar:2.0.4]
> at
org.apache.syncope.core.provisioning.java.pushpull.AbstractProvisioningJobDelegate.doExecute(AbstractProvisioningJobDelegate.java:558)
~[syncope-core-provisioning-java-2.0.4.jar:2.0.4]
> at
org.apache.syncope.core.provisioning.java.job.AbstractSchedTaskJobDelegate.execute(AbstractSchedTaskJobDelegate.java:96)
~[syncope-core-provisioning-java-2.0.4.jar:2.0.4]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[?:1.8.0_71]
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
~[?:1.8.0_71]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
~[?:1.8.0_71]
> at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_71]
> at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
~[spring-aop-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
~[spring-aop-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
~[spring-aop-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
~[spring-tx-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
~[spring-tx-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
~[spring-tx-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at
org.apache.syncope.core.persistence.jpa.spring.DomainTransactionInterceptor.invoke(DomainTransactionInterceptor.java:64)
~[syncope-core-persistence-jpa-2.0.4.jar:2.0.4]
> at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
~[spring-aop-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
~[spring-aop-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at com.sun.proxy.$Proxy290.execute(Unknown Source) ~[?:?]
> at
org.apache.syncope.core.provisioning.java.job.TaskJob$1.exec(TaskJob.java:80)
~[syncope-core-provisioning-java-2.0.4.jar:2.0.4]
> at
org.apache.syncope.core.provisioning.java.job.TaskJob$1.exec(TaskJob.java:70)
~[syncope-core-provisioning-java-2.0.4.jar:2.0.4]
> at
org.apache.syncope.core.spring.security.AuthContextUtils.execWithAuthContext(AuthContextUtils.java:136)
~[syncope-core-spring-2.0.4.jar:2.0.4]
> at
org.apache.syncope.core.provisioning.java.job.TaskJob.execute(TaskJob.java:69)
~[syncope-core-provisioning-java-2.0.4.jar:2.0.4]
> at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
~[quartz-2.3.0.jar:?]
> at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
~[quartz-2.3.0.jar:?]
>
> enduser.log shows this from the beginning:
> 15:48:44.384 ERROR
org.apache.syncope.client.enduser.init.ClassPathScanImplementationLookup
- Could not find annotation
org.apache.syncope.client.enduser.annotations.Resource in
org.apache.syncope.client.enduser.resources.CaptchaResource, ignoring
>
> console.log shows this:
> 16:24:49.743 ERROR
org.apache.wicket.protocol.ws.javax.WicketEndpoint - An error occurred
in web socket connection with id : 1
> java.io.IOException: java.io.IOException: An established connection
was aborted by the software in your host machine
> at
org.apache.tomcat.websocket.WsRemoteEndpointImplBase.sendMessageBlock(WsRemoteEndpointImplBase.java:315)
~[tomcat-websocket.jar:8.5.16]
> at
org.apache.tomcat.websocket.WsRemoteEndpointImplBase.sendMessageBlock(WsRemoteEndpointImplBase.java:258)
~[tomcat-websocket.jar:8.5.16]
> at
org.apache.tomcat.websocket.WsSession.sendCloseMessage(WsSession.java:592)
~[tomcat-websocket.jar:8.5.16]
> at org.apache.tomcat.websocket.WsSession.onClose(WsSession.java:512)
~[tomcat-websocket.jar:8.5.16]
> at
org.apache.tomcat.websocket.WsFrameBase.processDataControl(WsFrameBase.java:347)
~[tomcat-websocket.jar:8.5.16]
> at
org.apache.tomcat.websocket.WsFrameBase.processData(WsFrameBase.java:289)
~[tomcat-websocket.jar:8.5.16]
> at
org.apache.tomcat.websocket.WsFrameBase.processInputBuffer(WsFrameBase.java:133)
~[tomcat-websocket.jar:8.5.16]
> at
org.apache.tomcat.websocket.server.WsFrameServer.onDataAvailable(WsFrameServer.java:82)
~[tomcat-websocket.jar:8.5.16]
> at
org.apache.tomcat.websocket.server.WsFrameServer.doOnDataAvailable(WsFrameServer.java:171)
~[tomcat-websocket.jar:8.5.16]
> at
org.apache.tomcat.websocket.server.WsFrameServer.notifyDataAvailable(WsFrameServer.java:151)
~[tomcat-websocket.jar:8.5.16]
> at
org.apache.tomcat.websocket.server.WsHttpUpgradeHandler.upgradeDispatch(WsHttpUpgradeHandler.java:148)
~[tomcat-websocket.jar:8.5.16]
> at
org.apache.coyote.http11.upgrade.UpgradeProcessorInternal.dispatch(UpgradeProcessorInternal.java:54)
~[tomcat-coyote.jar:8.5.16]
> at
org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:53)
~[tomcat-coyote.jar:8.5.16]
> at
org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
~[tomcat-coyote.jar:8.5.16]
> at
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
~[tomcat-coyote.jar:8.5.16]
> at
org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
~[tomcat-coyote.jar:8.5.16]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[?:1.8.0_71]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
Source) [?:1.8.0_71]
> at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
~[tomcat-util.jar:8.5.16]
> at java.lang.Thread.run(Unknown Source) [?:1.8.0_71]
> Caused by: java.io.IOException: An established connection was
aborted by the software in your host machine
> at sun.nio.ch.SocketDispatcher.write0(Native Method) ~[?:1.8.0_71]
> at sun.nio.ch.SocketDispatcher.write(Unknown Source) ~[?:1.8.0_71]
> at sun.nio.ch.IOUtil.writeFromNativeBuffer(Unknown Source) ~[?:1.8.0_71]
> at sun.nio.ch.IOUtil.write(Unknown Source) ~[?:1.8.0_71]
> at sun.nio.ch.SocketChannelImpl.write(Unknown Source) ~[?:1.8.0_71]
> at org.apache.tomcat.util.net.NioChannel.write(NioChannel.java:134)
~[tomcat-coyote.jar:8.5.16]
> at
org.apache.tomcat.util.net.NioBlockingSelector.write(NioBlockingSelector.java:101)
~[tomcat-coyote.jar:8.5.16]
> at
org.apache.tomcat.util.net.NioSelectorPool.write(NioSelectorPool.java:157)
~[tomcat-coyote.jar:8.5.16]
> at
org.apache.tomcat.util.net.NioEndpoint$NioSocketWrapper.doWrite(NioEndpoint.java:1259)
~[tomcat-coyote.jar:8.5.16]
> at
org.apache.tomcat.util.net.SocketWrapperBase.doWrite(SocketWrapperBase.java:670)
~[tomcat-coyote.jar:8.5.16]
> at
org.apache.tomcat.util.net.SocketWrapperBase.flushBlocking(SocketWrapperBase.java:607)
~[tomcat-coyote.jar:8.5.16]
> at
org.apache.tomcat.util.net.SocketWrapperBase.flush(SocketWrapperBase.java:597)
~[tomcat-coyote.jar:8.5.16]
> at
org.apache.tomcat.websocket.server.WsRemoteEndpointImplServer.doWrite(WsRemoteEndpointImplServer.java:95)
~[tomcat-websocket.jar:8.5.16]
> at
org.apache.tomcat.websocket.WsRemoteEndpointImplBase.writeMessagePart(WsRemoteEndpointImplBase.java:494)
~[tomcat-websocket.jar:8.5.16]
> at
org.apache.tomcat.websocket.WsRemoteEndpointImplBase.sendMessageBlock(WsRemoteEndpointImplBase.java:309)
~[tomcat-websocket.jar:8.5.16]
> ... 19 more
>
>
> Finally, core-connid.log shows this once in a while:
> 16:15:08.888 DEBUG Exception: Method: schema
> java.lang.UnsupportedOperationException: SCHEMA script executor is
null. Problem loading Schema script
> at
net.tirasa.connid.bundles.db.scriptedsql.ScriptedSQLConnector.schema(ScriptedSQLConnector.java:356)
~[?:?]
> at
org.identityconnectors.framework.impl.api.local.operations.SchemaImpl.schema(SchemaImpl.java:59)
~[connector-framework-internal-1.4.2.0.jar:?]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[?:1.8.0_71]
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
~[?:1.8.0_71]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
~[?:1.8.0_71]
> at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_71]
> at
org.identityconnectors.framework.impl.api.local.operations.ConnectorAPIOperationRunnerProxy.invoke(ConnectorAPIOperationRunnerProxy.java:98)
~[connector-framework-internal-1.4.2.0.jar:?]
> at com.sun.proxy.$Proxy278.schema(Unknown Source) ~[?:?]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[?:1.8.0_71]
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
~[?:1.8.0_71]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
~[?:1.8.0_71]
> at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_71]
> at
org.identityconnectors.framework.impl.api.local.operations.ThreadClassLoaderManagerProxy.invoke(ThreadClassLoaderManagerProxy.java:96)
~[connector-framework-internal-1.4.2.0.jar:?]
> at com.sun.proxy.$Proxy278.schema(Unknown Source) ~[?:?]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[?:1.8.0_71]
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
~[?:1.8.0_71]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
~[?:1.8.0_71]
> at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_71]
> at
org.identityconnectors.framework.impl.api.DelegatingTimeoutProxy.invoke(DelegatingTimeoutProxy.java:99)
~[connector-framework-internal-1.4.2.0.jar:?]
> at com.sun.proxy.$Proxy278.schema(Unknown Source) ~[?:?]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[?:1.8.0_71]
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
~[?:1.8.0_71]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
~[?:1.8.0_71]
> at java.lang.reflect.Method.invoke(Unknown Source) ~[?:1.8.0_71]
> at
org.identityconnectors.framework.impl.api.LoggingProxy.invoke(LoggingProxy.java:83)
~[connector-framework-internal-1.4.2.0.jar:?]
> at com.sun.proxy.$Proxy278.schema(Unknown Source) ~[?:?]
> at
org.identityconnectors.framework.impl.api.AbstractConnectorFacade.schema(AbstractConnectorFacade.java:145)
~[connector-framework-internal-1.4.2.0.jar:?]
> at
org.apache.syncope.core.provisioning.java.AsyncConnectorFacade.getObjectClassInfo(AsyncConnectorFacade.java:112)
~[syncope-core-provisioning-java-2.0.4.jar:2.0.4]
> at
org.apache.syncope.core.provisioning.java.AsyncConnectorFacade$$FastClassBySpringCGLIB$$886ae36a.invoke(<generated>)
~[syncope-core-provisioning-java-2.0.4.jar:2.0.4]
> at
org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
~[spring-core-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at
org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)
~[spring-aop-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
~[spring-aop-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at
org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:115)
~[spring-aop-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> at java.util.concurrent.FutureTask.run(Unknown Source) ~[?:1.8.0_71]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[?:1.8.0_71]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
Source) [?:1.8.0_71]
> at java.lang.Thread.run(Unknown Source) [?:1.8.0_71]
>
>
>
> Help is very appreciated!
>
>
> Best Regards,
> Sergio Muriel
>
>
> ________________________________
> From: Matteo Alessandroni
<skylar...@apache.org><mailto:skylar...@apache.org>
> Sent: Wednesday, September 13, 2017 4:23 AM
> To: user@syncope.apache.org<mailto:user@syncope.apache.org>
> Subject: Re: Scripted SQL Pull Task Error
>
> Hi Sergio,
>
> There could be 2 possibilities for that error:
> - there is no mapping for "username" in your resource "Edit
Provision Rules" section or there is an incorrect mapping (e.g.
"Purpose" column for "username" is set not to handle synchronization);
> - one or more users in your external resource do not have a
"username" value (it is blank) and Syncope requires it.
> Please check those things and let me know.
>
> Regards,
> Matteo
>
> On 2017-09-13 02:53, Sergio Muriel
<sergio...@hotmail.com><mailto:sergio...@hotmail.com> wrote:
> > Hi everyone,
> >
> > following the advise from Francesco I decided to connect to my
Sakai LMS instance starting from the given scripts at
> >
> >
https://github.com/Tirasa/ConnIdDBBundle/tree/master/scriptedsql/src/main/resources/samples
<https://github.com/Tirasa/ConnIdDBBundle/tree/master/scriptedsql/src/main/resources/samples>
Tirasa/ConnIdDBBundle
<https://github.com/Tirasa/ConnIdDBBundle/tree/master/scriptedsql/src/main/resources/samples>
github.com
ConnIdDBBundle - ConnId: DB bundle
>
> >
> >
> > I'm trying to pull the users from there, so I customized both the
Sync and Search scripts (because the user info is not in a single
table). I run the pull task and I can see the running task icon
spinning for several minutes (Dashboard, control tab); however, when
it stops spinning I get no new users but a message like this for each
user in my core-persistence.log:
> >
> >
> > 18:43:19.304 WARN
org.apache.syncope.core.persistence.jpa.validation.entity.EntityValidationListener
- Bean validation errors found:
[ConstraintViolationImpl{rootBean=JPAUser[null],
propertyPath='username', message='Blank username',
leafBean=JPAUser[null], value=null}]
> >
> >
> > What I find weird, is that I do see that most of the users have
username attribute (in core-connid.log), like this one:
> >
> >
> > 18:43:13.858 DEBUG Enter: {Uid=Attribute: {Name=__UID__,
Value=[5165468435165165165165]}, ObjectClass=ObjectClass: __ACCOUNT__,
Attributes=[Attribute: {Name=lastname, Value=[Register]}, Attribute:
{Name=username, Value=[a...@123.org<mailto:a...@123.org>]}, Attribute:
{Name=__NAME__, Value=[a...@123.org<mailto:a...@123.org>]}, Attribute:
{Name=firstname, Value=[Scott]}, Attribute: {Name=__UID__,
Value=[5165468435165165165165]}, Attribute: {Name=email,
Value=[a...@123.org<mailto:a...@123.org>]}], Name=Attribute:
{Name=__NAME__, Value=[a...@123.org<mailto:a...@123.org>]}} Method: handle
> >
> > It should at least load the ones that are correct. Am I right?
> >
> >
> > Thank you for the help!
> >
> > Best Regards,
> > Sergio Muriel
> >
>
>