Maximo

Maximo

Come for answers, stay for best practices. All we're missing is you.

 View Only
Back to discussions
Expand all | Collapse all

BIRT 4.8 Setup with MAS 8.10

  • 1.  BIRT 4.8 Setup with MAS 8.10

    Posted 10/26/23 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 10/27/23 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 10/30/23 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
    ------------------------------

    Original Message


  • 4.  RE: BIRT 4.8 Setup with MAS 8.10

    Posted 10/31/23 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
    ------------------------------

    Original Message


  • 5.  RE: BIRT 4.8 Setup with MAS 8.10

    Posted 12/12/23 04:49 AM

    Hi Bradley,

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



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

    Original Message


  • 6.  RE: BIRT 4.8 Setup with MAS 8.10

    Posted 12/08/23 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 12/11/23 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 12/12/23 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
    ------------------------------

    Original Message


  • 9.  RE: BIRT 4.8 Setup with MAS 8.10

    Posted 12/12/23 10:23 AM

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



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

    Original Message


  • 10.  RE: BIRT 4.8 Setup with MAS 8.10

    Posted 07/14/25 09:42 AM

    Andrew and Ansel.... I am facing the same issue but the links are not working. Please share if you have working link

    https://ibm.box.com/shared/static/90x18iqoahrhq4z5z7pkvp721v148ng2.zip.

     https://www.ibm.com/support/pages/setting-eclipse-48-maximo-application-suite-8x-maximo-asset-management-7612-7613. 



    ------------------------------
    chetan arer
    ------------------------------

    Original Message


Related Content