Receiving error message when tries to connect to MS SQL db via java - using Mirth 4.4.2

[lilianamSF]

Hello,

We need assistance on troubleshooting the error message below. Has anyone seen this error?
Thank you.

ERROR (com.mirth.connect.connectors.jdbc.DatabaseReceiverScript:192): An error occurred while polling for messages, retrying after 10000 ms... java.lang.NullPointerException at com.mirth.connect.connectors.jdbc.DatabaseReceiverScript.poll(DatabaseReceiverScript.java:188) at com.mirth.connect.connectors.jdbc.DatabaseReceiver.poll(DatabaseReceiver.java:140) at com.mirth.connect.donkey.server.channel.PollConnectorJob.execute(PollConnectorJob.java:49) at org.quartz.core.JobRunShell.run(JobRunShell.java:213) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)

[ab-mg-23]

The NPE is likely because your script is returning a null value. The call to result.toString() at line 188 of the below linked code should pop a NPE if that is the case.

connect/server/src/com/mirth/connect/connectors/jdbc/DatabaseReceiverScript.java

Lines 175 to 189 in e0b3a89

	if (result instanceof NativeJavaObject) {
	Object unwrappedResult = ((NativeJavaObject) result).unwrap();
	if (unwrappedResult instanceof ResultSet) {
	finalResult = (ResultSet) unwrappedResult;
	} else if (unwrappedResult instanceof List) {
	finalResult = (List<Map<String, Object>>) unwrappedResult;
	} else {
	throw new DatabaseReceiverException("Unrecognized value returned from script in channel \"" + ChannelController.getInstance().getDeployedChannelById(connector.getChannelId()).getName() + "\", expected ResultSet or List<Map<String, Object>>: " + unwrappedResult.toString());
	}
	done = true;
	} else {
	throw new DatabaseReceiverException("Unrecognized value returned from script in channel \"" + ChannelController.getInstance().getDeployedChannelById(connector.getChannelId()).getName() + "\", expected ResultSet or List<Map<String, Object>>: " + result.toString());
	}