Assignment Manager Does not Assign from Workflow, Instead gives Error SBL-ASG-00023 (Doc ID 539486.1)

Last updated on AUGUST 07, 2015

Applies to:

Siebel Assignment Manager - Version 7.7.2 [18325] and later
z*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.

***Checked for relevance on 13-Nov-2013***

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 which creates a service request in database and then calls Synchronous Assignment Manager Requests to assign SR to suitable group based on assignment rules. This works perfect when run from Tools in simulation mode against server.

The next step was to move this to server and the workflow 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 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 so that it calls a sub process with assignment but got the same error.  How can this transaction be forced to be commited to DB 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 WF also works successfully in Workflow Process Simulator, 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms