org.postgresql.util.PSQLException: ERROR: Error en spd_subfalla ::: No se puede borrar el registro, aun exite una referencia al registro favor de verificar

GitHub | carloszaragoza | 10 months ago
  1. 0

    Al borrar una subfalla que se está usando

    GitHub | 10 months ago | carloszaragoza
    org.postgresql.util.PSQLException: ERROR: Error en spd_subfalla ::: No se puede borrar el registro, aun exite una referencia al registro favor de verificar
  2. 0

    GitHub comment 1#176573154

    GitHub | 10 months ago | carast
    org.postgresql.util.PSQLException: ERROR: Error en spd_falla ::: No se puede borrar el registro, aun exite una referencia al registro favor de verificar
  3. 0

    PlainSQL: `sqlu` generates wrong DDL sql?

    GitHub | 2 years ago | tminglei
    org.postgresql.util.PSQLException: ERROR: syntax error at or near "$1" Position: 88
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    PSQLException; No function matches given name and argument types

    Stack Overflow | 1 year ago | user1011376
    org.postgresql.util.PSQLException: ERROR: function create_new_user(bigint, character varying, character varying, character varying, character varying, unknown, character) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 15
  6. 0

    ERROR c.t.t.d.e.DefaultExecutorFactory - System executor exception

    GitHub | 1 year ago | zarmack
    com.torodb.torod.core.exceptions.ToroRuntimeException: java.lang.RuntimeException: org.jooq.exception.DataAccessException: SQL [{ ? = call "public"."reserve_doc_ids"(?, ?) }]; ERROR: function public.reserve_doc_ids(character varying, integer) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 15

  1. silex 16 times, last 4 weeks ago
  2. silex 1 times, last 5 months ago
10 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. org.postgresql.util.PSQLException

    ERROR: Error en spd_subfalla ::: No se puede borrar el registro, aun exite una referencia al registro favor de verificar

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.execute
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:413)
    6 frames
  3. org.apache.tomcat
    DelegatingPreparedStatement.execute
    1. org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:197)
    2. org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:197)
    2 frames
  4. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor65.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    3. java.lang.reflect.Method.invoke(Unknown Source)
    3 frames
  5. com.ibatis.common
    PreparedStatementLogProxy.invoke
    1. com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(PreparedStatementLogProxy.java:62)
    1 frame
  6. com.sun.proxy
    $Proxy29.execute
    1. com.sun.proxy.$Proxy29.execute(Unknown Source)
    1 frame
  7. com.ibatis.sqlmap
    SqlMapSessionImpl.queryForObject
    1. com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQueryProcedure(SqlExecutor.java:278)
    2. com.ibatis.sqlmap.engine.mapping.statement.ProcedureStatement.sqlExecuteQuery(ProcedureStatement.java:39)
    3. com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189)
    4. com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForObject(MappedStatement.java:120)
    5. com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:518)
    6. com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493)
    7. com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)
    7 frames
  8. Spring ORM
    SqlMapClientTemplate.queryForObject
    1. org.springframework.orm.ibatis.SqlMapClientTemplate$1.doInSqlMapClient(SqlMapClientTemplate.java:270)
    2. org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:200)
    3. org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:268)
    3 frames
  9. mx.com.nok
    FallaBusiness.deleteSubfalla
    1. mx.com.nok.falla.dao.ibatis.FallaDAOImpl.deleteSubfalla(FallaDAOImpl.java:65)
    2. mx.com.nok.falla.model.business.FallaBusiness.deleteSubfalla(FallaBusiness.java:119)
    2 frames
  10. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    4. java.lang.reflect.Method.invoke(Unknown Source)
    4 frames
  11. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    4. org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
    5. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    6. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
    6 frames
  12. com.sun.proxy
    $Proxy16.deleteSubfalla
    1. com.sun.proxy.$Proxy16.deleteSubfalla(Unknown Source)
    1 frame
  13. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    4. java.lang.reflect.Method.invoke(Unknown Source)
    4 frames
  14. flex.messaging.services
    JavaAdapter.invoke
    1. flex.messaging.services.remoting.adapters.JavaAdapter.invoke(JavaAdapter.java:418)
    1 frame
  15. BlazeDS Core Library
    MessageBrokerServlet.service
    1. flex.messaging.services.RemotingService.serviceMessage(RemotingService.java:183)
    2. flex.messaging.MessageBroker.routeMessageToService(MessageBroker.java:1503)
    3. flex.messaging.endpoints.AbstractEndpoint.serviceMessage(AbstractEndpoint.java:884)
    4. flex.messaging.endpoints.amf.MessageBrokerFilter.invoke(MessageBrokerFilter.java:121)
    5. flex.messaging.endpoints.amf.LegacyFilter.invoke(LegacyFilter.java:158)
    6. flex.messaging.endpoints.amf.SessionFilter.invoke(SessionFilter.java:44)
    7. flex.messaging.endpoints.amf.BatchProcessFilter.invoke(BatchProcessFilter.java:67)
    8. flex.messaging.endpoints.amf.SerializationFilter.invoke(SerializationFilter.java:146)
    9. flex.messaging.endpoints.BaseHTTPEndpoint.service(BaseHTTPEndpoint.java:278)
    10. flex.messaging.MessageBrokerServlet.service(MessageBrokerServlet.java:322)
    10 frames
  16. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
    1 frame
  17. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    2 frames
  18. Tomcat WS
    WsFilter.doFilter
    1. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    1 frame
  19. Glassfish Core
    CoyoteAdapter.service
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
    4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
    5. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
    6. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
    7. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
    8. org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:617)
    9. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
    10. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)
    10 frames
  20. Grizzly HTTP
    NioEndpoint$SocketProcessor.run
    1. org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091)
    2. org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:668)
    3. org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1521)
    4. org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1478)
    4 frames
  21. Java RT
    ThreadPoolExecutor$Worker.run
    1. java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    2. java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    2 frames
  22. Tomcat Util
    TaskThread$WrappingRunnable.run
    1. org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    1 frame
  23. Java RT
    Thread.run
    1. java.lang.Thread.run(Unknown Source)
    1 frame