Prev: Replication via SMO/RMO - Error "class not registered"
Next: Error 207 - Invlaid Column Name
From: jk on 26 Jan 2010 19:24
Using Transactional Replication. SQL Server 2008 SP1 x64. (Windows 2008 R2)
Replicating permissions for non dbo schemas causes an error when Snapshot
agent runs.

Created a blank database, added a schema, "valuer". Added a sproc to that
schema:
CREATE PROCEDURE valuer.TestProc3
AS
BEGIN
SELECT 3
END

Enabled the server for distribution. Created a publication with that one
article in it. Added a subscriber.
When I run the Snapshot agent I get an error:
-------------------------------------------------------------------------------------
2010-01-26 23:45:13.77 [0%] Generating schema scripts for article
'TestProc3'
2010-01-26 23:45:13.79 [0%] The replication agent had encountered an
exception.
2010-01-26 23:45:13.79 Source: Unknown
2010-01-26 23:45:13.79 Exception Type: System.NullReferenceException
2010-01-26 23:45:13.79 Exception Message: Object reference not set to an
instance of an object.
2010-01-26 23:45:13.79 Message Code: Not Applicable
2010-01-26 23:45:13.79
Version string portion was too short or too long.
--------------------------------------------------------------------------------------

Has anyone encountered this issue ?

Thanks
Jan.


From: Paul Ibison on 27 Jan 2010 14:42
Please can you enable logging : http://support.microsoft.com/?id=312292 and
we'll see if this gives more info.
Thanks,
Paul

 | 
Pages: 1
Prev: Replication via SMO/RMO - Error "class not registered"
Next: Error 207 - Invlaid Column Name