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, Nullable
1 rowListAttrIndex, Int32 columnPosition, AppEvaluatable rowFilter, Nullable1 maxResults, Int32 rowListContextLevel)\r\n at Jeenee.DataTypes.ColumnSetExpression.Evaluatable.RunAndFilter(ListMetaData listTypeQualifier, IDataContext dataContext, String tableName, Nullable
1 rowListAttrIndex, Int32 colIndex, AppEvaluatable columnFilter, Boolean makeDistinct, Int32 rowListContextLevel, Nullable1 maxResults)\r\n at Jeenee.DataTypes.SelectFunction.Run(Evaluatable funcExpressionEvaluatable, IDataContext dataContext, List
1 children, List1 argumentValues)\r\n at Jeenee.DataTypes.BuiltinFunction.RunBatch(Evaluatable funcExpressionEvaluatable, BatchDataContext batchDataContext, List
1 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.List
1โฆctor(IEnumerable1 collection)\r\n at System.Linq.Enumerable.ToList[TSource](IEnumerable
1 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, Nullable
1 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](Partitioner
1 source, ParallelOptions parallelOptions, Action1 simpleBody, Action
2 bodyWithState, Action3 bodyWithStateAndIndex, Func
4 bodyWithStateAndLocal, Func5 bodyWithEverything, Func
1 localInit, Action1 localFinally)\r\n at System.Threading.Tasks.Parallel.ForEach[TSource](Partitioner
1 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, Dictionary
2 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, Nullable
1 rowListAttrIndex, Int32 columnPosition, AppEvaluatable rowFilter, Nullable1 maxResults, Int32 rowListContextLevel)\r\n at Jeenee.DataTypes.ColumnSetExpression.Evaluatable.RunAndFilter(ListMetaData listTypeQualifier, IDataContext dataContext, String tableName, Nullable
1 rowListAttrIndex, Int32 colIndex, AppEvaluatable columnFilter, Boolean makeDistinct, Int32 rowListContextLevel, Nullable1 maxResults)\r\n at Jeenee.DataTypes.SelectFunction.Run(Evaluatable funcExpressionEvaluatable, IDataContext dataContext, List
1 children, List1 argumentValues)\r\n at Jeenee.DataTypes.BuiltinFunction.RunBatch(Evaluatable funcExpressionEvaluatable, BatchDataContext batchDataContext, List
1 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.List
1โฆctor(IEnumerable1 collection)\r\n at System.Linq.Enumerable.ToList[TSource](IEnumerable
1 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, Nullable
1 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, ICollection
1 columnPositions, Boolean& addedColumns)\r\n at Nirvana.Data.AppDataContext.ColumnValues(String tableName, Nullable1 rowListAttrIndex, Int32 columnPosition, AppEvaluatable rowFilter, Nullable
1 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, Nullable
1 maxResults)\r\n at Jeenee.DataTypes.SelectFunction.Run(Evaluatable funcExpressionEvaluatable, IDataContext dataContext, List1 children, List
1 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, Nullable
1 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_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\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, Nullable
1 rowListAttrIndex, Int32 columnPosition, AppEvaluatable rowFilter, Nullable1 maxResults, Int32 rowListContextLevel)\r\n at Jeenee.DataTypes.ColumnSetExpression.Evaluatable.RunAndFilter(ListMetaData listTypeQualifier, IDataContext dataContext, String tableName, Nullable
1 rowListAttrIndex, Int32 colIndex, AppEvaluatable columnFilter, Boolean makeDistinct, Int32 rowListContextLevel, Nullable1 maxResults)\r\n at Jeenee.DataTypes.SelectFunction.Run(Evaluatable funcExpressionEvaluatable, IDataContext dataContext, List
1 children, List1 argumentValues)\r\n at Jeenee.DataTypes.BuiltinFunction.RunBatch(Evaluatable funcExpressionEvaluatable, BatchDataContext batchDataContext, List
1 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, ICollection
1 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, ICollection
1 columnPositions, Boolean& addedColumns)\r\n at Nirvana.Data.AppDataContext.GetTableIndexFromCache(String tableName, ItemSchema tableSchema, ICollection1 keyColumnPositions, ICollection
1 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, List
1 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, Nullable
1 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โ
This is clearly an AppSheet bug. Please contact Support for help with this.
Seems to have corrected itself now. Thanks for your help Steve.
User | Count |
---|---|
35 | |
35 | |
27 | |
23 | |
18 |