Event log error

  • I have scripts that send error log reports to me every day for all of our production VMs. I keep seeing this message in several of our sql 2012 installations, should I be concerned? Is there something I can do to remedy this? I can't imagine that the CopyDatabaseWizard is being invoked, either. Error message follows:

    Activation context generation failed for "c:\program files (x86)\microsoft sql server\120\Tools\Binn\managementstudio\CopyDatabaseWizard.exe".Error in manifest or policy file "c:\program files (x86)\microsoft sql server\120\Tools\Binn\managementstudio\CopyDatabaseWizard.exe" on line 8. The value "1.0" of attribute "version" in element "assemblyIdentity" is invalid.

  • I have the same error. I suspect it has something to do with my nightly full database backups.

  • Have you checked that you don't have any maint plans or SSIS pkgs that may be calling it?

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

  • Correct, that has been ruled out.

  • Well then, if there are no other problems with SQL and you can't find anything online about it then I'd say you can ignore it until it becomes an issue.

    How many times a day does it happen?

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

  • I've only seen it once a day, but on multiple VMs.

    This was happening with sql 2012 SP1 and then after I upgraded to SP2 + CU3.

    Nothing is breaking, but then again I don't ever use the copy database wizard 🙂

  • Pretty much the same story with me except we use SQL Server 2014

  • Y unsolved mysteries like that can be annoying, but pick your battles. If it's not causing any problems then let it go.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

  • I suspect that only Microsoft can answer this mystery.

  • I found the short way:

    1. make a backup copy of "copydatabasewizard.exe";

    2. edit "copydatabasewizard.exe" with an Hex editor;

    3. search for "assemblyIdentity";

    4. change "version" value (right of "=" char) from "1.0" to "1.0.0.0"

    5. save change

    And voila ! "copydatabasewizard.exe" works again !

    Don't know why MS has an incorrect manifest embedded in that file, FYI version number must have 4 digits, not 2.

    Ciao.

    Paolo.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply