Search

Column '<column name>' does not belong to table summary. (System.Data) by Ole Kristian Bangaas

Active

5
3
Sign in
 to vote
Type: Bug
ID: 769121
Opened: 10/30/2012 1:08:53 AM
Access Restriction: Public
1
Workaround(s)
0
User(s) can reproduce this bug
SQL Server allows article names containing period, which is handy in the cases where you are replicating tables with the same name that are located in different schemas, eg 'Purchase.Orders' and 'Sales.Orders'. However, if you attempt to open Microsoft Replication Conflict Viewer to look at the conflicts, you'll get the following error message:

Column '<column name>' does not belong to table summary. (System.Data)

Due to this error, you cannot override winner/looser for merge conflicts if the article name contains period.
Details (expand)

Product Language

English

Version

SQL Server 2008 R2

Category

Replication

Operating System

Windows Server 2008 R2 Enterprise

Operating System Language

English

Steps to Reproduce

Create a merge replication with articles containing period in the name, and generate a conflict.

Actual Results

Error Dialog:

Column '<column name>' does not belong to table summary. (System.Data)

Expected Results

The conflict should show normally

Platform

X64

Virtualization

 
File Attachments
0 attachments
Sign in to post a comment.
Posted by Microsoft on 4/23/2013 at 3:18 PM
Hi Ole Kristian Bangaas ,

given my previous message, I'm archiving this work item for now.

Best regards
Jean-Yves Devant 
Program Manager Servicing and Lifecycle Experience of High Availability Technologies in SQL Server
Posted by Microsoft on 4/23/2013 at 3:17 PM
Hi Ole Kristian Bangaas, again, thanks for taking the time to share your feedback, this is really important to us. We have fixed the issue. The fix will be available in Service Pack/Public Cumulative Update of SQL Server 2012. Best regards Jean-Yves Devant Program Manager Servicing and Lifecycle Experience of High Availability Technologies in SQL Server
Posted by Microsoft on 3/15/2013 at 5:24 PM
        Hi Ole Kristian Bangaas,
        
        again, thanks for taking the time to share your feedback, this is really important to us. We have fixed the issue. The fix will be available in Service Pack/Public Cumulative Update of SQL Server 2012.
        
        Best regards
        Jean-Yves Devant 
        Program Manager Servicing and Lifecycle Experience of High Availability Technologies in SQL Server
        
        
Posted by Microsoft on 10/30/2012 at 10:34 AM
            Hi Ole Kristian Bangaas ,
                    
            thanks for taking the time to share your feedback, this is really important to us.
            We will investigate the issue and get back to you.
            
            Best regards
            Jean-Yves Devant 
            Program Manager Servicing and Lifecycle Experience of High Availability Technologies in SQL Server
            Program Manager SQL Server Replication, Change Data Capture, Change Tracking
Sign in to post a workaround.
Posted by Ole Kristian Bangaas on 10/30/2012 at 1:10 AM
Create article names without period.
© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement