none
SQL 2014 6.6.2.0 Filling SQL DW Logs RRS feed

  • Question

  • Hi all,

    After updating the SQL 2014 MP 6.6.2.0 form 6.6.0.0 the Log file on the DW started to fill and i got these errors:

    Data Warehouse failed to deploy database component. Failed to deploy Data Warehouse component. The operation will be retried.

    Exception 'DeploymentException': Failed to perform Data Warehouse component deployment operation: Install; Component: Script, Id: '4173391e-ce71-1369-c358-17030bb09b41', Management Pack Version-dependent Id: '8152d5f4-c958-2b42-2a56-a8fff2ea3f98'; Target: Database, Server name: 'colo-scomdw', Database name: 'OperationsManagerDW'. Batch ordinal: 39; Exception: Sql execution failed. Error 9002, Level 17, State 4, Procedure Microsoft_SQLServer_Visualization_Library_UpdateHierarchy, Line 192, Message: The transaction log for database 'OperationsManagerDW' is full due to 'ACTIVE_TRANSACTION'.

    In the SQL DW the current process is insert on Microsoft_SQLServer_Visualization_Library_UpdateHierarchy.

    I just attempted to delete the MP's. I removed the overrides MP first and them hit a dependency on: microsoft :Microsoft.SystemCenter.SecureReferenceOverride when removing this MP:Microsoft.SQLServer.2014.IntegrationServices.Discovery. Sigh

    Whats the best course of action. How can i remove this thing..

    Thanks, 

    Mike

      

     
    • Edited by HelpMe_AU Tuesday, October 20, 2015 2:27 AM
    Tuesday, October 20, 2015 2:26 AM

Answers

  • Just remove SQL Server Visualization Management Pack and all other management packs which depends on it and wait for new MP release. It's known issue.

    Vladimir Zelenov | http://systemcenter4all.wordpress.com

    Tuesday, October 20, 2015 8:23 AM

All replies

  • I have this issue too.

    Vladimir Zelenov | http://systemcenter4all.wordpress.com

    Tuesday, October 20, 2015 7:37 AM
  • Just remove SQL Server Visualization Management Pack and all other management packs which depends on it and wait for new MP release. It's known issue.

    Vladimir Zelenov | http://systemcenter4all.wordpress.com

    Tuesday, October 20, 2015 8:23 AM
  • Arr crap i just check the dependencies and the dam Default MP is listed. I created a Dashboard under the main tree and it must have saved it to the Default MP as now that i think about it i can't recall putting it in my dashboards MP. 

    Can i just remove the reference in the MP:

     <PublicKeyToken>31bf3856ad364e35</PublicKeyToken>
          </Reference>
          <Reference Alias="SQLServer">
            <ID>Microsoft.SQLServer.Visualization.Library</ID>
            <Version>6.6.2.0</Version>

    Also remove this at the top <?xml version="1.0" encoding="utf-8"?>

    After this occurred i deleted the Dashboard and looking at an older version of the MP a lot of references have been removed except the reference above 

    And is it OK to update the Default MP version or is it better to delete it and then re-import?

     <Manifest>
        <Identity>
          <ID>Microsoft.SystemCenter.OperationsManager.DefaultUser</ID>
          <Version>7.1.10226.0</Version>
        </Identity>
        <Name>My Default Management Pack</Name>
        <References>

    Sorry for all the questions, I haven't been stung with this before and normally stay a few versions behind allowing a path forward. O'well learning is FUN...

    Also has MS advised this is a know issue somewhere if so i would be interested in the link to track the progress and fix.

    Thanks

    Mike


    Tuesday, October 20, 2015 10:50 AM
  • Hi,

    You don't need to update the Default MP version since it is unsealed.

    Unsealed MP could be successfully imported over and over again using the same version number.

    To remove the reference <Reference Alias="SQLServer">, you have to find and delete the usages.

    The usages will start with "<alias>!", "SQLServer!" in your example.

    You should remove all the tags that have this usage.

    Then, you can remove the reference.

    It is a good idea to save this cleaned default MP somewhere as a backup in case of having unwanted references again.

    Then, you can just export the spoiled one (to be safe) and import the backup one.

    Thanks,

    Dmitry.

    Tuesday, October 20, 2015 12:04 PM
  • See more about the issue here:

    https://social.technet.microsoft.com/Forums/scriptcenter/en-US/a0f1ff51-791a-4231-a674-6905069356f3/sql-management-pack-6620-broken-visualizations?forum=operationsmanagermgmtpacks

    That was well tested, hmm?


    Please remember to click “Mark as Answer” on the post that helped you. <br/> Patrick Seidl (System Center and Private Cloud) <br/> Blog: http://www.systemcenterrocks.com

    Tuesday, October 20, 2015 12:11 PM
  • Just remove SQL Server Visualization Management Pack and all other management packs which depends on it and wait for new MP release. It's known issue.

    Vladimir Zelenov | http://systemcenter4all.wordpress.com

    The trouble is that that visualization MP has a dependency on almost all of the other MP's!  There's not much of SQL monitoring left when deleted - I'm not even sure what monitoring is left.

    this really is a horrific release.

    Tuesday, October 20, 2015 3:55 PM
  • I only had to remove 3 other sealed SQL MPs before deleting this one....but agreed, Flagship MP and this happens???!

    JB

    Tuesday, October 20, 2015 9:10 PM
  • We have this issue too and 2012 R2 U7. DW log is full now from it. This was the same issue on MP 6.6.0.0 and appears still not fixed on 6.6.2.0


    • Edited by RichardLeos Wednesday, October 21, 2015 6:00 AM
    Wednesday, October 21, 2015 5:59 AM
  • You're right.  The following are the only dependencies:

    Microsoft SQL Server Visualization Library
        Microsoft SQL Server Generic Dashboards
        Microsoft SQL Server 2014 (Presentation)
        Microsoft SQL Server 2012 (Presentation)
        Microsoft SQL Server 2008 (Presentation)

    get these out and you're good again.

    And yes, their flagship MP.  SCOM has lost a lot of trust here after yesterdays downtime. I have worked hard to get people interested.

    • Edited by Robuea Wednesday, October 21, 2015 9:06 AM
    Wednesday, October 21, 2015 9:05 AM
  • I agree Robuea,

    As a SCOM SME, much of my mental energy and time with this tool is taken up by the internal PR battle, to win people over to its worthiness. Situations like this don't help, especially when you enthusiastically promote such improvements to its historically woeful presentation layer only for those improvements to go pear shaped again...back to square one.

    Thursday, October 22, 2015 1:02 AM
  • Please up-vote this problem on Connect.
    Thursday, October 22, 2015 9:58 AM
  • http://blogs.msdn.com/b/sqlreleaseservices/archive/2015/10/16/released-system-center-management-pack-for-sql-server-and-replication-6-6-2-0.aspx?CommentPosted=true&PageIndex=2#comments

    UPDATE (10/22/2015): We have removed this release from Download Center for the time being. Large number of customers reported seeing an issue with tempdb and DW log growing above normal levels. We are working on a fix and will release an update as soon as we have it ready. If you have already installed 6.6.2.0 and seeing this issue in your environment, please run the script below to mitigate the problem. You should still update your environment when we have the new release available even if you run the workaround. We apologize for the trouble this has caused you.

    alter procedure sdk.Microsoft_SQLServer_Visualization_Library_UpdateHierarchy as RETURN 0;

    GO

    alter procedure sdk.Microsoft_SQLServer_Visualization_Library_UpdateLastValues as RETURN 0;

    GO

    update sdk.Microsoft_SQLServer_Visualization_Library_Tables set LastProcessedId = 9223372036854775807;

    Thursday, October 22, 2015 7:52 PM
  • Fixed management packs 6.6.3.0 was released.

    http://www.microsoft.com/en-us/download/details.aspx?id=10631


    Vladimir Zelenov | http://systemcenter4all.wordpress.com

    Thursday, November 12, 2015 1:35 PM
  • Has someone (Microsoft???) tested it already?

    Cheers,
    Patrick


    Please remember to click 'Mark as Answer' on the post that helped you.

    Patrick Seidl (System Center and Private Cloud)
    s2 - seidl solutions
    Blog: http://www.systemcenterrocks.com

    Thursday, November 12, 2015 1:46 PM
  • Has someone (Microsoft???) tested it already?

    Cheers,
    Patrick


    Please remember to click 'Mark as Answer' on the post that helped you.

    Patrick Seidl (System Center and Private Cloud)
    s2 - seidl solutions
    Blog: http://www.systemcenterrocks.com


    I tested, all works fine!

    Vladimir Zelenov | http://systemcenter4all.wordpress.com

    Thursday, November 12, 2015 9:39 PM
  • Has someone (Microsoft???) tested it already?

    Cheers,
    Patrick


    Please remember to click 'Mark as Answer' on the post that helped you.

    Patrick Seidl (System Center and Private Cloud)
    s2 - seidl solutions
    Blog: http://www.systemcenterrocks.com


    I tested, all works fine!

    Vladimir Zelenov | http://systemcenter4all.wordpress.com

    Many thanks to Vladimir for a help with a testing.
    Friday, November 13, 2015 1:22 AM