Key Performance Tool error

Answers

• stryk Member Posts: 645

  2010-12-06

  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:

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

  And the function should look like this:

  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

  Jörg A. Stryk (MVP - Dynamics NAV)
  NAV/SQL Performance Optimization & Troubleshooting
  STRYK System Improvement
  The Blog - The Book - The Tool

  0
• dsatria Member Posts: 80

  2010-12-08

  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:

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

  0
• dsatria Member Posts: 80

  2010-12-08

  Hi all,
  
  The problem turned out to be our database name which contains spaces
  So changing the function code will solve it:

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

  Thanks and regards,
  David

  0