JDBC Flow Designer Step error: MID server issue or something else?

[Community Alums]

When I attempt to test an action with a simple JDBC step using a connection alias (related connection record and the referenced jdbc credential both tested fine), i get this: 

failed with error: com.snc.process_flow.exception.OpException: Error in JDBC step execution. Please check the MID server logs for details.
	at com.snc.process_flow.operation.JdbcOperation.executeOperation(JdbcOperation.java:111)
	at com.snc.process_flow.operation.JdbcOperation.invoke(JdbcOperation.java:65)
	at com.snc.process_flow.operation.RetryableIntegrationOperation.run(RetryableIntegrationOperation.java:51)
	at com.snc.process_flow.engine.Operation.execute(Operation.java:198)
	at com.snc.process_flow.engine.ProcessEngine.executeOps(ProcessEngine.java:501)
	at com.snc.process_flow.engine.ProcessEngine.run(ProcessEngine.java:411)
	at com.snc.process_flow.engine.ProcessAutomation.run(ProcessAutomation.java:66)
	at com.snc.process_flow.engine.MidProcessAutomation.messageFlow(MidProcessAutomation.java:55)
	at com.service_now.mid.probe.IPaaSActionProbe.probe(IPaaSActionProbe.java:106)
	at com.service_now.mid.probe.AProbe.process(AProbe.java:102)
	at com.service_now.mid.queue_worker.AWorker.runWorker(AWorker.java:122)
	at com.service_now.mid.queue_worker.AWorkerThread.run(AWorkerThread.java:20)
	at com.service_now.mid.threadpool.ResourceUserQueue$RunnableProxy.run(ResourceUserQueue.java:649)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at java.base/java.lang.Thread.run(Thread.java:834)

Also this error

com.snc.automation_common.integration.exceptions.InvalidOperationException: Not able to get the credential with the sysId: d768f562dbb23414359af8f3399619a2. If the credential is an external credential, please verify your external credential setup/configuration. Otherwise, please check if the credential is active.: java.lang.RuntimeException: com.snc.automation_common.integration.exceptions.InvalidOperationException: Not able to get the credential with the sysId: d768f562dbb23414359af8f3399619a2. If the credential is an external credential, please verify your external credential setup/configuration. Otherwise, please check if the credential is active.: 	com.snc.mid.jdbc.DirectConnectionHandler.initConnectionFactory(DirectConnectionHandler.java:58)
	com.snc.mid.jdbc.DirectConnectionHandler.<init>(DirectConnectionHandler.java:26)
	com.snc.mid.jdbc.JDBCConnectionHandlerFactory.getConnectionHandler(JDBCConnectionHandlerFactory.java:30)
	com.snc.process_flow.operation.jdbc.MidJdbcExecutionWrapper.init(MidJdbcExecutionWrapper.java:64)
	com.snc.process_flow.operation.jdbc.MidJdbcExecutionWrapper.execute(MidJdbcExecutionWrapper.java:74)
	com.snc.process_flow.operation.JdbcOperation.executeOperation(JdbcOperation.java:77)
	com.snc.process_flow.operation.JdbcOperation.invoke(JdbcOperation.java:65)
	com.snc.process_flow.operation.RetryableIntegrationOperation.run(RetryableIntegrationOperation.java:51)
	com.snc.process_flow.engine.Operation.execute(Operation.java:198)
	com.snc.process_flow.engine.ProcessEngine.executeOps(ProcessEngine.java:501)
	com.snc.process_flow.engine.ProcessEngine.run(ProcessEngine.java:411)
	com.snc.process_flow.engine.ProcessAutomation.run(ProcessAutomation.java:66)
	com.snc.process_flow.engine.MidProcessAutomation.messageFlow(MidProcessAutomation.java:55)
	com.service_now.mid.probe.IPaaSActionProbe.probe(IPaaSActionProbe.java:106)
	com.service_now.mid.probe.AProbe.process(AProbe.java:102)
	com.service_now.mid.queue_worker.AWorker.runWorker(AWorker.java:122)
	com.service_now.mid.queue_worker.AWorkerThread.run(AWorkerThread.java:20)
	com.service_now.mid.threadpool.ResourceUserQueue$RunnableProxy.run(ResourceUserQueue.java:649)
	java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	java.base/java.lang.Thread.run(Thread.java:834)

I do not currently have access to the MID server host to view the logs. To rule out a possible firewall issue, created a JDBC data source and a test load ran just fine. The credential record mentioned in the second error is active and not external. 

Any ideas? 

[Sukraj Raikhraj]

create a new data source and validate if that works. Before using flow

1) Database information

2) credentials

3) mid server

https://docs.servicenow.com/en-US/bundle/sandiego-platform-administration/page/administer/import-sets/task/create-jdbc-type-data-source.html

[Community Alums · Accepted solution]

Tried this and still failed. The solution ended up being deletion of orphan credentials and resolving some firewall issues.