Error Message 11-15-2021

[James_Fussell]

I am getting the following error on Sync. Is this a bug?

Error: “System.AggregateException: One or more errors occurred. —> DiagnosticFrameworkWrapper.CustomerFacingException: Error: Data table ‘SOPProducts’ is not accessible due to: The service is currently unavailable…\r\n at Nirvana.Data.AppDataContext.GetRootTableDataFromCache(String tableName, ICollection1 columnPositions, Boolean& addedColumns)\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(Context perTableContext, Int32 thisUserId, String appTemplateName, AppTemplate appTemplate, AppTable appTable, Boolean augmentData, String tableTimestampsFromClient, TableParams tableParamsFromClient, AppErrors perTableAppErrors, DataFormat desiredFormat) in T:\tmp\tmp636.tmp\jeenee\Nirvana\Controllers\API\AppApiController.cs:line 2001\r\n at Nirvana.source.api.AppApiController.<>c__DisplayClass40_0.b__2(AppTable appTable) in T:\tmp\tmp636.tmp\jeenee\Nirvana\Controllers\API\AppApiController.cs:line 1841\r\n at System.Threading.Tasks.Parallel.<>c__DisplayClass42_02.<PartitionerForEachWorker>b__1()\r\n at System.Threading.Tasks.Task.InnerInvokeWithArg(Task childTask)\r\n at System.Threading.Tasks.Task.<>c__DisplayClass176_0.<ExecuteSelfReplicating>b__0(Object <p0>)\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.PartitionerForEachWorker[TSource,TLocal](Partitioner1 source, ParallelOptions parallelOptions, Action1 simpleBody, Action2 bodyWithState, Action3 bodyWithStateAndIndex, Func4 bodyWithStateAndLocal, Func5 bodyWithEverything, Func1 localInit, Action1 localFinally)\r\n at System.Threading.Tasks.Parallel.ForEach[TSource](Partitioner1 source, ParallelOptions parallelOptions, Action1 body)\r\n at Nirvana.source.api.AppApiController.ParallelReadTables(IPerfCollector perfCollector, Context context, String appTemplateName, AppTemplate appTemplate, AppTemplate smallClone, String tableTimestampsFromClient, Dictionary2 perTableParamsFromclient, DataFormat desiredFormat) in T:\tmp\tmp636.tmp\jeenee\Nirvana\Controllers\API\AppApiController.cs:line 1869\r\n at Nirvana.source.api.AppApiController.ExecuteSyncRequest(IPerfCollector perfCollector, Context context, AppSyncRequest request) in T:\tmp\tmp636.tmp\jeenee\Nirvana\Controllers\API\AppApiController.cs:line 1694\r\n—> (Inner Exception #0) DiagnosticFrameworkWrapper.CustomerFacingException: Error: Data table ‘SOPProducts’ is not accessible due to: The service is currently unavailable…\r\n at Nirvana.Data.AppDataContext.GetRootTableDataFromCache(String tableName, ICollection1 columnPositions, Boolean& addedColumns)\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(Context perTableContext, Int32 thisUserId, String appTemplateName, AppTemplate appTemplate, AppTable appTable, Boolean augmentData, String tableTimestampsFromClient, TableParams tableParamsFromClient, AppErrors perTableAppErrors, DataFormat desiredFormat) in T:\tmp\tmp636.tmp\jeenee\Nirvana\Controllers\API\AppApiController.cs:line 2001\r\n at Nirvana.source.api.AppApiController.<>c__DisplayClass40_0.b__2(AppTable appTable) in T:\tmp\tmp636.tmp\jeenee\Nirvana\Controllers\API\AppApiController.cs:line 1841\r\n at System.Threading.Tasks.Parallel.<>c__DisplayClass42_02.<PartitionerForEachWorker>b__1()\r\n at System.Threading.Tasks.Task.InnerInvokeWithArg(Task childTask)\r\n at System.Threading.Tasks.Task.<>c__DisplayClass176_0.<ExecuteSelfReplicating>b__0(Object <p0>)<---\r\n\r\n---> (Inner Exception #1) DiagnosticFrameworkWrapper.CustomerFacingException: Error: Data table 'SOPProducts' is not accessible due to: The service is currently unavailable..\r\n at Nirvana.Data.AppDataContext.GetRootTableDataFromCache(String tableName, ICollection1 columnPositions, Boolean& addedColumns)\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 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(Context perTableContext, Int32 thisUserId, String appTemplateName, AppTemplate appTemplate, AppTable appTable, Boolean augmentData, String tableTimestampsFromClient, TableParams tableParamsFromClient, AppErrors perTableAppErrors, DataFormat desiredFormat) in T:\\tmp\\tmp636.tmp\\jeenee\\Nirvana\\Controllers\\API\\AppApiController.cs:line 2001\r\n at Nirvana.source.api.AppApiController.<>c__DisplayClass40_0.<ParallelReadTables>b__2(AppTable appTable) in T:\\tmp\\tmp636.tmp\\jeenee\\Nirvana\\Controllers\\API\\AppApiController.cs:line 1841\r\n at System.Threading.Tasks.Parallel.<>c__DisplayClass42_02.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\r\n—> (Inner Exception #2) DiagnosticFrameworkWrapper.CustomerFacingException: Error: Data table ‘SOPProducts’ is not accessible due to: The service is currently unavailable…\r\n at Nirvana.Data.AppDataContext.GetRootTableDataFromCache(String tableName, ICollection1 columnPositions, Boolean& addedColumns)\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 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.GetTableIndexFromCache(String tableName, ItemSchema tableSchema, ICollection1 keyColumnPositions, ICollection1 requiredVirtualColumns)\r\n at Nirvana.Data.AppDataContext.GetRowByKey(String tableName, String tableKeyValue, ICollection1 requiredVirtualColumns)\r\n at Nirvana.Data.AppDataContext.RefRowValue(String tableName, String tableKeyValue, Int32 refColumnPosition)\r\n at Jeenee.DataTypes.DeRefExpression.Evaluatable.Run(IDataContext dataContext, List1 childValues)\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 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(Context perTableContext, Int32 thisUserId, String appTemplateName, AppTemplate appTemplate, AppTable appTable, Boolean augmentData, String tableTimestampsFromClient, TableParams tableParamsFromClient, AppErrors perTableAppErrors, DataFormat desiredFormat) in T:\tmp\tmp636.tmp\jeenee\Nirvana\Controllers\API\AppApiController.cs:line 2001\r\n at Nirvana.source.api.AppApiController.<>c__DisplayClass40_0.b__2(AppTable appTable) in T:\tmp\tmp636.tmp\jeenee\Nirvana\Controllers\API\AppApiController.cs:line 1841\r\n at System.Threading.Tasks.Parallel.<>c__DisplayClass42_0`2.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”

[Steve]

This is clearly an AppSheet bug. Please contact Support for help with this.

https://www.appsheet.com/Support/Contact

[James_Fussell]

Seems to have corrected itself now. Thanks for your help Steve.