Exceptions while creating pages

I have a user getting the following exceptions while trying to create pages. Any ideas?

I wonder if I'm missing something in my database, like a field isn't auto-populating. I had an issue where I was pointed to the wrong database for a stretch; I compared the database and tried to synchronize them, but maybe I missed something. I can provide DB schemas of any tables you want to look at.

I tried creating a page with SQL Profiler on and saw it was trying to insert an id of 2637 when the last record in the database is 3524. This (sf_permissions_inheritance_map) and sf_media_thumbnails are the only two tables that use INTs for keys instead of GUIDs (voa_keygen uses a string, otherwise it's all GUIDs).

These integer primary keys aren't identity columns, so I don't know how it's figuring out what to put in that field. There are a bunch of gaps in that table.

I have broken inheritance on a bunch of my pages.

I suppose I could try to restart the website and profile through creating a page to see if I can find where the low id is coming from. But that seems tedious and I'm not confident it will help me much.

Ideas?

Hello Eric,

 I think the answer to your question relies in the "voa_keygen" table. It is used to store the last generated id for such columns as the described one. And if I understood correctly the scenario in question you transferred some data from one database to another right? So in this table you should see the last id and change it to see if this is fixing the problem.

OK, so I updated my voa_keygen table (thanks). I'm not getting those exceptions in the log anymore, but it still wasn't working.

I ran a trace and looked at the results of all the selects and the following returned an odd result

Hi,

  I am having one portion of the error that eric is having. Here is the error from my log file

----------------------------------------
Timestamp: 6/2/2011 3:49:46 PM


Message: HandlingInstanceID: 12affef2-d5a4-4bcb-9c7e-09662444a759
An exception of type 'System.ArgumentException' occurred and was caught.
------------------------------------------------------------------------
06/02/2011 10:49:46
Type : System.ArgumentException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message : Invalid type specified Telerik.Sitefinity.Security.Data.SecurityDataProvider
Source : Telerik.Sitefinity
Help link : 
ParamName : 
Data : System.Collections.ListDictionaryInternal
TargetSite : TProviderBase InstantiateProvider(Telerik.Sitefinity.Configuration.IDataProviderSettings, System.Type, Telerik.Sitefinity.Abstractions.ExceptionPolicyName, Telerik.Sitefinity.Data.ManagerBase`1[TProviderBase])
Stack Trace :    at Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, Type providerType, ExceptionPolicyName policy, ManagerBase`1 manager)


Additional Info:


MachineName : BWCDCWEBSTG
TimeStamp : 6/2/2011 3:49:46 PM
FullName : Telerik.Sitefinity.Utilities, Version=4.1.1339.0, Culture=neutral, PublicKeyToken=b28c218413bdf563
AppDomainName : /LM/W3SVC/5/ROOT-2-129515033276897278
ThreadIdentity : nmadhavan
WindowsIdentity : NT AUTHORITY\NETWORK SERVICE
Requested URL : /Sitefinity/Services/Configuration/ConfigSectionItems.svc/localization/00000000-0000-0000-0000-000000000000/




Category: ErrorLog


Priority: 0


EventId: 9010


Severity: Warning


Title:Enterprise Library Exception Handling


Machine: BWCDCWEBSTG


App Domain: /LM/W3SVC/5/ROOT-2-129515033276897278


ProcessId: 1852


Process Name: C:\Windows\SysWOW64\inetsrv\w3wp.exe


Thread Name: 


Win32 ThreadId:2684


Extended Properties: 
----------------------------------------

Thanks
Madhavan

Hi Madhavan,

Do you have  any code that runs on application start or do you use a custom mebership data providers? The error you get says that

Telerik.Sitefinity.Security.Data.SecurityDataProvider is not a valid type but this is the correct type.

All the best,
Ivan Dimitrov
the Telerik team

Hi Ivan,

  I have a seperate db where the membership details are stored. Having said that the db of that is the same as the one of fitefinity. Basically the membership is running of a different SF db. Hope this will enable you to nail down the problem.

Thanks
Madhavan

Hi Madhavan,

The stack shows that the error occurs when the configuration files are loaded. Most probably you went to Administration >> Settings >> Advanced and the data provider settings could not be initialized properly because somewhere you have used a type which is not proper. For example you set Telerik.Sitefinity.Security.Data.SecurityDataProvider as a RoleProvider or MembershipProvider type. The error doesn't show which config file has been modified, but you can check App_Data/Sitefinity/Configurations and check all configs. We generate only the configuration files that are changed, so you can easily track your modifications.

Best wishes,
Ivan Dimitrov
the Telerik team