fabio martelli created SYNCOPE-235:
--------------------------------------
Summary: CSVDir connector fails during check connection
Key: SYNCOPE-235
URL: https://issues.apache.org/jira/browse/SYNCOPE-235
Project: Syncope
Issue Type: Bug
Components: console, core
Affects Versions: 1.0.4-incubating, 1.1.0
Environment: embedded
Reporter: fabio martelli
Fix For: 1.0.4-incubating, 1.1.0
Checking the csvdir connector connection via admin console I got the following
exception:
18:43:19.078 ERROR org.connid.bundles.csvdir.database.FileToDB.bindFileTables
While creating view USER_EX68673
java.sql.SQLSyntaxErrorException: object name already exists: USER_EX68673 in
statement [CREATE VIEW USER_EX68673 AS SELECT * FROM CSV_TABLE56271]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
~[hsqldb-2.2.8.jar:2.2.8]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
~[hsqldb-2.2.8.jar:2.2.8]
at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
~[hsqldb-2.2.8.jar:2.2.8]
at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
~[hsqldb-2.2.8.jar:2.2.8]
at
org.connid.bundles.csvdir.database.FileToDB.bindFileTables(FileToDB.java:119)
[org.connid.bundles.csvdir-0.5.jar:na]
at
org.connid.bundles.csvdir.database.FileToDB.createDbForSync(FileToDB.java:69)
[org.connid.bundles.csvdir-0.5.jar:na]
at
org.connid.bundles.csvdir.CSVDirConnection.allCsvFiles(CSVDirConnection.java:205)
[org.connid.bundles.csvdir-0.5.jar:na]
at
org.connid.bundles.csvdir.methods.CSVDirTest.execute(CSVDirTest.java:54)
[org.connid.bundles.csvdir-0.5.jar:na]
at
org.connid.bundles.csvdir.methods.CSVDirTest.test(CSVDirTest.java:46)
[org.connid.bundles.csvdir-0.5.jar:na]
at
org.connid.bundles.csvdir.CSVDirConnector.test(CSVDirConnector.java:274)
[org.connid.bundles.csvdir-0.5.jar:na]
at
org.identityconnectors.framework.impl.api.local.operations.TestImpl.test(TestImpl.java:47)
[framework-internal-1.3.2.jar:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.6.0_37]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
~[na:1.6.0_37]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
~[na:1.6.0_37]
at java.lang.reflect.Method.invoke(Method.java:597) ~[na:1.6.0_37]
at
org.identityconnectors.framework.impl.api.local.operations.ConnectorAPIOperationRunnerProxy.invoke(ConnectorAPIOperationRunnerProxy.java:93)
[framework-internal-1.3.2.jar:na]
at $Proxy144.test(Unknown Source) [na:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.6.0_37]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
~[na:1.6.0_37]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
~[na:1.6.0_37]
at java.lang.reflect.Method.invoke(Method.java:597) ~[na:1.6.0_37]
at
org.identityconnectors.framework.impl.api.local.operations.ThreadClassLoaderManagerProxy.invoke(ThreadClassLoaderManagerProxy.java:107)
[framework-internal-1.3.2.jar:na]
at $Proxy144.test(Unknown Source) [na:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.6.0_37]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
~[na:1.6.0_37]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
~[na:1.6.0_37]
at java.lang.reflect.Method.invoke(Method.java:597) ~[na:1.6.0_37]
at
org.identityconnectors.framework.impl.api.DelegatingTimeoutProxy.invoke(DelegatingTimeoutProxy.java:107)
[framework-internal-1.3.2.jar:na]
at $Proxy144.test(Unknown Source) [na:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.6.0_37]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
~[na:1.6.0_37]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
~[na:1.6.0_37]
at java.lang.reflect.Method.invoke(Method.java:597) ~[na:1.6.0_37]
at
org.identityconnectors.framework.impl.api.LoggingProxy.invoke(LoggingProxy.java:76)
[framework-internal-1.3.2.jar:na]
at $Proxy144.test(Unknown Source) [na:na]
at
org.identityconnectors.framework.impl.api.AbstractConnectorFacade.test(AbstractConnectorFacade.java:235)
[framework-internal-1.3.2.jar:na]
at
org.apache.syncope.core.propagation.ConnectorFacadeProxy.test(ConnectorFacadeProxy.java:477)
[ConnectorFacadeProxy.class:na]
at
org.apache.syncope.core.rest.controller.ConnInstanceController.check(ConnInstanceController.java:377)
[ConnInstanceController.class:na]
at
org.apache.syncope.core.rest.controller.ConnInstanceController$$FastClassByCGLIB$$7de89b09.invoke(<generated>)
[cglib-2.2.2.jar:na]
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
[cglib-2.2.2.jar:na]
at
org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)
[spring-aop-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
[spring-aop-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:64)
[spring-security-core-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
[spring-aop-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
[spring-tx-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
[spring-aop-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
[spring-aop-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.apache.syncope.core.rest.controller.ConnInstanceController$$EnhancerByCGLIB$$4fcb4918.check(<generated>)
[cglib-2.2.2.jar:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.6.0_37]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
~[na:1.6.0_37]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
~[na:1.6.0_37]
at java.lang.reflect.Method.invoke(Method.java:597) ~[na:1.6.0_37]
at
org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
[spring-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:436)
[spring-webmvc-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:424)
[spring-webmvc-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923)
[spring-webmvc-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)
[spring-webmvc-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
[spring-webmvc-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789)
[spring-webmvc-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
[servlet-api.jar:na]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
[servlet-api.jar:na]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
[catalina.jar:7.0.32]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
[catalina.jar:7.0.32]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
[spring-security-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
[spring-security-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
[spring-security-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
[spring-security-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
[spring-security-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
[spring-security-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
[spring-security-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
[spring-security-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
[spring-security-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
[spring-security-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
[spring-security-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
[spring-security-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
[spring-security-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
[spring-security-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:201)
[spring-security-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
[spring-security-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
[spring-security-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
[spring-security-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
[spring-security-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
[spring-security-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
[spring-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
[spring-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
[catalina.jar:7.0.32]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
[catalina.jar:7.0.32]
at
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
[spring-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
[spring-web-3.1.3.RELEASE.jar:3.1.3.RELEASE]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
[catalina.jar:7.0.32]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
[catalina.jar:7.0.32]
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
[catalina.jar:7.0.32]
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
[catalina.jar:7.0.32]
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
[catalina.jar:7.0.32]
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
[catalina.jar:7.0.32]
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
[catalina.jar:7.0.32]
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
[catalina.jar:7.0.32]
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
[catalina.jar:7.0.32]
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
[catalina.jar:7.0.32]
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)
[tomcat-coyote.jar:7.0.32]
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
[tomcat-coyote.jar:7.0.32]
at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
[tomcat-coyote.jar:7.0.32]
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
[na:1.6.0_37]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
[na:1.6.0_37]
at java.lang.Thread.run(Thread.java:680) [na:1.6.0_37]
Caused by: org.hsqldb.HsqlException: object name already exists: USER_EX68673
at org.hsqldb.error.Error.error(Unknown Source)
~[hsqldb-2.2.8.jar:2.2.8]
at org.hsqldb.error.Error.error(Unknown Source)
~[hsqldb-2.2.8.jar:2.2.8]
at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
~[hsqldb-2.2.8.jar:2.2.8]
at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
~[hsqldb-2.2.8.jar:2.2.8]
at org.hsqldb.StatementSchema.getResult(Unknown Source)
~[hsqldb-2.2.8.jar:2.2.8]
at org.hsqldb.StatementSchema.execute(Unknown Source)
~[hsqldb-2.2.8.jar:2.2.8]
at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
~[hsqldb-2.2.8.jar:2.2.8]
at org.hsqldb.Session.executeDirectStatement(Unknown Source)
~[hsqldb-2.2.8.jar:2.2.8]
at org.hsqldb.Session.execute(Unknown Source) ~[hsqldb-2.2.8.jar:2.2.8]
... 103 common frames omitted
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
