After upgrading Parallels Business Automation Standard to 4.5.2 I can not create a Virtual Machine if there are node groups assigned to the Virtual machine Hosting Plan. Order on Virtual Server fails and I see the following error in the Action Log:
[2014/05/28 18:48:13] [ERROR]  [HSPC::MT::Billing::process_documents] Can't process doc #12345: provisioning failed: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR `gp`.`group_id` IN(13)) AND `ip`.`holder_obj_id` IS NULL AND `ip_pool`.`ippoo' at line 1 at /usr/local/share/perl5/HSPC/WebDB.pm line 286.
The software issue PBAS-29450 is fixed in PBAS version 4.5.3
Upgrade PBAS to the latest version.
Hotfixes for PBAS 4.5.2 are attached.
To apply a hotfix
- Download the rpm that complies with your system architecture (32-bit or 64-bit);
Install the rpm:
#rpm -Uvh hspc-ipmanager-4.5.3-03.swsoft.x86_64.rpm
#rpm -Uvh hspc-ipmanager-4.5.3-03.swsoft.i386.rpm
Restart the hspcd service:
#service hspcd restart