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
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