000032532 - An exception occurred in RSA Archer 5.x using the column filters due to SiteMinder configuration in Manage Users or Master Reports Listings page

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 10Show Document
  • View in full screen mode

Article Content

Article Number000032532
Applies ToRSA Product Set: Archer

RSA Version/Condition: 5.x and higher

Platform: Windows
IssueFrom Manage Users or Master Reports Listings page, an exception occurred using the column filters.  
Two sample error messages:
Exception Occurred: Load operation failed for query 'GetMasterReports'.
Warning: Load operation failed for query 'GetUserEntityList'.
User-added image
User-added image
CauseThis occurs due to SiteMinder configuration.  SiteMinder allows you to list a set of character sequences that cannot be part of a URL request or CSS. 
In SiteMinder's authentication log report, the following may be logged or something similar:

URL contains BadCssChars.
URL contains invalid characters. Exiting with HTTP 500 server error '00-0002'.

For information on configuring SiteMinder check out Specify Bad URL Characters or Override the Default CSS Character Set.
  1. Enable SiteMinder information logging to determine the characters it does not like.
  2. Reproduce the issue.
  3. Check SiteMinder's authentication log report to determine if there is a bad URL or CSS character.
  4. Update the SiteMinder agent's configuration file for blacklisted characters and remove the one found in step 3.
  5. Confirm the issue no longer occurs.
The following is a snippet from a SiteMinder agent configuration.  
NOTE: your values may be different depending on your policies.
BadCssChars = <,>,;,',%22,(,),%00,%04,%08,%0A,%1B 
BadUrlChars = \,//,./,/.,/*,*.,~,%,%00-%1f,%7f-%ff,%