Troubleshooting
Problem
On updating an user from Application Manager (e.g. adding a group subscription), RCP SOM will fail to login for that specific user. Login will fail throwing ORA-0 error with following query.
SELECT /*YANTRA*/ yfs_user.createts, yfs_user.modifyprogid, yfs_user.modifyts, yfs_user.createuserid,
yfs_user.createprogid, yfs_user.modifyuserid, yfs_user.user_key, yfs_user.lockid
FROM yfs_user YFS_USER
WHERE yfs_user.user_key = ? AND yfs_user.lockid = ?
yfs_user.createprogid, yfs_user.modifyuserid, yfs_user.user_key, yfs_user.lockid
FROM yfs_user YFS_USER
WHERE yfs_user.user_key = ? AND yfs_user.lockid = ?
Symptom
Steps to reproduce:
1. Launch Application Manager. In Application Platform, go to Security > Users.
2. Open User Details for any Node User (e.g. N1U1).
3. In Group Subscriptions section, add a group subscription (e.g. STORE-MANAGER) and save changes.
2. Open User Details for any Node User (e.g. N1U1).
3. In Group Subscriptions section, add a group subscription (e.g. STORE-MANAGER) and save changes.
4. Login to RCP SOM with user N1U1.
Actual Result: Login will fail with ORA-0 error | Could not find entity (probably changed lockid).
Cause
The housekeeping fields are not available in the memory.
Environment
IBM Sterling RCP SOM 9.3
Resolving The Problem
Steps to resolve:
1. Set the property (yfs.yfs.unset.dbhk.fields.YFS_USER=false) in customer_overrides.properties.
2. Restart the application server
_________________________________
2. Restart the application server
_________________________________
This property will disable unsetting of house keeping fields (createts, modifyts, createprogid, modifyprogid, createuserid, modifyuserid) on the specific table YFS_USER after loading the records. Note that by setting this property the house keeping fields of YFS_USER (or any other table configured in similar way) will be kept in memory.
This should not affect the performance as the property affects only YFS_USER table and the cache will retain
house keeping columns apart from all other data in YFS_USER table which is loaded by the entity framework as usual.
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS6PEW","label":"Sterling Order Management"},"Component":"","Platform":[{"code":"PF002","label":"AIX"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Was this topic helpful?
Document Information
Modified date:
27 February 2019
UID
ibm10871242