[
https://issues.apache.org/jira/browse/SYNCOPE-235?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Francesco Chicchiriccò resolved SYNCOPE-235.
--------------------------------------------
Resolution: Not A Problem
This is not Syncope's issue but ConnId CSVDir connector bundle: opened [1] for
this.
https://code.google.com/p/connid/issues/detail?id=54
> 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, 1.1.0
> Environment: embedded
> Reporter: fabio martelli
> Fix For: 1.0.4, 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
