AppSync: Postgres upgrade fails

Summary: AppSync: Postgres upgrade fails

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

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.

Affected Products

AppSync

Products

AppSync
Article Properties
Article Number: 000057208
Article Type: Solution
Last Modified: 19 Sept 2025
Version:  6
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.