Article - CS349305

SKU Override load is failing with closed connection error Servigistics Service Parts Management

Modified: 05-Apr-2022   


Applies To

  • Servigistics Service Parts Management 12.1.1.3 N/A to 12.1.1.4

Description

 
  • SKU Override load is failing with Closed Connection Error
2021-06-08 15:44:36,582[GatewayTask-2] INFO  com.svg.core.process.BaseCustomHook - PreGateway executed successfully
2021-06-08 15:44:36,582[GatewayTask-2] INFO  com.svg.core.process.BaseCustomHook - PreGateway executed successfully
2021-06-08 15:44:36,584[GatewayTask-2] INFO  com.svg.core.util.EventLog - Custom Procedure: PreGateway completed.
2021-06-08 15:44:36,781[GatewayTask-2] INFO  com.svg.core.util.EventLog - BEGIN DATA TRANSFER FOR DOWNLOAD ID XXXXXXXXXX
06-08 15:44:38,788[GatewayTask-2] INFO  com.svg.core.util.EventLog - BEGIN Populating SKU Override Data (DownloadID: XXX)
2021-06-08 15:45:25,987[GatewayTask-2] ERROR com.svg.core.database.TransactionUtil - StatementCallback; SQL [select HostSKUOverrideId  from IPCSDD_SKU_OVERRIDE ovr join IPCS_PART_MASTER pm on ovr.HostPartId = pm.HostPartId join IPCS_LOC_MASTER lm on ovr.HostLocId = lm.HostLocID left outer join IPCS_PLANNER rec on ovr.HOSTRECOMMENDERPLANNERID = rec.HOSTPLANNERID  left outer join (select * from IPCSV_MEO_OVR_SECURITY_SKU where plannerId = XXXX) userSecurity on userSecurity.partId = pm.PartID and userSecurity.locId = lm.LocID  left outer join (select * from IPCSV_MEO_OVR_SECURITY_SKU) recommendSecurity on recommendSecurity.partId = pm.PartID and recommendSecurity.locId = lm.LocID  left outer join (SELECT rights, plannerId FROM IPCS_PLANNER_COVG where procId = XXXX) RecommenderGlobalSecurity on rec.PlannerID = RecommenderGlobalSecurity.plannerId  left outer join (SELECT rights, plannerId FROM IPCS_PLANNER_COVG where procId = XXXX ) userGlobalSecurity on userGlobalSecurity. PlannerID = XXXX WHERE (RecommenderGlobalSecurity.rights is null and  recommendSecurity.AllowRecommend is null) or (userGlobalSecurity.rights is null and  userSecurity.AllowRecommend is null)]; No more data to read from socket; nested exception is java.sql.SQLRecoverableException: No more data to read from socket
2021-06-08 15:45:25,988[GatewayTask-2] WARN  com.svg.core.util.EventLog - PreparedStatementCallback; SQL [insert into IPCS_STATUS (EvtTime, EvtOffset, MsgType, Message, TaskID) values (?, ?, ?, ?, ?)]; Closed Connection; nested exception is java.sql.SQLRecoverableException: Closed Connectionorg.springframework.dao.RecoverableDataAccessException: PreparedStatementCallback; SQL [insert into IPCS_STATUS (EvtTime, EvtOffset, MsgType, Message, TaskID) values (?, ?, ?, ?, ?)]; Closed Connection; nested exception is java.sql.SQLRecoverableException: Closed Connection at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:100) ~[spring-jdbc-5.0.19.RELEASE.jar:5.0.19.RELEASE] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) ~[spring-jdbc-5.0.19.RELEASE.jar:5.0.19.RELEASE] at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) ~[spring-jdbc-5.0.19.RELEASE.jar:5.0.19.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1397) ~[spring-jdbc-5.0.19.RELEASE.jar:5.0.19.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:620) ~[spring-jdbc-5.0.19.RELEASE.jar:5.0.19.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:849) ~[spring-jdbc-5.0.19.RELEASE.jar:5.0.19.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:904) ~[spring-jdbc-5.0.19.RELEASE.jar:5.0.19.RELEASE] at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:914) ~[spring-jdbc-5.0.19.RELEASE.jar:5.0.19.RELEASE] at com.svg.core.service.impl.EventLogServiceImpl.logMsg(EventLogServiceImpl.java:112) ~[AutoPilotServer.jar:12.1.1.2] at com.svg.core.service.impl.EventLogServiceImpl.error(EventLogServiceImpl.java:99) 


 
This is a printer-friendly version of Article 349305 and may be out of date. For the latest version click CS349305