[SQL Server Data Warehousing] Datawarehouse 33503 SQL-Server-Error

One of our customers has installed one datawarehouse and one management-server.

There is only one Problem. The datawarehouse’s SQL-Server (English) is installed in another language than the SQL-Server of the management server (German) but the collation is still the same. (Latin1_Gerneral_100_CI_AS)

Now there are thousands of following errors shown in eventlog:

Log Name:      Operations Manager

Source:        Data Warehouse

Date:          26.04.2013 08:34:27

Event ID:      33503

Task Category: None

Level:         Warning

Keywords:      Classic

User:          N/A

Computer:    

Description:

An error countered while attempting to execute ETL Module:

ETL process type: Extract

Batch ID: 377

Module name: Extract_EnumType_GR_ITSD

Message: Fehler beim Konvertieren einer Zeichenfolge in ein Datum und/oder eine Uhrzeit.

Message translated to English: Conversion failed when converting date and/or time from character string.

Stack:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

   at System.Data.SqlClient.SqlDataReader.HasMoreRows()

   at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)

   at System.Data.SqlClient.SqlBulkCopy.ReadFromRowSource()

   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()

   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)

   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)

Event Xml:

 

   

    33503

    3

    0

    0x80000000000000

   

    5082730

    Operations Manager

   

   

 

 

    Extract

    377

    Extract_EnumType_GR_ITSD

    Fehler beim Konvertieren einer Zeichenfolge in ein Datum und/oder eine Uhrzeit.

       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

   at System.Data.SqlClient.SqlDataReader.HasMoreRows()

   at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)

   at System.Data.SqlClient.SqlBulkCopy.ReadFromRowSource()

   at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()

   at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)

   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)

 

Is there any possibility to fix this problem?

Thanks for reply!

.

social.technet.microsoft.com/Forums