My demo apps 9.0 tools 22.214.171.124 is using oracle xe database bundle
I am able to access the fat client on my demo (DEMO DEMO DEMO900) but
I am not able to access the web client (tools > EnterpriseOne Menu)
the jas log give : Exception occured in the JDESignon.jdeSignon() :BuildUserSession Failed. com.jdedwards.database.base.JDBException: [DATA_SOURCE_NOT_FOUND] Data source for F00921, TBLE not found. ([DATABASE_CONNECT_FAILED] Database Connection failed for DataSource System Local.)
java.sql.SQLException: Exception d'E/S: The Network Adapter could not establish the connection
the oracle db is actually crypted with the jdedwards encrypted pass but when i decrypt it i am able to connect via sqlplus
the listener is ok
the instance is ok
the database is ok
i look on the support for troubleshooting but none help or none where talking about e1 oracle standalone demo case only e1 sql standalone demo
Any ideas !!!
actually i correct the tns pb by just changing the value for tns in jdbj.ini giving the full path to this variable
tns = fullpath\tnsnames.ora
but still i have another error, i am able to connect, the screen display but there is no menu. It is first written 'loading' in the place where the open application should be just under the menu title ,and after i refresh the open application list that said ' you have no running application'. This is normal , but i have no menu
in the log :
err: This server will use the the <E1 Client Install Location>/DEMO/spec/spec.ini file to access the package specs for on-demand generation.
*20 mai 2012 21:02:47,127 [SEVERE] - [JAS] SpecException occured in the JDEOWDirect.getSpec(): | User Name : DEMO, Environment : DEMO900, Role : *ALL, Language : null com.jdedwards.base.spec.SpecException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource BSFNUBEDSTR-D9800150C.* java.sql.SQLException: No suitable driver
I already give a drvier 'ojdbc5.jar' is there another driver i should give ???
down in the log i also have this error : com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource OneWorld Local.
com.jdedwards.base.spec.SpecException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource BSFNUBEDSTR-D9800150C.