SQLite errors

(imported topic written by mynameisbear91)

Sorry about all the recent “I’m using Vista, and…” threads, I got a brand spankin’ new workstation a few days ago with a few gigs of ram and 4 processors, and decided to go ahead and give Vista (32 bit version) a workout with my standard admin tools. Needless to say, some things don’t work, but they’re really fast about not working. :wink:

I don’t know if this is Vista specific, because I never ran the console on anything but the server itself before now. I get the following error on occasion when I have the console open on my Vista machine.

“SQLite error 0-11”

(imported comment written by SystemAdmin)

Mr Golightly,

This error code is for a corrupt database:

#define SQLITE_CORRUPT 11 /* The database disk image is malformed */

I would suggest trying to clear the BES Console cache: http://support.bigfix.com/cgi-bin/kbdirect.pl?id=233

Or just manually delete these files:

  • Documents and Settings<current user>\Local Settings\Application Data\BigFix\Enterprise Console<DSN><BigFix UserName>\SessionCache.dat

  • Documents and Settings<current user>\Local Settings\Application Data\BigFix\Enterprise Console<DSN><BigFix UserName>\PropertyResults

(imported comment written by mynameisbear91)

Tyler Duni

Or just manually delete these files:

  • Documents and Settings<current user>\Local Settings\Application Data\BigFix\Enterprise Console<DSN><BigFix UserName>\SessionCache.dat
  • Documents and Settings<current user>\Local Settings\Application Data\BigFix\Enterprise Console<DSN><BigFix UserName>\PropertyResults

Where would these files be on a Vista machine? I’m having issues with the console exploding before it even gets to that point, and I want to clear the cache but I’m not yet familiar enough with Vista to know where all the settings are stored (or why doing a search for SessionCache.dat, even searching from the root of C:, turns up nothin’…)

Conrad

(imported comment written by mynameisbear91)

cgolightly

Where would these files be on a Vista machine? I’m having issues with the console exploding before it even gets to that point, and I want to clear the cache but I’m not yet familiar enough with Vista to know where all the settings are stored (or why doing a search for SessionCache.dat, even searching from the root of C:, turns up nothin’…)

Conrad

and then I dropped to a command prompt and did an old school search (cd c:\users, dir /s sessioncache.dat …) and answered my own question.

On Vista:

C:\Users\username\appdata\local\bigfix\Enterprise Console\BES_EnterpriseServer\username

Conrad