Thank you for helping out in this case. The solution from Andrew in the thread worked.
Original Message:
Sent: Tue October 31, 2023 04:24 PM
From: Bradley Downing
Subject: BIRT 4.8 Setup with MAS 8.10
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:
Sent: Mon October 30, 2023 02:00 AM
From: Ansel Gonsalves
Subject: BIRT 4.8 Setup with MAS 8.10
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:
Sent: Fri October 27, 2023 10:46 AM
From: Bradley Downing
Subject: BIRT 4.8 Setup with MAS 8.10
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
Original Message:
Sent: Thu October 26, 2023 02:38 AM
From: Ansel Gonsalves
Subject: BIRT 4.8 Setup with MAS 8.10
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
------------------------------