Data Generator fails on bridge table

The simplest way to populate your database with test data.

Moderators: David Atkinson, Anu Deshpande, Lionel

Data Generator fails on bridge table

Postby emmanuelbuah » Fri Oct 22, 2010 6:54 pm

Below is my table structure for which im trying to generate test data. I have the project configured to generate 1 business, 7 businessgroups , 1000 businessmemebers and 1500 businessgroupmembers. Business, businessgroup and businessmember generates without error but businessgroupmembers fails. Is this a bug or I'm missing something here.


Code: Select all
/****** Object:  Table [dbo].[Business]    Script Date: 10/22/2010 07:58:14 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Business](
   [BusinessId] [int] IDENTITY(1,1) NOT NULL,
 CONSTRAINT [Business_PK] PRIMARY KEY CLUSTERED
(
   [BusinessId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO



/****** Object:  Table [dbo].[BusinessGroup]    Script Date: 10/22/2010 07:58:29 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[BusinessGroup](
   [BusinessId] [int] NOT NULL,
   [BusinessGroupId] [int] IDENTITY(1,1) NOT NULL,
 CONSTRAINT [PK_BusinessGroup] PRIMARY KEY CLUSTERED
(
   [BusinessId] ASC,
   [BusinessGroupId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[BusinessGroup]  WITH NOCHECK ADD  CONSTRAINT [Business_FK_BusinessGroup] FOREIGN KEY([BusinessId])
REFERENCES [dbo].[Business] ([BusinessId])
GO

ALTER TABLE [dbo].[BusinessGroup] CHECK CONSTRAINT [Business_FK_BusinessGroup]
GO




/****** Object:  Table [dbo].[BusinessGroupMember]    Script Date: 10/22/2010 07:58:40 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[BusinessGroupMember](
   [BusinessMemberId] [int] NOT NULL,
   [BusinessGroupId] [int] NOT NULL,
   [BusinessGroupBusinessId] [int] NOT NULL,
   [BusinessMemberBusinessId] [int] NOT NULL
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[BusinessGroupMember]  WITH NOCHECK ADD  CONSTRAINT [FK_BusinessGroupMember_BusinessGroup1] FOREIGN KEY([BusinessGroupBusinessId], [BusinessGroupId])
REFERENCES [dbo].[BusinessGroup] ([BusinessId], [BusinessGroupId])
GO

ALTER TABLE [dbo].[BusinessGroupMember] CHECK CONSTRAINT [FK_BusinessGroupMember_BusinessGroup1]
GO

ALTER TABLE [dbo].[BusinessGroupMember]  WITH NOCHECK ADD  CONSTRAINT [FK_BusinessGroupMember_BusinessMember] FOREIGN KEY([BusinessMemberBusinessId], [BusinessMemberId])
REFERENCES [dbo].[BusinessMember] ([BusinessId], [BusinessMemberId])
GO

ALTER TABLE [dbo].[BusinessGroupMember] CHECK CONSTRAINT [FK_BusinessGroupMember_BusinessMember]
GO


USE [WorkSpace]
GO

/****** Object:  Table [dbo].[BusinessMember]    Script Date: 10/22/2010 07:58:48 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[BusinessMember](
   [BusinessId] [int] NOT NULL,
   [BusinessMemberId] [int] IDENTITY(1,1) NOT NULL,
 CONSTRAINT [PK_BusinessMember_1] PRIMARY KEY CLUSTERED
(
   [BusinessId] ASC,
   [BusinessMemberId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[BusinessMember]  WITH NOCHECK ADD  CONSTRAINT [Business_FK_BusinessMember] FOREIGN KEY([BusinessId])
REFERENCES [dbo].[Business] ([BusinessId])
GO

ALTER TABLE [dbo].[BusinessMember] CHECK CONSTRAINT [Business_FK_BusinessMember]
GO

emmanuelbuah
 
Posts: 4
Joined: Fri Oct 22, 2010 2:02 pm

Postby james.billings » Mon Oct 25, 2010 2:30 pm

I've opened you a support ticket and contacted you directly to work through this - let me know if you don't get the email!
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Postby emmanuelbuah » Mon Oct 25, 2010 2:55 pm

I received the email but it only said someone will contact me so I don't know if I'm suppose to wait. I haven't received any direct email from you James. I received one email and that was from support. Let me know.
emmanuelbuah
 
Posts: 4
Joined: Fri Oct 22, 2010 2:02 pm

Postby james.billings » Mon Oct 25, 2010 3:00 pm

OK - I was basically after your data generator project file, as I tried to replicate the problem but got different results. Could you reply to the auto-email with that, and also the error you were seeing?

Thanks!
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Postby emmanuelbuah » Mon Oct 25, 2010 11:36 pm

I replied the support email with attached zip files of the data gen file and pdf file of the error. Thanks.
emmanuelbuah
 
Posts: 4
Joined: Fri Oct 22, 2010 2:02 pm

Postby james.billings » Tue Oct 26, 2010 11:13 am

We've received those, thanks - I'll take a look
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Postby emmanuelbuah » Thu Oct 28, 2010 5:09 pm

James, any luck on whether this is a bug or setup/configuration issue on my part.
emmanuelbuah
 
Posts: 4
Joined: Fri Oct 22, 2010 2:02 pm


Return to SQL Data Generator 1

Who is online

Users browsing this forum: No registered users and 0 guests

cron