Project-Accelerator icon indicating copy to clipboard operation
Project-Accelerator copied to clipboard

Published 20 hours ago • verified publisher icon OfficeDev

Importing solution Schema Bound Error

Open j9mchn opened this issue 2 years ago • 1 comments

I have an environment with Accelerator V1.0.0.3 installed. I have a custom solution I have created on top of the Accelerator solution. On attempting to install both Accelerator V1.0.0.4 and V1.0.0.5 I receive the following error: Import failed: Cannot schema bind function 'dbo.fn_UDF_170b7e9618654a6f8e1a5ed85a5c8841'. 'dbo.msdyn_ProjectRisk' is not schema bound. Could you please help me diagnose the issue?

j9mchn avatar Mar 15 '22 22:03 j9mchn

I have actually found the issue as I have had an issue importing before. The problem is that in my custom solution I am changing the calculation of field proj_costexposure to reference my custom fields in my custom solution instead. By removing that solution layer (ie changing the calculation back to the original) the new accelerator will import.
The question then remains - why can you not change a calculation if you want Accelerator upgrades?

j9mchn avatar Mar 15 '22 23:03 j9mchn