Slow Info Desktop

[JonRob]

Hi,

We are experinecing problems with logging onto and navigating the Info Desktop.

Since moving to Info 7.5 we find this very slow despite the fact that reports still process very quickly.

Any ideas ?

 

[rhinok]

It most likely has to do with your Info System Database.

From which version did you upgrade? 6 or 7? Did you upgrade the Info Database or do you point to the old database? What database do you use? Is it still the Access database? If so, how big is it?

What's your folder structure like? Do you have a lot of shared points?

What's your security like? Do you have tighly controlled user groups with access to certain folder layers only or can all users see all the folders?

What's your network connection like?

All these things can contribute to the problem you have experienced. You should probably analyze your Info setup closely in order to determine the cause of the problem.

 

[JonRob]

Hi,

Sorry about the delay replying but we were trying a few things.

Our setup is :

We have two APS's and 6 Info Servers and a seperate server that stores the Input and Output files. The system Db resides on a Oracle 8i Db which is on a clustered Alpha box.

All the hardware is new and high spec. ie dual processors, loads of memory and disc space and dual network cards.

So far we have tried :

Dropping one APS from the cluster
Switching off one Network Card on the remaining APS
Increasing Space avaliable to the Cinfo DB
Unclustering the Cinfo Db.

None of the above seems to help.

Analysing the NT Application log on the APS we find a steady stream of 'Database Exception Error' messages.

Any Clues ?

 

[rhinok]

You probably have corrupt records in your system database. I, too, had many of those 'Database exception errors'. This, coincidentally, occurred after upgrading.

Within the text of your error messages you may find reference to specific process id's (CI_PRCID) in the system database. This may lead you to the corrupt records.

Also, as a Seagate Info Admin, you should modify the following registry key on your pc:

HKEY_CURRENT_USER\Software\Seagate Software\Seagate Info\ShowInstanceID to be equal to "Yes".

This will show the process ID for that specific instance in the CI_RUNTIMEIMAGE table. This will also assist you in troubleshooting your corrupt records.

With assistance from Priority Support, I was able to isolate the corrupt records and delete them (after backing up the system database, etc...). Sometimes, Priority Support can actually help...