Loading data from Oracle JDBC data source via MID server fails with null pointer exception while querying table that contains column of type "timestamp" with null values.

Steps to Reproduce


  1. Set up an Oracle JDBC data source via MID server with query field of type Specific SQL and an SQL Statement with the value 'select * from <table>'. Ensure that the table has a column of type 'timestamp' with null values. If you are using an Oracle database set up for a ServiceNow instance, update the attached XML with Oracle config to create the datasource.

  2. Select Load all records.

  3. After few seconds, it reports with an error.

    MID Server reported error: java.lang.NullPointerException
    at java.util.Calendar.setTime(
    at java.text.SimpleDateFormat.format(
    at java.text.SimpleDateFormat.format(
    at java.text.DateFormat.format(
    at com.service_now.mid.probe.JDBCProbe.doSelect(
    at com.service_now.mid.probe.JDBCProbe.doQuery(
    at com.service_now.mid.probe.JDBCProbe.probe(
    at com.service_now.mid.probe.AProbe.process(
    at com.service_now.mid.queue_worker.AWorker.runWorker(
    at java.util.concurrent.ThreadPoolExecutor.runWorker(
    at java.util.concurrent.ThreadPoolExecutor$




This issue is under review. To receive notifications when more information is available, subscribe to this Known Error article by clicking the Subscribe button at the top right of the article. If you are able to upgrade, review the Fixed In field to determine whether any versions have a permanent fix.


Related Problem: PRB1032318

Seen In

There is no data to report.

Fixed In

Jakarta Patch 2 Hot Fix 1
Jakarta Patch 3

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-05-21 11:35:04