i created a basic report that reads of a table where i added virtual columns. This worked perfectly up until Wednesday evening. As of yesterday I have been receiving the below message. I have tried redoing the report, I also went and deleted some of the virtual columns but the error persists. I need this report to run twice a day but as it is I currently have had no report for 2 days in a row now. Below is an extract of the error I receive in the audit log.
Error:
โDiagnosticFrameworkWrapper.CustomerFacingException: Request cancelled: took too long to process: Executing function batch: SELECT 280 of 432\r\n at Nirvana.Data.AppDataContext.CheckCancellation(String errorMessage) in d:\a\1\s\V2API\DataLayer\AppDataContext.cs:line 764\r\n at Jeenee.DataTypes.BuiltinFunction.RunBatch(Evaluatable funcExpressionEvaluatable, BatchDataContext batchDataContext, List1 children, BatchArguments batchArguments) in d:\\a\\1\\s\\DataTypes\\Expressions\\Functions\\FunctionRegistry.cs:line 80\r\n at Jeenee.DataTypes.BuiltinFunctionExpression.Evaluatable.runBatch(BatchDataContext batchDataContext, BatchArguments batchArguments) in d:\\a\\1\\s\\DataTypes\\Expressions\\FunctionExpression.cs:line 170\r\n at Jeenee.DataTypes.AppEvaluatable.RunBatch(BatchDataContext batchDataContext, BatchTrace batchTrace) in d:\\a\\1\\s\\DataTypes\\Expressions\\AppEvaluatable.cs:line 336\r\n at Nirvana.Data.DataLayer.GetComputedFieldValuesBatch(Context context, IDataContext dataContext, TableData tableData, SchemaField attr, Int32 col) in d:\\a\\1\\s\\V2API\\DataLayer\\VirtualColumns.cs:line 375\r\n at Nirvana.Data.DataLayer.GetComputedFieldValues(Context context, IDataContext dataContext, TableData tableData, SchemaField attr) in d:\\a\\1\\s\\V2API\\DataLayer\\VirtualColumns.cs:line 342\r\n at Nirvana.Data.DataLayer.AugmentVirtualColumns(Context context, TableData tableData, ItemSchema tableSchema, IEnumerable1 columns, IDataContext dataContext) in d:\a\1\s\V2API\DataLayer\VirtualColumns.cs:line 264\r\n at Nirvana.Data.AppDataContext.augmentDesiredVirtualColumns(TableDataCacheEntry tableDataCacheEntry, ItemSchema tableSchema, ICollection1 desiredColumnPositions, IDataContext dataContext) in d:\\a\\1\\s\\V2API\\DataLayer\\AppDataContext.cs:line 877\r\n at Nirvana.Data.AppDataContext.addColumnsIfNecessary(TableDataCacheEntry tableDataCacheEntry, String tableName, ItemSchema thisSchema, ICollection1 columnPositions, Boolean& addedColumns) in d:\a\1\s\V2API\DataLayer\AppDataContext.cs:line 891\r\n at Nirvana.Data.AppDataContext.GetRootTableDataFromCache(String tableName, ICollection1 columnPositions, Boolean& addedColumns) in d:\\a\\1\\s\\V2API\\DataLayer\\AppDataContext.cs:line 977\r\n at Nirvana.Data.AppDataContext.GetTableIndexFromCache(String tableName, ItemSchema tableSchema, ICollection1 keyColumnPositions, ICollection1 requiredVirtualColumns) in d:\\a\\1\\s\\V2API\\DataLayer\\AppDataContext.cs:line 1124\r\n at Nirvana.Data.AppDataContext.GetRowByKey(String tableName, String tableKeyValue, ICollection1 requiredVirtualColumns) in d:\a\1\s\V2API\DataLayer\AppDataContext.cs:line 701\r\n at Nirvana.Data.TemplateExcel.Replace(Context context, WorkflowTemplateBindContext bindContext, String tableName, Boolean compatibilityMode, Int32 columnSliceMapping, Change change, AppDataContext appDataContext, UpdateModeEnum updateMode, EmailExpressions emailExpressions, Templates templates, AppErrors appErrors) in d:\a\1\s\V2API\Workflow\Template\TemplateExcel\TemplateExcel.cs:line 33\r\n at Nirvana.Data.TemplateExcel.Replace(Context context, WorkflowTemplateBindContext bindContext, String tableName, Boolean compatibilityMode, Int32 columnSliceMapping, Change change, UpdateModeEnum updateMode, EmailExpressions emailExpressions, Templates templates, AppErrors appErrors) in d:\a\1\s\V2API\Workflow\Template\TemplateExcel\TemplateExcel.cs:line 204\r\n at Nirvana.Data.Templates.Replace(Context context, WorkflowTemplateBindContext bindContext, String tableName, Int32 columnSliceMapping, Change change, UpdateModeEnum updateMode, EmailExpressions emailExpressions, AppErrors appErrors) in d:\a\1\s\V2API\Workflow\Template\TemplateCommon\Templates.cs:line 74\r\n at Nirvana.Data.WorkflowTemplate.Replace(Context context, Int32 columnSliceMapping, Change change, UpdateModeEnum updateMode, EmailExpressions emailExpressions, AppErrors appErrors) in d:\a\1\s\V2API\Workflow\Template\WorkflowTemplate\WorkflowTemplate.cs:line 686\r\n at Nirvana.Data.WorkflowActionEmail.GetAttachment(Context context, String tableName, Int32 columnSliceMapping, Change change, UpdateModeEnum updateMode, EmailExpressions emailExpressions, AppErrors appErrors) in d:\a\1\s\V2API\Workflow\Action\WorkflowActionEmail.cs:line 228\r\n at Nirvana.Data.WorkflowActionEmail.Create(Context context, String tableName, Int32 columnSliceMapping, Change change, UpdateModeEnum updateMode, ActionDefinition actionDefinition, WorkflowLogEvent workflowLogEvent) in d:\a\1\s\V2API\Workflow\Action\WorkflowActionEmail.cs:line 49\r\n at Nirvana.Data.WorkflowRuleEvaluator.CreateActionResults(Context context, WorkflowActionBase workflowAction, AppTemplate appTemplate, String tableName, Int32 columnSliceMapping, Change change, UpdateModeEnum updateMode, WorkflowLogEvent workflowLogEvent) in d:\a\1\s\V2API\Workflow\Evaluators\WorkflowRuleEvaluator.cs:line 126\r\n at Nirvana.Data.WorkflowRuleEvaluator.PerformActions(Context context, AppTemplate appTemplate, String tableName, Int32 columnSliceMapping, Change change, UpdateModeEnum updateMode, WorkflowLogEvent workflowLogEvent) in d:\a\1\s\V2API\Workflow\Evaluators\WorkflowRuleEvaluator.cs:line 355\r\n at Nirvana.Data.WorkflowRuleEvaluator.ProcessRule(Context context, String tableName, Int32 columnSliceMapping, Change change, UpdateModeEnum updateMode) in d:\a\1\s\V2API\Workflow\Evaluators\WorkflowRuleEvaluator.cs:line 492โ
LinkedIn
Twitter
