org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command Where: SQL statement "CREATE TABLE reports.avl_historico_354676056031379( CONSTRAINT reports_pk_historico_354676056031379_fecha_imei PRIMARY KEY (fecha, imei), CONSTRAINT reports_avl_historico_only_354676056031379 CHECK (imei = 354676056031379), CONSTRAINT reports_fk_avl_historico_354676056031379_imei FOREIGN KEY (imei) REFERENCES public.avl_equipo (imei) MATCH SIMPLE ON UPDATE CASCADE ON DELETE CASCADE ) INHERITS (reports.avl_historico) WITHOUT OIDS;" PL/pgSQL function reports.trigger_crea_historico_imei() line 3 at EXECUTE statement

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via stackexchange.com by Unknown author, 1 year ago
reports_avl_historico_only_354676056031379 CHECK (imei = 354676056031379), CONSTRAINT reports_fk_avl_historico_354676056031379_imei FOREIGN KEY (imei) REFERENCES public.avl_equipo (imei) MATCH SIMPLE ON UPDATE CASCADE ON DELETE CASCADE ) INHERITS (reports.avl_historico) WITHOUT OIDS;" PL/pgSQL function reports.trigger_crea_historico_imei() line 3 at EXECUTE statement
via Database Administrators by Gonzalo Vasquez
, 1 year ago
reports_avl_historico_only_354676056031379 CHECK (imei = 354676056031379), CONSTRAINT reports_fk_avl_historico_354676056031379_imei FOREIGN KEY (imei) REFERENCES public.avl_equipo (imei) MATCH SIMPLE ON UPDATE CASCADE ON DELETE CASCADE ) INHERITS (reports.avl_historico) WITHOUT OIDS;" PL/pgSQL function reports.trigger_crea_historico_imei() line 3 at EXECUTE statement
via GitHub by e-Evolution
, 1 year ago
ERROR: syntax error at or near "AND" Position: 1167
via Google Groups by enrique, 3 months ago
ERROR: syntax error at or near ""null"" Position: 21
via adempiere by mjmckay
, 1 year ago
ERROR: function pg\_catalog.btrim(timestamp without time zone) does not exist   Hint: No function matches the given name and argument types. You might need to add explicit type casts.   Position: 156
via adempiere by sfetter0511
, 1 year ago
ERROR: function bomqtyavailable(numeric, integer, integer) does not exist; State=42883; ErrorCode=0
org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command Where: SQL statement "CREATE TABLE reports.avl_historico_354676056031379( CONSTRAINT reports_pk_historico_354676056031379_fecha_imei PRIMARY KEY (fecha, imei), CONSTRAINT reports_avl_historico_only_354676056031379 CHECK (imei = 354676056031379), CONSTRAINT reports_fk_avl_historico_354676056031379_imei FOREIGN KEY (imei) REFERENCES public.avl_equipo (imei) MATCH SIMPLE ON UPDATE CASCADE ON DELETE CASCADE ) INHERITS (reports.avl_historico) WITHOUT OIDS;" PL/pgSQL function reports.trigger_crea_historico_imei() line 3 at EXECUTE statement
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:559)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
at waypoint.soporte.equipos.CreateEquipo.doPost(CreateEquipo.java:105)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:644)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1081)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:658)
at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:222)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1566)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.lang.Thread.run(Thread.java:745)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
104 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.