3787103 - System Update failed with "connection reset by peer" error during the deployment due to database ddl/index changes

• An error occurs while performing a system update.
• Error message was found as below:

  [m[1;31mERROR [main] [DefaultDbScriptsExecutor] problem executing sql [reason: StatementCallback; SQL [INSERT INTO composedtypes1 (hjmpTS, createdTS, modifiedTS, TypePkString, OwnerPkString, PK, sealed, Jun 5, 2026 @ 16:18:40.077 [m[32mINFO  [main] [JDBCConnectionFactory] Error while destroying connection 380(-A!) : The connection is closed. Jun 5, 2026 @ 16:18:40.077 [m[32mINFO  [main] [DefaultDbScriptsExecutor] Executed 26 Statements. Time taken: 21.71 min Jun 5, 2026 @ 16:18:40.077 [m[32mINFO  [main] [DefaultDbScriptsExecutor] ###### Executing DML Statements in batch mode ..... log: Target exception: java.lang.IllegalStateException: problem executing sql [reason: StatementCallback; SQL [DROP INDEX orders.DBA_OrdersIDX_017_45;  ALTER TABLE bulkuploadtemplate     ADD p_singlejobexecutiononly TINYINT;  ALTER TABLE carts     ADD p_tokoisptaxexemption BIGINT;  ALTER TABLE deliverycarrier     ADD p_vendorintegrationenabled TINYINT;  ALTER TABLE deliverymodes     ADD p_preferreddefaultdeliverymode TINYINT;  ALTER TABLE forecastedstocklevel     ADD p_lastmodifiedtime DATETIME2;  ALTER TABLE orders     ADD p_tokoisptaxexemption BIGINT;  ALTER TABLE pointofservice …… log: [m[1;31mERROR [main] [DefaultDbScriptsExecutor] problem executing sql [reason: StatementCallback; SQL [INSERT INTO composedtypes2 (hjmpTS, createdTS, modifiedTS, TypePkString, OwnerPkString, PK, sealed, p_extensionname, p_autocreate, p_generate, InternalCode, p_defaultvalue, InheritancePathString, jaloClassName, ItemJNDIName, Singleton, p_jaloonly, p_dynamic, SuperTypePK, p_legacypersistence, p_systemtype, p_catalogitemtype, p_catalogversionattributequali, p_uniquekeyattributequalifier, aCLTS, propTS, InternalCodeLowerCase, removable, propertyTableStatus, ItemTypeCode, p_comparati…. ULL, seriestype = '1', currentValue = '3484', template = NULL WHERE serieskey = 'pk_82';  UPDATE numberseries SET hjmpTS = NULL, seriestype = '1', currentValue = '1372', template = NULL WHERE serieskey = 'pk_83';  UPDATE numberseries SET hjmpTS = NULL, seriestype = '1', currentValue = '101460', template = NULL WHERE serieskey = 'pk_87';  UPDATE numberseries SET hjmpTS = NULL, seriestype = '1', currentValue = '18097', template = NULL WHERE serieskey = 'pk_91']; Connection reset by peer; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset by peer     at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:107) ~[spring-jdbc-5.3.43.jar:5.3.43] ……

SAP Commerce Cloud V2

connection reset by peer, SQLServerException, system update failure, deployment failure, ddl timeout, index creation, drop index, items.xml change, large tables, database indexing, hybris, jdbc batchUpdate, DefaultDbScriptsExecutor , KBA , CEC-SCC-CLA-DEP , Deployments , Problem