Postgresql error: org.postgresql.util.Psqlexception: ERROR: portal "C_70" does not exist

Asked

Viewed 163 times

-3

We use a Java Web application with Postgres database to generate the Sped files and in the middle of the TXT file generation we are getting the error below. That one portal "C_70" does not necessarily repeat itself, and it is not always in the same line that the error occurs. Someone has seen something like this and knew how to get around? 

Exception Stack Trace:
org.postgresql.util.PSQLException: ERRO: portal "C_70" não existe
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
        at org.postgresql.core.v3.QueryExecutorImpl.fetch(QueryExecutorImpl.java:2037)
        at org.postgresql.jdbc2.AbstractJdbc2ResultSet.next(AbstractJdbc2ResultSet.java:1833)
        at wfr.database.PagedResultSet.next(SourceFile:191)
        at com.sun.rowset.CachedRowSetImpl2.populate(SourceFile:752)
        at wfr.database.WFRResultSet.a(SourceFile:242)
        at wfr.database.WFRResultSet.next(SourceFile:220)
        at wfr.com.systems.system_sap.rules.WebrunFunctions.ebfSQLNext(WebrunFunctions.java:15523)
        at wfr.com.systems.system_sap.rules.SpedContabilBlocoI050.FlowRemark3(SpedContabilBlocoI050.java:395)
        at wfr.com.systems.system_sap.rules.SpedContabilBlocoI050.FlowRemark1(SpedContabilBlocoI050.java:382)
        at wfr.com.systems.system_sap.rules.SpedContabilBlocoI050.run(SpedContabilBlocoI050.java:344)
        at wfr.rules.WFRRule.start(SourceFile:761)
        at wfr.rules.WFRRule.callRule(SourceFile:681)
        at wfr.com.systems.system_sap.rules.Fis0001GerarSpedContabil.run(Fis0001GerarSpedContabil.java:179)
        at wfr.rules.WFRRule.start(SourceFile:761)
        at wfr.rules.WFRRule.callRule(SourceFile:681)
        at wfr.com.systems.system_sap.rules.Fis0000GerarSpedContabil.FlowSubRoutine1(Fis0000GerarSpedContabil.java:137)
        at wfr.com.systems.system_sap.rules.Fis0000GerarSpedContabil.run(Fis0000GerarSpedContabil.java:122)
        at wfr.rules.WFRRule.start(SourceFile:761)
        at wfr.rules.WFRRule.call(SourceFile:1823)
        at wfr.rules.WFRRule.call(SourceFile:57)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)

P.S.: Unfortunately, I can’t post the code snippet in which the error occurs, because we use a tool called Maker Studio that generates incomprehensible code.

java postgresql

  • try to pass more information, with what is there becomes complicated

  • Without the code that handles the location of such "C_70" it is impossible to help. The error itself is clear.

  • 1

    @Statelessdev The biggest problem is that we find very little information about this error. While the error is quite clear, he is not very well known, apparently. Anyway, we were able to find out that it occurs at the moment we give the "next()" in Resultset and we fixed it in Maker Studio itself so that it does not occur anymore. Thank you!!

  • @Felipejanser If you think it’s worth it, create an answer to your own question and mark it as correct, so you can help others who, in the future, go through the same situation. I’m glad you could work it out.

1 answer

0


Anyway, we were able to find out that it occurs at the moment we give the "next()" in Resultset and we fixed the tool itself Maker Studio so that the error does not occur more.

Browser other questions tagged java postgresql

You are not signed in. Login or sign up in order to post.