Indications:

• Data is no longer being placed into the database.
• The Chaperon logger is behind and the amount of time behind is increasing.

Versions Affected:

• Chaperon installations on a server with a date format other than month/day/year that log to an MSDE/SQL.

Cause:

• Chaperon will attempt to insert data with the month and day fields switched.  This will cause Chaperon to report the error above when a number greater than 12 is attempted to be added to the month section.

Solution:

Correcting this issue involves making registry changes.  Making incorrect changes can adversly affect your system.  Making registry changes is not recommended if you are not familiar with doing so.  If you do not feel comfortable making these changes, join our online tech support at http://webex.cornerpost.net and a technician will be happy to assist.

• Stop the Chaperon service by clicking Start > Run and typing cmd.  When the command prompt appears, type net stop chaperon2000.
• Close all Chaperon administration MMC's including those that may be opened in terminal server.
• Click Start > Run and type regedt32 to open the registry editor.
• Expand HKLM > System > Current Control Set > Services > Chaperon2000 > Parameters.
• In the Parameters section, add a new value named SQLDateFormat with a string of mm/dd/yyyy hh:nn:ss
• Restart Chaperon.

Note:  Using nn for the minutes section is correct and not a typo because mm has already been used for the months section.