Products
Webtrends Analytics 9.x
Webtrends Analytics 8.x
Cause
You need to configure 2 SDC datasources that use the same dcsid for organization purposes but when you try to use an existing DCSID, you are told, “The SmartSource Site ID (DCSID) you entered already exists in the system. Please enter a unique DCSID.”
Resolution
The UI does not allow you use a DCSID more than once as it is supposed to be unique for each Datasource. You have 2 workarounds you can use:
A The DCSID is used solely to help create the javascript tag and as a result, has no impact on what the Datasource will actually look at. Due to this, you can make a non-SDC Datasource and point it at the desired DCSID’s logs to achieve 2 Datasources looking at the same SDC logs.
2. The DCSID is stored in the databases wtMaster in the table wt_Datasource. As a result, you can manually change the DCSID for the desired Datasource and allow the UI to show the DCSID for both Datasources. To do this, please do the following:
a. Backup your databases as per the KB article based on you database version:
c. Run the following query to update the database. You will need to replace “DATASOURCE NAME” with the name of your Datasource and “DCSID” with your desired DCSID
For Analytics with MySQL Databases (8.1a and earlier)
Use wtMaster;
UPDATE wt_Datasource SET DCSID=’DCSID’ WHERE Name=’DATASOURCE NAME’;
For Analytics with MS SQL Databases (8.5 and later)
UPDATE wtMaster.dbo.wt_Datasource SET DCSID=’DCSID’ WHERE Name=’DATASOURCE NAME’;
For example:
UPDATE wtMaster.dbo.wt_Datasource SET DCSID=’dcsd2bkcgakqoacduxs5mrlxg_5o2v’ WHERE Name=’New SDC Datasource’;