...
5. Manually remove the invalid dataset reference from the U05_DTA_SETS table in the AGRIS database. (The TenantIDs found in U05 all point back to A000 dataset, which refers to tenant neutral data. As such, the specific dataset reference in question does not get removed automatically from U05 when items 1-4 above are completed.)
As an example, if we were completing the removal of dataset 008 from the database name AGRIS, then we would use this command:
use AGRIS;
DELETE FROM U05_DTA_SETS WHERE U05_DSET_NUM_S=008
NOTE: It is possible that a U05_DSET_NUM_S reference for this dataset may not exist depending on what did or did not complete during the dataset import/copy operation.
6. Manually remove the invalid dataset reference from the Tenant table in the ACCELERATOR database.
As an example, if we were completing the removal of the TenantID used throughout this document, 9B6343B8-15B7-4DB9-B119-A83801194888, then we would use this command:
use ACCELERATOR;
DELETE FROM Tenant WHERE TenantID='9B6343B8-15B7-4DB9-B119-A83801194888'
NOTE: It is possible that a TenantID reference for this dataset may not exist in the [Accelerator].[dbo].[Tenant] table depending on what did or did not complete during the dataset import/copy operation.
Related articles
| Filter by label (Content by label) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|