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 ====== SMS Database Errors ====== SMS utilizes a Paradox database for most of its information, though some of the more recently added information is stored in a Microsoft Access Database. Neither of these databases are server-based databases, meaning each client must open the files and process any necessary information. Because of this, they have many "hands in the pot" when being accessed by multiple clients and are inherently less stable than server-based databases (like Microsoft SQL Server). Network reliability is extremely important to the stability of the database. Most database problems are the result of some network unreliability, though finding the source of the problem is the IT equivalent to a needle in a moving haystack. ===== Common SMS Database Problems ===== * [[sms_error_-_index_out_of_date]] * [[sms_error_-_index_out_of_bounds]] * [[sms_error_-_invalid_operation]] * [[id_repair]] * [[index_does_not_exist]] * [[sms_error_-_corrupt_table_other_than_header]] * [[http://sms.cyriouswiki.com/corruption_in_index_or_header|Corrupt table/index header]] * [[sms_error_-_unable_to_connect_to_system_database]] * [[sms_error_-_record_locked_by_another_user]] * [[sms_error_-_.net_file_error|SMS Error - .NET File Error]] * [[sms_error_-_blob_error]] * [[sms_error_-_key_violation]] * [[sms_error_-_missing_line_items]] * [[sms_error_-_missing_order]] * [[sms_error_-_table_or_field_missing]] * [[sms_error_-_cannot_perform_action_on_closed_dataset]] * [[sms_error_-_unknown_internal_os_error_bad_file_number]] * [[sms_error_-_invalid_pointer_error]] * [[error_tbcloseouttemp_no_index_currently_active|Error tbCloseoutTemp No Index Currently Active]] * [[sms_error_-_stream_read_error]] * [[Declaration has not been closed, line 1