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?
Please see a similar thread which should answer query:
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?
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.
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.
thank to have share this
Thank you very much. This solved the problem here as well.