SCCM 2012 R2 Installation Error

Hi All,

I am installing fresh SCCM 2012 R2 environment in windows server 2012 R2, all prerequisites check are passed by SCCM installer. But I got the below error during the step of setting up the SQL server database as attached,

ERROR: Failed to execute SQL Server command; CCISource::InsertObject returned 14

ERROR: Failed to install default configuration items (FinalSqlOperations)

INFO: Creating administrative user and assigning Full Administrator role  $$<Configuration Manager Setup><10-31-2014 10:24:11.373-480><thread=300 (0x12C)>
INFO: Removing byte order marker after reading from file (D:\SOURCE\SCCM\SMSSETUP\BIN\X64\OperatingSystem.xml)  $$<Configuration Manager Setup><10-31-2014 10:24:14.482-480><thread=300 (0x12C)>
INFO: Inserting default ConfigurationItem(GLOBAL/OperatingSystem)  $$<Configuration Manager Setup><10-31-2014 10:24:14.748-480><thread=300 (0x12C)>
error 14: SQL Error Message A .NET Framework error occurred during execution of user-defined routine or aggregate "spSetupLanternDocuments_CLR": ~~System.Data.SqlClient.SqlException: The locale identifier (LCID) 15369 is not supported by SQL Server.~~System.Data.SqlClient.SqlException: ~~   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)~~   at System.Data.SqlClient.SqlDataReaderSmi.InternalNextResult(Boolean ignoreNonFatalMessages)~~   at System.Data.SqlClient.SqlDataReaderSmi.NextResult()~~   at System.Data.SqlClient.SqlCommand.RunExecuteReaderSmi(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)~~   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)~~   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)~~   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)~~   at System.Data.SqlClient.SqlCommand.ExecuteReader()~~   at Microsoft.SystemsManagementServer.SQLCLR.Utilities.IsDesktopConfigurationItem(String ciAuthoringScopeId, String ciLogicalName, Int32 ciVersion)~~   at Microsoft.SystemsManagementServer.SQLCLR.LanternDocumentsGenerator.GenerateLanternDocuments(String digest, Boolean shouldGenerateLanternDocuments)~~   at Microsoft.SystemsManagementServer.SQLCLR.LanternDocumentsGenerator.SetupLanternDocuments(Int32 ciid, Boolean shouldGenerateLanternDocuments)~~.~  $$<Configuration Manager Setup><10-31-2014 10:24:18.966-480><thread=300 (0x12C)>
ERROR: Failed to execute SQL Server command; CCISource::InsertObject returned 14  $$<Configuration Manager Setup><10-31-2014 10:24:18.966-480><thread=300 (0x12C)>
WARNING: retry default ConfigurationItem GLOBAL/OperatingSystem  $$<Configuration Manager Setup><10-31-2014 10:24:19.013-480><thread=300 (0x12C)>
INFO: Inserting default ConfigurationItem(GLOBAL/OperatingSystem)  $$<Configuration Manager Setup><10-31-2014 10:24:19.123-480><thread=300 (0x12C)>
error 14: SQL Error Message A .NET Framework error occurred during execution of user-defined routine or aggregate "spSetupLanternDocuments_CLR": ~~System.Data.SqlClient.SqlException: The locale identifier (LCID) 15369 is not supported by SQL Server.~~System.Data.SqlClient.SqlException: ~~   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)~~   at System.Data.SqlClient.SqlDataReaderSmi.InternalNextResult(Boolean ignoreNonFatalMessages)~~   at System.Data.SqlClient.SqlDataReaderSmi.NextResult()~~   at System.Data.SqlClient.SqlCommand.RunExecuteReaderSmi(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)~~   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)~~   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)~~   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)~~   at System.Data.SqlClient.SqlCommand.ExecuteReader()~~   at Microsoft.SystemsManagementServer.SQLCLR.Utilities.IsDesktopConfigurationItem(String ciAuthoringScopeId, String ciLogicalName, Int32 ciVersion)~~   at Microsoft.SystemsManagementServer.SQLCLR.LanternDocumentsGenerator.GenerateLanternDocuments(String digest, Boolean shouldGenerateLanternDocuments)~~   at Microsoft.SystemsManagementServer.SQLCLR.LanternDocumentsGenerator.SetupLanternDocuments(Int32 ciid, Boolean shouldGenerateLanternDocuments)~~.~  $$<Configuration Manager Setup><10-31-2014 10:24:19.248-480><thread=300 (0x12C)>
ERROR: Failed to execute SQL Server command; CCISource::InsertObject returned 14  $$<Configuration Manager Setup><10-31-2014 10:24:19.248-480><thread=300 (0x12C)>
WARNING: retry default ConfigurationItem GLOBAL/OperatingSystem  $$<Configuration Manager Setup><10-31-2014 10:24:19.248-480><thread=300 (0x12C)>
INFO: Inserting default ConfigurationItem(GLOBAL/OperatingSystem)  $$<Configuration Manager Setup><10-31-2014 10:24:19.248-480><thread=300 (0x12C)>
error 14: SQL Error Message A .NET Framework error occurred during execution of user-defined routine or aggregate "spSetupLanternDocuments_CLR": ~~System.Data.SqlClient.SqlException: The locale identifier (LCID) 15369 is not supported by SQL Server.~~System.Data.SqlClient.SqlException: ~~   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)~~   at System.Data.SqlClient.SqlDataReaderSmi.InternalNextResult(Boolean ignoreNonFatalMessages)~~   at System.Data.SqlClient.SqlDataReaderSmi.NextResult()~~   at System.Data.SqlClient.SqlCommand.RunExecuteReaderSmi(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)~~   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)~~   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)~~   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)~~   at System.Data.SqlClient.SqlCommand.ExecuteReader()~~   at Microsoft.SystemsManagementServer.SQLCLR.Utilities.IsDesktopConfigurationItem(String ciAuthoringScopeId, String ciLogicalName, Int32 ciVersion)~~   at Microsoft.SystemsManagementServer.SQLCLR.LanternDocumentsGenerator.GenerateLanternDocuments(String digest, Boolean shouldGenerateLanternDocuments)~~   at Microsoft.SystemsManagementServer.SQLCLR.LanternDocumentsGenerator.SetupLanternDocuments(Int32 ciid, Boolean shouldGenerateLanternDocuments)~~.~  $$<Configuration Manager Setup><10-31-2014 10:24:19.357-480><thread=300 (0x12C)>
ERROR: Failed to execute SQL Server command; CCISource::InsertObject returned 14  $$<Configuration Manager Setup><10-31-2014 10:24:19.357-480><thread=300 (0x12C)>
WARNING: retry default ConfigurationItem GLOBAL/OperatingSystem  $$<Configuration Manager Setup><10-31-2014 10:24:19.373-480><thread=300 (0x12C)>
INFO: Inserting default ConfigurationItem(GLOBAL/OperatingSystem)  $$<Configuration Manager Setup><10-31-2014 10:24:19.373-480><thread=300 (0x12C)>
error 14: SQL Error Message A .NET Framework error occurred during execution of user-defined routine or aggregate "spSetupLanternDocuments_CLR": ~~System.Data.SqlClient.SqlException: The locale identifier (LCID) 15369 is not supported by SQL Server.~~System.Data.SqlClient.SqlException: ~~   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)~~   at System.Data.SqlClient.SqlDataReaderSmi.InternalNextResult(Boolean ignoreNonFatalMessages)~~   at System.Data.SqlClient.SqlDataReaderSmi.NextResult()~~   at System.Data.SqlClient.SqlCommand.RunExecuteReaderSmi(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)~~   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)~~   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)~~   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)~~   at System.Data.SqlClient.SqlCommand.ExecuteReader()~~   at Microsoft.SystemsManagementServer.SQLCLR.Utilities.IsDesktopConfigurationItem(String ciAuthoringScopeId, String ciLogicalName, Int32 ciVersion)~~   at Microsoft.SystemsManagementServer.SQLCLR.LanternDocumentsGenerator.GenerateLanternDocuments(String digest, Boolean shouldGenerateLanternDocuments)~~   at Microsoft.SystemsManagementServer.SQLCLR.LanternDocumentsGenerator.SetupLanternDocuments(Int32 ciid, Boolean shouldGenerateLanternDocuments)~~.~  $$<Configuration Manager Setup><10-31-2014 10:24:19.482-480><thread=300 (0x12C)>
ERROR: Failed to execute SQL Server command; CCISource::InsertObject returned 14  $$<Configuration Manager Setup><10-31-2014 10:24:19.482-480><thread=300 (0x12C)>
WARNING: retry default ConfigurationItem GLOBAL/OperatingSystem  $$<Configuration Manager Setup><10-31-2014 10:24:19.482-480><thread=300 (0x12C)>
INFO: Inserting default ConfigurationItem(GLOBAL/OperatingSystem)  $$<Configuration Manager Setup><10-31-2014 10:24:19.529-480><thread=300 (0x12C)>
error 14: SQL Error Message A .NET Framework error occurred during execution of user-defined routine or aggregate "spSetupLanternDocuments_CLR": ~~System.Data.SqlClient.SqlException: The locale identifier (LCID) 15369 is not supported by SQL Server.~~System.Data.SqlClient.SqlException: ~~   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)~~   at System.Data.SqlClient.SqlDataReaderSmi.InternalNextResult(Boolean ignoreNonFatalMessages)~~   at System.Data.SqlClient.SqlDataReaderSmi.NextResult()~~   at System.Data.SqlClient.SqlCommand.RunExecuteReaderSmi(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)~~   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)~~   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)~~   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)~~   at System.Data.SqlClient.SqlCommand.ExecuteReader()~~   at Microsoft.SystemsManagementServer.SQLCLR.Utilities.IsDesktopConfigurationItem(String ciAuthoringScopeId, String ciLogicalName, Int32 ciVersion)~~   at Microsoft.SystemsManagementServer.SQLCLR.LanternDocumentsGenerator.GenerateLanternDocuments(String digest, Boolean shouldGenerateLanternDocuments)~~   at Microsoft.SystemsManagementServer.SQLCLR.LanternDocumentsGenerator.SetupLanternDocuments(Int32 ciid, Boolean shouldGenerateLanternDocuments)~~.~  $$<Configuration Manager Setup><10-31-2014 10:24:19.638-480><thread=300 (0x12C)>
ERROR: Failed to execute SQL Server command; CCISource::InsertObject returned 14  $$<Configuration Manager Setup><10-31-2014 10:24:19.638-480><thread=300 (0x12C)>
WARNING: retry default ConfigurationItem GLOBAL/OperatingSystem  $$<Configuration Manager Setup><10-31-2014 10:24:19.638-480><thread=300 (0x12C)>
INFO: Inserting default ConfigurationItem(GLOBAL/OperatingSystem)  $$<Configuration Manager Setup><10-31-2014 10:24:19.685-480><thread=300 (0x12C)>
error 14: SQL Error Message A .NET Framework error occurred during execution of user-defined routine or aggregate "spSetupLanternDocuments_CLR": ~~System.Data.SqlClient.SqlException: The locale identifier (LCID) 15369 is not supported by SQL Server.~~System.Data.SqlClient.SqlException: ~~   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)~~   at System.Data.SqlClient.SqlDataReaderSmi.InternalNextResult(Boolean ignoreNonFatalMessages)~~   at System.Data.SqlClient.SqlDataReaderSmi.NextResult()~~   at System.Data.SqlClient.SqlCommand.RunExecuteReaderSmi(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)~~   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)~~   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)~~   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)~~   at System.Data.SqlClient.SqlCommand.ExecuteReader()~~   at Microsoft.SystemsManagementServer.SQLCLR.Utilities.IsDesktopConfigurationItem(String ciAuthoringScopeId, String ciLogicalName, Int32 ciVersion)~~   at Microsoft.SystemsManagementServer.SQLCLR.LanternDocumentsGenerator.GenerateLanternDocuments(String digest, Boolean shouldGenerateLanternDocuments)~~   at Microsoft.SystemsManagementServer.SQLCLR.LanternDocumentsGenerator.SetupLanternDocuments(Int32 ciid, Boolean shouldGenerateLanternDocuments)~~.~  $$<Configuration Manager Setup><10-31-2014 10:24:19.795-480><thread=300 (0x12C)>
ERROR: Failed to execute SQL Server command; CCISource::InsertObject returned 14  $$<Configuration Manager Setup><10-31-2014 10:24:19.795-480><thread=300 (0x12C)>
ERROR: Failed to install default configuration items (FinalSqlOperations).  $$<Configuration Manager Setup><10-31-2014 10:24:19.795-480><thread=300 (0x12C)>
~~===================== Completed Configuration Manager 2012 Server Setup =====================  $$<Configuration Manager Setup><10-31-2014 10:24:19.810-480><thread=300 (0x12C)>

The SQL server is a dedicated remote server, version is CU2 for SQL SERVER 2012 SP2(11.0.5548), the OS is windows server 2012 R2.

Anybody can help me on this? T

October 31st, 2014 4:20am

Hi All,

The problem was caused by the default locale settings of the OS is incompatible with the version of the SQL Server settings

Go to Regional and Language Options and set everything is US-English then it works like a charm.

Thanks.

Free Windows Admin Tool Kit Click here and download it now
October 31st, 2014 6:53am

That's what the logfile also said: "The locale identifier (LCID) 15369 is not supported by SQL Server"
October 31st, 2014 7:12am

Thanks for your reply.
Free Windows Admin Tool Kit Click here and download it now
October 31st, 2014 7:14am

Hi All,

I used this method "Regional and Language Options and set everything is US-English " in my testing environment and this issue was resolved. But when I am deploying SCCM in my production environment, I got the same issue again even if I set everything to US-English in "Regional and Language Options". 

SQL Error Message A .NET Framework error occurred during execution of user-defined routine or aggregate "spSetupLanternDocuments_CLR": ~~System.Data.SqlClient.SqlException: The locale identifier (LCID) 15369 is not supported by SQL Server.~~System.Data.SqlClient.SqlException

It's very weird. Can anybody help me on this?

Many thanks.

November 17th, 2014 9:13am

Sounds like too much messing to me. ConfigMgr can be a complicated product. You have to get it right in the beginning. Re-install SQL.
Free Windows Admin Tool Kit Click here and download it now
November 17th, 2014 10:32am

@Btlcxh - I had faced a similar issue in my lab setup when I tried deploying SCCM 2012 R2 on Windows Server 2012 R2 + SQL 2012 SP2.

Can you uninstall the SQL 2012 with SP2 and Install SQL Server 2012 with Service Pack 1 ?. No need to deploy any cumulative update initially.

http://prajwaldesai.com/installing-sql-server-2012-for-configuration-manager-20

November 17th, 2014 12:04pm

Hi,

I just re installed the SQL server with SP2 and CU2, SCCM installation works. After that, I got the replication error between CAS server and Primary server, the error code is same as the SCCM installation Process.

In statesys.log, it said,

SQL MESSAGE: spProcessStateReport - Error: Message processing encountered a SQL error 9802 at record 1 for TopicType 701: "The locale identifier (LCID) 15369 is not supported by SQL Server.", Line 0 in procedure ""

In rcmctrl.log, it said

The asynchronous command finished with return message: [A .NET Framework error occurred during execution of user-defined routine or aggregate "spDRSActivation": ~~Microsoft.ConfigurationManager.DataReplicationService.ServiceException: Exception has been thrown by the target of an invocation. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.SqlClient.SqlException: The locale identifier (LCID) 15369 is not supported by SQL Server.~

I highly doubted it is related with the service pack. But actually it works in my testing lab. Anyway. I am going to re-install it with SQL server SP1 as suggested by Prajwal in my production environment.

Will let you know the result once it is finish. Thanks for your support.

Free Windows Admin Tool Kit Click here and download it now
November 18th, 2014 6:02am

Hi All,

Just reinstalled SQL with SP1, and still get the error during SCCM installation,

INFO: Inserting default ConfigurationItem(GLOBAL/OperatingSystem)

error 14: SQL Error Message A .NET Framework error occurred during execution of user-defined routine or aggregate "spSetupLanternDocuments_CLR": ~~System.Data.SqlClient.SqlException: The locale identifier (LCID) 15369 is not supported by SQL Server.~~System.Data.SqlClient.SqlException: ~~   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

ERROR: Failed to execute SQL Server command; CCISource::InsertObject returned 14

WARNING: retry default ConfigurationItem GLOBAL/OperatingSystem

ERROR: Failed to install default configuration items (FinalSqlOperations).

And Regional and Language Options and set everything is English(United Stated). SQL Instance language is English(United Stated). I have no idea about this.

Thanks.

November 19th, 2014 6:39am

Yes, I know this is an old post, but Im trying to clean them up. Did you solve this problem, if so what was the solution?

Since no one has answer this post, I recommend opening  a support case with Microsoft Customer Support Services (CSS) as they can work with you to solve this problem.

Free Windows Admin Tool Kit Click here and download it now
July 4th, 2015 12:21pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics