• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

EnterpriseOne Oracle VM 9.1

aarrgghh

Member
I'm implementing JDE 9.1 using the VM templates as a trial to build & test some SOAP/REST integration calls. Finally got the core (DB, app, AIS, and web) servers running in an Oracle VM system. I can get to the db, OneWorld starts and I can get to the web html app, but I can't sign into JDE on the web server. All of the default accounts don't seem to work.

I've done some digging and it appears there are no passwords in the SY910.F98OWSEC table (if I'm reading this right the encypted passwords should be in the table).

Anyone know what one of the valid accounts is supposed to be for these VM's?


 
Last edited by a moderator:

rsvconsulting

VIP Member
Enable the JDE user. We can either login to E1 as a different system user, which is already configured and enable JDE user in P98OWSEC. If such a user has not been configured, then we can modify the value in F98OWSEC directly using SQL command.

The sample query to be executed is given below.
SQL> update SY910.F98OWSEC SET SCEUSER=01 WHERE SCUSER='JDE';

SQL > commit;


Now try to login to E1 with JDE user or any user that has JDE as the proxy user.
 

aarrgghh

Member
Enable the JDE user. We can either login to E1 as a different system user, which is already configured and enable JDE user in P98OWSEC. If such a user has not been configured, then we can modify the value in F98OWSEC directly using SQL command.

The sample query to be executed is given below.
SQL> update SY910.F98OWSEC SET SCEUSER=01 WHERE SCUSER='JDE';

SQL > commit;


Now try to login to E1 with JDE user or any user that has JDE as the proxy user.

Thanks for the reply. I'm familiar with Oracle DB, but I'm totally new to JDE, so I really appreciate the help.

The JDE user was already enabled:

select scuser, sceuser from SY910.F98OWSEC where scuser = 'JDE';

SCUSER SCEUSER

---------- -------
JDE 01
JDE 01
JDE 01
JDE 01
JDE 01
JDE 01


6 rows selected
 

aarrgghh

Member
Here's the entire F98OWSEC table (had to put in a file to stay under the post limit): View attachment F98OWSEC.txt

It appears there are no passwords for any user in SCOWPWD or SCSECPWD (I'm assuming this is the system/db password to use and the first is the E1 password). On closer inspection these fields aren't null, they are 10 spaces. I feel like there's a step I'm missing here to set up user accounts, but I can't sign in to get to the [FONT=Helvetica Neue, Neue Helvetica, Arial, sans-serif]P0092 application to set up users.[/FONT]

This is the sign in with details shown. Are the Environment and Role fields correct?

JDE sign in.jpg

This is the error I get with any user from the F98OWSEC table and most passwords. However, if I use JDE/JDE here I get ' An unknown JAS sign in error occurred. Please contact the System Administrator.'
 

aarrgghh

Member
Ok, it appears I have a valid user/pass combo when I get the JAS error.

Here's an example from the jde.log on the app server:
5738/-169916720 SYS:Metadata Fri Feb 12 14:24:27.856414 jdb_utl1.c12665
JDB9900810 - Failed to populate address book number and user full name for user JDE


And the corresponding jdedebug.log:
Feb 12 14:24:27.855765 dbinitrq.c482 - 5738/-169916720 SYS:Metadata ORACLE DBInitReq conn=08247708 requ=08479f28 JDEDB (ovsorcl) new [ 1]
Feb 12 14:24:27.855802 dbsql_s.c1825 - 5738/-169916720 SYS:Metadata SELECT WWALPH FROM TESTDTA.F0111 WHERE ( WWAN8 = 304881.000000 AND WWIDLN = 0.000000 ) ORDER BY WWAN8 ASC,WWIDLN ASC
Feb 12 14:24:27.856187 dbfetch.c107 - 5738/-169916720 SYS:Metadata ORACLE DBFetch conn=08247708 requ=08479f28 maxrows=100
Feb 12 14:24:27.856212 dbfetch.c139 - 5738/-169916720 SYS:Metadata ORACLE DBFetch conn=08247708 requ=08479f28 fetched=0
Feb 12 14:24:27.856224 jdb_exef.c5569 - 5738/-169916720 SYS:Metadata No More Data found (hRequest 084debe0)
Feb 12 14:24:27.856234 jdb_rq1.c5391 - 5738/-169916720 SYS:Metadata Entering JDB_CloseTable (hRequest 084debe0)
Feb 12 14:24:27.856257 jdb_rq1.c5506 - 5738/-169916720 SYS:Metadata Entering JDB_CloseTable(Table = F0111)
Feb 12 14:24:27.856266 jdb_rqst.c1224 - 5738/-169916720 SYS:Metadata Entering JDB_ClearSequencing (hRequest 084debe0)
Feb 12 14:24:27.856275 jdb_rqst.c1317 - 5738/-169916720 SYS:Metadata Exiting JDB_ClearSequencing with Success
Feb 12 14:24:27.856283 jdb_rqst.c1374 - 5738/-169916720 SYS:Metadata Entering JDB_ClearSelection (hRequest 084debe0)
Feb 12 14:24:27.856291 jdb_rqst.c1493 - 5738/-169916720 SYS:Metadata Exiting JDB_ClearSelection with Success
Feb 12 14:24:27.856306 jdb_rqst.c2414 - 5738/-169916720 SYS:Metadata Entering JDB_ClearAggregate (hRequest 084debe0)
Feb 12 14:24:27.856315 jdb_rqst.c2550 - 5738/-169916720 SYS:Metadata Exiting JDB_ClearAggregate with Success
Feb 12 14:24:27.856323 jdb_rqst.c2854 - 5738/-169916720 SYS:Metadata Entering JDB_ClearGroupBy (hRequest 084debe0)
Feb 12 14:24:27.856331 jdb_rqst.c3012 - 5738/-169916720 SYS:Metadata Exiting JDB_ClearGroupBy with Success
Feb 12 14:24:27.856343 dbfreerq.c97 - 5738/-169916720 SYS:Metadata ORACLE DBFreeReq conn=08247708 requ=08479f28 CLOSE
Feb 12 14:24:27.856353 jdb_exet.c9033 - 5738/-169916720 SYS:Metadata Entering JDB_ClearBuffers (hRequest 084debe0)
Feb 12 14:24:27.856362 jdb_exet.c9149 - 5738/-169916720 SYS:Metadata Exiting JDB_ClearBuffers with success.
Feb 12 14:24:27.856372 jdb_rq1.c14627 - 5738/-169916720 SYS:Metadata Decremented table handle count to 0
Feb 12 14:24:27.856385 jdb_rq1.c5842 - 5738/-169916720 SYS:Metadata Exiting JDB_CloseTable(Table = F0111) with Success
Feb 12 14:24:27.856393 jdb_rq1.c5844 - 5738/-169916720 SYS:Metadata Exiting JDB_CloseTable with Success
Feb 12 14:24:27.856407 jdb_utl1.c12665 - 5738/-169916720 SYS:Metadata JDB9900810 - Failed to populate address book number and user full name for user JDE
Feb 12 14:24:27.856490 jdb_ctl.c710 - 5738/-169916720 SYS:Metadata Enter JDB_FreeCriticalSections. count=2
Feb 12 14:24:27.856505 jdb_ctl.c753 - 5738/-169916720 SYS:Metadata Exit JDB_FreeCriticalSections,count=1 to go
Feb 12 14:24:27.856517 jdb_ctl.c4893 - 5738/-169916720 SYS:Metadata Exiting JDB_InitEnvOvrExtended with Success (EnvHandle 081436d0) (OvrEnv DV910) (User JDE) (Role *ALL)
Feb 12 14:24:27.856526 jdb_ctl.c5957 - 5738/-169916720 SYS:Metadata Entering JDB_InitUser with (AUTO commit mode)
Feb 12 14:24:27.856540 jdb_tm.c65 - 5738/-169916720 SYS:Metadata Entering JDB_BeginTransaction (UserHandle 08443a58)
Feb 12 14:24:27.856555 jdb_tm.c89 - 5738/-169916720 SYS:Metadata Exiting JDB_BeginTransaction with Success (UserHandle 08443a58)
Feb 12 14:24:27.856566 jdb_ctl.c10623 - 5738/-169916720 SYS:Metadata Incremented huser count to 2
Feb 12 14:24:27.856574 jdb_ctl.c5966 - 5738/-169916720 SYS:Metadata Exiting JDB_InitUser with Success (UserHandle 08443a58)

It appears the error may be the JDB9900810, but then the debug has this 'Exiting JDB_InitUser with Success'.

Any thoughts on how to fix this?
 

aarrgghh

Member
Quick follow up. The JDB9900810 isn't the problem. I've cleared that by manually putting an entry in the F0111 table for the JDE user. Still getting the unknown JAS error on sign in.
 
Top