It turned out that on Ubuntu, MySQL table names are case sensitive. The syncope database has a table qrtz_locks - notice syncope is looking for QRTZ_LOCKS. I tried renaming the table to upper case, and the error went away.
Now I got another error. Syncope is looking for QRTZ_JOB_DETAILS, but the syncope database does not have that table, either in lower case or upper case. My syncope database has 118 tables. On 2016-08-24 13:41 (-0500), "Cam Luc"<[email protected]> wrote: > 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] > >
