Logging Tables

The Connector includes several logging tables for different purposes. Error management and functional use of these tables are described in the documentation for each table.

Class Record Updates

The Connector logs updates to the class tables and errors. These logs are created when spMFUpdateTable is executed.

The table MFUpdateHistory contains details of every class table update that the Connector performs against SQL and M‑Files. The ID of this table is recorded in the class table as the Update ID. Consequently the class table shows the ID in the history of the last update to the object.

The following core operations record entries in this table:

Use the procedure spMFUpdateHistoryShow to explore summarized content and lists for a specific UpdateID.

The table MFAuditHistory contains the object version (ObjID, version, class, object type) for every object in class tables and is used to cross‑check the object version status with the class table object detail. Use the view MFvwAuditSummary for a summarized result. When the procedure spMFObjectTypeUpdateClassIndex is run, the audit table will include details of all tables, not only those with class tables. Use the view MFvwObjectChangeHistory for details about the object count and highest ObjID of the class.

Procedure Processing logs

Two tables are used to log key events for key procedures. MFProcessBatch has a unique reference for each process. A single record is created when the process starts and updated with progress until completion. The MFProcessBatchDetail records individual entries for key events of each process batch.

These tables also include procedures actioned through the context menu. Activity through the vault application is also recorded in the logs defined in the configuration section of the MFSQL Connector VAF application.

These logs are set for all standard procedures. Custom procedures can include entries to MFProcessBatch by using spMFProcessBatch_Upsert and to MFProcessBatchDetail by using spMFProcessBatchDetail_Insert.

Error logs

System errors are logged when triggered in any procedure. The table MFLog contains details of the system errors reported by the Connector.

Error entries in the MFLog table trigger an email to the address in the MFSettings table SupportEmailRecipient. This email depends on Database Mail being set up on the server. The logs can also be inspected with

SELECT * FROM dbo.MFLog ORDER BY LogID DESC

An example of such an email is below. image0