Forum Discussion

Sergey's avatar
Sergey
Icon for OneStream Employee rankOneStream Employee
3 years ago

Database update error. The wrong number of database rows were processed.

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 t...
dashboards
RafaelVidal's avatar
RafaelVidal
New Contributor III
2 years ago

Sergey, Jack,

is there a workaround if the table does not have a PK? I don't have the privilege to add one. 

JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
2 years ago

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.