Hi John, Can you share the configs? So that we can reproduce locally and see. We need 1) dbs file 2) synapse configs 3) ESB version you are using 4) sample excel file(if you can share) In iterator mediator if you do requests within that mediator, those may get hit DSS parallaly( or may be not in order you send them to DSS) May be issue is something like that. So if that happens, all the requests will be successful, but some may be overwritten.
Thanks, On Thu, Sep 17, 2015 at 11:35 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 > > -- Rajith Vitharana Software Engineer, WSO2 Inc. : wso2.com Mobile : +94715883223 Blog : http://lankavitharana.blogspot.com/
_______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
