|
|
You're in the
sql server replication
group:Merge Replication Error: Column names in each table must be unique.
sql server replication:
them, others are: reason_code, source_object, reason_text, conflict_type, origin_datasource, tablenick, and create_time. If any of your tables have columns with these names in them, your snapshot will fail with a message similar to the one you are getting. You will have to change the column names for this to work. -- Hilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html [quoted text, click to view] "Noman Qureshi" <nomq@hotmail.com> wrote in message news:%23h4bWBg7EHA.2180@TK2MSFTNGP10.phx.gbl... > Hello All > > I am new to SQL and facing problem creating merge replication, searched MS > site but found nothing on it > > I have created a new merge publication with all the tables in a DB, this > error occurs wile snapshot agent starts to create the snapshot error is > > Snapshot Agent Error Details > > Error: > "Column names in each table must be unique. Column name 'PubID' in table > 'aonflict_NomBilling_PubPage' is specified more than once." > > Category = Data source > Source = sqlserver1 > Number = 2705 > > At this point the snap shot agent aborts > > Any advice/solution > > Thanks & Regards > > Qazi M. >
Hello All
I am new to SQL and facing problem creating merge replication, searched MS site but found nothing on it I have created a new merge publication with all the tables in a DB, this error occurs wile snapshot agent starts to create the snapshot error is Snapshot Agent Error Details Error: "Column names in each table must be unique. Column name 'PubID' in table 'aonflict_NomBilling_PubPage' is specified more than once." Category = Data source Source = sqlserver1 Number = 2705 At this point the snap shot agent aborts Any advice/solution Thanks & Regards Qazi M.
Thanks for you reply Hilary
The table and column is in use of five applications, is there any other workaround for this problem (else have to modify and recompile all the applications) [quoted text, click to view] "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:eMHGaLg7EHA.1300@TK2MSFTNGP14.phx.gbl... > there are some reserved column names in merge replication. PubID is one of > them, others are: reason_code, source_object, reason_text, > conflict_type, origin_datasource, tablenick, and create_time. > > If any of your tables have columns with these names in them, your snapshot > will fail with a message similar to the one you are getting. > > You will have to change the column names for this to work. > > -- > Hilary Cotter > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > "Noman Qureshi" <nomq@hotmail.com> wrote in message > news:%23h4bWBg7EHA.2180@TK2MSFTNGP10.phx.gbl... >> Hello All >> >> I am facing problem creating merge replication, searched MS site but >> found nothing on it >> >> I have created a new merge publication with all the tables in a DB, this >> error occurs wile snapshot agent starts to create the snapshot error is >> >> Snapshot Agent Error Details >> >> Error: >> "Column names in each table must be unique. Column name 'PubID' in table >> 'aonflict_NomBilling_PubPage' is specified more than once." >> >> Category = Data source >> Source = sqlserver1 >> Number = 2705 >> >> At this point the snap shot agent aborts >> >> Any advice/solution >> >> Thanks & Regards >> >> Qazi M. >> > >
If your tables are small, you could have the application write to views
which correspond to the underlying tables, only the column names in the underlying tables are correct, but pubid would be in the view. If the tables are larger you would have to go with indexed views. -- Hilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html [quoted text, click to view] "Noman Qureshi" <nomq@hotmail.com> wrote in message news:%23bNObWg7EHA.1404@TK2MSFTNGP11.phx.gbl... > Thanks for you reply Hilary > The table and column is in use of five applications, is there any other > workaround for this problem > > (else have to modify and recompile all the applications) > > > "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message > news:eMHGaLg7EHA.1300@TK2MSFTNGP14.phx.gbl... > > there are some reserved column names in merge replication. PubID is one of > > them, others are: reason_code, source_object, reason_text, > > conflict_type, origin_datasource, tablenick, and create_time. > > > > If any of your tables have columns with these names in them, your snapshot > > will fail with a message similar to the one you are getting. > > > > You will have to change the column names for this to work. > > > > -- > > Hilary Cotter > > Looking for a SQL Server replication book? > > http://www.nwsu.com/0974973602.html > > "Noman Qureshi" <nomq@hotmail.com> wrote in message > > news:%23h4bWBg7EHA.2180@TK2MSFTNGP10.phx.gbl... > >> Hello All > >> > >> I am facing problem creating merge replication, searched MS site but > >> found nothing on it > >> > >> I have created a new merge publication with all the tables in a DB, this > >> error occurs wile snapshot agent starts to create the snapshot error is > >> > >> Snapshot Agent Error Details > >> > >> Error: > >> "Column names in each table must be unique. Column name 'PubID' in table > >> 'aonflict_NomBilling_PubPage' is specified more than once." > >> > >> Category = Data source > >> Source = sqlserver1 > >> Number = 2705 > >> > >> At this point the snap shot agent aborts > >> > >> Any advice/solution > >> > >> Thanks & Regards > >> > >> Qazi M. > >> > > > > > >
You could create a "mirror table", with the only difference from original -
changed name of problematic column. And you could include this table in replication. Of course you would gave to make sure that all the actions (insert/update/delete) which are done on original table, would also be done on "mirror table" and vice versa. That could be done by triggers, hopefully without big problems. -- Regards, Kestutis Adomavicius Consultant UAB "Baltic Software Solutions" [quoted text, click to view] "Noman Qureshi" <nomq@hotmail.com> wrote in message news:%23bNObWg7EHA.1404@TK2MSFTNGP11.phx.gbl... > Thanks for you reply Hilary > The table and column is in use of five applications, is there any other > workaround for this problem > > (else have to modify and recompile all the applications) > > > "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message > news:eMHGaLg7EHA.1300@TK2MSFTNGP14.phx.gbl... > > there are some reserved column names in merge replication. PubID is one of > > them, others are: reason_code, source_object, reason_text, > > conflict_type, origin_datasource, tablenick, and create_time. > > > > If any of your tables have columns with these names in them, your snapshot > > will fail with a message similar to the one you are getting. > > > > You will have to change the column names for this to work. > > > > -- > > Hilary Cotter > > Looking for a SQL Server replication book? > > http://www.nwsu.com/0974973602.html > > "Noman Qureshi" <nomq@hotmail.com> wrote in message > > news:%23h4bWBg7EHA.2180@TK2MSFTNGP10.phx.gbl... > >> Hello All > >> > >> I am facing problem creating merge replication, searched MS site but > >> found nothing on it > >> > >> I have created a new merge publication with all the tables in a DB, this > >> error occurs wile snapshot agent starts to create the snapshot error is > >> > >> Snapshot Agent Error Details > >> > >> Error: > >> "Column names in each table must be unique. Column name 'PubID' in table > >> 'aonflict_NomBilling_PubPage' is specified more than once." > >> > >> Category = Data source > >> Source = sqlserver1 > >> Number = 2705 > >> > >> At this point the snap shot agent aborts > >> > >> Any advice/solution > >> > >> Thanks & Regards > >> > >> Qazi M. > >> > > > > > >
Thanks for the reply Hilary, Kestutis
We have decided that it is batter to update the applications and rename the problematic column, that will make our DB more compliant to (MS) standards and will be beneficial for us in the future, who knows what we will get in the next patch/sp or future version of SQL . We have forwarded the column names provided by Hilary to our development team so they can avoid them in the future. Thanks again Regards & Best Wishes Noman Qureshi "Even impossible says I M Possible" [quoted text, click to view] "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:O2Rp$Yp7EHA.2676@TK2MSFTNGP12.phx.gbl... > If your tables are small, you could have the application write to views > which correspond to the underlying tables, only the column names in the > underlying tables are correct, but pubid would be in the view. If the > tables > are larger you would have to go with indexed views. > > -- > Hilary Cotter > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > "Noman Qureshi" <nomq@hotmail.com> wrote in message > news:%23bNObWg7EHA.1404@TK2MSFTNGP11.phx.gbl... >> Thanks for you reply Hilary >> The table and column is in use of five applications, is there any other >> workaround for this problem >> >> (else have to modify and recompile all the applications) >> >> >> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >> news:eMHGaLg7EHA.1300@TK2MSFTNGP14.phx.gbl... >> > there are some reserved column names in merge replication. PubID is one > of >> > them, others are: reason_code, source_object, reason_text, >> > conflict_type, origin_datasource, tablenick, and create_time. >> > >> > If any of your tables have columns with these names in them, your > snapshot >> > will fail with a message similar to the one you are getting. >> > >> > You will have to change the column names for this to work. >> > >> > -- >> > Hilary Cotter >> > Looking for a SQL Server replication book? >> > http://www.nwsu.com/0974973602.html >> > "Noman Qureshi" <nomq@hotmail.com> wrote in message >> > news:%23h4bWBg7EHA.2180@TK2MSFTNGP10.phx.gbl... >> >> Hello All >> >> >> >> I am facing problem creating merge replication, searched MS site but >> >> found nothing on it >> >> >> >> I have created a new merge publication with all the tables in a DB, > this >> >> error occurs wile snapshot agent starts to create the snapshot error >> >> is >> >> >> >> Snapshot Agent Error Details >> >> >> >> Error: >> >> "Column names in each table must be unique. Column name 'PubID' in > table >> >> 'aonflict_NomBilling_PubPage' is specified more than once." >> >> >> >> Category = Data source >> >> Source = sqlserver1 >> >> Number = 2705 >> >> >> >> At this point the snap shot agent aborts >> >> >> >> Any advice/solution >> >> >> >> Thanks & Regards >> >> >> >> Qazi M. >> >> >> > >> > >> >> > >
Don't see what you're looking for? Try a search.
|
April 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |