IBM Support

IBM Sterling Order Management - User unable to login into Store 360 application and gets an INVALID USER message

Troubleshooting


Problem

Users unable to login into Store 360 application and gets an INVALID USER message

Symptom

Application log displays below error -
[12/9/23 15:48:33:295 GMT] 000006ce SystemOut              O 2023-12-09 15:48:33,295:ERROR  :Default Executor-thread-423: Login Failed. User [null] Client IP address[xx.xxx.xxx.xx] : <?xml version="1.0" encoding="UTF-8"?>
<Errors>
    <Error ErrorCode="YCP0084"
        ErrorDescription="Invalid User identifiers passed." ErrorRelatedMoreInfo="Invalid login credentials">
        <Attribute Name="ErrorCode" Value="YCP0084"/>
        <Attribute Name="ErrorDescription" Value="Invalid User identifiers passed."/>
        <Attribute Name="ErrorRelatedMoreInfo" Value="Invalid login credentials"/>
        <Attribute Name="UserId" Value="system"/>
        <Attribute Name="ProgId" Value="system"/>
        <Stack>com.yantra.yfc.util.YFCException
    at com.yantra.ycp.sm.server.YCPSecurityManager.login(YCPSecurityManager.java:221)
    at com.yantra.ycp.sm.server.YCPSecurityManager.login(YCPSecurityManager.java:130)

Cause

On login, in WSCAuthProvider, store app calls getOrganizationHierarchy on the ship node to set some store fields in the session. The following error is being thrown by this call after the login. Now when yfs.unset.dbhk.fields.YFS_SHIP_NODE property is correctly set, the following sql will not even run. One can confirm this in the API log.

ErrorDescription="Could not find entity ( probably changed lockid) [ SELECT YFS_SHIP_NODE.CREATETS,YFS_SHIP_NODE.MODIFYPROGID,YFS_SHIP_NODE.MODIFYTS,YFS_SHIP_NODE.CREATEUSERID,YFS_SHIP_NODE.CREATEPROGID,YFS_SHIP_NODE.MODIFYUSERID,YFS_SHIP_NODE.SHIPNODE_KEY,YFS_SHIP_NODE.LOCKID FROM YFS_SHIP_NODE YFS_SHIP_NODE WHERE YFS_SHIP_NODE.SHIPNODE_KEY=? AND YFS_SHIP_NODE.LOCKID=? ]"

Resolving The Problem

To resolve this issue, configure the below mentioned property in customer_overrides file and restart the app server. 
yfs.unset.dbhk.fields.YFS_SHIP_NODE=false 
Post this change, user will not observe login issue for Store 360 application. 

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"ARM Category":[{"code":"a8m0z000000cxzVAAQ","label":"Call Center Store and SIM"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Document Information

Modified date:
28 May 2024

UID

ibm17154972

Page Feedback