ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Jaspersoft Studio Timestamp Error (DE63073)

book

Article ID: 227316

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise STARTER PACK-CLARITY PPM

Issue/Introduction

When running a query in Jaspersoft with dates it throws an error and claims there is a NullPointerException for the timestamp

Jaspersoft JDBC Adapter throws NullPointerException on dates

STEPS TO REPRODUCE

  1. Set up Jaspersoft Studio with Postgres GCP in SAAS
  2. Use the steps below to connect to the database: Preview Data with the DataAdapter
  3. Connect to the database and query any date field, i.e.
  4. select schedule_start from inv_investments

Expected Results: The date to be returned correctly

Actual Results: Error thrown: java.lang.NullPointerException Unable to get value for result set field "schedule_start" of class java.sql.Timestamp

Environment

Clarity release 16.0 and Jaspersoft studio 7.9

Resolution

This was raised as product defect DE63073, currently in review by Engineering