search cancel

Issues setting up and running reports from the Siteminer adminUI


Article ID: 106072


Updated On:


CA Single Sign On Secure Proxy Server (SiteMinder) CA Single Sign On SOA Security Manager (SiteMinder) CA Single Sign-On


When trying to run any report in the AdminUI we are receiving the following error: Failed to execute ReportingInstanceEvent. ERROR MESSAGE: SmApiWrappedException:Column 'RPT_INSTANCE_ID' cannot accept a NULL value.

We also receive the following in the AdminUI server.log:
2018-05-15 15:54:34,781 ERROR [com.crystaldecisions.sdk.occa.infostore.internal.InternalInfoStore] (Thread-219) commitHelper(): failed: com.crystaldecisions.sdk.exception.SDKException$ContradictingValues: The property SI_ENDTIME has a value Wed Jan 31 10:26:54 EST 2018 that contradicts with property SI_STARTTIME of value Tue May 15 14:54:34 EDT 2018.  Resolve the contradiction.


Confirmed for 12.52 SP2 Policy Server, and Oracle Database on CABI 4.1 SP3


The start date of the reports were set in the future, causing problems generating 


Go to each of the the Reports in the Report Server Admin UI, and change the default settings to recurrence once, and set the end date to the future (ex: December 2100).