Error adding row to table

[entomophile]

My app was working fine.  I made some changes to a few referenced dropdowns and deleted a few bad records.  Now I get the following error message when I try to add a new record...

Unable to add row to table 'Records'. → Invalid request provided to AppSheet database

I ran the Audit Log and got the message below but it's all Greek to me.

Error: "ExceptionHandlerFramework.CustomerFacingException: Invalid request provided to AppSheet database\r\n at DatabaseProviders.TablesProviderUtil.ThrowCustomerFacingExceptionIfUserError(Exception e)\r\n at DatabaseProviders.TablesDBProvider.InsertRows(Context context, SqlTable table, List`1 rowValues)\r\n at DatabaseProviders.SqlTable.InsertRows(Context context, Op op, ImmutableArray`1 rows, ImmutableArray`1 colTypes)\r\n at ProviderBase.ExternalApiProviderData.AppendRows(Context context, Op op, PhysicalSchema physicalSchema, ImmutableArray`1 colTypes, List`1 keyPositions, Boolean writeFullTable, Boolean tryUpsert)\r\n at ProviderBase.ExternalApiProviderData.AppendRows(Context context, Op op, PhysicalSchema physicalSchema, ImmutableArray`1 colTypes, List`1 keyPositions, Boolean tryUpsert)\r\n at ProviderBase.APIBasedProvider.AppendTableRows(Context context, Op op, String name, Int32 ownerId, String userToken, PhysicalSchema physicalSchema, DataFormat fileFormat, ImmutableArray`1 colTypes, List`1 keyPositions)\r\n at Nirvana.Data.DataLayer.AppendTableRows(Context context, Op op, Int32 ownerId, AppTable appTable, ImmutableArray`1 colTypes, List`1 keyPositions)\r\n at Nirvana.Internal.InternalAPI.AddTableRowInternal(Context context, Op op, Int32 userId, Int32 executeAs, ChangeEventWorkflowRuleEvaluator changeEventWorkflowRuleEvaluator)\r\n at Nirvana.Internal.InternalAPI.PerformOperation(Context context, Op op, Int32 userId, String appTemplateVersion, UpdateModeEnum requiredUpdateMode, RowOperation rowOperation)\r\n at Nirvana.Internal.InternalAPI.AddTableRow(Context context, Op op, Int32 userId, String appTemplateVersion)\r\n at AppApiHandler.AddTableRowHandler.AddTableRowInternal(IPerfCollector perfCollector, Context context, Op op, String appTemplateVersion, IQueryString queryString)"

[SkrOYC]

---

@entomophile wrote:

AppSheet database

---

AppSheet Database is a preview feature not prepared for any production app

[Revin]

Thanks for the input. I'm hopping into the same pit right now after I've set up a field being an array of related field from another table. The same error pops up whenever the apps tries to insert a row. Luckily, the apps is only a prototype right now. Before it gets any further, I think the best way I can do right now is banning myself from using the Appsheet database and copy all the tables into google sheet manually. Jeez, I never thought Google would create a mysterious box. Have they ever considered about how much time wasted just for a disappointment like this?