IBM Support

Logon problems in WMSYantra

Troubleshooting


Problem

Logon problems in WMSYantra

Symptom

PART: Yantra WMS

When trying to log into Wms, the following message is recieved. " Oracle Error : -1435 Sqlcode [0] SQLCD [ORA-01435 user does not exist] SqlMessage: ORA-01435: user does not exist. I am
getting this error upon logon. I can still get into the system after it
shows this error several times

Cause

Resolving The Problem

The problem was we recreated the Oracle database giving it a different SID. When I created the new warehouse, I kept the same name as the old warehouse in the old SID. All these records were still on the warehouse schema map files. So when the system referred to the files, it looked at the warehouse code on the old SID. That created the user and table/sequence problem.

[{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Historical Number

PRI47844

Product Synonym

[<p><b>]Fact[</b><p>];

Document Information

Modified date:
16 June 2018

UID

swg21544652

Page Feedback