March 17, 2023 at 6:17 am
Hi,
Below error occurring while running the snapshot agent in transactional replication. Please help me to resolve this error.
Message
2023-03-17 05:20:35.44 [11%] Pre-loading meta-data of all tables in the publisher database for scripting
2023-03-17 05:20:37.10 [11%] Sorting article objects in the proper creation order
2023-03-17 05:20:37.12 [11%] Customizing object for scripting based on article 'test'
2023-03-17 05:20:37.18 [11%] Resolving duplicate object names among replicated objects
2023-03-17 05:20:37.20 [11%] Analyzing foreign key references among article objects in the publication
2023-03-17 05:20:37.20 [11%] Analyzing external references of all replicated check and default constraints
2023-03-17 05:20:37.20 [11%] Analyzing dependencies on non-article objects
2023-03-17 05:20:37.21 [11%] Generating schema scripts for article 'test'
2023-03-17 05:20:37.69 [62%] Processing system pre-snapshot script
2023-03-17 05:20:37.70 [62%] Posting snapshot commands into the distribution database
2023-03-17 05:20:37.71 [62%] Inserted schema command for article 'test' into the distribution database
2023-03-17 05:20:37.72 [62%] Inserted index creation command for article 'test' into the distribution database.
2023-03-17 05:20:37.72 [62%] Inserted bcp command for article 'test' into the distribution database.
2023-03-17 05:20:37.72 [62%] Inserted stored proc to disable constraint/triggers article 'test' during concurrent snapshot into the distribution database.
2023-03-17 05:20:37.74 [62%] Locking published tables while generating the snapshot
2023-03-17 05:20:38.13 [62%] The replication agent had encountered an exception.
2023-03-17 05:20:38.13 Source: Replication
2023-03-17 05:20:38.13 Exception Type: Microsoft.SqlServer.Replication.ReplicationAgentSqlException
2023-03-17 05:20:38.13 Exception Message: A .NET Framework error occurred during execution of user-defined routine or aggregate "sp_scriptdropinsreconciliationproc_sqlclr":
2023-03-17 05:20:38.13 System.Data.SqlClient.SqlException: The locale identifier (LCID) 19465 is not supported by SQL Server.
2023-03-17 05:20:38.13 System.Data.SqlClient.SqlException:
2023-03-17 05:20:38.13 at Microsoft.SqlServer.Server.SmiEventSink_Default.DispatchMessages(Boolean ignoreNonFatalMessages)
2023-03-17 05:20:38.13 at Microsoft.SqlServer.Server.SqlDataRecord..ctor(SqlMetaData[] metaData)
2023-03-17 05:20:38.13 at Microsoft.SqlServer.Replication.SqlPipeTextWriter..ctor()
2023-03-17 05:20:38.13 at Microsoft.SqlServer.Replication.TransSqlClrCodeGenerators.ScriptDropReconciliationProcedure(SqlInt32 articleId, CustomStoredProcedureType customProcedureType)
2023-03-17 05:20:38.13 at Microsoft.SqlServer.Replication.TransSqlClrCodeGenerators.sp_scriptdropinsreconciliationproc_sqlclr(SqlInt32 articleId, SqlInt32 mode, SqlByte publisherType, SqlInt32 format)
2023-03-17 05:20:38.13 .
2023-03-17 05:20:38.13 A .NET Framework error occurred during execution of user-defined routine or aggregate "sp_scriptdropdelreconciliationproc_sqlclr":
2023-03-17 05:20:38.13 System.Data.SqlClient.SqlException: The locale identifier (LCID) 19465 is not supported by SQL Server.
2023-03-17 05:20:38.13 System.Data.SqlClient.SqlException:
2023-03-17 05:20:38.13 at Microsoft.SqlServer.Server.SmiEventSink_Default.DispatchMessages(Boolean ignoreNonFatalMessages)
2023-03-17 05:20:38.13 at Microsoft.SqlServer.Server.SqlDataRecord..ctor(SqlMetaData[] metaData)
2023-03-17 05:20:38.13 at Microsoft.SqlServer.Replication.SqlPipeTextWriter..ctor()
2023-03-17 05:20:38.13 at Microsoft.SqlServer.Replication.TransSqlClrCodeGenerators.ScriptDropReconciliationProcedure(SqlInt32 articleId, CustomStoredProcedureType customProcedureType)
2023-03-17 05:20:38.13 at Microsoft.SqlServer.Replication.TransSqlClrCodeGenerators.sp_scriptdropdelreconciliationproc_sqlclr(SqlInt32 articleId, SqlInt32 mode, SqlByte publisherType, SqlInt32 format)
2023-03-17 05:20:38.13 .
2023-03-17 05:20:38.13 Message Code: 6522
2023-03-17 05:20:38.13
Thanks
March 18, 2023 at 7:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy