|
|
| Author |
Messages |
|
Mark Christie Registered Users
 Nuke Newbie Posts:6

 |
| 4/26/2005 7:07 AM |
|
<table align="left" cellpadding="0" cellspacing="0" width="90%"> <tbody><tr><td class="txt3" align="left" valign="top"><p>Greetings, Forum.</p> <p>I've tried installing 3.0.13 on a Windows Server 2003 system several times, only to get the following message when I first browse to <a target=_blank href="http://localhost/dotnetnuke">http://localhost/dotnetnuke</a> :</p><font color="#246398"> <h1><u>Installing DotNetNuke</u></h1> <h2>Version: 03.00.13</h2> <h2><u>Current Settings</u></h2> <p> <table cellpadding="0" cellspacing="0"> <tbody><tr> <td><b>Default Provider</b></td> <td><b>SqlDataProvider</b></td></tr> <tr> <td><b>Connection String</b></td> <td><b>Server=(local);Database=DotNetNuke;uid=DNN;pwd=****;</b></td></tr> <tr> <td><b>.NET Framework Version</b> </td> <td><b>1.1.4322.2300</b></td></tr> <tr> <td><b>Windows User</b></td> <td><b>NT AUTHORITY\NETWORK SERVICE</b></td></tr> <tr> <td><b>Host Name</b></td> <td><b>erp-wp2</b></td></tr></tbody></table><br><br></p> <h2><u>Installation Status Report</u></h2> <p>00:00:00.140 - Installing Version: 3.0.12<br>00:00:00.140 - Installing Script: DotNetNuke.SetUp.SqlDataProvider<br>00:00:00.187 - Installing Script: DotNetNuke.Schema.SqlDataProvider<br>00:00:07.687 - Installing Script: DotNetNuke.Data.SqlDataProvider<br>00:00:12.405 - Installing MemberRole Provider:<br>00:00:12.405 - Executing InstallCommon.sql<br>00:00:15.530 - Executing InstallMembership.sql<br>00:00:18.343 - Executing InstallProfile.sql<br>00:00:19.468 - Executing InstallRoles.sql<br>00:00:21.186 - Upgrading to Version: 3.0.13<br>00:00:21.421 - Performing General Upgrades<br></p></font></td></tr></tbody> </table> <p> </p> <hr> <span> <h1>Server Error in '/DotNetNuke' Application. <hr> </h1> <h2><i>The stored procedure 'dbo.DNN_GetTabByName' doesn't exist.</i> </h2> </span><font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif "><b>Description: </b>An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. <br><br><b>Exception Details: </b>System.InvalidOperationException: The stored procedure 'dbo.DNN_GetTabByName' doesn't exist.<br><br><b>Source Error:</b> <br><br> <table bgcolor="#ffffcc"> <tbody><tr> <td><code>An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.</code> </td></tr></tbody></table><br><b>Stack Trace:</b> <br><br> <table bgcolor="#ffffcc"> <tbody><tr> <td><pre>[InvalidOperationException: The stored procedure 'dbo.DNN_GetTabByName' doesn't exist.]<br> System.Data.SqlClient.SqlCommand.DeriveParameters() +1274<br> System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) +41<br> Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues)<br> Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter)<br> Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter)<br> Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName)<br> Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues)<br> DotNetNuke.Data.SqlDataProvider.GetTabByName(String TabName, Int32 PortalId) +128<br> DotNetNuke.Entities.Tabs.TabController.GetTabByName(String TabName, Int32 PortalId, Int32 ParentId) +23<br> DotNetNuke.Services.Upgrade.Upgrade.UpgradeApplication() +65<br> DotNetNuke.Services.Upgrade.Upgrade.UpgradeDNN(String strProviderPath, String strDatabaseVersion) +1342<br> DotNetNuke.Services.Upgrade.Upgrade.InstallDNN(String strProviderPath) +1031<br> DotNetNuke.Framework.Install.InstallApplication() +1003<br> DotNetNuke.Framework.Install.Page_Load(Object sender, EventArgs e) +220<br> System.Web.UI.Control.OnLoad(EventArgs e) +67<br> System.Web.UI.Control.LoadRecursive() +35<br> System.Web.UI.Page.ProcessRequestMain() +750<br></pre></td></tr></tbody></table><br></font> <hr> <p><font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif "><b>Version Information:</b> Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300 </font></p> <p><font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif "> </font><span id="PostFlatView"><p>I am starting fresh, installing a clean version of DNN v3.0.13. I dumped the database, the DNN folder, the virtual directory in IIS, even downloaded a new ZIP from a different host site. </p> <p>Mostly using instructions from <a target=_blank href="http://dotnetjunkies.com/WebLog/richard.dudley/archive/2004/12/11/36123.aspx">http://dotnetjunkies.com/WebLog/richard.dudley/archive/2004/12/11/36123.aspx</a></p> <p>Files unzipped to C:\inetpub\wwwroot\DotNetNuke folder.</p> <p>Granted NETWORK SERVICE modify privs to the DotNetNuke folder. (.NET Framework v1.1.4322)</p> <p>Created user DNN in SQL Server v8.0 with db_owner privs to DotNetNuke database.</p> <p>Modified web.config to accommodate DNN user in connectionString. Added "DNN_" for objectQualifier for SqlDataProvider.</p> <p>Created DotNetNuke application under Default Web Site. Permissions for Scripts and Executables.<br> </p> <p>Consistently getting the same error every time I try.<br> </p> <p>Any ideas?<br> </p> </span></p> |
|
|
|
|
Scott McCulloch Administrators
 Nuke Master Posts:12820


 |
| 4/26/2005 7:17 AM |
|
Ok - a few questions. When you encounter the error can you:- * Look at the database, tell me if anything database, stored procs etc. are created. * Sql Server V8.0 is Sql 2000 ? That error means for some reason the tables, stored procs have not been created, or your user does not have access to them. Have you tried, dropping the database, and re-running? |
|
Scott McCulloch Site Administrator |
|
|
Jack Hoelz Gold Membership
 Nuke Master Posts:815


 |
| 4/26/2005 7:23 AM |
|
I ran into this exact same problem yesterday. Considering this was my 15th deployment of DNN3 I was shocked. On the surface I could not find anything wrong with my entries. I went back, deleted everything, recreated everything, new folders, db, config entries and what do you know, it worked. 
|
|
Get The Net!!
Jack Hoelz |
|
|
Mark Christie Registered Users
 Nuke Newbie Posts:6

 |
| 4/26/2005 7:55 AM |
|
Thanx for the quick response...! > Have you tried, dropping the database, and re-running? Yeah, I've tried dumping everything and starting fresh about 10 times now...at least it's consistent...  > * Sql Server V8.0 is Sql 2000 ? Yup...For my specific instance, SQL Server 2000 v8.00.760 SP3. > * Look at the database, tell me if anything database, stored procs etc. are created. The installation creates 65 tables, 6 views, and 222 stored procedures...but none of those 222 sprocs are the DNN_GetTabByName one that it seems to be looking for. I see DNN_GetTables, DNN_GetTabPermission, DNN_GetTabPermissionsByPortal, and DNN_GetTabPermissionsByTabID, but no DNN_GetTabByName... In the DNN_Version table, there are 2 entries. It looks like it is installing v3.0.12 and then trying to upgrade to 3.0.13. Does that sound correct to you? Best regards, -Mark C. |
|
|
|
|
Jack Hoelz Gold Membership
 Nuke Master Posts:815


 |
| 4/26/2005 8:26 AM |
|
Added "DNN_" for objectQualifier for SqlDataProvider. & Created DotNetNuke application under Default Web Site I have never done the above. Just giving Network Services Write perms on the root directory and if your running W2K3 sp1 make sure you can run scripts on the directory as well. |
|
Get The Net!!
Jack Hoelz |
|
|
Mark Christie Registered Users
 Nuke Newbie Posts:6

 |
| 4/26/2005 8:57 AM |
|
Network Services has Modify privs, including Read & Execute, on the root directory, and for the Execute Permissions on the virtual directory in IIS, I've tried both Scripts only and Scripts and Executables. |
|
|
|
|
Scott McCulloch Administrators
 Nuke Master Posts:12820


 |
| 4/26/2005 11:41 PM |
|
All I can suggest is something is different in the environment, have you installed dotnetnuke successfully anywhere else? You could also try the forums.asp.net and go into the dotnetnuke forums. Someone there might know the answer. |
|
Scott McCulloch Site Administrator |
|
|
Mark Christie Registered Users
 Nuke Newbie Posts:6

 |
| 4/27/2005 6:12 AM |
|
> have you installed dotnetnuke successfully anywhere else? Yup. My own machine running Windows XP Pro and a server running Win2000 SP4. > You could also try the forums.asp.net and go into the dotnetnuke forums. > Someone there might know the answer. Been there. Done that. Had more frequent and more productive responses on this forum...so thank you. > All I can suggest is something is different in the environment... More than likely. If I figure out anything, I'll let you know...otherwise, I might have to raise the white flag on this one. Best regards. -Mark C. |
|
|
|
|
Mark Christie Registered Users
 Nuke Newbie Posts:6

 |
| 4/27/2005 11:03 AM |
|
You're gonna love the answer to this one... Our SQL Server was set up with a server collation that is case-sensitive (Latin1_General_BIN), in order to support our new ERP system... And it looks like a number of stored procedures in DotNetNuke do not conform strictly to the case-sensitivity...for example: CREATE procedure dbo.dnn_DeleteListEntryByID @EntryId int, @DeleteChild bit as Delete From dnn_Lists Where [EntryID] = @EntryID If @DeleteChild = 1 Begin Delete From dnn_Lists Where [ParentID] = @EntryID End @EntryId does not match @EntryID, due to case-sensitivity... Great fun, eh? Best regards, -Mark C. P.S.: Should I report this as a bug??? |
|
|
|
|
Mike Horton Gold Membership
 Nuke Addict Posts:84


 |
| 4/27/2005 2:57 PM |
|
| I'd report it as one. It's a legitimate bug that others might run into if it isn't fixed. |
|
|
|
|
Scott McCulloch Administrators
 Nuke Master Posts:12820


 |
| 4/27/2005 3:18 PM |
|
Heh, I would never have thought of that, yep, better to report it at as a bug. |
|
Scott McCulloch Site Administrator |
|
|
Mark Christie Registered Users
 Nuke Newbie Posts:6

 |
| 4/29/2005 8:24 AM |
|
Thought you might be interested in a response I got from a member of the .NET Nuke Core Team on the ASP.NET Forum: Mark, we're aware of this issue, and have been discussing how best to handle it. In the dnn 1.0.10 timeframe there were a number of fixes made to ensure it worked in case sensitive sql server installs, but unfortunately since then some errors have come in. The primary problem is ensuring that once fixed, this does not happen again, so we are looking for solutions that can validate the scrips automatically. BTW Please feel free to log this, or any other issue in the public issue tracker http://support.dotnetnuke.com/project/Project.aspx?PROJID=23 Cathal I've gone ahead and entered the problem into the public issue tracker. Best regards, -Mark C. |
|
|
|
|
|
| You are not authorized to post a reply. |
|
|
|
ActiveForums 3.7
|
|