UUID in JasperReports server

[sahilk]

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?

[Legacy User]

Hi Sahil,

 

Please see a similar thread which should answer query:

 

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

 

Kind Regards,

Brian

[Jon_Israel]

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.

[sahilk]

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

[sahilk]

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

[JEROME MAYER]

thank to have share this

very usefull!

[MarcosStrapa]

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

[JAN POKORNY]

How to settings UUID for Jasper 9? 

[Mounika Prasad Kombathula]

Hi Jan,

In Jasper 9.0.0, you would need to edit the applicationContext-jdbc-metadata.xml and add the (below) new entry under jdbcMetaConfiguration bean-

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

Save the file and restart the Jasper service from services console.

Regards,

Mounika.