---
title: "MDS v5.0.0 Hotfix"
canonical: "https://servicedesk.maxgeo.com/space/MDS/1798504449/MDS%20v5.0.0%20Hotfix"
format: markdown
---
> Macro (toc)



# 01_500_usp_DataStructOrientDriver

#6381: Enhanced usp_DataStructOrientDriver to reflect tblDHStructureOrient PK include Priority

#  02_500_tblDHGeotechRMR

New FK FK_tblDHGeotechRMR_tblLIBGeotFabric_Fabric_Type (4.6.6 change missed to be deployed)

#   03_500_UserPlusEdit_role_swap

Swap old User Plus/Edit role if needed

#   04_500_tblSYSConfigRelation

#14292: Add config relation record for tblXRFResults

#  05_500_TriggerNestLevel

#14293: Update validated trigger to better handle nested triggers

#  06_500_tblLIBHoleDiameter

#14299: Add standard Hole diameter data into tblLIBHoleDiameter

#  07_500_tblSYSDSConfig

#14302: Update tblSYSDSConfig for tblContractActivityLogCrews

#  08_500_tblLIBOrientationQuality

#14304: Default data for tblLIBOrientationQuality

#  09_500_tblContractHeader

#14488: Grant update permission to DS_UserPlus on tblContractHeader.

#  10_500_DMP_Config_Data

#7431 Add DMP config data

#  11_500_usp_RptQAQC_PBI_Repeats

#15171: New SP usp_RptQAQC_PBI_Repeats

#  12_500_tblSYSAssDispatchTemplates

#15171: Grant permission to tblSYSAssDispatchTemplates

#  13_500_utf_MXAuditExceptionAppList

Update utf_MXAuditExceptionAppList with more apps

#  17_500_tblSYSConfigRelation

#6991: Default config in tblSYSConfigRelation for tblAssayHyperspectral

#  18_500_usp_AdminRunQuery

#15225: New internal used SP usp_AdminRunQuery for QGIS plugin

#  19_500_tblDHGeotechRMR

#15244: Update tblDHGeotechRMR.Total_Core_Recovery_pct computation formula

#  20_500_usp_DataAssayMergingProcess

#15667: Added @OverwriteDataSet to handle same sampleID associate with multiple active datasets. When @OverwriteDataSet specified, it will be used as the DataSet for all samples to be processed.

#  21_500_tblSYSAssQCResultDetail

#15692: Change tblSYSAssQCResultDetail.Repeat_SampleID length from 30 to 50

#  23_500_tblLIBSampleType

#16966: Remove trigger TR_udtblLIBSampleType_Code

#  24_500_tblPTSite

#16967: Fixed bug with referencing Hole_ID instead of Site_ID

#  25_500_tblSYSDSConfig

DevOps#16971: Change tblSYSDSConfig.UserName,DisplayName column length from 50 to 100

#  26_500_GridTransformationUpdates

Grid transformation performance enhancement

#  27_500_tblVWDHCollarAttributes

#17372: Added Preferred grid columns

#  28_500_tblVWDHCollSurv

#17372: Added Preferred grid columns

#  29_500_tblSYSSRSCoordinateSystem

#17375: Update tblSYSSRSCoordinateSystem.AuthorityCode

#  30_500_tblSYSQCGroup

#17394: Fixed syntax error in TR_utblSYSQCGroup

#  31_500_Views add preferred grid

# 17372: Update views to have Preferred_Grid_ID/East/North/RL for following views:

tblVWDHMaxAssays

tblVWFSMaxAssays

tblVWFSSamp

tblVWLSMaxAssays

tblVWLSSamp

tblVWPTAssays

tblVWPTMaxAssays

tblVWPTSamp

tblVWReportCollar

tblVWXRFIncomingResults

tblVWXRFResults

tblVWXRFResultsQC

#  32_500_usp_DataAssayQCRuleChecker

#10169: Changed LabElement length from 25 to 100

#  33_500_usp_ProcessImportData

#15652: Enhanced usp_ProcessImportData for DS5 3.2.0

#  34_500_tblVWSYSDispatchedSamples_CSV_Export

Enhanced tblVWSYSDispatchedSamples_CSV_Export for DS5 3.2.0

#  35_500_tblSYSAssDispatchDetails

New column tblSysAssDispatchDetails.Lab_Dispatch_Status for DS5 3.2.0

#  36_500_tblLIBCompany

New column tblLIBCompany.LabCode/Lab_OfficeCode for DS5 3.2.0

#  37_500_tblSYSAssDispatchHeader

New column tblSYSAssDispatchHeader.Lab_WorkOrder for DS5 3.2.0

#  38_500_pXRF_Plugin_v2.2_Upgrade

pXRF plugin v2.2 upgrade for DS5 3.2.0

#  39_500_usp_AdminBatchDelete

Fixed usp_AdminBatchDelete to handle tblSYSXRFIncomingData

#  40_500_usp_CRSGridTransform

#17876: Fixed Local to LL transformation

#  41_500_usp_DataAssayMergingProcess

Fixed QCRuleChecker call looping bug

# 42_500_usp_DataXRFResultsMergingProcess

#17888: Added update DataSet based on tblSampleRegister.SampleID

#  43_500_usp_GenerateMasterCalendar

#17889: New usp_GenerateMasterCalendar for PowerBI report

#  44_500_AssayManager_Task13627

#13627: DS5 assay manager config data

#  45_500_pXRF_Importing_References_Task17669

#13627: DS5 assay manager config data for pXRF

#  46_500_Grant_Permission_AllSPFunctions

#17891: Grant permission on all SP,Functions

#  47_500_EnableTrustedFK

#16968: Enable trusted FKs where possible

#  48_500_tblDHOrientation

#18302: Fixed logic bug with TR_iutblDHOrientation_Interval_Overlap

#  49_500_usp_NDS_LoggingStatistics

#18726: Fixed Hole status and Date_completed

#  50_500_StandardSampleModule

#18759: Reallocate standards sample table to new Standards Management module

#  51_500_tblDHSampWater

#19196: Fixed bug in TR_iutblDHSampWater_UsingActiveLIBCode

#  52_500_tblSYSConfigRelation

#19197: Add config relation record for tblAssayWater

#  53_500_tblVWDHSurv_Priority

#19201: Grant update permission on tblVWDHSurv_Priority to DS_SysAdmin

#  54_500_tblSYSDSConfig

#19202: Update DSConfig for table/view with From/To columns as DOWNHOLE instead of POINT

#  55_500_usp_ProcessInComingDataDriver

#19202: Added handle of different from/to columns like Length_From/To

#  56_500_usp_ProcessInComingDataDriver

#19839: Enhanced logic to handle SampleID length less than mask pattern length

#  57_500_Assay triggers

#19879: Enhanced assay triggers TR_u*_AssayResultNum_UnitCode_LimitLower_sysAssayStatus_Element to better handle reassay for DS5

              tblAssay

              tblAssayHyperspectral

              tblAssayWater

#  58_500_tblSYSXRFAttachment

New table tblSYSXRFAttachment for DS5 v3.2.0.1

#  59_500_MDS.tblSYSMappingAppConfigVals

DS5 v3.2.0.0 remove Micromine export config data

#  60_500_MDS.tblMasterCalendar

New table MDS.tblMasterCalendar used by QAQC PBI report

# 61_500_ProcessInComingDataDriver

#19905: Fixed bug with handling overlapping data masks

#  62_500_Coordinates views

#19941: Fixed bug with tblVWDHCoordinates/tblVWFSCoordinates/tblVWLSCoordinates/tblVWPTCoordinates view for FIELDSITED_Survey_Date/SURVEYED_Survey_Date

#  63_500_tblSYSDSConfig_OrderBy

#19988: set tblSYSDSConfig.OrderBy to NULL if contains column does not exist

#  64_500_tblVWDHCollarAttributes

#20031: Restrict to only look at Priority 0 lithology data

#  65_500_tblVWLSMaxAssays

#20032: Added assay values

#  66_500_tblSYSConfigRelation

#20032: Set tblSYSConfigRelation.Depth_From_Field for tblLSSampHyper table to be Length_From

#  67_500_tblSYSXRFAttachment

Grant permission to tblSYSXRFAttachment for DS5

#  68_500_QAQC_v2.1

New SP usp_RptQAQC_PBI_SampleSummary_DQ and usp_RptQAQC_PBI_Repeats_DQ for QAQC v2.1

#  69_500_usp_DataAssayQCRuleChecker

#20267: Exclude (PASS) element LOI from Repeats check rule

#  70_500_tblSYSAssMethodPriority

#20741: Enhance TR_iutblSYSAssMethodPriority_Rerank_Method logic for performance and add handle of other assay tables

#  71_500_usp_ProcessInComingDataDriver

#20733/20740: Enhanced usp_ProcessInComingDataDriver logic to only look config related to the @AssayTable and handle mask contains underscore "_"

#  72_500_AssayResult

#20280: Expand AssayResult column lenght from 20 to 100 on assay tables, updated usp_DataAssayQCRuleChecker to handle large column length

#  73_500_DS5_v3.2.1.0

DS5 v3.2.1.0 changes

#  74_500_usp_PopulateHALData

New usp_PopulateHALData for Historic Assay Loader extension

#  75_500_usp_ProcessInComingDataDriver

#21038: Enhanced logic to apply lab filter on masks when batch is specified

#  76_500_usp_ProcessInComingDataDriver

#21115: Enhanced logic to handle same sample existing in multiple batches

#  77_500_Views fix join bug

#22376: Fixed views have join bug when retrieve preferred grid for tblVWFSMaxAssays, tblVWFSSamp, tblVWLSMaxAssays, tblVWLSSamp, tblVWPTAssays, tblVWPTAssaysWater, tblVWPTMaxAssays, tblVWPTSamp, tblVWXRFIncomingResults, tblVWXRFResults, tblVWXRFResultsQC

#  78_500_tblProdSurvey

#22406: Corrected tblProdSurvey.Site_ID FK

#  79_500_usp_DataAssayMergingProcess

#22392: Enhanced logic to handle large buffer table without provide @LabCodeBatchNo filter

#  80_500_tblSYSAssDispatchTemplates

#22409: Aligned permission on tblSYSAssDispatchTemplates

#  81_500_Assay table validated triggers

#22416: Enhanced logic for better performance

#  82_500_Coordinate views

#22418: Update Coordinate views to include Preferred_Local

#  83_500_tblSYSFilter

#22493: Update filter definition in tblSYSFilter for "Missing Library Entries"

#  84_500_StandardSamp_ValidateTrigger

#23132: Fixed bug with Source_Type filter for validated trigger on tblStandardSamp/tblStandardSampQC

#  85_500_PBI_QAQC_v211_SPs

Updated PBI QAQC v2.1.1 SPs

#  86_500_usp_ProcessInComingDataDriver

#23706: Added @OverwriteDataSet to handle same sampleID associate with multiple active datasets. When @OverwriteDataSet specified, it will be used as the DataSet for all samples to be processed.

#  87_500_tblDHLithology

#24882: Changed tblDHLithology check constraint CK_tblDHLithology_Lith2_Texture_Structure_GrainSize_pct_Regolith_Overprint_Oxidation_Colour_Tone_Colour1_Colour2_Strat

#  88_500_usp_RptQAQC_PBI_SampleSummary_DQ

#24998: Added filter to exclude Repeat 0 from QCCategory result and SUM QCSampleCount as well.

#  89_500_tblSYSConfigRelation

#25002: Add assays (tblAssay, tblAssayHyperspectral, tblAssayWater, tblXRFResults) RHNORM config relation record if not already exists

#  90_500_usp_DataAssayQCRuleChecker

#23134/23672: Pass the record if sysResult is 0 and not throw divide by zero error. Also pass the record for repeat rule if Orig_LimitLower is NULL.

#25018: Pass the record for ScreenTest when value is on the right edge of the range. For example, when check range is 0-90, pass 90 instead of fail it.

#  91_500_GridTran triggers

#25217: Enhandled GridTran triggers to handle of delete last none transformed coordinate record. Renamed from TR_iu*_GridTran to TR_iud*_GridTran

#  092_500_Add_Preferred_Survey_Method to views

#25403: Add Preferred_Survey_Method to views for dsCONNECT

#  093_500_Assay_Management_SPs

#25224: Align @Loaded_By/@UserName in usp_DataAssayMergingProcess, usp_DataAssayRankingProcess and ProcessIncomingDataDriver SPs

#  094_500_usp_CRSGridTransform

#26544: Correct logic for local to LL transform

#  095_500_IntervalOverlapTriggers

#26657 Fixed bug with with not checking full PK set for interval overlap trigger on tblDHHazards, tblDHRegolith and tblDHStratigraphy

# 096_500_Prod_View_MachineryFactor 

#26685: Fixed join logic for machinery factor for views: tblVWProdLocationTrucking/tblVWProdReconTrucktoResource/tblVWProdTruckingCalculated #26690: tblVWProdTruckingClaimed - added Default_SG for Tonnage_Calculated

# 097_500_tblVWBudgetsDaily 

#27349: Added dates restriction to prevent error

# 098_500_Coordinates_table_Priority_Recal culate 

#28165: Set Coordinates table Priority Recalucate trigger to be run first

# 099_500_Validated_Date_Triggers

#29392: Fixed validation logic bug within Validate_Date triggers and enhanced Validated triggers to allow reset validated flag

# 100_500_tblDHGeotechRMR 

#30489: Fixed missing tblDHGeotechRMR.RQD_Deere_pct updates from 4.6.4 to 4.6.5

#  101_500_Assay_Management_SPs 

#28112: Fixed syntax bug with handling @LoadedBy in usp_DataAssayMergingProcess and ProcessIncomingDataDriver SPs #30644: Fixed bug when orig