| Author |
Message |
emmanuelbuah
Joined: 22 Oct 2010
Posts: 4
|
 Posted: Fri Oct 22, 2010 6:54 pm Post subject: Data Generator fails on bridge table |
 |
|
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: |
/****** 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
|
|
|
| Back to top |
|
 |
james.billings
Joined: 16 Jun 2010
Posts: 844
Location: My desk.
|
| Posted: Mon Oct 25, 2010 2:30 pm Post subject: |
|
|
| 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! |
|
| Back to top |
|
|
emmanuelbuah
Joined: 22 Oct 2010
Posts: 4
|
| Posted: Mon Oct 25, 2010 2:55 pm Post subject: |
|
|
| 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. |
|
| Back to top |
|
|
james.billings
Joined: 16 Jun 2010
Posts: 844
Location: My desk.
|
| Posted: Mon Oct 25, 2010 3:00 pm Post subject: |
|
|
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! |
|
| Back to top |
|
|
emmanuelbuah
Joined: 22 Oct 2010
Posts: 4
|
| Posted: Mon Oct 25, 2010 11:36 pm Post subject: |
|
|
| I replied the support email with attached zip files of the data gen file and pdf file of the error. Thanks. |
|
| Back to top |
|
|
james.billings
Joined: 16 Jun 2010
Posts: 844
Location: My desk.
|
| Posted: Tue Oct 26, 2010 11:13 am Post subject: |
|
|
| We've received those, thanks - I'll take a look |
|
| Back to top |
|
|
emmanuelbuah
Joined: 22 Oct 2010
Posts: 4
|
| Posted: Thu Oct 28, 2010 5:09 pm Post subject: |
|
|
| James, any luck on whether this is a bug or setup/configuration issue on my part. |
|
| Back to top |
|
|
|
