Local Database 8.x Login Issue error SBL-DAT-00559: No positions associated with login user (Doc ID 534364.1)

Last updated on JANUARY 27, 2023

Applies to:

Symptoms

SBL-DAT-00556, SBL-DAT-00558

User had completed Database Extract for a User Id "<Username>" in Server. The user has valid Responsibilities and position and able to login ok in Web Client.
The sse_data.dbf Extract was successful in local. The Siebel Remote Client fails for User Id / Password when trying to Login .

For other users Id's the DB Extract/ initialization / Login to Remote is OK.

Logging into the database trough dbisqlc.exe using the mobile client’s login and password was successful.

On the log file found the following messages were found:

Siebel.log:

 ObjMgrSessionLog    Error    1    0    2005-09-23 13:51:56    (dmsessionusercontext.cpp (1414)) SBL-DAT-00559: No positions associated with login user '<Username>'.

ObjMgrSessionLog    Error    1    0    2005-09-23 13:51:56    (dmsessionusercontext.cpp (1440)) SBL-DAT-00558: An error occurred that prevented setting a primary position for the login user.
This operation was being attempted because the no primary position was found for the user '<Username>'. See additional error messages for more information.

ObjMgrSessionLog    Error    1    0    2005-09-23 13:51:56    (dmsessionusercontext.cpp (1766)) SBL-DAT-00556: The position related context could not be established for login name '<Username>'.

The following queries were executed and showed that the position entry in the local database was correct: 

SELECT * FROM SIEBEL.S_USER WHERE LOGIN = '<Username>'

ROW_ID='1-MR6NX'

SELECT * FROM SIEBEL.S_POSTN WHERE ROW_ID='1-MR6O5'

PR_EMP_ID='1-MR6NX'

SELECT * FROM SIEBEL.S_NODE

EMP_ID='1-MR6NX'

SELECT * FROM SIEBEL.S_PARTY WHERE ROW_ID='1-MR6O5'

ROW_ID='1-MR6O5'

The behavior was reproducible after the mobile user’s re-extraction.

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.