failed to get dynamic schema - using Execute Query action in SQL server

[mounikakadiveti]

I am receiving the following error when I connect to this particular SQL server, though the connection is well established.

I am ending with this error when I choose Execute SQL Query action. However, when I choose an other action like for example Execute a Stored Procedure with the same SQL server connection it is working perfectly fine. 

Please somebody help me with this

[JohnAageAnderse]

Hello @mounikakadiveti 

I just read something about that if the return from the query only is one row, the dynamic information is not available.

Could you try and select the top 2 rows and see if anything changes?

Kind regards, John

[mounikakadiveti]

Hi @JohnAageAnderse 

I tried to retrieve top 10 but still I get the same error

[Inrade]

I seem to be having the same issue. Does anybody have a response?