Products

Solutions

Resources

Partners

Community

Blog

About

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 ForumsReportsReportsMissing {databaseOwner} Statements in all SqlDataProvidersMissing {databaseOwner} Statements in all SqlDataProviders
Previous
 
Next
New Post
5/27/2007 10:03 PM
 

In the new Version of Reports Module 04.05.02 and before there are missing the most {databaseOwner} statements.  so this Module is not funktunaly for users with other databaseOwner then 'dbo'.

Please make an update and set the correct {databaseOwner} statements on all calls of a table in the spocs.

Thanks

Matthias

 
New Post
5/28/2007 1:15 AM
 

You are correct that DotNetNuke is designed to allow database objects to be part of schemas other than 'dbo', but I do believe that DotNetNuke requires that if a different schema (databaseOwner) is used, that schema must be the default for the user specified in your connection string.

So while it would be prudent to add the '{databaseOwner}' token to the SQL statements in the upgrade script files, it should not be necessary, since SQL Server will by default use the default schema specified for a user. Therefore, to fix your issue, you should ensure that the user you use in the connection string (in web.config) to allow DotNetNuke to access the database has the correct default schema specified.

If you cannot change the default schema you will have to either wait until the next version, when this token is included in the scripts, or you can introduce it your self by simply unpacking the downloaded ZIP, altering the file by adding "{databaseOwner}" in front of every usage of the "{objectQualifier}" token and repackaging it into a ZIP file. This will produce a fully-installable version of the module that should resolve your problem.

I should also note that the module has been tested in environments which use schemas other than 'dbo' without issues, but mistakes are sometimes made. If you still encounter problems, please let me know, and provide as much detail as possible (feel free to remove private data such as passwords from connection strings, etc.), by either replying to this thread or by emailing me at: andrew.nurse@dotnetnuke.com


Andrew Nurse
DotNetNuke Core Team Member and Reports Module Project Lead
Microsoft Certified Professional Developer

 
New Post
5/28/2007 5:22 AM
 

 The DatabaseOwner before the objectqualifier did not set the databaeOwener as Objectqualifier.  This is specified the DatabaseOwner for the access of the table. Without this setting you loosed many perfomenance on the SqlServer !

I get a high cpu usage near 100% of the SqlServer if the databaseOwner statements are not setting.  I have manuell setting this all to my spocs and functions now.  So I get a very better perfomenance of the Sql server and the weppage.  Please look to these posts too:

http://www.dotnetnuke.com/Community/Forums/tabid/795/forumid/108/threadid/133872/scope/posts/Default.aspx 

http://www.dotnetnuke.com/Community/Blogs/tabid/825/EntryID/1422/Default.aspx 

Regards

Matthias

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsReportsReportsMissing {databaseOwner} Statements in all SqlDataProvidersMissing {databaseOwner} Statements in all SqlDataProviders


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