Wednesday, March 28, 2012

Replication Error - SharePoint 2007 DB

I have several SharePoint 2007 SQL 2005 databases that are replicating fine.

However, I have the WSS_Content _db that errors every time as shown below.

This only happens on the table shown, not on any of the other tables.

I am looking for confimation that this is a glitch withing SQL 2005 and there is nothing I can do about it pending a service release.

Anyone else run into this?


Error messages:

Source: Microsoft.SqlServer.Smo
Target Site: System.Collections.Specialized.StringCollection ScriptWithList(Microsoft.SqlServer.Management.Smo.DependencyCollection, Microsoft.SqlServer.Management.Smo.SqlSmoObject[])
Message: Script failed for Table 'dbo.NameValuePair_Hindi_CI_AS'.
Stack: at Microsoft.SqlServer.Management.Smo.Scripter.ScriptWithList(DependencyCollection depList, SqlSmoObject[] objects)
at Microsoft.SqlServer.Management.Smo.Scripter.ScriptWithList(SqlSmoObject[] objects)
at Microsoft.SqlServer.Replication.Snapshot.TransSmoScriptingManager.GenerateLogBasedArticleSchScript(Scripter scripter, BaseArticleWrapper articleWrapper, Table smoTable)
at Microsoft.SqlServer.Replication.Snapshot.TransSmoScriptingManager.GenerateLogBasedArticleScripts(ArticleScriptingBundle articleScriptingBundle)
at Microsoft.SqlServer.Replication.Snapshot.TransSmoScriptingManager.GenerateArticleScripts(ArticleScriptingBundle articleScriptingBundle)
at Microsoft.SqlServer.Replication.Snapshot.SmoScriptingManager.GenerateObjectScripts(ArticleScriptingBundle articleScriptingBundle)
at Microsoft.SqlServer.Replication.Snapshot.SmoScriptingManager.DoScripting()
at Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.DoScripting()
at Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.GenerateSnapshot()
at Microsoft.SqlServer.Replication.SnapshotGenerationAgent.InternalRun()
at Microsoft.SqlServer.Replication.AgentCore.Run() (Source: Microsoft.SqlServer.Smo, Error number: 0)

Can you exlain your scenario in more detail? Are you using transactional replication? Also, are you using Hindi as table name? What collation are you using?


Gary

|||

The 'Hindi' table is part of the database that was automatically installed by SharePoint, along with numerous others.

Wish I could include a photo.

Some of the other tables are Greek, Hebrew, Hindi, Hungarian, Japanese....etc

They start with Albanian and end with Vietnamese.

The backup works great until it hits the 'Hindi' table and then crashes.

If this wasn't a production environment I would delete the table and see what happened.

Thanks.

No comments:

Post a Comment