W-16299360 "
When attempting to upgrade Tableau Server, an unexpected ""This job failed due to unexpected error: 'TApplicationException'...Internal error processing completeApplyMigrations"" error occurs during the upgrade process.

NOTE: This issue can also occur during the blue/green upgrade process when restoring a Tableau Server backup

The following error may display when running the Tableau Server upgrade script:

This job failed due to unexpected error: 'TApplicationException'
org.apache.thrift.TApplicationException: Internal error processing completeApplyMigrations
Error message located in the databasemaintenance.log file:

Error:
Caused by: org.postgresql.util.PSQLException: ERROR: could not create unique index
""id__ad_identity_store_instance_id_lower_sam_acct_name_state_idx""

Impacted Versions

2023.3.7
2023.3.8
2023.1.14
2023.1.15
2022.3.18
2022.3.19"

W-15840768 Upgrades from Tableau Server versions prior to 2022.3, to version 2022.3 or later, result in the Views (all-time) counts displaying and sorting incorrectly in the ""Explore"" section.

Notably, the sorting order from the prior version may be preserved, despite the view counts being different and out-of-order numerically even when viewing in Descending Sort Order.