Skip to main content
 

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. 



 
Be the first to reply!

Reply