Search Engine: Elastic

Article ID: 130639, created on Apr 13, 2017, last review on Apr 13, 2017

  • Applies to:
  • Operations Automation 7.0

Symptoms

  1. Task to upgrade "Parallels Presence Builder for PA" instance to 12.0.7 failed with error:

    Script execution failed: executing '/usr/bin/sw-engine-cgi -d open_basedir= -q configure.php' for APS application instance with id 9 returned value '1' with output '' and errors ''.
    
  2. PPB upgrade log ($path_to_webspace/webspace/siteapps/1/htdocs/tmp/upgrade.log) contains the error:

    2017-04-13T11:55:42+02:00       [INFO]          Start adding index 'uuid' into 'widget_map_markers' table...
    2017-04-13T11:55:42+02:00       [EMERG]         Zend_Db_Statement_Exception: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 2
    file: /var/www/vhosts/2/100017/webspace/siteapps/9/htdocs/include/Zend/Db/Statement/Pdo.php
    line: 234
    code: 23000
    

    NOTE: In the example above, $path_to_webspace is the folder the instance of "Parallels Presence Builder for PA" is installed to.

Cause

PPB DB inconsistency. The table 'widget_map_markers' contains the records with not unique 'uuid' field. Upgrade script tries to assign attribute 'UNIQUE' to 'uuid' field and fails.

Resolution

Contact Odin Technical Support for assistance.

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 0871c0b47b3b86ae3b1af4c2942cd0ce 1941880841f714e458ae4dc3d9f3062d

Email subscription for changes to this article
Save as PDF