Loading

Update failed. First exception on row 0 with id ‘<record Id>'; first error: INSUFFICIENT_ACCESS_OR_READONLY, insufficient access rights on object id: []: Nonprofit Success Pack (NPSP)

Publiceringsdatum: Nov 5, 2024
Beskrivning
Some users of Nonprofit Success Pack (NPSP) may receive the following error "Update failed. the First exception on row 0 with id ‘<record Id>'; first error: INSUFFICIENT_ACCESS_OR_READONLY, insufficient access rights on object id: []" while using NPSP Data Import wizard. This is because they have access to only a subset of Batch Upload records.

They will also see in "Number of Data Import records to process" shows an incorrect number of records. The reason behind this is the apex class which is rendering the numeric value on the Data Import VF page which is set to public sharing and if the users only have access to a subset of import records then, it is rendering a less number of records that will actually be processed. When the user will begin the "Data Import Process" then all the records will be processed in batches instead of those whose permission has been given. Batch is an asynchronous process that runs in the background and when it's in process, we can't use any security model to filter the records.

This scenario is most likely to happen when the user wants to process only a specific Batch of Records rather than processing all the records.


 
Lösning
In NPSP, if you want to import the records using the NPSP data import wizard, you have to give access to the NPSP Data Import objects and fields to all the profiles. If the user importing the data does not have that full access such as Read, Create, Edit, and Delete then the system will give "insufficient access rights on object" error. 

In order to grant access to the NPSP Data Import object and fields:

1. In Salesforce Lightning go to the gear in the upper right and then click on Setup
and in Salesforce Classic go to Setup in the top right corner. If you can’t find setup click on the dropdown for your user.
2. In the quick find box over on the left, search for Profiles.
3. For the Profile that you want to give access to, click the name of the Profile.
4. Go to Object Settings and navigate to the NPSP Data Import object.
5. In the Object Permission section, select "Read, Create, Edit, and Delete" permissions.
6. In the Field Permissions section, select the Read Access and Edit Access checkboxes for all field names.
7. Click Save.

Note: Please check in the sharing settings the Organization-Wide Defaults(OWD) for the NPSP Data Import object is set to "Public Read/ Write."

 
Knowledge-artikelnummer

000389539

 
Laddar
Salesforce Help | Article