Installation Questions

Jul 12, 2014 at 4:27 PM
Edited Jul 12, 2014 at 5:30 PM
when running the db install script Portal_LoadData.sql I get many foreign key errors like:

Msg 547, Level 16, State 1, Server <server name>\SQLEXPRESS, Line 631
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Portal_Annou
ncements_PortalCfg_Modules". The conflict occurred in database "Portal", table "
dbo.PortalCfg_Modules", column 'ModuleId'.
The statement has been terminated.

Answer to question

Upon further investigation... In the Portal_LoadData.sql file you need to move all of the inserts into

INSERT [Portal_HtmlText] ([ModuleID], [DesktopHtml], [MobileSummary], [MobileDetails])

below the inserts into

INSERT [Portal_Announcements] ([ItemID], [ModuleID], [CreatedByUser], [CreatedDate], [Title], [MoreLink], [MobileMoreLink], [ExpireDate], [Description]) VALUES (1, 8, N'', CAST(0x0000917A0103F0FC AS DateTime), N'Open Enrollment and Payroll Checklist', N'~/admin/notimplemented.aspx?title=Open%20Enrollment%20and%20Payroll%20Checklist', N'', CAST(0x0000B3C400000000 AS DateTime), N'Please take a few moments to review this year-end checklist that will guide you through the Benefits Open Enrollment process and instruct you on how to ensure your payroll information is accurate for 2001.')

so that the keys are in the Portal_Announcements table.

Thank you!!