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.

Internal content

Link on internal Article