Receiving an error with replication

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server Newbies » Receiving an error with replication

Receiving an error with replication

Rate Topic

Display Mode

Topic Options

Author

Message

forceman29

Posted Monday, December 10, 2012 6:13 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:19 PM
Points: 17, Visits: 98

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).

Post #1394840

Gazareth

Posted Tuesday, December 11, 2012 3:47 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Monday, May 20, 2013 1:53 AM
Points: 1,474, Visits: 2,342

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

Post #1395006

forceman29

Posted Thursday, December 13, 2012 9:38 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:19 PM
Points: 17, Visits: 98

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.

Post #1396266

Gazareth

Posted Friday, December 14, 2012 3:12 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Monday, May 20, 2013 1:53 AM
Points: 1,474, Visits: 2,342

No problem, happy to hear it's sorted.

Cheers
Gaz

Post #1396544

« Prev Topic | Next Topic »

Permissions