Get Data from SAP BW

Anonymous — Thu, 14 Apr 2016 15:46:12 GMT

I tried to connect and fecth data from SAP BW using the component tSAPSWInput, i have already added all the equired libraries (jdbc4olap,....). Connection is OK (checked from SAP side), but when trying to display data using tlogrow, i have the error below:
avr. 14, 2016 4:24:07 PM com.sun.xml.messaging.saaj.soap.MessageImpl identifyContentType
GRAVE: SAAJ0537 : Content-Type non valide. Cela peut être un message d'erreur au lieu d'un message SOAP
Exception in component tSAPBWInput_1_Out
java.sql.SQLException: com.sun.xml.messaging.saaj.SOAPExceptionImpl: Invalid Content-Type:text/html. Is this an error message instead of a SOAP response?
Caused by: Invalid Content-Type:text/html. Is this an error message instead of a SOAP response?
Cause Stack Trace: com.sun.xml.messaging.saaj.SOAPExceptionImpl: Invalid Content-Type:text/html. Is this an error message instead of a SOAP response?
    at com.sun.xml.messaging.saaj.soap.MessageImpl.identifyContentType(MessageImpl.java:670)
    at com.sun.xml.messaging.saaj.soap.MessageFactoryImpl.createMessage(MessageFactoryImpl.java:100)
    at com.sun.xml.messaging.saaj.client.p2p.HttpSOAPConnection.post(HttpSOAPConnection.java:347)
    at com.sun.xml.messaging.saaj.client.p2p.HttpSOAPConnection.call(HttpSOAPConnection.java:160)
    at org.jdbc4olap.xmla.XmlaConn.execute(XmlaConn.java:563)
    at org.jdbc4olap.jdbc.StatementHelper.processQuery(StatementHelper.java:72)
    at org.jdbc4olap.jdbc.OlapStatement.executeQuery(OlapStatement.java:105)
    at icgo.test_sap_0_1.Test_SAP.tSAPBWInput_1_InProcess(Test_SAP.java:793)
    at icgo.test_sap_0_1.Test_SAP.runJobInTOS(Test_SAP.java:1268)
    at icgo.test_sap_0_1.Test_SAP.main(Test_SAP.java:1125)
    at org.jdbc4olap.xmla.XmlaConn.execute(XmlaConn.java:601)
    at org.jdbc4olap.jdbc.StatementHelper.processQuery(StatementHelper.java:72)
    at org.jdbc4olap.jdbc.OlapStatement.executeQuery(OlapStatement.java:105)
    at icgo.test_sap_0_1.Test_SAP.tSAPBWInput_1_InProcess(Test_SAP.java:793)
    at icgo.test_sap_0_1.Test_SAP.runJobInTOS(Test_SAP.java:1268)
    at icgo.test_sap_0_1.Test_SAP.main(Test_SAP.java:1125)
Could someone help me?
Regards

Re: Get Data from SAP BW

Anonymous — Tue, 19 Apr 2016 07:49:03 GMT

Hi,
Could you please show us your job setting screenshot? What does your query look like?
Best regards
Sabrina

topic Re: Get Data from SAP BW in Talend Studio

Get Data from SAP BW

Re: Get Data from SAP BW