DataTools HowTo: Solve an "Overflow (6)" Error

in

Wed, 03 Mar 2010, 3:59pm

Question:

For the past 2 days I get an "Overflow (6)" error message when I launch my DataTools product for the first time each morning. What is causing the error, and how can it be fixed?

Answer:

The Cause

The error is usually the result of “corrupted” window dimension/location values in the “settings” file for the product. This is sometimes caused when the application is closed (intentionally or not) with one or more of the application's windows in a position that is outside the visual boundaries of your computer screen.

The Solution

The solution to the problem depends on which of the DataTools products is affected. Each product within a "category" (i.e., Extractors, Loaders, Parsers, etc.) creates/edits and uses a unique "settings" file each time the product is launched and closed. The "settings" files reside in the following path, depending on the operating system of your workstation on which DataTools is installed, as follows:

On Windows XP:

C:\Documents and Settings\[YOUR_USERNAME]\Application Data\Pervasive\DataTools9\Common\Settings

The following list includes some of the DataTools product category names and the associated "settings" file name:

  • Data Joiner - DataJoiner.xml
  • Data Loaders - DataLoader_Settings.xml
  • Data Extractors - DataExtractor_Settings.xml
  • Data Parsers - DataParseSettings.xml
  • Data Parser for Unstructured Text - ExtractorSchema.xml
  • Data Viewer - Browse.xml

IMPORTANT NOTE: For the Data Parser for Unstructured Text back up the extractor900.mdb file prior to deleting the settings file. Otherwise, you will lose any/all saved extraction scripts. The extractor900.mdb file resides in this folder path (Windows XP): C:\Documents and Settings\jterrell\Application Data\Pervasive\DataTools9\Common