Apex Code Development You need to sign in to do that
Don't have an account?
"Geocodes for Billing Address" failded for 2/3 of accounts
We are facing an issue with the "Geocodes for Billing Address" Data Integration Rule. After the rule has been activated, more than 2/3 of the Accounts have been updated, but 1/3 which is still over 50k Accounts have not been updated with longitude and latitude.
The manual process over the related list works, but we cannot do that manually for such huge amount of Accounts.
We also tried some other troubleshooting that did not work:
- Dataloader update with Account ID
- Address update of accounts
- Data integration rule deactivation and activation
We also already opened a Case with SF, but didn't get a helping answer.
So we are looking for a solution that automates the process or solves the issue.
The "Status Detail" of the related list tells "A validation or trigger error prevented this record form being updated".
What would be the solution to get all accounts updated? What can we do?
Thank you!
Greetings!
I would suggest you to capture the debug logs to see the complete error message to troubleshoot the error you have provided as below:
"A validation or trigger error prevented this record form being updated".
If you can find out the Validation rule or trigger which is being running in background then you can fix the issue.
Please mark it as best answer if it helps you to fix the issue.
Thank you!
Regards,
Shirisha Pathuri
Thank you!
I have identified two validation rules that block the process and did some further investigation on it.
One approach would be to bypass the validation rule. But the profile of the user (Sys Admin) has already been excluded from both validation rules right from the beginning.
Do you have any idea how to fix the issue?
Is there maybe a possibility to set anything up that starts the manual sync process for the Accounts that are missing?
Thanks again!
Regards,
Veronika