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 , 

     

    Server.log

    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:

     

    https://docops.ca.com/ca-single-sign-on/12-52-sp1/en/release-notes/cumulative-releases/defects-fixed-in-12-52-sp1-cr01

     

    Policy Server Displays Java.Sql Error (55835)

    Symptom:

     

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

     

    Regards,
    Leo Joseph.