Siebel EAI >  SBL-EAI-04117: HTTP Request error during 'Submitting Data SendHTTP request'

Generic HTTP Internal Server error

SBL-EAI-04117: HTTP Request error during 'Submitting Data SendHTTP request': 'Status code - 500'


These two error messages are commonly seen in a variety of scenarios and indicate that an error has occurred on the BI Publisher side of the integration. When encountering these errors within the XMLPReportServer log files a review should be made of the of the following trace which may provide details of specific issues in the integration. For further information in such scenarios it is recommended to review the contents of the BI Publisher console window and look to increase BI Publisher logging levels.

If these errors are reported in isolation then it may be beneficial to introduce the following changes :
1. In Siebel Tools modify the vanilla 'EAI HTTP Transport' business service.
2. Right click on the name of the business service and select 'Edit Server Scripts'.
3. Copy paste the following script in the 'PreInvokeMethod' event:

function Service_PreInvokeMethod (MethodName, Inputs, Outputs)
{
  if (MethodName == "SendReceive" || MethodName == "Send")
  {
    Inputs.SetProperty("HDR.Connection","close");
  }
  return (ContinueOperation);
}

4. Compile the modified business service and deploy the SRF to the Siebel server.

These changes ensure that the HTTP connections are closed and re-opened when new requests are made to the BI Publisher Server thereby clearing any incomplete connections to the server.

These error messages are reported with minimal logging in place for the Object Manager Logging event on the XMLPReportServer component

2.1) The errors below are seen in XMLP Report Server log intermittently when multiple reports are generated at the same time:

ObjMgrLog Error 1 00000157517a16dc:0 2013-04-26 12:06:28 (httptransport.cpp (1634)) SBL-EAI-04117: HTTP Request error during 'Submitting Data SendHTTP request': 'Status code - 500'
ObjMgrLog Error 1 00000157517a16dc:0 2013-04-26 12:06:28 (httptransport.cpp (983)) SBL-EAI-04117: HTTP Request error during 'Submitting Data Send HTTP request': 'Status code - 500'

ObjMgrLog Error 1 00000157517a16dc:0 2013-04-26 12:06:28 (soapbinding.cpp (675)) SBL-EAI-04304: Unknown Part 'http://xml.apache.org/axis/:hostname'  for operation 'runReport' exists in SOAP message.
ObjMgrBusServiceLog Error 1 00000157517a16dc:0 2013-04-26 12:06:28 (outdisp.cpp (247)) SBL-EAI-04308: Operation 'runReport' of Web Service 'http://xmlns.oracle.com/oxp/service/v11/PublicReportService.PublicReportServiceService' at port 'PublicReportService_v11' failed with the following explanation: "oracle.apps.xdo.security.ValidateException".

XMLPReportLog XMLPReportError 1 00000157517a16dc:0 2013-04-26 12:06:28 Invalid User Name and Password for BIP Server
ObjMgrBusServiceLog Error 1 00000157517a16dc:0 2013-04-26 12:06:28 (xmlpadaptersvc.cpp (2283)) SBL-RPT-50529: Verify BI Publisher Server Userid and Password.
XMLPReportLog XMLPReportError 1 00000157517a16dc:0 2013-04-26 12:06:28 Error in generating Report Output file D:\siebel\8.1.1.0.0\ses\siebsrvr/xmlp/reports/BIP Branch Event Internal Use Report1-2K93FU.PDF in the XMLP Engine
ObjMgrBusServiceLog Error 1 00000157517a16dc:0 2013-04-26 12:06:28 (xmlpadaptersvc.cpp (2955)) SBL-RPT-50524: BI Publisher engine failed to generate report.


Solution - The max tasks parameter has been increased and reports started working fine and generated consistently.