Sql Exceptions - General Discussion

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

Home All Forums

1
2
3
4
5

10/29/2007 11:27 AM

Joined: 1/1/0001

Posts: 0

Sql Exceptions

Hi,

I'm having problems with my DotNetNuke site (4.5.3) - I'm getting a lot of exceptions, particularly when the page structure is being edited. The exception information in event viewer is as follows:

Exception type: SqlException
Exception message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

and:

Exception type: SqlException
Exception message: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

Has anyone experienced similar problems or have any suggestions?

Thanks

10/29/2007 1:31 PM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: Sql Exceptions

this looks like communication issues between web server and database server, maybe due to missing resources of the db server or due to a slow connection in between.

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

10/30/2007 11:07 AM

Joined: 1/1/0001

Posts: 0

Re: Sql Exceptions

Hi,

Thanks for the reply, however there are other sites on the servers which are fine so I don't think it's communication problems.

Any other ideas?

10/30/2007 12:22 PM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: Sql Exceptions

I suggest that you try to clean sitelog and eventlog, by executing the following commands in Host :: SQL menu item:

Truncate Table {databaseOwner}{objectQualifier}SiteLog

Truncate Table {databaseOwner}{objectQualifier}EventLog

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

Page 1 of 1

These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

DNN Corp. (DotNetNuke)