Report Instance Was Not Successfully Created

Document ID : KB000041054
Last Modified Date : 14/02/2018
Show Technical Document Details

Problem:

Audit Reports do not run, but the Analysis reports handle without issue.

The following error is generated in the adminui:

"Failed to execute ReportingInstanceEvent. ERROR MESSAGE: Exception:Report instance was not successfully created. Please see the application server logs and the report server."

 

Environment:  

AdminUI O/S: ALL

Report Server O/S: ALL

Audit Store: SQL Server(All versions)

 

Cause: 

The collation sequence is set to a case sensitive sequence.

 

Resolution:

Changing to a case-insensitive collation sequence will fix this problem.

In SQL Server, this can be done in the Maintenance section of the General tab, the database Collation name type should be set to a case insensitive collation

( Example: "SQL_Latin_General_CP1_CI_AS")

The "CI" in the example above stands for "Case Insensitive"