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.
Solved! Go to 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.
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.
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
This looks more like network instability?
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!