Query report error

edev · Post by **edev** » Thu Apr 20, 2006 4:26 pm

Hi,

I manually combined two profiles together into a big one (using SQL to update dataspace and profile name in "testdb"), but the new profile's query log wouldn't work. Is there another database setting I have to update in order for dowalk to recognize the query table as a new one? I get errors like "Can't open KDBF file..." and "Could not open index..."

Any help would be appreciated.

Post by **Kai** » Thu Apr 20, 2006 5:47 pm

Can you give the complete error messages (ie. including paths)? This may shed some light on the issue.

edev · Post by **edev** » Wed May 03, 2006 2:41 pm

Sorry about the delay, these are the error messages I got after clicking on "Top Query" link in "Query Report":

002 /webinator/dowalk(topquery) 9308: Can't open Metamorph index token file C:\Profile1\db2\T00908a.tok read/write: No such file or directory in the function openwtix

000 /webinator/dowalk(topquery) 9308: SQLPrepare() failed with -1 in the function prepntexis

002 /webinator/dowalk(topquery) 9315: Can't open KDBF file C:\Profile1\db2\T00908a.dat for reading: error 2: No such file or directory

100 /webinator/dowalk(topquery) 9315: Could not open index C:\Profile1\db2\T00908a in the function ixfmmindex

115 /webinator/dowalk(topquery) 9315: Query 'indexcount=' would require linear search

If you could point to me the right direction of fixing it that would be great, thanks!

Post by **mark** » Wed May 03, 2006 3:21 pm

Looks like the query log index is missing. It can be recreated with "remakeindex". See "using dowalk" in the manual. http://www.thunderstone.com/site/webina ... de179.html