Page 1 of 1
Query report error
Posted: Thu Apr 20, 2006 4:26 pm
by edev
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.
Query report error
Posted: Thu Apr 20, 2006 5:47 pm
by Kai
Can you give the complete error messages (ie. including paths)? This may shed some light on the issue.
Query report error
Posted: Wed May 03, 2006 2:41 pm
by edev
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!
Query report error
Posted: Wed May 03, 2006 3:21 pm
by mark
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