Access Frontend_Findings - x-ian/dha-mis-migration GitHub Wiki

Admin Frontend

concept_set and concept creation

Unsure at the same time a new concept_set with new concepts can be created. If yes, it might fail because of different ID generation.

DE Frontend

Database Documenter

Access Database Documenter generates 820 pages. During the process the following error messages pop up.

The MS Office Access database engine cannot find the input table or query 'art_clinic_drug_set_'. Make sure it exists and that its name is spelled correctly. Unable to document Query 'art_clinic_obs_drug_set'. Continue?

Analyse frontend

Invalid queries

to be removed?:

  • art_clinic_obs_outc_site_quart_new
  • art_clinic_old
  • art_regimens
  • check_cd4
  • concept_lev_rep_obs
  • htc_site_agg
  • map_regimen_supply_rule_frmdata
  • psm_distribution_list_accpac
  • psm_DL6_diff
  • psm_DL6_diff_error
  • psm_DL6_diff_error_sites
  • psm_DL6_receive
  • psm_relo_item_frmdata
  • psm_relo_transact_frmdata
  • psm_relo_transact_item_review
  • psm_rule_supply_item_frmdata
  • survival_set_data
  • tb_data_year_quarter

Performance Analyser

Run for long time (exact time unknown)

  • ~15 recommendations to add indexes to various fields to improve performance for different queries; impact unclear because usage of both reported tables and queries unknown.
    • Table NMCP_DL27_export: Add index to '1109' to optimze query art_supervision_mainreport_tmptbl_team
    • Table art_clinic_obs: Add index to fields year_qurater_id, car_regno, visit_date, start_... for query mileage
    • art_supervision_mainreport_tmptbl: Add index to team for query art_supervision_mainreport_tmptbl
    • concept: Add index to concept_id_parent, concept_name for query concept_period_label_all
    • concept_ Add index to concept_ID_parent, sort_weight for query concept_sub_group_all
    • concept: Add index to field Retired for query chksum_qry_right
    • map_regimen_supply_rule: Add index to field default_rule for query art_drug_stock_consum_year_quarter
    • map_regimen_supply_rule: Add index to active for query psm_regimen_consum_growth
    • psm_DL_item: Add index to units_received for query psm_DL_chk_missing
    • psm_DL_sheet: add index to receive_date for query psm_DL_chk_missing
    • psm_relocate: Add index to field hdepartment_id_send, hdepartment_id_receive... for query psm_relocate_relo
    • psm_rule_dim_de_list_tbl: Add index to field data_element for query concept_period_label_filter
    • supply_item: Add index to field display_label for query psm_DL_export
  • Many suggestions about additional relations between tables; impact unclear

Database Documenter

Access Database Documenter generates roughly 3700 pages. During the process the following error messages pop up.

The microsoft office access database engine cannot find the input table or query 'chk_outc_site_quart'. make sure it exists and that its name is spelled correctly. Unable to document Query 'art_clinic_obs_outc_site_quart_new'. Continue?

the microsoft office access database engine cannot find the input table or query 'code_zone'. make sure it exists and that its name is spelled correctly. Unable to document Query 'art_clinic_old'. Continue?

the microsoft office access database engine cannot find the input table or query 'map_regimen_stock'. make sure it exists and that its name is spelled correctly. Unable to document Query 'art_regimens'. Continue?

The action query 'report_levels_app' cannot be used as a row source. Unable to document Query 'concept_lev_rep_obs'. Continue?

the microsoft office access database engine cannot find the input table or query 'psm_rule_dim_de_list'. make sure it exists and that its name is spelled correctly. Unable to document Query 'map_regimen_supply_rule_firmdata'. Continue?

the microsoft office access database engine cannot find the input table or query 'supply_item_accpac'. make sure it exists and that its name is spelled correctly. Unable to document Query 'psm_distribution_list_accpac'. Continue?

the microsoft office access database engine cannot find the input table or query 'psm_distribution_list_LD6_recs'. make sure it exists and that its name is spelled correctly. Unable to document Query 'psm_DL6_diff'. Continue?

the microsoft office access database engine cannot find the input table or query 'psm_distribution_list_LD6_recs'. make sure it exists and that its name is spelled correctly. Unable to document Query 'psm_DL6_diff_error'. Continue?

the microsoft office access database engine cannot find the input table or query 'psm_distribution_list_LD6_recs'. make sure it exists and that its name is spelled correctly. Unable to document Query 'psm_DL6_diff_error_sites'. Continue?

the microsoft office access database engine cannot find the input table or query 'temp_DL6_qty'. make sure it exists and that its name is spelled correctly. Unable to document Query 'psm_DL6_receive'. Continue?

The SQL statement could not be executed because it contains ambiguous outer joins. To enforce one of the joins to be performed first, create a separate query that performs the first join and then include that query in your SQL statement. Unable to document Query 'psm_regim_consum_growth' Continue?

The MS Office Access database engine cannot find the input table or query 'psm_relo_transact'. Make sure it exists and that its name is spelled correctly. Unable to document Query 'psm_relo_item_app'. Continue?

The MS Office Access database engine cannot find the input table or query 'psm_relo_transact'. Make sure it exists and that its name is spelled correctly. Unable to document Query 'psm_relo_item_frmdata'. Continue?

The MS Office Access database engine cannot find the input table or query 'psm_relo_transact'. Make sure it exists and that its name is spelled correctly. Unable to document Query 'psm_relo_transact_frmdata'. Continue?

The MS Office Access database engine cannot find the input table or query 'psm_relo_transact'. Make sure it exists and that its name is spelled correctly. Unable to document Query 'psm_relo_transact_item_review'. Continue?

The MS Office Access database engine cannot find the input table or query 'psm_rule_supply_item_'. Make sure it exists and that its name is spelled correctly. Unable to document Query 'psm_rule_supply_item_frmdata'. Continue?

The MS Office Access database engine cannot find the input table or query 'survival_set_agegroup'. Make sure it exists and that its name is spelled correctly. Unable to document Query 'survival_set_data'. Continue?

The MS Office Access database engine cannot find the input table or query 'temp_tb_'. Make sure it exists and that its name is spelled correctly. Unable to document Query 'tb_data_year_quarter'. Continue?

⚠️ **GitHub.com Fallback** ⚠️