Bug #1467
openConnection is null a veces en
Description
Algunos de mx.gob.conocer.sii.service.commons.security.impl.SystemMenuServiceImpl:getMainMenu truenan al cargr inicialmente SII
2026-01-29 20:02:48,088 [http-nio-8090-exec-10] ERROR m.g.c.s.s.commons.aop.TracingAOP - <<-- An exception has occurred: org.springframework.transaction.TransactionSystemException: Could not commit JPA transaction; nested exception is javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Connection is null.
Error Code: 0 mx.gob.conocer.sii.service.commons.security.impl.SystemMenuServiceImpl:getMainMenu:[mx.gob.conocer.sii.commons.to.AbstractConocerTO@2e48f21f[
userId=6656
username=SUPEREVAL
idProfile=29
fullName=Super Evaluador Piloto
]]
2026-01-29 20:02:48,089 [http-nio-8090-exec-10] ERROR m.g.c.s.s.commons.aop.TracingAOP - Could not commit JPA transaction; nested exception is javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Connection is null.
Error Code: 0
org.springframework.transaction.TransactionSystemException: Could not commit JPA transaction; nested exception is javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Connection is null.
Error Code: 0
at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:521)
...
at com.sun.proxy.$Proxy448.getMainMenu(Unknown Source)
at mx.gob.conocer.sii.web.controller.service.session.MainPageServiceController.mainPage(MainPageServiceController.java:105)
at mx.gob.conocer.sii.web.controller.service.session.MainPageServiceController$$FastClassByCGLIB$$f9313bdd.invoke(<generated>)
Updated by Miguel Ruiz Velasco 16 days ago
- Status changed from New to In Progress
- % Done changed from 0 to 10
Rastrear el 11/02/2026 el connection is null: resultado dudoso
Updated by Miguel Ruiz Velasco 16 days ago
Rastrear el 12/02/2026 el connection is null. El intento de componerlo con resultados terribles: todo empezo a tronar masivamente con "connection is null", incluso cosas que funcionaban antes.
De plano regresé a un commit de la mañana del 11/02/2026 para que volviera a funcionar el SII
Updated by Miguel Ruiz Velasco 16 days ago
- % Done changed from 10 to 20
A partir del commit f7f915f5f5873a00ec3ed2a523687d20d9c529ba del 11/02/2026 se empezó una nueva rama
Se rastreo y arreglo el bug en MainPageServiceController.mainPage
Aparentemente el problema es al cerrar la conexion del EntityManager con un try-with-resource.
Updated by Miguel Ruiz Velasco 13 days ago
- % Done changed from 20 to 90
Se sacaron de try-with-resources las conexiones de EntityManager
Updated by Miguel Ruiz Velasco 10 days ago
- Status changed from In Progress to Feedback
- % Done changed from 90 to 100