Key Performance Tool error

dsatria · **Posted:** Mon Dec 06, 2010 12:32 pm

Hi,

We're using NAV 4.0 without SP with SQL Option (SQL 2000 SP3a)

I successfully installed "Key Information Tool".fob and setup SQL Connection (Test Connection succeeded)
Load Text Objects didn't return any error but when we clicked "Get SIFT Info" threw an error like this:

Any idea what's wrong? I tried with 2 tables (G/L Entry and Warehouse Entries) but same error occured.
Thanks in advance

Regards,
David

stryk · **Posted:** Mon Dec 06, 2010 1:35 pm

Hi David,

well, I guess you have to debug this - I don't have the tool available, but obviously there's something wrong with the ADO connection string:

There should be a line like this:

Code: Select all

...
ADOConnection.DefaultDatabase(GetCurrentDatabase);
...

And the function should look like this:

Code: Select all

GetCurrentDatabase() : Text[250]
Databases.SETRANGE("My Database", TRUE);
Databases.FINDFIRST;
EXIT(STRSUBSTNO('[%1]', Databases."Database Name"));

If this does not work, maybe you could "hard-code" the default db?!

But: if you are trying to fix some SIFT issues, maybe this could also help:
http://dynamicsuser.net/blogs/stryk/archive/2010/05/29/optimizing-sift-and-vsift.aspx

Regards,
Jörg

dsatria · **Posted:** Wed Dec 08, 2010 7:59 am

Hi Jörg,

Thanks for your reply

There is a line like you mentioned but with slightly different name, i.e. GetCurrentDB instead of GetCurrentDatabase

But the function code is totally different:

Code: Select all

SessionInfo.SETRANGE(SessionInfo."My Session",TRUE);
IF SessionInfo.FIND('-') THEN
  DBName := SessionInfo."Database Name";

IF (STRPOS(DBName,'.') <> 0) OR
   (STRPOS(DBName,'-') <> 0) THEN
  DBName := '[' + DBName + ']';

EXIT(DBName);

Using Debugger I can assure you that DBName variable contains correct database name.
Is there any other information I can supply you to make things clearer?

Regards,
David

PS. Thanks for the URL to the article regarding SIFT, I'm reading it now...

dsatria · **Posted:** Wed Dec 08, 2010 8:29 am

Hi all,

The problem turned out to be our database name which contains spaces :wink:

So changing the function code will solve it:

Code: Select all

...
IF (STRPOS(DBName,'.') <> 0) OR
   (STRPOS(DBName,'-') <> 0) OR
   (STRPOS(DBName,' ') <> 0) THEN
  DBName := '[' + DBName + ']';
...

Thanks and regards,
David

mibuso.com

Key Performance Tool error

Who is online