Using the JDBCProbe script include to execute a command against a database produces an output ecc_queue record with a missing agent correlator which leads to NullPointerExceptions in the response ecc_queue record.

Steps to Reproduce

  1. Set up a Microsoft SQL Server database and a table that you can access using a JDBC data source.
  2. Set up a MID server that has access to connect to the SQL Server database.
  3. In an instance, create a data source with the SQL Server information.
  4. Create a script to insert a record into the SQL Server database.
  5. Run the script.


Change the JDBCProbe script include to set the agent_correlator:

  1. Edit the JDBCProbe script include.
  2. In the Script field, look for the method create().
  3. Add the line egr.agent_correlator = gs.generateGUID();

Change from:

var egr = new GlideRecord("ecc_queue");
egr.agent = "mid.server." + this.midServer;


var egr = new GlideRecord("ecc_queue");
egr.agent_correlator = gs.generateGUID();
egr.agent = "mid.server." + this.midServer;

Related Problem: PRB664013

Seen In

Fuji Patch 11
Geneva Patch 1
Geneva Patch 3
Geneva Patch 4
Geneva Patch 4 Hot Fix 2
Geneva Patch 5
Geneva Patch 5 Hot Fix 4
Geneva Patch 6
Geneva Patch 6 Hot Fix 4
Geneva Patch 7
Helsinki Patch 1
Helsinki Patch 2
Helsinki Patch 3

Fixed In


Associated Community Threads

There is no data to report.

Article Information

Last Updated:2017-07-24 08:39:03