Complex Object Schema is null. Please run test step error in testing JDBC query

chandra shoban1
Tera Contributor

Need urgent help.

I am trying to establish a jdbc connection where need to execute the below sql query and fetch the information from the db. view. Connection is successful. However, , when i tested using Integration hub jdbc query, im getting the below error message. Please let me know what the possible issue could be.

 

select * from viewname

Error Message

Complex Object Schema is null. Please run test step.

2 REPLIES 2

mwood
Tera Guru

Did you ever figure this out?  I'm running into the same issue.

Stepan
Tera Contributor

Hello Chandra,

what you need to do is run test step from here (screen bellow).

It will generate ResultSet which can then be used further in your flow/action.

Stepan_1-1731490538555.png