BBNC: Exception Error on Email

It is interesting to note two separate failures exposed. There seems to be issues with email code handling particular export definitions A Critical bug should be created asap on Monday morning. (assuming there are no errors in the current sends) The information on the messages that were deleted should still be available to PD in the database, so it is retrieveable. Don't worry about pulling data just yet

[External Web Notes]

Belvidere Thanksgiving Test Message - Suzanne and Angela - 2

[11/11/2011 3:10:12 PM]


[11/11/2011 3:10:12 PM]


[11/11/2011 3:10:26 PM]


[11/11/2011 3:10:28 PM]

[Refreshing lists]

[11/11/2011 3:10:35 PM]

[Processing conditions]

[11/11/2011 3:10:37 PM]

[Exception] Data could not be saved.

A .NET Framework error occurred during execution of user-defined routine or aggregate "USP_LOADSPEC":

System.Data.SqlClient.SqlException: Invalid column name 'BIO_FIRSTNAME'.


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.SQLViewSpecProcessor.ProcessSpec(SQLViewSpec spec, Nullable`1 changeAgentID)

at Blackbaud.AppFx.Platform.SqlClr.SQLViewSpecProcessor.ProcessSpec(String specXml, Nullable`1 changeAgentID)

at Blackbaud.AppFx.Platform.SqlClr.SQLViewSpecCLR.ProcessSpec(SqlXml specXml, Nullable`1 changeAgentID, SqlBoolean skipValidation)

at Blackbaud.AppFx.Platform.SqlClr.LoadSpec.LoadSpe - at Blackbaud.AppFx.Server.DBErrorHandler.HandleDBError(SqlException ex, ExpectedDBExceptions definedExceptions)

at Blackbaud.AppFx.Server.DBErrorHandler.HandleDBError(SqlException ex)

at Blackbaud.AppFx.Server.DataFormSaveProcessor.ExecuteAddNewSP()

at Blackbaud.AppFx.Server.DataFormSaveProcessor.ProcessRequest()

at Blackbaud.AppFx.Server.RequestProcessor`2.GetReply()

at Blackbaud.AppFx.Server.ServiceMethods.DispatchServiceMethod(RequestProcessorBase proc, Boolean checkSecurity)

at Blackbaud.AppFx.ContentManagement.Platform.Email.Catalog.Common.CreateSQLView(String catalogItemName, String dataBaseViewName, String selectionSQL, RequestContext context)

at Blackbaud.AppFx.ContentManagement.Platform.Email.Catalog.EmailProcessor.AddMergeViewToEmailJob(EmailDataProcessorBase dataProcessor, Int32 emailJobId, String html)

at Blackbaud.AppFx.ContentManagement.Platform.Email.Catalog.EmailProcessor.ProcessConditionalEmail(EmailDataProcessorBase dataProcessor)

at Blackbaud.AppFx.ContentManagement.Platform.Email.Catalog.EmailProcessor.ProcessEmail()

Resend attetmpt #5 was successful:

The real version is now being sent

I noted there were 4 existing attempts before the #5listed above

however, in the process of retrieveing information about link #2, the user sending the email deleted the 4 prior failures.

I was able to apture the above failure for #2

I managed to retrieved a brief snippet of the exception from Email attempt #1:

Object reference not set to an instance of an object. - at Blackbaud.AppFx.Server.ExportDefinitionProcessor

Download and install the latest version and patch, if applicable. 



Was this article helpful?

Thanks for your feedback! Did this solve your issue?

Comments (optional):

Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):

Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.