Lawson user is not able to add or see bookmark they have access to
If a user is having issues seeing a bookmark in Lawson, it may be because the bookmark is a parent of itself which can cause the bookmark to not appear for users even though they have access to it.
This issue can also create an infinite child bug in the Bookmark Manager as seen below:
In the database under the table “LOBKMARK”, we see that this BOOK_MARK 272 is the parent of itself (PARENT_BKMARK is also 272).
IMPORTANT: Always be cautious when making updates to the database.
To fix BOOK_MARK 272, we need to update its PARENT_BKMARK and set it to 0.
Here is the code to do this:
UPDATE LOBKMARK SET PARENT_BKMARK = 0 where BOOK_MARK = 272 and OBJ_ID = 285
We add the OBJ_ID in there as an extra check. It’s always recommended to build and update query with a select query first so you don’t change more than what you need.