| 
                                                        
                                                            
                                                                
                                                                    |  |  
                                                                    |   Certified Developer 8 | 
                                                                            
                                                                                liquidmagic
                                                                            - 
                                                                                4/27/2012 7:41:28 AM
                                                                            
                                                                         
                                                                        Problem after migrating a website to another server 
                                                                            Hello,  I have the following issue. I migrated a website from one server to another. Here is the way I did it.  I copies all files from the rot directory of the site to the other server. Then I created a backup of the server and did a restore on the new server. I changed the connections tring, fixed permissions and I get the following error. The error happens on some cases even though it's a server error. I mean on a browser I see the site but from another location somebody else cannot.  Here is the error:  Server Error in '/' Application.
 Procedure or function Proc_CMS_SettingsKey_SelectGeneration has too many arguments specified.
 
 Description: 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.
 
 Exception Details: System.Data.SqlClient.SqlException: Procedure or function Proc_CMS_SettingsKey_SelectGeneration has too many arguments specified.
 
 Source Error:
 
 The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:
 
 1. Add a "Debug=true" directive at the top of the file that generated the error. Example:
 
 <%@ Page Language="C#" Debug="true" %>
 
 or:
 
 2) Add the following section to the configuration file of your application:
 
 <configuration>
 <system.web>
 <compilation debug="true"/>
 </system.web>
 </configuration>
 
 Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.
 
 Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.
 
 Stack Trace:
 
 [SqlException (0x80131904): Procedure or function Proc_CMS_SettingsKey_SelectGeneration has too many arguments specified.]
 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +212
 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +245
 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1099
 System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +58
 System.Data.SqlClient.SqlDataReader.get_MetaData() +112
 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +6291924
 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +6292993
 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +424
 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +28
 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +211
 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +87
 CMS.DataProviderSQL.DataConnection.ExecuteReader(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, CommandBehavior commandBehavior) +223
 
 [Exception: [DataConnection.ExecuteQuery]: Query: Proc_CMS_SettingsKey_SelectGeneration: caused exception: Procedure or function Proc_CMS_SettingsKey_SelectGeneration has too many arguments specified.]
 CMS.DataProviderSQL.DataConnection.ExecuteReader(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, CommandBehavior commandBehavior) +485
 CMS.SettingsProvider.SqlHelperClass.ExecuteReader(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, CommandBehavior commandBehavior, IDataConnection conn) +196
 CMS.SettingsProvider.SettingsKeyProvider.LoadGenerationReader(Int32 generation, Object parameter) +234
 CMS.SettingsProvider.ProviderDictionaryCollection.LoadGeneration(Int32 generation) +139
 CMS.SettingsProvider.ProviderDictionary`2.LoadNextGeneration() +40
 CMS.SettingsProvider.ProviderStringDictionaryTemplate`1.Contains(String key, ValueType& value) +245
 CMS.SettingsProvider.SettingsKeyProvider.GetValue(String siteName, String globalKeyName) +443
 CMS.SettingsProvider.SettingsKeyProvider.GetBoolValue(String keyName) +97
 CMS.SettingsProvider.DebugHelper.get_DebugDisabled() +61
 CMS.SettingsProvider.DebugHelper.GetDebugBoolSetting(String keyName, Boolean defaultValue) +17
 CMS.SettingsProvider.DebugHelper.get_DebugEverythingEverywhere() +51
 CMS.SettingsProvider.DebugHelper.get_DebugEverything() +50
 CMS.SettingsProvider.DebugHelper.GetDebugBoolSetting(String keyName) +222
 CMS.GlobalHelper.CacheHelper.get_DebugCache() +49
 CMS.CMSHelper.CMSContext.get_AnyDebugEnabled() +56
 CMSFunctions.get_AnyDebugEnabled() +9
 CMSAppBase.FirstRequestInitialization(Object sender, EventArgs e) +315
 CMSAppBase.BeforeBeginRequest(Object sender, EventArgs e) +125
 CMSAppBase.CMSBeginRequest(Object sender, EventArgs e) +16
 CMS.CMSHelper.CMSApplicationModule.app_BeginRequest(Object sender, EventArgs e) +35
 System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +80
 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +171
 
 Version Information: Microsoft .NET Framework Version:2.0.50727.5448; ASP.NET Version:2.0.50727.5456
 Any ideas why? Thank you, Dimitris
                                                                        
                                                                            
                                                                         
 
                                                                            
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                         |  | 
                                        
                                            
                                                | 
                                                    
                                                        
                                                            
                                                                
                                                                    |  |  
                                                                    |   Kentico Support | 
                                                                            
                                                                                kentico_jurajo
                                                                            - 
                                                                                4/29/2012 12:18:07 PM
                                                                            
                                                                         
                                                                        RE:Problem after migrating a website to another server 
                                                                            Hi, Have you tried to enable the debug mode as it is mentioned in the error message and in this blog post  so we can see where it is coming from? Are you able to reproduce the issue again? Best regards, Juraj Ondrus
                                                                        
                                                                            
                                                                         
 
                                                                            
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                         |  | 
                                        
                                            
                                                | 
                                                    
                                                        
                                                            
                                                                
                                                                    |  |  
                                                                    |   Certified Developer 8 | 
                                                                            
                                                                                liquidmagic
                                                                            - 
                                                                                4/30/2012 4:31:15 PM
                                                                            
                                                                         
                                                                        RE:Problem after migrating a website to another server 
                                                                            Hello, 
 it happens randomly on all pages. Right now it happens on all pages (even on CMS Desk and Site Manager). So, I can't debug it.
 
 Any ideas on what to look if this starts working?
 
 Dimitris
 
                                                                            
                                                                         
 
                                                                            
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                         |  | 
                                        
                                            
                                                | 
                                                    
                                                        
                                                            
                                                                
                                                                    |  |  
                                                                    |   Kentico Support | 
                                                                            
                                                                                kentico_radekm2
                                                                            - 
                                                                                5/2/2012 2:42:45 AM
                                                                            
                                                                         
                                                                        RE:Problem after migrating a website to another server 
                                                                            Hello. You can still enable debug in your web.config file, so we could see more details then: Add the following section to the configuration file of your application: <configuration><system.web>
 <compilation debug="true"/>
 </system.web>
 </configuration>
 I have found the same issue in our ticket history, and the problem was solved by customer himself, when he realized what was the problem: "There was a mixup between the db backups we were making." Could you please check that this is not your case, too? Thank you. Best Regards, Radek Macalik
                                                                        
                                                                            
                                                                         
 
                                                                            
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                         |  | 
                                        
                                            
                                                | 
                                                    
                                                        
                                                            
                                                                
                                                                    |  |  
                                                                    |   Certified Developer 8 | 
                                                                            
                                                                                liquidmagic
                                                                            - 
                                                                                5/3/2012 2:06:17 AM
                                                                            
                                                                         
                                                                        RE:Problem after migrating a website to another server 
                                                                            Hello, 
 I will add debugging and check.
 
 Did he mention the way it was solved?
 
 Thank you,
 Dimitris
 
 
                                                                            
                                                                         
 
                                                                            
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                         |  | 
                                        
                                            
                                                | 
                                                    
                                                        
                                                            
                                                                
                                                                    |  |  
                                                                    |   Kentico Support | 
                                                                            
                                                                                kentico_radekm2
                                                                            - 
                                                                                5/3/2012 2:54:37 AM
                                                                            
                                                                         
                                                                        RE:Problem after migrating a website to another server 
                                                                            Hello.
 All he wrote (and it is kind of description what was wrong) is:
 
 ...
 There was a mixup between the db backups we were making.
 ...
 
 Best Regards,
 Radek Macalik
 
                                                                            
                                                                         
 
                                                                            
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                         |  | 
                                        
                                            
                                                | 
                                                    
                                                        
                                                            
                                                                
                                                                    |  |  
                                                                    |   Certified Developer 8 | 
                                                                            
                                                                                liquidmagic
                                                                            - 
                                                                                5/3/2012 3:01:44 AM
                                                                            
                                                                         
                                                                        RE:Problem after migrating a website to another server 
                                                                            Hello, 
 not very helpful...
 
 The thing is that we are getting this randomly. We will try to restore it from another backup set.
 
 Thank you,
 Dimitris
 
 
                                                                            
                                                                         
 
                                                                            
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                         |  | 
                                        
                                            
                                                | 
                                                    
                                                        
                                                            
                                                                
                                                                    |  |  
                                                                    |   Kentico Support | 
                                                                            
                                                                                kentico_radekm2
                                                                            - 
                                                                                5/3/2012 4:09:33 AM
                                                                            
                                                                         
                                                                        RE:Problem after migrating a website to another server 
                                                                            Hello.
 I see. I will be waiting for your update.
 
 Best Regards,
 Radek Macalik
 
                                                                            
                                                                         
 
                                                                            
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                            
                                                                            
                                                                            
                                                                            
                                                                         
                                                                         |  |