Reports not firing

[Dan_Oliphant]

All my reports stopped working two days ago and have yet to return.

Here is the error log…
Error:
“DiagnosticFrameworkWrapper.CustomerFacingException: Request cancelled: took too long to process: Computing a formula\r\n at Nirvana.Data.AppDataContext.CheckCancellation(String errorMessage)\r\n at Jeenee.DataTypes.AppEvaluatable.RunBatch(BatchDataContext batchDataContext, BatchArguments batchArguments)\r\n at Jeenee.DataTypes.AppEvaluatable.RunBatch(BatchDataContext batchDataContext, BatchTrace batchTrace)\r\n at System.Linq.Enumerable.WhereSelectListIterator2.MoveNext()\r\n at System.Collections.Generic.List1…ctor(IEnumerable1 collection)\r\n at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source)\r\n at Jeenee.DataTypes.AppEvaluatable.RunBatch(BatchDataContext batchDataContext, BatchTrace batchTrace)\r\n at Nirvana.Data.AppDataContext.ColumnValues(String tableName, Nullable1 rowListAttrIndex, Int32 columnPosition, AppEvaluatable rowFilter, Nullable1 maxResults, Int32 rowListContextLevel)\r\n at Jeenee.DataTypes.ColumnSetExpression.Evaluatable.RunAndFilter(ListMetaData listTypeQualifier, IDataContext dataContext, String tableName, Nullable1 rowListAttrIndex, Int32 colIndex, AppEvaluatable columnFilter, Boolean makeDistinct, Int32 rowListContextLevel, Nullable1 maxResults)\r\n at Jeenee.DataTypes.SelectFunction.Run(Evaluatable funcExpressionEvaluatable, IDataContext dataContext, List1 children, List1 argumentValues)\r\n at Jeenee.DataTypes.BuiltinFunction.RunBatch(Evaluatable funcExpressionEvaluatable, BatchDataContext batchDataContext, List1 children, BatchArguments batchArguments)\r\n at Jeenee.DataTypes.BuiltinFunctionExpression.Evaluatable.RunBatch(BatchDataContext batchDataContext, BatchArguments batchArguments)\r\n at Jeenee.DataTypes.AppEvaluatable.RunBatch(BatchDataContext batchDataContext, BatchTrace batchTrace)\r\n at System.Linq.Enumerable.WhereSelectListIterator2.MoveNext()\r\n at System.Collections.Generic.List1..ctor(IEnumerable1 collection)\r\n at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source)\r\n at Jeenee.DataTypes.AppEvaluatable.RunBatch(BatchDataContext batchDataContext, BatchTrace batchTrace)\r\n at Nirvana.Data.DataLayer.GetComputedFieldValuesBatch(Context context, IDataContext dataContext, TableData tableData, SchemaField attr, Int32 col)\r\n at Nirvana.Data.DataLayer.GetComputedFieldValues(Context context, IDataContext dataContext, TableData tableData, SchemaField attr)\r\n at Nirvana.Data.DataLayer.AugmentVirtualColumns(Context context, TableData tableData, ItemSchema tableSchema, IEnumerable1 columns, IDataContext dataContext)\r\n at Nirvana.Data.AppDataContext.AugmentDesiredVirtualColumns(TableDataCacheEntry tableDataCacheEntry, ItemSchema tableSchema, ICollection1 desiredColumnPositions, IDataContext dataContext)\r\n at Nirvana.Data.AppDataContext.AddColumnsIfNecessary(TableDataCacheEntry tableDataCacheEntry, String tableName, ItemSchema thisSchema, ICollection1 columnPositions, Boolean& addedColumns)\r\n at Nirvana.Data.AppDataContext.GetRootTableDataFromCache(String tableName, ICollection1 columnPositions, Boolean& addedColumns)\r\n at Nirvana.Data.AppDataContext.GetSliceDataFromCache(String sliceName, ICollection1 columnPositions, Boolean& addedColumns)\r\n at Nirvana.Data.AppDataContext.GetTableIndexFromCache(String tableName, ItemSchema tableSchema, ICollection1 keyColumnPositions, ICollection1 requiredVirtualColumns)\r\n at Nirvana.Data.AppDataContext.GetRowByKey(String tableName, String tableKeyValue, ICollection`1 requiredVirtualColumns)\r\n at Nirvana.Data.WorkflowActionEvaluator.GetForTableNameRow(Context context, TableRefMetaData tableRefMetaData, Change change, AppWorkflowRule appWorkflowRule, AppTemplate appTemplate)\r\n at Nirvana.Data.WorkflowActionEvaluator.GetForTableNameRows(Context context, Change change, AppWorkflowRule appWorkflowRule, AppTemplate appTemplate)\r\n at Nirvana.Data.WorkflowActionEvaluator.CreateScheduledTaskResults(Context context, TaskEvaluatorBase taskEvaluator, AppTemplate appTemplate, String tableName, Int32 columnSliceMapping, UpdateModeEnum updateMode, WorkflowLogEvent workflowLogEvent, AppWorkflowRule appWorkflowRule)\r\n at Nirvana.Data.WorkflowRuleEvaluator.InvokeRule(Context context, AppTemplate appTemplate, String tableName, Int32 columnSliceMapping, Change change, UpdateModeEnum updateMode, WorkflowLogEvent workflowLogEvent)\r\n at Nirvana.Data.WorkflowRuleEvaluator.ProcessRule(Context context, String tableName, Int32 columnSliceMapping, Change change, UpdateModeEnum updateMode, Op op)”

[Aleksi]

@Dan_Oliphant It sounds that you are using option “ForEachRowInTable” and I assume that you are doing some kind of calculation with the report. That can lead to a situation that the calculation is timing out as in this case. Please check how many rows you are triggering with the report and try to reduce that amount so you could find the reason for this behavior.

[Dan_Oliphant]

Its both, but I am running them with Slices. Most have 16 rows. That should cause this should it?

[Dan_Oliphant]

i contacted support, because these are all reports that worked up until two days ago

[Aleksi]

Okay good. As we probably need to check your app what it’s doing on the background.