Dear Sebastian..
I have the same problem.. after upgrading to 7.4.2 and executing the last version of Turbo Scripts (Rev m), I getting the below error on adding page to TOP LEVEL.
I haven't any Error on creating NONE TOP LEVEL pages

ModuleId:-1

ModuleDefId:-1

FriendlyName:

ModuleControlSource:DesktopModules/Admin/Tabs/ManageTabs.ascx

AbsoluteURL:/Default.aspx

DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke

ExceptionGUID:63a3508d-9e14-4b61-b33e-306d2834186d

AssemblyVersion:7.4.2

PortalId:0

UserId:1

TabId:55

RawUrl:/Home/ctl/Tab/activeTab/settingTab?popUp=true

Referrer:http://domain/Home/ctl/Tab/activeTab/settingTab?popUp=true

UserAgent:Mozilla/5.0 (Windows NT 6.1; rv:42.0) Gecko/20100101 Firefox/42.0

ExceptionHash:lsQ1l9pwFfsanMR0dp8Ycw==

Message:Cannot insert duplicate key row in object 'dbo.Tabs' with unique index 'IX_Tabs_PortalLevelParentOrder'. The duplicate key value is (0, 0, , 1, 0). The statement has been terminated. The 'AddTab' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.

StackTrace:

InnerMessage:Cannot insert duplicate key row in object 'dbo.Tabs' with unique index 'IX_Tabs_PortalLevelParentOrder'. The duplicate key value is (0, 0, , 1, 0). The statement has been terminated. The 'AddTab' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.

InnerStackTrace:

at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at PetaPoco.Database.ExecuteScalar[T](String sql, Object[] args)
at DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteScalar[T](String connectionString, CommandType type, String sql, Object[] args)
at DotNetNuke.Data.DataProvider.AddTabToEnd(TabInfo tab, Int32 createdByUserID)
at DotNetNuke.Entities.Tabs.TabController.AddTabInternal(TabInfo tab, Int32 afterTabId, Int32 beforeTabId, Boolean includeAllTabsModules)
at DotNetNuke.Entities.Tabs.TabController.AddTab(TabInfo tab, Boolean includeAllTabsModules)
at DotNetNuke.Modules.Admin.Tabs.ManageTabs.SaveTabData(String strAction)
at DotNetNuke.Modules.Admin.Tabs.ManageTabs.cmdUpdate_Click(Object Sender, EventArgs e)

Source:

FileName:

FileLineNumber:0

FileColumnNumber:0

Hello I am currently working on the same site that Tajas was referring to as well,  we have the DNN upgrade that you have suggested and the site performed well on the new server we had setup during testing, now however once the site has gone live and is under real world stress,  we are starting to get hangs where the site will stop responding for 1 min up to 30 mins sometimes even longer where they have rebooted the server to get it to recover,  there is always about a  1 min  hang when a new page is published from the admin panel,  but the more worrying issue is when it happens randomly and it is several times a day.

  we are looking for all possible causes for this, and one of the items we have noted is that during the hangs the CPU usage is near 100% and our network traffic skyrockets.  tracing this back to the database we have found that there care 85,000+ records entered into the error log table they all deal with the duplicate page error.  now I can see this being part of the issue, but there are many duplicate pairs of tabIDs with different base URLs most of them are not part of the site nor have anything to do with the site, so that is compounding the number dramatically.

Other information the database is on it's own server and only sees a slight uptick in CPU and is still very responsive during the events. The server that the site is on has 32 gigs of ram and at times IIS does peak out around 24 gigs, but rapidly drops back down even during the events. when an event is not in progress the site normally runs at about 1-2% CPU usage.  

for 3rd party plugins I do know we are using psSiteSearch but again we have disabled the schedule and the High CPU events still happened.

with that basic information I guess I have a few questions if anyone might be able to shed some light on for me.

1st is there any location in the database where I might find the bogus base URLs?

2nd  what processes trigger the duplicate error messages to be created? As most of the time nobody is doing any content or publishing pages when this happens ( we have already disabled the scheduler to see if that would do it, no luck)

3rd  does this sound like it could be fully responsible for hanging the site like this?

Thanks

Scott Pflanzer

 

Scott,
for base URLs, check tables PortalAlias (domain names), Tabs (page names and urls) and TabUrls (page redirects).
Please check IIS app pool settings and make sure, there is only one worker process assigned to the site.
You also might clear the event log tables in the database, see http://www.dnnsoftware.com/community-...

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN