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

> Macro (toc)


  


# > Macro (anchor)

MDS v4.6 HotFix -Client_Validated_Reset trigger on tblContractActivityLog tables

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

<span style="color: #000000">This hotfix enhanced the Client_Validated_Reset triggers on tblContractActivityLog* tables to better handle change of PK values.</span>


# > Macro (anchor)

MDS v4.6.3 HotFix -02_MDS.tblSYSConfig

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

<span style="color: #000000">This hotfix set correct DAL version number for MDS v4.6.3.</span>


# > Macro (anchor)

MDS v4.6 HotFix - tblDHColl Max_Depth trigger

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

<span style="color: #000000">This hotfix updates the trigger TR_utblDHColl_Max_Depth for better performance</span>


# > Macro (anchor)

MDS v4.6.2+ HotFix – tblVWProdTruckingRpt

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

<span style="color: #000000">This hotfix fixes Ounces calculation formula in tblVWProdTruckingRpt and associated extension SQL statements</span>


# > Macro (anchor)

MDS v4.6.3 HotFix -05_Validated triggers

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

<span style="color: #000000">This hotfix This hotfix add DH table validated triggers and updater FS/LS/PT table validated triggers</span>


# > Macro (anchor)

MDS v463 HotFix -07_tblDHRadiometrics

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

<span style="color: #000000">This hotfix enhanced tblDHRadiometrics with added Priority column</span>


# > Macro (anchor)

MDS v463 HotFix -08_Surpac tables

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

<span style="color: #000000">This hotfix fixed Surpac tables to work with Surpac</span>


# > Macro (anchor)

MDS v4.6.3 HotFix - 10_SchemaAuditTrigger

This is for MDS v4.6.0 (or above to 4.6.3 with last SP date: 01/Aug/2017)

This hotfix enhanced the schema audit trigger as at 28/Feb/2018


# > Macro (anchor)

MDS v4.6.3 HotFix - 15_tblSYSAssElement

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

<span style="color: #000000">This hotfix patches your current MDS schema with an enhanced version of trigger TR_utblSYSAssElement_SystemUnits on table tblSYSAssElement as at 6th Jun 2018</span>


# > Macro (anchor)

MDS v4.6.3 HotFix - 17_tblDHSurv

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

<span style="color: #000000">This hotfix enhanced TR_iudtblDHSurv_Priority_Recalculate to reflect rename tblSYSParam.HeighestPriorityValue to HighestPriorityValue as at 25th Sep 2018</span>


# > Macro (anchor)

MDS v4.6.3 Hotfix - 18_tblSYSFilterItem

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

<span style="color: #000000">This hotfix increased column tblSYSFilterItem.FilterItem_Field length from 20 to 100</span>



  


# > Macro (anchor)

Enhanced functions, stored procedures

# MDS v4.6.3SP1 HotFix - 07_usp_DataAssayRankingProcess

<span style="color: #000000">This is for MDS v4.6.0 (or above to 4.6.3 with last SP date: 15/Apr/2018)</span>

<span style="color: #000000">This hotfix patches your current MDS schema with an enhanced version of usp_DataAssayRankingProcess stored procedure as at 19th Nov 2018!</span>