Cannot create db from data file

rwyargerrwyarger Posts: 8
edited December 19, 2007 1:14PM in SQL Packager Previous Versions
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

Comments

  • 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], [Border], [DisplayCondition], [DateTimeType], [ErrorText], [RoleID], [ParentControl], [ZoneID], [ListID], [ViewPrivilege], [EditPrivilege], [SubCellID], [TemplateID], [DisplayUnits], [EditCondition], [RequireCondition], [ROWID]) VALUES (2, 700, 'Staff Group', 6, 'Procedure Staff', NULL, 90, 240, 100, 158, 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, 'a86e9517-1dbe-4b66-b237-fb9f04c160c0')
    </SQL></SQLError>







    I apologize in advance for the long post, but I only have 7 days left to evaluate this product, and I would like to try and figure out how to get it working before my eval period expires.

    Thank you
  • Brian DonahueBrian Donahue Posts: 6,590 New member
    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.
  • 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?
  • Brian DonahueBrian Donahue Posts: 6,590 New member
    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.
  • 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!!
Sign In or Register to comment.