Skip to main content

How to Change Tags from Uploading to Not-Uploading

Occasionally, a tag can become stuck in an uploading state, which can prevent users from adding it to a new request.
For example, a tag may have been used for live streaming and then return 400 or 500 errors when later included in a historical request.

This guide explains how to identify tags in the uploading state and set them back to not-uploading so they can be added to new requests.

warning

When making changes in production, ensure another team member is present and observing through screen share.

Instructions​

  1. Navigate to the Tag Controller database in Azure and open the query editor.

  2. Run the following query to identify tags currently in the uploading state:

select * from [dbo].[TagMap]
where uploading = 1
  1. Create a backup of the TagMap table:
select * into TagMapOld from [dbo].[TagMap]
  1. Update tags with an uploading state of 1 to 0:
update [dbo].[TagMap] set uploading = 0 where uploading = 1

The number of updated rows should match the count returned in Step 2.