Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

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
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsStoreStoreDNN 4.9 Store Module Run Time error DNN 4.9 Store Module Run Time error
Previous
 
Next
New Post
2/27/2011 9:16 AM
 
Subhash Kamath

Joined: 9/4/2006
Posts: 9
Hello Giles, and DNN Store Team,

I am on Dnn 4.9 and the Store Module available then.

My DNN site is hosted on a shared hosting which allows only limited connections to the Database.
The site had been running fine for the past 3 years however lately it has suddenly been facing problems
when we access the Products Catalog ( Not edit mode).

The Event log shows the following dump

<LogProperties><LogProperty><PropertyName>AssemblyVersion</PropertyName><PropertyValue>04.09.00</PropertyValue></LogProperty><LogProperty><PropertyName>PortalID</PropertyName><PropertyValue>0</PropertyValue></LogProperty><LogProperty><PropertyName>PortalName</PropertyName><PropertyValue>Modest Office</PropertyValue></LogProperty><LogProperty><PropertyName>UserID</PropertyName><PropertyValue>-1</PropertyValue></LogProperty><LogProperty><PropertyName>UserName</PropertyName><PropertyValue /></LogProperty><LogProperty><PropertyName>ActiveTabID</PropertyName><PropertyValue>56</PropertyValue></LogProperty><LogProperty><PropertyName>ActiveTabName</PropertyName><PropertyValue>Products</PropertyValue></LogProperty><LogProperty><PropertyName>RawURL</PropertyName><PropertyValue>/Products/tabid/56/CategoryID/1/Default.aspx</PropertyValue></LogProperty><LogProperty><PropertyName>AbsoluteURL</PropertyName><PropertyValue>/Default.aspx</PropertyValue></LogProperty><LogProperty><PropertyName>AbsoluteURLReferrer</PropertyName><PropertyValue>http://modestoffice.com/Products/tabid/56/CategoryID/1/Default.aspx</PropertyValue></LogProperty><LogProperty><PropertyName>UserAgent</PropertyName><PropertyValue>Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)</PropertyValue></LogProperty><LogProperty><PropertyName>DefaultDataProvider</PropertyName><PropertyValue>DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider</PropertyValue></LogProperty><LogProperty><PropertyName>ExceptionGUID</PropertyName><PropertyValue>e2e8b273-0d92-4647-a328-a98c7c422d44</PropertyValue></LogProperty><LogProperty><PropertyName>InnerException</PropertyName><PropertyValue>A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)</PropertyValue></LogProperty><LogProperty><PropertyName>FileName</PropertyName><PropertyValue /></LogProperty><LogProperty><PropertyName>FileLineNumber</PropertyName><PropertyValue>0</PropertyValue></LogProperty><LogProperty><PropertyName>FileColumnNumber</PropertyName><PropertyValue>0</PropertyValue></LogProperty><LogProperty><PropertyName>Method</PropertyName><PropertyValue>DotNetNuke.Modules.Store.Components.StoreControlBase.OnLoad</PropertyValue></LogProperty><LogProperty><PropertyName>StackTrace</PropertyName><PropertyValue /></LogProperty><LogProperty><PropertyName>Message</PropertyName><PropertyValue>DotNetNuke.Services.Exceptions.PageLoadException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) ---&gt; System.Exception: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
   at DotNetNuke.Modules.Store.Components.StoreControlBase.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   --- End of inner exception stack trace ---</PropertyValue></LogProperty><LogProperty><PropertyName>Source</PropertyName><PropertyValue /></LogProperty></LogProperties>


and DNN returns the following error 

Logon failed for login 'xxxxx' due to trigger execution.
Changed database context to 'XXXXXX'. Changed language setting to us_english.

The host says that the number of connections are exceeding those allotted.

I am not seeing any large number of hits on the site however this problem has started.

Even clicking on a category link once leads to this error.

What is the problem.
Please help me resolve this problem.


Thanks and Regards
Subhash

 
New Post
2/27/2011 11:48 AM
 
Gilles Le Pigocher


Joined: 10/11/2003
Posts: 1966
Hi Subhash,

It's probably because you use an old Store module prior to version 02.01.36 with a bug in the tax provider. At the minimum, you should use the version 02.01.36 or the last 03.00.00 available at Codeplex.

Gilles
We (team members) are Humans offering their knowledge, their work and their spare time FOR FREE to benefit the community. It would be so particularly appreciated that your messages begin with "Hello" and end with "Thank you" or any other form of politeness. Ask yourself what your reaction would be, if you were approached by me (a total stranger) on the street to ask you something without saying "Hello" nor "Thank you"? After several years of services dedicated to the community, I begin to be tired to read requests without any form of politeness.
 
New Post
2/28/2011 1:22 AM
 
Subhash Kamath

Joined: 9/4/2006
Posts: 9
Dear Giles,

Thanks for the very prompt reply. Would this problem happen even if no change has been made to the store settings.

Secondly.: I am unable to login as Host to DNN due to another error which too was not there till recently.
Seems both problems have cropped u simultaneously.

Because of the login problem I am unable to release the new modules suggested by you thru the DNN interface.

Is there any other way that i can do the upgrade e.g. Manually. What will be the procedure.
Your guidance is highly appreciated.
The new additions of SEO are also something I wanted for a long time.

Thanks & Regards
Subhash
 
New Post
2/28/2011 1:37 PM
 
Gilles Le Pigocher


Joined: 10/11/2003
Posts: 1966
Hi Subhash,

Yes this problem can happen without change the Store settings. The bug is related to a connection not closed in the Tax provider. You probably have more visits than before and now the bug crash your web site most frequently.

You problem about the login is not related, could you provide me more informations about that? Are you able to login to your website with another account (admin)? Is it related to the host password? Did you apply changes into the web config and changed the machine keys? Do you have an error message?

It's very difficult to upgrade a module 'by hand' and it's prone to a lot of problems! Don't complains if you fail and are no longer able to run your website! I DO NOT recommend to do that!

You need an access to the root folder of your website by ftp AND a direct access to the SQL Server instance hosting your database.

Steps to upgrade the module:

- First you NEED a backup of both the database AND the website root folder (including subfolders off course)!
- Second you NEED to install a DNN instance and the SAME currently used Store module version to your personal computer.
- After you have to upgrade your local instance with the new Store module version, this will allow you to obtain an updated ...\DesktopModules\Store folder and the new Store dll set inside the bin folder.
- Now you have to delete all the files in the remote ...\DesktopModules\Store folder, then upload the local updated folder into the remote folder.
- Upload the DotNetNuke.Modules.Store.*.dll set from the local bin folder to the remote bin folder.

This is the first part and the more simple one, now you have to upgrade your database. You have to remember if the db account used is a dbo and if you have defined a table prefix when you have installed your DNN instance. Inside you local folder ...\DesktopModules\Store\Providers\DataProviders\SqlDataProvider you have several XX.YY.ZZ.SqlDataProvider files, those files upgrade your db structure. XX.YY.ZZ is the version number of the Store module, you have to apply each file one by one from the version just after the currently used Store module version to the last file. As a sample, if your currently used Store module version is 02.01.00, you have to apply each file from 02.01.05 to 02.01.46!

Steps to upgrade your db:

1) Connect to your SQL Server instance
2) Open the .SqlDataProvider file with notepad
3) Insert to the first line: USE YourDatabaseName
4) Search and replace all {databaseOwner} by dbo. (don't forget the DOT!) if your db account is a dbo or replace them by an empty string otherwise.
5) Search and replace all {objectQualifier} by the table prefix you defined at install.
6) Copy all the text and paste it to a new request.
7) Run this new request.
8) Repeat from step 2 for each file.

Gilles
We (team members) are Humans offering their knowledge, their work and their spare time FOR FREE to benefit the community. It would be so particularly appreciated that your messages begin with "Hello" and end with "Thank you" or any other form of politeness. Ask yourself what your reaction would be, if you were approached by me (a total stranger) on the street to ask you something without saying "Hello" nor "Thank you"? After several years of services dedicated to the community, I begin to be tired to read requests without any form of politeness.
 
New Post
2/28/2011 2:24 PM
 
Subhash Kamath

Joined: 9/4/2006
Posts: 9
Dear Giles,

Thanks very much once again for the very kind and prompt reply.

I guess the bug described by you is the one faced by me. Earlier the host was providing more connections.
However now they have reduced the number of connections allotted ,  also the site may be experiencing more hits.

I will try to follow the manual installation method if I cannot login as administrator.
Does the Upgarde through the DNN interface write any files to the web root folder. If that is the case then also i will have to do manual
install as the web root does not have Write access unless done via ftp.
Do i require to make any changes apart from the ones you specified e.g web.config. or any existing xml resource files etc.

I will continue running DNN 4.9 , hope that is not a problem ?

Login Problem
I am logging as host which is the ultimate account.
I haven't installed DNN as dbo , but all this while there was no problem and we have edited the site several times.
The error I get is    :
   A critical error has occurred.
  Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

I know this is not related to the store module. But still hoping to get a resolution to it.

Thanks & Regards
Subhash
 
 Page 1 of 3
123Next 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsStoreStoreDNN 4.9 Store Module Run Time error DNN 4.9 Store Module Run Time error


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:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. 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.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out