Query using JDBC Probe

Woz
Tera Contributor

Hello,

execute the following 
1) use JDBC prob to query DB
2) based on response update records on same DB using JDBC prob

At the moment we have failed on step one. We have followed this article to create a record to query DB in ECC_queue https://john-james-andersen.com/blog/service-now/using-the-servicenow-jdbcprobe.html

Everything looks normal until we get to the below - this record never moves from "Ready" and we never get the "JDBCProbeResult" record

Woz_0-1685957009298.png

What is also odd is we do not see any errors in the system logs or on the MID itself?


1 REPLY 1

Rahul Priyadars
Giga Sage
Giga Sage

If I understood Correctly 

Step 1 - is to query the outside DB and get results

So ECC queue value should be - Output first so that Mid Server Processes it.

Also use a small code snippet to just test the connectivity first.

Regards

RP