CA Service Management

 View Only
Expand all | Collapse all

Jasper Studio Data Adapter (JRS 7.1.x)

Juan Manuel Martinez Osorio

Juan Manuel Martinez OsorioNov 28, 2019 01:10 PM

  • 1.  Jasper Studio Data Adapter (JRS 7.1.x)

    Posted Sep 30, 2019 08:38 AM
    Hello,

      I've installed a new SDM/CABI system (17.2 C2 and CABI using JRS 7.1.1) and I'm trying to use the TIBCO Jasper Studio to design a report.
    In previous versions, I've been using the com.ddtek.jdbc.openaccess.OpenAccessDriver JDBC driver to define a Data Adapter, but in this new version I see the JDBC url is different.
     
     I've been trying to mimic the sdm_ds datasource present in JRS, using the com.ca.sdm.dal.sql.jdbc.driver.DalJdbcDriver as JDBC driver, but no matter what I add in the JDBC URL, the Studio dialog just hangs when I press the Test button.

     What's the correct syntax to add a Data Adapter for the new versions ?


  • 2.  RE: Jasper Studio Data Adapter (JRS 7.1.x)

    Broadcom Employee
    Posted Sep 30, 2019 02:43 PM
    Cristi..........

    What version of Jasper Studio are you using with JasperSoft Server 7.1.1?

    ------------------------------
    Paul Coccimiglio
    Principal Support Engineer
    Broadcom Inc.
    ------------------------------



  • 3.  RE: Jasper Studio Data Adapter (JRS 7.1.x)

    Posted Oct 01, 2019 04:08 AM
    I'm using JasperSoft Studio 7.1.0


  • 4.  RE: Jasper Studio Data Adapter (JRS 7.1.x)

    Posted Nov 04, 2019 11:21 AM
    Any news about this?

    I just see the same. And I don't know in wich library is this driver com.ca.sdm.dal.sql.jdbc.driver.DalJdbcDriver containded...


  • 5.  RE: Jasper Studio Data Adapter (JRS 7.1.x)

    Broadcom Employee
    Posted Nov 04, 2019 01:58 PM
    Hello, 

    Please try the steps noted in the following document:

    https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=10048

    Regards, 
    Pablo

    ------------------------------
    Senior Support Engineer
    ------------------------------



  • 6.  RE: Jasper Studio Data Adapter (JRS 7.1.x)

    Posted Nov 04, 2019 02:20 PM
    Hi Pablo,

    Document refers to oajc.jar and it contains the driver for com.ddtek.jdbc.openaccess.OpenAccessDriver
    but not for com.ca.sdm.dal.sql.jdbc.driver.DalJdbcDriver wich is the new driver delivered with 17.2.

    Regards,
    Carlos


  • 7.  RE: Jasper Studio Data Adapter (JRS 7.1.x)
    Best Answer

    Broadcom Employee
    Posted Nov 05, 2019 11:22 AM
    Hi Carlos,Cristi, 

    We need to involve other teams to answer this question. Can you please submit a ticket so we can involve the other teams?
    Regards, 
    Pablo

    ------------------------------
    Senior Support Engineer
    ------------------------------



  • 8.  RE: Jasper Studio Data Adapter (JRS 7.1.x)

    Posted Nov 28, 2019 01:10 PM


  • 9.  RE: Jasper Studio Data Adapter (JRS 7.1.x)

    Posted Apr 08, 2020 03:04 AM
    Edited by Cristi Mitrana Apr 08, 2020 03:04 AM
    Any updates on this question ?

    I just installed 17.3 and I'm trying to connect - using Jasper Studio - to the SDM data source. 

    I'm trying to follow the same steps as the ones described in http://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/business-management/ca-service-management/17-3/installing/installing-ca-service-management-17-3/installing-common-components-ca-eem-cabi-jasperreports-ca-process-automation/cabi-jasperreports-server-for-ca-service-management/Install-and-Integrate--JasperReports-Server-r7_2-with-CA-Service-Management.html for creating a new Data Adapter in JRS.

    Creating the datasource with com.ca.sdm.dal.sql.jdbc.driver.DalJdbcDriver exhibits the same behavior - Jasper Studio freezes while testing the connection.

    Can we have a feedback on what's the correct syntax to use for Jasper Reports Studio ? Is it even supported ?


  • 10.  RE: Jasper Studio Data Adapter (JRS 7.1.x)

    Posted Sep 15, 2020 03:31 PM
    Same Issue,and apparently nothing to do. Reports 's environment on version 17.3 doesn't work. We had to change all our reports to SQL based queries.

    If anyone have a working environment with CA SDM 17.3 and JasperServer 7.1.1 or 7.2 could you please share your settings/findings.

    Thanks for your help.


  • 11.  RE: Jasper Studio Data Adapter (JRS 7.1.x)

    Posted Sep 16, 2020 07:20 AM
    I hope the following will help to create  SDM Data Adapter in Studio (my version is 7.5)




    ...Michael

    ------------------------------
    Principal Services Consultant
    HCL Enterprise Studio
    Germany
    ------------------------------



  • 12.  RE: Jasper Studio Data Adapter (JRS 7.1.x)

    Posted Sep 21, 2020 04:02 AM
    Hi Michael,
    I had DalDriver configured and it worked fine.
    Since I've upgraded to 17.3.01 and Jasper-Server 7.1.1 (7.1.0 before) it does not work any longer.
    I've already copied the new jar from 17.3.01 iso.

    Now when I'm trying to configure Data Adapter - test shows following error:

    net.sf.jasperreports.engine.JRRuntimeException: java.lang.ClassNotFoundException: com.ca.sdm.dal.sql.jdbc.driver.DalJDBCDriver cannot be found by net.sf.jasperreports_7.3.0.final
    at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.getConnection(JdbcDataAdapterService.java:187)
    at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:131)
    at net.sf.jasperreports.data.AbstractDataAdapterService.test(AbstractDataAdapterService.java:122)
    at com.jaspersoft.studio.data.wizard.AbstractDataAdapterWizard$3.runOperations(AbstractDataAdapterWizard.java:155)
    at com.jaspersoft.studio.utils.jobs.CheckedRunnableWithProgress$1.run(CheckedRunnableWithProgress.java:51)
    at java.lang.Thread.run(Thread.java:748)
    Caused by: java.lang.ClassNotFoundException: com.ca.sdm.dal.sql.jdbc.driver.DalJDBCDriver cannot be found by net.sf.jasperreports_7.3.0.final
    at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:484)
    at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:395)
    at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:387)
    at org.eclipse.osgi.internal.loader.ModuleClassLoader.loadClass(ModuleClassLoader.java:150)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:348)
    at net.sf.jasperreports.engine.util.JRClassLoader.loadClassForRealName(JRClassLoader.java:191)
    at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.getConnection(JdbcDataAdapterService.java:148)
    ... 5 more
    What could be missing in my configuration?

    Regards,
    Peter

    ------------------------------
    Senior Technical Consultant
    Fujitsu Services
    ------------------------------



  • 13.  RE: Jasper Studio Data Adapter (JRS 7.1.x)

    Posted Sep 21, 2020 04:58 AM
    Hi Peter.
    As far as I'm aware, ther are at least 5 jars which might be dependent on each other
    BOPIntegration.jar
    slump.jar
    sd-utils.jar
    bc-fips.1.0.1.jar
    log4j....jar
    domsrvr-util.jar

    So, if you think you need to substitute those, do all or none.
    Well, I think, the documented procedure is to copy these jars from the CABI DVD.
    However ,I had some trouble with those as well.
    Don't forget to restart your jasper report server service, after replacing any jar.
    The dal- driver class itself is included in the BOPIntegration.jar.
    If you get a class not found, you might have copied the jars to a wrong place.
    Hope that helps somehow. If not, broadcom support should be able to help further.
    Best regards
    ....Michael

    Holen Sie sich Outlook für Android






  • 14.  RE: Jasper Studio Data Adapter (JRS 7.1.x)

    Posted Sep 21, 2020 05:06 AM
    Hi Michael,
    on Server itself it's all running fine with those jars copied from iso.
    The problem is in studio ...
    The path seems to be correct and I tried a shorter path as well and added the jars from there.
    It does not work.

    Regards,
    Peter

    ------------------------------
    Senior Technical Consultant
    Fujitsu Services
    ------------------------------



  • 15.  RE: Jasper Studio Data Adapter (JRS 7.1.x)

    Posted Sep 21, 2020 05:24 AM
    Hi Peter .
    Sure , I would recreate the jar path config in Studio when changing the jars underneath.
    If that doesn't help as well, as said, contact support.
    Regards
    ....Michael

    Holen Sie sich Outlook für Android






  • 16.  RE: Jasper Studio Data Adapter (JRS 7.1.x)

    Posted Sep 21, 2020 05:57 AM
    Hi Michael,
    the 'not found'-Error was selfmade problem (case-sensitive).
    Now that I wrote JDBC-Driver-Name correct it is found but hangs/freezes. Studio must be killed by taskmanager.

    Recreation does not help.
    I think I'll open a case together wit customer.
    Great ....

    Regards,
    Peter

    ------------------------------
    Senior Technical Consultant
    Fujitsu Services
    ------------------------------



  • 17.  RE: Jasper Studio Data Adapter (JRS 7.1.x)

    Posted Sep 21, 2020 06:05 AM
    Yes, great, but as always, hopefully not only helpful for you and your customer....
    Btw. I am using Studio 7.5 ,never observed such freezes..
    BR
    ...Michael

    Holen Sie sich Outlook für Android






  • 18.  RE: Jasper Studio Data Adapter (JRS 7.1.x)

    Broadcom Employee
    Posted Sep 25, 2020 11:53 AM
    Edited by Stephanie Maehr Sep 25, 2020 12:01 PM

    I had a similar issue on my remote machine (SDM 17.3 and Jasper Studio 7.5 or 7.8).

    Armin L. pointed me to two additional jars
    - domsrvr_utils.jar 
    - bcprov-jdk15on-1.52.jar

    Once added in my Drivers classpath (and my local hostname to the DAL_whitelist in SDM Options Manager) I was able to connect .. 




  • 19.  RE: Jasper Studio Data Adapter (JRS 7.1.x)

    Posted Sep 28, 2020 01:25 AM
    Hi Stephanie,
    I already talked with Armin about it and he told me the same.
    Thanks for your answer.
    But my problem is - where to get bcprov-jdk15on-1.52.jar from?
    Seems to be a jar delivered with Studio 7.5

    At the moment I can't find a short way to get Studio 7.5 and have a CASE open for this problem.

    I'm hoping for a solution by support.

    Many thanks,
    Peter


    ------------------------------
    Senior Technical Consultant
    Fujitsu Services
    ------------------------------



  • 20.  RE: Jasper Studio Data Adapter (JRS 7.1.x)

    Posted Sep 28, 2020 03:12 AM
    Hi Stephanie,
    taking bcprov-jdk15on-1.52.jar from a old CABI-Installation,
    Michael gave the tipp where to find it,
    and adding log4j-1-2-16.jar (log4j-1-2-17.jar  I could not find)
    Studio 7.3.0 is now running. 

    Thanks to all (Stephanie, Michael, Armin) who helped to find this WorkAround.

    Regards,
    Peter



    ------------------------------
    Senior Technical Consultant
    Fujitsu Services
    ------------------------------