Clarity Service Management

Expand all | Collapse all

UUID in JasperReports server

  • 1.  UUID in JasperReports server

    Posted 02-07-2017 07:19 AM

    I'm working with JasperReports Server to fetch info of CA SAM and APM to define dashboards.

    The challenge I see here is that no UUID is accessible in the Domain Designer.

    Can't create Joins with other tables without UUIDs.

     

    Anyone having any experience with this?



  • 2.  Re: UUID in JasperReports server

    Posted 02-07-2017 08:26 AM

    Hi Sahil,

     

    Please see a similar thread which should answer query:

     

    https://communities.ca.com/message/241913064

     

    Kind Regards,

    Brian



  • 3.  Re: UUID in JasperReports server

    Posted 02-07-2017 08:52 AM

    Hi Sahil,

    Unfortunately currently we do not support domains in Jasper as we do not currently ship one.  There may be some folks out there that gotten this to work, but unfortunately CA Support is not able to assist in this area.

     

    Can anyone else out there help Sahil out?

    Regards,

    Jon I.



  • 4.  Re: UUID in JasperReports server

    Posted 02-08-2017 05:25 AM

    Hi John/Brian,

     

    I'm already using the Domains/adHoc Views and they are working.

    The only challenge I see here is getting the UUID which is a binary data type from SQL Server which I believe is the issue with the JDBC Drivers.

     

    I hope CA will be able to provide a workaround to this.

     

    Thanks,

    Sahil



  • 5.  Re: UUID in JasperReports server

    Posted 02-09-2017 03:33 AM

    Open this file in a text-editor.The path is mentioned in the snapshot.

    Add a new entry

    <entry key="binary" value="java.lang.String"/>

     

    Add another entry

    <entry key="BINARY" value="java.lang.String"/>

     

    Save the file and restart the Apache Tomcat Service.

    Create a new domain and now you will be able to see the UUID fields.

     

     

    Cheers,

    Sahil



  • 6.  Re: UUID in JasperReports server

    Posted 02-10-2017 09:33 AM

    thank to have share this

    very usefull!



  • 7.  Re: UUID in JasperReports server

    Posted 04-06-2018 04:42 PM

    Thank you very much. This solved the problem here as well.