Apollo_TabLocalizationGetLastTabUpdate doesn't exist...

Jan 19, 2013 at 9:32 AM

Hi everybody,

I've downloaded the latest Apollo package today and installed into DNN 7.0.0 successfully into my Azure account. During CREATE TABLE Apollo_TabLocalization, removed WITH FILLFACTOR = 90, on the CONSTRAINTs, incompatible with my SQL SERVER. 

2 errors observed: 

1) Haven't used it on any page yet. But when restarting my site (after logging in as host), exception thrown: Apollo_TabLocalizationGetLastTabUpdate doesn't exist...

Did this twice (uninstalled then repair), same result. Yes, this proc is created in 05.03.00. Details below.

2) During uninstallation, only dataprovider reported deleted is - Providers\DataProviders\SqlDataProvider\05.00.09.SqlDataProvider 
then Error reported System.Data.SqlClient.SqlException (0x80131904): Tables without a clustered index are not supported in this version of SQL Server. Please create a clustered index and try again.
The SQL string is

  • DELETE FROM dbo.SkinControls WHERE (ControlKey LIKE 'ML%') AND (ControlSrc LIKE '%PageLocalization%')
  • DELETE FROM dbo.Packages WHERE (Name LIKE 'Apollo.ML%') AND (FriendlyName LIKE '%SkinObject') AND (Description LIKE '%PageLocalization%')

The message on clustered index could explain that tables are not created, then procs neither. Where should I put clustered index ?

 

 

Any comments or hints would be most welcome !


1) Exception Apollo_TabLocalizationGetLastTabUpdate details are:

DotNetNuke.Services.Exceptions.ModuleLoadException: Exception has been thrown by the target of an invocation. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: The stored procedure 'dbo.Apollo_TabLocalizationGetLastTabUpdate' doesn't exist. at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at Apollo.DNN_Localization.SqlDataProvider.GetLastTabUpdate(Int32 portalId) at Apollo.DNN_Localization.LocalizationController.GetLastTabUpdate(Int32 portalId) at Apollo.DNN_Localization.LocalizeTab.getLocalizedTabsArray(String locale, Int32 portalID) at Apollo.DNN_Localization.LocalizeTab.getLocalizedTabsArray() at Apollo.DNN_Localization.LocalizeTab.getLocalizedTab(TabInfo objTab) --- End of inner exception stack trace --- at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner) at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeType typeOwner) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at DotNetNuke.Web.DDRMenu.Localisation.Apollo.LocaliseTab(TabInfo tab, Int32 portalId) at DotNetNuke.Web.DDRMenu.Localisation.Localiser.LocaliseTab(TabInfo tab) at DotNetNuke.Web.DDRMenu.Localisation.Localiser.LocaliseNode(MenuNode node) at System.Collections.Generic.List`1.ForEach(Action`1 action) at DotNetNuke.Web.DDRMenu.Localisation.Localiser.LocaliseNode(MenuNode node) at DotNetNuke.Web.DDRMenu.MenuBase.PreRender() at DotNetNuke.Web.DDRMenu.SkinObject.OnPreRender(EventArgs e) --- End of inner exception stack trace ---