Below is the error that I get when I have a custom lookup field related to User on Engagement Plan object.
npsp.TDTM_EngagementPlan: execution of AfterInsert caused by: System.QueryException: No such column '' on entity 'User'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names. (System Code
It appears that the error is caused by a custom lookup field to User on the Engagement Plan object. The error message indicates that the system is unable to find the specified column on the User object.
It is possible that the field name is incorrect, or that the field has been deleted or renamed. Double-check that the field name is correct and that the field exists on the User object.
Another possibility is that the field level security for the custom lookup field is not set correctly. Ensure that the field is visible and accessible to the relevant profiles and permission sets.
If the above suggestions do not resolve the issue, it is recommended to reach out to the NPSP support team for further assistance. They can review the debug logs and provide more specific guidance on how to resolve the issue.
