BusinessObjects Board

There is no response for the web service...

dataservices realtime
#2

looking at the axis2.xml looks like the Security phase is not enabled, can you uncomment the following tag under

if the job still fails, run the job from command line with additinoal -np -D arguments this will create axis2_log.txt file in %LINK_DIR%\log folder, post that log, review the log before posting and remove any sensitive information (url, etc)

you don’t need KEY_FILE and PASSPHRASE if you don’t need client certificate, commet these out also

manoj_d (BOB member since 2009-01-02)

#3

Hi,

thanks for your answer, but no change in response after enhance the axis2.xml.

Now i’m stuck in calling the job (it’s a real-time job) from command line.
I tried the following command in %LINK_DIR%\bin:

al_engine -S[TNS_LISTENERNAME] -U[REP_USER] -P[BASE64_ENCODED_PASSWORD_OF_REP_USER] -NOracle -q[REP_NAME] -s[JOB_NAME] -CtRTDF -np -D

This failed because of invalid database username/password??
Why do i have to use database credentials?
Isn’t it possible to just use server + repository + repository credentials + jobname?

Maybe you can provide an example how to call the job via command line with all necessary arguments please?

PS: calling the webservice via soupUI works without problems.

Thanks in advance.

schaphi :de: (BOB member since 2012-06-04)

#4

use the following command to run the job from command line
al_engine -U -P -NOracle -S -s -D -np

replace the values enclosed in < and > with the values from your env

manoj_d (BOB member since 2009-01-02)

#5

Thanks a lot for your help.

Found the solution: parameter SERVER_CERT was not set correctly with the base64 encoded certificate of the web service server in axis2.xml


<transportSender name="https" class="axis2_http_sender">
  <parameter name="PROTOCOL" locked="false">HTTP/1.1</parameter>
  <parameter name="xml-declaration" insert="false"/>
</transportSender>
<parameter name="SERVER_CERT">F:/.../atrium_base64.cer</parameter>

Have a nice day…

schaphi :de: (BOB member since 2012-06-04)

#6

Hi Dinesh,

I am newbie in BODS and have a tough task to consume the external web services using BODS :hb: , have refered few blogs but unable to get the technicalities.

I have gone through some of links of your’s wherein you provided solutions to the different queries.Please provide the step by step guide to consume external web services using BODS.

Thanks in advance.

Rgds
Vir

vir (BOB member since 2010-05-07)

#7

what is the error you are getting and when are you getting the error ? when importing the WSDL or when you are calling the webservice function ?

check the following post

manoj_d (BOB member since 2009-01-02)

#8

Hi Manoj,

I have gone through the suggested link, followed steps to created the data store,imported the functions, created DF and job, used the SSL certificate as well still we are getting below error :

There is no responce for web service ,ensure that the network,web server and service are running properly.Also ensure that the service client call time out is set propoerly.

If possible can you share your contact details.
Thanks & Regards
Vir

vir (BOB member since 2010-05-07)

#9

this is a generic error, run the job from commandline with additional -D -np option, this will create a axis2_log.txt file in %LINK_DIR%\log folder, attach that log to the post

manoj_d (BOB member since 2009-01-02)

#10

Hi Vir,

do you use WebService-Security (“WSS”) for authentification?
This would be the part in XML-Message you have to send (and also add manually to calls in soapUI)


<wsse:Security xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" mustUnderstand="1">
  <wsse:UsernameToken>
    <wsse:Username>TEST</wsse:Username>
    <wsse:Password>12345</wsse:Password>
  </wsse:UsernameToken>
</wsse:Security>

If so, in axis2.xml the following modules have to be implemented:


<module ref="addressing"/>
<module ref="rampart"/>
<module ref="logging"/>

The rampart module enables the usage of webservice security.

If you can’t fix the problem, maybe also trace your request with Wireshark.

schaphi :de: (BOB member since 2012-06-04)

#11

Hi Manoj,

Please find attached axis2_log file herewith.
We did the changes in the axis2.xml file , as we don’t want to set clientside certification we are not using policy file and no proxy setting as well.

Kindly suggest.

Thanks in advence.

Rgds
Vir
axis2_log.txt (40.0 KB)

vir (BOB member since 2010-05-07)

#12

have you tried invoking this service from SoapUI ? looks like something is missing from the respose

[Wed Feb 06 16:01:19 2013] [error] …\src\core\transport\http\sender\http_client.c(667) Content-Type header missing in HTTP response
[Wed Feb 06 16:01:19 2013] [error] …\src\core\transport\http\sender\http_client.c(668) Response does not contain Content-Type
[Wed Feb 06 16:01:19 2013] [error] …\src\core\transport\http\sender\http_sender.c(1381) status_code < 0
[Wed Feb 06 16:01:19 2013] [error] …\src\core\engine\engine.c(179) Transport sender invoke failed

I don’t think this error is because of missing certificate, else the connect itself wolud haev failed

manoj_d (BOB member since 2009-01-02)

#13

Hi Manoj,

On behalf of Vir: The webservice/s work/s fine from soapUI. I was able to add a default Content-Type = “text/xml” and eliminate this error, but the subsequent “Error occurred in Transport” message remains.

However, more importantly, the original xml reader error persists.

I just wanted to clarify the steps again while actually creating the DF:

i. The input schema was created using copy/paste from soapUI for the specific method & generating the xsd in Visual Studio.
ii. This xsd file was then used to create the XML format in BODS.
iii. Used this format, temporarily, as an XML source file to create the input schema in a Query transform.
iv. A subsequent Query transform uses this schema as input & the schema automatically created/saved while importing the web-service function, serves as the output
v. For the time being, we are just dumping the output into a temp XML file.

Additionally, I changed the Certificate file (used Chrome to download it as .cer file, instead of the Firefox .crt). Now, I see that there is log entry about certification.

take care,
gautam

GautamW (BOB member since 2013-02-06)

#14

I was checking the error, I think the error might be happening because of Soap Version, is your service using Soap 1.2 ?DS doesn’t support Soap 1.2 , what is the content type that you are getting in the response ?

manoj_d (BOB member since 2009-01-02)

#15

Hi Manoj,

It seems like a web-service supporting multiple protocols (there are namespace defined for both xmlsoap12 and xmlsoap, in the WSDL. The soapUI clearly identifies the SOAP version as 1.1.

Also, the response content-type is: text/xml;charset = utf-8

take care,
gautam

GautamW (BOB member since 2013-02-06)

#16

ok, if the WSDL has both the ports, then DS will only import the Soap11 port, will it be possible for you to use tcpMon or wireshark to trace the http rsponse that comes back to DS ?

or is it possible for you to file a case with Support ? I can work with support on trouble-shooting this issue

manoj_d (BOB member since 2009-01-02)

#17

Hi,
I am facing issues connecting to a WS-HTTP web service, Attached are the error, axis2.xml and policy.xml files, Can anyone tell me what is going wrong here? :hb:

Warm Regards,
Titash
axis2.txt (6.0 KB)
Policy.txt (1.0 KB)
AL_Error.txt (0.0 KB)

titash_mitra :kuwait: (BOB member since 2011-12-12)

#18

change the following in the Axis2.xml






to






this will add the WSS related header to message before sending it to the server

manoj_d (BOB member since 2009-01-02)

#19

Thanks Manoj for the reply.This does not create any difference. :hb:
Anything else I can try? Can you please have a look if the policy.xml looks good?

Warm Regards,
Titash

titash_mitra :kuwait: (BOB member since 2011-12-12)

#20

does this service requires WSA (Addressing), from the message looks like it requires addressing

we recently fixed something related to this, what is the complete version of DS ?

manoj_d (BOB member since 2009-01-02)

#21

Yes , it requires WSA, Great to know you already nailed it! Can you please help me with the steps…
DS version is 4.2 SP7.

Warm Regards,
Titash

titash_mitra :kuwait: (BOB member since 2011-12-12)