Smart View Error 1020043 – You do not have sufficient access to perform a lock on this database


When attempting to submit data through Smart View the following error occurs:

ERROR
———————–
Error 1020043 – You do not have sufficient access to perform a lock on this database.

STEPS
———————–
The issue can be reproduced at will with the following steps:
1. Open Excel.

2. Connect to the Essbase server using Private connection.

3. Perform Adhoc analysis.

4. Enter data and submit

 

To Fix-

Delete the security the filter in EAS for that user in the application after taking backup of the same.

Steps Followed:

1. Open EAS Console > Expand Essbase server > Expand Application > Right Click on the database > Edit > Filters.

2. Select the user from the Filter Name  and edit.

3. Take backup of the “Filter Rows” and delete Read and Write access only.

4. Save it

Log into the Planning as admin and create a security filter for that user.

Now that user can submit data from Smart View without any issue.

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s