We are experiencing an issue with CPQ EQ when submitting a large number of configurable products from EQ to LN.
We are currently running EQ version 24.10.
Has anyone encountered a similar issue or found a way to resolve it without upgrading the EQ version?
Infor.PCM.GenericEngine.Models.RuleEngineException: A database error was encountered: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.InvalidOperationException: A database error was encountered: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> Microsoft.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (258): The wait operation timed out. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.SqlCommand.InternalEndExecuteNonQuery(IAsyncResult asyncResult, Boolean isInternal, String endMethod) at Microsoft.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult) at Microsoft.Data.SqlClient.SqlCommand.EndExecuteNonQueryAsync(IAsyncResult asyncResult) at System.Threading.Tasks.TaskFactory1.FromAsyncCoreLogic(IAsyncResult iar, Func2 endFunction, Action1 endAction, Task1 promise, Boolean requiresSynchronization)--- End of stack trace from previous location --- at Infor.Keystone.Common.Framework.Database.Logging.LoggingDbCommand.TimeExecutionAsync[T](Func1 func, String memberName) in C:\BuildAgent\_work\6\s\src\Keystone.Common\Framework\Database\Logging\LoggingDbCommand.cs:line 133 at Infor.Keystone.Common.Framework.Database.Dao.Database.ExecuteAsync(DbCommand cmd) in C:\BuildAgent\_work\6\s\src\Keystone.Common\Framework\Database\Dao\Database.cs:line 283ClientConnectionId:23f4eeeb-83f2-4126-b701-b15bee02489fError Number:-2,State:0,Class:11 --- End of inner exception stack trace --- at Infor.Keystone.Common.Framework.Database.Dao.Database.ExecuteAsync(DbCommand cmd) in C:\BuildAgent\_work\6\s\src\Keystone.Common\Framework\Database\Dao\Database.cs:line 290 at Infor.Keystone.Common.Framework.Database.Dao.Database.ExecuteAsync(DbCommand cmd) in C:\BuildAgent\_work\6\s\src\Keystone.Common\Framework\Database\Dao\Database.cs:line 290 at Infor.Keystone.Common.Framework.Database.Dao.Database.ExecuteAsync(String sql, Object[] args) in C:\BuildAgent\_work\6\s\src\Keystone.Common\Framework\Database\Dao\Database.cs:line 272 at Infor.Keystone.Common.Framework.Database.Dao.Database.ExecuteAsync(String sql, Object[] args) in C:\BuildAgent\_work\6\s\src\Keystone.Common\Framework\Database\Dao\Database.cs:line 272 at Infor.Keystone.Runtime.Entities.EntityRecords.Repositories.EntityRecordRepository.LockAggregateRootOfAsync(IEntityDefinition entityDefinition, IDictionary2 values) in C:\BuildAgent\_work\6\s\src\Keystone.Runtime\Entities\EntityRecords\Repositories\EntityRecordRepository.cs:line 69 at Infor.Keystone.Runtime.Entities.EntityRecords.Repositories.EntityRecordRepository.UpdateAsync(IEntityDefinition entityDefinition, EntityRecord record, IDictionary2 assignments) in C:\BuildAgent\_work\6\s\src\Keystone.Runtime\Entities\EntityRecords\Repositories\EntityRecordRepository.cs:line 194 at Infor.Keystone.Runtime.Entities.EntityRecords.Services.Impl.EntityRecordServiceImpl.UpdateAsync(IEntityDefinition entityDefinition, Guid id, IDictionary2 assignments, Boolean resequence) in C:\BuildAgent\_work\6\s\src\Keystone.Runtime\Entities\EntityRecords\Services\Impl\EntityRecordServiceImpl.cs:line 158 at Infor.Keystone.Runtime.Entities.EntityRecords.Services.Impl.EntityRecordServiceImpl.DeleteAsync(IEntityDefinition entityDefinition, Guid id, Boolean resequence) in C:\BuildAgent\_work\6\s\src\Keystone.Runtime\Entities\EntityRecords\Services\Impl\EntityRecordServiceImpl.cs:line 224 at Infor.Keystone.Runtime.Engine.Models.Rules.Record.DeleteEntityRecordRule.<>c__DisplayClass1_0.<<ExecuteRuleAsync>b__0>d.MoveNext() in C:\BuildAgent\_work\6\s\src\Keystone.Runtime\Engine\Models\Rules\Record\DeleteEntityRecordRule.cs:line 36--- End of stack trace from previous location --- at Infor.Keystone.Runtime.Engine.Tracing.Services.TraceContextCreationService.ExecuteAndPublishAsync[TResult](Func1 func, Func2 createExpressionObjectFunc) in C:\BuildAgent\_work\6\s\src\Keystone.Runtime\Engine\Tracing\Services\TraceContextCreationService.cs:line 242 at Infor.PCM.GenericEngine.Models.Runtime.GenericXmlRuleBase.ExecuteActionAsync(IGenericEngine engine, IGenericRuleDataFactory ruleDataFactory) in C:\BuildAgent\_work\6\s\src\GenericEngine\Models\Runtime\GenericXmlRuleBase.cs:line 24 at Infor.Keystone.Runtime.Engine.GenericEngine.Models.XmlRuleBase.ExecuteActionAsync(IGenericEngine engine, IGenericRuleDataFactory ruleDataFactory) in C:\BuildAgent\_work\6\s\src\Keystone.Runtime\Engine\GenericEngine\Models\XmlRuleBase.cs:line 50 at Infor.PCM.GenericEngine.Models.Runtime.GenericEngine.ExecuteRuleAsync(GenericRuleBase currentRule, GenericRuleset currentRuleset) in C:\BuildAgent\_work\6\s\src\GenericEngine\Models\Runtime\GenericEngine.cs:line 181 --- End of inner exception stack trace --- at Infor.PCM.GenericEngine.Models.Runtime.GenericEngine.ExecuteRuleAsync(GenericRuleBase currentRule, GenericRuleset currentRuleset) in C:\BuildAgent\_work\6\s\src\GenericEngine\Models\Runtime\GenericEngine.cs:line 188 at Infor.Keystone.Runtime.Engine.Tracing.TracingRuleExecutingAggregator.RuleExecutedAsync(Func1 next) in C:\BuildAgent\_work\6\s\src\Keystone.Runtime\Engine\Tracing\TracingRuleExecutingAggregator.cs:line 52 at Infor.Keystone.Runtime.UsageMetrics.UsageMetricsEngineFactoryWrapper.RuleExecutedAsync(Func1 arg) in C:\BuildAgent\_work\6\s\src\Keystone.Runtime\UsageMetrics\UsageMetricsEngineFactoryWrapper.cs:line 40 at Infor.PCM.GenericEngine.Models.Runtime.GenericEngine.ExecuteCurrentRuleAsync() in C:\BuildAgent\_work\6\s\src\GenericEngine\Models\Runtime\GenericEngine.cs:line 162 at Infor.PCM.GenericEngine.Models.Runtime.GenericEngine.ExecuteAsync() in C:\BuildAgent\_work\6\s\src\GenericEngine\Models\Runtime\GenericEngine.cs:line 95Expression Detail
