Install of Mddigest_HF-Patient_0.7.0.1_Install.zip Fails

Dec 28, 2009 at 1:17 PM

Hi:

It appears that the above module fails when trying to create the stored procedures. Below is a shortened copy of some of the errors reported:

============================================= -- Author: <Author,,Name> -- Create date: <Create Date,,> -- Description: <Description,,> -- ============================================= CREATE PROCEDURE [dbo].[eh_sp_UpdateReferralRequestStatus] ( @ReferralId int ,@StatusID int ) -- Add the parameters for the stored procedure here AS BEGIN Update eh_tbl_ReferralRequest SET StatusID=@StatusID where ReferralId=@ReferralId 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].[eh_sp_UpdateObstetrics]') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'CREATE proc [dbo].[eh_sp_UpdateObstetrics] ( @ID int , @PatientID int , @Numberofpregnancies int , @FullTermDeliveries int , @PreTermDeliveries int , @NumberofMiscarriages int , @NumberofLivingChildren int , @MethodofContraception varchar(100) ) as begin Update [dbo].[eh_tbl_Obstetrics] SET [PatientID]=@PatientID , [Numberofpregnancies]=@Numberofpregnancies , [FullTermDeliveries]=@FullTermDeliveries , [PreTermDeliveries]=@PreTermDeliveries , [NumberofMiscarriages]=@NumberofMiscarriages , [NumberofLivingChildren]=@NumberofLivingChildren , [MethodofContraception]=@MethodofContraception Where ID=@ID end exec eh_sp_AddObstetrics ' 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) IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_eh_tbl_PatientAllergies_eh_tbl_PatientAllergies]') AND parent_object_id = OBJECT_ID(N'[dbo].[eh_tbl_PatientAllergies]')) ALTER TABLE [dbo].[eh_tbl_PatientAllergies] WITH CHECK ADD CONSTRAINT [FK_eh_tbl_PatientAllergies_eh_tbl_PatientAllergies] FOREIGN KEY([IssueId]) REFERENCES [dbo].[eh_tbl_PatientAllergies] ([IssueId]) System.Data.SqlClient.SqlException: Cannot alter table 'dbo.eh_tbl_PatientAllergies' because this table does not exist in database 'DotNetNuke'. 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) ALTER TABLE [dbo].[eh_tbl_PatientAllergies] CHECK CONSTRAINT [FK_eh_tbl_PatientAllergies_eh_tbl_PatientAllergies] 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 NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_eh_tbl_RequestAppointment_eh_tbl_PhysicianProfile]') AND parent_object_id = OBJECT_ID(N'[dbo].[eh_tbl_RequestAppointment]')) ALTER TABLE [dbo].[eh_tbl_RequestAppointment] WITH CHECK ADD CONSTRAINT [FK_eh_tbl_RequestAppointment_eh_tbl_PhysicianProfile] FOREIGN KEY([PhysicianId]) REFERENCES [dbo].[eh_tbl_PhysicianProfile] ([PhysicianID]) System.Data.SqlClient.SqlException: Cannot alter table 'dbo.eh_tbl_RequestAppointment' because this table does not exist in database 'DotNetNuke'. 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) ALTER TABLE [dbo].[eh_tbl_RequestAppointment] CHECK CONSTRAINT [FK_eh_tbl_RequestAppointment_eh_tbl_PhysicianProfile] 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 NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_eh_tbl_PracticeLocations_eh_tbl_PracticeProfile]') AND parent_object_id = OBJECT_ID(N'[dbo].[eh_tbl_PracticeLocations]')) ALTER TABLE [dbo].[eh_tbl_PracticeLocations] WITH CHECK ADD CONSTRAINT [FK_eh_tbl_PracticeLocations_eh_tbl_PracticeProfile] FOREIGN KEY([PracticeID]) REFERENCES [dbo].[eh_tbl_PracticeProfile] ([PracticeID]) System.Data.SqlClient.SqlException: Cannot alter table 'dbo.eh_tbl_PracticeLocations' because this table does not exist in database 'DotNetNuke'. 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) ALTER TABLE [dbo].[eh_tbl_PracticeLocations] CHECK CONSTRAINT [FK_eh_tbl_PracticeLocations_eh_tbl_PracticeProfile] 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 NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_eh_tbl_PhysicianProfile_eh_tbl_PracticeProfile]') AND parent_object_id = OBJECT_ID(N'[dbo].[eh_tbl_PhysicianProfile]')) ALTER TABLE [dbo].[eh_tbl_PhysicianProfile] WITH CHECK ADD CONSTRAINT [FK_eh_tbl_PhysicianProfile_eh_tbl_PracticeProfile] FOREIGN KEY([PracticeID]) REFERENCES [dbo].[eh_tbl_PracticeProfile] ([PracticeID]) System.Data.SqlClient.SqlException: Cannot alter table 'dbo.eh_tbl_PhysicianProfile' because this table does not exist in database 'DotNetNuke'. 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) ALTER TABLE [dbo].[eh_tbl_PhysicianProfile] CHECK CONSTRAINT [FK_eh_tbl_PhysicianProfile_eh_tbl_PracticeProfile] System.Data.SqlClient.SqlException: Line 10: 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].[eh_tb_Medical_IssuesType]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[eh_tb_Medical_IssuesType]( [ID] [int] IDENTITY(1,1) NOT NULL, [Text] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, CONSTRAINT [PK_ehealth_Medical_IssuesType] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ) END System.Data.SqlClient.SqlException: Table 'dbo.eh_tb_Medical_IssuesType' does not exist or cannot be opened for SET operation. 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) SET IDENTITY_INSERT [dbo].[eh_tb_Medical_IssuesType] ON INSERT [dbo].[eh_tb_Medical_IssuesType] ([ID], [Text]) VALUES (1, N'Problems') INSERT [dbo].[eh_tb_Medical_IssuesType] ([ID], [Text]) VALUES (2, N'Allergies') INSERT [dbo].[eh_tb_Medical_IssuesType] ([ID], [Text]) VALUES (3, N'OtherAllergies') SET IDENTITY_INSERT [dbo].[eh_tb_Medical_IssuesType] OFF /****** Object: Table [dbo].[eh_tbl_PracticeType] Script Date: 08/04/2009 08:59:33 ******/ SET ANSI_NULLS ON System.Data.SqlClient.SqlException: Line 10: 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].[eh_tbl_PracticeType]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[eh_tbl_PracticeType]( [PracticeTypeID] [int] IDENTITY(1,1) NOT NULL, [PracticeType] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, CONSTRAINT [PK_eh_tbl_PracticeType] PRIMARY KEY CLUSTERED ( [PracticeTypeID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ) END System.Data.SqlClient.SqlException: Table 'dbo.eh_tbl_PracticeType' does not exist or cannot be opened for SET operation. 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) SET IDENTITY_INSERT [dbo].[eh_tbl_PracticeType] ON INSERT [dbo].[eh_tbl_PracticeType] ([PracticeTypeID], [PracticeType]) VALUES (1, N'Solo') INSERT [dbo].[eh_tbl_PracticeType] ([PracticeTypeID], [PracticeType]) VALUES (2, N'Single Specialty Group') INSERT [dbo].[eh_tbl_PracticeType] ([PracticeTypeID], [PracticeType]) VALUES (3, N'Multi Specialty Group') INSERT [dbo].[eh_tbl_PracticeType] ([PracticeTypeID], [PracticeType]) VALUES (4, N'Residency Practice') INSERT [dbo].[eh_tbl_PracticeType] ([PracticeTypeID], [PracticeType]) VALUES (5, N'Community Health Center') INSERT [dbo].[eh_tbl_PracticeType] ([PracticeTypeID], [PracticeType]) VALUES (6, N'Other(please specify)') SET IDENTITY_INSERT [dbo].[eh_tbl_PracticeType] OFF /****** Object: Table [dbo].[eh_tbl_Specialty] Script Date: 08/04/2009 08:59:33 ******/ SET ANSI_NULLS ON System.Data.SqlClient.SqlException: Line 10: 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].[eh_tbl_Specialty]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[eh_tbl_Specialty]( [SpecialtyID] [int] NOT NULL, [Specialty] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, CONSTRAINT [PK_eh_tbl_Specialty] PRIMARY KEY CLUSTERED ( [SpecialtyID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ) END System.Data.SqlClient.SqlException: Invalid object name 'dbo.eh_tbl_Specialty'. 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) INSERT [dbo].[eh_tbl_Specialty] ([SpecialtyID], [Specialty]) VALUES (1, N'Pediatrics') INSERT [dbo].[eh_tbl_Specialty] ([SpecialtyID], [Specialty]) VALUES (2, N'Family Medicine') INSERT [dbo].[eh_tbl_Specialty] ([SpecialtyID], [Specialty]) VALUES (3, N'Internal Medicine') INSERT [dbo].[eh_tbl_Specialty] ([SpecialtyID], [Specialty]) VALUES (4, N'Other') /****** Object: Table [dbo].[eh_tbl_Patient_History_Exams] Script Date: 08/04/2009 08:59:33 ******/ SET ANSI_NULLS ON System.Data.SqlClient.SqlException: Line 10: 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].[eh_tbl_Patient_History_Exams]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[eh_tbl_Patient_History_Exams]( [ExamsID] [int] IDENTITY(1,1) NOT NULL, [ExamName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, CONSTRAINT [PK_eh_tbl_Patient_History_Exams] PRIMARY KEY CLUSTERED ( [ExamsID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ) END System.Data.SqlClient.SqlException: Table 'dbo.eh_tbl_Patient_History_Exams' does not exist or cannot be opened for SET operation. 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) SET IDENTITY_INSERT [dbo].[eh_tbl_Patient_History_Exams] ON INSERT [dbo].[eh_tbl_Patient_History_Exams] ([ExamsID], [ExamName]) VALUES (1, N'Breast Exam') INSERT [dbo].[eh_tbl_Patient_History_Exams] ([ExamsID], [ExamName]) VALUES (2, N'Cardiac Echo') INSERT [dbo].[eh_tbl_Patient_History_Exams] ([ExamsID], [ExamName]) VALUES (3, N'ECG') INSERT [dbo].[eh_tbl_Patient_History_Exams] ([ExamsID], [ExamName]) VALUES (4, N'Gynecological Exam') INSERT [dbo].[eh_tbl_Patient_History_Exams] ([ExamsID], [ExamName]) VALUES (5, N'Mammogram') INSERT [dbo].[eh_tbl_Patient_History_Exams] ([ExamsID], [ExamName]) VALUES (6, N'Physical Exam') INSERT [dbo].[eh_tbl_Patient_History_Exams] ([ExamsID], [ExamName]) VALUES (7, N'Prostate Exam') INSERT [dbo].[eh_tbl_Patient_History_Exams] ([ExamsID], [ExamName]) VALUES (8, N'Rectal Exam') INSERT [dbo].[eh_tbl_Patient_History_Exams] ([ExamsID], [ExamName]) VALUES (9, N'Sigmoid/Colonoscopy') INSERT [dbo].[eh_tbl_Patient_History_Exams] ([ExamsID], [ExamName]) VALUES (10, N'Retinal Exam') INSERT [dbo].[eh_tbl_Patient_History_Exams] ([ExamsID], [ExamName]) VALUES (11, N'Flu Vaccination') INSERT [dbo].[eh_tbl_Patient_History_Exams] ([ExamsID], [ExamName]) VALUES (12, N'Pneumonia Vaccination') INSERT [dbo].[eh_tbl_Patient_History_Exams] ([ExamsID], [ExamName]) VALUES (13, N'LDL') INSERT [dbo].[eh_tbl_Patient_History_Exams] ([ExamsID], [ExamName]) VALUES (14, N'Hemoglobin') INSERT [dbo].[eh_tbl_Patient_History_Exams] ([ExamsID], [ExamName]) VALUES (15, N'PSA ') SET IDENTITY_INSERT [dbo].[eh_tbl_Patient_History_Exams] OFF /****** Object: Table [dbo].[eh_tbl_RiskFactorCategories] Script Date: 08/04/2009 08:59:33 ******/ SET ANSI_NULLS ON 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].[eh_tbl_RiskFactorCategories]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[eh_tbl_RiskFactorCategories]( [CategoryID] [int] IDENTITY(1,1) NOT NULL, [CategoryName] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) END System.Data.SqlClient.SqlException: Table 'dbo.eh_tbl_RiskFactorCategories' does not exist or cannot be opened for SET operation. 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) SET IDENTITY_INSERT [dbo].[eh_tbl_RiskFactorCategories] ON INSERT [dbo].[eh_tbl_RiskFactorCategories] ([CategoryID], [CategoryName]) VALUES (1, N'Pulmonary ') INSERT [dbo].[eh_tbl_RiskFactorCategories] ([CategoryID], [CategoryName]) VALUES (2, N'Cardiovascular ') INSERT [dbo].[eh_tbl_RiskFactorCategories] ([CategoryID], [CategoryName]) VALUES (3, N'GI') INSERT [dbo].[eh_tbl_RiskFactorCategories] ([CategoryID], [CategoryName]) VALUES (4, N'Endocrinology') INSERT [dbo].[eh_tbl_RiskFactorCategories] ([CategoryID], [CategoryName]) VALUES (5, N'Neurology') INSERT [dbo].[eh_tbl_RiskFactorCategories] ([CategoryID], [CategoryName]) VALUES (6, N'Allergy/Immunology') INSERT [dbo].[eh_tbl_RiskFactorCategories] ([CategoryID], [CategoryName]) VALUES (7, N'Surgery') INSERT [dbo].[eh_tbl_RiskFactorCategories] ([CategoryID], [CategoryName]) VALUES (8, N'Urology') INSERT [dbo].[eh_tbl_RiskFactorCategories] ([CategoryID], [CategoryName]) VALUES (9, N'Hematology') INSERT [dbo].[eh_tbl_RiskFactorCategories] ([CategoryID], [CategoryName]) VALUES (10, N'Infectious Disease') INSERT [dbo].[eh_tbl_RiskFactorCategories] ([CategoryID], [CategoryName]) VALUES (11, N'Ortho/Rheumatology') INSERT [dbo].[eh_tbl_RiskFactorCategories] ([CategoryID], [CategoryName]) VALUES (12, N'Ophthomology') INSERT [dbo].[eh_tbl_RiskFactorCategories] ([CategoryID], [CategoryName]) VALUES (13, N'Dermatology') INSERT [dbo].[eh_tbl_RiskFactorCategories] ([CategoryID], [CategoryName]) VALUES (14, N'Oncology') INSERT [dbo].[eh_tbl_RiskFactorCategories] ([CategoryID], [CategoryName]) VALUES (15, N'Psychiatry') SET IDENTITY_INSERT [dbo].[eh_tbl_RiskFactorCategories] OFF /****** Object: Table [dbo].[eh_tbl_RiskFactors] Script Date: 08/04/2009 08:59:33 ******/ SET ANSI_NULLS ON System.Data.SqlClient.SqlException: Line 11: 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].[eh_tbl_RiskFactors]') AND type in (N'U')) BEGIN CREATE TABLE [dbo].[eh_tbl_RiskFactors]( [ID] [int] IDENTITY(1,1) NOT NULL, [SubCategoryName] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [RelationID] [int] NULL, CONSTRAINT [PK_eh_tbl_riskfactors] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ) END System.Data.SqlClient.SqlException: Table 'dbo.eh_tbl_RiskFactors' does not exist or cannot be opened for SET operation. 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) SET IDENTITY_INSERT [dbo].[eh_tbl_RiskFactors] ON INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (1, N'Asthma', 1) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (2, N'COPD', 1) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (3, N'Bronchitis', 1) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (4, N'Sleep Apnea', 1) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (5, N'Varicose Veins', 2) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (6, N'High Blood Pressure', 2) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (7, N'Heart Disease', 2) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (8, N'Stroke', 2) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (9, N'DVT', 2) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (10, N'Valve Disease', 2) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (11, N'Gallbladder Disease', 3) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (12, N'Hepatitis', 3) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (13, N'Gastric Ulcers', 3) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (14, N'Diverticular Disease', 3) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (15, N'Diabetes', 4) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (16, N'Hypothyroid', 4) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (17, N'Seizure Disorder', 5) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (18, N'MS', 5) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (19, N'Seasonal Allergies', 6) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (20, N'Food Allergies', 6) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (21, N'Tonsillectomy', 7) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (22, N'Lumpectomy', 7) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (23, N'Mastectomy', 7) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (24, N'Appendectomy', 7) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (25, N'Cholecystectomy', 7) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (26, N'Hysterectomy', 7) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (27, N'Oopherectomy', 7) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (28, N'Kidney Disease', 8) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (29, N'Urinary Tract Infections', 8) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (30, N'Iron Deficiency Anemia', 9) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (31, N'Sickle Cell Anemia', 9) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (32, N'Clotting Disorder', 9) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (33, N'Bleeding Disorder', 9) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (34, N'HIV', 10) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (35, N'Tuberculosis', 10) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (36, N'Shingles', 10) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (37, N'Rheumatoid Arthritis', 11) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (38, N'Osteoarthritis', 11) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (39, N'Fibromyalgia', 11) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (40, N'Osteoporosis', 11) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (41, N'Disc Disease', 11) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (42, N'Cataracts', 12) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (43, N'Glaucoma', 12) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (44, N'Psoriasis', 13) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (45, N'Acne', 13) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (46, N'Eczema', 13) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (47, N'Lymphoma', 14) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (48, N'Leukemia', 14) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (49, N'Lung Cancer', 14) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (50, N'Colon Cancer', 14) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (51, N'Melanoma', 14) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (52, N'Breast Cancer', 14) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (53, N'Cervical Cancer', 14) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (54, N'Ovarian Cancer', 14) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (55, N'Prostate Cancer', 14) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (56, N'Depression', 15) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (57, N'ADD/ADHD', 15) INSERT [dbo].[eh_tbl_RiskFactors] ([ID], [SubCategoryName], [RelationID]) VALUES (58, N'Bipolar', 15) SET IDENTITY_INSERT [dbo].[eh_tbl_RiskFactors] OFF
Info End Sql execution: 01.00.00.SqlDataProvider file
Info Finished Sql execution
Failure Installation Failed - Script
Info Installation Failed - HF-Patient
Info Starting Installation - HF-Calendar
Info Starting Installation - Module
Info Module registered successfully - HF-Calendar
Info Component installed successfully - Module
Failure Package Installation aborted
Info Installation Failed - HF-Calendar
Info Starting Installation - HF-PatientBanner
Info Starting Installation - Module
Info Module registered successfully - HF-PatientBanner
Info Component installed successfully - Module
Failure Package Installation aborted
Info Installation Failed - HF-PatientBanner
Info Starting Installation - HF-Navigation
Info Starting Installation - Module
Info Module registered successfully - HF-Navigation
Info Component installed successfully - Module
Failure Package Installation aborted
Info Installation Failed - HF-Navigation
Info Starting Installation - HF-SearchPatient
Info Starting Installation - Module
Info Module registered successfully - HF-SearchPatient
Info Component installed successfully - Module
Failure Package Installation aborted
Info Installation Failed - HF-SearchPatient
Info Starting Installation - HF-SearchPatientResult
Info Starting Installation - Module
Info Module registered successfully - HF-SearchPatientResult
Info Component installed successfully - Module
Failure Package Installation aborted
Info Installation Failed - HF-SearchPatientResult
Info Starting Installation - HF-PracticeMonitor
Info Starting Installation - Module
Info Module registered successfully - HF-PracticeMonitor
Info Component installed successfully - Module
Failure Package Installation aborted
Info Installation Failed - HF-PracticeMonitor
Info Deleted temporary install folder
EndJob Installation Failed