PostgreSQL Dataflow Refresh Error

[geebos]

Hi,

I am refreshing a large table in PostgreSQL and it is returing the following error. Is it simply to do with the size or something different? Any advice would be much appreciated.

Error: Encountered user gateway exception: '[DM_ErrorDetailNameCode_UnderlyingErrorCode]=-2147467259 [DM_ErrorDetailNameCode_UnderlyingHResult]=-2147467259 [Microsoft.Data.Mashup.ValueError.DataSourceKind]=PostgreSQL [Microsoft.Data.Mashup.ValueError.DataSourcePath]=cc-data-warehouse.postgres.database.azure.com;Master [Microsoft.Data.Mashup.ValueError.ErrorCode]=-2147467259 [Microsoft.Data.Mashup.ValueError.Message]=Exception while reading from stream [Microsoft.Data.Mashup.ValueError.Reason]=DataSource.Error [InnerType]=MashupValueException PostgreSQL: Exception while reading from stream [GatewayPipelineErrorCode]=DM_GWPipeline_Gateway_MashupDataAccessError [ErrorShortName]=GatewayClientErrorResponseException[GatewayId=741247]/MashupDataAccessValueException[ErrorCode=-2147467259 HResult=-2147467259]/Wrapped(MashupValueException)[ErrorCode=-2147467259 HResult=-2147467259] [ExceptionErrorShortName]=GatewayClientErrorResponseException[GatewayId=741247]'. RootActivityId = a0191b73-3df3-4931-8b35-e6216a16baf3.Param1 = [DM_ErrorDetailNameCode_UnderlyingErrorCode]=-2147467259 [DM_ErrorDetailNameCode_UnderlyingHResult]=-2147467259 [Microsoft.Data.Mashup.ValueError.DataSourceKind]=PostgreSQL [Microsoft.Data.Mashup.ValueError.DataSourcePath]=cc-data-warehouse.postgres.database.azure.com;Master [Microsoft.Data.Mashup.ValueError.ErrorCode]=-2147467259 [Microsoft.Data.Mashup.ValueError.Message]=Exception while reading from stream [Microsoft.Data.Mashup.ValueError.Reason]=DataSource.Error [InnerType]=MashupValueException PostgreSQL: Exception while reading from stream [GatewayPipelineErrorCode]=DM_GWPipeline_Gateway_MashupDataAccessError [ErrorShortName]=GatewayClientErrorResponseException[GatewayId=741247]/MashupDataAccessValueException[ErrorCode=-2147467259 HResult=-2147467259]/Wrapped(MashupValueException)[ErrorCode=-2147467259 HResult=-2147467259] [ExceptionErrorShortName]=GatewayClientErrorResponseException[GatewayId=741247] Request ID: b6e04c19-b18c-68ce-c460-9a8110ee6567.

[geebos · Accepted solution]

It appears to be due to the size of the table itself, so it's being reduced to see if that resolves the issue. Thanks for the feedback anyway.

[v-luwang-msft]

Hi @geebos ，

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[lbendlin]

This looks more like network instability?