Share
Report
263Could 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?
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
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"
All responses (
Answers (
