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 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.