Inbound REST API Invoking Workflow Process Which Invokes EAI Siebel Adapter Business Service Fails To Handle Attachment IC With Error "Field 'FileExt' does not exist in definition for business component 'Service Request Attachment'"
(Doc ID 2983730.1)
Last updated on OCTOBER 30, 2023
Applies to:
Siebel CRM - Version 22.3 and laterInformation in this document applies to any platform.
Symptoms
A custom business service 'SR ASI' has been created, which is then invoked inside a workflow process to handle service request and attachment data.
This workflow process is invoked through Inbound REST. When the EAI task runs for this Inbound REST call, it fails at the custom business service 'SR ASI' with an error.
The following error message occurs in the EAIObjMgr_enu_*.log file:
StpExec TaskArg 4 0000034964b8285c:0 2023-07-20 00:34:07 Input: @0*0*1*1*0*0*12*StatusObject4*TRUE4*1*13*SiebelMessage3*0*9*MessageId9*9SIA-MPIH11*MessageType18*Integration Object13*IntObjectName9*SR IO15*IntObjectFormat19*Siebel Hierarchical0*1*15*ListOf SR IO3*0*5*1*19*Service Request3*0*14*Department13*Customer Care18*Sub Department24*Customer Service Support7*SR Type14*Refund Request13*ListOfService Request Attachment3*0*4*0*26*Service Request Attachment3*0*16*ActivityComments0*15*ActivityFileExt3*jpg16*ActivityFileName6*change22*Activity Attachment Id147872*/9j/4AAQSkZJRgABAQEAYABgAAD/4RDsRXhpZgAATU0AKgAAAAgABAE7AAIAAAALAAAISodpAAQAAAABAAAIVpydAAEAAAAWAAAQzuocAAcAAAgMAAAAPgAAAAAc6gAAAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
...
...
EAISiebAdpt EAISiebAdptErr 1 0000034964b8285c:0 2023-07-20 00:34:07 [0] Method 'FieldValue' of business component 'Service Request Attachment' (integration component 'Service Request Attachment') for record with search specification '[ActivityFileName] = "change" AND [ActivityFileExt] = "jpg"' returned the following error:"Field 'FileExt' does not exist in definition for business component 'Service Request Attachment'.
Please ask your systems administrator to check your application configuration.(SBL-DAT-00398)"(SBL-EAI-04451) (0x75018e)
The behavior occurs as follows:
1. Create a custom business service called 'SR ASI' based on class CSSEAIDataSyncService.
2. Create a custom workflow process that invokes this custom business service 'SR ASI' based on class CSSEAIDataSyncService.
3. Set up the workflow process to be invoked through Siebel Inbound REST, follow steps from Siebel documentation:
• Siebel Bookshelf > Siebel REST Guide > Chapter 7 Accessing Workflows
https://docs.oracle.com/cd/F26413_36/books/RestAPI/c-RestAPI-Using-WF-Access.html#restapi_using
4. Use any 3rd party too such as SoapUI or Chrome Postman to send an inbound JSON message with a service request and attachment message body, into Siebel to invoke this Inbound REST which runs the workflow process.
5. This starts an EAI task that runs the workflow process.
6. The workflow process is started, it runs up to the step that invokes the custom business service 'SR ASI' method 'InsertOrUpdate' and fails with the reported error here.
NOTE: The same situation and error can occur if the workflow process invokes the out of the box EAI Siebel Adapter business service Upsert method on the IO/attachment IC.
Changes
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 |