My Oracle Support Banner

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

Last updated on MARCH 19, 2018

Applies to:

Siebel CRM - Version 15.5 [IP2015] and later
Information in this document applies to any platform.

Symptoms

On : 15.5 [IP2015] version, Assignment Manager

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.

We want to implement using position name for 'Default Position' for assignment object 'PUB Case'. That is, we want to use 'Default Position' = Siebel Administrator.
We follow the Solution in the following Doc which has the required configuration for this implementation:
Problem Setting The "Default Position” Property In Assignment Object (Doc ID 1925757.1)

After that, we set '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)



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!


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