Search Forum Home   DotNetNuke  CATALooK.netStore  Installation fa...  Installation failure - CataLookStore.zip    3/21/2011 2:47:20 PM WRowsell 1 posts Installation failure - CataLookStore.zip   Dear All, I am installing Catalook for the first time. WHen I tried to install CATALooKStore.zip I got this failure message. Can anyone suggest what to do to fix this? See message: Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself. Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, snipped ... information_schema, sys, or yourself. Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself. Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.GrantStoredProceduresPermission(String Permission, String LoginOrRole) if exists (select * from dbo.sysusers where name='OrbitDNNUser') begin declare @exec nvarchar(2000) declare @name varchar(150) declare sp_cursor cursor for select o.name as name from dbo.sysobjects o where ( OBJECTPROPERTY(o.id, N'IsProcedure') = 1 or OBJECTPROPERTY(o.id, N'IsExtendedProc') = 1 or OBJECTPROPERTY(o.id, N'IsReplProc') = 1 ) and OBJECTPROPERTY(o.id, N'IsMSShipped') = 0 and o.name not like N'#%%' and (left(o.name,len('')) = '' or left(o.name,7) = 'aspnet_') open sp_cursor fetch sp_cursor into @name while @@fetch_status >= 0 begin select @exec = 'grant EXECUTE on [' + @name + '] to [OrbitDNNUser]' execute (@exec) fetch sp_cursor into @name end deallocate sp_cursor end Info End Sql execution: 03.69.00.SqlDataProvider file Info Finished Sql execution Failure Installation Failed - Script Any tips guys?? William  4/5/2011 7:52:02 AM steve123 84 posts stefporter.com Re: Installation failure - CataLookStore.zip Hi William, did you checked your timeout values in your 'web.config' ? This behavior is described e.g. in the manual: If you get any errors while uploading pa-modules or importing and exporting products, orders etc., this may be caused by a slow internet connection or your provider has limited the maximum amount of time for a script to execute. To fix this, you can use also the ftp method to install the modules: Ftp the 3 pa-module files to /Install/Module folder and then give a command at the /Install/Install.aspx?mode=InstallResources \PA-Modules, or perform the steps below o Change this line in your web.config: <forms name=".DOTNETNUKE" protection="All" cookieless="UseCookies" timeout="60" /> to <forms name=".DOTNETNUKE" protection="All" cookieless="UseCookies" timeout="600000" /> o Add green marked parameter to the httpRuntime section of the web.config and change the red marked parameters: <httpRuntime useFullyQualifiedRedirectUrl="true" maxRequestLength="2097151" requestLengthDiskThreshold="50000" executionTimeout="9000" /> o Here you can find more information: Timeout Error If there was a timeout while uploading the module CATALooKStore.zip and the module is now listed with the new version number in: Host -> Module Definitions -> CATALooKStore -> Version, it is necessary to change the version number to the old CATALooK.netStore version number that was installed before the update. Please execute the following script via Host -> SQL (Turn off the 'Run as Script?' option) to reset the version number: DNN4 update {databaseOwner}{objectQualifier}desktopmodules set version='XX.XX.XX' where FriendlyName='CATALooKStore' DNN5 update {databaseOwner}{objectQualifier}packages set version='XX.XX.XX' where FriendlyName='CATALooKStore' Replace XX.XX.XX by the CATALooK version number before the update or 00.00.00 if this was a new installation. Regards, Stefan.  Page 1 of 1   DotNetNuke  CATALooK.netStore  Installation fa... Flat View Tree View Oldest To Newest Newest To Oldest