E-INST: ENCRYPT PASSWORD ERROR:Return: 904 - ORA-00904: "OPERPSWDSALT": invalid identifier (Doc ID 1530693.1)

Last updated on JULY 19, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.53 and later
Information in this document applies to any platform.
*** Checked for relevance on 13-Aug-2014***

Symptoms

ISSUE STATEMENT
------------------------
When customer is  installing 8.53 with FSCM 9.1 FP2.

While running encrypt.dms in datamover during the Database creation getting the error


FileName
------------
encrypt.log shows the below error while running the Database import script

FileComment
-----------------
shows the message

Started:  Tue Feb 19 11:33:24 2013
Data Mover Release: 8.53
Database: FS91DMO (ENG)
File: E:\pt853-903-R1-retail\peopletools\src\pssys\stmupd.cppSQL error. Stmt #: 1408  Error Position: 50  Return: 904 - ORA-00904: "OPERPSWDSALT": invalid identifier
Failed SQL stmt: UPDATE PSOPRDEFN SET     VERSION = :2,     OPERPSWD = :3,     OPERPSWDSALT = :4,      ENCRYPTED = :5, LASTPSWDCHANGE =TO_DATE(:6,'YYYY-MM-DD')     WHERE OPRID = :1
Error: Process aborted. Possibly due to JVM is not available or missing java class or empty password.
Ended: Tue Feb 19 12:34:41 2013
Unsuccessful completion

STEPS
---------
The issue can be reproduced with the following steps:
1. login in DataMover in Bootstrap mode
2. Run encrypt.dms


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms