- You have a large vSphere environment, with several ESXi hosts and 1000+ virtual machines
- You install Agent for VMware and connect it to vCenter.
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
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
Issue in the product.
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.