Hello, when one of my users tries to add a new entry on the app it's giving her the error "Unable to add row to table 'Forms' -> Invalid request provided to AppSheet database".
Looking at the audit history it gives me this error in response:
Error: "ExceptionHandlerFramework.CustomerFacingException: Invalid request provided to AppSheet database\r\n at DatabaseProviders.TablesProviderUtil.ThrowCustomerFacingExceptionIfUserError(Exception e) in C:\\tmpfs\\appsheet\\Provider\\DatabaseProviders\\Tables\\TablesProviderUtil.cs:line 1264\r\n at DatabaseProviders.TablesDBProvider.InsertRows(Context context, SqlTable table, List`1 rowValues) in C:\\tmpfs\\appsheet\\Provider\\DatabaseProviders\\Tables\\TablesDBProvider.cs:line 782\r\n at DatabaseProviders.SqlTable.InsertRows(Context context, Op op, ImmutableArray`1 rows, ImmutableArray`1 colTypes) in C:\\tmpfs\\appsheet\\Provider\\DatabaseProviders\\Base\\SqlTable.cs:line 219\r\n at ProviderBase.ExternalApiProviderData.AppendRowsAsync(Context context, Op op, PhysicalSchema physicalSchema, ImmutableArray`1 colTypes, List`1 keyPositions, Boolean writeFullTable, Boolean tryUpsert, CancellationToken cancellationToken) in C:\\tmpfs\\appsheet\\Provider\\ProviderBase\\ApiBasedProvider\\ExternalApiProviderData.cs:line 721\r\n at ProviderBase.ExternalApiProviderData.AppendRowsAsync(Context context, Op op, PhysicalSchema physicalSchema, ImmutableArray`1 colTypes, List`1 keyPositions, Boolean tryUpsert, CancellationToken cancellationToken) in C:\\tmpfs\\appsheet\\Provider\\ProviderBase\\ApiBasedProvider\\ExternalApiProviderData.cs:line 228\r\n at Nirvana.Data.DataLayer.AppendTableRowsAsync(Context context, Op op, Int32 ownerId, AppTable appTable, ImmutableArray`1 colTypes, List`1 keyPositions, CancellationToken cancellationToken) in C:\\tmpfs\\appsheet\\V2API\\DataLayer\\DataAccess.cs:line 265\r\n at Nirvana.Internal.InternalAPI.AddTableRowInternalAsync(Context context, Op op, Int32 userId, Int32 executeAs, ChangeEventWorkflowRuleEvaluator changeEventWorkflowRuleEvaluator, CancellationToken cancellationToken) in C:\\tmpfs\\appsheet\\V2API\\InternalAPI\\AddDeleteUpdate.cs:line 1329\r\n at Nirvana.Internal.InternalAPI.PerformOperationAsync(Context context, Op op, Int32 userId, String appTemplateVersion, UpdateModeEnum requiredUpdateMode, RowOperationAsync rowOperation, CancellationToken cancellationToken) in C:\\tmpfs\\appsheet\\V2API\\InternalAPI\\AddDeleteUpdate.cs:line 1058\r\n at Nirvana.Internal.InternalAPI.AddTableRowAsync(Context context, Op op, Int32 userId, String appTemplateVersion, CancellationToken cancellationToken) in C:\\tmpfs\\appsheet\\V2API\\InternalAPI\\AddDeleteUpdate.cs:line 1174\r\n at AppApiHandler.AddTableRowHandler.AddTableRowInternal(IPerfCollector perfCollector, Context context, Op op, String appTemplateVersion, IQueryString queryString, CancellationToken cancellationToken) in C:\\tmpfs\\appsheet\\ControllerHandler\\AppApiHandler\\AddTableRowHandler.cs:line 290"
Any help figuring out what is causing this issue and how to fix it is much appreciated! I've tried everything I can think of.
LinkedIn
Twitter
