Cannot determine what is causing JDE.LOG entries

[radi8]

On my Dev box, when working with the WAS 6.1 WEB DEV and debugger, I am getting the following entries in my JDE.LOG
<font class="small">Code:</font><hr /><pre>
4220/1736 MAIN_THREAD Wed Feb 25 10:38:07.385000 Jdb_omp1.c587
JDB9900245 - Failed to find F98611 Local in cache

4220/1736 MAIN_THREAD Wed Feb 25 10:38:07.385001 Jdb_rq1.c1823
JDB3100011 - Failed to get location of table F989999 for environment PY811

4220/1736 MAIN_THREAD Wed Feb 25 10:38:07.385002 Jdb_utl1.c11663
JDB9900603 - Failed to open table F989999
</pre><hr />
I have looked at the OCM, JDE.INI, JDBJ.INI, and JAS.INI and cannot see anything obviously out of line in any of them. Can anyone provide any suggestions on what may be causing them and how to get rid of them?

 

[Tom_Davidson]

Check your JDE.ini under [DB SYSTEM SETTINGS]
check that Base Datasource= , etc. is correct and the ODBC really exists.

You may also want to put it in debug and check the jdedebug.log

Tom

 

[radi8]

I couldn't see the forest for the trees... found an invalid ODBC reference in the secondary Data Sources section.

Thanks for the help.

 

[brother_of_karamazov]

Post your jde.ini with references to passwords removed.


[ QUOTE ]
I couldn't see the forest for the trees... found an invalid ODBC reference in the secondary Data Sources section.

Thanks for the help.

[/ QUOTE ]

 

[vikks]

Check your database data sources. the servername - E811 Server map in the Locala datasources causes this issue. If there isnt a datasource by the name of the database mapping to the Py811 application server create it.

 

[radi8]

There was an entry in the Secondary Data Sources pointing to the local database name: PS811 but the actual local database is PY811. Once I corrected this, the log entries went away.

I am now trying to determine where in the installation process of the local MSDE that database name is defined. I will change the JDE.INI on the deployment server to match what the MSDE Install engine is actually creating.

 

[Jfreyre]

Hi those errors are produced by some deconfiguration in the jdbj.ini and jde.ini for a webdeveloper fat client... take a look at this, and make the changes you would need to make it work (ie: if you are not using your DV811 pathcode)

Resolution:
To stop the errors from showing up in the JDE.log file you have to create a couple of ODBC connections for your local workstation and change some values in the JDE.ini and the JDBJ.ini files on your local workstation.

C:\ jde.ini
X:\E811\JAS\EA_JAS_80.ear\webclient.war\WEB-INF\jdbj.ini



In your JDE.ini file make the following change:

[DB SYSTEM SETTINGS - SECONDARY]
Base Datasource=OneWorld Local - DV811

to

[DB SYSTEM SETTINGS - SECONDARY]
Base Datasource=Local - DV811

And

[LOCALWEB]
Spec Datasource=OneWorld Local – DV811

to

[LOCALWEB]
Spec Datasource=Local – DV811
Make the following change in the JDBJ.ini:

[JDBJ-SPEC DATA SOURCE]
name=OneWorld Local – DV811

to

[JDBJ-SPEC DATA SOURCE]
name=Local – DV811

Add the following ODBC values to your local System DSN.

 Local – DV811
 EnterpriseOne Local

Steps to complete the adding of a local ODBC Data Source.
1. As an Administrator, log onto local workstation.
2. Go to Start>All Programs>Administrative Tools>Data Source (ODBC)