Tables Missing or Do Not Comply with Schema

<< 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 Schema has not been applied to the database. If the SPM Schema has been applied to the database (and fewer tables are listed in the error message), the error indicates the build of the SPM Schema applied does not match the build of SPM Desktop opened.

 

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. If the SPM Schema was previously applied to the database, update the build of the SPM Schema to match the build of SPM Desktop used. It is recommended to only use matching builds of SPM Schema and SPM Desktop.