Incremental Migration To RR Causes Error For Existing REST Services and/or Web Services
(Doc ID 2989523.1)
Last updated on JANUARY 30, 2024
Applies to:
Siebel CRM - Version 23.8 and laterInformation in this document applies to any platform.
Symptoms
Performing Incremental Repository Migration (IRR) to an RR environment (such as Production) results in repeated errors with Siebel RESTful services and/or Web Services. The only remediation is to restart the EAI Object Manager.
For example, for an existing business service-based REST interface called "LOYMembership" following errors are seen in siebel_1.log on the AI:
[SIEBEL ERROR] Thread[https-jsse-nio-9999-exec-2898,5,main] [2023-10-31 08:56:32.333] [null] Service request execute Exception : Unable to create the Business Service 'LOYMembership'(SBL-DAT-00227)
[SIEBEL ERROR] Thread[https-jsse-nio-9999-exec-2844,5,main] [2023-10-31 08:56:33.397] [null] Service request execute Exception : Unable to create the Business Service 'LOYMembership'(SBL-DAT-00227)
The issue can be reproduced at will with the following steps:
1. Create and Deploy a business service-based REST interface, for examples on creating and calling a business service-based REST interface refer to How To Test Siebel IP2016 and 17+ RESTFul Services API (Doc ID 2193144.2)
2. Deliver changes to MAIN Workspace
3. Perform Incremental Repository Migration(IRR) to the Runtime Repository (RR) instance
4. Add access to BS
5. Test and verify that requests to REST interface works in RR environment
6. Make a repository change, which may not be related to specific REST interface Business Service
7. Deliver changes to MAIN
8. Perform a new IRR -- have already some active EAI tasks running before perform the IRR
9. After the IRR is done, within 2-3 minutes, EAI tasks which were running before the IRR will start error out with http 401 code and Error SBL-DAT-00227 is seen in OM.logs
Notes: Following Error was also seen for a related issue using Web Services, indicating that Error can vary and same may also impact Web Services.
SBL-DAT-00452: Join in business component definition 'Account' has source fields that come from tables 'S_ORG_EXT' and 'S_PARTY'
SBL-DAT-00452: Join in business component definition 'IND Contact Thin' has source fields that come from tables 'S_CONTACT' and 'S_PARTY'
SBL-EAI-04180: Fields from different components are unsupported in Unary Operator: 'IS NOT NULL' in query specification '[Order.ApplicationNumber] = 23-D-3636 AND [Order.SubmissionDate] IS NOT NULL'
SBL-EAI-04394: No integration component field corresponding to 'PSSDeliveryId'
Changes
Applied 23.8 Siebel Update
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |