Show pageOld revisionsBacklinksBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. CKG Edit ===== Error Message ===== "Table is Full" ... ===== Explanation of Error ===== The BDE limits the size of the data transferred onto the HD in the BDEAdmin. As databases grows and as HD size have exceeded 4 GB, there is an increase need for larger block size transfers ===== Resolution 1 ===== ---- - Run the [[dbrebuild]] ===== Resolution 2 ===== ---- - Navigate to the BDEAdmin.exe (located in the "Program Files\Cyrious\Common\BDE\" folder) - Go to Configuration - Drill down to Native - Drill down to Paradox - Increase the block size to 16384, 8192, or 4096. Only increase the block size in multiples of 4096. - Set the level to 7 - [[dbrebuild]] the database ===== Resolution 3 (this requires assistance from Cyrious Tech Support) ===== ---- - After you have tried the first two configurations, you should proceed with these steps. It is important to note that before proceeding with recreating the tables that you confirm the BDE block size has been increased. When the tables are created via the queries below the new tables will only have an increased block size if the bde block size has been set properly. - The queries below are for SMS 8.91 tables but you can modify them for prior versions of SMS by deleting the additional fields that are not needed in earlier versions. - Rename the existing tables to a new name. - Run the queries below to create new tables. - {{ :sql_to_create_adjustment_database_for_sms_8.91.txt|}} - {{ :sql_-_create_estimate_database_for_sms_8.91.sql|}} - {{ :sql_-_create_estimate_details_database_for_sms_8.91.sql|}} - {{ :sql_-_create_order_database_for_sms_8.91.sql|}} - {{ :sql_-_create_order_details_database_for_sms_8.91.sql|}} - {{ :sql_to_create_gl_database_table_for_sms_8.91.txt|}} - {{ :sql_to_create_payment_database_for_sms_8.91.txt|}} - Run the queries below to import the original data into the new blank tables. <code sql> //For Example Insert Into "Adjustment Database" Select * From "Old_Adjustment" ; Insert Into "Estimate Database" Select * from "Old_Estimate" ; Insert Into "Estimate Details Database" Select * from "Old_EstimateDetails" ; Insert Into "Order Database" Select * from "Old_Order" ; Insert Into "Order Details Database" Select * from "Old_OrderDetails" ; Insert Into "GL Database" Select * from "Old_GL" ; Insert Into "Payments Database" Select * From "Old_Payments" ; </code>