<< Click to Display Table of Contents >> Navigation: SPM > SPM > Troubleshooting > Tables Missing or Do Not Comply with Schema |
Affected Software/Reports/DLL(s): SPM
Affected Software Version: N/A
Symptoms: The following errors may occur when opening SPM.
Used database is not compatible with current version of SPM. Following tables are missing or do not comply with latest DB schema:
* dt_spm_planned_activity (Invalid column name 'group_code'. Invalid column name 'unit'.) * dt_spm_planned_container (Invalid column name 'remark_1'.) * dt_spm_planned_sample (Invalid column name 'group_code'. Invalid column name 'parent_sample_id'. Invalid column name 'creation_id'.) * dt_spm_scheduled_container (Invalid column name 'remark_1'.) * dt_spm_scheduled_result (Invalid column name 'spm_contract_method_id'. Invalid column name 'report_order'.) * dt_spm_contract (Invalid column name 'cost_unit'.) * dt_spm_contract_container (Invalid column name 'preservative'. Invalid column name 'virtual_YN'. Invalid column name 'rt_spm_container_id'. Invalid column name 'remark_1'.) * dt_spm_contract_method (Invalid column name 'cost'.) * dt_spm_scheduled_task (Invalid column name 'priority_ranking'. Invalid column name 'cancelled_YN'. Invalid column name 'person_name'. Invalid column name 'company_code'.) * at_spm_sample_chain_of_custody (Invalid column name 'sample_id'.) * dt_spm_contract_mag (Invalid column name 'select_members_YN'. Invalid column name 'cost'. Invalid column name 'cost_calc_code'. Invalid column name 'cost_type'.) * dt_spm_plan (Invalid column name 'cost_unit'.) * dt_spm_planned_task (Invalid column name 'status_flag'. Invalid column name 'usePlannedValues_YN'. Invalid column name 'planned_task_name'. Invalid column name 'planned_task_state'. Invalid column name 'skip_months'. Invalid column name 'priority_ranking'. Invalid column name 'person_name'. Invalid column name 'company_code'. Invalid column name 'custom_field_1'. Invalid column name 'custom_field_2'. Invalid column name 'custom_field_3'. Invalid column name 'custom_field_4'. Invalid column name 'custom_field_5'. Invalid column name 'spm_commitment_id'.) * dt_spm_scheduled_activity (Invalid column name 'unit'.) * dt_spm_scheduled_sample (Invalid column name 'parent_sample_id'. Invalid column name 'creation_id'. Invalid column name 'sample_id_planned'.) * dt_spm_contract_mag_members (Invalid column name 'spm_contract_method_id'. Invalid column name 'report_order'. Invalid column name 'default_detect_limit'. Invalid column name 'default_units'. Invalid column name 'default_qualifier'. Invalid column name 'reporting_detect_limit'. Invalid column name 'reporting_units'. Invalid column name 'ebatch'. Invalid column name 'chemical_name'. Invalid column name 'remark'.) * at_spm_contract_mth_container (Invalid object name 'at_spm_contract_mth_container'.) * dt_spm_scheduled_cost_mag (Invalid object name 'dt_spm_scheduled_cost_mag'.) * dt_spm_contract_cost (Invalid object name 'dt_spm_contract_cost'.) * rt_spm_container (Invalid object name 'rt_spm_container'.) * dt_spm_planned_access (Invalid object name 'dt_spm_planned_access'.) * dt_spm_access_required (Invalid object name 'dt_spm_access_required'.) * dt_spm_access (Invalid object name 'dt_spm_access'.) * dt_spm_access_status (Invalid object name 'dt_spm_access_status'.) * dt_srn (Invalid object name 'dt_srn'.) * dt_srn_amendment (Invalid object name 'dt_srn_amendment'.) * dt_srn_issue (Invalid object name 'dt_srn_issue'.) * dt_srn_issue_sample (Invalid object name 'dt_srn_issue_sample'.) * dt_srn_issue_container (Invalid object name 'dt_srn_issue_container'.) * dt_srn_issue_test (Invalid object name 'dt_srn_issue_test'.) * dt_spm_resample (Invalid object name 'dt_spm_resample'.) * at_spm_commitment_report (Invalid object name 'at_spm_commitment_report'.) * at_spm_commitment_planned_task (Invalid object name 'at_spm_commitment_planned_task'.) * dt_spm_commitment (Invalid object name 'dt_spm_commitment'.) * rt_spm_cost_calc (Invalid object name 'rt_spm_cost_calc'.) * rt_spm_cost_calc_mag (Invalid object name 'rt_spm_cost_calc_mag'.) * dt_spm_scheduled_sample_cost (Invalid object name 'dt_spm_scheduled_sample_cost'.) * dt_sdg (Invalid column name 'sdg_id'. Invalid column name 'sdg_id'. Invalid column name 'sdg_id'. Invalid column name 'lab_code'. Invalid column name 'lab_contact'. Invalid column name 'data_review_date'. Invalid column name 'data_review_company'.) * at_sample_sdg (Invalid object name 'at_sample_sdg'.) * dt_chain_of_custody (Invalid column name 'turn_around_time'. Invalid column name 'lab_code'. Invalid column name 'cooler_desc'. Invalid column name 'quote_number'. Invalid column name 'shipping_date'. Invalid column name 'email_invoice_to'. Invalid column name 'email_report_to'. Invalid column name 'relinquished_by'. Invalid column name 'relinquished_date'. Invalid column name 'lab_receipt_date'. Invalid column name 'lab_cooler_count'. Invalid column name 'lab_cooler_desc'. Invalid column name 'lab_security_seal'. Invalid column name 'lab_cooler_temp'. Invalid column name 'remark'. Invalid column name 'chain_of_custody_id'. Invalid column name 'sampler_1'. Invalid column name 'sampler_2'. Invalid column name 'sampler_3'. Invalid column name 'project_manager'. Invalid column name 'project_id'. Invalid column name 'po_number'. Invalid column name 'department'.) * dt_chain_of_custody_mag (Invalid object name 'dt_chain_of_custody_mag'.) * rt_mth_anl_group (Invalid column name 'spm_cost'.)
Following tables do not have required SPM reference data:
* rt_lookup (lookup_type: authority_lookup) * rt_lookup (lookup_type: authority_type_lookup) * rt_lookup (lookup_type: monitor_program_lookup) * rt_lookup (lookup_type: monitor_type_lookup) * rt_lookup (lookup_type: spm_commitment_purpose) * rt_lookup (lookup_type: spm_commitment_report) * rt_lookup (lookup_type: spm_la_status) * rt_lookup (lookup_type: resample_reason) * rt_lookup (lookup_type: spm_resample) * rt_lookup (lookup_type: srn_amendment) * rt_lookup (lookup_type: srn_issue) * rt_lookup (lookup_type: srn_issue_sample) * rt_lookup (lookup_type: spm_ranking_priority) |
Cause/Details: The error message may indicate that the SPM database Schema has not been applied to the database.
Resolution/Workaround: To remedy this error, copy the SPM Schema (schema.SPM.xme), which is bundled with the SPM installer, to the database schema folder per instructions in Update Database Schema.
Copyright © 2024 EarthSoft, Inc. • Modified: 02 Apr 2020