You can translate the question and the replies:

Error when testing a soap service with SOAPUI

The following error is recevied when testing the SOAP service. Incidentally the same view was successfully used for a REST service. <soapenv:Fault> <faultcode>soapenv:Server.generalException</faultcode> <faultstring/> <detail> <ns1:Get_shipmentsException xmlns:ns1="http://com/denodo/webservice/i_shipments_soap"> <ns1:data/> <ns1:error> <ns1:item> <ns1:errorCode>50001</ns1:errorCode> <ns1:errorMessage>Error executing query. Total time 3.985 seconds. QUERY [PROJECTION] [ERROR] QUERY [SELECTION] [ERROR] I_SHIPMENTS [PROJECTION] [ERROR] I_SHIPMENTS [PROJECTION] [ERROR] MTP_SHIPMENTS_U_LIMS [PROJECTION] [ERROR] MTP_SHIPMENTS_U_LIMS [UNION] [ERROR] I_MTP_SHIPMENTS [PROJECTION] [ERROR] I_MTP_SHIPMENTS [PROJECTION] [ERROR] MTP_SHIPMENTS_SAP [PROJECTION] [ERROR] MTP_SHIPMENTS_SAP [JOIN] [ERROR] ZXSNSHIPH [BASE] [ERROR] ZXSNSHIPH [CUSTOM WRAPPER] [ERROR] Received exception with message 'Error running wrapper: null'</ns1:errorMessage> </ns1:item> <ns1:item> <ns1:errorCode>1</ns1:errorCode> <ns1:errorMessage>QUERY [PROJECTION] [ERROR]</ns1:errorMessage> </ns1:item>
user
25-04-2017 16:11:49 -0400

3 Answers

Hi, I would review the Virtual DataPort logs, which are located at <DENODO_HOME>\logs\vdp for more details on the error. The error you are experiencing is not due to the web service but it is coming from a custom wrapper that you could have created manually. Custom wrappers are ad-hoc wrappers developed in Java to access any source that Virtual DataPort does not have support for. I would suggest you to check the properties of the classes and jar files used in creating the custom data source. You could refer the section “[Developing Custom Wrappers](https://community.denodo.com/docs/html/browse/6.0/vdp/developer/index)” in Virtual DataPort Developer guide for more details. Hope this helps!
Denodo Team
27-04-2017 09:36:24 -0400
The "Custom Wrapper" in question is the Denodo RFCReadTable Custom Wrapper. The view reads tables in SAP and tables in ORACLE and unions them. As I stated in the original post, the REST service generated in Denodo works fine, but the SOAP service does not. The error in the log is: 534317296 [Access(2627)-1035-01.06-poc.zxsnshiph] ERROR 2017-04-25T15:50:57.624 com.denodo.connect.sap.rfcreadtable.wrapper.RFCReadTableWrapper [] - Error running wrapper STACK TRACE: java.lang.NullPointerException at java.util.Calendar.setTime(Unknown Source) at java.text.SimpleDateFormat.format(Unknown Source) at java.text.SimpleDateFormat.format(Unknown Source) at java.text.DateFormat.format(Unknown Source) at com.denodo.connect.sap.rfcreadtable.wrapper.util.DateUtils.formatVDPDateTime(DateUtils.java:48) at com.denodo.connect.sap.rfcreadtable.wrapper.TableReader.addWhereClause(TableReader.java:187) at com.denodo.connect.sap.rfcreadtable.wrapper.TableReader.readData(TableReader.java:146) at com.denodo.connect.sap.rfcreadtable.wrapper.RFCReadTableWrapper.run(RFCReadTableWrapper.java:242) at com.denodo.vdb.misc.datasource.MyDataSource$1$1.doRun(Unknown Source) at com.denodo.vdb.engine.wrapper.raw.my.MyAccessImpl.doRun(Unknown Source) at com.denodo.vdb.engine.wrapper.RawAccess.run(Unknown Source) at com.denodo.vdb.engine.thread.g.a(Unknown Source) at com.denodo.vdb.engine.thread.ReusableThread.run(Unknown Source)
user
27-04-2017 10:41:16 -0400
Hi, I would suggest you to connect to SAP using Multidimensional Database Sources.Virtual DataPort provides two types of adapters to retrieve data from SAP Business Warehouse and SAP Business Intelligence: 1. Using XMLA adapters, you could connect to SAP through its XMLA interface. 1. Using BAPI adapters, which use the SAP JCo connector. We recommend using these adapters to access SAP BW and SAP BI because their CPU usage and memory footprint are lower than with the XMLA adapters. You can find all the information related to this data source in “Multidimensional Database Sources” of “[Virtual DataPort Administration Guide](https://community.denodo.com/docs/view/document/Denodo%20Express/Denodo%206.0/Virtual%20DataPort%20Administration%20Guide)”. In addition to that you could refer the Knowledge base article “[Denodo and SAP Best Practices](https://community.denodo.com/kb/view/document/Denodo%20and%20SAP%20Best%20Practices?category=Data+Sources)” to know about using SAP in Denodo Platform. Hope this helps!
Denodo Team
04-05-2017 08:09:34 -0400
You must sign in to add an answer. If you do not have an account, you can register here