Invalid Cursor State -- sql server replication

Santiago Titon
10/17/2007 2:59:40 PM

Hello

Sorry i don=B4t know english very well.

I work with:

Windows 2000 Server
SQL Server 2000 SP4
Replication Transactional with queue update

Queue Reader error:

DISTRIBUIDOR.Comercial: {? =3D call dbo.sp_getqueuedarticlesynctraninfo
(N'COMPLETA', 120)}
Servidor: DISTRIBUIDOR, Base de datos Comercial : Error ODBC: Estado
del cursor no v=E1lido
Error al aplicar el mensaje en cola al publicador
Servidor: DISTRIBUIDOR, Base de datos Comercial : Error ODBC: Estado
del cursor no v=E1lido
Disconnecting from DISTRIBUIDOR 'DISTRIBUIDOR'
Subproceso de trabajo 656 : error en la tarea
Disconnecting from DISTRIBUIDOR 'DISTRIBUIDOR'
Anulando lector de colas

In english

DISTRIBUIDOR.Comercial: {? =3D call dbo.sp_getqueuedarticlesynctraninfo
(N'COMPLETA', 120)}
Server: DISTRIBUIDOR, Database Comercial : ODBC Error: Invalid Cursor
State

I was searching in all the groups and MSDN.

Only found Article ID : 308733, but don't resolve it.

Anybody know what to do ?

Thanks !

Santiago Titon

Hilary Cotter
10/19/2007 8:05:08 AM

IIRC this is a transitory error. It should pass the next time you run the
queue reader agent.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

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
[quoted text, click to view]
Hello

Sorry i don´t know english very well.

I work with:

Windows 2000 Server
SQL Server 2000 SP4
Replication Transactional with queue update

Queue Reader error:

DISTRIBUIDOR.Comercial: {? = call dbo.sp_getqueuedarticlesynctraninfo
(N'COMPLETA', 120)}
Servidor: DISTRIBUIDOR, Base de datos Comercial : Error ODBC: Estado
del cursor no válido
Error al aplicar el mensaje en cola al publicador
Servidor: DISTRIBUIDOR, Base de datos Comercial : Error ODBC: Estado
del cursor no válido
Disconnecting from DISTRIBUIDOR 'DISTRIBUIDOR'
Subproceso de trabajo 656 : error en la tarea
Disconnecting from DISTRIBUIDOR 'DISTRIBUIDOR'
Anulando lector de colas

In english

DISTRIBUIDOR.Comercial: {? = call dbo.sp_getqueuedarticlesynctraninfo
(N'COMPLETA', 120)}
Server: DISTRIBUIDOR, Database Comercial : ODBC Error: Invalid Cursor
State

I was searching in all the groups and MSDN.

Only found Article ID : 308733, but don't resolve it.

Anybody know what to do ?

Thanks !

Santiago Titon

sql server replication : Invalid Cursor State