Assignment Manager Does not Assign from Workflow, Instead gives Error SBL-ASG-00023
(Doc ID 539486.1)
Last updated on SEPTEMBER 12, 2023
Applies to:
Siebel Assignment Manager - Version 7.7.2 [18325] and laterz*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.7.2 [18325]
Database: Oracle 9.0.1.3
Application Server OS: Microsoft Windows 2000 Advanced Server SP 4
Database Server OS: IBM AIX 5L 5.2
This document was previously published as Siebel SR 38-3191102361.
Symptoms
Customer created a Service Request inbound flow for integration. The flow reads a Service Request XML from MQ broker and passes it to a workflow process executed by Workflow Process Manager (WfProcMgr) which creates a service request in database and then calls Synchronous Assignment Manager Requests to assign SR to a suitable group based on assignment rules. This works perfect when run from Siebel Tools in simulation mode against server.
The next step was to move this to server and the workflow process works fine except when it comes to the assignment of the SR. When Synchronous Assignment Manager Requests is called on the server the following error occurs:
An invalid Row ID, Row 1-3XX9NF, from the S_SRV_REQ table, has been passed to the assignment manager for processing.
--
An invalid Row ID, Row (null), from the (null) table, has been passed to the assignment manager for processing.
--
Error invoking service 'Synchronous Assignment Manager Requests', method 'Assign' at step 'Assign to Group'.(SBL-BPR-00162)
Customer would like to understand if there are some special parameters that need to be set in order to force a commit on EAI Siebel Adapter Upsert, specific on server? They have also tried to modify the workflow process so that it calls a sub process with assignment but got the same error. How can this transaction be forced to be committed to the database before Assignment manager is fired?
Changes
The custom workflow process (WF) has many steps prior to assignment step which calls 'Synchronous Assignment Manager Requests' business service to assign. The custom workflow process also works successfully in Workflow Process Simulator in Siebel Tools, but fails when running it on the server side with SBL-ASG-00023 error:
An invalid Row ID, Row (null), from the (null) table, has been passed to the assignment manager for processing.
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 |