3514132 - Promotion publish failed due to com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated in table 'xxx-p1-db.dbo.enginerules', column 'p_ruleparameters'.

Promotion publish failed due to below exception.

{"instant":{"epochSecond":1725178856,"nanoOfSecond":556092139
"thread":"RuleCompiler-Thread-488","level":"ERROR","loggerName":"de.hybris.platform.ruleengineservices.compiler.impl.DefaultRuleCompilerService",
"message":"Exception caught","thrown":{"commonElementCount":0,"localizedMessage":"org.springframework.dao.DataIntegrityViolationException: query; 
SQL []; String or binary data would be truncated in table 'xxx
-p1-db.dbo.enginerules', column 'p_ruleparameters'. 
Truncated value: '[{\"uuid\":\"6ea99711-5e90-4085-b941-79293cf2190f\",\"type\":\"java.lang.String\",\"value\":\"1aed_sale\"
{\"uui'.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated in table 'xxx-p1-db.dbo.enginerules', column 'p_ruleparameters'. Truncated value: '[{\"uuid\":\"6ea99711-5e90-4085-b941-79293cf2190f\",\"type\":\"java.lang.String\",\"value\":\"1aed_sale\"
{\"uui'.","message":"org.springframework.dao.DataIntegrityViolationException: query; SQL []; String or binary data would be truncated in table 'xxx
-p1-db.dbo.enginerules', column 'p_ruleparameters'. Truncated value: '[{\"uuid\":\"6ea99711-5e90-4085-b941-79293cf2190f\",\"type\":\"java.lang.String\",\"value\":\"1aed_sale\"
{\"uui'.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated in table 'xxx-p1-db.dbo.enginerules', column 'p_ruleparameters'. Truncated value: '[{\"uuid\":\"6ea99711-5e90-4085-b941-79293cf2190f\",\"type\":\"java.lang.String\",\"value\":\"1aed_sale\"
{\"uui'.","name":"de.hybris.platform.servicelayer.exceptions.ModelSavingException","cause":{"commonElementCount":29,"localizedMessage":"org.springframework.dao.DataIntegrityViolationException: query; SQL []; String or binary data would be truncated in table 'xxx
-p1-db.dbo.enginerules', column 'p_ruleparameters'. Truncated value: '[{\"uuid\":\"6ea99711-5e90-4085-b941-79293cf2190f\",\"type\":\"java.lang.String\",\"value\":\"1aed_sale\"
{\"uui'.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated in table 'xxx-p1-db.dbo.enginerules', column 'p_ruleparameters'. Truncated value: '[{\"uuid\":\"6ea99711-5e90-4085-b941-79293cf2190f\",\"type\":\"java.lang.String\",\"value\":\"1aed_sale\"
{\"uui'.","message":"org.springframework.dao.DataIntegrityViolationException: query; SQL []; String or binary data would be truncated in table 'xxx-p1-db.dbo.enginerules', column 'p_ruleparameters'. Truncated value: '[{\"uuid\":\"6ea99711-5e90-4085-b941-79293cf2190f\",\"type\":\"java.lang.String\",\"value\":\"1aed_sale\"
{\"uui'.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated in table 'xxx-p1-db.dbo.enginerules', column 'p_ruleparameters'. Truncated value: '[{\"uuid\":\"6ea99711-5e90-4085-b941-79293cf2190f\",\"type\":\"java.lang.String\",\"value\":\"1aed_sale\"
{\"uui'.","name":"de.hybris.platform.persistence.hjmp.HJMPException","cause":{"commonElementCount":29,"localizedMessage":"query; SQL []; String or binary data would be truncated in table 'xxx-p1-db.dbo.enginerules', column 'p_ruleparameters'. Truncated value: '[{\"uuid\":\"6ea99711-5e90-4085-b941-79293cf2190f\",\"type\":\"java.lang.String\",\"value\":\"1aed_sale\"
{\"uui'.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated in table 'xxx-p1-db.dbo.enginerules', column 'p_ruleparameters'. Truncated value: '[{\"uuid\":\"6ea99711-5e90-4085-b941-79293cf2190f\",\"type\":\"java.lang.String\",\"value\":\"1aed_sale\"
{\"uui'.","message":"query; SQL []; String or binary data would be truncated in table 'xxx
-p1-db.dbo.enginerules', column 'p_ruleparameters'. Truncated value: '[{\"uuid\":\"6ea99711-5e90-4085-b941-79293cf2190f\",\"type\":\"java.lang.String\",\"value\":\"1aed_sale\"
{\"uui'.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated in table 'xxx-p1-db.dbo.enginerules', column 'p_ruleparameters'. Truncated value: '[{\"uuid\":\"6ea99711-5e90-4085-b941-79293cf2190f\",\"type\":\"java.lang.String\",\"value\":\"1aed_sale\"
{\"uui'.","name":"org.springframework.dao.DataIntegrityViolationException","cause":{"commonElementCount":29,"localizedMessage":"String or binary data would be truncated in table 'xxx-p1-db.dbo.enginerules', column 'p_ruleparameters'. Truncated value: '[{\"uuid\":\"6ea99711-5e90-4085-b941-79293cf2190f\",\"type\":\"java.lang.String\",\"value\":\"1aed_sale\"
{\"uui'.","message":"String or binary data would be truncated in table 'xxx-p1-db.dbo.enginerules', column 'p_ruleparameters'. 
Truncated value: '[{\"uuid\":\"6ea99711-5e90-4085-b941-79293cf2190f\",\"type\":\"java.lang.String\",\"value\":\"1aed_sale\"
{\"uui'.","name":"com.microsoft.sqlserver.jdbc.SQLServerException","extendedStackTrace":[

{"class":"com.microsoft.sqlserver.jdbc.SQLServerException","method":"makeFromDatabaseError","file":"SQLServerException.java","line":265,"exact":false,"location":"mssql-jdbc-11.2.3.jre17.jar","version":"?"
{"class":"com.microsoft.sqlserver.jdbc.SQLServerStatement","method":"getNextResult","file":"SQLServerStatement.java","line":1676,"exact":false,"location":"mssql-jdbc-11.2.3.jre17.jar","version":"?"
{"class":"com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement","method":"doExecutePreparedStatement","file":"SQLServerPreparedStatement.java","line":620,"exact":false,"location":"mssql-jdbc-11.2.3.jre17.jar","version":"?"
{"class":"com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd","method":"doExecute","file":"SQLServerPreparedStatement.java","line":540,"exact":false,"location":"mssql-jdbc-11.2.3.jre17.jar","version":"?"
{"class":"com.microsoft.sqlserver.jdbc.TDSCommand","method":"execute","file":"IOBuffer.java","line":7620,"exact":false,"location":"mssql-jdbc-11.2.3.jre17.jar","version":"?"
{"class":"com.microsoft.sqlserver.jdbc.SQLServerConnection","method":"executeCommand","file":"SQLServerConnection.java","line":3916,"exact":false,"location":"mssql-jdbc-11.2.3.jre17.jar","version":"?"
{"class":"com.microsoft.sqlserver.jdbc.SQLServerStatement","method":"executeCommand","file":"SQLServerStatement.java","line":268,"exact":false,"location":"mssql-jdbc-11.2.3.jre17.jar","version":"?"
{"class":"com.microsoft.sqlserver.jdbc.SQLServerStatement","method":"executeStatement","file":"SQLServerStatement.java","line":242,"exact":false,"location":"mssql-jdbc-11.2.3.jre17.jar","version":"?"
{"class":"com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement","method":"executeUpdate","file":"SQLServerPreparedStatement.java","line":486,"exact":false,"location":"mssql-jdbc-11.2.3.jre17.jar","version":"?"
{"class":"de.hybris.platform.jdbcwrapper.interceptor.PreparedStatementWithJDBCInterceptor","method":"lambda$executeUpdate$5","file":"PreparedStatementWithJDBCInterceptor.java","line":78,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.jdbcwrapper.interceptor.recover.SQLRecoverableExceptionHandler","method":"passThrough","file":"SQLRecoverableExceptionHandler.java","line":93,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.jdbcwrapper.interceptor.recover.SQLRecoverableExceptionHandler","method":"get","file":"SQLRecoverableExceptionHandler.java","line":51,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.jdbcwrapper.interceptor.JDBCInterceptor","method":"get","file":"JDBCInterceptor.java","line":61,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.jdbcwrapper.interceptor.PreparedStatementWithJDBCInterceptor","method":"executeUpdate","file":"PreparedStatementWithJDBCInterceptor.java","line":78,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.jdbcwrapper.PreparedStatementImpl","method":"executeUpdate","file":"PreparedStatementImpl.java","line":311,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.persistence.GenericBMPBean$GenericItemEntityState","method":"storeChanges","file":"GenericBMPBean.java","line":1627,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.persistence.GenericBMPBean","method":"ejbStore","file":"GenericBMPBean.java","line":306,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.tx.Transaction","method":"executeEntityStore","file":"Transaction.java","line":1786,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.tx.Transaction","method":"executeEJBModifications","file":"Transaction.java","line":1742,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.tx.Transaction","method":"flushDelayedStore","file":"Transaction.java","line":1698,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.tx.Transaction","method":"commit","file":"Transaction.java","line":720,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.tx.Transaction","method":"handleCommitForFinishExecute","file":"Transaction.java","line":1349,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.tx.Transaction","method":"finishExecute","file":"Transaction.java","line":1329,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.tx.Transaction","method":"execute","file":"Transaction.java","line":1299,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.tx.Transaction","method":"execute","file":"Transaction.java","line":1207,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.jalo.Item","method":"setAllAttributes","file":"Item.java","line":2140,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.jalo.Item","method":"setAllAttributes","file":"Item.java","line":2120,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.servicelayer.internal.converter.impl.ItemModelConverter","method":"storeAttributes","file":"ItemModelConverter.java","line":1886,"exact":false,"location":"coreserver.jar","version":"?"}]
"extendedStackTrace":[{"class":"org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator","method":"doTranslate","file":"SQLErrorCodeSQLExceptionTranslator.java","line":248,"exact":false,"location":"spring-jdbc-5.3.34.jar","version":"5.3.34"
{"class":"org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator","method":"translate","file":"AbstractFallbackSQLExceptionTranslator.java","line":73,"exact":false,"location":"spring-jdbc-5.3.34.jar","version":"5.3.34"
{"class":"de.hybris.platform.jdbcwrapper.DataSourceImpl","method":"translateToDataAccessException","file":"DataSourceImpl.java","line":1031,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.persistence.GenericBMPBean$GenericItemEntityState","method":"storeChanges","file":"GenericBMPBean.java","line":1651,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.persistence.GenericBMPBean","method":"ejbStore","file":"GenericBMPBean.java","line":306,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.tx.Transaction","method":"executeEntityStore","file":"Transaction.java","line":1786,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.tx.Transaction","method":"executeEJBModifications","file":"Transaction.java","line":1742,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.tx.Transaction","method":"flushDelayedStore","file":"Transaction.java","line":1698,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.tx.Transaction","method":"commit","file":"Transaction.java","line":720,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.tx.Transaction","method":"handleCommitForFinishExecute","file":"Transaction.java","line":1349,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.tx.Transaction","method":"finishExecute","file":"Transaction.java","line":1329,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.tx.Transaction","method":"execute","file":"Transaction.java","line":1299,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.tx.Transaction","method":"execute","file":"Transaction.java","line":1207,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.jalo.Item","method":"setAllAttributes","file":"Item.java","line":2140,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.jalo.Item","method":"setAllAttributes","file":"Item.java","line":2120,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.servicelayer.internal.converter.impl.ItemModelConverter","method":"storeAttributes","file":"ItemModelConverter.java","line":1886,"exact":false,"location":"coreserver.jar","version":"?"}]
"extendedStackTrace":[{"class":"de.hybris.platform.persistence.GenericBMPBean$GenericItemEntityState","method":"storeChanges","file":"GenericBMPBean.java","line":1651,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.persistence.GenericBMPBean","method":"ejbStore","file":"GenericBMPBean.java","line":306,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.tx.Transaction","method":"executeEntityStore","file":"Transaction.java","line":1786,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.tx.Transaction","method":"executeEJBModifications","file":"Transaction.java","line":1742,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.tx.Transaction","method":"flushDelayedStore","file":"Transaction.java","line":1698,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.tx.Transaction","method":"commit","file":"Transaction.java","line":720,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.tx.Transaction","method":"handleCommitForFinishExecute","file":"Transaction.java","line":1349,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.tx.Transaction","method":"finishExecute","file":"Transaction.java","line":1329,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.tx.Transaction","method":"execute","file":"Transaction.java","line":1299,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.tx.Transaction","method":"execute","file":"Transaction.java","line":1207,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.jalo.Item","method":"setAllAttributes","file":"Item.java","line":2140,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.jalo.Item","method":"setAllAttributes","file":"Item.java","line":2120,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.servicelayer.internal.converter.impl.ItemModelConverter","method":"storeAttributes","file":"ItemModelConverter.java","line":1886,"exact":false,"location":"coreserver.jar","version":"?"}]
"extendedStackTrace":[{"class":"de.hybris.platform.servicelayer.internal.converter.impl.ItemModelConverter","method":"storeAttributes","file":"ItemModelConverter.java","line":1901,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.servicelayer.internal.converter.impl.ItemModelConverter","method":"lambda$save$2","file":"ItemModelConverter.java","line":875,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.servicelayer.internal.polyglot.UnitOfWorkInterceptor","method":"lambda$toSupplier$0","file":"UnitOfWorkInterceptor.java","line":71,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.servicelayer.internal.polyglot.UnitOfWorkInterceptor","method":"execute","file":"UnitOfWorkInterceptor.java","line":57,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.servicelayer.internal.polyglot.UnitOfWorkInterceptor","method":"updateFromServiceLayer","file":"UnitOfWorkInterceptor.java","line":28,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.servicelayer.internal.converter.impl.ItemModelConverter","method":"save","file":"ItemModelConverter.java","line":875,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.servicelayer.internal.model.impl.wrapper.ModelWrapper","method":"save","file":"ModelWrapper.java","line":364,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.servicelayer.internal.model.impl.ResolvingModelPersister","method":"saveOthers","file":"ResolvingModelPersister.java","line":62,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.servicelayer.internal.model.impl.ResolvingModelPersister","method":"persist","file":"ResolvingModelPersister.java","line":47,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService","method":"saveViaJalo","file":"DefaultModelService.java","line":1173,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService","method":"doJaloPersistence","file":"DefaultModelService.java","line":732,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService","method":"persistWrappers","file":"DefaultModelService.java","line":1117,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService","method":"performPersistenceOperations","file":"DefaultModelService.java","line":709,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService","method":"saveAllInternal","file":"DefaultModelService.java","line":703,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService","method":"saveAll","file":"DefaultModelService.java","line":683,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.servicelayer.internal.model.impl.DefaultModelService","method":"save","file":"DefaultModelService.java","line":630,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.droolsruleengineservices.compiler.impl.DefaultDroolsRuleTargetCodeGenerator","method":"generate","file":"DefaultDroolsRuleTargetCodeGenerator.java","line":173,"exact":false,"location":"droolsruleengineservicesserver.jar","version":"?"
{"class":"de.hybris.platform.ruleengineservices.compiler.impl.DefaultRuleCompilerService","method":"compile","file":"DefaultRuleCompilerService.java","line":101,"exact":false,"location":"ruleengineservicesserver.jar","version":"?"
{"class":"de.hybris.platform.ruleengineservices.maintenance.impl.DefaultRuleCompilerSpliterator$JobProvider","method":"lambda$getJob$0","file":"DefaultRuleCompilerSpliterator.java","line":167,"exact":false,"location":"ruleengineservicesserver.jar","version":"?"
{"class":"java.util.stream.ReferencePipeline$3$1","method":"accept","file":"ReferencePipeline.java","line":197,"exact":false,"location":"?","version":"?"
{"class":"java.util.ArrayList$SubList$2","method":"forEachRemaining","file":"ArrayList.java","line":1481,"exact":false,"location":"?","version":"?"
{"class":"java.util.stream.AbstractPipeline","method":"copyInto","file":"AbstractPipeline.java","line":509,"exact":false,"location":"?","version":"?"
{"class":"java.util.stream.AbstractPipeline","method":"wrapAndCopyInto","file":"AbstractPipeline.java","line":499,"exact":false,"location":"?","version":"?"
{"class":"java.util.stream.ReduceOps$ReduceOp","method":"evaluateSequential","file":"ReduceOps.java","line":921,"exact":false,"location":"?","version":"?"
{"class":"java.util.stream.AbstractPipeline","method":"evaluate","file":"AbstractPipeline.java","line":234,"exact":false,"location":"?","version":"?"
{"class":"java.util.stream.ReferencePipeline","method":"collect","file":"ReferencePipeline.java","line":682,"exact":false,"location":"?","version":"?"
{"class":"de.hybris.platform.ruleengineservices.maintenance.impl.DefaultRuleCompilerSpliterator$JobProvider","method":"lambda$getJob$1","file":"DefaultRuleCompilerSpliterator.java","line":168,"exact":false,"location":"ruleengineservicesserver.jar","version":"?"
{"class":"de.hybris.platform.core.AbstractTenant$5","method":"run","file":"AbstractTenant.java","line":2549,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.core.TenantAwareThreadFactory$1","method":"internalRun","file":"TenantAwareThreadFactory.java","line":163,"exact":false,"location":"coreserver.jar","version":"?"
{"class":"de.hybris.platform.core.threadregistry.RegistrableThread","method":"run","file":"RegistrableThread.java","line":124,"exact":false,"location":"coreserver.jar","version":"?"}]
"endOfBatch":false,"loggerFqcn":"org.apache.logging.slf4j.Log4jLogger","contextMap":{"Tenant":""
"threadId":19091,"threadPriority":4,"origin":"PLATFORM"}
    

SAP Commerce Cloud

promotion, promotion engine, publish , KBA , CEC-SCC-COM-PRO-PE , Promotion Engine , Problem