"edit table" fails with "Could not expand rows as there are no rows with the following row IDs"

Hi appsperts!

I have an App in which I want a single column to be editable. However, when I edit an entry and then click on “save”, the toast notification says “Table saved with errors”, and in the error log of the Apps Builder tells me

Failed to update data due to an invalid argument. Details: Could not expand rows as there are no rows with the following row IDs in the original FRT: [dcc1e814-bc60-473e-be22-9749b8f5880e]

I checked this message both here and also in slack: It appeared before in the context of VDTs, but I never saw an actual solution. Does anyone have an idea what could be the issue?

The table is an ordinary table (no VDT); it contains an action column and a filter, but these do not affect the error (I tested that).

Hi @matthias.lechner ,

does the table have queries on data source or element?

1 Like

Hi @do-hwan.kim ,

yes, on both actually. Is that a blocker?

This is often the case when you create or rename columns using “custom sql” on elements or datasources.

E.g., when having something like “SELECT ugly_name123 as “Nice Name” FROM inputTable”

2 Likes