Re: Distribution Agent fails with error: Line 1: Incorrect syntax near ',null,'

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Hilary Cotter (hilary.cotter_at_gmail.com)
Date: 10/06/04 

Date: Tue, 5 Oct 2004 22:00:00 -0400

It looks like a bug here. Could you post the schema of the problem table
here?

To get around this you should open a support incident with Microsoft.

It is possible to manipulate this command in the msrepl_commands table to
fix it. 

-- 
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Steve Klein" <sklein@singular.com> wrote in message
news:10m6abdovj1e519@corp.supernews.com...
> Greetings--
>
> We are running queued updatable transactional replication between one SQL
> Server 2000 and one MSDE instance (SP3 on both). Replication died last
night
> with the following error --
>
> Distribution Agent   Line 1: Incorrect syntax near ',null,'
>
> Last command:
>
> EXEC  sp_MSins_<tablename> 4,19533,null,'2004-10-03
> 22:04:29.417',1,null,null,0,'Notice Wells Fargo update','"Wells Fargo"
>
<atmservice@wellsfargo.com>',3722469734,'PG4-20041003-19533',null',null,'200
> 4-10-03 22:04:29.417','2004-10-03 22:04:29.417',null,'2004-10-03
> 22:00:39.240',null,'4541D8DA-CB2A-4AE1-B074-012B7839D6D1'
> Transaction sequence number and command ID of last execution batch are
> 0x00000481000006E7000100000000 and 6.
>
>
>
> You'll notice that the SQL is malformed at the 13th parameter:
> ...,null',...
>
> We are trying to figure out the following:
>
> 1. How to re-establish replication
> 2. How this happened
> 3. How to keep it from happening again!
>
> Any and all help appreciated!
>
> --Steve Klein
>
>
>
>

Relevant Pages

  • Re: Cannot use a CONTAINS or FREETEXT predicate on table...
    ... command from the context of the database I wish to publish. ... This database is not enabled for publication. ... The replication agent has been successfully started. ... Source: Microsoft SQL Native Client ...
    (microsoft.public.sqlserver.replication)
  • Re: starting merge agent - any logging available
    ... I'm not exactly sure which version you are running, so for SQL 2000 let's ... In em, drill down on your merge agent folder, locate your problem merge ... command box, copy out the statement you see there. ... In SQL 2005, right click on your replication folder, select launch ...
    (microsoft.public.sqlserver.replication)
  • Re: sp_addscriptexec / ftp
    ... > Program Manager SQL Replication ... >> all subscribers. ... >> run the command. ...
    (microsoft.public.sqlserver.replication)
  • Distribution Agent fails with error: Line 1: Incorrect syntax near ,null,
    ... We are running queued updatable transactional replication between one SQL ... Server 2000 and one MSDE instance (SP3 on both). ... 22:04:29.417',1,null,null,0,'Notice Wells Fargo update','"Wells Fargo" ... Transaction sequence number and command ID of last execution batch are ...
    (microsoft.public.sqlserver.replication)
  • Re: COBOL stored procedure for DB2
    ... Regarding how you precompile the app, you must specify target mfcob to db2 prep, rather than target ibmcob. ... Have you also confirmed that, prior to executing the CALL statement, the host variables specified within the client app have the appropriate values? ... MODIFIES SQL DATA ... confirm the cob command used for creating the SP module. ...
    (comp.lang.cobol)