We are having problem with SDM on acceptance. We are planning an upgrade to version 20, but before continuing, we would like to fix this issue.
The error message: "Sorry, staging Area is not available. Error code : 1326"
You may need to:
- Check if database users ELNSDMr and ELNSDMw are not locked for any reason, and unlock them (how to: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/axdbi/using-sql-plus-to-unlock-accounts-and-reset-passwords.html )
- Re-crypt the DM_Account passwords. This is done by logging into the database as the SDM schema owner and running a statement like:
update dm_account set accountpassword = crypt('Password') where accountname = ‘AccountName’;
You need to do that for ELNSDMr (read) and ELNSDMw (write) accounts.