none
GPO Backup - baseline could not be imported into the database

    Question

  • Getting an error when trying to import a GPO backup I just created.

    I see the following error information:

    Program Location:

    at Microsoft.SecurityComplianceManager.ClientObjects.Baselines.BulkCopy.InsertFromDataTable(Boolean ignoreDuplicates)
       at Microsoft.SecurityComplianceManager.ImportGPO.CreateSettingsForImportedGPO.CreateBaselineAndSettingGroups()
       at Microsoft.SecurityComplianceManager.ImportGPO.ImportGPOCommon.ImportGpoFromFolder()
    ==================
    XML parsing: line 1, character 1031, illegal xml character
    ------------------
    Additional data:

    HelpLink.ProdName: Microsoft SQL Server
    HelpLink.ProdVer: 10.00.1600
    HelpLink.EvtSrc: MSSQLServer
    HelpLink.EvtID: 9420
    HelpLink.BaseHelpUrl: http://go.microsoft.com/fwlink
    HelpLink.LinkId: 20476

    ------------------
    Program Location:

    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlBulkCopy.RunParser(BulkCopySimpleResultSet bulkCopyHandler)
       at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinuedOnSuccess(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)
       at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)
       at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)
       at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source)
       at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestAsync(CancellationToken cts, TaskCompletionSource`1 source)
       at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalAsync(CancellationToken ctoken)
       at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServerAsync(Int32 columnCount, CancellationToken ctoken)
       at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
       at Microsoft.SecurityComplianceManager.ClientObjects.Baselines.BulkCopy.InsertFromDataTable(Boolean ignoreDuplicates)

    Other GPO backups are fine. How can I track down the cause of this error?

    Friday, February 28, 2014 9:47 PM

All replies

  • I found the culprit by elinming the settings until the error went away. I had a long dash (Char 150) instead of a normal dash (Char 45) in one of the GPO settings.
    Friday, March 07, 2014 4:30 AM