PostgreSQL error: org.postgresql.util.PSQLException: ERROR: portal "C_70" does not exist

-3

We use a Java Web application with Postgres database to generate the Sped files and in the middle of generating the TXT file we are getting the error below. This portal "C_70" is not necessarily repeated, and it is not always the same line as the error occurs. Has anyone seen anything like this and knew how to circumvent it?

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)

Q: Unfortunately, I can not post the code snippet in which the error occurs because we use a tool called Maker Studio that generates an incomprehensible code.

    
asked by anonymous 28.05.2018 / 23:27

1 answer

0

Finally, we were able to find out that it occurs at the time we give "Next ()" in the ResultSet and have found a way in the Maker Studio tool itself so that the error will no longer occur.     

30.05.2018 / 17:41