Red Gate forums :: View topic - Cannot create db from data file
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager Previous Versions
SQL Packager Previous Versions forum

Cannot create db from data file

Search in SQL Packager Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
rwyarger



Joined: 17 Dec 2007
Posts: 7

PostPosted: Mon Dec 17, 2007 7:53 pm    Post subject: Cannot create db from data file Reply with quote

Hello -

I am currently running SQL Packager 5.4.0.89 in 14-day trial mode. My company is having me evaluate this product to see if it might be able to assist us with version control, and just overall better db management of our base and Proddb's.

My problem however is that after creating a schema and data file with SQL Packager - I am unable to create a new db with these files. I have tried the following...

- Creating a .NET exe (error was logged with tech support).

- Creating the db in Microsoft SQL Management Studio (both express and standard have been used with the exact same result...Insufficient System Memory to execute query)

- Creating the db with sqlcmd from the command line (same error as with the Management Studio product).

I have yet to be able to recreate one of our db's with the product.

Any help from anyone would be really appreciated.

Thank you,

Rich Yarger
Hill-Rom Configuration Analyst
Back to top
View user's profile Send private message
rwyarger



Joined: 17 Dec 2007
Posts: 7

PostPosted: Wed Dec 19, 2007 2:44 am    Post subject: Reply with quote

Just to follow up on this thread - here is the error I am getting when trying to recreate the database with the .NET executable that is generated from the SQL Packager tool...

SQL Error: TemplateID,SubCellID MUST EXIST IN DISPLAY_SUBCELLS TABLE
The transaction ended in the trigger. The batch has been aborted.


Assmbly: create_dbStore1


Package: Package28.resx


Batch:Batch51


<SQLError Package="create_db"><Error>TemplateID,SubCellID MUST EXIST IN DISPLAY_SUBCELLS TABLE
The transaction ended in the trigger. The batch has been aborted.</Error><Assembly>create_dbStore1</Assembly><Package>Package28.resx</Package><Batch>Batch51</Batch><SQL>DECLARE @pv binary(16)
INSERT INTO [dbo].[DB_VARS_HISTORY] ([ID], [TheKey], [LastUpdate], [TheValue], [TheTextValue]) VALUES (46, 'SchemaVersion', '20070905 00:02:37.490', 0, '538')
INSERT INTO [dbo].[DB_VARS_HISTORY] ([ID], [TheKey], [LastUpdate], [TheValue], [TheTextValue]) VALUES (47, 'SchemaVersion', '20070905 00:02:37.490', 0, '539')
INSERT INTO [dbo].[DB_VARS_HISTORY] ([ID], [TheKey], [LastUpdate], [TheValue], [TheTextValue]) VALUES (48, 'SchemaVersion', '20070905 00:02:37.490', 0, '540')
INSERT INTO [dbo].[DB_VARS_HISTORY] ([ID], [TheKey], [LastUpdate], [TheValue], [TheTextValue]) VALUES (49, 'SchemaVersion', '20070905 00:02:37.490', 0, '541')
INSERT INTO [dbo].[DB_VARS_HISTORY] ([ID], [TheKey], [LastUpdate], [TheValue], [TheTextValue]) VALUES (50, 'SchemaVersion', '20070905 00:02:37.490', 0, '542')
INSERT INTO [dbo].[DB_VARS_HISTORY] ([ID], [TheKey], [LastUpdate], [TheValue], [TheTextValue]) VALUES (51, 'SchemaVersion', '20070905 00:02:37.490', 0, '543')
INSERT INTO [dbo].[DB_VARS_HISTORY] ([ID], [TheKey], [LastUpdate], [TheValue], [TheTextValue]) VALUES (52, 'SchemaVersion', '20070905 00:02:37.490', 0, '544')
INSERT INTO [dbo].[DB_VARS_HISTORY] ([ID], [TheKey], [LastUpdate], [TheValue], [TheTextValue]) VALUES (53, 'SchemaVersion', '20070905 00:02:37.490', 0, '545')
INSERT INTO [dbo].[DB_VARS_HISTORY] ([ID], [TheKey], [LastUpdate], [TheValue], [TheTextValue]) VALUES (54, 'ReportServerName', '20070905 19:16:27.533', 1, 'ENTER REPORT SERVER NAME HERE')
INSERT INTO [dbo].[DB_VARS_HISTORY] ([ID], [TheKey], [LastUpdate], [TheValue], [TheTextValue]) VALUES (55, 'StandardReports', '20070905 20:00:08.420', 8, 'Release')
INSERT INTO [dbo].[DB_VARS_HISTORY] ([ID], [TheKey], [LastUpdate], [TheValue], [TheTextValue]) VALUES (56, 'ReportServerName', '20070905 20:00:08.437', 1, 'HRNACANCRDPRD12')
INSERT INTO [dbo].[DB_VARS_HISTORY] ([ID], [TheKey], [LastUpdate], [TheValue], [TheTextValue]) VALUES (57, 'StandardReports', '20070907 12:14:15.870', 8, 'Release')
INSERT INTO [dbo].[DB_VARS_HISTORY] ([ID], [TheKey], [LastUpdate], [TheValue], [TheTextValue]) VALUES (58, 'ReportServerName', '20070907 12:14:15.980', 1, 'MCDHAPPNC04')
SET IDENTITY_INSERT [dbo].[DB_VARS_HISTORY] OFF
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 100, 'patient label', 1, 'Patient Information', NULL, 5, 8, 8, 34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '73b48cdb-cb18-4e74-97b8-e8c343093bb8')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 110, 'Last Label', 1, 'Last Name:', NULL, 17, 8, 8, 34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'a240ee63-d71a-4c87-89f1-18915dd8bbde')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 111, 'Last Name', 2, NULL, NULL, 14, 51, 12, 63, -116, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '03970142-2ed1-48d1-9ea0-529c632ec035')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 112, 'First Label', 1, 'First Name:', NULL, 32, 8, 8, 34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'e708a9ee-f956-45dc-b309-6b0cdf77d983')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 113, 'First Name', 2, NULL, NULL, 29, 51, 12, 63, -117, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3c0fde9e-cae0-4c1f-ab23-c3fe71bc8c25')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 114, 'Birthdate Label', 1, 'Birthdate:', NULL, 17, 118, 8, 34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'a97a389c-b962-47e3-91af-8ce5dadf99c0')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 115, 'Birthdate', 9, NULL, NULL, 14, 160, 12, 42, -118, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 1, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '22b1f2d7-23da-4a15-a7e4-b18cef6e7369')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 116, 'Gender Label', 1, 'Gender:', NULL, 32, 118, 8, 39, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'c2dacd90-8e65-470a-9006-005fbca77211')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 117, 'Gender', 2, NULL, NULL, 29, 160, 12, 9, -120, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'ea1fe7e0-3790-416d-9625-ed54ddb13c20')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 118, 'Pt Type Label', 1, 'Patient Type:', NULL, 47, 8, 8, 42, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1156b3a1-d69d-4612-bd55-888c5286d0b4')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 119, 'Pat Type', 2, NULL, NULL, 44, 51, 12, 40, -130, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'e2dea270-1aa8-4c28-b6ec-5225c5477248')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 120, 'SSN Label', 1, 'SSN:', NULL, 47, 118, 8, 33, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'd09ce668-9024-4c5d-8a0f-c97a163de874')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 121, 'SSN', 2, NULL, NULL, 44, 160, 12, 55, -119, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'f731e04e-6c5c-423d-a87b-13a09bac0151')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 123, 'Episode comments', 2, NULL, NULL, 59, 51, 22, 342, -127, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '864b8aa2-e104-4508-a7a3-f660dd028884')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 124, 'Comments Label', 1, 'Comments:', NULL, 60, 8, 9, 39, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'a702f65a-1a2f-42a1-a87b-f8a7a0350211')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 500, 'Location selection group', 14, 'Location Information', NULL, 90, 8, 100, 116, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 203, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '51156205-fec8-4eb5-8d7f-a690d1540705')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 501, 'Location Info Group', 6, 'Location Information', NULL, 90, 8, 100, 116, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '94f9d4ed-5e9a-4611-9a1f-13bb791c3977')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 503, 'Service', 1, NULL, NULL, 105, 43, 93, 78, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 500, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '6573b3e9-8ec5-4778-bbc2-c820588243ed')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 504, 'Service Label', 1, 'Service:', NULL, 103, 13, 8, 26, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '8f5a029f-7119-4284-b3a0-6986af0f7b7e')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 505, 'Area', 2, NULL, NULL, 119, 43, 178, 78, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 500, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'f4343222-556e-46fc-94fc-69be0765558f')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 506, 'Area Label', 1, 'Area:', NULL, 117, 13, 8, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'e05a5ec5-a94e-453e-bc5d-defff7e74926')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 507, 'Location', 3, NULL, NULL, 133, 43, 178, 78, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 500, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '66203c8b-bd73-420e-928e-ae2a7bbf7fac')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 508, 'Loc Label', 1, 'Location:', NULL, 131, 13, 8, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '04a6fd73-d3d4-411a-a332-e0264fbebd46')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 600, 'Sched info Group', 6, 'Schedule Information', NULL, 90, 128, 100, 108, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '5bb96292-bcb4-41a0-9c38-3078c3c44761')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 601, 'Date Label', 1, 'Scheduled Date:', NULL, 105, 131, 8, 53, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4d149b4a-b5de-4d9d-8244-df7727188418')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 602, 'Date', 9, 'Today', NULL, 103, 187, 13, 38, -7, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, 1, 'Please enter procedure date in format MM/DD/YY', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '7de6ff7c-4b59-4a16-a436-a46df9e06b4b')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 603, 'Time Label', 1, 'Time:', NULL, 119, 165, 8, 19, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0fef7757-0504-4a28-a38f-c7cef474c74a')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 604, 'Time', 9, NULL, NULL, 117, 187, 13, 38, -7, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, 2, 'Please enter procedure time in format HH:MM', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '98c85f12-13a4-49e6-98ba-51cff26bd1be')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 605, 'Duration Label', 1, 'Duration:', NULL, 133, 154, 8, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2808e93e-40ca-401e-a0b6-7305e84eba74')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 606, 'Duration', 2, NULL, NULL, 131, 187, 13, 24, -11, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fb0a8d7a-a400-4e2a-8842-a5fdb9be049b')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 607, 'Setup Label', 1, 'Setup:', NULL, 147, 160, 8, 24, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '08094c75-58d2-4d0c-b67a-86a76c6b6e52')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 608, 'Setup Duration', 2, NULL, NULL, 145, 187, 13, 24, -29, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '05281a28-5941-4684-a62c-ae8085c998e7')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 609, 'Cleanup Label', 1, 'Cleanup:', NULL, 161, 157, 8, 27, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '6e27b112-7de0-4fe5-b1c3-f925b1a6f106')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 610, 'Cleanup Duration', 2, NULL, NULL, 159, 187, 13, 24, -30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4f65262f-5cc0-42d4-9b42-267a385ff4ba')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 611, 'To Follow Label', 1, 'To Follow Time:', NULL, 175, 134, 8, 50, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3aeef00a-a96d-4951-81f0-ccecbcd4bc56')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 612, 'TF Time', 9, NULL, NULL, 173, 187, 13, 40, -9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 2, 'Please enter procedure TF time in format HH:MM', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'e20f3a7c-f478-479c-842d-bab17044592d')
INSERT INTO [dbo].[DIALOG_CONTROLS] ([DialogID], [ControlID], [Name], [ControlType], [DefaultText], [StringID], [ControlTop], [ControlLeft], [ControlHeight], [ControlWidth], [FieldID], [EventList], [EventID], [ClearEventID], [DefaultState], [Required], [LeftAction], [RightAction], [JustifyText], [ReadOnly], [MultiLine]
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6644

PostPosted: Wed Dec 19, 2007 11:00 am    Post subject: Reply with quote

Hi Rich,

I think that the error may be prevented by using the SQL Packager option on the data options tab, called 'disable DML triggers'. This will stop triggers from updating anything while the data is inserted.

It would be a good idea, though, to examine the tables that are being updated and make sure that the triggers on them are valid. They may be attempting to do some action that is not valid in the current environment, such as updating another database via a linked server; SQL Packager cannot create linked servers for you so you would be required to create any linked servers manually before attempting to run the package.
Back to top
View user's profile Send private message
rwyarger



Joined: 17 Dec 2007
Posts: 7

PostPosted: Wed Dec 19, 2007 5:28 pm    Post subject: Re: Reply with quote

Brian Donahue wrote:
Hi Rich,

I think that the error may be prevented by using the SQL Packager option on the data options tab, called 'disable DML triggers'. This will stop triggers from updating anything while the data is inserted.

It would be a good idea, though, to examine the tables that are being updated and make sure that the triggers on them are valid. They may be attempting to do some action that is not valid in the current environment, such as updating another database via a linked server; SQL Packager cannot create linked servers for you so you would be required to create any linked servers manually before attempting to run the package.


Hey! Great! That worked!

Now - what has it done that may still need to be tweaked manually since I disabled the "DML triggers" option for the data?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6644

PostPosted: Wed Dec 19, 2007 7:00 pm    Post subject: Reply with quote

Hi Rich,

It's hard to say. Typically you don't need to do anything because the updates that may be done using one or more of your triggers may already be reflected in the data that you have packaged from the source database.

Still, it may be worth having a look at the triggers in Management Studio to see what they're meant to do.
Back to top
View user's profile Send private message
rwyarger



Joined: 17 Dec 2007
Posts: 7

PostPosted: Wed Dec 19, 2007 7:14 pm    Post subject: Re: Reply with quote

Brian Donahue wrote:
Hi Rich,

It's hard to say. Typically you don't need to do anything because the updates that may be done using one or more of your triggers may already be reflected in the data that you have packaged from the source database.

Still, it may be worth having a look at the triggers in Management Studio to see what they're meant to do.


This is going to sound horrible, but our documentation (at least what is provided to our group) is so lacking that I really couldn't tell from looking.

I guess I will use this db to see if any anomalies pop-up. This is a very exciting move in the direction I have been hoping for though, and again - thank you for your insights!!
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group