I am struggling with Jusper Report during Domain creation (using Domain Designer).
Everything works fine:
- Type: JDBC Data Source;
- JDBC Driver: com.ddtek.jdbc.openaccess.OpenAccessDriver
2. New Domain created using Domain Designer
- table casd_cr choosed
- fileds from casd_cr choosed – like ref_num; status; customer_organization_name, etc…
But, if I want to create pre-filter (in domain designer) based on customer_organization_name, OR fields with combo_name, I got error message.
com.jaspersoft.commons.dataset.DataSetException: Exception calling JRDataSource.next() for query select top 2147483647 "casd_cr"."assignee_organization_name" as "casd_cr_assignee_organization_name" from "casd"."cr" "casd_cr" group by "casd_cr"."assignee_organization_name" order by "casd_cr_assignee_organization_name"
… Caused by: java.sql.SQLException: [DataDirect][OpenAccess SDK JDBC Driver][OpenAccess SDK SQL Engine]AHD12008:Attribute casd_cr_customer_organization_name referenced by Majic SQL query not found in object(s) cr at casd_cr_customer_organization_name…
(whole error message attached in txt file)
The same result I got, if I try to use this field for filtering on Ad Hoc View.
Which version of SDM is being used here? We started supporting only one out of the box domain (Incident Management) in 17.1 release. We were not supporting domains prior to this release.
Hi....SDM 17.0 and Jasper reports 6.3.0
Yea, unfortunately, we do not have support for domains in that release yet. With 17.1 we provide one domain, which might give some clues in creating custom ones
Hi, I updated to SDM 17.1 and Jasper 6.4.3.
Where can I find the provided domain? OOB I do not see a sigle different :/
The Incident Management Domain is part of our Insights module of xFlow Analyst interface.
Configure Insights - CA Service Management - 17.1 - CA Technologies Documentation and FAQs About Insights - CA Service Management - 17.1 - CA Technologies Documentation
Take a look at these two videos for a quick overview: CA Service Management 17.1 Release Notes - CA Service Management - 17.1 - CA Technologies Documentation