locked
Either a required impersonation level was not provided, or the provided impersonation level is invalid RRS feed

  • Question

  • My SSMS has been able to processing cubes correctly before I have applied these four patches KB2676562, KB2686509, KB2695962, KB2659262

    When I process the cubes on AS2005, this is the error message that I get:

    Errors and Warnings from Response

                    Internal error: The operation terminated unsuccessfully.

                    Internal error: The operation terminated unsuccessfully.

                    Errors in the high-level relational engine. The following exception occurred while the managed IDbConnection interface was being used: Could not load file or assembly 'System.Transactions, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. Either a required impersonation level was not provided, or the provided impersonation level is invalid. (Exception from HRESULT: 0x80070542).

    I use my AD account as the impersonation in the datasource and in the cube database, it looks like SSAS is impersonating my account, but fails to access System.Transaction

    Any one knows what is going on? And how i can fix this?

    Monday, May 28, 2012 8:46 PM

Answers

  • It seems like that the windows update caused Analysis to stop, and the first start up after that will cause this failure.

    I restarted the service and now it seems to be running correctly

    • Marked as answer by Makubex Wednesday, May 30, 2012 3:44 PM
    Wednesday, May 30, 2012 3:44 PM

All replies

  • I suspect that the issue is that System.Transactions has disappeared from the GAC. Have a look at the following and see if it helps:

    http://geekswithblogs.net/ranganh/archive/2009/05/27/error-could-not-load-file-or-assembly-system.transactions-version2.0.0.0-cultureneutral.aspx


    http://bi-logger.blogspot.com/

    Tuesday, May 29, 2012 6:19 PM
  • i checked the GAC and it seems like that System.Transactions are there. Even when they are there, do i still need to register them? I need to take cautious steps because this is on a production server

    Tuesday, May 29, 2012 8:15 PM
  • No, you don't need to register it if it is in the GAC. The loader should automatically check the GAC for assemblies (unless the application specifically attempts to open an assembly from a given location) but you do need to make sure it is the correct version. I'm pretty sure that there is an issue with not being able to find that assembly

    http://bi-logger.blogspot.com/

    Wednesday, May 30, 2012 7:11 AM
  • There are 2 System.Transactions in the GAC, one for x86, one for AMD64, both are 2.0.0.0 and has token b77a5c561934e089

    The error message that I am getting from the cube is as following, and it seems so that it is looking for the same public token:

    Processing Dimension 'TreeMaster' completed successfully.
    Start time: 5/28/2012 2:58:05 PM; End time: 5/28/2012 2:58:05 PM; Duration: 0:00:00
    Processing Dimension Attribute '(All)' completed successfully.
    Start time: 5/28/2012 2:58:05 PM; End time: 5/28/2012 2:58:05 PM; Duration: 0:00:00
    Processing Dimension Attribute 'Inactive' completed successfully.
    Start time: 5/28/2012 2:58:05 PM; End time: 5/28/2012 2:58:05 PM; Duration: 0:00:00
    Errors and Warnings from Response
    Internal error: The operation terminated unsuccessfully.
    Internal error: The operation terminated unsuccessfully.
    Errors in the high-level relational engine. The following exception occurred while the managed IDbConnection interface was being used: Could not load file or assembly 'System.Transactions, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. Either a required impersonation level was not provided, or the provided impersonation level is invalid. (Exception from HRESULT: 0x80070542).
    Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Blah Dev', Name of 'Blah'.
    Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'LU GLB Tree Master', Name of 'TreeMaster' was being processed.
    Errors in the OLAP storage engine: An error occurred while the 'Inactive' attribute of the 'TreeMaster' dimension from the 'BlahGX2' database was being processed.
    Server: The operation has been cancelled.


    • Edited by Makubex Wednesday, May 30, 2012 2:00 PM
    Wednesday, May 30, 2012 1:59 PM
  • It seems like that the windows update caused Analysis to stop, and the first start up after that will cause this failure.

    I restarted the service and now it seems to be running correctly

    • Marked as answer by Makubex Wednesday, May 30, 2012 3:44 PM
    Wednesday, May 30, 2012 3:44 PM