Environment: Ubuntu 16 64bit
Application server: Tomcat 8
JDK: Java 8
Syncope version: 2.0.0-M4
Syncope internal database: MySQL
I am a new user. After being able to connect MySQL as the internal storage (all
tables are created in syncope database), I created a MySQL connector, and a
Users resource. The connector and resource seem to work, as I am able to view
the users with "explore resource". But when creating a Pull task to pull users
from MySQL into Syncope, I encountered the following error:
ERROR org.apache.syncope.client.console.wizards.AjaxWizard - Wizard error on
finish
org.apache.syncope.common.lib.SyncopeClientException: Scheduling [Failure
obtaining db row lock: Table 'syncope.QRTZ_LOCKS' doesn't exist {prepstmnt
913057574 SELECT * FROM QRTZ_LOCKS WHERE SCHED_NAME = 'scheduler' AND LOCK_NAME
= ? FOR UPDATE} [code=1146, state=42S02]]
at
org.apache.syncope.common.lib.SyncopeClientException.build(SyncopeClientException.java:37)
~[syncope-common-lib-2.0.0-M4.jar:2.0.0-M4]
at
org.apache.syncope.client.lib.RestClientExceptionMapper.checkSyncopeClientCompositeException(RestClientExceptionMapper.java:147)
~[syncope-client-lib-2.0.0-M4.jar:2.0.0-M4]
at
org.apache.syncope.client.lib.RestClientExceptionMapper.fromResponse(RestClientExceptionMapper.java:58)
~[syncope-client-lib-2.0.0-M4.jar:2.0.0-M4]
at
org.apache.syncope.client.lib.RestClientExceptionMapper.fromResponse(RestClientExceptionMapper.java:42)
~[syncope-client-lib-2.0.0-M4.jar:2.0.0-M4]
at
org.apache.cxf.jaxrs.client.ClientProxyImpl.checkResponse(ClientProxyImpl.java:303)
~[cxf-rt-rs-client-3.1.6.jar:3.1.6]
at
org.apache.cxf.jaxrs.client.ClientProxyImpl.handleResponse(ClientProxyImpl.java:793)
~[cxf-rt-rs-client-3.1.6.jar:3.1.6]
at
org.apache.cxf.jaxrs.client.ClientProxyImpl.doChainedInvocation(ClientProxyImpl.java:755)
~[cxf-rt-rs-client-3.1.6.jar:3.1.6]
at
org.apache.cxf.jaxrs.client.ClientProxyImpl.invoke(ClientProxyImpl.java:228)
~[cxf-rt-rs-client-3.1.6.jar:3.1.6]
at com.sun.proxy.$Proxy237.create(Unknown Source) ~[?:?]
at
org.apache.syncope.client.console.rest.TaskRestClient.create(TaskRestClient.java:202)
~[syncope-client-console-2.0.0-M4.jar:2.0.0-M4]
at
org.apache.syncope.client.console.tasks.SchedTaskWizardBuilder.onApplyInternal(SchedTaskWizardBuilder.java:96)
~[syncope-client-console-2.0.0-M4.jar:2.0.0-M4]
at
org.apache.syncope.client.console.tasks.SchedTaskWizardBuilder.onApplyInternal(SchedTaskWizardBuilder.java:56)
~[syncope-client-console-2.0.0-M4.jar:2.0.0-M4]
at
org.apache.syncope.client.console.wizards.AjaxWizardBuilder$1.onApplyInternal(AjaxWizardBuilder.java:104)
~[syncope-client-console-2.0.0-M4.jar:2.0.0-M4]
at
org.apache.syncope.client.console.wizards.AjaxWizard.onFinish(AjaxWizard.java:182)
~[syncope-client-console-2.0.0-M4.jar:2.0.0-M4]
