|
|
|
Joined: 5/9/2007
Posts: 5
|
|
|
During a fresh install of DNN 5.1 i have a problem instlling this module. I Try install only the module ant this is the error: Any idea what happend?
|
Error loading files from temporary folder - see below
|
StartJob |
Starting Installation |
Info |
Starting Installation - DNN_Reports |
Info |
Starting Installation - Script |
Info |
Begin Sql execution |
Info |
Creating backup of previous version - Install\Scripts\04.04.02.SqlDataProvider |
Info |
Created - Install\Scripts\04.04.02.SqlDataProvider |
Info |
Executing 04.04.02.SqlDataProvider |
Info |
Start Sql execution: 04.04.02.SqlDataProvider file |
Info |
End Sql execution: 04.04.02.SqlDataProvider file |
Info |
Creating backup of previous version - Install\Scripts\04.05.00.SqlDataProvider |
Info |
Created - Install\Scripts\04.05.00.SqlDataProvider |
Info |
Executing 04.05.00.SqlDataProvider |
Info |
Start Sql execution: 04.05.00.SqlDataProvider file |
Info |
End Sql execution: 04.05.00.SqlDataProvider file |
Info |
Creating backup of previous version - Install\Scripts\05.00.00.SqlDataProvider |
Info |
Created - Install\Scripts\05.00.00.SqlDataProvider |
Info |
Executing 05.00.00.SqlDataProvider |
Info |
Start Sql execution: 05.00.00.SqlDataProvider file |
Info |
End Sql execution: 05.00.00.SqlDataProvider file |
Info |
Creating backup of previous version - Install\Scripts\05.01.00.SqlDataProvider |
Info |
Created - Install\Scripts\05.01.00.SqlDataProvider |
Info |
Executing 05.01.00.SqlDataProvider |
Info |
Start Sql execution: 05.01.00.SqlDataProvider file |
Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid object name 'sys.foreign_keys'. 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /****** Object: ForeignKey [FK_reports_XsltExtensionObjects_TabModules] Script Date: 04/30/2009 09:40:15 ******/ IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'dbo.[FK_reports_XsltExtensionObjects_TabModules]') AND parent_object_id = OBJECT_ID(N'dbo.[reports_XsltExtensionObjects]')) ALTER TABLE dbo.[reports_XsltExtensionObjects] DROP CONSTRAINT [FK_reports_XsltExtensionObjects_TabModules] System.Data.SqlClient.SqlException: Invalid object name 'sys.objects'. 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /****** Object: StoredProcedure dbo.[reports_AddXsltExtensionObject] Script Date: 04/30/2009 09:40:10 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.[reports_AddXsltExtensionObject]') AND type in (N'P', N'PC')) DROP PROCEDURE dbo.[reports_AddXsltExtensionObject] System.Data.SqlClient.SqlException: Invalid object name 'sys.objects'. 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /****** Object: StoredProcedure dbo.[reports_ClearXsltExtensionObjects] Script Date: 04/30/2009 09:40:10 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.reports_ClearXsltExtensionObjects') AND type in (N'P', N'PC')) DROP PROCEDURE dbo.reports_ClearXsltExtensionObjects System.Data.SqlClient.SqlException: Invalid object name 'sys.objects'. 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /****** Object: StoredProcedure dbo.reports_GetXsltExtensionObjects Script Date: 04/30/2009 09:40:10 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.reports_GetXsltExtensionObjects') AND type in (N'P', N'PC')) DROP PROCEDURE dbo.[reports_GetXsltExtensionObjects] System.Data.SqlClient.SqlException: Invalid object name 'sys.foreign_keys'. 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /****** Object: Table dbo.[reports_XsltExtensionObjects] Script Date: 04/30/2009 09:40:15 ******/ IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'dbo.[FK_reports_XsltExtensionObjects_TabModules]') AND parent_object_id = OBJECT_ID(N'dbo.[reports_XsltExtensionObjects]')) ALTER TABLE dbo.[reports_XsltExtensionObjects] DROP CONSTRAINT [FK_reports_XsltExtensionObjects_TabModules] System.Data.SqlClient.SqlException: Invalid object name 'sys.objects'. 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.[reports_XsltExtensionObjects]') AND type in (N'U')) DROP TABLE dbo.[reports_XsltExtensionObjects] System.Data.SqlClient.SqlException: Line 12: Incorrect syntax near '('. 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.[reports_XsltExtensionObjects]') AND type in (N'U')) BEGIN CREATE TABLE dbo.[reports_XsltExtensionObjects]( [ExtensionObjectId] [int] IDENTITY(1,1) NOT NULL, [TabModuleId] [int] NOT NULL, [XmlNamespace] [nvarchar](512) NOT NULL, [ClrType] [nvarchar](512) NOT NULL, CONSTRAINT [PK_reports_XsltExtensionObjects] PRIMARY KEY CLUSTERED ( [ExtensionObjectId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] END System.Data.SqlClient.SqlException: Invalid object name 'sys.objects'. 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.[reports_GetXsltExtensionObjects]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'-- ============================================= -- Author: Andrew Nurse -- Create date: March 29, 2009 -- Description: Retrieves all Xslt Extension Objects for the given tab module -- ============================================= CREATE PROCEDURE dbo.[reports_GetXsltExtensionObjects] @TabModuleId int AS BEGIN SELECT * FROM reports_XsltExtensionObjects WHERE TabModuleId = @TabModuleId END ' END System.Data.SqlClient.SqlException: Invalid object name 'sys.objects'. 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.[reports_ClearXsltExtensionObjects]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'-- ============================================= -- Author: Andrew Nurse -- Create date: March 29, 2009 -- Description: Clears all Xslt Extension Objects for the given tab module -- ============================================= CREATE PROCEDURE dbo.[reports_ClearXsltExtensionObjects] @TabModuleId int AS BEGIN DELETE FROM reports_XsltExtensionObjects WHERE TabModuleId = @TabModuleId END ' END System.Data.SqlClient.SqlException: Invalid object name 'sys.objects'. 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.[reports_AddXsltExtensionObject]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'-- ============================================= -- Author: Andrew Nurse -- Create date: March 29, 2009 -- Description: Clears all Xslt Extension Objects for the given tab module -- ============================================= CREATE PROCEDURE dbo.[reports_AddXsltExtensionObject] @TabModuleId int, @Xmlns nvarchar(512), @ClrType nvarchar(512) AS BEGIN INSERT INTO reports_XsltExtensionObjects(TabModuleId, XmlNamespace, ClrType) VALUES(@TabModuleId, @Xmlns, @ClrType) END ' END System.Data.SqlClient.SqlException: Invalid object name 'sys.foreign_keys'. 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /****** Object: ForeignKey [FK_reports_XsltExtensionObjects_TabModules] Script Date: 04/30/2009 09:40:15 ******/ IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'dbo.[FK_reports_XsltExtensionObjects_TabModules]') AND parent_object_id = OBJECT_ID(N'dbo.[reports_XsltExtensionObjects]')) ALTER TABLE dbo.[reports_XsltExtensionObjects] WITH CHECK ADD CONSTRAINT [FK_reports_XsltExtensionObjects_TabModules] FOREIGN KEY([TabModuleId]) REFERENCES dbo.[TabModules] ([TabModuleID]) ON UPDATE CASCADE ON DELETE CASCADE System.Data.SqlClient.SqlException: Invalid object name 'sys.foreign_keys'. 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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'dbo.[FK_reports_XsltExtensionObjects_TabModules]') AND parent_object_id = OBJECT_ID(N'dbo.[reports_XsltExtensionObjects]')) ALTER TABLE dbo.[reports_XsltExtensionObjects] CHECK CONSTRAINT [FK_reports_XsltExtensionObjects_TabModules] |
Info |
End Sql execution: 05.01.00.SqlDataProvider file |
Info |
Finished Sql execution |
Failure |
Installation Failed - Script |
Info |
Installation Failed - DNN_Reports |
Info |
Deleted temporary install folder |
EndJob |
Installation Failed |
|
|
|
|
|
|
|
| |
|
|
|
Joined: 11/1/2003
Posts: 43
|
|
|
Same error for me.
DotNetNuke 5.1 (773)
SQL SERVER 2000
Framework .NET 3.5
David.
I am not a programmer, just a simple user
|
|
|
|
| |
|
|
|
Joined: 11/1/2003
Posts: 43
|
|
|
"Reports" is certainly a good module but without being able to install, it is difficult to get an idea ....
David (from dotnetnuke.fr)
I am not a programmer, just a simple user
|
|
|
|
| |
|
|
Joined: 7/11/2008
Posts: 9
|
|
|
I got the same error. I don't believe you have access to the sys.foreign_keys table from a hosted SQL server account. I'll add this to the bug tracker.
|
|
|
|
| |
|
|
Joined: 7/11/2008
Posts: 9
|
|
|
Actually, the identifier 'sys.foreign_keys' is SQL 2005/8 specific. This sql script will not work on SQL 2000.
|
|
|
|
| |