Specify Warehouse Settings

You can use the warehouse settings to:

  • Assist in the management of the database size
  • Specify a server restart after an error condition
  • Reduce the number of transactions involved in downstreaming
  • Enable warehousing
  • Perform transaction bucket checking prior to warehousing
  • Allow for automatic archiving by specifying archiving rules
  • Make downstreaming more efficient by specifying the date on and before which transaction records are archived
  • Specify cut-off settings for WAG stockpile calculations

Warehousing is required for external reporting packages.

Security Note: You need the Allow server engine settings security right in the Options user group security rights group for this activity.

Activity Steps

  1. Open the Warehouse Settings.
  2. Select the Warehouse Settings tab to view or edit warehouse settings:
    • Contributor Remnant Cut-off—Level at which small contributor values are removed permanently. If the small contributor remnant values which build up over time in weighted-average grade (WAG) stockpiles are allowed to remain in the MineMarket stockpile State Engine memory, system performance may be seriously degraded. These values are typically set at 1% or less. If contributors are being used for financial purposes (for example, cost or revenue distribution), a lower value is usually set (for example, 0.01%). This value must be between 0.00001 and 1.0.
    • Unassigned Contributor Redistribution—Percentage threshold for redistributing unassigned contributors during warehouse calculations. If the unassigned stockpile contributors total more than the unassigned contributors redistribution value setting and the unassigned contributor warning flag setting has been activated, a warning message (in red) displays when displaying stockpile contributors. See Specify Contributor Settings. This value must be between 0 and 10.
    • Error Restart—Number of minutes to wait before restarting the warehousing if an error has stopped the warehousing.
    • 3D Tonnage Mismatch Threshold Percent—If the difference between the specified reclaim tonnage and the actual tonnes reclaimed from the 3D stockpile exceeds this threshold, a tonnage mismatch warning displays for the transaction. Changing the threshold percentage only affects future transactions that are warehoused.
    • Minimum Remnant Transactions—Minimum number of transactions sampled before remnant cut-off can occur.
    • Remnant Cut-off—Cut-off percentage for old transactions to be declared irrelevant and dropped from the state for WAG stockpiles.
    • Use Remnant Cut-off—Whether the remnant cut-off is used for WAG stockpiles. If unchecked, the contributor will dig to the last level. (Not recommended)
    • Warehouse Enabled—Whether warehousing is enabled.
    • Perform Transaction Bucket Checking—Whether the transaction bucket is made self-healing by analysing the content of the main bucket and each stockpile bucket before warehousing commences.
    • Warehouse Errors Before Notification—Number of errors that can occur before a notification is sent to the client.
    • Warehousing Required—Whether warehousing is required. This field is not editable; it is defined automatically by the application.
    • Warehousing Batch Size—The number of transactions and surveys that are processed during each warehousing batch. The minimum value is 10 and the maximum value is 2000.
    • Warehousing Save List Size—The number of persistent objects that are saved at once during warehousing. The minimum value is 25 and the maximum value is 1000.
    • Default Transactions Between Each Full State—The default number of transactions between each stored full stockpile state in the MineMarket database. This setting is only applicable to new 3D, FIFO and LIFO stockpiles. This setting affects how often full transaction states (FIFO and LIFO layers, and 3D stockpile geometry data) are stored. The lower the value, the more often full states are recorded, but the more database storage is used. The higher the value, the less often full states are recorded, but this has a negative impact on performance. Prior to MineMarket 4.11.0, this setting was hard coded for 3D stockpiles to 40 transactions between each full state. This value is recommended for 3D stockpiles and any supply chains that include 3D stockpiles. If the supply chain only has FIFO or LIFO (or WAG) stockpiles, a much larger value is recommended; for example, 1000.
  3. Select the Previous Archives tab to view or edit the details of the last database archive.

    Note: The Rollback button is active if you select an old archive. If you click the Rollback button, the archive can be brought back into the data currently available.

  4. Select the Archive Settings tab to view or edit the database archive settings. See Enable Archiving.
  5. Select the In-Memory Calcs tab to view or edit details of calculations performed in memory.
    • No Cut-Off—If selected, no warehousing cut-off is used for WAG stockpiles.
    • Use These Cut-Off Settings—If selected, the Cut-Off Relevance and Minimum No. Of Transactions To Use are used for warehousing cut-off for WAG stockpiles.
    • Cut-Off Relevance—Relevance percentage of the WAG cut-off. The relevance percentage indicates the proportion of a WAG stockpile's mass for which analyte sample values are known.
    • Minimum No. Of Transactions To Use—Minimum number of transactions to use for WAG cut-off.
    • Bigger Cut-Off/Smaller Cut-Off—Sliding scale used to set WAG cut-off relevance and the minimum number of transactions to use.
  6. Select the Status Messages tab to view or edit settings for server statistics.
    • Enable Message Thread—Whether the thread that requests server statistics is executed.
    • Timer Interval—In seconds.
  7. Click OK.

    Note: MineMarket saves the changes from this screen automatically. This saving does not include any unsaved changes made on any other screens.