| Author |
Messages |
|
chiptay
Posts:12
 |
| 06/14/2007 15:52 |
|
Help! I've received this error doing an upgrade to SQL Reporting 1.5 on our DNN 4.5.3 website:
StartJob Begin Sql execution
Info Executing 01.04.00.SqlDataProvider
StartJob Start Sql execution: 01.04.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'Domain'. 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) /** Create Stored Procedures **/ create PROCEDURE dbo.RS2005GetServers @PortalId as int = -1 AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; Select ServerId, ServerName, ServerURL, ServerVersion, UserName, Password, Domain From RS2005Servers Where PortalId = @PortalId or PortalId is null --isnull is just for the upgarde where it is null END System.Data.SqlClient.SqlException: Invalid column name 'Domain'. 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) create PROCEDURE dbo.RS2005UpdateServer -- Add the parameters for the stored procedure here @PortalId as int = -1, @ServerId as Int = 0, @ServerName as varchar(500) = Null, @ServerURL as varchar(500)= Null, @ServerVersion as varchar(50) = NULL, @UserName as varchar(100) = Null, @Password as varchar(100) = Null, @Domain as varchar(100) = Null AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; IF isnull(@ServerId,0) > 0 BEGIN UPDATE RS2005Servers SET [ServerName] = @ServerName ,[ServerURL] = @ServerURL ,[ServerVersion] = @ServerVersion ,[UserName] = @Username ,[Password] = @Password ,[Domain] = @Domain ,PortalId = @PortalId WHERE @ServerId = ServerId END ELSE BEGIN INSERT INTO RS2005Servers ( PortalId, ServerName, ServerURL, ServerVersion, Username, Password, Domain) VALUES ( @PortalId, @ServerName, @ServerURL, @ServerVersion, @Username, @Password, @Domain) END END
EndJob End Sql execution: 01.04.00.SqlDataProvider file |
|
|
|
|
host
Posts:497
|
| 06/14/2007 17:14 |
|
| what were you upgrading from? Can you uninstall the module and reinstlal it? Please let me know what version you were upgrading from. |
|
|
|
|
chiptay
Posts:12
|
| 07/25/2007 17:33 |
|
I have this problem again, except I was did not upgrade DNN this time. I just tried to install version 1.5 of your SSRS module. I had 1.2 installed and tried to install 1.5 over it. Same message:
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'Domain'. 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) /** Create Stored Procedures **/ create PROCEDURE dbo.RS2005GetServers @PortalId as int = -1 AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; Select ServerId, ServerName, ServerURL, ServerVersion, UserName, Password, Domain From RS2005Servers Where PortalId = @PortalId or PortalId is null --isnull is just for the upgarde where it is null END System.Data.SqlClient.SqlException: Invalid column name 'Domain'. 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) create PROCEDURE dbo.RS2005UpdateServer -- Add the parameters for the stored procedure here @PortalId as int = -1, @ServerId as Int = 0, @ServerName as varchar(500) = Null, @ServerURL as varchar(500)= Null, @ServerVersion as varchar(50) = NULL, @UserName as varchar(100) = Null, @Password as varchar(100) = Null, @Domain as varchar(100) = Null AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; IF isnull(@ServerId,0) > 0 BEGIN UPDATE RS2005Servers SET [ServerName] = @ServerName ,[ServerURL] = @ServerURL ,[ServerVersion] = @ServerVersion ,[UserName] = @Username ,[Password] = @Password ,[Domain] = @Domain ,PortalId = @PortalId WHERE @ServerId = ServerId END ELSE BEGIN INSERT INTO RS2005Servers ( PortalId, ServerName, ServerURL, ServerVersion, Username, Password, Domain) VALUES ( @PortalId, @ServerName, @ServerURL, @ServerVersion, @Username, @Password, @Domain) END END
|
|
|
|
|
chiptay
Posts:12
|
| 07/25/2007 17:45 |
|
Question for you: if I uninstall the 1.2 module and then try to re-install the 1.5 module, do I loose all of the report settings I have set up using your module?
I have dozens of reports placed in numerous locations on an intranet. Does that mean I would have to set all of those reports up again?
Thanks. - ChipTay
|
|
|
|
|
host
Posts:497
|
| 07/25/2007 18:28 |
|
| If you have a bunch of reports there already, you do not want to uninstall the module, you will lose those settings. Does the module function after your upgrade? Do you have access to the DNN database to view the table structure? |
|
|
|
|
chiptay
Posts:12
|
| 07/25/2007 18:30 |
|
No, the module doesn't function afterwards. And yes, I can see the DNN database.
The SR2005Servers table does not have "Domain" in it:
/****** Object: Table [dbo].[RS2005Servers] Script Date: 07/25/2007 18:27:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[RS2005Servers](
[ServerId] [int] IDENTITY(1,1) NOT NULL,
[ServerName] [varchar](100) NULL,
[ServerURL] [varchar](500) NULL,
[ServerVersion] [varchar](50) NULL,
[UserName] [varchar](100) NULL,
[Password] [varchar](100) NULL,
CONSTRAINT [_PK_RS2005Servers] PRIMARY KEY CLUSTERED
(
[ServerId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF |
|
|
|
|
host
Posts:497
|
| 07/25/2007 18:48 |
|
The SQL Script from 1.0.2 should have added that, very strange. Please go to host -> sql and choose to run this as a script:
ALTER TABLE {databaseOwner}{objectQualifier}RS2005Servers
ADD [Domain] varchar(100) |
|
|
|
|
chiptay
Posts:12
|
| 07/25/2007 19:04 |
|
| That did it! Thanks. |
|
|
|
|
host
Posts:497
|
| 07/25/2007 19:45 |
|
| Fantastic! |
|
|
|
|
|