WillStrohl
commented
9 years ago I attempted to reproduce this issue using EVS, but was unable to. The only errors occurring appear to be unrelated.
Closed WillStrohl closed 9 years ago
WillStrohl
commented
9 years ago I attempted to reproduce this issue using EVS, but was unable to. The only errors occurring appear to be unrelated.
Install DNN 7.2.1 running on azure. Following error on install...
StartJob Starting Installation Info Starting Installation - WillStrohl.Injection Info Starting Installation - Script Info Begin Sql execution Info Creating backup of previous version - Providers\DataProviders\SqlDataProvider\01.00.00.SqlDataProvider Info Created - Providers\DataProviders\SqlDataProvider\01.00.00.SqlDataProvider Info Executing 01.00.00.SqlDataProvider Info Start Sql execution: 01.00.00.SqlDataProvider file Info End Sql execution: 01.00.00.SqlDataProvider file Info Creating backup of previous version - Providers\DataProviders\SqlDataProvider\01.00.01.SqlDataProvider Info Created - Providers\DataProviders\SqlDataProvider\01.00.01.SqlDataProvider Info Executing 01.00.01.SqlDataProvider Info Start Sql execution: 01.00.01.SqlDataProvider file Info End Sql execution: 01.00.01.SqlDataProvider file Info Creating backup of previous version - Providers\DataProviders\SqlDataProvider\01.00.02.SqlDataProvider Info Created - Providers\DataProviders\SqlDataProvider\01.00.02.SqlDataProvider Info Executing 01.00.02.SqlDataProvider Info Start Sql execution: 01.00.02.SqlDataProvider file Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'sysindexes'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:4de9a209-b7b3-4de0-ad9e-57f966a1e543 /* INSTALL SQL PROVIDER SCRIPT Injection Module for DotNetNuke Version: 1.00.02 Author: Will Strohl E-Mail: will.strohl@gmail.com Website: http://www.willstrohl.com Copyright 2009 Will Strohl Release Notes: This update patches SQL problems that were created. */ IF EXISTS(SELECT 1 FROM [sysindexes] WHERE [name] = N'IX_dnn_wns_inj_injection_injectcontent') BEGIN DROP INDEX [IX_dnn_wns_inj_injection_injectcontent] ON dbo.[dnn_wns_inj_injection] END Info End Sql execution: 01.00.02.SqlDataProvider file Info Finished Sql execution Failure Installation Failed - Script Info Installation Failed - WillStrohl.Injection Info Deleted temporary install folder EndJob Installation Failed comments
Telekia wrote Aug 25, 2014 at 5:12 AM
It seems the same kind of error in Azure with dnn 7.3.2 and WSCIM 1.2.1
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'sysindexes'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:e506a4b3-0dd9-4dbe-b1f8-b0d1202869a4 Error Number:208,State:1,Class:16 /* INSTALL SQL PROVIDER SCRIPT Injection Module for DotNetNuke Version: 1.00.02 Author: Will Strohl E-Mail: will.strohl@gmail.com Website: http://www.willstrohl.com Copyright 2009 Will Strohl Release Notes: This update patches SQL problems that were created. */ IF EXISTS(SELECT 1 FROM [sysindexes] WHERE [name] = N'IX_wns_inj_injection_injectcontent') BEGIN DROP INDEX [IX_wns_inj_injection_injectcontent] ON dbo.[wns_inj_injection] END
ORIGINAL: https://wnsinj.codeplex.com/workitem/12773