Power Platform Community Forum Thread Details

Could someone please help me with this problem? I get it when I want to run a query using Oracle.
I really don't understand anything. Is it a problem with my gateway ? Of the Query?

"error": {

"code": 502,

"source": "brazil-001.azure-apim.net",

"clientRequestId": "d39301c2-1f51-4656-bcb9-05eb194754fa",

"message": "BadGateway",

"innerError": {

"status": 502,

"message": "Unexpected Exception : [0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayClientMaxPacketLimitReachedException: packet reached the maximum limit = '4' at gateway client.\r\n\r\nGatewayPipelineErrorCode=DM_GWPipeline_Client_MaxPacketLimitReached\r\nGatewayVersion=\r\nMaxPacketLimitReachedCount=4\r\n ([0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayClientMaxPacketLimitReachedException.StackTrace:)\r\n at Microsoft.PowerBI.DataMovement.Pipeline.Relay.Service.GatewayClientRemoter.<>c__DisplayClass21_1.<<TransferImpl>b__0>d.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at Microsoft.PowerBI.DataMovement.GatewayDiagnostics.GatewayDiagnosticsTelemetryServiceBase.<ExecuteInActivity>d__6.MoveNext()\r\n--\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at Microsoft.PowerBI.DataMovement.Pipeline.AdoNetProvider.AdoNetProviderReader.<ReadAsync>d__64.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at Microsoft.Azure.Connectors.Common.Mashup.Adapter.QueryResult.<ReadSingleResultSetAsync>d__35.MoveNext() in X:\\bt\\1082352\\repo\\src\\source\\common\\Mashup\\Adapter\\QueryResult.cs:line 338\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at Microsoft.Azure.Connectors.Common.Mashup.Adapter.GatewayNativeQueryExecutor.<ExecuteQueryAsync>d__7.MoveNext() in X:\\bt\\1082352\\repo\\src\\source\\common\\Mashup\\Adapter\\GatewayNativeQueryExecutor.cs:line 233\r\n inner exception: packet reached the maximum limit = '4' at gateway client.\r\nclientRequestId: d39301c2-1f51-4656-bcb9-05eb194754fa",

},

This is the query, for what it's worth

SELECT DISTINCT CT.COD_CATEGORIA_ARCH, CT.DESC_CATEGORIA_ARCH, FV.CORR_FICHA, TF.COD_TIPO,DK.DIRECTORIO, FV.NRO_FICHA||'_'||FV.NOM_ARCHIVO as NOMBRE_ARCHIVO,

FV.DESC_ARCHIVO, FV.FEC_CARGA, FV.FECHA_VIGENCIA, FV.COD_ESTADO, SUC.NOM_SUC,F.RUT_CLI AS RUT_CLIENTE, CL.RAZON_SOCIAL,FV.NRO_FICHA,

ESTADO_FICHA_VENTA(FV.NRO_FICHA,SYSDATE)||' - '||ES.DESC_ESTADO ESTADO_FICHA_VENTA, (SYSDATE) FECHA_ESTADO_FICHA, TF.DESCRIPCION_TIPO AS SUBTIPO

FROM ANEXO_NUMERO_FICHAS FV, FICHA_VENTA F, DIR_KSA DK, TIPO_FICHA_ANEXOS TF, CLIENTE CL, SUCURSAL SUC, CATEGORIA_TIPO_ARCHIVOS CT, ESTADO ES

WHERE FV.NRO_FICHA = F.NRO_FICHA AND DK.COD_SISTEMA = FV.COD_SISTEMA AND DK.COD_TIPO_DIR = FV.COD_TIPO_DIR AND TF.COD_TIPO = FV.COD_TIPO AND F.RUT_CLI = CL.RUT_CLI

AND F.COD_SUC = SUC.COD_SUC AND TF.COD_CATEGORIA_ARCH = CT.COD_CATEGORIA_ARCH AND ESTADO_FICHA_VENTA(F.NRO_FICHA,SYSDATE) = ES.COD_ESTADO

AND FV.COD_ESTADO = 1 /*Vigente*/AND FV.FEC_CARGA >= TO_DATE('20190101','YYYYMMDD')AND FV.FEC_CARGA <= TO_DATE('20191231','YYYYMMDD') ORDER BY FV.NRO_FICHA DESC

"source": "oracle-bs.azconn-bs.p.azurewebsites.net"

Categories:

Building flows