Lookup Table Error - Insufficient base table information for updating or refreshing

Modified on Fri, 13 Mar at 12:47 AM

Affects

This error can affect all users on all versions

Error

Error occurs when trying to add or edit a lookup table.

image.png

 

Resolution

In Group/User security maintenance, the user needs to be in a group with (Select and Update) access to be able to update lookup tables. The user will also need Select and Update access to SYS|LookupMaint

 

Considerations

Consider who else is within the group before giving permissions as it may benefit giving the user individual permissions rather than the whole group.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article