12-06-2022 12:44 PM - last edited on 05-24-2023 12:26 PM by JackLacava
Hello !
I'm facing an issue where I want to change the value in one of the cell of an SQL table editor.
The row is already there (generated via business rule), but I just want to edit a cell of this row. When I hit save, I get the message "Database update error. The wrong number of database rows were processed".
It only happens with this row that has been inserted by a business rule. I am able to change the value of all rows except this one. Also, I don't have any business rule running when I save my datatable.
Strangely, I get the same error message if I try to delete the row ...
How to solve this situation ?
Regards,
12-07-2022 06:32 AM
The rule might have left a row lock...? If you're working locally, you could try rebooting the whole environment (Onestream and SQLServer). If not, sounds like one for Support to look into.
12-10-2022 05:42 AM
Thanks Jack, you're awesome !
The error was because there was no primary keys, I have added an "ID" column as the first column on my datatable, and now I don't have this issue anymore. Something to keep in mind when working on data table !
Many thanks !
03-08-2024 01:34 PM
Sergey, Jack,
is there a workaround if the table does not have a PK? I don't have the privilege to add one.
03-09-2024 05:13 AM
In theory you could add one dynamically in the rules that retrieve and save data, although it's a lot of work.
One thing to note is that primary keys are only mentioned in documentation in relation to multi-selection; if you have that enabled, you could try renouncing that and seeing if it removes the problem.
If that's still not working, the only way is to contact Support and/or eventually file on IdeaStream.