In edit data store web service, I entered parameters for WSS user name, WSS password and WSS password type. Rest of the parameters are set to blank. Note that I didn’t setup proxy host and proxy port. I don’t know where should I setup user ID and password that is included in the SOAP header???
I executed the Job and unsuccessful in retrieving the data from the web services and I get the following error.
“There is no response for the web service . Ensure that the network, web server, and service are running properly. Also ensure that the service client call time out is set properly.”
As a next step I tried running the job using command line:
al_engine -U<> -P<> -NOracle -S<> -s<> -D -np
below are the error entries from the axis2.log:
[Wed Nov 19 17:07:56 2014] [error] …\src\core\transport\http\sender\ssl\ssl_utils.c(86) [ssl client] Loading client certificate failed , key file /path/to/client/certificate/chain/file
[Wed Nov 19 17:07:56 2014] [error] …\src\core\transport\http\sender\ssl\ssl_stream.c(101) Error occurred in SSL engine
[Wed Nov 19 17:07:56 2014] [error] …\src\core\transport\http\sender\http_client.c(287) Data stream creation failed for Host xxxxxxxxxx.xxx.xxx and 443 port
[Wed Nov 19 17:07:56 2014] [error] …\src\core\transport\http\sender\http_client.c(544) client data stream null or socket error for host xxxxxxxxxx.xxx.xxx and 443 port
[Wed Nov 19 17:07:56 2014] [error] …\src\core\transport\http\sender\http_client.c(548) A read attempt(HTTP) for the reply without sending the request
[Wed Nov 19 17:07:56 2014] [error] …\src\core\transport\http\sender\http_sender.c(1381) status_code < 0
[Wed Nov 19 17:07:56 2014] [error] …\src\core\engine\engine.c(179) Transport sender invoke failed
Now I don’t get any errors and the last statement in axis2_log says as given below:
[ssl client] SSL certificate verified against peer
But now my JOB abruptly hangs and I get the following error:
4368 4416 RUN-050406 11/21/2014 5:19:17 PM Data flow received a bad system message. Message text from the child process is
4368 4416 RUN-050406 11/21/2014 5:19:17 PM <￭==========================================================
4368 4416 RUN-050406 11/21/2014 5:19:17 PM Collect the following and send to Customer Support:
4368 4416 RUN-050406 11/21/2014 5:19:17 PM 1. Log files(error_, monitor_, trace_*) associated with this failed job.
4368 4416 RUN-050406 11/21/2014 5:19:17 PM 2. Exported ATL file of this failed job.
4368 4416 RUN-050406 11/21/2014 5:19:17 PM 3. DDL statements of tables referenced in this failed job.
4368 4416 RUN-050406 11/21/2014 5:19:17 PM 4. Data to populate the tables referenced in the failed job. If not possible, get the last few rows (or sample of them) when
4368 4416 RUN-050406 11/21/2014 5:19:17 PM the job failed.
4368 4416 RUN-050406 11/21/2014 5:19:17 PM 5. Core dump, if any, generated from this failed job.
4368 4416 RUN-050406 11/21/2014 5:19:17 PM ==========================================================>. The process executing data flow has died
I’m guessing, that the handshake with the web service is successful and able to send and receive request from the web service but there is something wrong with my data flow.
As a follow-up, I opened port 6060 on my DS Server and I can see my request is sent to the Web Service, processed and sent back but my JOB is not picking up the result set back and terminates abruptly with the following same error message as before.
“Data flow received a bad system message. Message text from the child process is…”
Please advise if anyone had the same issue. I logged a ticket (1132374 / 2014) with SAP support assistance also.
My command line job crashed abruptly with the following error message.
Problem signature:
Problem Event Name: BEX64
Application Name: al_engine.exe
Application Version: 14.1.2.378
Application Timestamp: 520e02b8
Fault Module Name: axis2_http_sender.dll
Fault Module Version: 0.0.0.0
Fault Module Timestamp: 4d10574d
Exception Offset: 00000000000015b2
Exception Code: c0000409
Exception Data: 0000000000000000
OS Version: 6.1.7601.2.1.0.274.10
Locale ID: 1033
Additional Information 1: 4743
Additional Information 2: 47433debcd6e2ac647f3b0a23768cd1e
Additional Information 3: 3e5b
Additional Information 4: 3e5b8f3ff954724118285f5eb1b261c4
Also, I followed KBA 1196661 to create dump file by adding the following two lines in dsconfig.txt (under al_engine) and dsuserconfig.txt (under string), but still unable to see the dump file.