Hi All,
When I try to synchronize task with a CSVDir recource; a failure gets reported
with below stacktrace (I hope its not a compatibility issue of Hibernate with
HSQLDB, as per
http://stackoverflow.com/questions/3805478/internal-hsql-database-complains-about-privileges
). Please if you can help.
org.quartz.JobExecutionException: While syncing on connector [See nested
exception:
org.identityconnectors.framework.common.exceptions.ConnectorException:
org.identityconnectors.framework.common.exceptions.ConnectorIOException:
java.lang.IllegalStateException: java.sql.SQLSyntaxErrorException: user lacks
privilege or object not found: USER_EX70236]
at
org.apache.syncope.core.sync.impl.SyncJob.executeWithSecurityContext(SyncJob.java:434)
at
org.apache.syncope.core.sync.impl.SyncJob.doExecute(SyncJob.java:341)
at
org.apache.syncope.core.quartz.AbstractTaskJob.execute(AbstractTaskJob.java:104)
at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)
Caused by:
org.identityconnectors.framework.common.exceptions.ConnectorException:
org.identityconnectors.framework.common.exceptions.ConnectorIOException:
java.lang.IllegalStateException: java.sql.SQLSyntaxErrorException: user lacks
privilege or object not found: USER_EX70236
at
org.connid.bundles.csvdir.methods.CSVDirExecuteQuery.execute(CSVDirExecuteQuery.java:83)
at
org.connid.bundles.csvdir.CSVDirConnector.executeQuery(CSVDirConnector.java:127)
at
org.connid.bundles.csvdir.CSVDirConnector.executeQuery(CSVDirConnector.java:71)
at
org.identityconnectors.framework.impl.api.local.operations.SearchImpl.rawSearch(SearchImpl.java:105)
at
org.identityconnectors.framework.impl.api.local.operations.SearchImpl.search(SearchImpl.java:82)
at sun.reflect.GeneratedMethodAccessor1160.invoke(Unknown
Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.identityconnectors.framework.impl.api.local.operations.ConnectorAPIOperationRunnerProxy.invoke(ConnectorAPIOperationRunnerProxy.java:93)
at $Proxy339.search(Unknown Source)
at sun.reflect.GeneratedMethodAccessor1160.invoke(Unknown
Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.identityconnectors.framework.impl.api.local.operations.ThreadClassLoaderManagerProxy.invoke(ThreadClassLoaderManagerProxy.java:100)
at $Proxy339.search(Unknown Source)
at sun.reflect.GeneratedMethodAccessor1160.invoke(Unknown
Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.identityconnectors.framework.impl.api.BufferedResultsProxy$BufferedResultsHandler.run(BufferedResultsProxy.java:162)
Caused by:
org.identityconnectors.framework.common.exceptions.ConnectorIOException:
java.lang.IllegalStateException: java.sql.SQLSyntaxErrorException: user lacks
privilege or object not found: USER_EX70236
at
org.connid.bundles.csvdir.methods.CSVDirExecuteQuery.executeImpl(CSVDirExecuteQuery.java:131)
at
org.connid.bundles.csvdir.methods.CSVDirExecuteQuery.execute(CSVDirExecuteQuery.java:80)
... 18 more
Caused by: java.lang.IllegalStateException: java.sql.SQLSyntaxErrorException:
user lacks privilege or object not found: USER_EX70236
at
org.connid.bundles.csvdir.CSVDirConnection.allCsvFiles(CSVDirConnection.java:234)
at
org.connid.bundles.csvdir.methods.CSVDirExecuteQuery.executeImpl(CSVDirExecuteQuery.java:121)
... 19 more
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not
found: USER_EX70236
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown
Source)
at
org.connid.bundles.csvdir.CSVDirConnection.allCsvFiles(CSVDirConnection.java:225)
... 20 more
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found:
USER_EX70236
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.SchemaManager.getTable(Unknown Source)
at org.hsqldb.ParserDQL.readTableName(Unknown Source)
at org.hsqldb.ParserDQL.readTableOrSubquery(Unknown Source)
at org.hsqldb.ParserDQL.XreadTableReference(Unknown Source)
at org.hsqldb.ParserDQL.XreadFromClause(Unknown Source)
at org.hsqldb.ParserDQL.XreadTableExpression(Unknown Source)
at org.hsqldb.ParserDQL.XreadQuerySpecification(Unknown Source)
at org.hsqldb.ParserDQL.XreadSimpleTable(Unknown Source)
at org.hsqldb.ParserDQL.XreadQueryPrimary(Unknown Source)
at org.hsqldb.ParserDQL.XreadQueryTerm(Unknown Source)
at org.hsqldb.ParserDQL.XreadQueryExpressionBody(Unknown Source)
at org.hsqldb.ParserDQL.XreadQueryExpression(Unknown Source)
at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown
Source)
at org.hsqldb.ParserCommand.compilePart(Unknown Source)
at org.hsqldb.ParserCommand.compileStatement(Unknown Source)
at org.hsqldb.Session.compileStatement(Unknown Source)
at org.hsqldb.StatementManager.compile(Unknown Source)
at org.hsqldb.Session.execute(Unknown Source)
... 23 more
Thanks.
Gurpreet
NOTICE: This email message is for the sole use of the intended recipient(s)
and may contain confidential and privileged information. Any unauthorized
review, use, disclosure or distribution is prohibited. If you are not the
intended recipient, please contact the sender by reply email and destroy all
copies of the original message.
This message has been content scanned by the Axway MailGate.
MailGate uses policy enforcement to scan for known viruses, spam, undesirable
content and malicious code. For more information on Axway products please visit
www.axway.com.
