Default Position As Siebel Administrator Causes AsgnSrvr To Go Offline, Errors SBL-ASG-00027 and SBL-ASG-00024 (Doc ID 2375916.1)

Last updated on JULY 22, 2024

Applies to:

Symptoms

In vanilla the 'Default Position' for assignment object is the position id. In this case, the 'Default Position' = 0-5200 for assignment object 'PUB Case' where 0-5200 is the position's ROW_ID for 'Siebel Administrator' position.

How to implement using position name for 'Default Position' for assignment object 'PUB Case'. That is, to use 'Default Position' = Siebel Administrator.
Followed the steps in the document,Problem Setting The "Default Position” Property In Assignment Object (Doc ID 1925757.1)

After that,  'Default Position' on assignment object 'PUB Case' to Siebel Administrator and restart the AsgnSrvr (Assignment Manager) component to take effect of this change.
The AsgnSrvr component becomes offline upon restart. In AsgnSrvr log, there is the following error:

ERROR

SQLParseAndExecute Statement 4 000550385a5f04c8:0 2018-01-25 15:36:09

SELECT COUNT(*)

FROM SIEBEL.S_POSTN

WHERE NAME = ?

SQLParseAndExecute Bind Vars 4 000550385a5f04c8:0 2018-01-25 15:36:09 01:Siebel Administrator


SQLParseAndExecute Prepare + Execute 4 000550385a5f04c8:0 2018-01-25 15:36:09 Time: 0s, Rows: 0, Avg. Time: 0s [Row count does not apply to SELECT statements]

Loading Error 1 000550385a5f04c8:0 2018-01-25 15:36:09 The default posistion name is not unique

GenericLog GenericError 1 000550385a5f04c8:0 2018-01-25 15:36:09 (asgnobj.cpp (5007) err=1835035 sys=2) SBL-ASG-00027: Default position Siebel Administrator for assignment object PUB Case is not found in the positions table.

GenericLog GenericError 1 000550385a5f04c8:0 2018-01-25 15:36:09 (asgnobj.cpp (5661) err=1835032 sys=0) SBL-ASG-00024: Unable to load assignment object PUB Case.

GenericLog GenericError 1 000550385a5f04c8:0 2018-01-25 15:36:09 (asgnobj.cpp (313) err=1835032 sys=0) SBL-ASG-00024: Unable to load assignment object PUB Case.

GenericLog GenericError 1 000550385a5f04c8:0 2018-01-25 15:36:09 (asgnsrvr.cpp (1067) err=1835032 sys=0) SBL-ASG-00024: Unable to load assignment object PUB Case.

GenericLog GenericError 1 000550385a5f04c8:0 2018-01-25 15:36:09 (asgnsrvr.cpp (1291) err=1835032 sys=0) SBL-ASG-00024: Unable to load assignment object PUB Case.

GenericLog GenericError 1 000550385a5f04c8:0 2018-01-25 15:36:09 (smimtsrv.cpp (1203) err=1835032 sys=0) SBL-ASG-00024: Unable to load assignment object PUB Case.


REPRO STEPS

The issue can be reproduced at will with the following steps:

Step 1) Apply Solution in the following Doc:
Problem Setting The "Default Position” Property In Assignment Object (Doc ID 1925757.1)

1. Configure comdb*.sql in siebsrvr\bin and siebsrvr\sqltempl:

1.1 select DB_SCHEMA_VER from SIEBEL.S_APP_VER;
The query above contains the current DB Schema version. For example,
DB_SCHEMA_VER is 50.

1.2 check both locations for comdb.sql

[Siebel Dir]\siebsrvr\SQLTEMPL
and
[Siebel Dir]\siebsrvr\BIN

1.3 Copy the following statement from comdb45.sql to comdb50.sql:

; ===================================================
; SQL statements used by the ASSIGNMENT ENGINE (AE)
;====================================================

ASGN_OBJECT_DEFAULT_POSITION_COUNT =
SELECT COUNT(*)
FROM &Table_Owner.S_POSTN
WHERE NAME = ?
/

ASGN_OBJECT_DEFAULT_POSITION_ID =
SELECT ROW_ID
FROM &Table_Owner.S_POSTN
WHERE NAME = ?
/

and save the changes.

1.4. Restart Siebel Sever.

It is important to restart the Siebel Server service after modifying the  comdb*.sql file. And after Siebel Server is restarted, make sure the most  recent comdb*.sql file is the one you modified (the largest number such as 50
is the largest number among other comdb*.sql files and is the one you modified), and check the comdb*.sql file you modified and make sure the changes are there. If after Siebel Server restart a new comdb51.sql is
created in SQLTMPL and BIN folders and the changes you made are not in the new file, then you need to modify again on the new file in the 2 folders and
restart Siebel Server service, and check again.

After this configuration, the Assignment Manager should be started  successfully.

Step 2). Create an assignment rule on PUB Case assignment object, criteria: case status, Compare to Object; Value: Active. Position Candidates: add a position  there, e.g. AMPosition; click on Release button to refresh rulecache.dat.

Step 3). Change Default Position from 0-5220 to Siebel Administrator for PUB Case.  In Siebel Tools > Workflow Policy Object > PUB Case, Lock the Project, expand to get Assignment Object, choose Default Position property and change it from 0-5220 to Siebel Administrator.

Step 4). SADMIN logs into application, shutdown Assignment Manager component first  and then startup Assignment Manager component. The Assignment Manager becomes offline. In AsgnSrvr log, there is the following error:

SQLParseAndExecute Statement 4 000550385a5f04c8:0 2018-01-25 15:36:09

SELECT COUNT(*)

FROM SIEBEL.S_POSTN

WHERE NAME = ?

SQLParseAndExecute Bind Vars 4 000550385a5f04c8:0 2018-01-25
15:36:09 01:Siebel Administrator


SQLParseAndExecute Prepare + Execute 4 000550385a5f04c8:0 2018-01-25  15:36:09 Time: 0s, Rows: 0, Avg. Time: 0s [Row count does not apply to SELECT  statements]

Loading Error 1 000550385a5f04c8:0 2018-01-25 15:36:09 The default posistion  name is not unique
 

GenericLog GenericError 1 000550385a5f04c8:0 2018-01-25 15:36:09 (asgnobj.cpp  (5007) err=1835035 sys=2) SBL-ASG-00027: Default position Siebel  Administrator for assignment object PUB Case is not found in the positions
table.

GenericLog GenericError 1 000550385a5f04c8:0 2018-01-25 15:36:09 (asgnobj.cpp (5661) err=1835032 sys=0) SBL-ASG-00024: Unable to load assignment object PUB Case.

GenericLog GenericError 1 000550385a5f04c8:0 2018-01-25 15:36:09 (asgnobj.cpp  (313) err=1835032 sys=0) SBL-ASG-00024: Unable to load assignment object PUB Case.

GenericLog GenericError 1 000550385a5f04c8:0 2018-01-25  15:36:09 (asgnsrvr.cpp (1067) err=1835032 sys=0) SBL-ASG-00024: Unable to load assignment object PUB Case.

GenericLog GenericError 1 000550385a5f04c8:0 2018-01-25 15:36:09 (asgnsrvr.cpp (1291) err=1835032 sys=0) SBL-ASG-00024: Unable to load assignment object PUB Case.

GenericLog GenericError 1 000550385a5f04c8:0 2018-01-25  15:36:09 (smimtsrv.cpp (1203) err=1835032 sys=0) SBL-ASG-00024: Unable to load assignment object PUB Case.

SmiLayerLog Error 1 000550385a5f04c8:0 2018-01-25 15:36:09 Terminate process
due to unrecoverable error: 1835032. (Main Thread)

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.