Uploaded image for project: 'ZZZ-WSO2 Data Services Server'
  1. ZZZ-WSO2 Data Services Server
  2. DS-1265

Query mode in Excel - Xlsx Dataservices do not work.

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: High
    • Resolution: Duplicate
    • Affects Version/s: 3.5.1
    • Fix Version/s: 3.5.1
    • Component/s: DataServices
    • Labels:
      None

      Description

      Enable query mode and create a data source using a Xlsx file.

      <data name="CondenserXl" transports="http https local">
         <config enableOData="false" id="CondenserXl">
            <property name="driverClassName">org.wso2.carbon.dataservices.sql.driver.TDriver</property>
            <property name="url">jdbc:wso2:excel:filePath=gov:/Condenserxls.xlsx</property>
         </config>
         <query id="QueryPriceXls" useConfig="CondenserXl">
            <sql>Select PRICE from Sheet1 where ITEM_CODE=?</sql>
            <result element="Entries" rowName="Entry">
               <element column="PRICE" name="PRICE" xsdType="string"/>
            </result>
            <param name="price" sqlType="STRING"/>
         </query>
         <operation name="getPrice">
            <call-query href="QueryPriceXls">
               <with-param name="price" query-param="price"/>
            </call-query>
         </operation>
         <resource method="GET" path="/getCondensers/{itemcode}">
            <call-query href="QueryPriceXls">
               <with-param name="price" query-param="price"/>
            </call-query>
         </resource>
      </data>
      

      Below exception will be thrown.

      
      [2017-01-18 10:55:52,407]  INFO {org.wso2.carbon.core.deployment.DeploymentInterceptor} -  Deploying Axis2 service: CondenserFile {super-tenant}
      [2017-01-18 10:55:52,613] ERROR {org.wso2.carbon.dataservices.core.DBDeployer} -  The CondenserXls.dbs service, which is not valid, caused {1}
      DS Fault Message: java.lang.reflect.InvocationTargetException
      DS Code: CONNECTION_UNAVAILABLE_ERROR
      Source Data Service:-
      Name: CondenserXls
      Location: /CondenserXls.dbs
      Description: N/A
      Default Namespace: http://ws.wso2.org/dataservice
      Nested Exception:-
      java.sql.SQLException: java.lang.reflect.InvocationTargetException
      
      	at org.wso2.carbon.dataservices.core.description.config.RDBMSConfig.<init>(RDBMSConfig.java:45)
      	at org.wso2.carbon.dataservices.core.description.config.ConfigFactory.getRDBMSConfig(ConfigFactory.java:92)
      	at org.wso2.carbon.dataservices.core.description.config.ConfigFactory.createConfig(ConfigFactory.java:60)
      	at org.wso2.carbon.dataservices.core.DataServiceFactory.createDataService(DataServiceFactory.java:159)
      	at org.wso2.carbon.dataservices.core.DBDeployer.createDBService(DBDeployer.java:797)
      	at org.wso2.carbon.dataservices.core.DBDeployer.processService(DBDeployer.java:1152)
      	at org.wso2.carbon.dataservices.core.DBDeployer.deploy(DBDeployer.java:201)
      	at org.apache.axis2.deployment.repository.util.DeploymentFileData.deploy(DeploymentFileData.java:136)
      	at org.apache.axis2.deployment.DeploymentEngine.doDeploy(DeploymentEngine.java:807)
      	at org.apache.axis2.deployment.repository.util.WSInfoList.update(WSInfoList.java:144)
      	at org.apache.axis2.deployment.RepositoryListener.update(RepositoryListener.java:377)
      	at org.apache.axis2.deployment.RepositoryListener.checkServices(RepositoryListener.java:254)
      	at org.apache.axis2.deployment.DeploymentEngine.loadServices(DeploymentEngine.java:135)
      	at org.wso2.carbon.core.CarbonAxisConfigurator.deployServices(CarbonAxisConfigurator.java:567)
      	at org.wso2.carbon.core.internal.DeploymentServerStartupObserver.completingServerStartup(DeploymentServerStartupObserver.java:51)
      	at org.wso2.carbon.core.internal.CarbonCoreServiceComponent.notifyBefore(CarbonCoreServiceComponent.java:238)
      	at org.wso2.carbon.core.internal.StartupFinalizerServiceComponent.completeInitialization(StartupFinalizerServiceComponent.java:185)
      	at org.wso2.carbon.core.internal.StartupFinalizerServiceComponent.serviceChanged(StartupFinalizerServiceComponent.java:288)
      	at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:107)
      	at org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(BundleContextImpl.java:861)
      	at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230)
      	at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148)
      	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:819)
      	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:771)
      	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:130)
      	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:214)
      	at org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(BundleContextImpl.java:433)
      	at org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(BundleContextImpl.java:451)
      	at org.wso2.carbon.throttling.agent.internal.ThrottlingAgentServiceComponent.registerThrottlingAgent(ThrottlingAgentServiceComponent.java:123)
      	at org.wso2.carbon.throttling.agent.internal.ThrottlingAgentServiceComponent.activate(ThrottlingAgentServiceComponent.java:100)
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:497)
      	at org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:260)
      	at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:146)
      	at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:345)
      	at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:620)
      	at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:197)
      	at org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolver.java:343)
      	at org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SCRManager.java:222)
      	at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:107)
      	at org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(BundleContextImpl.java:861)
      	at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230)
      	at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148)
      	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:819)
      	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:771)
      	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:130)
      	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:214)
      	at org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(BundleContextImpl.java:433)
      	at org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(BundleContextImpl.java:451)
      	at org.wso2.carbon.core.init.CarbonServerManager.initializeCarbon(CarbonServerManager.java:514)
      	at org.wso2.carbon.core.init.CarbonServerManager.start(CarbonServerManager.java:219)
      	at org.wso2.carbon.core.internal.CarbonCoreServiceComponent.activate(CarbonCoreServiceComponent.java:94)
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:497)
      	at org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:260)
      	at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:146)
      	at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:345)
      	at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:620)
      	at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:197)
      	at org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolver.java:343)
      	at org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SCRManager.java:222)
      	at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:107)
      	at org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(BundleContextImpl.java:861)
      	at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230)
      	at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148)
      	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:819)
      	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:771)
      	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:130)
      	at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:214)
      	at org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(BundleContextImpl.java:433)
      	at org.eclipse.equinox.http.servlet.internal.Activator.registerHttpService(Activator.java:81)
      	at org.eclipse.equinox.http.servlet.internal.Activator.addProxyServlet(Activator.java:60)
      	at org.eclipse.equinox.http.servlet.internal.ProxyServlet.init(ProxyServlet.java:40)
      	at org.wso2.carbon.tomcat.ext.servlet.DelegationServlet.init(DelegationServlet.java:38)
      	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1282)
      	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1195)
      	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1085)
      	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5349)
      	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5641)
      	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
      	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1571)
      	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1561)
      	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      	at java.lang.Thread.run(Thread.java:745)
      Caused by: java.sql.SQLException: java.lang.reflect.InvocationTargetException
      	at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:290)
      	at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
      	at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:701)
      	at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:635)
      	at org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:188)
      	at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:127)
      	at org.wso2.carbon.dataservices.core.description.config.SQLConfig.createConnection(SQLConfig.java:187)
      	at org.wso2.carbon.dataservices.core.description.config.SQLConfig.createConnection(SQLConfig.java:172)
      	at org.wso2.carbon.dataservices.core.description.config.SQLConfig.initSQLDataSource(SQLConfig.java:150)
      	at org.wso2.carbon.dataservices.core.description.config.RDBMSConfig.<init>(RDBMSConfig.java:43)
      	... 89 more
      Caused by: org.apache.poi.POIXMLException: java.lang.reflect.InvocationTargetException
      	at org.apache.poi.POIXMLFactory.createDocumentPart(POIXMLFactory.java:65)
      	at org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:601)
      	at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:174)
      	at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:249)
      	at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:211)
      	at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:170)
      	at org.wso2.carbon.dataservices.sql.driver.TExcelConnection.createConnectionToExcelDocument(TExcelConnection.java:74)
      	at org.wso2.carbon.dataservices.sql.driver.TExcelConnection.<init>(TExcelConnection.java:58)
      	at org.wso2.carbon.dataservices.sql.driver.TConnectionFactory.createConnection(TConnectionFactory.java:32)
      	at org.wso2.carbon.dataservices.sql.driver.TDriver.connect(TDriver.java:51)
      	at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278)
      	... 98 more
      Caused by: java.lang.reflect.InvocationTargetException
      	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
      	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      	at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
      	at org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:56)
      	at org.apache.poi.POIXMLFactory.createDocumentPart(POIXMLFactory.java:62)
      	... 108 more
      Caused by: java.lang.NoSuchMethodError: org.apache.xmlbeans.XmlOptions.setLoadEntityBytesLimit(I)Lorg/apache/xmlbeans/XmlOptions;
      	at org.apache.poi.POIXMLTypeLoader.<clinit>(POIXMLTypeLoader.java:50)
      	at org.apache.poi.xssf.model.StylesTable.readFrom(StylesTable.java:203)
      	at org.apache.poi.xssf.model.StylesTable.<init>(StylesTable.java:146)
      	... 114 more
      [2017-01-18 10:55:52,923]  INFO {org.wso2.carbon.core.deployment.DeploymentInterceptor} -  Deploying Axis2 service: ElectronicsDS {super-tenant}
      [2017-01-18 10:55:52,945]  INFO {org.apache.tomcat.util.net.NioSelectorPool} -  Using a shared selector for servlet write/read
      [2017-01-18 10:55:54,190]  INFO {org.apache.tomcat.util.net.NioSelectorPool} -  Using a shared selector for servlet write/read
      [2017-01-18 10:55:54,669]  INFO {org.wso2.carbon.ntask.core.service.impl.TaskServiceImpl} -  Task service starting in STANDALONE mode...
      [2017-01-18 10:55:54,745]  INFO {org.wso2.carbon.core.init.JMXServerManager} -  JMX Service URL  : service:jmx:rmi://localhost:11111/jndi/rmi://localhost:9999/jmxrmi
      [2017-01-18 10:55:54,800]  INFO {org.wso2.carbon.core.internal.StartupFinalizerServiceComponent} -  Server           :  WSO2 Data Services Server-3.5.1
      [2017-01-18 10:55:54,801]  INFO {org.wso2.carbon.core.internal.StartupFinalizerServiceComponent} -  WSO2 Carbon started in 23 sec
      [2017-01-18 10:55:55,181]  INFO {org.wso2.carbon.ui.internal.CarbonUIServiceComponent} -  Mgt Console URL  : https://192.168.124.1:9443/carbon/
      [2017-01-18 10:57:12,623] ERROR {org.wso2.carbon.dataservices.core.DBDeployer} -  The CondenserXls.dbs service, which is not valid, caused {1}
      DS Fault Message: Error acquiring lock for the excel file even after 20 second wait, filePath - gov:/Condenserxls.xlsx
      DS Code: CONNECTION_UNAVAILABLE_ERROR
      Source Data Service:-
      Name: CondenserXls
      Location: /CondenserXls.dbs
      Description: N/A
      Default Namespace: http://ws.wso2.org/dataservice
      Nested Exception:-
      java.sql.SQLException: Error acquiring lock for the excel file even after 20 second wait, filePath - gov:/Condenserxls.xlsx
      
      	at org.wso2.carbon.dataservices.core.description.config.RDBMSConfig.<init>(RDBMSConfig.java:45)
      	at org.wso2.carbon.dataservices.core.description.config.ConfigFactory.getRDBMSConfig(ConfigFactory.java:92)
      	at org.wso2.carbon.dataservices.core.description.config.ConfigFactory.createConfig(ConfigFactory.java:60)
      	at org.wso2.carbon.dataservices.core.DataServiceFactory.createDataService(DataServiceFactory.java:159)
      	at org.wso2.carbon.dataservices.core.DBDeployer.createDBService(DBDeployer.java:797)
      	at org.wso2.carbon.dataservices.core.DBDeployer.processService(DBDeployer.java:1152)
      	at org.wso2.carbon.dataservices.core.DBDeployer.deploy(DBDeployer.java:201)
      	at org.wso2.carbon.dataservices.core.FaultyServiceRectifier.run(FaultyServiceRectifier.java:110)
      	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
      	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
      	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
      	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      	at java.lang.Thread.run(Thread.java:745)
      Caused by: java.sql.SQLException: Error acquiring lock for the excel file even after 20 second wait, filePath - gov:/Condenserxls.xlsx
      	at org.wso2.carbon.dataservices.sql.driver.TExcelConnection.acquireLock(TExcelConnection.java:99)
      	at org.wso2.carbon.dataservices.sql.driver.TExcelConnection.createConnectionToExcelDocument(TExcelConnection.java:72)
      	at org.wso2.carbon.dataservices.sql.driver.TExcelConnection.<init>(TExcelConnection.java:58)
      	at org.wso2.carbon.dataservices.sql.driver.TConnectionFactory.createConnection(TConnectionFactory.java:32)
      	at org.wso2.carbon.dataservices.sql.driver.TDriver.connect(TDriver.java:51)
      	at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278)
      	at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
      	at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:701)
      	at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:635)
      	at org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:188)
      	at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:127)
      	at org.wso2.carbon.dataservices.core.description.config.SQLConfig.createConnection(SQLConfig.java:187)
      	at org.wso2.carbon.dataservices.core.description.config.SQLConfig.createConnection(SQLConfig.java:172)
      	at org.wso2.carbon.dataservices.core.description.config.SQLConfig.initSQLDataSource(SQLConfig.java:150)
      	at org.wso2.carbon.dataservices.core.description.config.RDBMSConfig.<init>(RDBMSConfig.java:43)
      	... 14 more
      [2017-01-18 10:57:12,624] ERROR {org.wso2.carbon.dataservices.core.FaultyServiceRectifier} -  Error in faulty service rectifier
      org.apache.axis2.deployment.DeploymentException: The CondenserXls.dbs service, which is not valid, caused {1}
      	at org.wso2.carbon.dataservices.core.DBDeployer.deploy(DBDeployer.java:249)
      	at org.wso2.carbon.dataservices.core.FaultyServiceRectifier.run(FaultyServiceRectifier.java:110)
      	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
      	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
      	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
      	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      	at java.lang.Thread.run(Thread.java:745)
      Caused by: DS Fault Message: Error acquiring lock for the excel file even after 20 second wait, filePath - gov:/Condenserxls.xlsx
      DS Code: CONNECTION_UNAVAILABLE_ERROR
      Source Data Service:-
      Name: CondenserXls
      Location: /CondenserXls.dbs
      Description: N/A
      Default Namespace: http://ws.wso2.org/dataservice
      Nested Exception:-
      java.sql.SQLException: Error acquiring lock for the excel file even after 20 second wait, filePath - gov:/Condenserxls.xlsx
      
      	at org.wso2.carbon.dataservices.core.description.config.RDBMSConfig.<init>(RDBMSConfig.java:45)
      	at org.wso2.carbon.dataservices.core.description.config.ConfigFactory.getRDBMSConfig(ConfigFactory.java:92)
      	at org.wso2.carbon.dataservices.core.description.config.ConfigFactory.createConfig(ConfigFactory.java:60)
      	at org.wso2.carbon.dataservices.core.DataServiceFactory.createDataService(DataServiceFactory.java:159)
      	at org.wso2.carbon.dataservices.core.DBDeployer.createDBService(DBDeployer.java:797)
      	at org.wso2.carbon.dataservices.core.DBDeployer.processService(DBDeployer.java:1152)
      	at org.wso2.carbon.dataservices.core.DBDeployer.deploy(DBDeployer.java:201)
      	... 8 more
      Caused by: java.sql.SQLException: Error acquiring lock for the excel file even after 20 second wait, filePath - gov:/Condenserxls.xlsx
      	at org.wso2.carbon.dataservices.sql.driver.TExcelConnection.acquireLock(TExcelConnection.java:99)
      	at org.wso2.carbon.dataservices.sql.driver.TExcelConnection.createConnectionToExcelDocument(TExcelConnection.java:72)
      	at org.wso2.carbon.dataservices.sql.driver.TExcelConnection.<init>(TExcelConnection.java:58)
      	at org.wso2.carbon.dataservices.sql.driver.TConnectionFactory.createConnection(TConnectionFactory.java:32)
      	at org.wso2.carbon.dataservices.sql.driver.TDriver.connect(TDriver.java:51)
      	at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278)
      	at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
      	at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:701)
      	at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:635)
      	at org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:188)
      	at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:127)
      	at org.wso2.carbon.dataservices.core.description.config.SQLConfig.createConnection(SQLConfig.java:187)
      	at org.wso2.carbon.dataservices.core.description.config.SQLConfig.createConnection(SQLConfig.java:172)
      	at org.wso2.carbon.dataservices.core.description.config.SQLConfig.initSQLDataSource(SQLConfig.java:150)
      	at org.wso2.carbon.dataservices.core.description.config.RDBMSConfig.<init>(RDBMSConfig.java:43)
      	... 14 more
      
      

        Attachments

          Activity

            People

            • Assignee:
              anupama@wso2.com Anupama Pathirage
              Reporter:
              ushani@wso2.com Ushani Balasooriya
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: