Loading data using Oracle JDBC data source via MID server fails with NPE while querying table that contains column of type timestamp with null values - Known Error

Loading data using Oracle JDBC data source via MID server fails with NPE while querying table that contains column of type timestamp with null values Description 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

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 '. 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.

Select Load all records.

After few seconds, it reports with an error.

MID Server reported error: java.lang.NullPointerException at java.util.Calendar.setTime(Calendar.java:1770) at java.text.SimpleDateFormat.format(SimpleDateFormat.java:943) at java.text.SimpleDateFormat.format(SimpleDateFormat.java:936) at java.text.DateFormat.format(DateFormat.java:345) at com.service_now.monitor.jdbc.JDBCRowSet.next(JDBCRowSet.java:181) at com.service_now.monitor.jdbc.JDBCMultiRowSet.next(JDBCMultiRowSet.java:19) at com.service_now.mid.probe.JDBCProbe.doSelect(JDBCProbe.java:319) at com.service_now.mid.probe.JDBCProbe.doQuery(JDBCProbe.java:198) at com.service_now.mid.probe.JDBCProbe.probe(JDBCProbe.java:123) at com.service_now.mid.probe.AProbe.process(AProbe.java:81) at com.service_now.mid.queue_worker.AWorker.runWorker(AWorker.java:119) at com.service_now.mid.queue_worker.AWorkerThread.run(AWorkerThread.java:20) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745)

Workaround 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.