Symptoms
When using the mArchive 1.3 tool for 4.6.11, I get the following error when running the execution script provided by the db consolidation pdf:
/****
Begin Transaction...
Begin Transaction...Done
Creating mArchiveBackupLog...
Creating mArchiveBackupLog...Done
Initialize Log Database - 2017-06-14 13:27:08
Initialize Log Database...Done
Checking for previous Archives...
Checking for previous Archives...Done
Initialize Archive Database
Initialize Archive Database...done
Dropping Indexes
Dropping Indexes...Done
Update Design data
Truncated _Act
Truncated _ActData
Truncated _ActXml
Truncated _Esc
Truncated _Event
Truncated _Line
Truncated _Proc
Truncated _ProcEsc
Truncated _EventEsc
Truncated _ProcData
Truncated _ProcSet
Truncated _ProcXml
Truncated _Setting
Truncated _LogBatch
Truncated _ProcRights
Counting rows in _Act ...
Inserting 10292 records into _Act - 2017-06-14 13:27:09
...Inserted _Act (10292 records) - 2017-06-14 13:27:09
Counting rows in _ActData ...
Inserting 25129 records into _ActData - 2017-06-14 13:27:09
...Inserted _ActData (25129 records) - 2017-06-14 13:27:09
Counting rows in _ActXml ...
Inserting 73 records into _ActXml - 2017-06-14 13:27:09
...Inserted _ActXml (73 records) - 2017-06-14 13:27:09
Counting rows in _Esc ...
Inserting 133 records into _Esc - 2017-06-14 13:27:09
...Inserted _Esc (133 records) - 2017-06-14 13:27:09
Counting rows in _ProcEsc ...
Inserting 0 records into _ProcEsc - 2017-06-14 13:27:09
...Inserted _ProcEsc (0 records) - 2017-06-14 13:27:09
Counting rows in _EventEsc ...
Inserting 0 records into _EventEsc - 2017-06-14 13:27:09
...Inserted _EventEsc (0 records) - 2017-06-14 13:27:09
Counting rows in _Event ...
Inserting 23185 records into _Event - 2017-06-14 13:27:09
...Inserted _Event (23185 records) - 2017-06-14 13:27:09
Counting rows in _Line ...
Inserting 15499 records into _Line - 2017-06-14 13:27:09
...Inserted _Line (15499 records) - 2017-06-14 13:27:10
Counting rows in _Proc ...
Inserting 938 records into _Proc - 2017-06-14 13:27:10
...Inserted _Proc (938 records) - 2017-06-14 13:27:10
Counting rows in _ProcData ...
Inserting 4799 records into _ProcData - 2017-06-14 13:27:10
...Inserted _ProcData (4799 records) - 2017-06-14 13:27:10
Counting rows in _ProcSet ...
Inserting 28 records into _ProcSet - 2017-06-14 13:27:10
...Inserted _ProcSet (28 records) - 2017-06-14 13:27:10
Counting rows in _ProcXml ...
Inserting 38 records into _ProcXml - 2017-06-14 13:27:10
...Inserted _ProcXml (38 records) - 2017-06-14 13:27:10
Counting rows in _Setting ...
Inserting 70 records into _Setting - 2017-06-14 13:27:10
...Inserted _Setting (70 records) - 2017-06-14 13:27:10
Counting rows in _LogBatch ...
!!!!!!!!!EXCEPTION!!!!!!!!!
Rollback Transaction...
Rollback Transaction...Done
Archiving NOT completed successfully
Msg 50000, Level 16, State 1, Procedure mArchive, Line 2665
Invalid object name '_LogBatch'.
Diagnosis
Fixed with mArchive 1.5 tool.
Solution
This was fixed with the mArchive 1.5 tool, which is also compatible with 4.6.11. You can obtain this newer version from K2 Support.