starting enterprise server services

andy_smith

Well Known Member
List,

We have an issue were all reports stopped running on our enterprise server
and on bouncing the services all workstations being unable to connect with
'unable to locate security server' error.

When the services start up, they produce log files that are full of errors
being unable to read the F9200 table (Data Dictionary Master) like follows
:-

1280/1192 Thu Feb 21 12:10:52 2002 jdeksec2753
INITIALIZING SECURITY SERVER KERNEL

1280/1192 Thu Feb 21 12:10:52 2002 JDB_RQ11139
JDB3100001 - Failed to validate user handle

1280/1192 Thu Feb 21 12:10:52 2002 JDEDDAPI3320
JDB9910147 - Unable to open F9200

1280/1192 Thu Feb 21 12:10:52 2002 JDEDDAPI1196
JDB9900147 - Unable to open F9200

1280/1192 Thu Feb 21 12:10:52 2002 JDB_RST2664
JDB9900324 - Failed to find Data Dictionary Item

1280/1192 Thu Feb 21 12:10:52 2002 JDB_RST329
JDB9900299 - Failed to create global table specs for F98611

1280/1192 Thu Feb 21 12:10:52 2002 JDB_RQ11139

Hence the services have not started correctly giving rise to all the other
problems.

Anyone seen this before, nothing has changed recently except it is possible
that Data Dictionary replication got turned on then off again - could the
data dictionary be corrupt ?

When the services start there is no evidence in the SQLServer Profiler trace
whereas on another similar installation the SQLServer trace shows many SQL
requests coming from the service as it starts up.

Any ideas anyone ?

Xe Update32 SP16 Win2000 Server, SQLserver2000




Andy Smith
Technical Consultant

WHITEHOUSE
Consultants

http://www.whitehouse-consult.co.uk

Office: 01564-711037
Mobile: 07949 603770





Andy Smith
Whitehouse Consultants
Win2K SQLServer7 Xe
 
Andy,

Check that the user handle in your enterprise server jde.ini is valid.
It is in a couple of places in that file. Typically, you will find
user = jde, password = jde until it is changed.

To test, try signing onto the SQL database with the user/password combination in your ini file...case matters!

Good Luck...

owguru (at least I'm trying :)
>all versions
>all platforms
 
We had a similar problem that was fixed by "relaying" the service package on
the Enterprise server. For some unknown reason, the Jdekrnl files (Bin32)
had been modified. After the SP refresh the services start error free.

Regards,
David Roy

OW XE, NT4.0, SQL7.0 SP3, Citrix MetaFrame 1.8 SP3.
 
hello andy_smith

I recommend you to check the following:

1. Do the services jdenetwork and jdequeue are installed and start correctly?
Note: the jdenetwork service must be installed first and the the jdequeue, the same for starting the services, giving them a valid account preceded by the domain.

2. Is the jde.ini of your enterprise server lodated under the jdedwardsoneworld\ddp\b7333\system'bin32 directory?

3. In the jde.ini of your enterprise server check the section [SECURITY]
SecurityServer=enterprise_server
User=jde
password=jde
DefaultEnvironment=xx7333
DataSource=System - B7333 (Data Source where the F98owsec is located)

4. Are all datasources configured in your enterprise server?
The System data source checks the security table and the Server Map data source checks the OCM mapping for the security table.

5. Is mdactyp 2.6 (for sql server 2000) installed in the server where your f98owsec table resides?

6. Is the f98owsec table marked through sql server to be accesed by the jde user (permissions sql).

7. The f9200 table is one of the tables that is being accessed when running PORTTEST, verify this by rerunning the PORTTEST, if it fails check the Data Dictionary data source.


8. Verify your ocm mappings for system - b7333 and server maps.


I hope it can be helpful in any way!
I woul like to help you troubleshoot this problem.
Good Luck

Juan Botero
System Administrator
Network Administrator
Enka de Colombia S.A
574-4054472
574-4054564
 
Hallo andy,
have you configured correctly ODBC datasource on your enterprise server too?
Gigi
 
Back
Top