Article ID: 119236, created on Dec 20, 2013, last review on May 18, 2015

  • Applies to:
  • Odin Business Automation Standard 4.5


During OBAS upgrade to 4.5 version in accordance with the Release Notes the following error appears:

[root@pbas ~]# hspc-upgrade-manager --finish  
  => [factory finished] task-manager  
  => [factory finished] core  
  => [factory finished] cc  
  => [factory finished] configuration-manager  
    => [process section] '4.5-37'  
      => [exec start] '4.5/add_ext_attr_default_value.sql' with '/usr/sbin/hspc-sql' processor  
ERROR 1142 (42000) at line 1: SELECT command denied to user 'aspcomplete'@'<mysql_host>' for table 'COLUMNS'  
      => [exec error] '4.5/add_ext_attr_default_value.sql' in 0.09 secs  
=> [An error occurred while upgrade.]  


OBAS database is stored on an external server:

[root@pbas ~]# grep MAIN_DB /etc/hspc/hspc.conf  
MAIN_DB_HOST    = <mysql_host>  
MAIN_DB_NAME    = aspc  
MAIN_DB_USER    = <mysql_user>  
MAIN_DB_PASS    = <mysql_password>  

MySQL version 4 is installed on the remote database server <mysql_host>.

There is a software issue "PBAS-29182 - Upgrade to 4.5 failed with remote mysql 4 DB"

It was fixed in OBAS 4.5.1


Upgrade OBAS straight to 4.5.1.

Solution for failed upgrade to OBAS 4.5-55

  1. Upgrade MySQL to version 5 on the remote database server <mysql_host> manually.
  2. Run the script on OBAS node to complete the upgrade:

    [root@pbas ~]# hspc-upgrade-manager --finish

Related Articles

How to upgrade OBAS system to the latest available version?

Cannot upgrade OBAS to 4.5: "Access denied for user 'root'"

Search Words

An error occurred while upgrade

SELECT command denied to user 'aspcomplete'

external mysql

400e18f6ede9f8be5575a475d2d6b0a6 caea8340e2d186a540518d08602aa065 624ca542e40215e6f1d39170d8e7ec75 70a5401e8b9354cd1d64d0346f2c4a3e

Email subscription for changes to this article
Save as PDF