Remove Historical Tag Providers

Ignition
9

The other avenue involves going into the internal database, which is inherently risky. If you’re not comfortable, or not willing to take the risk, then I would suggest contacting support.
If you do just want to do it, then:

  1. Get a gateway backup. This should always be your first step when doing any significant modification, but especially when directly affecting the internal database.
  2. Navigate to the “Status” section of the gateway web interface. Then add sys.internaldb to the path in the URL bar, so you’re navigating to something like http://localhost:8088/web/status/sys.internaldb
  3. Run a query to find the ID of the provider record you need to delete, in the query box:
    select TAGHISTORYPROVIDEREP_ID, NAME, ENABLED, TYPE, DESCRIPTION from TAGHISTORYPROVIDEREP;
  4. Run the appropriate delete query to remove that record.
13 Likes