Alteryx Upgrade to 22.3 version - migration failed due to corrupted data

[AsmaM]

Hi Team,

We are trying to do Alteryx  upgrade from 22.1 version to 22.3 version, where we have to run pre-migration tool as mongo db re-encryption happened in this version.Before upgrading to 22.3 we ran pre-upgrade checks as mentioned in this doc https://knowledge.alteryx.com/index/s/article/server-pre-upgrade-checks which went fine.  

After running pre-migration tool faced the below error and migration failed.
3;Error Unpackaging app: <Id> Error: The attached file was missing in Mongo: The collection is <AS_App_Chunks.Files>; The Id is <id>

 Mongodump we took from 21.1 version from old server and restored it in new server which is having 22.1 version.In new server with  22.1 version after we restored mongodump we could see all the workflows in admin tab.

we are assuming the problem might be that the data from the 2021.1 version is corrupted. Alteryx’s metadata lets you see the workflows, but the underlying chunks associated with those workflows seem to be corrupted.Hoping to get any resolution/help to correct the corrupted data.

There are no resolutions/articles available for this kind of issue.

Note: We can't install 21.1 version in new server as the support is already ended for that version by alteryx.

Any help would be appreciated.

[mbaerend]

Hi AsmaM, 

I'm sorry to hear you ran into trouble with the upgrade. If there are corrupted workflows, that will cause the migration to fail. Please reach out to Alteryx support and they will be able to help you identify and mitigate the issue. 

Cheers,

Mariah Baerend

[Bleon]

This seems to be something that is happening, quite frequently, but no details on how to identify the workflow associated with the issue. It would be helpful for support or someone who worked with support to at least offer a resolution. Fortunately, this was found in the pre-migration check, we did, so no outage was accompanied by this discovery. Can someone post the queries needed to identify the related workflows associated with this appChunk ID?

2024-03-30 15:55:00.807358;3;Error Unpackaging app: <> Error: Internal Error in Read: Data decryption failed

Thanks,

Branden

[rcaro7]

I have faced the same error when upgrading from 2022.1 to 2023.2:

Error Unpackaging app: <id> Username, <id> CreationDateTime, <2021-12-08 10:56:50> Error: The attached file was missing in Mongo: The collection is <AS_App_Chunks.Files>; The Id is <id>> Error: Error in validating workflow chunks. Please check workflow is valid in Server UI

I had ran the Migration Prep Tool, and also the Server Pre-Upgrade Check (2018.3+) [2.2.4 - Public]

I immediatelly contacted Alteryx Support (through Mission Control) and had a Teams meeting with a Technical support representative

We had 1701 records (apps) which were corrupted and had to be deleted from the MongoDB database in order to successfully run the AlteryxService