My stat server cannot write to database

[Samuki]

Dear genesys pros, I have a question for you. My stat server does not seem to be able to write to the status table. I checked that my data access properties are correct. I also checked that tables exist and user has the right priveleges to access the database. In fact, it looks like dbserver has only troubles inserting into the STATUS table, because judging from the log, select statements from Login and QINFO execute flawlessly. What do you think it could be?

[Vic]

Samuki,

I bet that this is because you have LocalTime option set to true in StatServer but when you created STATUS table you used the wrong script.

To check if this is true, in CME check for LocalTime option under statserver and if this is set to true then open STATUS table and count the number of fields. If you have 8 fields then you know that you have ran a wrong script.

There are two ways to fix this problem.
The first way is simply turning off LocalTime option. What this option does is that it writes the start time and end time for a particular status.

But, if you think that you need to know these times, then simply you will need to recreate the status table run the sql script under statserver/sql directory that has _lttime at the end of it.

That should fix your problem. Needless to say any data that you had in that table would be gone!

Vic