No announcement yet.

Web Reporting Collation Conflict

  • Filter
  • Time
  • Show
Clear All
new posts

  • Web Reporting Collation Conflict

    Web Reporting Collation Conflict

    Rev: 1.5
    Date: 12/15/2010


    When attempting to run Web Reporting after installation you may receive the following or similar error after login:

    Microsoft OLE DB Provider for SQL Server error '80040e14'

    Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.

    /WebReportingforUMP/sql.asp, line 74

    The installation routine through version 2.53 of Web Reporting for User Manager Pro defined a collation value for the columns it was creating in its tables in the User Manager Pro reporting data store. If the collation of the database did not match the collation that was set on the columns used by web reporting, the web pages would generate an error.


    To address the problem, download, extract, and run the SQL script found here:

    It will be necessary to use SQL Enterprise Manager or SQL Management Studio to run the script.
    1. Open SQL Enterprise Manager or SQL Management Studio as a user with the rights to modify the tables in the User Manager Pro Reporting data store.
    2. Determine the collation used by the User Manager Pro reporting data store. Open the properties of the database and examine the options section. The collation type should be defined here. Note this information exactly as it appears here.
    3. Create a new query using the provided SQL script.
    4. Ensure the connected database is the User Manager Pro reporting data store.
    5. In the script there are numerous lines that end with TABLE_COLLATION_VALUE_GOES_HERE. Replace that value with the collation value found in the previous steps.
    6. Execute the script. If errors are encountered, the script may be re-run as many times as necessary without ill effect.
    7. Web reporting should now work as expected.

    This problem will be addressed properly during installation in a forthcoming version.

    Applies To:

    Web Reporting 2.x

    1875 Century Park East, Suite 1200
    Los Angeles, CA 90067
    Main: (800) 829-6263
    International: +1 (310) 550-8575
    Fax: (310) 550-1152