How do I delete a data source that says it is still in use by a profile?


Webtrends Analytics 9.x
Webtrends Analytics 8.x
Webtrends Enterprise 7.5x
Webtrends Professional 7.5x
Webtrends Small Business 7.5x


A data source cannot be deleted from within the user interface due to being in use by another profile.


1. Connect to the system database using a front end like SQLYog or Microsoft Management Studio, depending on the type of database/version of the product.
2. Find the wt_profile table under the wtmaster section of the database.
3. The ProfileName value of profiles which were recently deleted will have a corresponding ProfileStatusID value of 4, indicating they are pending deletion. Note the ProfileID value for each profile with a ProfileStatusID of 4.
4. Delete all entries in wt_profile that have a ProfileStatusID value of 4.
5. Under wt_profiledatasource, delete each entry for a ProfileID corresponding to the ProfileID of the affected profiles as displayed in wt_profile.
6. Close the database editor, log back into Webtrends and attempt to delete the data source(s) again. The above-mentioned steps will have removed the dependencies and it should now be possible to delete them.
Note: It is recommended that backups are made of the system database before making modifications.