- Fórum
- Protheus/Microsiga/Totvs
- Módulos do Protheus
- Módulo Livros Fiscais
- Erro ao gerar Bloco K no Sped Fiscal
Perguntas Erro ao gerar Bloco K no Sped Fiscal
- clistenis
- Autor do Tópico
- Desconectado
- Membro Especialista
Menos
Mais
- Postagens: 97
- Obrigados Recebidos: 0
9 anos 2 meses atrás #29387
por clistenis
Erro ao gerar Bloco K no Sped Fiscal foi criado por clistenis
Boa tarde amigo, alguém já passou por este erro ao tentar gerar o sped com bloco K ?
Dá um erro de SQL, achei estranho.
Obrigado caso alguém tenha um dica.
THREAD ERROR (clistenis, GNX-DTI-1) 05/10/2015 14:44:37
: Error : 1722 - ORA-01722: invalid number
( From tOracleConnection::GetQueryFile )
Thread ID [2621503248] User [Administrador] IO [316333] Tables [88] MaxTables [88] Comment [SPEDFISCAL - TCPIP] Status [] SP [ ] Traced [No] InTran [No] DBEnv [ORACLE/sigaofc] DBThread [(SID 492,891)] Started [05/10/2015 14:20:27] LastIO [] IP [192.168.32.6:2424] RCV [37955867] SND [307732276] TCBuild [20141119]
SELECT SUM(SD3.D3_QUANT) AS QUANT,SD3.D3_OP,SD3.D3_COD,SD3.D3_FILIAL,SB1.B1_TIPO,SC2.C2_DATPRI AS DTINI,SC2.C2_DATRF AS DTFIM FROM SD3010 SD3 JOIN SB1010 SB1 ON SB1.B1_FILIAL = '0101' AND SB1.B1_COD = SD3.D3_COD AND SB1.D_E_L_E_T_ = ' ' JOIN SC2010 SC2 ON SD3.D3_OP = SC2.C2_NUM+SC2.C2_ITEM+SC2.C2_SEQUEN AND SC2.C2_FILIAL = '0101' AND SC2.D_E_L_E_T_ = ' ' WHERE SD3.D3_FILIAL = '0101' AND SD3.D_E_L_E_T_ = ' ' AND SD3.D3_ESTORNO = ' ' AND SD3.D3_OP <> ' ' AND SD3.D3_CF IN ('PR0','PR1') AND SUBSTR (SD3.D3_COD,1,3) <> 'MOD' AND SD3.D3_EMISSAO >= '20150901' AND SD3.D3_EMISSAO <= '20150930' AND SB1.B1_TIPO IN ('PP','PA') AND SD3.D_E_L_E_T_ = ' ' GROUP BY SD3.D3_OP, SD3.D3_COD, SD3.D3_FILIAL, SB1.B1_TIPO, SC2.C2_DATPRI, SC2.C2_DATRF on REGK230(MATXSPED.PRW) 02/10/2014 13:27:20 line : 557
[TOTVS build: 7.00.131227A-20150327]
Called from SPDBLOCOK(MATXSPED.PRW) 02/10/2014 13:27:20 line : 65
Called from BLOCOK(SPEDXFUN.PRW) 29/04/2015 15:36:10 line : 13522
Called from PRSPED(SPEDFISCAL.PRW) 05/05/2015 14:16:34 line : 3512
Called from {|LEND| PRSPED(@LEND,@CFILEDEST,CPERFIL,@OPROCESS,LTABCOMP,LTABCDT,LTABCD0,LTABCE5,LINTTMS,AWIZSCREEN,LTABCD1)}(SPEDFISCAL.PRW) 05/05/2015 14:16:34 line : 132
Called from eval line : 227
Called from {|SELF|(EVAL(BBLOCK),EVAL({||OBNTCAN:HIDE(),OBNTFIN:SHOW()}))}(FISXCLASS.PRW) 06/05/2013 09:09:46 line : 227
Called from ::MSDIALOG:ACTIVATE
Called from FISPROGRESS:ACTIVATE(FISXCLASS.PRW) 06/05/2013 09:09:46 line : 227
Called from SPEDFISCAL(SPEDFISCAL.PRW) 05/05/2015 14:16:34 line : 133
Called from __EXECUTE(APLIB090.PRW) 30/07/2015 11:33:26 line : 581
Called from FWPREEXECUTE(FWPREEXECUTE.PRW) 16/02/2015 00:06:32 line : 82
Called from {||FWPREEXECUTE('SPED FISCAL', 'SPEDFISCAL()', 1, '09', 'XXXXXXXXXX') } line : 353
Called from ::TWINDOW:ACTIVATE
Called from MSAPP:ACTIVATE(FWAPP.PRW) 20/08/2015 16:07:52 line : 621
Called from SIGAADV(APLIB000.PRW) 18/03/2015 18:17:30 line : 54
Dá um erro de SQL, achei estranho.
Obrigado caso alguém tenha um dica.
THREAD ERROR (clistenis, GNX-DTI-1) 05/10/2015 14:44:37
: Error : 1722 - ORA-01722: invalid number
( From tOracleConnection::GetQueryFile )
Thread ID [2621503248] User [Administrador] IO [316333] Tables [88] MaxTables [88] Comment [SPEDFISCAL - TCPIP] Status [] SP [ ] Traced [No] InTran [No] DBEnv [ORACLE/sigaofc] DBThread [(SID 492,891)] Started [05/10/2015 14:20:27] LastIO [] IP [192.168.32.6:2424] RCV [37955867] SND [307732276] TCBuild [20141119]
SELECT SUM(SD3.D3_QUANT) AS QUANT,SD3.D3_OP,SD3.D3_COD,SD3.D3_FILIAL,SB1.B1_TIPO,SC2.C2_DATPRI AS DTINI,SC2.C2_DATRF AS DTFIM FROM SD3010 SD3 JOIN SB1010 SB1 ON SB1.B1_FILIAL = '0101' AND SB1.B1_COD = SD3.D3_COD AND SB1.D_E_L_E_T_ = ' ' JOIN SC2010 SC2 ON SD3.D3_OP = SC2.C2_NUM+SC2.C2_ITEM+SC2.C2_SEQUEN AND SC2.C2_FILIAL = '0101' AND SC2.D_E_L_E_T_ = ' ' WHERE SD3.D3_FILIAL = '0101' AND SD3.D_E_L_E_T_ = ' ' AND SD3.D3_ESTORNO = ' ' AND SD3.D3_OP <> ' ' AND SD3.D3_CF IN ('PR0','PR1') AND SUBSTR (SD3.D3_COD,1,3) <> 'MOD' AND SD3.D3_EMISSAO >= '20150901' AND SD3.D3_EMISSAO <= '20150930' AND SB1.B1_TIPO IN ('PP','PA') AND SD3.D_E_L_E_T_ = ' ' GROUP BY SD3.D3_OP, SD3.D3_COD, SD3.D3_FILIAL, SB1.B1_TIPO, SC2.C2_DATPRI, SC2.C2_DATRF on REGK230(MATXSPED.PRW) 02/10/2014 13:27:20 line : 557
[TOTVS build: 7.00.131227A-20150327]
Called from SPDBLOCOK(MATXSPED.PRW) 02/10/2014 13:27:20 line : 65
Called from BLOCOK(SPEDXFUN.PRW) 29/04/2015 15:36:10 line : 13522
Called from PRSPED(SPEDFISCAL.PRW) 05/05/2015 14:16:34 line : 3512
Called from {|LEND| PRSPED(@LEND,@CFILEDEST,CPERFIL,@OPROCESS,LTABCOMP,LTABCDT,LTABCD0,LTABCE5,LINTTMS,AWIZSCREEN,LTABCD1)}(SPEDFISCAL.PRW) 05/05/2015 14:16:34 line : 132
Called from eval line : 227
Called from {|SELF|(EVAL(BBLOCK),EVAL({||OBNTCAN:HIDE(),OBNTFIN:SHOW()}))}(FISXCLASS.PRW) 06/05/2013 09:09:46 line : 227
Called from ::MSDIALOG:ACTIVATE
Called from FISPROGRESS:ACTIVATE(FISXCLASS.PRW) 06/05/2013 09:09:46 line : 227
Called from SPEDFISCAL(SPEDFISCAL.PRW) 05/05/2015 14:16:34 line : 133
Called from __EXECUTE(APLIB090.PRW) 30/07/2015 11:33:26 line : 581
Called from FWPREEXECUTE(FWPREEXECUTE.PRW) 16/02/2015 00:06:32 line : 82
Called from {||FWPREEXECUTE('SPED FISCAL', 'SPEDFISCAL()', 1, '09', 'XXXXXXXXXX') } line : 353
Called from ::TWINDOW:ACTIVATE
Called from MSAPP:ACTIVATE(FWAPP.PRW) 20/08/2015 16:07:52 line : 621
Called from SIGAADV(APLIB000.PRW) 18/03/2015 18:17:30 line : 54
Por favor Acessar ou Registrar para participar da conversa.
- JamesWesTRP
- Desconectado
- Membro Dourado
Menos
Mais
- Postagens: 248
- Obrigados Recebidos: 1
5 anos 2 meses atrás #32763
por JamesWesTRP
Respondido por JamesWesTRP no tópico Erro ao gerar Bloco K no Sped Fiscal
Amigo,
Conseguiu resolver este caso ?
Se sim, como ? Estou com o mesmo problema...
Conseguiu resolver este caso ?
Se sim, como ? Estou com o mesmo problema...
Por favor Acessar ou Registrar para participar da conversa.
- Fórum
- Protheus/Microsiga/Totvs
- Módulos do Protheus
- Módulo Livros Fiscais
- Erro ao gerar Bloco K no Sped Fiscal
Tempo para a criação da página:0.083 segundos