Solution to Web Reports does not load UI after login attempt

Usage and Config Platform
1

Web Reports does not load UI after login attempt

Cause: Database collation may be set to a case sensitive collation: SQL_Latin1_General_CP1_CS_AS

Solution: Change the database collation to be case insensitive: SQL_Latin1_General_CP1_CI_AS

See the following KB article:

http://www-01.ibm.com/support/docview.wss?uid=swg21970383

1 Like
2

Thanks @BigFixNinja Can you please mention the version of Web Reports?

1 Like
3

At the time I documented this, the BigFix server had the following configuration:

BigFix Server Version: 9.2.5.130
Server OS: Windows Server 2012 R2
SQL Server: 2008 R2 Standard

However, I do not believe the problem is constraint to server/database platform or application version. The problem seems to be with the way the SQL server was configured and during re-installation/upgrading of the server components the re-created Web Reports database was created and inherited SQL_Latin1_General_CP1_CS_AS from how the SQL server instance was configured.

2 Likes