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.