Question

Audit Trails Reporting shows ERROR [22008] ... Datetime field overflow

Audit Trail Laserfiche

Updated January 15, 2016

asked on January 7, 2016

A client gets the next message: "ERROR [22008][Microsoft][SQL Server Native Client 10.0]Datetime field overflow. Fractional second precision exceeds the scale specified in the parameter binding"

For what I could understand, this message shows up when attempting to pass a datetime outside the range allowed by Microsoft datetime field.

So, the real question is ... Is there any way to configure the datetime format in Audit Trail?

0 0

Answer

APPROVED ANSWER SELECTED ANSWER

replied on January 15, 2016

The issue is specific to using Google Chrome and trying to set an event time filter in the audit report. The recommended solution is to upgrade to Audit Trail 10.

1 0

Replies

replied on January 7, 2016 • Show version history

Hi Billy, what version of Laserfiche are they running? This was an issue resolved in Laserfiche 9.2.0 SP 1, by applying KB 1013588.

If that does not resolve the issue, please open a support case for further troubleshooting and we can look into the matter.

Hope this helps!

[EDIT: I jumped too far ahead; you don't need to go all the way to 9.2.1 SP 1. Thanks Alex!]

0 0

replied on January 8, 2016

I applied the KB 1013588 as the solution, but i get the same message error after the update installation.

I`ve restarted the Audit Trail and Laserfiche Server`s services after the patch was completely installed.

Any help will be much appreciated. Thanks.

0 0

replied on January 8, 2016

I recommend opening a case with Support for further troubleshooting, where you can provide the full details of the error and information can be exchanged more efficiently.

0 0

APPROVED ANSWER SELECTED ANSWER

replied on January 15, 2016

The issue is specific to using Google Chrome and trying to set an event time filter in the audit report. The recommended solution is to upgrade to Audit Trail 10.

1 0

You are not allowed to follow up in this post.

Question

Question

Audit Trails Reporting shows ERROR [22008] ... Datetime field overflow

Answer

Replies

Sign in to reply to this post.