December 10, 2012 at 6:13 pm
Hey Guys,
I'm running SQL server 2008 R2. The Programming department wants to have a database replicate to a different database that they will use for reporting. I have been able to setup the publications and subscriptions no problem.
I've created the snapshot without any problems.
The issue I run into is (I see the following error when I go into the Replication Monitor)
"Column name or number of supplied values does not match table definition."
Is there a way with replication to force changes unto the subscriber? Record the error but ignore them and continue?
Here is the detail's of the message
CREATE PROCEDURE [dbo].[p_MatchMaker_PrepHistReports]
@WorkUnit int = 500
AS
BEGIN
SET NOCOUNT ON;
DECLARE @Threshold DateTime
SET @Threshold = DATEADD(DAY,-1,GETDATE())
TRUNCATE TABLE Match_Reports
INSERT INTO Match_Reports
SELECT TOP (@WorkU
(Transaction sequence number: 0x000030E900006A8100B300000000, Command ID: 742)
Any idea? I'm new to sql in the sense i've been managing sql in a light sense till now. Now i'm required to go deeper and this is one of them (before it was just simple database backups, restores, user management).
December 11, 2012 at 3:47 am
Hi,
Sounds like more a problem with the insert into Match_Reports table than replication per se.
Have a look at the definition of dbo.p_MatchMaker_PrepHistReports (it looks truncated in the error message/your post) & check the insert statement there.
I think the proc may be providing too many parameters in comparison to no. of columns in Match_Report table.
Cheers
Gaz
December 13, 2012 at 9:39 am
Hey Gazareth,
Thank you for the help. That is exactly what i needed. I gave the info to a programmer and he new exactly what the problem was.
Thanks again.
December 14, 2012 at 3:12 am
No problem, happy to hear it's sorted.
Cheers
Gaz
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply