Snapshot replication gives "Invalid Descriptor Error"

Snapshot replication gives "Invalid Descriptor Error"

Post by Guy Colsou » Sat, 18 Jan 2003 02:31:39



I try the following :

1) MSDE 2000 sp2 configured as a publisher. It contains a database that has
been prepared for a snapshot publication (of only 2 of its tables)

2) On the other side, a SQL Standard Edition Server 2000 sp2.

The subscription created on 1) is pushed to 2)

I get the following error on the agent :

Invalid Descriptor Index
(Source: ODBC SQL Server Driver (ODBC); Error number: S1002)

Does somebody have an idea to solve this problem.

Guy

NB Merge publication configured between the same servers works perfectly.

 
 
 

Snapshot replication gives "Invalid Descriptor Error"

Post by Eric Yang [M » Tue, 21 Jan 2003 15:45:37


Hello,

Please run sp_helpsort on both publisher and subscriber servers and see if
they had the same collation.

In addition, is there any TEXT or other BLOB data type fields in the
replication table? Could you setup a snapshot replication between the
servers using another table? Was the service pack 2 applied on the SQL
Server or MSDE successfully?  
We may need to use the profile to trace the whole replication process in
order to troubleshoot this issue.

Sincerely,

Eric Yang [MS]
Microsoft Support

Please do not send email directly to this alias.  This is our online
account name for newsgroup participation only.
This posting is provided 'AS IS' with no warranties, and confers no rights.
Get Secure! - www.microsoft.com/security

 
 
 

Snapshot replication gives "Invalid Descriptor Error"

Post by Guy Colsou » Tue, 21 Jan 2003 18:57:55


1) collation : the collation was different on both server. I've fixed it by
alter database PW001A06 collate french_CI_AS

2) No TEXT or BLOB  fields in the replication process.

3) Snapshot relication between these 2 server has never worked (already
tried with other DB)
Merge replication works fine.

4) The SP2 has been sucessfully applied on both server

5) Here is the profile trace :

Microsoft SQL Server Distribution Agent 8.00.534
Copyright (c) 2000 Microsoft Corporation
Microsoft SQL Server Replication Agent: P266-PW001A06-INTRANET-2

Startup Delay: 3366 (msecs)
Connecting to Distributor 'P266'
Connecting to Distributor 'P266.'
[20/01/2003 10:46:52]P266.: exec sp_helpdistpublisher N'P266'

Server: P266
DBMS: Microsoft SQL Server
Version: 08.00.0534
user name: dbo
API conformance: 2
SQL conformance: 1
transaction capable: 2
read only: N
identifier quote char: "
non_nullable_columns: 1
owner usage: 31
max table name len: 128
max column name len: 128
need long data len: Y
max columns in table: 1024
max columns in index: 16
max char literal len: 524288
max statement len: 524288
max row size: 524288

[20/01/2003 10:46:52]P266.distribution: execute sp_server_info 18

ANSI codepage: 1
[20/01/2003 10:46:52]P266.distribution: select datasource, srvid from
master..sysservers where upper(srvname) = upper(N'INTRANET')
[20/01/2003 10:46:52]P266.distribution: {?=call sp_MShelp_subscriber_info
(N'P266', N'INTRANET')}
Subscriber security mode: 1, login name: sa.
[20/01/2003 10:46:52]P266.distribution: select datasource, srvid from
master..sysservers where upper(srvname) = upper(N'P266')
[20/01/2003 10:46:52]P266.distribution: {call
sp_MShelp_distribution_agentid(0, N'PW001A06', NULL, 5, N'PW001A06', 0)}
Agent message code 20046. Invalid Descriptor Index
[20/01/2003 10:46:52]P266.distribution: {call
sp_MSadd_distribution_history(2, 6,  ?, ?, 0, 0, 0.00, 0x01, 1, ?, -1, 0x01,
0x01)}
Adding alert to msdb..sysreplicationalerts: ErrorId = 10,
Transaction Seqno = 0000000000000000000000000000, Command ID = -1
Message: Replication-Replication Distribution Subsystem: agent
P266-PW001A06-INTRANET-2 failed. Invalid Descriptor Index[20/01/2003
10:46:52]P266.distribution: {call sp_MSadd_repl_alert(3, 2,  10, 14151,
?, -1, N'P266', N'PW001A06', N'INTRANET', N'PW001A06', ?)}
ErrorId = 10, SourceTypeId = 4
ErrorCode = 'S1002'
ErrorText = 'Invalid Descriptor Index'
[20/01/2003 10:46:52]P266.distribution: {call sp_MSadd_repl_error(10, 0,  4,
?, N'S1002', ?)}

Category:ODBC
Source:  ODBC SQL Server Driver
Number:  S1002
Message: Invalid Descriptor Index
Disconnecting from Distributor History 'P266'



Quote:

> Hello,

> Please run sp_helpsort on both publisher and subscriber servers and see if
> they had the same collation.

> In addition, is there any TEXT or other BLOB data type fields in the
> replication table? Could you setup a snapshot replication between the
> servers using another table? Was the service pack 2 applied on the SQL
> Server or MSDE successfully?
> We may need to use the profile to trace the whole replication process in
> order to troubleshoot this issue.

> Sincerely,

> Eric Yang [MS]
> Microsoft Support

> Please do not send email directly to this alias.  This is our online
> account name for newsgroup participation only.
> This posting is provided 'AS IS' with no warranties, and confers no
rights.
> Get Secure! - www.microsoft.com/security

 
 
 

Snapshot replication gives "Invalid Descriptor Error"

Post by Guy Colsou » Tue, 21 Jan 2003 22:38:22


Don't search anymore.

4) was the real issue.

The INSTALL dir of the MSDE server was not SP2.

After a full reinstall -> everything OK.

Thanks a lot for help.

Guy



> 1) collation : the collation was different on both server. I've fixed it
by
> alter database PW001A06 collate french_CI_AS

> 2) No TEXT or BLOB  fields in the replication process.

> 3) Snapshot relication between these 2 server has never worked (already
> tried with other DB)
> Merge replication works fine.

> 4) The SP2 has been sucessfully applied on both server

> 5) Here is the profile trace :

> Microsoft SQL Server Distribution Agent 8.00.534
> Copyright (c) 2000 Microsoft Corporation
> Microsoft SQL Server Replication Agent: P266-PW001A06-INTRANET-2

> Startup Delay: 3366 (msecs)
> Connecting to Distributor 'P266'
> Connecting to Distributor 'P266.'
> [20/01/2003 10:46:52]P266.: exec sp_helpdistpublisher N'P266'

> Server: P266
> DBMS: Microsoft SQL Server
> Version: 08.00.0534
> user name: dbo
> API conformance: 2
> SQL conformance: 1
> transaction capable: 2
> read only: N
> identifier quote char: "
> non_nullable_columns: 1
> owner usage: 31
> max table name len: 128
> max column name len: 128
> need long data len: Y
> max columns in table: 1024
> max columns in index: 16
> max char literal len: 524288
> max statement len: 524288
> max row size: 524288

> [20/01/2003 10:46:52]P266.distribution: execute sp_server_info 18

> ANSI codepage: 1
> [20/01/2003 10:46:52]P266.distribution: select datasource, srvid from
> master..sysservers where upper(srvname) = upper(N'INTRANET')
> [20/01/2003 10:46:52]P266.distribution: {?=call sp_MShelp_subscriber_info
> (N'P266', N'INTRANET')}
> Subscriber security mode: 1, login name: sa.
> [20/01/2003 10:46:52]P266.distribution: select datasource, srvid from
> master..sysservers where upper(srvname) = upper(N'P266')
> [20/01/2003 10:46:52]P266.distribution: {call
> sp_MShelp_distribution_agentid(0, N'PW001A06', NULL, 5, N'PW001A06', 0)}
> Agent message code 20046. Invalid Descriptor Index
> [20/01/2003 10:46:52]P266.distribution: {call
> sp_MSadd_distribution_history(2, 6,  ?, ?, 0, 0, 0.00, 0x01, 1, ?, -1,
0x01,
> 0x01)}
> Adding alert to msdb..sysreplicationalerts: ErrorId = 10,
> Transaction Seqno = 0000000000000000000000000000, Command ID = -1
> Message: Replication-Replication Distribution Subsystem: agent
> P266-PW001A06-INTRANET-2 failed. Invalid Descriptor Index[20/01/2003
> 10:46:52]P266.distribution: {call sp_MSadd_repl_alert(3, 2,  10, 14151,
> ?, -1, N'P266', N'PW001A06', N'INTRANET', N'PW001A06', ?)}
> ErrorId = 10, SourceTypeId = 4
> ErrorCode = 'S1002'
> ErrorText = 'Invalid Descriptor Index'
> [20/01/2003 10:46:52]P266.distribution: {call sp_MSadd_repl_error(10, 0,
4,
> ?, N'S1002', ?)}

> Category:ODBC
> Source:  ODBC SQL Server Driver
> Number:  S1002
> Message: Invalid Descriptor Index
> Disconnecting from Distributor History 'P266'



> > Hello,

> > Please run sp_helpsort on both publisher and subscriber servers and see
if
> > they had the same collation.

> > In addition, is there any TEXT or other BLOB data type fields in the
> > replication table? Could you setup a snapshot replication between the
> > servers using another table? Was the service pack 2 applied on the SQL
> > Server or MSDE successfully?
> > We may need to use the profile to trace the whole replication process in
> > order to troubleshoot this issue.

> > Sincerely,

> > Eric Yang [MS]
> > Microsoft Support

> > Please do not send email directly to this alias.  This is our online
> > account name for newsgroup participation only.
> > This posting is provided 'AS IS' with no warranties, and confers no
> rights.
> > Get Secure! - www.microsoft.com/security

 
 
 

Snapshot replication gives "Invalid Descriptor Error"

Post by Eric Yang [M » Fri, 24 Jan 2003 22:27:23


Hello,

Thank you for your feed back.

Sincerely,

Eric Yang [MS]
Microsoft Support

Please do not send email directly to this alias.  This is our online
account name for newsgroup participation only.
This posting is provided 'AS IS' with no warranties, and confers no rights.
Get Secure! - www.microsoft.com/security