Search Engine: Elastic

Article ID: 121793, created on May 28, 2014, last review on Jul 14, 2018

  • Applies to:
  • Odin Business Automation Standard 4.5


After upgrading Odin 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] [31284] [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/ line 286.


The software issue PBAS-29450 is fixed in OBAS version 4.5.3


Upgrade OBAS to the latest version.

Hotfixes for OBAS 4.5.2 are attached.

For 32-bit systems

For 64-bit systems

To apply a hotfix

  1. Download the rpm that complies with your system architecture (32-bit or 64-bit);
  2. 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
  3. Restart the hspcd service:

    #service hspcd restart

    Warning: Restart of the hspcd service will cause OBAS downtime for about 10-60 seconds.

400e18f6ede9f8be5575a475d2d6b0a6 caea8340e2d186a540518d08602aa065 624ca542e40215e6f1d39170d8e7ec75 70a5401e8b9354cd1d64d0346f2c4a3e

Email subscription for changes to this article
Save as PDF