Exception stack
java.sql.SQLException: ERROR: function web.pub_macha() does not exist at character 8
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:126)
at org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:451)
at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:281)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48)
at paulb.catwalk3.server.postgresql.PostgreSQLSession.call(PostgreSQLSession.java:138)
at paulb.catwalk3.server.BrowserServlet.processRequest(BrowserServlet.java:41)
at paulb.catwalk3.server.GenericServlet.internalProcessRequest(GenericServlet.java:86)
at paulb.catwalk3.server.GenericServlet.doGet(GenericServlet.java:54)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:879)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.base/java.lang.Thread.run(Thread.java:840)
Debug log
Creating new session: paulb.catwalk3.server.postgresql.PostgreSQLSession
Content type: text/html; charset=UTF-8
Opening session: username=svmk database=svmk_postgres_1/svmk
initSessionSql: SELECT CW.INIT_SESSION()
Procedure name: web.pub_macha
Parameters:
describeProcSql: SELECT NAME, TYPE FROM CW.DESCRIBE_PROC('WEB.PUB_MACHA') ORDER BY POSITION
initDocSql: SELECT CW.INIT_CALL()
callSql: SELECT WEB.PUB_MACHA()