Connect. Communicate. Collaborate. Securely.

Home » Kerio User Forums » Kerio Control » Error: Unable to process StatImage
  •  
Dukeman

Messages: 57
Karma: 6
Send a private message to this user
Since last night I'm seeing the following error messages in the Error log:

Quote:

[03/Mar/2014 19:10:18] (335544569) Unable to process StatImage, Firebird DB error message follows:
[03/Mar/2014 19:10:18] (335544569) Firebird DB: *** IBPP::SQLException ***
[03/Mar/2014 19:10:18] (335544569) Firebird DB: Context: Statement::Execute( EXECUTE PROCEDURE INSERT_WEB_ACCESS(?, ?, ?, ?, ?) )
[03/Mar/2014 19:10:18] (335544569) Firebird DB: Message: isc_dsql_execute2 failed
[03/Mar/2014 19:10:18] (335544569) Firebird DB:
[03/Mar/2014 19:10:18] (335544569) Firebird DB: SQL Message : -303
[03/Mar/2014 19:10:18] (335544569) Firebird DB: Incompatible column/host variable data type
[03/Mar/2014 19:10:18] (335544569) Firebird DB:
[03/Mar/2014 19:10:18] (335544569) Firebird DB: Engine Code : 335544569
[03/Mar/2014 19:10:18] (335544569) Firebird DB: Engine Message :
[03/Mar/2014 19:10:18] (335544569) Firebird DB: Dynamic SQL Error
[03/Mar/2014 19:10:18] (335544569) Firebird DB: SQL error code = -303
[03/Mar/2014 19:10:18] (335544569) Firebird DB: Malformed string
[03/Mar/2014 19:10:18] (335544569) Firebird DB:


This is since then happening every hour. Normally I receive a traffic report for the last day, but this was not send either.

Where does this error come from, and more important: how to resolve this? I'm running Kerio Control 8.2.2 patch 1 build 1684.

Thanks,
Barry
  •  
mlee (Kerio)

Messages: 246
Karma: 16
Send a private message to this user
Guess you have a corrupted database. Can you access the statistic at all?

If not, please stop Kerio Control and clear the following directory:
/var/winroute/star/cache/

M.

PTSD. BP. OCD. ASPD. BPD. Certified.
  •  
Dukeman

Messages: 57
Karma: 6
Send a private message to this user
Thank you for your reply. The statistics website gives an error as well (error in databaseconnection).

I'm running the firewall on a dedicated server (software appliciance), how can I stop kerio and still access the files?
I know how to enable SSH on kerio, but to access it, Kerio has to be started I guess?
  •  
Dukeman

Messages: 57
Karma: 6
Send a private message to this user
I just emptied the /star/cache folder while Kerio was running. The hourly processing of the star database ran with a couple of errors:

Quote:

[05/Mar/2014 21:11:49] SIC<dio>: unable to sync SIC to DB, some data could be lost: unknown UserId for 4eff6408-6ce6-174a-8a19-5ebad120c212
[05/Mar/2014 21:11:49] SIC<dio>: unable to sync SIC to DB, some data could be lost: unknown UserId for d6b0e792-0471-064d-be6c-66b008d0e769
[05/Mar/2014 21:11:49] SIC<dio>: unable to sync SIC to DB, some data could be lost: unknown UserId for 4265cfc2-842c-ce44-a44c-ee35d66f2d53
[05/Mar/2014 21:11:49] SIC<dio>: unable to sync SIC to DB, some data could be lost: unknown UserId for 86b1a9e7-fb4f-f348-b5a3-33b68552f942
[05/Mar/2014 21:11:49] SIC<proto>: unable to sync SIC to DB, some data could be lost: unknown UserId for 4eff6408-6ce6-174a-8a19-5ebad120c212
[05/Mar/2014 21:11:49] SIC<proto>: unable to sync SIC to DB, some data could be lost: unknown UserId for d6b0e792-0471-064d-be6c-66b008d0e769
[05/Mar/2014 21:11:49] SIC<proto>: unable to sync SIC to DB, some data could be lost: unknown UserId for 4265cfc2-842c-ce44-a44c-ee35d66f2d53
[05/Mar/2014 21:11:49] SIC<proto>: unable to sync SIC to DB, some data could be lost: unknown UserId for 86b1a9e7-fb4f-f348-b5a3-33b68552f942
[05/Mar/2014 21:11:49] SIC<iss>: unable to sync SIC to DB, some data could be lost: unknown UserId for 4eff6408-6ce6-174a-8a19-5ebad120c212
[05/Mar/2014 21:11:49] SIC<iss>: unable to sync SIC to DB, some data could be lost: unknown UserId for d6b0e792-0471-064d-be6c-66b008d0e769
[05/Mar/2014 21:11:49] SIC<iss>: unable to sync SIC to DB, some data could be lost: unknown UserId for 4265cfc2-842c-ce44-a44c-ee35d66f2d53
[05/Mar/2014 21:11:49] SIC<iss>: unable to sync SIC to DB, some data could be lost: unknown UserId for 86b1a9e7-fb4f-f348-b5a3-33b68552f942
[05/Mar/2014 21:11:50] SIC<web>: unable to sync SIC to DB, some data could be lost: unknown UserId for 4eff6408-6ce6-174a-8a19-5ebad120c212
[05/Mar/2014 21:11:50] SIC<web>: unable to sync SIC to DB, some data could be lost: unknown UserId for d6b0e792-0471-064d-be6c-66b008d0e769
[05/Mar/2014 21:11:50] SIC<activity>: unable to sync SIC to DB, some data could be lost: unknown UserId for 4eff6408-6ce6-174a-8a19-5ebad120c212
[05/Mar/2014 21:11:50] SIC<activity>: unable to sync SIC to DB, some data could be lost: unknown UserId for d6b0e792-0471-064d-be6c-66b008d0e769


The daily report mail was now send (which was not for the past few days) and the statistics website is working again.

Seems that deleting the cache did the trick. I'll see what will happen the upcoming days.

Thank you for your help Martin!
  •  
mlee (Kerio)

Messages: 246
Karma: 16
Send a private message to this user
Glad that it works, you are welcome Smile

M.

PTSD. BP. OCD. ASPD. BPD. Certified.
  •  
Dukeman

Messages: 57
Karma: 6
Send a private message to this user
The "unknown userid" error came back every hour, but has been solved as well. I copied the .xml file back to Control. From then the problem was completely solved!
Previous Topic: Kerio en Linux
Next Topic: Kerio VPN too slow transfer data
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 Aug 20 00:15:45 CEST 2017

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