The multi-part identifier V_QUERY_CONSTITUENT\Cash Supporters -Total - Cash gift within 12 months (Jan 2012) (!update manually) Smart Field.CURRENCYID" could not be bound."

Occurs when upgrading from 2.7.1654 to  2.91.1535.0

The "RunServiceRevisions" task failed unexpectedly.
Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.RevisionExecutionException: An error occurred while executing a service revision.
Revision text: ExecuteCode: Blackbaud.AppFx.Platform.ServiceRevisions.CodeRevisions1120 Rev_130_UpdateUserDefinedSmartQueriesForMulticurrency ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.LoadSpecException: Procedure Return Code: 0 ---> System.Exception: The multi-part identifier "V_QUERY_CONSTITUENT\Cash Supporters -Total - Cash gift within 12 months (Jan 2012) (!update manually) Smart Field.CURRENCYID" could not be bound. ---> System.Data.SqlClient.SqlException: A .NET Framework error occurred during execution of user-defined routine or aggregate "USP_LOADSPEC":
System.Data.SqlClient.SqlException: The multi-part identifier "V_QUERY_CONSTITUENT\Cash Supporters -Total - Cash gift within 12 months (Jan 2012) (!update manually) Smart Field.CURRENCYID" could not be bound.
System.Data.SqlClient.SqlException:
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQuerySmi(Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Blackbaud.AppFx.Platform.SqlClr.SmartQuerySpecProcessor.ProcessTvfSmartQuerySpec(SmartQuerySpec spec, Nullable`1 changeAgentID, SqlBoolean processPageAlterations)
   at Blackbaud.AppFx.Platform.SqlClr.SmartQuerySpecProcessor.ProcessSpec(SmartQuerySpec spec, Nullable`1 changeAgentID, SqlBoolean processPageAlterations)
   at Blackbaud.AppFx.Platform.SqlClr.SmartQuerySpecProcessor.ProcessSpec(String specXml, Nullable`1 changeAgentID, SqlBoolean processPageAlterations)
   at Blackbaud.AppFx.Platform.SqlClr.SmartQuerySpecCLR.ProcessSpec(SqlXml specXml, Nullable`1 changeAgentID, SqlBoolean processPageAlterations)
   at Blackbaud.AppFx.Platform.SqlClr.LoadSpec.LoadSpec(SqlXml specXml, Nullable`1 changeAgentID, SqlString sourceName, SqlString itemName, SqlBoolean loadAsDependency, SqlBoolean forceReload, SqlBoolean processPageAlterations, SqlBoolean skipValidation)
.
LOADSPEC ERROR:The multi-part identifier "V_QUERY_CONSTITUENT\Cash Supporters -Total - Cash gift within 12 months (Jan 2012) (!update manually) Smart Field.CURRENCYID" could not be bound.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.RevisionRunner.ExecuteLoadSpecAndTrapSpecialError(SqlCommand cmd)
   --- End of inner exception stack trace ---
   at Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.RevisionRunner.ExecuteLoadSpecAndTrapSpecialError(SqlCommand cmd)
   at Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.RevisionRunner.ExecuteLoadSpecProcedure(SqlConnection conn, String specXML, String assemblyName, String specResourceName, Boolean loadAsDependency, Boolean forceReload, Guid changeAgentID, Boolean skipValiation, String itemType, LoadSpecLogger logger)
   --- End of inner exception stack trace ---
   at Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.RevisionRunner.ExecuteLoadSpecProcedure(SqlConnection conn, String specXML, String assemblyName, String specResourceName, Boolean loadAsDependency, Boolean forceReload, Guid changeAgentID, Boolean skipValiation, String itemType, LoadSpecLogger logger)
   at Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.CodeRevisionBase.ExecuteLoadSpecProcedure(String specXML, String assemblyName, String specResourceName, Boolean loadAsDependency, Boolean forceReload)
   at Blackbaud.AppFx.Platform.ServiceRevisions.CodeRevisions1120.LoadSpecInternal(SqlConnection conn, String specXml)
   at Blackbaud.AppFx.Platform.ServiceRevisions.CodeRevisions1120.Rev_130_UpdateUserDefinedSmartQueriesForMulticurrency()
   --- End of inner exception stack trace ---
   at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
   at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.RevisionRunner.RunCodeRevision(Assembly assembly, String className, String methodName, Int32 revisionNumber)
   at Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.RevisionRunner.RunRevs(DBRevisions revs, Int32 startAtRevisionID, Boolean onlyLoadNonDesignerSpecs)
   --- End of inner exception stack trace ---
   at Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.RevisionRunner.RunRevs(DBRevisions revs, Int32 startAtRevisionID, Boolean onlyLoadNonDesignerSpecs)
   at Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisionsHelpers.RevisionRunner.RunLatestRevisions()
   at Blackbaud.AppFx.Platform.BuildTasks.RunServiceRevisions.Execute()
   at Microsoft.Build.BuildEngine.TaskEngine.ExecuteInstantiatedTask(EngineProxy engineProxy, ItemBucket bucket, TaskExecutionMode howToExecuteTask, ITask task, Boolean& taskResult)
Process failed.

 

Download and install the latest patch, which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch. 

Environment

 2.91.1535.0
 2.91.1535, patch 37

Was this article helpful?