Search Engine: Elastic

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

  • Applies to:
  • Odin Business Automation Standard 4.5

Symptoms

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.]  

Cause

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

Resolution

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'"

400e18f6ede9f8be5575a475d2d6b0a6 caea8340e2d186a540518d08602aa065 624ca542e40215e6f1d39170d8e7ec75 70a5401e8b9354cd1d64d0346f2c4a3e

Email subscription for changes to this article
Save as PDF