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
>
> >
> >
> > 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
> >
>
>
