question

ikramelmbarki-0704 avatar image
0 Votes"
ikramelmbarki-0704 asked ZoeHui-MSFT edited

SSIS Error when deploying package , The Local identifier 14348 is not supported by SQL Server

I am unable to deploy my project from Visual Studio to SSISDB. I have tried to change my localename and locale as well as my region. I have also made MYSQL Server login local but the below error still persists. Can anyone provide guidance
<WizardReport xmlns="http://schemas.datacontract.org/2004/07/Microsoft.SqlServer.IntegrationServices.Wizard.Common.Model" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><Results><Children/><Header>Results</Header><ReportItems><SummaryReportItem><Message i:nil="true"/><Property>Loading project</Property><Status>Success</Status><Value i:nil="true"/></SummaryReportItem><SummaryReportItem><Message i:nil="true"/><Property>Connecting to destination server</Property><Status>Success</Status><Value i:nil="true"/></SummaryReportItem><SummaryReportItem><Message i:nil="true"/><Property>Changing protection level</Property><Status>Success</Status><Value i:nil="true"/></SummaryReportItem><SummaryReportItem><Message>A .NET Framework error occurred during execution of user-defined routine or aggregate "deploy_project_internal": &#xD;
System.Data.SqlClient.SqlException: The locale identifier (LCID) 14348 is not supported by SQL Server.&#xD;
System.Data.SqlClient.SqlException: &#xD;
à System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)&#xD;
à System.Data.SqlClient.SqlInternalConnectionSmi.EventSink.DispatchMessages(Boolean ignoreNonFatalMessages)&#xD;
à System.Data.SqlClient.SqlDataReaderSmi.InternalNextResult(Boolean ignoreNonFatalMessages)&#xD;
à System.Data.SqlClient.SqlDataReaderSmi.NextResult()&#xD;
à System.Data.SqlClient.SqlCommand.RunExecuteReaderSmi(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)&#xD;
à System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task&amp; task, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry)&#xD;
à System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)&#xD;
à System.Data.SqlClient.SqlCommand.ExecuteScalar()&#xD;
à Microsoft.SqlServer.IntegrationServices.Server.ServerConnectionControl.GetServerProperty(String propertyName)&#xD;
à Microsoft.SqlServer.IntegrationServices.Server.ServerConnectionControl.GetSchemaVersion()&#xD;
à Microsoft.SqlServer.IntegrationServices.Server.ISServerExecArgumentBuilder.ToString()&#xD;
à Microsoft.SqlServer.IntegrationServices.Server.ServerApi.DeployProjectInternal(SqlInt64 deployId, SqlInt64 versionId, SqlInt64 projectId, SqlString projectName)&#xD;
.</Message><Property>Deploying project</Property><Status>Failure</Status><Value i:type="a:string" xmlns:a="http://www.w3.org/2001/XMLSchema">System.Data.SqlClient.SqlException (0x80131904): A .NET Framework error occurred during execution of user-defined routine or aggregate "deploy_project_internal": &#xD;
System.Data.SqlClient.SqlException: The locale identifier (LCID) 14348 is not supported by SQL Server.&#xD;
System.Data.SqlClient.SqlException: &#xD;
à System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)&#xD;
à System.Data.SqlClient.SqlInternalConnectionSmi.EventSink.DispatchMessages(Boolean ignoreNonFatalMessages)&#xD;
à System.Data.SqlClient.SqlDataReaderSmi.InternalNextResult(Boolean ignoreNonFatalMessages)&#xD;
à System.Data.SqlClient.SqlDataReaderSmi.NextResult()&#xD;
à System.Data.SqlClient.SqlCommand.RunExecuteReaderSmi(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)&#xD;
à System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task&amp; task, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry)&#xD;
à System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)&#xD;
à System.Data.SqlClient.SqlCommand.ExecuteScalar()&#xD;
à Microsoft.SqlServer.IntegrationServices.Server.ServerConnectionControl.GetServerProperty(String propertyName)&#xD;
à Microsoft.SqlServer.IntegrationServices.Server.ServerConnectionControl.GetSchemaVersion()&#xD;
à Microsoft.SqlServer.IntegrationServices.Server.ISServerExecArgumentBuilder.ToString()&#xD;
à Microsoft.SqlServer.IntegrationServices.Server.ServerApi.DeployProjectInternal(SqlInt64 deployId, SqlInt64 versionId, SqlInt64 projectId, SqlString projectName)&#xD;
.&#xD;
à System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)&#xD;
à System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)&#xD;
à System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)&#xD;
à System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady)&#xD;
à System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)&#xD;
à System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task&amp; task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)&#xD;
à System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task&amp; task, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry)&#xD;
à System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry)&#xD;
à System.Data.SqlClient.SqlCommand.ExecuteNonQuery()&#xD;
à Microsoft.SqlServer.IntegrationServices.Common.ObjectModel.SqlHelper.ExecuteSQLCommand(SqlStoreConnection storeConnection, CommandType cmdType, String cmdText, SqlParameter[] parameters, ExecuteType execType, Int32 commandTimeout)&#xD;
à Microsoft.SqlServer.Management.IntegrationServices.CatalogFolder.DeployProject(String projectName, Byte[] projectStream)&#xD;
à Microsoft.SqlServer.IntegrationServices.Wizard.Common.Model.DeployExportProjectHelper.DeployProject(CatalogFolder folder, String projectName, MemoryStream projectStream)&#xD;
à Microsoft.SqlServer.IntegrationServices.Wizard.Common.Model.DeploymentModel.Deploy(CatalogFolder folder, String projectName, MemoryStream projectStream)&#xD;
à Microsoft.SqlServer.IntegrationServices.Wizard.Common.Model.DeploymentModel.DeployProject()&#xD;
ClientConnectionId :606043b6-292f-4051-b3f2-182177232de1&#xD;
Error Number :6522,State :1,Class :16</Value></SummaryReportItem></ReportItems></Results><Summary><ReportSection><Children/><Header>Use the following arguments to perform this deployment from the command line:</Header><ReportItems><SummaryReportItem><Message/><Property>Command line</Property><Status>None</Status><Value i:type="a:string" xmlns:a="http://www.w3.org/2001/XMLSchema">/Silent /ModelType:Project /SourcePath:"C:\Users\Micro\source\repos\Formation_SSIS\Déploiement d'un projet\bin\Development\Déploiement d'un projet.ispac" /DestinationServer:"DESKTOP-5AKSM5D" /DestinationPath:"/SSISDB/PackageGestionFichier/Déploiement d'un projet"</Value></SummaryReportItem></ReportItems></ReportSection><ReportSection><Children/><Header>Source</Header><ReportItems><SummaryReportItem><Message/><Property>Path</Property><Status>None</Status><Value i:type="a:string" xmlns:a="http://www.w3.org/2001/XMLSchema">C:\Users\Micro\source\repos\Formation_SSIS\Déploiement d'un projet\bin\Development\Déploiement d'un projet.ispac</Value></SummaryReportItem></ReportItems></ReportSection><ReportSection><Children/><Header>Destination</Header><ReportItems><SummaryReportItem><Message/><Property>Server name</Property><Status>None</Status><Value i:type="a:string" xmlns:a="http://www.w3.org/2001/XMLSchema">DESKTOP-5AKSM5D</Value></SummaryReportItem><SummaryReportItem><Message/><Property>Path</Property><Status>None</Status><Value i:type="a:string" xmlns:a="http://www.w3.org/2001/XMLSchema">/SSISDB/PackageGestionFichier/Déploiement d'un projet</Value></SummaryReportItem></ReportItems></ReportSection></Summary></WizardReport>


I changed my local setting to :
"Locale" change to 00000409
"LocaleName" change to "en-US"

But I can't deploy my ipac file.
Thanks for help

sql-server-generalsql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered ZoeHui-MSFT edited

Hi @ikramelmbarki-0704,

You may try below methods for a try.

Method1:
Go to SSMS-->Go To Security-->Logins-->Right Click on your username and select Properties-->Change the default language to English

Method2:
Go to RegEdit -> HKEY_USERS -> [SID Local Admin] -> Control Panel -> International and change keys "Locale" and "LocaleName" for the desired region.

Method3:
Go to Windows Services, right click SQL Server (MSSQLSERVER) > properties > Log On > Tick the 'Local System account'. Restart the service by right clicking SQL Server (MSSQLSERVER) again and clicking restart.

Don't forget to restart SQL Sever.

Reference: http://www.vdwielen.net/2018/12/ssis-deployment-error-locale-id-lcid.html

https://stackoverflow.com/questions/21135511/ssis-error-while-deploying-package-the-locale-identifier-lcid-is-not-supported

Regards,

Zoe


If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.