Maximo

 View Only
Expand all | Collapse all

BIRT 4.8 Setup with MAS 8.10

  • 1.  BIRT 4.8 Setup with MAS 8.10

    Posted Thu October 26, 2023 12:23 PM

    Hello everyone,

    I have Maximo 7.6.1.2, which is linked to a BIRT report.viewer_4.3.1.v201309171028. However, I'm currently in the process of upgrading to MAS 8.10 and attempting to use BIRT report.viewer_4.8.0.v201806261756. Unfortunately, I'm encountering some issues with this new setup.

    I've followed the necessary steps according to IBM's documentation for setting up BIRT with Manage, but I'm getting a null pointer when running custom reports from 7.6.1.2. I fetched all the Libraries and Templates using OpenShift as specified in the document.

    Even when I attempted to create a new report using the template, I still ran into the same issue.

    I've even tried linking my new setup to the 7.6.1.2 database, but the problem persists.

    Here's an extract of the error message that I'm receiving. I get this after providing the parameters:

    -----
    A BIRT exception occurred. See next exception for more information.
    Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: java.lang.NullPointerException (/report/data-sets/script-data-set[@id="5"]/method[@name="open"]#2).

    I would greatly appreciate any insights or assistance. Has anyone else attempted to use BIRT 4.8 with Maximo 8.10 and encountered similar issues?

    Thank you for your time.



    ------------------------------
    Ansel Gonsalves
    ------------------------------


  • 2.  RE: BIRT 4.8 Setup with MAS 8.10

    Posted Fri October 27, 2023 10:46 AM

    Hi Ansel!

    Hope this finds you well.... The null pointer exception is coming form the Open method which (without more info) seems to indicate a null connection to your DB.  This might indicate the embedded library connection is pointing to the incorrect DB.  I am confused by some of the words above. Are you taking your custom reports directly into MAS8.10?  Did you try to run them in a BIRT instance prior to importing into MAS Manage? Do you have access to OpenShift or are you running in SaaS and working through a Managed Service provider?  Is this experience in MAS Manage or Running from BIRT developer?  Trying to get a sense of where you are exactly.



    ------------------------------
    Bradley K. Downing , MBA
    Senior Brand Technical Specialist
    IBM
    Bakersfield CA
    ------------------------------



  • 3.  RE: BIRT 4.8 Setup with MAS 8.10

    Posted Mon October 30, 2023 02:01 AM

    Hi Bradley,

    Thanks for your reply, and my apologies for the delayed response.

    To clarify a few things, I am getting this exception when previewing the report on Birt 4.8. Somehow, I was under the impression that I would need to load the custom reports I made for 7.6.1.2 using Birt 4.3 to Birt 4.8 only then it would work on Manage. After raising a ticket with IBM regarding the same, they said the reports should work directly.

    The reports are loading on Manage, and since it is time-critical for me, I will proceed using Birt 4.3 (connected to the 7.6.1.2 database) and look into the installation issues I'm facing for 4.8 at a later stage. We have a MNO deployed on Azure with control of Openshift, so we pulled the library files directly from the MAXINST pod as advised in the documents. We are running the database on a SQL-managed instance.



    ------------------------------
    Ansel Gonsalves
    ------------------------------



  • 4.  RE: BIRT 4.8 Setup with MAS 8.10

    Posted Tue October 31, 2023 04:24 PM

    Hi Ansel,

    Hey no worries on response time. were you able to generate log file in BIRT 4.8 (Eclipse)?  If so that will help diagnose problem.  Also in your mxreportdatasources.properties file you have set the correct JDBC url yes?  Be VERY sure of this value.  There are TWO valid URLs. One internal and one external. You need to be sure you are a) using the external one, b) using the correct values for the credentials and c) that you have access through your firewalls to the JDBC URL of the DB. If you have a log file and can send it, DM me or post here whichever you prefer.



    ------------------------------
    Bradley K. Downing , MBA
    Senior Brand Technical Specialist
    IBM
    Bakersfield CA
    ------------------------------



  • 5.  RE: BIRT 4.8 Setup with MAS 8.10

    Posted Tue December 12, 2023 04:49 AM

    Hi Bradley,

    Thank you for helping out in this case. The solution from Andrew in the thread worked.



    ------------------------------
    Ansel Gonsalves
    ------------------------------



  • 6.  RE: BIRT 4.8 Setup with MAS 8.10

    Posted Fri December 08, 2023 11:59 AM

    Hi Ansel,

    I faced similar issue while setting up BIRT 4.8, the difference is the fetch method.

    A BIRT exception occurred. See next exception for more information.
    Wrapped com.ibm.tivoli.maximo.report.script.MXReportRuntimeException: java.lang.NullPointerException (/report/data-sets/script-data-set[@id="5"]/method[@name="fetch"]#7)
       at org.eclipse.birt.data.engine.script.JSMethodRunner.runScript(JSMethodRunner.java:147)
       at org.eclipse.birt.report.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptExecutor.java:90)

    Analysing the log file, it has given me the following in the log.

    ERROR  getString(prnum) failed.
    java.lang.NullPointerException
        at com.ibm.tivoli.maximo.report.script.MXReportDataSetImpl.removeFewEmojis(MXReportDataSetImpl.java:2218)
        at com.ibm.tivoli.maximo.report.script.MXReportDataSetImpl.getString(MXReportDataSetImpl.java:444)

    Changing getString() to getInteger() really worked. None of the getString("ATTRIBUTE") in the fetch method is working.

    Appreciate any support.

    Thanks,



    ------------------------------
    PRABHU THOLKAPPIAN
    ------------------------------



  • 7.  RE: BIRT 4.8 Setup with MAS 8.10
    Best Answer

    Posted Mon December 11, 2023 10:03 AM

    Hi Ansel,

    I also faced a similar issue. the resolution for me was to use the scripts from https://www.ibm.com/support/pages/setting-eclipse-48-maximo-application-suite-8x-maximo-asset-management-7612-7613. The direct link is to the file zip is https://ibm.box.com/shared/static/90x18iqoahrhq4z5z7pkvp721v148ng2.zip.

    I used the script library from the ZIP instead of copying it from the Maximo installation. 



    ------------------------------
    Andrew Tess
    ------------------------------



  • 8.  RE: BIRT 4.8 Setup with MAS 8.10

    Posted Tue December 12, 2023 04:46 AM

    Hi Andrew,

    This worked. Thanks a lot. All I did was replace the script library files that I had extracted from Manage. 

    Thank you for your time.



    ------------------------------
    Ansel Gonsalves
    ------------------------------



  • 9.  RE: BIRT 4.8 Setup with MAS 8.10

    Posted Tue December 12, 2023 10:23 AM

    Glad it helped. hope fully it saved you the day it took me to find this almost by accident.



    ------------------------------
    Andrew Tess
    ------------------------------