Symantec Access Management

  • 1.  Reports not getting fetched from admin UI

    Posted 12-26-2017 08:51 AM

    I am unable to extract the following reports from siteminder adminUI in production environment:



    users by role

    resources by user

    roles by application

    applications protected resources

    roles by resource

    users by resource

    policies by role

    applications by user Error :


    Failed to execute ReportingInstanceEvent. ERROR MESSAGE: SmApiWrappedException:Column 'RPT_INSTANCE_ID' cannot accept a NULL value.


    CA report server version : CABI 3.2

    Siteminder version : 12.52

  • 2.  Re: Reports not getting fetched from admin UI

    Posted 12-27-2017 05:17 PM
    • Was this working before ?
    • Are the audit reports working?
    • Did you try runnig these report directly from CABI ?

  • 3.  Re: Reports not getting fetched from admin UI
    Best Answer

    Broadcom Employee
    Posted 12-28-2017 08:27 AM

    Analysis reports are run using in-memory engine within the PS. If this never worked before, please review the PSM for your configuration, making sure all components are in a supported configuration. Please check connectivity between Report Server host and PS/ AdminUI (and, if firewall used, proper firewall ports are open as recommended). Secondly, AdminUI's connection configuration for the Report Server.

    Best, - Vijay

  • 4.  Re: Reports not getting fetched from admin UI

    Posted 01-16-2018 01:38 AM

    Hi , 



    2018-01-16 11:03:06,545 ERROR [com.netegrity.ims.exception.EventExecuteStateException] (Thread-54) Exception:
    java.sql.SQLIntegrityConstraintViolationException: Column 'RPT_INSTANCE_ID' cannot accept a NULL value.


    Defects Fixed in 12.52 SP1 CR01:



    Policy Server Displays Java.Sql Error (55835)



    Policy Server displays java.sql.SQLIntegrityConstraintViolationException error, when you run the Audit and Analysis report due to null value in Column RPT_INSTANCE_ID.


    Leo Joseph.