SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Replication (2008)
 Snapshot error in replication
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

csaha
Yak Posting Veteran

52 Posts

Posted - 08/29/2012 :  16:44:18  Show Profile  Reply with Quote
Date 8/29/2012 3:38:06 PM
Log Job History (DEVWINSQL4-AbraHRMS_Live-snapshot_repl_AbraHRMS_Live-3)

Step ID 3
Server DEVWINSQL4
Job Name DEVWINSQL4-AbraHRMS_Live-snapshot_repl_AbraHRMS_Live-3
Step Name Detect nonlogged agent shutdown.
Duration 00:00:00
Sql Severity 16
Sql Message ID 8152
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: NT AUTHORITY\NETWORK SERVICE. String or binary data would be truncated. [SQLSTATE 22001] (Error 8152). The step failed.

tkizer
Almighty SQL Goddess

USA
36907 Posts

Posted - 08/29/2012 :  16:52:54  Show Profile  Visit tkizer's Homepage  Reply with Quote
Your schema is different between the publisher and the subscriber.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

csaha
Yak Posting Veteran

52 Posts

Posted - 08/30/2012 :  10:55:23  Show Profile  Reply with Quote
It was actually the permission issue. Ones that was built we had the the above error message was eliminated.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36907 Posts

Posted - 08/30/2012 :  12:51:24  Show Profile  Visit tkizer's Homepage  Reply with Quote
Cool, glad you got it sorted out. I think that error is very, very odd for a permission issue.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

thebrawn
Starting Member

USA
1 Posts

Posted - 07/23/2013 :  12:18:02  Show Profile  Reply with Quote
I am getting the same error...

Here is the details:
-Snapshot Replication
-Over 10,000 articles
-Source production database replicates to reporting database on different server
-Runs under SQL Server agent account

I have run redgate SQL Compare and it shows 22723 identical objects, therefore both databases have exact same schema, but I am getting string or binary data would be truncated when trying to run the snapshot job and it fails! I would say maybe permissions, but it seems odd to me as well to get that error for a permission issue...And another thing, using same servers, I also have snapshot replication set up on a different database to replicate to the same reporting server under the same permissions and I have had no issues with it whatsoever!

Can someone enlighten me? Should I change the agent security with a different user/password?
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000