You are not logged in.
Pages: 1
Hi i want to ask, i can't run my query when i run this type of query
select limit_id as "Limit code"
from dm."dimAccountopening"
limit 5;
maybe you can help me solve this ? the error is like this and it said table doesn't exist where i can run it on my db.
The report could not be executed: PSQLException: ERROR: relation "dm.dimAccounOverdrawn" does not exist Position: 68
net.datenwerke.gxtdto.client.servercommunication.exceptions.NonFatalException: The report could not be executed: PSQLException: ERROR: relation "dm.dimAccounOverdrawn" does not exist<br> Position: 68<br> at net.datenwerke.rs.base.server.table.TableReportUtilityServiceImpl.loadColumnDefinition(TableReportUtilityServiceImpl.java:377)<br> at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:112)<br> at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)<br> at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br> at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)<br> at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br> at java.base/java.lang.reflect.Method.invoke(Method.java:566)<br> at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:587)<br> at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:333)<br> at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:112)<br> at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)<br> at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:303)<br> at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:112)<br> at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)<br> at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:373)<br> at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)<br> at javax.servlet.http.HttpServlet.service(HttpServlet.java:555)<br> at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)<br> at net.datenwerke.security.service.security.aop.SecurityCheckInterceptor.invoke(SecurityCheckInterceptor.java:112)<br> at net.datenwerke.gf.service.gwtstacktrace.CatchStacktraceInterceptor.invoke(CatchStacktraceInterceptor.java:38)<br> at com.google.inject.servlet.ServletDefinition.doServiceImpl(ServletDefinition.java:290)<br> at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:280)<br> at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:184)<br> at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:89)<br> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:85)<br> at com.google.inject.persist.PersistFilter.doFilter(PersistFilter.java:94)<br> at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:82)<br> at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:121)<br> at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:133)<br> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)<br> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)<br> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)<br> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)<br> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481)<br> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)<br> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)<br> at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:673)<br> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)<br> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)<br> at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390)<br> at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)<br> at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926)<br> at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)<br> at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)<br> at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)<br> at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)<br> at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)<br> at java.base/java.lang.Thread.run(Thread.java:829)<br>Caused by: net.datenwerke.rs.core.service.reportmanager.exceptions.ReportExecutorException: The report could not be executed: PSQLException: ERROR: relation "dm.dimAccounOverdrawn" does not exist<br> Position: 68<br> at net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:275)<br> at net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:161)<br> at net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:151)<br> at net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:145)<br> at net.datenwerke.rs.base.service.reportengines.table.TableReportUtilsImpl.getReturnedColumns(TableReportUtilsImpl.java:194)<br> at net.datenwerke.rs.base.service.reportengines.table.TableReportUtilsImpl.getReturnedPlainColumns(TableReportUtilsImpl.java:148)<br> at net.datenwerke.rs.base.server.table.TableReportUtilityServiceImpl.loadColumnDefinition(TableReportUtilityServiceImpl.java:373)<br> ... 47 more<br>Caused by: net.datenwerke.rs.core.service.reportmanager.exceptions.ReportExecutorException: Query could not be executed: ERROR: relation "dm.dimAccounOverdrawn" does not exist<br> Position: 68<br> at net.datenwerke.rs.base.service.datasources.table.impl.TableDBDataSource.open(TableDBDataSource.java:274)<br> at net.datenwerke.rs.base.service.reportengines.table.TableReportEngine.createReport(TableReportEngine.java:276)<br> at net.datenwerke.rs.base.service.reportengines.table.TableReportEngine.doExecuteNormal(TableReportEngine.java:200)<br> at net.datenwerke.rs.base.service.reportengines.table.TableReportEngine.doExecuteNormal(TableReportEngine.java:155)<br> at net.datenwerke.rs.base.service.reportengines.table.TableReportEngine.doExecute(TableReportEngine.java:86)<br> at net.datenwerke.rs.core.service.reportmanager.engine.ReportEngine.execute(ReportEngine.java:146)<br> at net.datenwerke.rs.core.service.reportmanager.ReportExecutorServiceImpl.execute(ReportExecutorServiceImpl.java:246)<br> ... 53 more<br>Caused by: org.postgresql.util.PSQLException: ERROR: relation "dm.dimAccounOverdrawn" does not exist<br> Position: 68<br> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2713)<br> at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2401)<br> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:368)<br> at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:498)<br> at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:415)<br> at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:190)<br> at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:134)<br> at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1471)<br> at net.datenwerke.rs.base.service.datasources.table.impl.TableDBDataSource.open(TableDBDataSource.java:269)<br> ... 59 more<br>
Offline
Hi felipe,
this is a postgres error, pls check your JDBC URL, maybe the schema is missing.
You can also find lots of information on the internet (google):
e.g.
https://stackoverflow.com/questions/203 … -not-exist
https://dba.stackexchange.com/questions … xist-error
Regards,
Eduardo
Offline
Check that the table name in the query exactly matches the one in the database. Table names are case-sensitive in PostgreSQL,
so ensure that the case is correct.
Offline
Pages: 1