x

FÓRUM CONTÁBEIS

TECNOLOGIA CONTÁBIL

respostas 5

acessos 10.834

Erro no Sistema Emissor de Nota Fiscal Eletrônica ao Abrir o

REGINA

Regina

Iniciante DIVISÃO 2, Administrador(a)
há 9 anos Sexta-Feira | 27 março 2015 | 06:00

Instalei o sistema de emissor 3.1, ao tentar abrir para emissão de notas aparece a mensagem:
"Ocorreu um erro inesperado!", quando abro os detalhes aparece:
" org.hibernate.exception.JDBCConnectionException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
at org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:50)
at com.sun.proxy.$Proxy19.rollback(Unknown Source)
at br.gov.sp.fazenda.dsen.model.dao.ControleVersaoDAO.executarScript(ControleVersaoDAO.java:53)
at br.gov.sp.fazenda.dsen.model.business.ControleVersaoBusiness.a(ControleVersaoBusiness.java:42)
at br.gov.sp.fazenda.dsen.model.business.ControleVersaoBusiness.verificarVersao(ControleVersaoBusiness.java:27)
at br.gov.sp.fazenda.dsen.model.facade.SistemaFacade.verificarVersao(SistemaFacade.java:83)
at br.gov.sp.fazenda.dsen.controller.DSENSystemController.b(DSENSystemController.java:92)
at br.gov.sp.fazenda.dsen.controller.DSENSystemController.execAfterStartApp(DSENSystemController.java:66)
at br.gov.sp.fazenda.dsge.controller.DSGESystemController.startApp(DSGESystemController.java:118)
at br.gov.sp.fazenda.dsen.view.DSENDesktop$1.run(DSENDesktop.java:116)
Caused by: java.sql.SQLException: A conexão foi recusada, porque o banco de dados NFE310;autocommit=true;release_mode=auto não foi encontrado.
at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.jdbc.ClientDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
... 11 more
Caused by: org.apache.derby.client.am.DisconnectException: A conexão foi recusada, porque o banco de dados NFE310;autocommit=true;release_mode=auto não foi encontrado.
at org.apache.derby.client.net.NetConnectionReply.parseRDBNFNRM(Unknown Source)
at org.apache.derby.client.net.NetConnectionReply.parseAccessRdbError(Unknown Source)
at org.apache.derby.client.net.NetConnectionReply.parseACCRDBreply(Unknown Source)
at org.apache.derby.client.net.NetConnectionReply.readAccessDatabase(Unknown Source)
at org.apache.derby.client.net.NetConnection.readSecurityCheckAndAccessRdb(Unknown Source)
at org.apache.derby.client.net.NetConnection.flowSecurityCheckAndAccessRdb(Unknown Source)
at org.apache.derby.client.net.NetConnection.flowUSRIDPWDconnect(Unknown Source)
at org.apache.derby.client.net.NetConnection.flowConnect(Unknown Source)
at org.apache.derby.client.net.NetConnection.<init>(Unknown Source)
at org.apache.derby.client.net.ClientJDBCObjectFactoryImpl.newNetConnection(Unknown Source)
... 16 more"

Quando dou OK, o programa fecha sem ter terminado de abrir e eu não consigo fazer nada, o que fazer? Meu JAVA é versão 8, meu windows 7 Professional.

Ricardo Dimitri

Ricardo Dimitri

Ouro DIVISÃO 2, Analista Fiscal
há 9 anos Segunda-Feira | 30 março 2015 | 17:20

Boa tarde

Tentam fazer o seguinte procedimento:
Instalar o JAVA 8.40
Painel de Controle - JAVA - Geral - Arquivos Temporários na Internet clicar em "Definições" - Selecionar a opção "Manter os arquivos temporários no meu computador" - Na mesma tela clicar em "Excluir Arquivos", e se retornar alguma mensagem de erro, clicar na opção ao lado "Restaurar Padrões". Clicar Ok em todas as telas existentes e tentar baixar / abrir o emissor da nota fiscal eletrônica. Esse procedimento foi o que realizamos para abrir normalmente os emissor além de acrescentar os links conforme mencionado no site da secretaria da fazenda.

Att

Bacharel em Ciências Contábeis
Experiência nos regimes Simples Nacional, Lucro Presumido e Lucro Real
Ajudo empresas a descomplicar o complicado universo tributário
Analista em tributação de e-commerce
Analista em ações na bolsa de valores e ações em criptomoedas
Contato - 11.97424.7054
[email protected]
FELIPE SOARES

Felipe Soares

Iniciante DIVISÃO 2, Analista Informática
há 9 anos Sexta-Feira | 3 abril 2015 | 11:47

Olá,

Este erro ocorre pois ao realizar o download do emissor, você está mandando abrir com o arquivo Javaws.exe que está dentro da pasta /bin do instalador do Java, mas o correto é abrir o download com o arquivo JAVAWS.EXE que está em C:\WINDOWS\SYSTEM32\JAVAWS.EXE

Realizei isto em 15 computadores emissores de nf na fábrica em que trabalho e funcionou, espero que ajude.

Fabio Muniz

Fabio Muniz

Iniciante DIVISÃO 1, Administrador(a)
há 8 anos Terça-Feira | 22 dezembro 2015 | 17:06

Boa tarde, estou tendo problema com a versão 3.10.74, ao tentar pesquisar produtos, erro insperado:

null
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at br.gov.sp.fazenda.dsge.view.util.DSGEViewControllerHelper.getControllerFromView(DSGEViewControllerHelper.java:73)
at br.gov.sp.fazenda.dsen.view.PesquisarProdutoGUI.bindController(PesquisarProdutoGUI.java:406)
at br.gov.sp.fazenda.dsen.view.PesquisarProdutoGUI.<init>(PesquisarProdutoGUI.java:75)
at br.gov.sp.fazenda.dsen.view.PesquisarProdutoGUI.<init>(PesquisarProdutoGUI.java:53)
at br.gov.sp.fazenda.dsen.controller .nfe. ProdutoNotaController.c(ProdutoNotaController.java:95)
at br.gov.sp.fazenda.dsen.controller.nfe.ProdutoNotaController.actionPerformed(ProdutoNotaController.java:148)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$500(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.WaitDispatchSupport$2.run(Unknown Source)
at java.awt.WaitDispatchSupport$4.run(Unknown Source)
at java.awt.WaitDispatchSupport$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.WaitDispatchSupport.enter(Unknown Source)
at java.awt.Dialog.show(Unknown Source)
at java.awt.Component.show(Unknown Source)
at java.awt.Component.setVisible(Unknown Source)
at java.awt.Window.setVisible(Unknown Source)
at java.awt.Dialog.setVisible(Unknown Source)
at br.gov.sp.fazenda.dsen.controller.nfe.ManterNotaFiscalProdController.c(ManterNotaFiscalProdController.java:121)
at br.gov.sp.fazenda.dsen.controller.nfe.ManterNotaFiscalProdController.actionPerformed(ManterNotaFiscalProdController.java:188)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$500(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2223)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
at br.gov.sp.fazenda.dsen.model.dao.ProdutoDAO.selectProduto(ProdutoDAO.java:53)
at br.gov.sp.fazenda.dsen.model.business.ProdutoBusiness.pesquisarProduto(ProdutoBusiness.java:193)
at br.gov.sp.fazenda.dsen.model.business.ProdutoBusiness$$EnhancerByCGLIB$$996e82c2.CGLIB$pesquisarProduto$2(<generated>)
at br.gov.sp.fazenda.dsen.model.business.ProdutoBusiness$$EnhancerByCGLIB$$996e82c2$$FastClassByCGLIB$$bef47614.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:167)
at br.gov.sp.fazenda.dsge.model.dao.util.DSGEDAOInterceptorHelper.intercept(DSGEDAOInterceptorHelper.java:66)
at br.gov.sp.fazenda.dsen.model.business.ProdutoBusiness$$EnhancerByCGLIB$$996e82c2.pesquisarProduto(<generated>)
at br.gov.sp.fazenda.dsen.model.facade.ProdutoFacade.pesquisarProduto(ProdutoFacade.java:43)
at br.gov.sp.fazenda.dsen.controller.PesquisarProdutoController.a(PesquisarProdutoController.java:95)
at br.gov.sp.fazenda.dsen.controller.PesquisarProdutoController.<init>(PesquisarProdutoController.java:71)
... 91 more
Caused by: java.sql.SQLException: Column 'THIS_.CEST' is either not in any table in the FROM list or appears within aspecification and is outside the scope of thespecification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'THIS_.CEST' is not a column in the target table.
at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.client.am.Connection.prepareStatement(Unknown Source)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:423)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)
at org.hibernate.loader.Loader.doQuery(Loader.java:673)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
... 106 more
Caused by: org.apache.derby.client.am.SqlException: Column 'THIS_.CEST' is either not in any table in the FROM list or appears within aspecification and is outside the scope of thespecification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'THIS_.CEST' is not a column in the target table.
at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source)
at org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source)
at org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source)
... 114 more


alguém pode me ajudar??? o dia todo parado!

WILK JACKSON ASSUNÇÃO

Wilk Jackson Assunção

Iniciante DIVISÃO 2, Auxiliar Contabilidade
há 8 anos Segunda-Feira | 28 dezembro 2015 | 11:37

Bom dia, estou tendo problema com a versão 3.10.74, ao tentar pesquisar produtos, erro insperado;

já tentei todas as alternativas possíveis, desinstalei o java e coloquei uma versão mais antiga, não deu certo, ja desinstalei o emissor também não deu certo, alguém sabe como resolver esse problema?

O Portal Contábeis se isenta de quaisquer responsabilidades civis sobre eventuais discussões dos usuários ou visitantes deste site, nos termos da lei no 5.250/67 e artigos 927 e 931 ambos do novo código civil brasileiro.