JDeveloper with B9 Standalone - BSSV Lab

[OWDev]

Hi JDEList,

I have searched through the site and also on the web for a solution but to no avail.

I am trying to do a hands on lab for BSSV and have installed B9 Standalone and JDeveloper 10.1.3.5.

I am able to create a BSSV object and also launch JDeveloper from OMW. The lab I am doing requires me to create a Database Value Object Class. But when I run through the wizard and specify a table and press Find I get the error below in the message log.

"Can not load Table/View records - [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource Object Librarian Local.class com.jdedwards.database.base.JDBException"

I have no issues creating a Business Function Value Object Class through the wizard and my local web works fine as well.

Any helps on the above would be greatly appreciated.

-----------------------------------------------------------------------------------
E900 Demo - SSE
Tools 8.98.31
JDeveloper 10.1.3.5

 

[Chan Rana]

Try to genearte HTML spec for the table thru OMW if that doesnt fix then you might have to look into INIs and ODBC

Chan

 

[OWDev]

Hi Chan,

Thanks for replying. I generated the HTML specs and tried it again but still no luck. I then did a check out and check in of the object and then tried it again and still no luck. My INI's and ODBC's are fine as my local web launches. Can you attach your INI files for me to look at. I assume it is the JDBJ.INI that is the culprit.

Regards
Sam

 

[jitender]

Hi Sam

Tried to check for JDE.log file what you are missing.
Most probabaly your JDE account for the JDE databases is not enabled.
Tried to Reset the password for JDE in SQL Server and try again.

Hopefully it will resolve the problem.

But try first with checking the jde.log file what exactly you are missing.


Regards
Jitender

 

[Chan Rana]

Sam,
Turn on the BSSV log and see what you get in the debug log. This can give you some more info. You can also turn on toher debug logs.

Chan

 

[OWDev]

Hi Chandra,

Thanks for getting back. Can you point me to where/which INI I can actually turn the BSSV logs on. I looked at the jde.log and see nothing there either.

Regards
Sam

 

[OWDev]

Hi Jitender,

Thanks for your post. I see nothing of interest in the jde.log file. Re setting my password in SQL Server can you give me some step by step instructions or point me to where I can obtain this information. Please note that looking up business functions works but not tables.

Regards
Sam

 

[eewon]

The BSSV.log (as well as jas.log, jderoot.log and jasdebug.log) is turned on in the c:\e900\<pathcode>\ini\sbf\jdelog.properties file. The logs are probably already turned on by default, but the Oracle recommendation is that you change the relative paths of the log files to absolute ones so that you can easily find them.

 

[JDE kid]

All,

I too am facing exactly the same problem as OWDev (Database Value Object Class creation fails with error: "Can not load Table/View records - [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource Object Librarian Local.class com.jdedwards.database.base.JDBException".

Here's what the BSSV.log file gives:

06 May 2011 07:48:23,060 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [INTEROP] Session clearning thread started
06 May 2011 07:48:23,076 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [INTEROP] Connector shut down completely
06 May 2011 07:48:23,107 [Line ?] [checking usersession] [DEBUG ] - [INTEROP] Java Connector user session timeout-checking thread has been interrupted. java.lang.InterruptedException: sleep interrupted
java.lang.InterruptedException: sleep interrupted
at java.lang.Thread.sleep(Native Method)
at com.jdedwards.system.connector.dynamic.Connector$SessionClearingThread.run(Unknown Source)
at java.lang.Thread.run(Thread.java:595)
06 May 2011 07:59:36,311 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [INTEROP] Session clearning thread started
06 May 2011 07:59:36,311 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [INTEROP] UserSessionListener oracle.e1.ide.sbfextension.auth.AuthenticationPanel[,0,0,0x0,invalid,layout=java.awt.BorderLayout,alignmentX=0.0,alignmentY=0.0,border=,flags=9,maximumSize=,minimumSize=,preferredSize=] has been added to the connector
06 May 2011 07:59:40,773 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [INTEROP] User session -1748281199 for user DEMO has been created.
06 May 2011 07:59:40,773 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [INTEROP] User DEMO has login successfully
06 May 2011 07:59:51,677 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [INTEROP] UserSessionListener oracle.e1.ide.sbfextension.database.DBConnectorGateway@14cda3 has been added to the connector
06 May 2011 07:59:51,818 [Line ?] [AWT-EventQueue-0] [SEVERE] - [BSSVFRAMEWORK] com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource Object Librarian Local.
06 May 2011 07:59:59,649 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [INTEROP] User session -1748281199 for user DEMO has been terminated.
06 May 2011 07:59:59,649 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [INTEROP] User session -1748281199 for user DEMO log off completely
06 May 2011 08:01:29,131 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [INTEROP] UserSessionListener oracle.e1.ide.sbfextension.auth.AuthenticationPanel[,0,0,0x0,invalid,layout=java.awt.BorderLayout,alignmentX=0.0,alignmentY=0.0,border=,flags=9,maximumSize=,minimumSize=,preferredSize=] has been added to the connector
06 May 2011 08:01:29,255 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [INTEROP] User session 1158449078 for user DEMO has been created.
06 May 2011 08:01:29,255 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [INTEROP] User DEMO has login successfully
06 May 2011 08:02:08,552 [Line ?] [AWT-EventQueue-0] [DEBUG ] - [INTEROP] UserSessionListener oracle.e1.ide.sbfextension.database.DBConnectorGateway@1b80053 has been added to the connector
06 May 2011 08:02:08,583 [Line ?] [AWT-EventQueue-0] [SEVERE] - [BSSVFRAMEWORK] com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource Object Librarian Local.

Here's the jde.log contents:

7368/4240 MAIN_THREAD Fri May 06 00:45:55.101000 Jdb_ctl.c4065
Starting OneWorld
7964/6544 UNKNOWN Fri May 06 00:45:59.282000 jdeksec.c778
INITIALIZING SECURITY SERVER KERNEL
7964/6544 UNKNOWN Fri May 06 00:45:59.313000 Netpub.c975
JDENet already initialized
7964/6544 UNKNOWN Fri May 06 00:45:59.328000 Jdb_ctl.c2964
Net init failed or not initialized
7964/3240 UNKNOWN Fri May 06 00:49:17.492000 XMLRequest.cpp1264
ICU0000017 - ICU CodePage for 1252 is ibm-1252.
7964/1984 MAIN_THREAD Fri May 06 00:49:17.492001 Netpub.c3406
Info:Net program ended(JDENET_RunNet), pid = 7964, JDENETError = 0
7964/1984 MAIN_THREAD Fri May 06 00:49:17.508000 ipcmisc.c299
API ipcSawUnregisterProcV1 : process 7964 unregistered in entry 0

Any pointers highly appreciated.


E1 900/8.98.31 Demo
Oracle DB
JDeveloper - 10.1.3.4.0
Windows 7 Professional 64 bit

 

[KeerthiKiran]

Hi

1) Create a new E1Local database user using sqlplus
2) Give Sys user rights for the new Database User created.
3) Create same user/password for JDE Standalone also.
4) Login JDE Using New User
5) Connect JDeveloper, Try Creating ValueObjects. you will get all work done.