An overflow error means that the code is trying to put a number into a variable (or property, or table column, etc) and the data type of the variable doesn't allow numbers that large. Check
the data types of any variables you're working with and make sure they're
capable of holding the value you're attempting to store or work with. For example, a Small
Integer can only hold values in the range of (-32768 to 32767) and a Byte can
only hold (0-255). If this doesn't happen to all processes on all machines
all the time then more than likely something has happened to the machine where the error is occuring or
the data being processed by MaxRecall on that machine is causing the problem. Check the data. For example, is the program handling a very large file? Maybe the file bytes is too large for the fields in the DB where that's stored or the value is too large to be handled by the variables declared in the code; Or maybe a keyword value is too large for the kwval field in the keyword values table for that keyword. Also, try rebooting the machine if
it doesn't seem to be a MaxRecall data issue. If this is happening on a new install or upgrade, or on a machine that has had some type of failure or malware infection then maybe try running the Programs Update with the Full Re-install option selected. If this is happening to zzlouie.exe when it's trying to file docs then run the following query to see if there are any docs that aren't yet filed that exceed the currently allowable size (bytes of all pages). If there are any then those DocIDs need to be removed from the Filer_UL table. Then document the doc info and let the customer know because they'll need to re-add the doc with smaller page files. This has been seen where a user scans a multipage doc in full color before adding to MaxRecall. |
SELECT * FROM DOCS WHERE DOCSTATUS > 2 AND BINDERID = 0 AND PAGESBYTES > 1000000000 If this is happening when trying to email with MaxRecall keyword value entities in the email layout check the data types of the keywords. It seems to have a problem with dates. You could also potentially have trouble with numeric keywords if the value is large. |