Connect. Communicate. Collaborate. Securely.

Home » Kerio User Forums » Kerio Connect » KOFF SQL & Outlook Errors
  •  
jdowning

Messages: 5
Karma: 0
Send a private message to this user
Hello everyone,

I've had several users just today report several Outlook related problems. I have narrowed matters down to the offline cache and the SQL instance that manages it. Users are seeing errors like this:

[01/04/2008 09:10:52.686](4264){err}{scp-worker} In .\Worker_msgstore.cpp:80 (Worker::processSyncMsgStore)
Exception of class HResultException: .\Worker_msgstore.cpp(355), WorkerMsgstore::isSomethingChanged:
0x80004004 E_ABORT: Personal folder - getChangedPropList failed

[01/04/2008 09:10:52.686](3272){err}{synchronizer} In .\Synchronizator.cpp:586 (Synchronizator::syncSieve)
Error while calling syncSieve method!
HRESULT: 0x80042006 KOFF_E_SYNCQUEUE

[01/04/2008 09:10:52.717](3272){err}{database} In .\StoreProps.cpp:350 (StoreProps::internalStoreProp)
*** IBPP::SQLException ***
Context: Statement::Execute( execute procedure create_string_property(?,?,?,?,?) )
Message: isc_dsql_execute2 failed
SQL Message : -902
Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements
Engine Code : 335544335
Engine Message :
database file appears corrupt ()
wrong page type
page 40901 is of wrong type (expected 5, found Cool
At procedure 'CREATE_STRING_PROPERTY'
HRESULT: 0x80041001 KOFF_E_DB_SQL_ERROR

[01/04/2008 09:10:52.717](3272){err}{mapi-interface} In .\MAPIFolderImpl.cpp:627 (MAPIFolderImpl::CreateFolder)
Exception of class HResultException: .\MAPIFolderImpl.cpp(1739), MAPIFolderImpl::setAclToSubfolder:
0x80041001 KOFF_E_DB_SQL_ERROR

[01/04/2008 09:10:52.717](3272){err}{mapi-interface} In .\MSProviderImpl.cpp:282 (MSProviderImpl::Logon)
Exception of class HResultException: .\MsgStoreImpl.cpp(1697), MsgStoreImpl::initializeOutgoingQueue:
0x80040119 MAPI_E_EXTENDED_ERROR

[01/04/2008 09:10:52.795](4264){err}{database} In .\BasePropsObject.cpp:352 (BasePropsObject::getStoredPropVector)
*** IBPP::LogicException ***
Context: Statement::Set[int64_t]
Message: No statement has been prepared.
HRESULT: 0x80041000 KOFF_E_DATABASE

[01/04/2008 09:10:52.795](4264){err}{database} In .\BasePropsObject.cpp:1465 (BasePropsObject::getChangedPropList)
Exception of class HResultException: .\BasePropsObject.cpp(1437), BasePropsObject::getChangedPropList:
0x80041000 KOFF_E_DATABASE
HRESULT: 0x80041000 KOFF_E_DATABASE

For one user (running Vista Biz), I was able to restore the previous version via Vista's built-in methods. My other user has XP and that feature is unavailable to him. At this time, he can view some mail folders, but not others (like INBOX, Calendar, Contacts). Outlook shows the proper item count in the bottom left corner, but then displays "No Items to Show in this View."

Any help is appreciated!

--Justin
  •  
jruss

Messages: 37
Karma: 0
Send a private message to this user
We are experiencing a similar issue with one of our users.

debug.log shows:


Message: isc_dsql_prepare failed
SQL Message : -901
Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements
Engine Code : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -901
Implementation limit exceeded
Too many values (more than 1500) in member list to match against
HRESULT: 0x80041001 KOFF_E_DB_SQL_ERROR


Has anyone else seen this or had a fix?
Previous Topic: Kaspersky causes Sync problems with koff 6.5.1
Next Topic: Comodo and InstantSSL certificates
Goto Forum:
  


Disclaimer:
Kerio discussion forums are intended for open communication between forum members and may contain information and material posted by members which may be useful in learning about Kerio products. The discussion forums are not intended to provide technical support for any specific product. Any information implied or expressed in the discussion forums is that of the posting member. Kerio is in no way responsible for the information posted in the forums, or its accuracy. Kerio employees may participate in the discussions, but their postings do not represent an offical position of the company on any issues raised or discussed. Kerio reserves the right to monitor and maintain the forums to promote free and accurate exchange of information.

Current Time: Sun Sep 24 05:21:02 CEST 2017

Total time taken to generate the page: 0.00471 seconds
.:: Contact :: Home ::.
Powered by: FUDforum 3.0.4.