E-DM:- Datamover Login Shows "Invalid User ID and password for signon"

(Doc ID 1595781.1)

Last updated on NOVEMBER 20, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.53 and later
Information in this document applies to any platform.

Symptoms

When  logging into datamover in usermode with tools 8.53 the error "Invalid User ID and password for signon"  is displayed.

The  SQL  Trace shows:

PID-Line  Time        Elapsed  Trace Data...
--------  --------  ---------- -------------------->
1-1      19.24.51             Tuxedo session opened {oprid='PS', appname='TwoTier', addr='//TwoTier:7000', open at 02F3CC58, pid=4884}
1-2      19.24.53    2.585000 Cur#0.4884.XXXXXXX RC=0 Dur=0.041000 Create Connection Info=Primary/XXXXXXX/people/ Handle=02F60250
1-3      19.24.53    0.004000 Cur#1.4884.notSamTran RC=0 Dur=0.004000 Open Cursor Handle=02F60250
1-4      19.24.53    0.000000 Cur#1.4884.XXXXXXX RC=0 Dur=0.000000 COM Stmt=SELECT OWNERID FROM PS.PSDBOWNER WHERE DBNAME=:1
1-5      19.24.53    0.000000 Cur#1.4884.XXXXXXX RC=0 Dur=0.000000 Bind-1 type=2 length=7 value=XXXXXXX
1-6      19.24.53    0.000000 Cur#1.4884.XXXXXXX RC=0 Dur=0.000000 Fetch
1-7      19.24.53    0.001000 Cur#1.4884.XXXXXXX RC=0 Dur=0.001000 COM Stmt=SELECT OWNERID, TOOLSREL, TO_CHAR(LASTREFRESHDTTM,'YYYY-MM-DD HH24:MI:SS'), TO_CHAR(LASTCHANGEDTTM,'YYYY-MM-DD HH24:MI:SS') FROM SYSADM.PSSTATUS
1-8      19.24.53    0.001000 Cur#1.4884.XXXXXXX RC=0 Dur=0.000000 Fetch
1-9      19.24.53    0.000000 Cur#1.4884.XXXXXXX RC=0 Dur=0.000000 COM Stmt=SELECT DBID FROM SYSADM.PSSTATUS
1-10     19.24.53    0.000000 Cur#1.4884.XXXXXXX RC=0 Dur=0.000000 Fetch
1-11     19.24.53    0.000000 Cur#1.4884.XXXXXXX RC=0 Dur=0.000000 COM Stmt=SELECT VERSION, OPERPSWD, OPERPSWDSALT, ENCRYPTED, SYMBOLICID, ACCTLOCK FROM SYSADM.PSOPRDEFN WHERE OPRID = :1
1-12     19.24.53    0.000000 Cur#1.4884.XXXXXXX RC=0 Dur=0.000000 Bind-1 type=2 length=2 value=PS
1-13     19.24.53    0.001000 Cur#1.4884.XXXXXXX RC=0 Dur=0.000000 Fetch
1-14     19.24.53    0.000000 Cur#1.4884.XXXXXXX RC=0 Dur=0.000000 Disconnect
1-15     19.24.53    0.009000 Cur#0.4884.notSamTran RC=0 Dur=0.009000 Destroy Connection Handle=02F60250
1-16     19.24.53    0.035000 Cur#0.4884.notSamTran RC=1045 Dur=0.035000 Create Connection Info=Primary/XXXXXXX/PS/ Handle=00000000.

 

The above trace is missing the SQL statement

SELECT ACCESSID, ACCESSPSWD, ENCRYPTED FROM SYSADM.PSACCESSPRFL WHERE SYMBOLICID = :1

 

Also  last  statement in the trace "Create Connection Info=Primary/XXXXXXX/PS/ Handle=00000000"  shows it is trying to connect to the database using "PS" instead of  "SYSADM".

 

Changes

 The Oracle client  on the machine  is using 11.2.0.1.0.  but the supported release is 11.2.0.3.0.

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