'INITCOLVS' is not a recognized built-in function name
in [Replication]
|
Prev: Performance for Transactional replication for indexed view
Next: ReIndexing while using replication Important
From: Warren J. Hairston on 22 Sep 2006 21:09 I'm using a replicated SQL Server 2005 database on my server and a SQL Server Everywhere CTP (v3.1) database as my client app. Everything works fine (including sync) until I add a row to a table on the subscriber (client). Upon the next synchronization I get the following error: 'INITCOLVS' is not a recognized built-in function name. This error also tells me that the problem occurred while applying the new row to the publisher, not the subscriber. Any ideas??? Thanks in advance!
From: Hilary Cotter on 22 Sep 2006 21:28 -- Hilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com "Warren J. Hairston" <whairston(a)logicaloperators.com> wrote in message news:uB8y2zq3GHA.3508(a)TK2MSFTNGP03.phx.gbl... > I'm using a replicated SQL Server 2005 database on my server and a SQL > Server Everywhere CTP (v3.1) database as my client app. Everything works > fine (including sync) until I add a row to a table on the subscriber > (client). Upon the next synchronization I get the following error: > > 'INITCOLVS' is not a recognized built-in function name. > > This error also tells me that the problem occurred while applying the new > row to the publisher, not the subscriber. > > Any ideas??? > > Thanks in advance! >
From: Hilary Cotter on 22 Sep 2006 21:29 What is the compatibility mode on the subscriber? It should be 80 or above. -- Hilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com "Warren J. Hairston" <whairston(a)logicaloperators.com> wrote in message news:uB8y2zq3GHA.3508(a)TK2MSFTNGP03.phx.gbl... > I'm using a replicated SQL Server 2005 database on my server and a SQL > Server Everywhere CTP (v3.1) database as my client app. Everything works > fine (including sync) until I add a row to a table on the subscriber > (client). Upon the next synchronization I get the following error: > > 'INITCOLVS' is not a recognized built-in function name. > > This error also tells me that the problem occurred while applying the new > row to the publisher, not the subscriber. > > Any ideas??? > > Thanks in advance! >
From: Warren J. Hairston on 23 Sep 2006 11:02 Hilary, thanks for your reply. It WAS set to 80, but changing it to 90 seems to have no effect - subsequent sync operations result in the same error. My understanding is that this database was previously hosted by SQL Server 2000 and had only recently been moved to a SQL Server 2005 box. Any other ideas? "Hilary Cotter" <hilary.cotter(a)gmail.com> wrote in message news:%23Sm$A1x3GHA.1252(a)TK2MSFTNGP04.phx.gbl... > What is the compatibility mode on the subscriber? It should be 80 or > above. > > -- > Hilary Cotter > Director of Text Mining and Database Strategy > RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. > > This posting is my own and doesn't necessarily represent RelevantNoise's > positions, strategies or opinions. > > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > > > > "Warren J. Hairston" <whairston(a)logicaloperators.com> wrote in message > news:uB8y2zq3GHA.3508(a)TK2MSFTNGP03.phx.gbl... >> I'm using a replicated SQL Server 2005 database on my server and a SQL >> Server Everywhere CTP (v3.1) database as my client app. Everything works >> fine (including sync) until I add a row to a table on the subscriber >> (client). Upon the next synchronization I get the following error: >> >> 'INITCOLVS' is not a recognized built-in function name. >> >> This error also tells me that the problem occurred while applying the new >> row to the publisher, not the subscriber. >> >> Any ideas??? >> >> Thanks in advance! >> > >
From: Warren J. Hairston on 28 Sep 2006 00:09
We eventually figured this out (I think). The original SQL Server 2000 database had been copied to the SQL Server 2005 computer, then attached. We used the Copy Database Wizard to create a new copy of the database, which must have "converted" it to a SQL Server 2005 DB. We then published the new database and all of our problems disappeared. Hope this helps someone in the future. |