SQL Error after sending a large mailing - Data Springs Inc. - DotNetNuke Modules - DotNetNuke Module Product Forums - Product Discussion - DotNetNuke Modules

| |

Home

This feature requires the Standard edition. You are running the Trial edition or your site domain is not associated with your license key. Please visit www.packflash.com to purchase an upgrade or add your domain.
Products
This feature requires the Standard edition. You are running the Trial edition or your site domain is not associated with your license key. Please visit www.packflash.com to purchase an upgrade or add your domain.
- Mobile Applications
  
  Data Springs Forum iPAD app
  
  Forum Flow
  
  Opt In Text
- DNN Modules
  
  The Collection 6.0
  
  The User Management Suite
  
  Dynamic Forms
  
  Dynamic Registration
  
  Dynamic Login
  
  Dynamic Views
  
  Dynamic User Directory
  
  Dynamic Contacts
  
  Dynamic Image Rotator
  
  News Ticker
  
  Opt In Email
  
  Opt In Text
  
  Quick Poll
  
  Dynamic Info Cube
  
  Random Rounded Images
  
  Stock Quote
  
  Back on Track
  
  Dynamic News Ticker
  
  Dynamic Tags
  
  Interactive User Import
  
  Page Tags
  
  Presentation Archive
  
  Real Estate Listing
  
  Renewal Reminder
  
  Tailored Text / HTML
Services

This feature requires the Standard edition. You are running the Trial edition or your site domain is not associated with your license key. Please visit www.packflash.com to purchase an upgrade or add your domain.
Get Quote
This feature requires the Standard edition. You are running the Trial edition or your site domain is not associated with your license key. Please visit www.packflash.com to purchase an upgrade or add your domain.
- Request Quote For
  
  Custom DotNetNuke Module Quote
  
  Web Design Quote
  
  Software Outsourcing
  
  SharePoint Web Parts
  
  Mobile Programming
  
  Custom Software
Support
This feature requires the Standard edition. You are running the Trial edition or your site domain is not associated with your license key. Please visit www.packflash.com to purchase an upgrade or add your domain.
- Community Support The Data Springs Product Forums is an excellent resource where you can find solutions to questions previously encountered by other users. Each product has its own category to help you narrow your search. It also offers forums for enhancement requests, user guides and general information.
- Training Data Springs can offer additional training through our Premium Support hours. The training classes can either be held onsite or via web meetings which can be organized according to your preferences.
- Standard Support Data Springs strives to deliver excellent support for our customers. There are multiple ways of accessing support that are outlined below.
  
  Product Support Agreement
  
  Common Support Questions
  
  User Guides
  
  Upgrade Policy
  
  License Options
  
  Contact Support
- Product Demonstrations
  
  Dynamic Forms Tutorials
  
  SharePoint Web Parts Demonstrations
  
  Dynamic Login w/ Content Localization
  
  Opt In Email w/ Content Localization
  
  Dynamic User Directory
- Premium Support Premium Support is offered for additional requirements beyond what is covered in Standard Support. Find out more details below...
  
  Premium Support Options
  
  Premium Hourly Support
  
  Premium Monthly Support
  
  Premium Quarterly Support
  
  Misc Payments Form
Resources
This feature requires the Standard edition. You are running the Trial edition or your site domain is not associated with your license key. Please visit www.packflash.com to purchase an upgrade or add your domain.
- Beta Springs Beta Springs is a web site dedicated to quality control and improvement of the Data Springs products. Please visit this site and request access to setup and test any product specific issue or to review fully functional products before purchase.
- Other Resources
  
  Recommended Vendors
  
  Clothing / Apparel
- RESX Localization Translation RESX Translate is an easy to use service for providing translation services within Visual Studio and ASP.NET resources files (.RESX Extension).
- RESX Localization Spell Checker RESX Spell Check is an easy to use service for providing spell check services within Visual Studio and ASP.NET resources files (.RESX Extension).
- Articles & Information
  
  SQL Performance/Code Security Articles
  
  Moss 2007/ 2010 Articles
  
  Ajax AspDotNet JQuery Articles
  
  Drupal Wordpress and Joomla Articles
  
  SQL Server Visual Studio Articles
  
  Android / iPhone / Mobile Articles
  
  Internet Marketing Articles
  
  DotNetNuke Articles
  
  HTML 5 Getting Started w/ HTML 5
News
This feature requires the Standard edition. You are running the Trial edition or your site domain is not associated with your license key. Please visit www.packflash.com to purchase an upgrade or add your domain.
- In the Press Check out recent press releases for Data Springs products, events, and media relations.
- Blog An online diary and web log from staff and customers for premium DotNetNuke resources, Data Springs Modules, SharePoint Web Parts, Forum Flow, iPhone/Android Mobile Apps, and Data Springs Services.
- Newsletter Get current news and events the easy way! Select the newsletters you would like to receive or enter your email address to view/modify your subscription settings.
Training

This feature requires the Standard edition. You are running the Trial edition or your site domain is not associated with your license key. Please visit www.packflash.com to purchase an upgrade or add your domain.

Great Ideas. Always Flowing.

We are not happy until you are happy. Client satisfaction guaranteed. Whatever your needs and requirements, we have the skills and resources for the job!

Quick login...




Or... now make it easy with Facebook Integration

Top Sellers

Dynamic Registration 4.0

Frustrated over the lack of customization for your user's registration fields? Dynamically setup your DNN Portal with custom registration fields, layout, questions, and other core integration options......

Ultra Video Gallery 4

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to upload videos in various format and automatically encode them to flv or H264 format, you also can add videos from internet or record live videos from your webcam.

XMod Pro 2.7 - Forms and Views for Databases

Build high performance, completely customizable data-entry forms and views driven by your DNN and external databases. New built-in tools make it a snap to quickly create data entry forms, data views, and even database tables. Plus, add your own HTML, CSS, Javascript, SQL commands, stored procedures,

Smith Shopping Cart v3.88

The most advanced DotNetNuke shopping cart on the planet. Easy to use e-Commerce, Secure Shopping Cart Software and SEO friendly. B2C / B2B Ecommerce Sites.

Event Calendar and Registration 4.0

One stop solution for events calendar and events registration! FREE DOWNLOAD is available now!

DNN Modules

Dynamic Forms

Dynamic Login

Dynamic Registration

Dynamic User Directory

Dynamic Views

Dynamic Image Rotator

Dynamic News Ticker

Info Pics

Interactive User Import

Page Tags

News Ticker

Opt In Email

Presentation Archive

Quick Poll

Random Rounded Images

Real Estate

Stock Quote Module

Testimonials

Dynamic Tags

Tailored Text / HTML

Dynamic Info Cube

Back on Track

Dynamic Contacts

Forums > Product Discussion - DotNetNuke Modules > Opt In Email

SQL Error after sending a large mailing

Last Post 01-28-2014 05:01 PM by Benjamin Perez. 0 Replies.

Sort:

Check this box to subscribe to this topic.	Prev Next
You are not authorized to post a reply.

Author

Messages

Benjamin Perez User is Offline

going with the flow
Posts:55
Avatar

01-28-2014 05:01 PM
I have been seding newsletters with the Opt-in module for a while now. I have noticed that after sending a large distribution (23k + emails) I see the following error on the "View Log Results" Opt in Email Schedule failed. 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.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) 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.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at Dataspring.DNN.Modules.OptInAdvanceEmail.SqlDataProvider.GetPendingOptInPreviousDistribution(Guid id, Guid catid) at Dataspring.DNN.Modules.OptInAdvanceEmail.OptInEmailController.GetPendingPreviousDistributionByNewsletterID(Guid PreviousNewsLetterID, Guid catid) at Dataspring.DNN.Modules.OptInAdvanceEmail.SendNewsletters.SendNewsletters() at Dataspring.DNN.Modules.OptInAdvanceEmail.SendNewsletters.DoWork() at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) 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.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at Dataspring.DNN.Modules.OptInAdvanceEmail.SqlDataProvider.GetPendingOptInPreviousDistribution(Guid id, Guid catid) at Dataspring.DNN.Modules.OptInAdvanceEmail.OptInEmailController.GetPendingPreviousDistributionByNewsletterID(Guid PreviousNewsLetterID, Guid catid) at Dataspring.DNN.Modules.OptInAdvanceEmail.SendNewsletters.SendNewsletters() at Dataspring.DNN.Modules.OptInAdvanceEmail.SendNewsletters.DoWork()

You are not authorized to post a reply.

Forums > Product Discussion - DotNetNuke Modules > Opt In Email

Join our mailing list...

Get current news and events the easy way


First Name
	*
Last Name
	*
Email Address
	*	*

Subscribe Me

Recent Blogs...

SQL Server Indexes

SQL Driven Queries for Combo Boxes, Radio Buttons, Listboxes, and Checkbox Groups

Sell Modules and Skins? Setting up DotNetNuke Store w/ Google Analytics and Ecommerce Tracking

HTTP Silent Post with Dynamic Registration

HTTP Silent Post With Captcha Control

Dynamic Registration -> Dynamic User Directory / Dynamic Forms -> Dynamic Views differences

DNN Modules

Twitter Facebook Linkedin