Error while sending by HTTP (error code: 500 , error text: Internal Server Error) (See attachment HTMLError for details)

[former_member221434]

Dear Expert ,

I am facing occasionally this problem in SXMB_MONI at SAP PI Production system for SOAP to Proxy Synchronous scenario .

Error is :

'

Error while sending by HTTP (error code:  500 , error text: Internal Server Error) (See attachment HTMLError for details)

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>

- <!--

 Call Adapter 

--> 

- <SAP:Error SOAP:mustUnderstand="1" xmlns:SAP="http://sap.com/xi/XI/Message/30" xmlns:SOAP="http://schemas.xmlsoap.org/soap/envelope/">

<SAP:Category>XIServer</SAP:Category>

<SAP:Code area="INTERNAL">CLIENT_SEND_FAILED</SAP:Code>

<SAP:P1>500</SAP:P1>

<SAP:P2>Internal Server Error</SAP:P2>

<SAP:P3>(See attachment HTMLError for details)</SAP:P3>

<SAP:P4 />

<SAP:AdditionalText />

<SAP:Stack>Error while sending by HTTP (error code: 500 , error text: Internal Server Error) (See attachment HTMLError for details)</SAP:Stack>

<SAP:Retry>N</SAP:Retry>

</SAP:Error>

Regards ,

pradeep Kumar

[former_member182412]

Hi Pradeep,

You can see the actual response from ERP system when you call via soap adapter, you can find it by click on tab Further Links and click on log viewer then the response soap envelope you can see in new window like below.

If you cant find anything enable TraceHTTP parameter in soap adapter as per this log and see the actual response from ERP to find out the root cause.HTTP tracing in SOAP receiver adapters with TraceHTTP module parameter

Regards,

Praveen.

[former_member221434]

Hi Inaki/Praveen ,

This is my request payload and response payload is not coming in response message .

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:MT_Daily_Deposit_Collection_Request xmlns:ns0="http://namespace">

<Branch_Code>1032</Branch_Code>

<Pop_Code>2264</Pop_Code>

<Transaction_Request_Number>12505091</Transaction_Request_Number>

<Transaction_Amount>100</Transaction_Amount>

<Transaction_Narration>installment</Transaction_Narration>

<Collection_Agent_Code>263789</Collection_Agent_Code>

<Authorized_network_ID>+917073434904</Authorized_network_ID>

<MAC>mobile</MAC>

</ns0:MT_Daily_Deposit_Collection_Request>

  And HTML Error for request message and response message.

Request :

500 SAP Internal Server Error

ERROR: SQL error 1204 when accessing table TFDIR. (termination: RABAX_STATE)

Response :

500 Internal Server Error

Error is logged with Tag: {00565b60}

---

Mon Apr 4 17:13:48 2016

[former_member186851]

Hello Pradeep,

Check the data for failing records in the quality/Dev.

Also check if the SAP server is always up and running.

[former_member221434]

Hi Raghu ,

Actually this issue occur rarely, Otherwise all scenario are working fine in production environment.

I think this issue related to server connectivity to ECC server but i am not sure .

Regards,

Pradeep

[former_member186851]

ya Praveen,Might be.

the same scenario is working fine in all other environments right?

Stop and start the channel and check.

[former_member221434]

Hi Raghu,

Is this error related to above issue .

Tcode-sm58

Error is :

SQL error SQL code: 7794 occurred while accessing

[former_member182412]

Hi Pradeep,

You are getting SQL error when PI send the message to ECC via proxy, speak to basis about this.

Regards,

Praveen.

[former_member186851]

Hello Pradeep,

Might be some connection issue.

As Praveen suggested check with Basis team once.

[Ryan-Crosby]

Hi Pradeep,

Searching on that SQL error it seems to be because the system is not able to obtain a LOCK when some command in the proxy is executed.  Still something where you would need to check with BASIS as Praveen & Raghuraman have suggested.

Regards,

Ryan Crosby

[iaki_vila]

Hi Pradeep,

Check the payload against the payloads that go right. The problem could be in a date or currency tag, or in any tag expected and it is not present or vice versa

Regards.