locked
Extract_SCSMAdmin fault RRS feed

  • Question

  • Datawarehouse The registration process does not hold up to the end.

    It has deployed 13 modules and eventually Extract_SCSMAdmin - fault.

    Used SCSM 2012 r2.

    The reports were developed, but when you create a report, no information.

    Logs I do not understand WinOperMng.

    How to deal with it and that it is not enough?

    Имя журнала:   Operations Manager
    Источник:      Data Warehouse
    Дата:          19.01.2017 14:50:15
    Код события:   33503
    Категория задачи:Отсутствует
    Уровень:       Предупреждение
    Ключевые слова:Классический
    Пользователь:  Н/Д
    Компьютер:     srv-scsmdw-01.aq***.local
    Описание:
    An error countered while attempting to execute ETL Module:
     ETL process type: Extract
     Batch ID: 1252
     Module name: Extract_TypedManagedEntity_SCSMAdmin
     Message: Invalid target entity name. Can not generate SSPI context.

     Stack:    в System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling)
       в System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
       в System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
       в System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
       в System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
       в System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
       в System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
       в System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
       в System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       в System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
       в System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
       в System.Data.SqlClient.SqlConnection.Open()
       в Microsoft.SystemCenter.Warehouse.Utility.Helper.GetConnection(String connectionString, DomainUser securedUser)
       в Microsoft.SystemCenter.Warehouse.Utility.SqlBulkOperation.Insert(String sourceConnStrg, String sourceQuery, String destinationTable, Dictionary`2 mapping, String sqlConnectionStrg, Boolean& readerHasRows, DomainUser sourceSecureUser, DomainUser destSecureUser)
       в Microsoft.SystemCenter.Warehouse.Etl.ADOInterface.Insert(DomainUser sourceConnectionUser, DomainUser destinationConnectionUser)
       в Microsoft.SystemCenter.Warehouse.Etl.ADOInterface.Execute(IXPathNavigable config, Watermark wm, DomainUser sourceConnectionUser, DomainUser destinationConnectionUser)
       в Microsoft.SystemCenter.Warehouse.Etl.ExtractModule.Execute(IXPathNavigable config, Watermark wm, DomainUser sourceConnectionUser, DomainUser destinationConnectionUser, Int32 batchSize)
       в Microsoft.SystemCenter.Warehouse.Etl.ExtractModule.Execute(IXPathNavigable config, Watermark wm, DomainUser sourceConnectionUser, DomainUser destinationConnectionUser)
       в Microsoft.SystemCenter.Etl.ETLModule.OnDataItem(DataItemBase dataItem, DataItemAcknowledgementCallback acknowledgedCallback, Object acknowledgedState, DataItemProcessingCompleteCallback completionCallback, Object completionState)

    Имя журнала:   Operations Manager
    Источник:      Data Warehouse
    Дата:          19.01.2017 14:50:15
    Код события:   33502
    Категория задачи:Отсутствует
    Уровень:       Ошибка
    Ключевые слова:Классический
    Пользователь:  Н/Д
    Компьютер:     srv-scsmdw-01.aq***.local
    Описание:
    ETL Module Execution failed:
     ETL process type: Extract
     Batch ID: 1252
     Module name: Extract_TypedManagedEntity_SCSMAdmin
     Message: Invalid target entity name. Can not generate SSPI context.

     Stack:    в System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
       в System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
       в System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
       в System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
       в System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
       в System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
       в System.Data.SqlClient.SqlConnection.Open()
       в Microsoft.SystemCenter.Warehouse.Utility.Helper.GetConnection(String connectionString, DomainUser securedUser)
       в Microsoft.SystemCenter.Warehouse.Utility.SqlBulkOperation.Insert(String sourceConnStrg, String sourceQuery, String destinationTable, Dictionary`2 mapping, String sqlConnectionStrg, Boolean& readerHasRows, DomainUser sourceSecureUser, DomainUser destSecureUser)
       в Microsoft.SystemCenter.Warehouse.Etl.ADOInterface.Insert(DomainUser sourceConnectionUser, DomainUser destinationConnectionUser)
       в Microsoft.SystemCenter.Warehouse.Etl.ADOInterface.Execute(IXPathNavigable config, Watermark wm, DomainUser sourceConnectionUser, DomainUser destinationConnectionUser)
       в Microsoft.SystemCenter.Warehouse.Etl.ExtractModule.Execute(IXPathNavigable config, Watermark wm, DomainUser sourceConnectionUser, DomainUser destinationConnectionUser, Int32 batchSize)
       в Microsoft.SystemCenter.Warehouse.Etl.ExtractModule.Execute(IXPathNavigable config, Watermark wm, DomainUser sourceConnectionUser, DomainUser destinationConnectionUser)
       в Microsoft.SystemCenter.Etl.ETLModule.OnDataItem(DataItemBase dataItem, DataItemAcknowledgementCallback acknowledgedCallback, Object acknowledgedState, DataItemProcessingCompleteCallback completionCallback, Object completionState)


    • Edited by Stumm74 Friday, January 20, 2017 6:51 AM
    Friday, January 20, 2017 6:49 AM

All replies

  • Hey,

    when I take a look at the following:

    Module name: Extract_TypedManagedEntity_SCSMAdmin
     Message: Invalid target entity name. Can not generate SSPI context.

    I tend tgo think that there is some problem with the account(s), associated with the SCSMAdmin role?

    The error "Invalid target entity name. Can not generate SSPI context." refers to Kerberos authentication failure.

    Please check if the account(s) there are properly resolved. Please also check if there are some events, related domain authentication in the System event log. Make sure your server has a proper secure channel (different tools are out there that allow you to test it).

    You can then try and reset the DW jobs with a script:

    Resetting and running the Service Manager Data Warehouse Jobs separately

    Regards,


    Stoyan (Please take a moment to "Vote as Helpful" and/or "Mark as Answer" where applicable. This helps the community, keeps the forums tidy, and recognizes useful contributions. Thanks!)

    Monday, January 23, 2017 9:04 AM