Database connector not returning any data with test connection,
And if i use prod connection then process working fine as expected.
My question is why process stopping in step 2 itself with test connection, what could be the reason?
If a database GET operation stops at the shape itself, it means it didn't return data. Have you checked running the SQL statement directly on the database itself to compare the result?
Thanks for responding,
Connector : Database test - process stopping in connector itself and SQL fetching data in database
Connector : Database Prod - Data coming as expected
Connector : Database test - Data coming as expected
Process structure like this,
If you are sure it has data and it stops at the connector shape itself,then it could be the reason that it is waiting for subprocess to complete.Try to uncheck this option -"Wait for process to complete " and see if it works
The SQL is no returning when i connect stage database with few parameters,
Now process was working as expected,
Thanks for your help.
Retrieving data ...