Project

General

Profile

Actions
Copy link

Bug #1604

open

The user specified as a definer ('jonathan'@'%') does not exist

Added by Miguel Ruiz Velasco about 1 month ago. Updated about 1 month ago.

Status:
In Progress
Priority:
Normal
Assignee:
Miguel Ruiz Velasco
Start date:
06/23/2026
Due date:
% Done:

20%

Estimated time:
5:00 h
Spent time:
1:00 h

Description

2026-06-23 14:15:34,894 [http-nio-8080-exec-6] INFO   Servlet.guia_observacion - guia_observacion:insertaReactivos SPGENERA_REACTIVOS_IEC
2026-06-23 14:15:34,910 [http-nio-8080-exec-6] ERROR  Servlet.guia_observacion - guia_observacion:insertaReactivos - error en CallableStatement java.sql.SQLException: The user specified as a definer ('jonathan'@'%') does not exist
2026-06-23 14:15:34,910 [http-nio-8080-exec-6] ERROR  Servlet.guia_observacion - guia_observacion:doGet - error java.sql.SQLException: The user specified as a definer ('jonathan'@'%') does not exist
jun 23, 2026 2:15:34 P. M. org.apache.catalina.core.StandardWrapperValve invoke
GRAVE: El Servlet.service() para el servlet [guia_observacion] en el contexto con ruta [/evaluacion] lanzó la excepción [java.sql.SQLException: The user specified as a definer ('jonathan'@'%') does not exist] con causa raíz
java.sql.SQLException: The user specified as a definer ('jonathan'@'%') does not exist
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:130)
Actions
Copy link
 #1

Updated by Miguel Ruiz Velasco about 1 month ago

Ya van varios SP; el último que sí fue de ayer fue : SPGENERA_REACTIVOS_IEC

Actions
Copy link
 #2

Updated by Miguel Ruiz Velasco about 1 month ago

  • Status changed from New to In Progress
  • % Done changed from 0 to 20
Actions
Copy link
 #3

Updated by Miguel Ruiz Velasco about 1 month ago

  • Description updated (diff)
Actions
Copy link
 #4

Updated by Miguel Ruiz Velasco about 1 month ago

2026-06-23 14:30:40,073 [http-nio-8080-exec-1] ERROR Control.introduccion - introduccion:Instrumento Error SQL al ejecutar spExtraerP2IEC : java.sql.SQLSyntaxErrorException: Access denied for user 'mutrilla'@'%' to database 'DB_SI_06'

Actions
Copy link
 #5

Updated by Miguel Ruiz Velasco about 1 month ago

2026-06-23 14:33:02,521 [http-nio-8080-exec-10] ERROR DB Negocio.Configuracion - Configuracion:getConfiguraciones error: java.sql.SQLException: The user specified as a definer ('jonathan'@'%') does not exist spSettings

2026-06-23 14:33:05,316 [http-nio-8080-exec-6] INFO Control.spModificarDatosGral - spModificarDatosGral:GetPaisExtranjero [StorageProcedure: sp_ObtenerPaisExtranjeros] inicio
2026-06-23 14:33:05,328 [http-nio-8080-exec-6] ERROR DB Control.spModificarDatosGral - spModificarDatosGral:GetPaisExtranjero [Error SQL en StorageProcedure: sp_ObtenerPaisExtranjeros]: java.sql.SQLException: The user specified as a definer ('jonathan'@'%') does not exist
2026-06-23 14:33:05,361 [http-nio-8080-exec-3] INFO Control.spModificarDatosGral - spModificarDatosGral:ObtenerSectorProd [StorageProcedure: sp_ObtenerSectorProductivo] inicio

2026-06-23 14:33:05,696 [http-nio-8080-exec-6] ERROR DB Control.spModificarDatosGral - spModificarDatosGral:ObtenerNivelesEstudios [Error SQL en StorageProcedure: Sp_ObtenerNivelesEstudiosGral]: java.sql.SQLException: The user specified as a definer ('jonathan'@'%') does not exist
2026-06-23 14:33:05,700 [http-nio-8080-exec-9] INFO Control.spModificarDatosGral - spModificarDatosGral:ObtenerSectorProd [StorageProcedure: sp_ObtenerSectorProductivo] completado exitosamente

Actions
Copy link

Also available in: Atom PDF