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

http://donate.salvationarmyusa.org/AdminPage.aspx?edit=3&md=1&ctl=~%2FAdmin%2FEmail%2FEmailStatusReport.ascx&data=16826~1

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

[Created]

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

[Prepared]

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

[Processing]

[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'.

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.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:

http://donate.salvationarmyusa.org/cms/emailsummary?cid=17007&ecatid=1098&bm=-2104333699

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. 

Environment

 6.40.1535.13
 6.45.379

Was this article helpful?