The DSS version is 3.2.2 and the excel file is a .xls (97-2004)... On Thu, Sep 17, 2015 at 2:05 PM, Madhawa Gunasekara <[email protected]> wrote:
> Hi John, > > Can you specify the DSS version please ? > Are you using .xlsx format excel file for this scenario ? > > Thanks > Madhawa > > On Thu, Sep 17, 2015 at 10:05 PM, John Q <[email protected]> wrote: > >> Hello everybody, >> I´m working on a data service that writes some data to an excel file and >> it works fine when I try it on the DSS (Data Service Server). Now I am >> invoking the service from the ESB and I´m having some issues: >> >> From the ESB I am invoking the excel service inside an iterate mediator, >> all those calls are SUCCESS because after invoking the service, I´m logging >> the response and I can see it was SUCCES, also I can see the SUCCESS event >> on the soap tracer inside the DSS, it seems like everything it´s ok, but, >> when I see the excel file, only one row was created (each service execution >> creates a row) and when I invoke again the proxy service in the ESB, I get >> this error in the DSS >> >> Nested Exception:- >> >> DS Fault Message: Error in opening DBMS connection. >> >> DS Code: UNKNOWN_ERROR >> >> Nested Exception:- >> >> java.sql.SQLException: Error occurred while initializing the EXCEL >> datasource >> >> >> >> at >> org.wso2.carbon.dataservices.core.description.query.SQLQuery.processPreNormalQuery(SQLQuery.java:832) >> >> at >> org.wso2.carbon.dataservices.core.description.query.SQLQuery.runPreQuery(SQLQuery.java:2301) >> >> at >> org.wso2.carbon.dataservices.core.description.query.Query.execute(Query.java:275) >> >> at >> org.wso2.carbon.dataservices.core.engine.CallQuery.executeElement(CallQuery.java:188) >> >> at >> org.wso2.carbon.dataservices.core.engine.OutputElement.execute(OutputElement.java:89) >> >> at >> org.wso2.carbon.dataservices.core.description.operation.Operation.execute(Operation.java:61) >> >> at >> org.wso2.carbon.dataservices.core.engine.DataService.invoke(DataService.java:474) >> >> at >> org.wso2.carbon.dataservices.core.engine.DSOMDataSource.execute(DSOMDataSource.java:96) >> >> ... 46 more >> >> Caused by: DS Fault Message: Error in opening DBMS connection. >> >> DS Code: UNKNOWN_ERROR >> >> Nested Exception:- >> >> java.sql.SQLException: Error occurred while initializing the EXCEL >> datasource >> >> >> at >> org.wso2.carbon.dataservices.core.description.query.SQLQuery.createConnection(SQLQuery.java:752) >> >> at >> org.wso2.carbon.dataservices.core.description.query.SQLQuery.processPreNormalQuery(SQLQuery.java:805) >> >> ... 53 more >> >> Caused by: java.sql.SQLException: Error occurred while initializing the >> EXCEL datasource >> >> at >> org.wso2.carbon.dataservices.sql.driver.TExcelConnection.createConnectionToExcelDocument(TExcelConnection.java:56) >> >> at >> org.wso2.carbon.dataservices.sql.driver.TExcelConnection.<init>(TExcelConnection.java:36) >> >> at >> org.wso2.carbon.dataservices.sql.driver.TConnectionFactory.createConnection(TConnectionFactory.java:32) >> >> at >> org.wso2.carbon.dataservices.sql.driver.TDriver.connect(TDriver.java:50) >> >> 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:128) >> >> at >> org.wso2.carbon.dataservices.core.description.config.SQLConfig.createConnection(SQLConfig.java:188) >> >> at >> org.wso2.carbon.dataservices.core.description.query.SQLQuery.createConnection(SQLQuery.java:728) >> >> ... 54 more >> >> Caused by: java.io.IOException: Unable to read entire header; 0 bytes >> read; expected 512 bytes >> >> at >> org.apache.poi.poifs.storage.HeaderBlock.alertShortRead(HeaderBlock.java:226) >> >> at >> org.apache.poi.poifs.storage.HeaderBlock.readFirst512(HeaderBlock.java:207) >> >> at org.apache.poi.poifs.storage.HeaderBlock.<init>(HeaderBlock.java:104) >> >> at >> org.apache.poi.poifs.filesystem.POIFSFileSystem.<init>(POIFSFileSystem.java:138) >> >> at >> org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:322) >> >> at >> org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:303) >> >> at >> org.wso2.carbon.dataservices.sql.driver.TExcelConnection.createConnectionToExcelDocument(TExcelConnection.java:51) >> >> ... 65 more >> >> CAN ANYBODY HELP ME? >> >> >> thanks and best regards, >> >> >> _______________________________________________ >> Architecture mailing list >> [email protected] >> https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture >> >> > > > -- > *Madhawa Gunasekara* > Software Engineer > WSO2 Inc.; http://wso2.com > lean.enterprise.middleware > > mobile: +94 719411002 <+94+719411002> > blog: *http://madhawa-gunasekara.blogspot.com > <http://madhawa-gunasekara.blogspot.com>* > linkedin: *http://lk.linkedin.com/in/mgunasekara > <http://lk.linkedin.com/in/mgunasekara>* >
_______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
