Data Generator fails on bridge table

emmanuelbuah

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.

/****** 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

James B

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!

emmanuelbuah

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.

James B

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!

emmanuelbuah

I replied the support email with attached zip files of the data gen file and pdf file of the error. Thanks.

James B

We've received those, thanks - I'll take a look

emmanuelbuah

James, any luck on whether this is a bug or setup/configuration issue on my part.