FF Integrity Wizard Error 6 - 'Overflow Error.'

Article ID: 845791
Expand all | Collapse all

TechKnowledge Content

POTENTIAL CAUSES:

1. The database is corrupt. See resolution 18869.

2. The Communication Buffer Size needs to be reset in the Pervasive Engine using the BTI Database Setup Utility. See resolution 20744.

3. FastForward installation is corrupt. See resolution 22133.

4. Date field values contain errors in the Source database. See resolution 22869.

Resolution 18869 - Run Database Physical Integrity (95.500) within Solomon to repair integrity problems with the database

CORRECTION STEPS:

1. Make a BACKUP of the database, which can be restored in case an undesired data loss occurs.

2. Open Database Physical Integrity from the Utility menu in Solomon IV Version 4.21.

3. Select the Repair checkbox next to all the Records within the grid.

4. Click Start.

Resolution 20744 - Explain to reset the Communication Buffer Size in the Pervasive Engine using the BTI Database Setup Utility.

CORRECTION STEPS:

1. Select the BTI Database Setup Utility icon from the Solomon IV Group.

2. Under the Component option, select Scalable SQL Engine.

3. Under the Category option, select System Configuration.

4. Under the Settings option, select Communication Buffer Size.

5. Increase the number in the text box next to Communication Buffer Size.

6. Under the Category option, select Microkernel Database Engine.

7. Under the Settings option, select Remote Read.

8. Increase the number in the text box next to Communication Buffer Size.

9. Under the Component option, select MKDE (Server Edition).

10. Under the Category option, select Memory Resources.

11. Under the Settings option, select Communication Buffer Size.

12. Increase the number in the text box next to Communication Buffer Size.

Resolution 22133 - Uninstall then reinstall the FastForward tools following the directions in the FastForward Travel Guide located on the FastForward installation CD.

Resolution 22869 - Confirm the Date field values in the Source database table using Query Analyzer.

CORRECTION STEPS: 1. Make a BACKUP of the database, which can be restored in case an undesired data loss occurs.

2. Using Query Analyzer, access the appropriate Application Source database and execute the following statement to view the Date field values:

SELECT * from XXXXXXXX

(where XXXXXXXX = the table name)

3. Review the Date field values.

4. Execute the following statement to update the Date field value to confirm it is a valid value:

UPDATE XXXXXXXX SET YYYYYYYY = YYYYYYYY + 0

(where XXXXXXXX = the table name and YYYYYYYY = the Date field name)

EXAMPLE:

1. The example will be based on the PJCONTRL table and the LUpdDateTime Date field.

SELECT * from PJCONTRL UPDATE PJCONTRL SET LUpdDateTime = LUpdDateTime + 0

This article was TechKnowledge Document ID: 126151

Properties

Article ID: 845791 - Last Review: July 10, 2011 - Revision: 2.0
Keywords: 
KBRetire kbmbsmigrate KB845791
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com