Page tree
Skip to end of metadata
Go to start of metadata

Produto:

Protheus.

Ocorrência:

PSIGAERRO0210 - Relatório obrigações sociais (GPER060) quando a quantidade excede 1000 registros no banco Oracle: THREAD ERROR Error - TOPCONN - TC_Blob_Length error:COMM_PROGRAM_ERROR in file D:\bamboo-agent-5.7.2\xml-data\build-dir\TP11-BUILDV2APPSRV-TEC11WIN32RPO32\advtec9_tt11\lib\top.cpp at line 999

Passo a passo:

TOTVS Build 7.00.131227A-20170830 NG
THREAD ERROR
Error - TOPCONN - TC_Blob_Length error:COMM_PROGRAM_ERROR in file D:\bamboo-agent-5.7.2\xml-data\build-dir\TP11-BUILDV2APPSRV-TEC11WIN32RPO32\advtec9_tt11\lib\top.cpp at line 999

( PREVIOUS ERROR : : Error : 604 - ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
( From tOracleConnection::GetQueryFile )
Thread ID [3944] User [Administrador] IO [26562] Tables [326] MaxTables [326] Comment [GPER060 - TCPIP - ThreadID(12380)] Status [] SP [ ] Traced [No] SQLReplay [No] InTran [No] DBEnv [ORACLE/BRA115RHE] DBThread [(SID 390,31746,1)] Started [05/09/2017 09:41:51] LastIO [05/09/2017 09:45:52] IP [10.172.22.57:1616] RCV [7225883] SND [9030437] TCBuild [20161016-20170331] 
SELECT * FROM (SELECT RC_FILIAL,RC_MAT,RC_PD,RC_TIPO1,RC_QTDSEM,RC_HORINFO,RC_HORAS,RC_VALINFO,RC_VALOR,RC_VNAOAPL,RC_DATA,RC_DTREF,RC_SEMANA,RC_CC,RC_TIPO2,RC_SEQ,RC_VALORBA,RC_PROCES,RC_PERIODO,RC_POSTO,RC_NUMID,RC_ROTEIR,RC_DEPTO,RC_NODIA,RC_DIACTB,RC_ITEM,RC_CLVL,RC_EMPCONS,RC_IDCMPL,RC_PLNUCO,RC_CODB1T,RC_LOTPLS,RC_CODRDA FROM SRCT10 WHERE D_E_L_E_T_ = ' ' AND RC_PERIODO='201705' AND (RC_ROTEIR='FOL' OR RC_ROTEIR ='AUT') AND RC_FILIAL ='D MG 01 ' AND RC_MAT ='001016' AND RC_PD ='719' UNION SELECT RD_FILIAL,RD_MAT,RD_PD,RD_TIPO1,RD_QTDSEM,RD_HORINFO,RD_HORAS,RD_VALINFO,RD_VALOR,RD_VNAOAPL,RD_DATARQ,RD_DTREF,RD_SEMANA,RD_CC,RD_TIPO2,RD_SEQ,RD_VALORBA,RD_PROCES,RD_PERIODO,RD_POSTO,RD_NUMID,RD_ROTEIR,RD_DEPTO,RD_NODIA,RD_DIACTB,RD_ITEM,RD_CLVL,RD_EMPCONS,RD_IDCMPL,RD_PLNUCO,RD_CODB1T,RD_LOTPLS,RD_CODRDA FROM SRDT10 WHERE D_E_L_E_T_ = ' ' AND RD_PERIODO='201705' AND (RD_ROTEIR='FOL' OR RD_ROTEIR ='AUT') AND RD_FILIAL ='D MG 01 ' AND RD_MAT ='001016' AND RD_PD ='719' ) A ORDER BY RC_FILIAL,RC_CC )
on FWTBLCREATE(FWTABLEDDL.PRX) 28/08/2017 14:16:22 line : 1199

Solução:

O problema apontado é referente a uma configuração do banco de dados.

Segue link com mais detalhes para correção do problema.

http://tdn.totvs.com/display/public/rm/Oracle+-+ORA-01000+-+MAXIMUM+OPEN+CURSORS+EXCED


Observações:

P12