Histórico da Página

Tempo aproximado para leitura: 02 min

01. DADOS GERAIS

02. SITUAÇÃO/REQUISITO

Ao executar a API de beneficiarios, com o datemodified preenchido, a API retorna o erro abaixo:

{
"code": 400,
"detailedMessage": "",
"helpUrl": "http://tdn.totvs.com/x/Uzh_HQ",
"message": "Erro ao buscar dados do Plano de Saúde. Erro:\r\nFalha ao buscar dados do cliente!\r\n: Error : 907 - ORA-00907: missing right parenthesis\n ( From tOracleConnection::GetQueryFile )\nThread ID [19451]\tUser [manoela.gonzaga]\tIO [303]\tTables [11]\tMaxTables [14]\tComment []\tSP [ ]\tTraced [No]\tSQLReplay [No]\tInTran [No]\tDBEnv [ORACLE/BRTS12125V2]\tDBThread [(SID 868,28693,1)]\tStarted [30/05/2019 15:17:14]\tIP [10.171.67.120:55111]\tIDLE [ ]\tInTransact [ ]\tMemory [282336]\tRunning [ROP_QUERY]\tRCV [7954]\tSND [14609]\tTCBuild [20181212-20190503]\tTCVersion [18.2.1.1_RC1]\tARCH [64]\tOS [LINUX]\tBUILD [RELEASE]\t\nSELECT * FROM ( SELECT ROWNUM ITEMNUMBER, COUNT(1) OVER() AS TOTALNUMBER, RHK_FILIAL,RHK_MAT,RHK_MATSAU,RHK_MATODO,RHK_CNS,RHK_CODFOR,RHK_TPFORN,RHK_PLANO,RHK_PERINI,RHK_PERFIM,RHK_TPPLAN,RHL_FILIAL,RHL_MAT,RHL_MATSAU,RHL_MATODO,RHL_CNS,RHL_CODIGO,RHL_CODFOR,RHL_TPFORN,RHL_PLANO,RHL_PERINI,RHL_PERFIM,RHL_TPPLAN FROM RHKT10 AS RHK FULL JOIN RHLT10 AS RHL ON 1=2 WHERE (RHK_FILIAL = 'D MG 01' AND (REPLACE(TO_CHAR(TO_DATE('19960101','YYYYMMDD') + TO_NUMBER(CONCAT(REPLACE(TO_CHAR(ASCII(SUBSTR(RHK_USERGA,12,1))-50),' ',''),REPLACE(TO_CHAR(ASCII(SUBSTR(RHK_USERGA,16,1))-50),' ','')))),'.',' ')) >= '20190501') OR (RHL_FILIAL = 'D MG 01' AND (REPLACE(TO_CHAR(TO_DATE('19960101','YYYYMMDD') + TO_NUMBER(CONCAT(REPLACE(TO_CHAR(ASCII(SUBSTR(RHL_USERGA,12,1))-50),' ',''),REPLACE(TO_CHAR(ASCII(SUBSTR(RHL_USERGA,16,1))-50),' ','')))),'.',' ')) >= '20190501') ) QRY WHERE (QRY.ITEMNUMBER BETWEEN 1 AND 250) "
}

03. SOLUÇÃO

Correção da query que realiza a consulta das propriedades dos Beneficiários e retorna para o response da API REST.

<style>
div.theme-default .ia-splitter #main {
    margin-left: 0px;
}
.ia-fixed-sidebar, .ia-splitter-left {
    display: none;
}
#main {
    padding-left: 10px;
    padding-right: 10px;
    overflow-x: hidden;
}

.aui-header-primary .aui-nav,  .aui-page-panel {
    margin-left: 0px !important;
}
.aui-header-primary .aui-nav {
    margin-left: 0px !important;
}
</style>