Error when synchronizing CSVDir resource

[Gurpreet Bagga <Gu...@gohomeward.com>]

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.

Re: Error when synchronizing CSVDir resource

[Francesco Chicchiriccò <il...@apache.org>]

On 08/07/2013 14:02, Gurpreet Bagga wrote:
>
> 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.
>

Hi,
please post your CSVDir connector configuration and related resource 
mapping.

What is currently happening to you is that the CSVDir connector 
configuration is malformed or missing some required parameter, hence 
temporary HSQLDB tables are just not created by the connector itself; 
this provokes the exceptions you see.

The CSVDir connector, in fact, empowers HSQLDB features for generating 
SQL tables for CSV files.

Regards.

-- 
Francesco Chicchiriccò

ASF Member, Apache Syncope PMC chair, Apache Cocoon PMC Member
http://people.apache.org/~ilgrosso/