Cannot invoke "java.sql.ResultSet.next()" because "rs" is null

Products

• CA Service Management - Service Desk Manager
• CA Service Desk Manager

Issue/Introduction

The following error occurs when clicking on DataSet and Query Dialog in JasperStudio and selecting the SDM datasource:

java.lang.NullPointerException: Cannot invoke "java.sql.ResultSet.next()" because "rs" is null

at com.jaspersoft.studio.data.sql.ui.metadata.MetaDataUtil.readForeignKeys(MetaDataUtil.java:236)

 

The issue is random and disappears when clicking on "Read Fields" again sometime later.

No error logged in SDM logs when the issue occurs.

Environment

Service Desk Manager 17.4 RU 3 and above

JasperStudio 9.0

Cause

Issue with JasperStudio 9.0

Resolution

As of now (December 2025), Broadcom Engineering team is working on this with the Tibco Engineering team. At this moment, there is no ETA.

To workaround it in the meantime, as the issue comes only when we edit a report in JasperStudio, you can try to add the report query during the new report creation itself. When editing the same report, you might see an issue, but can ignore it, as there is no functionality loss.