Skip to main content
  • Place orders quickly and easily
  • View orders and track your shipping status
  • Enjoy members-only rewards and discounts
  • Create and access a list of your products
  • Manage your Dell EMC sites, products, and product-level contacts using Company Administration.
Some article numbers may have changed. If this isn't what you're looking for, try searching all articles. Search articles

Article Number: 000057208


AppSync: Postgres upgrade fails

Article Content


Symptoms



Postgres is being upgraded per KB 000504125, and it fails to upgrade Postgres.

The appsync_dbupgrade.log will show:
 
Command.run(): C:\Users\userid\AppData\Local\Temp\2\011266.tmp\executeScriptTmp0.bat:stdout [Failure, exiting]
Command.complete(): process completed with exit code: 1

The pg_upgrade_utility.log will show:
 
command: xcopy /e /y /q /r "E:\EMC\AppSync\jboss\datastore\data/pg_clog" "E:\EMC\AppSync\NewDatastore\data/pg_clog\" >> "pg_upgrade_utility.log" 2>&1
Invalid drive specification
0 File(s) copied

Note: The pg_upgrade_utility.log located in %AppData% will be removed when clicking OK when the failed upgrade message is presented during the upgrade dialog. Therefor this file must be collected before clicking OK and existing the upgrade dialog.

Note: The AppSync database resides in a non-default location, the E: drive in this example.

Cause

The trigger is a permission related issue for which the precise cause is not known.
The upgrade utility is being run as administrator and the user who is logged in when the upgrade utility is run as administrator via the right click method is a Domain administrator which exists in the local admin group which has full rights to the E: drive.

Regardless, should you use procmon to debug, you will find permission errors for the logged in user to the E: drive.

Resolution

Explicitly provide full administrative right to the E: drive for the specific user that is logged in when running the upgrade process.

Article Properties


Affected Product

AppSync

Product

AppSync

Last Published Date

20 Nov 2020

Version

2

Article Type

Solution