To create a Data Adapter after installing Jasper Studio one must do the following:
Thanks for sharing this tip with the community Steve!
Jasper Studio - Create Data Adapter for SDM
Many thanks from me also, this was a godsend. I did spend one day trying to get the connection working.
This should be covered in CA documentation.
I've created the Data Adapter for Service Desk in Jasper Studio as you described. However, when I try to create a new report using this Data Adapter, this error happens:
Is this a known issue? Do you know what may be causing this?
Do you have Service Desk 14.1.03 patch installed on the SDM node to which you are connecting to?
No, it's 14.1.02. Isn't it compatible? Thought 14.1.03 was only for xFlow.
You would need the service desk portion of the patch that is in 14.1.03 You don't have to implement xflow but the Binaries for 14.1.03 give you the needed support for this.
Just installed patch 03 for 14.1, but the error for Data Adapter is still happening. Do you think I need to create a support ticket for this?
Hi Diogo, When you say that the error for Data Adapter is still happening - can you elaborate on specifically what the error is, and where you are seeing it? Maybe a screenshot would help a bit as well?
Also can you tell us if you are following the instructions to configure Jasper for SDM as documented here: Configure CABI JasperReports® Server r6.2.0 for CA Service Management - CA Service Management - 14.1 - CA Technologies D…
Let us know,
You can see the error on the screenshot above (my first comment). This happens when I try to create a New Report using the Data Adapter I've just created (following the steps here). When I drag any table, the following error appears on upper part of the window:
[DataDirect][OpenAccess SDK JDBC Driver][OpenAccess SDK SQL Engine]AHD12008:O atributo OA_DEFERRABILITY mencionado pela consulta Majic SQL não foi encontrado no(s) objeto(s) OA_FKEYS at OA_DEFERRABILITY ... AS
Which means: "OA_DEFERRABILITY attribute mentioned by Majic SQL query was not found in objects OA_FKEYS at OA_DEFERRABILITY ... AS"...
Diogo, You should not need to create a new data adapter to create a new report in Jasper Studio. You should be connecting jasper studio to your jasper server where the data source is already configured, and then creating a report based on that data source. I dont think that Jasper Studio has the correct custom driver to connect to the Service Desk object layer which the one delivered with Jasper Server does.
SteveTroy would you be able to offer any in sight as to how best to go about generating new reports in jasper studio by connecting to the sdm_ds data source rather than attempting to create a new data adapter? Unfortunately this is not documented anywhere at the moment.
The JDBC driver you use is not present in my JDBC driver list.
Do you have any idea why?
I have tried solving this issue myself but to no avail so far.
OA_DEFERRABILITY attribute mentioned by Majic SQL query was not found in objects OA_FKEYS at OA_DEFERRABILITY ... AS"... typically means that you are not running the correct odjc driver on the SDM server.
Are you sure you are running version 72 of the ODBC Driver? Please check and let me know. I've worked on numerous cases were the driver was 60 and not 72.
The little square blocks that we're seeing next to table/column names seem to indicate that we have OAserver 6.x release on server side? Is this an SDM upgrade from 12.x by any chance?
Thanks for your response. About the ODBC Driver, I'm afraid I can't say about the version. How can I check (and correct, fi wrong)?
About SDM, yes, it's an upgrade from 12.7 version. Is there any issue regarding it?
checkout this thread, upgrading server side ODBC should help out resolve this issue I think.
It worked like a charm! Thanks a lot.
Also, was this done
If you installed Jasper Studio on a standalone server (highly recommended) you will need to copy oajc.jar from the server that hosts Jasper Report Server to the server that is hosting Jasper Studio. That is noted in the instructions above.
Yeah, I did copy the oajc.jar file before creating the Data Adapter.
I've installed Jasper studio pro 6.3.0 .
When I tried to create data source, there is no JDBC driver as per guide. Please help.
The driver you need is not listed in the drop down menu. You have to manually type
in the JDBC Driver text box.
I've successfully create the data adapter.
I've got the same error as diogo.nobrega when try to create new report from the data adapter.
I'll try to apply patch 14.1.03 and see what the result.
Jasper requires 14.1.03 to be applied. It is not certified for use on anything lower than 14.1.03.
There are files that the CP3 patch delivers that are required for Jasper to function properly.
Let us know if you still have the issue after CP3 is applied.