Saturday, April 27, 2013

[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

No comments:

Post a Comment

Search This Blog