KBA45017: Error converting varchar to datetime while exporting licensecompliance table

Knowledge Base Article	45017
Applicable Versions	Report Manager | N-compass 3.2
Date Created/Updated	November 6, 2012

Overview

During export an error where a varchar is converted to a datetime while exporting the licensecompliance table.

Explanation

To fix this, you need to modify the collation of the existing ODS.

1. On the Report Manager server, open Microsoft SQL Server Management Studio.
2. In the left pane, expand Databases.
3. Right-click the ODS database for the customer and click Properties.
4. In the left pane of the properties dialog, click Options.
5. In the Collation drop-down, select Latin1_General_CI_AS.

   

6. Click OK.