Schema error, fourth re-install this month. Fix short of re-install please?

[Bilar Crais]

Well, this is getting kind of old. about once a week or so, I have to completely wipe BTV and re-install to fix scheduling failures. Below is an excerpt from my log:



Incoming connection from 192.168.1.100 ...
[6/26/2004 17:55:03] 7. Starting up the IP Monitor
[6/26/2004 17:55:03] 8. Starting Web Service Threads.
[6/26/2004 17:55:04] Valid SnapStream.Net subscription found.
[6/26/2004 17:55:21] Guide Updater Service: Download complete. Decompressing data...
[6/26/2004 17:55:21] Guide Updater Service: Processing new data...
[6/26/2004 17:55:24] Guide Updater Service: Processing data complete. Loading new data...
[6/26/2004 17:55:26] Guide Updater Service: MDAC version: 2.80
[6/26/2004 17:55:26] Guide Updater Service: Jet Database Engine version: 4.0.8618.0
[6/26/2004 17:55:26] CSSGuideUpdater::OpenConnection - Open failed: 0x80040E4E
[6/26/2004 17:55:26] CSSGuideUpdater::CheckSchemaVersion - OpenConnection failed.
[6/26/2004 17:55:26] SSGuideUpdater::Initialize - Schema version check failed. Please reinstall or contact SnapStream support at http://www.snapstream.com/Support/Support.asp
[6/26/2004 17:55:26] CSSGuideUpdater::CleanUpdate - Initialize failed. hr: 0x80040E4E
[6/26/2004 17:55:26] Guide Updater Service: Data load into database tables failed.
[6/26/2004 17:55:28] Guide Updater Service: Initializing...
[6/26/2004 17:55:28] Guide Updater Service: Downloading data from SnapStream.Net...
[6/26/2004 17:55:49] Guide Updater Service: Download complete. Decompressing data...
[6/26/2004 17:55:49] Guide Updater Service: Processing new data...
[6/26/2004 17:55:52] Guide Updater Service: Processing data complete. Loading new data...
[6/26/2004 17:55:52] Guide Updater Service: MDAC version: 2.80
[6/26/2004 17:55:52] Guide Updater Service: Jet Database Engine version: 4.0.8618.0
[6/26/2004 17:55:52] CSSGuideUpdater::OpenConnection - Open failed: 0x80040E4E
[6/26/2004 17:55:52] CSSGuideUpdater::CheckSchemaVersion - OpenConnection failed.
[6/26/2004 17:55:52] SSGuideUpdater::Initialize - Schema version check failed. Please reinstall or contact SnapStream support at http://www.snapstream.com/Support/Support.asp
[6/26/2004 17:55:52] CSSGuideUpdater::CleanUpdate - Initialize failed. hr: 0x80040E4E
[6/26/2004 17:55:52] Guide Updater Service: Data load into database tables failed.
[6/26/2004 17:55:52] Guide Updater Service: If you see repeated data update failures, please visit SnapStream support at: http://www.snapstream.com/Support/Support.asp
[6/26/2004 17:55:54] Guide Updater Service: Initializing...
[6/26/2004 17:55:54] Guide Updater Service: Downloading data from SnapStream.Net...
[6/26/2004 17:56:16] Guide Updater Service: Download complete. Decompressing data...
[6/26/2004 17:56:16] Guide Updater Service: Processing new data...
[6/26/2004 17:56:19] Guide Updater Service: Processing data complete. Loading new data...
[6/26/2004 17:56:19] Guide Updater Service: MDAC version: 2.80
[6/26/2004 17:56:19] Guide Updater Service: Jet Database Engine version: 4.0.8618.0
[6/26/2004 17:56:19] CSSGuideUpdater::OpenConnection - Open failed: 0x80040E4E
[6/26/2004 17:56:19] CSSGuideUpdater::CheckSchemaVersion - OpenConnection failed.
[6/26/2004 17:56:19] SSGuideUpdater::Initialize - Schema version check failed. Please reinstall or contact SnapStream support at http://www.snapstream.com/Support/Support.asp
[6/26/2004 17:56:19] CSSGuideUpdater::CleanUpdate - Initialize failed. hr: 0x80040E4E
[6/26/2004 17:56:19] Guide Updater Service: Data load into database tables failed.
[6/26/2004 17:56:19] Guide Updater Service: If you see repeated data update failures, please visit SnapStream support at: http://www.snapstream.com/Support/Support.asp


Just what the hell is going on here?

Thank you,

CF

[RobertH]

The only thing in these cases is to try the typical reinstall of mdac/jet/.net from this thread:
http://forums.snapstream.com/vb/show...threadid=11893
and then see if btv fixes itself

or to do a full remove and reinstall.

Basically something is corrupting the ado.net/ms jet libraries, it could be something that got installed or something expecting a different version and is overwriting the newer one that btv needs or something, but in the end its getting damaged or its a version that btv cant work with.

because of the instabilities in the ado/jet libraries this is one of the reasons its being dropped in 3.5

[Bilar Crais]

Thanks for the quick reply, Robert. I'll give it a try.

[bujin]

I tried the install of mdac/jet/.net; no luck - my log has the same error as above. Any other thoughts?