Error: Failed to read a valid system id from the wtMaster database

Error: Failed to read a valid system id from the wtMaster database

Affected environments:

Webtrends Enterprise 7.0x
Webtrends Professional 7.0x
Webtrends Small Business 7.0x
Webtrends Analytics 8.x

Situation:

When attempting to license the product the following error appears:

Failed to read a valid system id from the wtMaster database

During the install a named instance is being used for the Microsoft SQL installation.

NOTE: This has also been seen on clean installs of 8.7d not explicitly using a named instance.

Solution:

Webtrends has not been tested nor supports Microsoft SQL named instances. The program will install components and files appropriately but will not create valid system information in the wt_Master database for the following tables:

wt_app_confdata
wt_app_profiles
wt_app_sections
wt_app_tokens

Without this information Webtrends cannot be properly licensed. Although using Microsoft SQL named instances is not supported it is still possible to resolve this issue by creating the necessary entries in the database tables.

To do this please follow the instructions below:

 1. Open Microsoft SQL Server Enterprise Manager.
 2. Open wt_app_tokens table, returing all rows.
 3. Add a new row, tab to the key_name column, add Key into the row.
 4. Press ENTER. * Note the id created for the new row. This id should be noted as the key_id.
 5. Open wt_app_profiles table, returing all rows.
 6. Add a new row, tab to the profile_name column, add system.ini into the row.
 7. Press ENTER. * Note the id created for the new row. This id should be noted as the profile_id.
 8. Open wt_app_sections table, returing all rows.
 9. Add a new row, tab to the section_name column, add systemid into the row.
 10. Press ENTER. * Note the id created for the new row. This id should be noted as the section_id.
 11. Open wt_app_confdata table, returing all rows.
 12. Add a new row, tab to the profile_id column, add the profile_id noted in Step 7.
 13. Tab to the section_id column, add the section_id noted in Step 10.
 14. Tab to the key_id column, add the key_id noted in Step 4.
 15. Tab to the data column, add the MAC address of the primary Network Card. Exclude the "-" (dashes) and        use  lowercase for the alpha characters.
 16. Press ENTER. It should return an "id" number for this row. Please disregard this value.
 17. Restart the Microsoft SQL service and the following Webtrends services: · Webtrends - Apache · Webtrends - Scheduler Agent · Webtrends - Tomcat
 18. Click the Webtrends product icon and add the activation key, the product should license successfully. You should now be able to successfully login and use the product.

    • Related Articles

    • Error: "Failed to read a valid system id from the wtMaster database."

      For products: Webtrends Analytics 9.2x Webtrends Analytics 8.x Webtrends Enterprise 7.x Webtrends Professional 7.x Webtrends Small Business 7.x Last modified: 5/6/2011 Situation: When attempting to activate a Webtrends installation, the following ...

    • "Authentication failed. Webtrends server error ID: 116"

      For products: Webtrends Analytics 9.2a Webtrends Analytics 8.x Webtrends Enterprise 7.x Webtrends Professional 7.x Webtrends Small Business 7.x Last modified: 8/6/2010 Situation: When attempting to export reports to e-mail, the following error ...

    • WebTrends server error ID: 100 on Scheduled Export

      For products: Webtrends On Demand Webtrends Analytics 9.2x Webtrends Analytics 8.x Last modified: 5/4/2011 Situation: This error will sometimes occur when performing a scheduled export and the text of the email will include this error number as well ...

    • Scheduled export fails and returns WebTrends server error ID: 98

      For products: Webtrends Analytics 9.2x Webtrends Analytics 8.x Last modified: 7/27/2010 Situation: A notification is received containing the following error message: Your WebTrends scheduled report could not be generated. The below error occurred ...

    • What are valid values for the Webtrends media parameters?

      Products Webtrends On Demand Webtrends Analytics 8.7 Webtrends Analytics 8.0x Webtrends Analytics 8.1 Webtrends Analytics 8.5 Webtrends Analytics 8.7 Webtrends Analytics 9.2 Introduction As of Webtrends Analytics 8.7d, Webtrends no longer supports ...