Unable to connect to E1local

jimmymac

Reputable Poster
I have an issue I believe is related to an expired JDE password. I was able to sign on to my local fat client this past Wednesday 3/13, and did notice a reminder that my password was going to be expiring in 3 days.

Since 3/13, I was on vacation until today. My first attempt to sign on to my local client today, I got the dreaded Unable to Connect to E1Local message. Messages in the JDE.LOG are noted below. It never prompted me to change my password but just gets these Unable to Connect to E1Local messages.

When looking at the JDE.LOG, it mentions the password being expired. So we reset my password on another fat client. I can sign on the web, but when i try local, it still gives me the Unable to Connect error, and still shows password expired in the JDE.LOG.

Any advice on how to correct would be appreciated.


5544/2948 MAIN_THREAD Mon Mar 18 15:29:49.987001 dbinitcn.c899
OCI0000065 - Unable to create user session to database server

5544/2948 MAIN_THREAD Mon Mar 18 15:29:49.988001 dbinitcn.c904
OCI0000141 - Error - ORA-28001: the password has expired

5544/2948 MAIN_THREAD Mon Mar 18 15:29:49.988004 dbinitcn.c520
OCI0000367 - Unable to connect to Oracle ORA-28001: the password has expired

5544/2948 MAIN_THREAD Mon Mar 18 15:29:49.989001 Jdb_drvm.c936
JDB9900164 - Failed to connect to E1Local

5544/2948 MAIN_THREAD Mon Mar 18 15:29:52.336001 Jtp_cm.c284
JDB9909003 - Could not init connect.

5544/2948 MAIN_THREAD Mon Mar 18 15:29:52.337001 Jtp_tm.c1135
JDB9909100 - Get connect info failed: Transaction ID =

5544/2948 MAIN_THREAD Mon Mar 18 15:29:52.337003 Jdb_rq1.c2441
JDB3100013 - Failed to get connectinfo

5544/2948 MAIN_THREAD Mon Mar 18 15:29:52.338004 SpecOpen.c2633
jdeSpecOpenLocalOpt completed in error - JDESPECRESULT_JDBFAILED.
 

Attachments

  • 182186-jde_5544_031813.txt
    101.2 KB · Views: 165
Jimmy,

The database user id password has expired. It is probably the system user id assigned to your JDE user id.
 
Thanks Peter, but how to correct it is the issue now. Also note that all of our users can access JDE fine over the web, and other developers can use their fat client, so I don't see quite how it is a JDE admin password issue, unless I'm misunderstanding the issue.
 
Had same issue a couple of weeks ago. See Oracle support doc 1377587.1
 
Jimmy,

I missed the "Failed to connect to E1Local".

As RAMMEDJR pointed out it is the password on the E1local database that has expired and will only effect users on that fat client.

If I remember correctly, to fix it you need to follow a process to unencrypt passwords, log in, fix the problem, log out, then re-encrypt. However the oracle doc that RAMMEDJR mentioned will provide all the detail.

I just tried to access it, but it was not available.
 
Oracle support had to send me the document as i was also unable to get off the support site. I have attached. Also, google search for 'Recover Lost or Corrupt Password in E1 Local (OEE) Database'
 

Attachments

  • 182209-E1_1377587.doc
    926 KB · Views: 1,238
Back
Top