Applies to: Siebel Marketing Enterprise - Version: 8.1.1 [21112] and later [Release: V8 and later ]
z*OBSOLETE: IBM AIX5L Based Systems (32-bit)
GoalThe campaign load works fine when using url with http, but fails when using url with https.
Error/Warning : Error invoking service 'Mktg Data Load Service', method 'PrepareCache' at step 'Prepare Cahce'.(SBL-BPR-00162)
--
HTTP Internet Exception during 'Data Send': 'The specified module could not be found.
', code: '126'(SBL-EAI-04116)
SolutionTo enable SSL communications between the Siebel CRM Server and the OBIEE SAW Server, it will be required to enable (and configure) the use of Certificates in both sides. The procedure to enable these certificates in Unix AIX, is described in Siebel Bookshelf > Siebel Security Guide (Version 8.1) > Communications and Data Encryption > Configuring Secure Communications > Installing Certificate Files on UNIX
The document titled “How To Register Certificates on UNIX Siebel Servers for Outbound HTTP Transport Requests / Web Services Over SSL†(Doc ID 473779.1) also describes the same procedure and adds valuable information to the procedure described in the Bookshelf documentation.
Some of our customers have experienced issues and have not been able to install and configure Certificate files on AIX. This issue does not occur on all AIX environments, so it is recommended that customers should try the procedures described in above 2 documents.
If the error persist and its still not possible to install Certificates, then a Quick Fix was released and it is already available for download. Please, use the Patches and Downloads section on Metalink/My Oracle Support and then the Simple Search feature to look for the patch number 8562677. Please read the Release Notes carefully before applying it in your environment.
Note: Customers can also refer to CR # 10495231 for additional information regarding this AIX Certificates issue.
ReferencesBUG:10563276 - MASTER CR TO TRACK INCLUSION OF MAINWIN 5.04 CUM. PATCH INTO SIEBEL 8.0. AND 8.1. CODELINES ON UNIX
NOTE:473779.1 - How To Register Certificates on UNIX Siebel Servers for Outbound HTTP Transport Requests / Web Services Over SSL
Applies to: Siebel System Software - Version: 7.5.3 [16157] and later [Release: V7 and later ]
z*OBSOLETE: Microsoft Windows 2000
SymptomsSBL-EAI-04116 The following error message is thrown by "EAI HTTP Transport" Business Service:
"... HTTP Internet Exception during 'Data Send': 'A certificate is required to complete client authentication', code: '12044'(SBL-EAI-04116) ...", when Web (HTTP) Server is configured to require a client certificate.
This Client Certificate is valid and using a Web Browser, one can navigate to the Site of the URL.
CauseThe reported behavior only occurs for HTTP/S requests, when external Web Server required client authentication at SSL-handshake. This means that the client SSL-certificate must be installed and provided by the client (Siebel Server).
The 'EAI HTTP Transport' Business Service of Siebel Application Release 7.5 supports only the Server SSL-Authentication, but not the Client (Mutual) SSL-Authentication for outbound HTTP/S-connections.
The related WinInet API case (the API used by EAI HTTP Transport) is published in the "Microsoft Knowledge Base Article - 224282 "HOWTO: Select Client Certificate in WinInet" on the Microsoft Support Site .
SolutionFor latest Siebel releases
Dim sRequest As Variant
Dim sResponse As String
Dim oWIP As Object
...
Set oWIP = CreateObject( 'WinHttp.WinHttpRequest.5.1' )
...
'
' Open URL for HTTPS/POST communication
'
oWIP.Open "POST", "https://myhost/myservice.asp", 0
...
'
' Specify the actual data encoding (UTF-16 for Unicode based Object Manager installation)
'
oWIP.SetRequestHeader "Content-Type", "application/x-www-form-urlencoded;charset=UTF-16"
'
...
'
' Specify the absolute or relative SSL-certificate name, installed on the client (Object Manager site)
'
oWIP.SetClientCertificate "MyCertificate"
...
'
' Send HTTPS-Request from variable to the URL
'
sRequest = ...
oWIP.Send sRequest
...
'
' Obtain HTTPS-Response text into variable
'
sResponse = oWIP.ResponseText
...
Set oWIP = Nothing
* * *
The Siebel Application product enhancement (Change Request Bug 10468185) was logged to ask the Client Authentication for SSL be supported for EAI HTTP Transport business service of Siebel Application.
This has been implemented in the recent product releases. For latest information on supported versions when using mutual authentication, see :Configuring SSL Mutual Authentication with EAI HTTP Transport/Outbound Web Services (Doc ID 560965.1)
Siebel System Software - Version: 7.8.2.2 SIA [19219] and later [Release: V7 and later ]
IBM AIX on POWER Systems (64-bit)
Product Release: V7 (Enterprise)
Version: 7.8.2.2 [19219] Pub Sect
Database: IBM DB2 8.2
Application Server OS: IBM AIX 5L 5.2
Database Server OS: IBM AIX 5L 5.2
This document was previously published as Siebel SR 38-3346992191.
SymptomsOn 7.8.2.2 SIA [19219]
Siebel EAI
When running EAI HTTP Transport against an SSL enabled Apache or IBM IHS webserver,
that had tcpkeepalive enabled intermittent errors were encountered during "Data Send".
e.g:
*********************************************************************************************
Date/Time: Thu May 10 10:30:43 2007 Hostname: wat059 Error Level: 127 Error Code: DWP000160 Description: Error in workflow DWP Person Trace Position: View: ObjectName: Test Login Name: WAE1BRE Error Msg: Error invoking service 'PersonTracePortType', method 'PersonTraceOperation' at step 'Invoke WebService'.(SBL-BPR-00162)
--
HTTP Internet Exception during 'Data Send': 'An error occurred in the secure channel
support
', code: '12157'(SBL-EAI-04116)
*********************************************************************************************
The errors were usually one of these 3 :
(SBL-BPR-00162)HTTP Internet Exception during 'Data Send': 'An error occurred in the secure channel support', code: '12157'(SBL-EAI-04116)
SBL-OMS-00107: Object manager error: ([1] HTTP Internet Exception during 'Data Send': 'The Server returned an invalid or unrecognized response', code: '12152'(SBL-EAI-04116)
SBL-EAI-04116: HTTP Internet Exception during 'Data Send': 'The connection with the server was reset
ChangesThe Interface WPM is invoked via a workflow policy (WP) and is set up to run asynchronously. The error seems to occur when the WPM is invoked by a high number of workflow policy requests i.e. this does not happen when we violate the policy 10 times in one go but when we viloate it 1200 times.
CauseThe behavior is not expected.
It was reproduced and a Change Request # 10527223 was raised to address this.
Solution
A workaround was attempted to set HDR.connection=close.
There was a performance issue with this.
The delay seemed to be due to Siebel waiting until the FIN packet is received from websrver.
The delay appeared to be the amount of time specified before tcptimeout closed the connnection. (parameter KeepAliveTimeout on the webserver)
This was reproduced too and Change Request # 10526731 was raised to address this.
When setting the webserver setting KeepAliveTimeout parameter to 60 seconds, this seemed to prevent the problem. Disabling the keepalive altogether is another option.
Another workaround could be to implement retry logic within a workflow. Although this cannot be guaranteed to work every retry.
NOTE: HDR.connection=close has a side effect on Siebel search. For details please consult
NOTE: 1192489.1 Siebel Search Operation Takes Several Minutes
ReferencesBUG:10526731 - WHEN SETTING HDR.CONNECTION=CLOSE ON SOME WEBSERVERS, RESPONSE IS DELAYED
BUG:10527223 - INTERMITTENT 12031,12152,12157 ERRORS WITH OUTBOUND WBSVC IHS/SSL
NOTE:527156.1 - HTTP Transport not returning data to Siebel until TCP connection is closed
NOTE:1192489.1 - Siebel Search Operation Takes Several Minutes
Applies to: Siebel Marketing - Version: 7.9.6 [1340] - Release: V7
Information in this document applies to any platform.
SymptomsSome campaign launches are failing with the following error:
HTTP Internet Exception during 'Data Send': 'The connection with the server was reset', code: '12031'(SBL-EAI-04116)
this occurs during the list generation at the step "Send Offers / Vendor Lists"
It usually occurs after about 10-20 minutes of processing.
Cause
The root cause of the problem was an Alteon load balancer which was responsible for closing connections from the WfProcMgr OM.
When the Alteon load-balancer was bypassed (by configuring Marketing Outbound Web Services to point directly to the SAW server) the "connection with the server has been reset" error ceased to occur.
Solution
NOTE:868102.1 - Intermittent Outbound Web Service Failures with Error: code: '12031' (SBL-EAI-04116)
NOTE:859382.1 - How to Control Parameters on Transport for Outbound Web Service, e.g. HTTPSleepTime
Applies to: Siebel Campaigns - Version: 7.8.2.3 [19221] and later [Release: V7 and later ]
Siebel Marketing - Version: 7.8.2.3 [19221] and later [Release: V7 and later]
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.8.2.3 [19221]
Database: Oracle 10.2.0.2
Application Server OS: Microsoft Windows 2000 Server SP 1
Database Server OS: HP-UX 10.0
This document was previously published as Siebel SR 38-3450604121.
SymptomsSBL-EAI-04116, SBL-BPR-00162
There is currently a problem using the Campaign Load functionality.
When the user tries to Load a Campaign, the following error appears:
Fehler/Warnung: Fehler beim Aufrufen von Dienst 'Mktg Data Load Service', Methode 'PrepareCache' bei Schritt 'Prepare Cache'(SBL-BPR-00162)
--
HTTP Internet-Ausnahme w�hrend 'Data Send': 'The server name or address could not be resolved
', Code: '12007'(SBL-EAI-04116)
Analysis
This functionality was working previously with the following Object Managers
English Object Manager
German Object Manager
This functionality is not now working currently with the following Object Managers
German Object Manager
Questions
1. Does the Campaign Load functionality work correctly when only the German (DEU) version of the Siebel OLTP Software is installed and not the English version (ENU)?
2. Does all the other Marketing functionality work correctly when only the German (DEU) version of the Siebel OLTP Software is installed and not the English version (ENU), e.g. Campaign Launch, Campaign Scheduling, Program Scheduling etc?
3. Is there any other cause for the problems that are occurring?
CauseHere:
- incomplete hosts setting
- German seed data
SolutionMessage 11. See symptoms and solution approach in:
Siebel Marketing 7.7 Testing and Troubleshooting Guide (Doc ID 478103.1)
2. For the special case here the resolution was:
a) Edit the /etc/hosts and add the host machine ip address (although both the Siebel OLAP and Siebel OLTP system are residing on the same host and DNS IP Resolution is working).
b) Edit the Workflow Process Step 'Prepare Cache' and the corresponding Workflow Parameter which called the Business Service as the German Seed data contained a incorrect value (instead of 'PrepareCache' the parameter value for the method call was 'PrepareCahce').
Additional Keywords: Marketing Connection Settings, business service method PrepareCache, DEU.
Navigate to Administration - Marketing > Servers
Select the record "Default Analytics Web Server" from the top applet
In the bottom applet, drill into each of the outbound web services: (1) JobManagementService, (2) SAWSessionService, (3) WebCatalogService.
Make sure the URL configured for the outbound web service points directly to the OBI PS server
Applies to: : Follow the Note 560965.1 to let the EAI HTTP Transport to use the Client Certificate with SSL-handshake.
For Siebel 7.5 and earlier releases: Consider to use some alternative API, specific to accordant operating system. Particularly for Microsoft Windows OS the following schematic Siebel Visual Basic (server-side) script could be used to perform HTTP/S POST. It employs the feature of the 'WinHttp.WinHttpRequest.5.1' COM-object of the Microsoft Windows HTTP Services (based on the 'winhttp.dll'):
z*OBSOLETE: IBM AIX5L Based Systems (32-bit)
GoalThe campaign load works fine when using url with http, but fails when using url with https.
Error/Warning : Error invoking service 'Mktg Data Load Service', method 'PrepareCache' at step 'Prepare Cahce'.(SBL-BPR-00162)
--
HTTP Internet Exception during 'Data Send': 'The specified module could not be found.
', code: '126'(SBL-EAI-04116)
SolutionTo enable SSL communications between the Siebel CRM Server and the OBIEE SAW Server, it will be required to enable (and configure) the use of Certificates in both sides. The procedure to enable these certificates in Unix AIX, is described in Siebel Bookshelf > Siebel Security Guide (Version 8.1) > Communications and Data Encryption > Configuring Secure Communications > Installing Certificate Files on UNIX
The document titled “How To Register Certificates on UNIX Siebel Servers for Outbound HTTP Transport Requests / Web Services Over SSL†(Doc ID 473779.1) also describes the same procedure and adds valuable information to the procedure described in the Bookshelf documentation.
Some of our customers have experienced issues and have not been able to install and configure Certificate files on AIX. This issue does not occur on all AIX environments, so it is recommended that customers should try the procedures described in above 2 documents.
If the error persist and its still not possible to install Certificates, then a Quick Fix was released and it is already available for download. Please, use the Patches and Downloads section on Metalink/My Oracle Support and then the Simple Search feature to look for the patch number 8562677. Please read the Release Notes carefully before applying it in your environment.
Note: Customers can also refer to CR # 10495231 for additional information regarding this AIX Certificates issue.
ReferencesBUG:10563276 - MASTER CR TO TRACK INCLUSION OF MAINWIN 5.04 CUM. PATCH INTO SIEBEL 8.0. AND 8.1. CODELINES ON UNIX
NOTE:473779.1 - How To Register Certificates on UNIX Siebel Servers for Outbound HTTP Transport Requests / Web Services Over SSL
Applies to: Siebel System Software - Version: 7.5.3 [16157] and later [Release: V7 and later ]
z*OBSOLETE: Microsoft Windows 2000
SymptomsSBL-EAI-04116 The following error message is thrown by "EAI HTTP Transport" Business Service:
"... HTTP Internet Exception during 'Data Send': 'A certificate is required to complete client authentication', code: '12044'(SBL-EAI-04116) ...", when Web (HTTP) Server is configured to require a client certificate.
This Client Certificate is valid and using a Web Browser, one can navigate to the Site of the URL.
CauseThe reported behavior only occurs for HTTP/S requests, when external Web Server required client authentication at SSL-handshake. This means that the client SSL-certificate must be installed and provided by the client (Siebel Server).
The 'EAI HTTP Transport' Business Service of Siebel Application Release 7.5 supports only the Server SSL-Authentication, but not the Client (Mutual) SSL-Authentication for outbound HTTP/S-connections.
The related WinInet API case (the API used by EAI HTTP Transport) is published in the "Microsoft Knowledge Base Article - 224282 "HOWTO: Select Client Certificate in WinInet" on the Microsoft Support Site .
SolutionFor latest Siebel releases
Dim sRequest As Variant
Dim sResponse As String
Dim oWIP As Object
...
Set oWIP = CreateObject( 'WinHttp.WinHttpRequest.5.1' )
...
'
' Open URL for HTTPS/POST communication
'
oWIP.Open "POST", "https://myhost/myservice.asp", 0
...
'
' Specify the actual data encoding (UTF-16 for Unicode based Object Manager installation)
'
oWIP.SetRequestHeader "Content-Type", "application/x-www-form-urlencoded;charset=UTF-16"
'
...
'
' Specify the absolute or relative SSL-certificate name, installed on the client (Object Manager site)
'
oWIP.SetClientCertificate "MyCertificate"
...
'
' Send HTTPS-Request from variable to the URL
'
sRequest = ...
oWIP.Send sRequest
...
'
' Obtain HTTPS-Response text into variable
'
sResponse = oWIP.ResponseText
...
Set oWIP = Nothing
* * *
The Siebel Application product enhancement (Change Request Bug 10468185) was logged to ask the Client Authentication for SSL be supported for EAI HTTP Transport business service of Siebel Application.
This has been implemented in the recent product releases. For latest information on supported versions when using mutual authentication, see :Configuring SSL Mutual Authentication with EAI HTTP Transport/Outbound Web Services (Doc ID 560965.1)
Siebel System Software - Version: 7.8.2.2 SIA [19219] and later [Release: V7 and later ]
IBM AIX on POWER Systems (64-bit)
Product Release: V7 (Enterprise)
Version: 7.8.2.2 [19219] Pub Sect
Database: IBM DB2 8.2
Application Server OS: IBM AIX 5L 5.2
Database Server OS: IBM AIX 5L 5.2
This document was previously published as Siebel SR 38-3346992191.
SymptomsOn 7.8.2.2 SIA [19219]
Siebel EAI
When running EAI HTTP Transport against an SSL enabled Apache or IBM IHS webserver,
that had tcpkeepalive enabled intermittent errors were encountered during "Data Send".
e.g:
*********************************************************************************************
Date/Time: Thu May 10 10:30:43 2007 Hostname: wat059 Error Level: 127 Error Code: DWP000160 Description: Error in workflow DWP Person Trace Position: View: ObjectName: Test Login Name: WAE1BRE Error Msg: Error invoking service 'PersonTracePortType', method 'PersonTraceOperation' at step 'Invoke WebService'.(SBL-BPR-00162)
--
HTTP Internet Exception during 'Data Send': 'An error occurred in the secure channel
support
', code: '12157'(SBL-EAI-04116)
*********************************************************************************************
The errors were usually one of these 3 :
SBL-OMS-00107: Object manager error: ([1] HTTP Internet Exception during 'Data Send': 'The Server returned an invalid or unrecognized response', code: '12152'(SBL-EAI-04116)
SBL-EAI-04116: HTTP Internet Exception during 'Data Send': 'The connection with the server was reset
ChangesThe Interface WPM is invoked via a workflow policy (WP) and is set up to run asynchronously. The error seems to occur when the WPM is invoked by a high number of workflow policy requests i.e. this does not happen when we violate the policy 10 times in one go but when we viloate it 1200 times.
CauseThe behavior is not expected.
It was reproduced and a Change Request # 10527223 was raised to address this.
Solution
A workaround was attempted to set HDR.connection=close.
There was a performance issue with this.
The delay seemed to be due to Siebel waiting until the FIN packet is received from websrver.
The delay appeared to be the amount of time specified before tcptimeout closed the connnection. (parameter KeepAliveTimeout on the webserver)
This was reproduced too and Change Request # 10526731 was raised to address this.
When setting the webserver setting KeepAliveTimeout parameter to 60 seconds, this seemed to prevent the problem. Disabling the keepalive altogether is another option.
Another workaround could be to implement retry logic within a workflow. Although this cannot be guaranteed to work every retry.
NOTE: HDR.connection=close has a side effect on Siebel search. For details please consult
NOTE: 1192489.1 Siebel Search Operation Takes Several Minutes
ReferencesBUG:10526731 - WHEN SETTING HDR.CONNECTION=CLOSE ON SOME WEBSERVERS, RESPONSE IS DELAYED
BUG:10527223 - INTERMITTENT 12031,12152,12157 ERRORS WITH OUTBOUND WBSVC IHS/SSL
NOTE:527156.1 - HTTP Transport not returning data to Siebel until TCP connection is closed
NOTE:1192489.1 - Siebel Search Operation Takes Several Minutes
Applies to: Siebel Marketing - Version: 7.9.6 [1340] - Release: V7
Information in this document applies to any platform.
SymptomsSome campaign launches are failing with the following error:
HTTP Internet Exception during 'Data Send': 'The connection with the server was reset', code: '12031'(SBL-EAI-04116)
this occurs during the list generation at the step "Send Offers / Vendor Lists"
It usually occurs after about 10-20 minutes of processing.
Cause
The root cause of the problem was an Alteon load balancer which was responsible for closing connections from the WfProcMgr OM.
When the Alteon load-balancer was bypassed (by configuring Marketing Outbound Web Services to point directly to the SAW server) the "connection with the server has been reset" error ceased to occur.
Solution
NOTE:868102.1 - Intermittent Outbound Web Service Failures with Error: code: '12031' (SBL-EAI-04116)
NOTE:859382.1 - How to Control Parameters on Transport for Outbound Web Service, e.g. HTTPSleepTime
Applies to: Siebel Campaigns - Version: 7.8.2.3 [19221] and later [Release: V7 and later ]
Siebel Marketing - Version: 7.8.2.3 [19221] and later [Release: V7 and later]
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.8.2.3 [19221]
Database: Oracle 10.2.0.2
Application Server OS: Microsoft Windows 2000 Server SP 1
Database Server OS: HP-UX 10.0
This document was previously published as Siebel SR 38-3450604121.
SymptomsSBL-EAI-04116, SBL-BPR-00162
There is currently a problem using the Campaign Load functionality.
When the user tries to Load a Campaign, the following error appears:
Fehler/Warnung: Fehler beim Aufrufen von Dienst 'Mktg Data Load Service', Methode 'PrepareCache' bei Schritt 'Prepare Cache'(SBL-BPR-00162)
--
HTTP Internet-Ausnahme w�hrend 'Data Send': 'The server name or address could not be resolved
', Code: '12007'(SBL-EAI-04116)
Analysis
This functionality was working previously with the following Object Managers
English Object Manager
German Object Manager
This functionality is not now working currently with the following Object Managers
German Object Manager
Questions
1. Does the Campaign Load functionality work correctly when only the German (DEU) version of the Siebel OLTP Software is installed and not the English version (ENU)?
2. Does all the other Marketing functionality work correctly when only the German (DEU) version of the Siebel OLTP Software is installed and not the English version (ENU), e.g. Campaign Launch, Campaign Scheduling, Program Scheduling etc?
3. Is there any other cause for the problems that are occurring?
CauseHere:
- incomplete hosts setting
- German seed data
SolutionMessage 11. See symptoms and solution approach in:
Siebel Marketing 7.7 Testing and Troubleshooting Guide (Doc ID 478103.1)
2. For the special case here the resolution was:
a) Edit the /etc/hosts and add the host machine ip address (although both the Siebel OLAP and Siebel OLTP system are residing on the same host and DNS IP Resolution is working).
b) Edit the Workflow Process Step 'Prepare Cache' and the corresponding Workflow Parameter which called the Business Service as the German Seed data contained a incorrect value (instead of 'PrepareCache' the parameter value for the method call was 'PrepareCahce').
Additional Keywords: Marketing Connection Settings, business service method PrepareCache, DEU.
Navigate to Administration - Marketing > Servers
Select the record "Default Analytics Web Server" from the top applet
In the bottom applet, drill into each of the outbound web services: (1) JobManagementService, (2) SAWSessionService, (3) WebCatalogService.
Make sure the URL configured for the outbound web service points directly to the OBI PS server
Applies to: : Follow the Note 560965.1 to let the EAI HTTP Transport to use the Client Certificate with SSL-handshake.
For Siebel 7.5 and earlier releases: Consider to use some alternative API, specific to accordant operating system. Particularly for Microsoft Windows OS the following schematic Siebel Visual Basic (server-side) script could be used to perform HTTP/S POST. It employs the feature of the 'WinHttp.WinHttpRequest.5.1' COM-object of the Microsoft Windows HTTP Services (based on the 'winhttp.dll'):
No comments:
Post a Comment