---
title: "MDS v4.6.5 Hotfix"
canonical: "https://servicedesk.maxgeo.com/space/MDS/1393000450/MDS%20v4.6.5%20Hotfix"
format: markdown
---
# Table of Contents

> Macro (toc)


  


# > Macro (anchor)

MDS v4.6.5. HotFix - pXRF

<span style="color: #000000">This is for MDS v4.6.5</span>

<span style="color: #000000">This hotfix patches your current MDS schema with fixes for pXRF functions:</span>

<span style="color: #000000">Added column LabCode into tblSYSXRFIncomingLabStandards</span>

<span style="color: #000000">Fixed script error in following SPs:</span>

<span style="color: #000000"> usp_ProcessXRFStandardsInComingData</span>

<span style="color: #000000"> usp_ProcessXRFLabChecksInComingData</span>

<span style="color: #000000"> usp_DataXRFResultsMergingProcess</span>



# > Macro (anchor)

MDS v4.6.5 HotFix - tblSYSFilterType_Imago

<span style="color: #000000">This is for MDS v4.6.5</span>

<span style="color: #000000">This hotfix patches your current MDS schema with following changes:</span>

<span style="color: #000000">Updated tblSYSFilterType.FilterType definition for DownHole</span>

<span style="color: #000000">Added ImagoAccess/ImagoParam columns to tblSYSDSConfig table</span>



# > Macro (anchor)

MDS v4.6.5 HotFix - usp_RptDHLoggingStats

<span style="color: #000000">This is for MDS v4.6.5</span>

<span style="color: #000000">This hotfix enhanced usp_RptDHLoggingStats to better handle HoleStatus and date filter</span>


# > Macro (anchor)

MDS v4.6.5 HotFix - usp_RptDrillLogTableData

<span style="color: #000000">This is for MDS v4.6.5</span>

<span style="color: #000000">THis hotfix enhanced usp_RptDrillLogTableData to better handle Superseded/Priority filter</span>



# > Macro (anchor)

MDS v4.6.5 HotFix - usp_ProcessInComingDataDriver

<span style="color: #000000">This is for MDS v4.6.5</span>

<span style="color: #000000">This hotfix enhanced usp_ProcessInComingDataDriver to handle tblStandardSamp table may contain Hole_ID column and fixed syntex issue in usp_ProcessStandardsInComingData.</span>



# > Macro (anchor)

MDS v4.6.5 Hotfix - usp_DataAssayQCRuleChecker

<span style="color: #000000">This is for MDS v4.6.5</span>

<span style="color: #000000">This hotfix, as at 17th Jun 2021, enhanced usp_DataAssayQCRuleChecker to allow partial assay merge when no QC rule setup.</span>

  


# > Macro (anchor)

MDS v4.6.5 Hotfix - tblDHGeotechRMR.RQD_Deere_pct

<span style="color: #000000">This is for MDS v4.6.4 (or above to 4.6.5 with last SP date: 30/Jun/2020)</span>

<span style="color: #000000">This hotfix corrected the computation formula for column RQD_Deere_pct on tblDHGeotechRMR.</span>


# > Macro (anchor)

MDS v4.6.5 HotFix – tblSYSAssBatch

<span style="color: #000000">This is for MDS v4.5.0 (or above to 4.6.5 with last SP date: 30/Jun/2020)</span>

<span style="color: #000000">This hotfix patches your current MDS schema with enhanced version of CK_tblSYSAssBatch_Lab_Job_Date/CK_tblSYSAssBatch_Lab_Received_Date on tblSYSAssBatch as at 14th Oct 2021</span>

<span style="color: #000000">It also introduced new index IX_tblSYSAssBatch_Lab_Job_Date on tblSYSAssBatch to improve QAQC report in DS5.</span>


# > Macro (anchor)

MDS v4.6.5 HotFix - usp_DataAssayMergingProcess

<span style="color: #000000">This is for MDS v4.6.5</span>

<span style="color: #000000">This hotfix patches your current MDS schema with an enhanced version of usp_DataAssayMergingProcess stored procedure as at 13th Oct 2021</span>


# > Macro (anchor)

MDS v4.6.5 HotFix - QAQC Report SPs

<span style="color: #000000">This is for MDS v4.6.5</span>

<span style="color: #000000">This hotfix patches your current MDS schema with enhanced version of:</span>

<span style="color: #000000">usp_RptQAQC_MonthlyReport_Repeatability</span>

<span style="color: #000000">usp_RptQAQC_MonthlyReport_Flushes</span>

<span style="color: #000000">usp_RptQAQC_MonthlyReport_CrushChecks</span>

<span style="color: #000000">usp_RptQAQC_MonthlyReport_CRMStandards</span>

<span style="color: #000000">usp_RptQAQC_MonthlyReport_Blank</span>

<span style="color: #000000">usp_RptQAQC_MonthlyReport</span>

<span style="color: #000000">usp_RptQAQC_MonthlyReport_BadStandards</span>

<span style="color: #000000">usp_RptQAQC_ScreenTest_Summary</span>



# > Macro (anchor)

MDS v4.6.5 HotFix – usp_GridTransform

<span style="color: #000000">This is for MDS v4.6.0 (or above to 4.6.5 with last SP date: 30/Jun/2020)</span>

<span style="color: #000000">This hotfix patches your current MDS schema with enhanced version of usp_GridTransformation to have option to exclude transform validated records.</span>

# > Macro (anchor)

MDS v4.6.5 HotFix – Assay view GenericMethod change

<span style="color: #000000">This is for MDS v4.6.5</span>

<span style="color: #000000">This hotfix patches your current MDS schema with enhanced logic for GenericMethod/LabCode/Batch_No in assay views.</span>

<span style="color: #000000">Please note, this patch assumed the primary commodity of the database is AU. If your primary commodity is not AU, please update respective configurations in assay normalisation (ranking) configuration. This is critical before load any assay data after this patch, if your primary commodity is not AU.</span>

<span style="color: #000000">The patch will auto migrate GenericMethod/LabCode/Batch_No data in the view into assay flat tables.</span>

<span style="color: #000000">The patch will attempt to update following views (if they haven't been modified from base MDS) to utilise the new change. If any views have been modified, please manually update them accordingly:</span>

<span style="color: #000000">	tblVWDHAssays</span>

<span style="color: #000000">	tblVWDHAssaysQC</span>

<span style="color: #000000">	tblVWDHAssaysWater</span>

<span style="color: #000000">	tblVWDHAssaysWaterQC</span>

<span style="color: #000000">	tblVWLSAssays</span>

<span style="color: #000000">	tblVWLSAssaysQC</span>

<span style="color: #000000">	tblVWLSAssaysWater</span>

<span style="color: #000000">	tblVWLSAssaysWaterQC</span>

<span style="color: #000000">	tblVWPTAssays</span>

<span style="color: #000000">	tblVWPTAssaysWater</span>

<span style="color: #000000">	tblVWStandardAssays</span>

<span style="color: #000000">	tblVWStandardAssaysQC</span>

<span style="color: #000000">	tblVWStandardAssaysWater</span>

<span style="color: #000000">	tblVWStandardAssaysWaterQC</span>

<span style="color: #000000">  </span>

<span style="color: #000000">	tblVWFSAssays</span>

<span style="color: #000000">	tblVWFSAssaysQC</span>

<span style="color: #000000">	tblVWFSAssaysWater</span>

<span style="color: #000000">	tblVWFSAssaysWaterQC</span>



# > Macro (anchor)

MDS v4.6.5 HotFix – MDS.tblSYSAppResource

<span style="color: #000000">This is for MDS v4.6.0 (or above to 4.6.5 with last SP date: 30/Jun/2020)</span>

<span style="color: #000000">This hotfix patches your current MDS schema with enhanced triggers on MDS.tblSYSAppResource table to better handle LogChief sync.</span>


# > Macro (anchor)

MDS v4.6.5 Hotfix - usp_RptQAQC_MonthlyReport_CRMStandards

<span style="color: #000000">This is for MDS v4.6.5</span>

<span style="color: #000000">This hotfix patches your current MDS schema with an enhanced version of usp_RptQAQC_MonthlyReport_CRMStandards as at 17th May 2022!</span>


# > Macro (anchor)

MDS v4.6.5 HoFix - usp_DataStructOrientDriver

<span style="color: #000000">This is for MDS v4.6.5</span>

<span style="color: #000000">This hotfix patches your current MDS schema with an enhanced version of usp_DataStructOrientDriver as at 31/May/2022. It introduced tblSYSParam.StructOrient_AzimuthField option to controle azimuth field used to run usp_DataStructOrientDriver.</span>

# > Macro (anchor)

MDS v4.6.5_Hotfix_ProcessIncomingDataDriver SPs

<span style="color: #000000">This is for MDS v4.6.5</span>

<span style="color: #000000">This hotfix patches your current MDS schema with enhanced version of IncomingDataDriver SPs as at 11th Jul 2022</span>


# MDS v4.6.5_Hotfix_18_usp_AdminBatchDelete

<span style="color: #000000">This is for MDS v4.6.5</span>

<span style="color: #000000">This hotfix patches your current MDS schema with enhanced version of the usp_AdminBatchDelete SP as at 25 Aug 2022</span>

# > Macro (anchor)

MDS v4.6.5_Hotfix_19_tblSYSQCSampleEvents

<span style="color: #000000">This is for MDS v4.6.5</span>

<span style="color: #000000">This patch updates your current MDS schema and changes tblSYSQCSampleEvents.SampleID column length from 30 to 50</span>

# > Macro (anchor)

MDS v4.6.6_HotFix_20_Assay Merge SPs

<span style="color: #000000">This is for MDS v4.6.5 (or above to 4.6.6 with last SP date: 01/Aug/2022)</span>

<span style="color: #000000">This hotfix patches your current MDS schema with enhanced version of the following SPs as at 12th Jul 2023:</span>

<span style="color: #000000">usp_DataAssayMergingProcess</span>

<span style="color: #000000">usp_DataAssayUpdateBatchStatus</span>

<span style="color: #000000">usp_DataAssayQCRuleChecker</span>