Happy 8th birthday to the Maveryx Community! Take a walk down memory lane in our birthday blog, and don't miss out on the awesome birthday present that all Maveryx Community members get to take advantage of!
How to Identify and Fix Null/Incorrect values in Subscriptions collection
When upgrading to an Alteryx Server version 2020.1 or later, users can run into issues during or after upgrade if they have Subscriptions (Paid Subscriptions) that contain null Expiration Dates. This article explains how to correct these null values.
If you are upgrading to 2020.3+, you do not need to update these values.
If you have already run the Pre-Upgrade Check application (found here) and have the PDF report, go straight to the "Update Subscriptions with Null ExpirationDate/ExpDate by Query" section for steps on how to correct the identified users. Please refer to the article above if you would like to run an Alteryx application to check these values, rather than the MongoDB queries below.
Upgrading to version 2020.1 or 2020.2
If you are upgrading to a later version, you do not need to update these values.
As much as possible, you should make edits from the Users page in Gallery > Admin > Subscriptions. If you run into issues making the changes via the Gallery, advanced users can make the edits directly in the database by following the steps below. If you would like assistance with the manual database edits, please contact Alteryx Support.
To locate the subscription in the Gallery:
Copy the alphanumeric ID value returned from the query. The id is the highlighted part below: