December 18, 2014 at 10:42 am
Hi guys, has anyone seen this before? Doing my head in!
Replication initialised & snapshot files generated.
Copied via ftp over the internet (uncompressed due to size)
When applying the snapshot files at the subscriber this error occurs:
2014-12-18 17:16:05.955 Applied script 'tab1.pre'
2014-12-18 17:16:06.214 Applied script 'tab2.pre'
2014-12-18 17:16:06.472 Applied script 'tab3.pre'
2014-12-18 17:16:06.732 Applied script 'tab4.pre'
2014-12-18 17:16:07.501 Applied script 'tab1_10.sch'
2014-12-18 17:16:07.783 Applied script 'tab1_11.sch'
2014-12-18 17:16:09.182 Applied script 'tab1_18.sch'
2014-12-18 17:16:28.193 Agent message code 105. Unclosed quotation mark after the character string 'insert dbo.MSrep
'.
2014-12-18 17:16:28.269 Category:COMMAND
Source: Failed Command
Number:
Message: if columnproperty(object_id(N'dbo.MSreplication_objects'), N'article', 'AllowsNull') is not null
exec sp_executesql
@statement =
N'insert dbo.MSrep
2014-12-18 17:16:28.284 Category:NULL
Source: Microsoft SQL Server Native Client 10.0
Number: 105
Message: Unclosed quotation mark after the character string 'insert dbo.MSrep
'.
2014-12-18 17:16:28.297 Category:NULL
Source: Microsoft SQL Server Native Client 10.0
Number: 102
Message: Incorrect syntax near 'insert dbo.MSrep
Cheers
December 22, 2014 at 2:50 am
So, after further investigation, looks like the distribution agent at the subscriber is trying to read data out of the snapshot files before they've finished copying!
December 22, 2014 at 3:21 am
How did you resolve it?
Regards,
Shafat Husain
🙂
And Your Lord Never Forgets...!! (64:19 -- Quran)
December 22, 2014 at 4:37 am
I waited!
After a while the errors resolved and I could see all the data in the target database. Very odd.
December 22, 2014 at 4:41 am
Apparently... "Good things come to those who WAIT" 😀
Regards,
Shafat Husain
🙂
And Your Lord Never Forgets...!! (64:19 -- Quran)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply