Took too long to process

Hi Appsheet Community,

I have an app on a mySQL database with about 25,000 rows. In order to make the app quicker, and to remove data that I don’t really need, I used the User Settings to create a date range, then set the security filter to only show rows that the date range was set to. Recently I haven’t been able to widen the date range without getting this error.

Unable to fetch app definition.

Error:Request cancelled: took too long to process: Computing a formula/n

Two questions…
Is there a better way to filter the data?
How do I figure out what formula is giving the issues when the date range is wider than say 5 months?

Audit Log Details
Action Details
Email Details
Error:
“System.AggregateException: One or more errors occurred. —> 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 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.AugmentData(Context context, AppTemplate appTemplate, String tableName, TableData tableData, ItemSchema itemSchema, Boolean keysOnly, AppErrors appErrors)\r\n at Nirvana.Data.DataLayer.GetTableData(Context context, AppTemplate appTemplate, String tableDataIdentifier, Int32 userId, AppTable appTable, ItemSchema tableSchema, UseCacheOption useCache, Boolean augmentData, AppEvaluatable filter, Nullable1 ifModifiedSinceDate, Boolean& notModified, AppErrors appErrors, Boolean ignoreSecurityFilters)\r\n at Nirvana.Internal.InternalAPI.GetTableData(Context context, AppTemplate appTemplate, AppTable appTable, Int32 userId, Boolean augmentData, AppEvaluatable filter, Nullable1 ifModifiedSince, Boolean& notModified, AppErrors appErrors)\r\n at Nirvana.source.api.AppApiController.ParallelReadTable(IPerfCollector perfCollector, Context perTableContext, Int32 thisUserId, String appTemplateName, AppTemplate appTemplate, AppTable appTable, Boolean augmentData, NameValueCollection props, AppErrors perTableAppErrors) in T:\\tmp\\tmpD68F.tmp\\jeenee\\Nirvana\\Controllers\\API\\AppApiController.cs:line 1704\r\n at Nirvana.source.api.AppApiController.<>c__DisplayClass29_0.<ParallelReadTables>b__1(AppTable appTable) in T:\\tmp\\tmpD68F.tmp\\jeenee\\Nirvana\\Controllers\\API\\AppApiController.cs:line 1593\r\n at System.Threading.Tasks.Parallel.<>c__DisplayClass17_01.b__1()\r\n at System.Threading.Tasks.Task.InnerInvokeWithArg(Task childTask)\r\n at System.Threading.Tasks.Task.<>c__DisplayClass176_0.b__0(Object )\r\n — End of inner exception stack trace —\r\n at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)\r\n at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)\r\n at System.Threading.Tasks.Parallel.ForWorker[TLocal](Int32 fromInclusive, Int32 toExclusive, ParallelOptions parallelOptions, Action1 body, Action2 bodyWithState, Func4 bodyWithLocal, Func1 localInit, Action1 localFinally)\r\n at System.Threading.Tasks.Parallel.ForEachWorker[TSource,TLocal](IEnumerable1 source, ParallelOptions parallelOptions, Action1 body, Action2 bodyWithState, Action3 bodyWithStateAndIndex, Func4 bodyWithStateAndLocal, Func5 bodyWithEverything, Func1 localInit, Action1 localFinally)\r\n at System.Threading.Tasks.Parallel.ForEach[TSource](IEnumerable1 source, ParallelOptions parallelOptions, Action1 body)\r\n at Nirvana.source.api.AppApiController.ParallelReadTables(IPerfCollector perfCollector, Context context, String appTemplateName, AppTemplate appTemplate, AppTemplate smallClone, Boolean appTemplateNotModified, NameValueCollection props) in T:\\tmp\\tmpD68F.tmp\\jeenee\\Nirvana\\Controllers\\API\\AppApiController.cs:line 1614\r\n at Nirvana.source.api.AppApiController.GetAppTemplateInternal(IPerfCollector perfCollector, Context context, String appTemplateName, Nullable1 ifModifiedSinceDate, Boolean getAllTables, NameValueCollection props, Boolean& appTemplateUnchanged) in T:\tmp\tmpD68F.tmp\jeenee\Nirvana\Controllers\API\AppApiController.cs:line 1470\r\n—> (Inner Exception #0) 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 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.AugmentData(Context context, AppTemplate appTemplate, String tableName, TableData tableData, ItemSchema itemSchema, Boolean keysOnly, AppErrors appErrors)\r\n at Nirvana.Data.DataLayer.GetTableData(Context context, AppTemplate appTemplate, String tableDataIdentifier, Int32 userId, AppTable appTable, ItemSchema tableSchema, UseCacheOption useCache, Boolean augmentData, AppEvaluatable filter, Nullable1 ifModifiedSinceDate, Boolean& notModified, AppErrors appErrors, Boolean ignoreSecurityFilters)\r\n at Nirvana.Internal.InternalAPI.GetTableData(Context context, AppTemplate appTemplate, AppTable appTable, Int32 userId, Boolean augmentData, AppEvaluatable filter, Nullable1 ifModifiedSince, Boolean& notModified, AppErrors appErrors)\r\n at Nirvana.source.api.AppApiController.ParallelReadTable(IPerfCollector perfCollector, Context perTableContext, Int32 thisUserId, String appTemplateName, AppTemplate appTemplate, AppTable appTable, Boolean augmentData, NameValueCollection props, AppErrors perTableAppErrors) in T:\\tmp\\tmpD68F.tmp\\jeenee\\Nirvana\\Controllers\\API\\AppApiController.cs:line 1704\r\n at Nirvana.source.api.AppApiController.<>c__DisplayClass29_0.<ParallelReadTables>b__1(AppTable appTable) in T:\\tmp\\tmpD68F.tmp\\jeenee\\Nirvana\\Controllers\\API\\AppApiController.cs:line 1593\r\n at System.Threading.Tasks.Parallel.<>c__DisplayClass17_01.b__1()\r\n at System.Threading.Tasks.Task.InnerInvokeWithArg(Task childTask)\r\n at System.Threading.Tasks.Task.<>c__DisplayClass176_0.b__0(Object )<—\r\n”
Properties:
{
“IfModifiedSinceDate”: “2021-03-29T13:47:02.1442961Z”,
“getAllTables”: “True”,
“syncsOnConsent”: “True”,
“isPreview”: “False”,
“apiLevel”: “2”,
“tzOffset”: “240”,
“locale”: “en-US”,
“tableTimestamps”: “{\r\n “universal_data”: “2021-03-31T13:56:11.5241753Z”,\r\n “_Per User Settings”: “2021-03-31T13:56:16.4853102Z”,\r\n “Appsheet Test Calendar”: “2021-03-31T13:56:16.4853102Z”,\r\n “onsites_do”: “2021-03-31T13:56:16.7196765Z”,\r\n “onsites_dre”: “2021-03-31T13:56:17.1132432Z”,\r\n “onsites_tc”: “2021-03-31T13:56:17.8491253Z”,\r\n “crew_dispatch”: “2021-03-31T13:56:12.9905467Z”,\r\n “active_staff”: “2021-03-31T13:55:49.0920206Z”,\r\n “crews”: “2021-03-31T13:56:11.7741825Z”,\r\n “tom_job_info”: “2021-03-31T13:55:36.6666605Z”,\r\n “nightly_dispatch”: “2021-03-31T13:56:11.4772642Z”,\r\n “trucks”: “2021-03-31T13:56:14.5765435Z”,\r\n “truck_dispatch”: “2021-03-31T13:56:13.9681072Z”,\r\n “active_trucks”: “2021-03-31T13:55:26.0133197Z”,\r\n “truck_availability”: “2021-03-31T13:55:26.5475335Z”,\r\n “task_list”: “2021-03-31T13:56:15.041404Z”,\r\n “catagory_AAR”: “2021-03-31T13:56:15.3739327Z”,\r\n “category_type”: “2021-03-31T13:56:15.5770854Z”,\r\n “move_AAR”: “2021-03-31T13:56:15.7801853Z”,\r\n “crew_file”: “2021-03-31T13:56:11.5554097Z”,\r\n “crew_category”: “2021-03-31T13:56:10.9880139Z”,\r\n “crew_cattype”: “2021-03-31T13:56:11.1803959Z”,\r\n “ManPower_Truck_Info”: “2021-03-31T13:55:15.5318322Z”,\r\n “claims”: “2021-03-31T13:56:13.2322218Z”,\r\n “home_app”: “2021-03-31T13:56:14.9217678Z”,\r\n “home_sales”: “2021-03-31T13:56:15.1239166Z”,\r\n “home_ops”: “2021-03-31T13:56:15.3895597Z”,\r\n “home_finance”: “2021-03-31T13:56:15.5770854Z”,\r\n “EstimatedCostBy_Year_Month”: “2021-03-31T13:56:15.7801853Z”,\r\n “salespeople”: “2021-03-31T13:56:16.1571708Z”,\r\n “Wufoo Resp”: “2021-03-31T13:56:10.9880139Z”,\r\n “bulletin board”: “2021-03-31T13:56:11.930433Z”,\r\n “truck_rentals”: “2021-03-31T13:56:12.7458977Z”,\r\n “crew_weekly_hours”: “2021-03-31T13:55:25.0786843Z”,\r\n “monthly_revenue”: “2021-03-31T13:55:26.122701Z”,\r\n “Claims Wufoo”: “2021-03-31T13:56:13.1853444Z”,\r\n “Jobs Calendar”: “2021-03-31T13:56:14.9842718Z”,\r\n “date_dow”: “2021-03-31T13:55:33.084464Z”,\r\n “val_dropdown”: “2021-03-31T13:55:35.161223Z”,\r\n “move_company”: “2021-03-31T13:56:16.188424Z”,\r\n “interstatedocs”: “2021-03-31T13:56:16.3602842Z”,\r\n “universal_data: Set [crew_initials] to DE Header Process Table”: “2021-03-31T13:55:35.9244337Z”\r\n}”,
“lastSyncTime”: “3/31/2021 1:56:19 PM”,
“appStartTime”: “”,
“dataStamp”: “3/31/2021 1:56:19 PM”,
“clientId”: “93fff0b6-1575-49fb-8e8f-02dfc6c7f52d”,
“build”: “e64de0cefd00aeeb50b6-1617110749208-77c2ac9”,
“hasValidPlan”: “True”,
“userConsentedScopes”: “data_input,device_identity,device_io,profile,usage”,
“localVersion”: “1.002053”,
“AppTemplateName”: “3126ca97-85b1-4502-bffd-d4782647ae94”,
“Operation”: “App sync”,
“RecordType”: “Stop”,
“Errors”: “Error:Request cancelled: took too long to process: Computing a formula/n”,
“Exception”: “System.AggregateException: One or more errors occurred. —> 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 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.AugmentData(Context context, AppTemplate appTemplate, String tableName, TableData tableData, ItemSchema itemSchema, Boolean keysOnly, AppErrors appErrors)\r\n at Nirvana.Data.DataLayer.GetTableData(Context context, AppTemplate appTemplate, String tableDataIdentifier, Int32 userId, AppTable appTable, ItemSchema tableSchema, UseCacheOption useCache, Boolean augmentData, AppEvaluatable filter, Nullable1 ifModifiedSinceDate, Boolean& notModified, AppErrors appErrors, Boolean ignoreSecurityFilters)\r\n at Nirvana.Internal.InternalAPI.GetTableData(Context context, AppTemplate appTemplate, AppTable appTable, Int32 userId, Boolean augmentData, AppEvaluatable filter, Nullable1 ifModifiedSince, Boolean& notModified, AppErrors appErrors)\r\n at Nirvana.source.api.AppApiController.ParallelReadTable(IPerfCollector perfCollector, Context perTableContext, Int32 thisUserId, String appTemplateName, AppTemplate appTemplate, AppTable appTable, Boolean augmentData, NameValueCollection props, AppErrors perTableAppErrors) in T:\\tmp\\tmpD68F.tmp\\jeenee\\Nirvana\\Controllers\\API\\AppApiController.cs:line 1704\r\n at Nirvana.source.api.AppApiController.<>c__DisplayClass29_0.<ParallelReadTables>b__1(AppTable appTable) in T:\\tmp\\tmpD68F.tmp\\jeenee\\Nirvana\\Controllers\\API\\AppApiController.cs:line 1593\r\n at System.Threading.Tasks.Parallel.<>c__DisplayClass17_01.b__1()\r\n at System.Threading.Tasks.Task.InnerInvokeWithArg(Task childTask)\r\n at System.Threading.Tasks.Task.<>c__DisplayClass176_0.b__0(Object )\r\n — End of inner exception stack trace —\r\n at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)\r\n at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)\r\n at System.Threading.Tasks.Parallel.ForWorker[TLocal](Int32 fromInclusive, Int32 toExclusive, ParallelOptions parallelOptions, Action1 body, Action2 bodyWithState, Func4 bodyWithLocal, Func1 localInit, Action1 localFinally)\r\n at System.Threading.Tasks.Parallel.ForEachWorker[TSource,TLocal](IEnumerable1 source, ParallelOptions parallelOptions, Action1 body, Action2 bodyWithState, Action3 bodyWithStateAndIndex, Func4 bodyWithStateAndLocal, Func5 bodyWithEverything, Func1 localInit, Action1 localFinally)\r\n at System.Threading.Tasks.Parallel.ForEach[TSource](IEnumerable1 source, ParallelOptions parallelOptions, Action1 body)\r\n at Nirvana.source.api.AppApiController.ParallelReadTables(IPerfCollector perfCollector, Context context, String appTemplateName, AppTemplate appTemplate, AppTemplate smallClone, Boolean appTemplateNotModified, NameValueCollection props) in T:\\tmp\\tmpD68F.tmp\\jeenee\\Nirvana\\Controllers\\API\\AppApiController.cs:line 1614\r\n at Nirvana.source.api.AppApiController.GetAppTemplateInternal(IPerfCollector perfCollector, Context context, String appTemplateName, Nullable1 ifModifiedSinceDate, Boolean getAllTables, NameValueCollection props, Boolean& appTemplateUnchanged) in T:\tmp\tmpD68F.tmp\jeenee\Nirvana\Controllers\API\AppApiController.cs:line 1470\r\n—> (Inner Exception #0) 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 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.AugmentData(Context context, AppTemplate appTemplate, String tableName, TableData tableData, ItemSchema itemSchema, Boolean keysOnly, AppErrors appErrors)\r\n at Nirvana.Data.DataLayer.GetTableData(Context context, AppTemplate appTemplate, String tableDataIdentifier, Int32 userId, AppTable appTable, ItemSchema tableSchema, UseCacheOption useCache, Boolean augmentData, AppEvaluatable filter, Nullable1 ifModifiedSinceDate, Boolean& notModified, AppErrors appErrors, Boolean ignoreSecurityFilters)\r\n at Nirvana.Internal.InternalAPI.GetTableData(Context context, AppTemplate appTemplate, AppTable appTable, Int32 userId, Boolean augmentData, AppEvaluatable filter, Nullable1 ifModifiedSince, Boolean& notModified, AppErrors appErrors)\r\n at Nirvana.source.api.AppApiController.ParallelReadTable(IPerfCollector perfCollector, Context perTableContext, Int32 thisUserId, String appTemplateName, AppTemplate appTemplate, AppTable appTable, Boolean augmentData, NameValueCollection props, AppErrors perTableAppErrors) in T:\\tmp\\tmpD68F.tmp\\jeenee\\Nirvana\\Controllers\\API\\AppApiController.cs:line 1704\r\n at Nirvana.source.api.AppApiController.<>c__DisplayClass29_0.<ParallelReadTables>b__1(AppTable appTable) in T:\\tmp\\tmpD68F.tmp\\jeenee\\Nirvana\\Controllers\\API\\AppApiController.cs:line 1593\r\n at System.Threading.Tasks.Parallel.<>c__DisplayClass17_01.b__1()\r\n at System.Threading.Tasks.Task.InnerInvokeWithArg(Task childTask)\r\n at System.Threading.Tasks.Task.<>c__DisplayClass176_0.b__0(Object )<—\r\n”,
“AppTemplateVersion”: “”,
“AppDefinitionChanged”: true,
“Performance”: “{“Version”:1,“Time”:“00:04:02.3838732”,“PerformanceTimingRoot”:{“Mid”:130,“Timer”:{“Time”:“00:04:02.3838732”},“Children”:[{“Mid”:63,“Timer”:{“Time”:“00:04:02.3822525”},“Children”:[{“Mid”:465,“Params”:{“ParamList”:[{“Pid”:31,“Value”:“3126ca97-85b1-4502-bffd-d4782647ae94”},{“Pid”:30,“Value”:“Latest”}]},“Timer”:{“Time”:“00:00:01.7376627”}},{“Mid”:244,“Timer”:{“Time”:“00:00:00.3547741”}},{“Mid”:155,“Timer”:{“Time”:“00:00:00.2883637”}},{“Mid”:117,“Params”:{“ParamList”:[{“Pid”:5,“Value”:“4”}]},“Timer”:{“Time”:“00:03:59.9999634”},“Children”:[{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“crew_category”},{“Pid”:21,“Value”:“02.28.35.878539”}]},“Timer”:{“Time”:“00:00:00.3359915”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Wufoo Resp”},{“Pid”:21,“Value”:“02.28.35.878539”}]},“Timer”:{“Time”:“00:00:00.3567353”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“bulletin board”},{“Pid”:21,“Value”:“02.28.36.235936”}]},“Timer”:{“Time”:“00:00:00.1498563”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“truck_rentals”},{“Pid”:21,“Value”:“02.28.36.376552”}]},“Timer”:{“Time”:“00:00:00.0703827”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“ManPower_Truck_Info”},{“Pid”:21,“Value”:“02.28.36.204708”}]},“Timer”:{“Time”:“00:00:00.8463572”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“crew_weekly_hours”},{“Pid”:21,“Value”:“02.28.36.454675”}]},“Timer”:{“Time”:“00:00:00.8138605”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“monthly_revenue”},{“Pid”:21,“Value”:“02.28.37.256886”}]},“Timer”:{“Time”:“00:00:00.2924007”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Claims Wufoo”},{“Pid”:21,“Value”:“02.28.37.555183”}]},“Timer”:{“Time”:“00:00:00.8631041”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“claims”},{“Pid”:21,“Value”:“02.28.37.053764”}]},“Timer”:{“Time”:“00:00:01.3617770”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“home_app”},{“Pid”:21,“Value”:“02.28.38.417454”}]},“Timer”:{“Time”:“00:00:00.0412869”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“home_sales”},{“Pid”:21,“Value”:“02.28.38.464306”}]},“Timer”:{“Time”:“00:00:00.0368809”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“home_ops”},{“Pid”:21,“Value”:“02.28.38.495552”}]},“Timer”:{“Time”:“00:00:00.0621061”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“home_finance”},{“Pid”:21,“Value”:“02.28.38.558073”}]},“Timer”:{“Time”:“00:00:00.0380954”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“EstimatedCostBy_Year_Month”},{“Pid”:21,“Value”:“02.28.38.600063”}]},“Timer”:{“Time”:“00:00:00.2366573”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Jobs Calendar”},{“Pid”:21,“Value”:“02.28.38.417454”}]},“Timer”:{“Time”:“00:00:03.3662796”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“date_dow”},{“Pid”:21,“Value”:“02.28.41.782934”}]},“Timer”:{“Time”:“00:00:00.2140501”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“salespeople”},{“Pid”:21,“Value”:“02.28.38.834393”}]},“Timer”:{“Time”:“00:00:03.2258912”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“interstatedocs”},{“Pid”:21,“Value”:“02.28.42.065628”}]},“Timer”:{“Time”:“00:00:00.1362344”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“val_dropdown”},{“Pid”:21,“Value”:“02.28.42.003134”}]},“Timer”:{“Time”:“00:00:00.2126871”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“universal_data: Set [crew_initials] to DE Header Process Table”},{“Pid”:21,“Value”:“02.28.42.190622”}]},“Timer”:{“Time”:“00:00:00.2107492”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“Appsheet Test Calendar”},{“Pid”:21,“Value”:“02.28.42.410832”}]},“Timer”:{“Time”:“00:00:00.1783503”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“move_company”},{“Pid”:21,“Value”:“02.28.42.206252”}]},“Timer”:{“Time”:“00:00:00.5918873”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“nightly_dispatch”},{“Pid”:21,“Value”:“02.28.35.878539”}]},“Timer”:{“Time”:“00:00:06.9617582”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“trucks”},{“Pid”:21,“Value”:“02.28.42.802910”}]},“Timer”:{“Time”:“00:00:00.0430854”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“truck_dispatch”},{“Pid”:21,“Value”:“02.28.42.849759”}]},“Timer”:{“Time”:“00:00:00.1367440”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“active_trucks”},{“Pid”:21,“Value”:“02.28.42.991831”}]},“Timer”:{“Time”:“00:00:00.0842812”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“onsites_do”},{“Pid”:21,“Value”:“02.28.42.582688”}]},“Timer”:{“Time”:“00:00:00.5183154”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“truck_availability”},{“Pid”:21,“Value”:“02.28.43.069953”}]},“Timer”:{“Time”:“00:00:00.0717912”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“task_list”},{“Pid”:21,“Value”:“02.28.43.148072”}]},“Timer”:{“Time”:“00:00:00.2753123”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“catagory_AAR”},{“Pid”:21,“Value”:“02.28.43.413680”}]},“Timer”:{“Time”:“00:00:00.2900053”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“onsites_dre”},{“Pid”:21,“Value”:“02.28.43.101197”}]},“Timer”:{“Time”:“00:00:00.9083868”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“onsites_tc”},{“Pid”:21,“Value”:“02.28.44.011822”}]},“Timer”:{“Time”:“00:00:01.2130251”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“crew_dispatch”},{“Pid”:21,“Value”:“02.28.45.233391”}]},“Timer”:{“Time”:“00:00:00.1487136”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“active_staff”},{“Pid”:21,“Value”:“02.28.45.374027”}]},“Timer”:{“Time”:“00:00:00.1394336”}},{“Mid”:116,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“crews”},{“Pid”:21,“Value”:“02.28.45.514629”}]},“Timer”:{“Time”:“00:00:00.0879233”}}]}]}]},“IsEmpty”:false}”,
“Result”: “Failure”
}