Error performing data extraction in System Center Service Maganer Data Warehouse 2019

%3CLINGO-SUB%20id%3D%22lingo-sub-2269936%22%20slang%3D%22en-US%22%3EError%20performing%20data%20extraction%20in%20System%20Center%20Service%20Maganer%20Data%20Warehouse%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2269936%22%20slang%3D%22en-US%22%3E%3CP%3EAfter%20performing%20the%20installation%20of%20the%20Data%20Warehouse%20and%20registering%2C%20it%20fails%20to%20perform%20the%20extraction%20jobs.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22israelsantos_0-1618312947769.jpeg%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F272425iCD112741AD215EF2%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22israelsantos_0-1618312947769.jpeg%22%20alt%3D%22israelsantos_0-1618312947769.jpeg%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22israelsantos_1-1618312966600.jpeg%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F272426iC32EFF08D6E706EB%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22israelsantos_1-1618312966600.jpeg%22%20alt%3D%22israelsantos_1-1618312966600.jpeg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EBelow%20is%20the%20error%20message%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EETL%20Module%20Execution%20failed%3A%3CBR%20%2F%3EETL%20process%20type%3A%20Extract%3CBR%20%2F%3EBatch%20ID%3A%20361%3CBR%20%2F%3EModule%20name%3A%20Extract_System.ConfigItemServicedByUser_ndd%3CBR%20%2F%3EMessage%3A%20Failed%20to%20convert%20string%20date%20and%20%2F%20or%20time.%3C%2FP%3E%3CP%3EStack%3A%20at%20System.Data.SqlClient.SqlConnection.OnError(SqlException%20exception%2C%20Boolean%20breakConnection%2C%20Action%601%20wrapCloseInAction)%3CBR%20%2F%3Eat%20System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject%20stateObj%2C%20Boolean%20callerHasConnectionLock%2C%20Boolean%20asyncClose)%3CBR%20%2F%3Eat%20System.Data.SqlClient.TdsParser.TryRun(RunBehavior%20runBehavior%2C%20SqlCommand%20cmdHandler%2C%20SqlDataReader%20dataStream%2C%20BulkCopySimpleResultSet%20bulkCopyHandler%2C%20TdsParserStateObject%20stateObj%2C%20Boolean%26amp%3B%20dataReady)%3CBR%20%2F%3Eat%20System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean%26amp%3B%20moreRows)%3CBR%20%2F%3Eat%20System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean%20setTimeout%2C%20Boolean%26amp%3B%20more)%3CBR%20%2F%3Eat%20System.Data.SqlClient.SqlDataReader.Read()%3CBR%20%2F%3Eat%20System.Data.SqlClient.SqlBulkCopy.ReadFromRowSourceAsync(CancellationToken%20cts)%3CBR%20%2F%3Eat%20System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalAsync(CancellationToken%20ctoken)%3CBR%20%2F%3Eat%20System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServerAsync(Int32%20columnCount%2C%20CancellationToken%20ctoken)%3CBR%20%2F%3Eat%20System.Data.SqlClient.SqlBulkCopy.WriteToServer(IDataReader%20reader)%3CBR%20%2F%3Eat%20Microsoft.SystemCenter.Warehouse.Utility.SqlBulkOperation.Insert(String%20sourceConnStrg%2C%20String%20sourceQuery%2C%20String%20destinationTable%2C%20Dictionary%602%20mapping%2C%20String%20sqlConnectionStrg%2C%20Boolean%26amp%3B%20readerHasRows%2C%20DomainUser%20sourceSecureUser%2C%20DomainUser%20destSecureUser)%3CBR%20%2F%3Eat%20Microsoft.SystemCenter.Warehouse.Etl.ADOInterface.Insert(DomainUser%20sourceConnectionUser%2C%20DomainUser%20destinationConnectionUser)%3CBR%20%2F%3Eat%20Microsoft.SystemCenter.Warehouse.Etl.ADOInterface.Execute(IXPathNavigable%20config%2C%20Watermark%20wm%2C%20DomainUser%20sourceConnectionUser%2C%20DomainUser%20destinationConnectionUser)%3CBR%20%2F%3Eat%20Microsoft.SystemCenter.Warehouse.Etl.ExtractModule.Execute(IXPathNavigable%20config%2C%20Watermark%20wm%2C%20DomainUser%20sourceConnectionUser%2C%20DomainUser%20destinationConnectionUser%2C%20Int32%20batchSize)%3CBR%20%2F%3Eat%20Microsoft.SystemCenter.Warehouse.Etl.ExtractModule.Execute(IXPathNavigable%20config%2C%20Watermark%20wm%2C%20DomainUser%20sourceConnectionUser%2C%20DomainUser%20destinationConnectionUser)%3CBR%20%2F%3Eat%20Microsoft.SystemCenter.Etl.ETLModule.OnDataItem(DataItemBase%20dataItem%2C%20DataItemAcknowledgementCallback%20acknowledgedCallback%2C%20Object%20acknowledgedState%2C%20DataItemProcessingCompleteCallback%20completionCallback%2C%20Object%20completionState)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

After performing the installation of the Data Warehouse and registering, it fails to perform the extraction jobs.

israelsantos_0-1618312947769.jpegisraelsantos_1-1618312966600.jpeg

I'm using SQL Server 2017 Enterprise, I already checked the Collation, I left it as it is in the installation manual. Could someone help me with this problem.
Thank you very much in advance.

 

Below is the error message

 

 

ETL Module Execution failed:
ETL process type: Extract
Batch ID: 361
Module name: Extract_System.ConfigItemServicedByUser_ndd
Message: Failed to convert string date and / or time.

Stack: 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.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
at System.Data.SqlClient.SqlDataReader.Read()
at System.Data.SqlClient.SqlBulkCopy.ReadFromRowSourceAsync(CancellationToken cts)
at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalAsync(CancellationToken ctoken)
at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServerAsync(Int32 columnCount, CancellationToken ctoken)
at System.Data.SqlClient.SqlBulkCopy.WriteToServer(IDataReader reader)
at Microsoft.SystemCenter.Warehouse.Utility.SqlBulkOperation.Insert(String sourceConnStrg, String sourceQuery, String destinationTable, Dictionary`2 mapping, String sqlConnectionStrg, Boolean& readerHasRows, DomainUser sourceSecureUser, DomainUser destSecureUser)
at Microsoft.SystemCenter.Warehouse.Etl.ADOInterface.Insert(DomainUser sourceConnectionUser, DomainUser destinationConnectionUser)
at Microsoft.SystemCenter.Warehouse.Etl.ADOInterface.Execute(IXPathNavigable config, Watermark wm, DomainUser sourceConnectionUser, DomainUser destinationConnectionUser)
at Microsoft.SystemCenter.Warehouse.Etl.ExtractModule.Execute(IXPathNavigable config, Watermark wm, DomainUser sourceConnectionUser, DomainUser destinationConnectionUser, Int32 batchSize)
at Microsoft.SystemCenter.Warehouse.Etl.ExtractModule.Execute(IXPathNavigable config, Watermark wm, DomainUser sourceConnectionUser, DomainUser destinationConnectionUser)
at Microsoft.SystemCenter.Etl.ETLModule.OnDataItem(DataItemBase dataItem, DataItemAcknowledgementCallback acknowledgedCallback, Object acknowledgedState, DataItemProcessingCompleteCallback completionCallback, Object completionState)

 

 

1 Reply
I'm using SQL Server 2017 Enterprise, I already checked the Collation, I left it as it is in the installation manual. Could someone help me with this problem.
Thank you very much in advance.