61930: Acronis Backup: ESXi configuration backup fails with "too many SQL variables" or "Command definition 'SELECT ...' not found."

use Google Translate

Symptoms

  1. You have a large vSphere environment, with several ESXi hosts and 1000+ virtual machines
  2. You install Agent for VMware and connect it to vCenter.
  3. You try to run a ESXi configuration backup for a host and the backup fails with one of the following errors:

    too many SQL variables

    OR

    Command definition 'SELECT ... '  not found.

Example of error log:

| error 0x1: too many SQL variables
| line: 0xf2f0816424d78491
| file: e:\235\enterprise\common\db\sqlite\sqlite_database.cpp:123
| function: Data::Sqlite::SqliteFacade::Prepare
| $module: dml_sqlite_addon_vsa64_10330

Cause

Issue in the product. 

 

Solution

As a workaround, connect the Agent for VMware directly to the ESXi host you are backing up, instead of the vCenter Server. See product documentation for instructions on changing the existing association with vCenter Server.

Acronis Development team is working on fixing this issue and the fix is planned for one of the future updates of the product. This article will be updated when a fix is available.

Tags: 

You are reporting a typo in the following text:
Simply click the "Send typo report" button to complete the report. You can also include a comment.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
20 + 0 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.