Disponible fix para el paquete de actualización a DNN 6.0 en Windows Azure

Al intentar actualizar en Windows Azure una instancia de DotNetNuke desde la versión 05.06.03 a la 06.00.00 usando el paquete oficial de actualización, te encontrarás con el siguiente error:

En el enlace siguiente puedes descargar un documento con la vista detallada de estos errores http://dnnazureaccelerator.codeplex.com/releases/view/71164#DownloadId=266857

El resumen de los mismos son referidos a incompatibilidades con SQL Azure del paquete de actualización (el de primera instalación funcionaba sin problemas):

Stored Procedure “GetFile”	Deprecated feature ‘String literals as column aliases’ is not supported in this version of SQL Server.
Stored Procedure “GetFileById”	Deprecated feature ‘String literals as column aliases’ is not supported in this version of SQL Server.
Stored Procedure “GetAllFiles”	Deprecated feature ‘String literals as column aliases’ is not supported in this version of SQL Server.
Stored Procedure “GetFiles”	Deprecated feature ‘String literals as column aliases’ is not supported in this version of SQL Server.
Creating PK on “PortalLocalization”	Table ‘PortalLocalization’ already has a primary key defined on it.
Stored Procedure “GetVendorsByEmail”	Deprecated feature ‘String literals as column aliases’ is not supported in this version of SQL Server.
Stored Procedure “GetBanner”	Deprecated feature ‘String literals as column aliases’ is not supported in this version of SQL Server.

Para solucionarlo, puedes seguir una de estas dos propuestas:

Usar el paquete corregido en vez del paquete oficial, que he puesto a descarga en http://dnnazureaccelerator.codeplex.com/releases/view/71164#DownloadId=266856
Aplicar el siguiente script T-SQL después de aplicar el paquete oficial de actualización

Hope this helps,

David Rodriguez

davidjrh

David Rodriguez, is a happy Spanish guy living and working in Tenerife (Canary Islands, Spain) where he was born. He is one of the lucky ones who has the opportunity to work with cutting edge technologies at Intelequia as CTO. He has more than 20 years development background mostly based on Microsoft technologies, designing and architecting highly scalable systems like reservation systems for airlines companies. He has been working with Microsoft Azure since it was on CTP, migrating on-premise systems to the cloud, co-founding the .NET User Group TenerifeDev as well as the CSV company Intelequia Software Solutions. He is also the author of different DNN-Azure open source projects available on GitHub such as caching providers, analytics and Azure Active Directory.

davidjrh

Deja un comentario Cancelar respuesta