I really want to get to the bottom as to why exactly this issue is occurring. Does anyone have any thoughts on this; Receiving this error in our php error log which causes the archive to fail.

 Class 'Zend_Db_Statement_Mysqli_Exception' not found in

Here is where the issue is occurring in /opt/piwik/libs/Zend/Db/Statement/Mysqli.php

        if ($this->_stmt === false || $mysqli->errno) {
             * @see Zend_Db_Statement_Mysqli_Exception
            // require_once 'Zend/Db/Statement/Mysqli/Exception.php';
            throw new Zend_Db_Statement_Mysqli_Exception("Mysqli prepare error: " . $mysqli->error, $mysqli->errno);

You should get a longer error message than this, with full backtrace. Is it output of archive.php?

This is the only message that is received. This is used from the output of the file we have not yet pushed forward the archive.php