Dataflow and Dataset refresh error: gateway connection

[fabiomanniti]

I am having trouble with my Dataset and Dataflows.

I used to have a gateway on-premises on my own computer and I created a set of dataflows and datasets and everything worked.

Now I moved my gateway on a VM and some problem started:

• If I create a dataset on PBI Desktop, when I publish on server an dI try to set an authomatic refresh I get this: Not configured correctly

• If I try to refresh a dataset I created before moving the gateway I get this error:

ODBC: ERROR [HY001] Out of memory while reading tuples.; memory allocation error???

• If I try to refresh an "old" dataflow, for some of them I don't have any problem but for other I get error:
  

  memory allocation error??? [GatewayPipelineErrorCode]=DM_GWPipeline_Gateway_MashupDataAccessError [ErrorShortName]=GatewayClientErrorResponseException[GatewayId=131016]/MashupDataAccessValueException[ErrorCode=-2147467259 HResult=-2147467259]/Wrapped(MashupValueException)[ErrorCode=-2147467259 HResult=-2147467259] [ExceptionErrorShortName]=GatewayClientErrorResponseException[GatewayId=131016] Request ID: 4167402d-27ee-ff9d-c5de-396705c1ce26.

[GilbertQ]

Hi @fabiomanniti 

The error appears to be an out of memory wrror where your ODBC data source is running out of memory for your query. I would check the query to PostfreSQL is working and runs fast?

The second error is because you have moved your gateway and it is no longer connected!

[fabiomanniti]

About the memory issue, what can I do to solve it?

About the connection, I don't understand: the gateway seems connected