BBIS\ Cannot export list of e-mail recipients

When trying to export email recipients the following error is received:
 
12223 System.Data.SqlClient.SqlException Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. 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.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() 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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at Blackbaud.Web.Content.Core.PagedSQLReader.ExecuteDataTable() at Blackbaud.Web.Content.Portal.ScorpioGridWrapper.ExportToCSV() at Blackbaud.Web.Content.Portal.VerbToolbar.Button_Command(Object sender, CommandEventArgs e) at System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 6/28/2013 4:09:09 PM
 
This has been found in the following scenarios:
 
When trying to export ~5,000 records I get the error with Firefox on Mac OS 10.8.3, but it works in Chrome and Safari. 
 
On a PC running Windows 8 it works in Firefox.
 
When I go up to ~17,000 records it does not work in Chrome or Safari on Mac OS, but still works in Firefox on a PC. 
 
With ~150,000 records is does not work in Firefox on a PC. 
 
On both the Mac and PC I'm using the latest version of all browsers. 
 
Found the following in SQL Snaps:
 
Login: 07/02/2013 12:22:12 PM
NT User: AppPool21027P
Login name: BLACKBAUDHOST\AppPool21027P
Appliation: Blackbaud App Server
Client Host: D2PBBISEC001V
Batch issued: 12:22:12 PM
Batch SQL: 21027P_1928c95b...
Blocked on SPID 443
Batch Age: 18 seconds
SQL Started at 12:22:12 PM
SPID 463
12:22:30 PM
cmd: UPDATE
Status: suspended
 
SQL Snaps, Event Viewer Logs, Screenshot, Fiddler Trace:
\\cly-files\attachments\2013CS\11678451
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.94.1524.58
 2.94.1524, patch 82 ; 3.0.516, Service Pack 6

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.