The 'ExecutorPackage' package did not load correctly

[devvcat]

After installation of the SSMS Executor extension on SSMS 2014/6, the following warning is displayed:

Workaround: Click 'No' and restart SSMS.

[sampSCS]

Unfortunately, the workaround doesn't get the extension working for me. After starting SSMS.exe (2014) with the "/log" switch, I found the following in the referenced ActivityLog.xml:

Error loading extension: The extension manifest is invalid. There is an error in XML document (1, 2). <PackageManifest xmlns='http://schemas.microsoft.com/developer/vsx-schema/2011'> was not expected.

Hope this helps! (I'll be very glad to have this great extension working for me again! )

[devvcat]

Hi @sampSCS,

when you install the extension and start SSMS 2014/2016 you will get this error

Error loading extension: The extension manifest is invalid. There is an error in XML document (1, 2). <PackageManifest xmlns='http://schemas.microsoft.com/developer/vsx-schema/2011'> > was not expected.

I haven't found a solution for this issue, yet. However the workaround for now is to click "No" and restart SSMS. After that, the extension will be working.

Please not the SSMS 2008 Add-In is not compatible with SSMS 2014. You need to either uninstall the 2008 add-in or remove it from:

%APPDATA%\Microsoft\MSEnvShared\AddIns

Let me know if this works for you. Stanislav

[sampSCS]

Stannislav,

After removing SSMSExecutor from:

%APPDATA%\Microsoft\MSEnvShared\AddIns

I also removed, then re-extracted the contents of “SSMSExecutor-2.0-alpha.zip” to my SSMS 2014 extensions folder at:

C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\Extensions

While I’m not getting the error when starting SSMS2014, [CTRL]+[SHIFT]+[E] still isn’t working. I also confirmed there isn’t anything else mapped to that hotkey combination.

Is there anything else I can try?

Regards,

--Sam

From: Stanislav Stoyanov [mailto:[email protected]] Sent: Monday, October 10, 2016 4:16 AM To: devvcat/ssms-executor [email protected] Cc: sampSCS [email protected]; Mention [email protected] Subject: Re: [devvcat/ssms-executor] The 'ExecutorPackage' package did not load correctly (#1)

Hi @sampSCS https://github.com/sampSCS ,

when you install the extension and start SSMS 2014/2016 you will get this error

Error loading extension: The extension manifest is invalid. There is an error in XML document (1, 2). <PackageManifest xmlns='http://schemas.microsoft.com/developer/vsx-schema/2011'> > was not expected.

I haven't found a solution this issue, yet. However the workaround for now is to click "No" and restart SSMS. After that, the extension will be working.

Please not the SSMS 2008 Add-In is not compatible with SSMS 2014. You need to either uninstall the 2008 add-in or remove it from:

%APPDATA%\Microsoft\MSEnvShared\AddIns

Let me know if this works for you. Stanislav

[devvcat]

Hi @sampSCS,

do you see the new SSMSExecutor icon when you open new query in SSMS?

Does it execute your query when you click the icon?

Can you confirm that the old add-in is removed? Do you see the icon for the old add-in and when you point to it does it have a key combination assigned?

Currently, the short cut is hardcoded in the code (I haven't found a way to add a keyboard mapping in the SSMS options).

In SSMS 2014 do you see mapping for the old add-in, if so, remove the assignment.

Uninstall the old-addin from Control Panel\Add remove programs.

Also it is important that when the above error occurs, to click "No" and restart SSMS.

The 'ExecutorPackage' package did not load correctly

Stanislav

[sampSCS]

Stanislav,

My answers to your question are found in-line below.

Regards,

--Sam

From: Stanislav Stoyanov [mailto:[email protected]] Sent: Monday, October 10, 2016 8:26 AM To: devvcat/ssms-executor [email protected] Cc: sampSCS [email protected]; Mention [email protected] Subject: Re: [devvcat/ssms-executor] The 'ExecutorPackage' package did not load correctly (#1)

Hi @sampSCS https://github.com/sampSCS ,

do you see the new SSMSExecutor icon when you open new query in SSMS? No, I don’t have any new icons.

https://cloud.githubusercontent.com/assets/16592863/19238854/0d962b8a-8f0c-11e6-82d2-f317773c984d.png

Does it execute your query when you click the icon? No icon

Can you confirm that the old add-in is removed? The old add-in was installed in my SSMS2012, but I have now removed it. Do you see the icon for the old add-in and when you point to it does it have a key combination assigned? No, I don’t have this icon either (I’ve never installed the old add-in to my SSMS2014).

https://cloud.githubusercontent.com/assets/16592863/19239051/fb50cd44-8f0c-11e6-8ec5-92d44124e3b4.png

Currently, the short cut is hardcoded in the code (I haven't found a way to add a keyboard mapping in the SSMS options). In the Keyboard section of the Options, the [CTRL]+[SHIFT]+[E] is not currently mapped to any functionality.

In SSMS 2014 do you see mapping for the old add-in, if so, remove the assignment. Does not exist in my SSMS2014 https://cloud.githubusercontent.com/assets/16592863/19239312/19caaf96-8f0e-11e6-90bc-b938a8a00177.png

Uninstall the old-addin from Control Panel\Add remove programs. Uninstalled the old add-in (I think it was installed for my SSMS2012)

Also it is important that when the above error occurs, to click "No" and restart SSMS.

The 'ExecutorPackage' package did not load correctly I am no longer getting this error, but the functionality isn’t working either

Stanislav

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/devvcat/ssms-executor/issues/1#issuecomment-252637184 , or mute the thread https://github.com/notifications/unsubscribe-auth/AFDMiAqyCky6w7lSmzsbjQWFrz46z63Aks5qyksBgaJpZM4KK4Jg . https://github.com/notifications/beacon/AFDMiG_33FbfJZMGkgUclSMSRTSu-cVaks5qyksBgaJpZM4KK4Jg.gif

[shining01]

Hello,

the plugin didn't load. i have copied the extracted folder to C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\Extensions

Can you help me please?

[sampSCS]

@devvcat : Any luck figuring out why your extension isn't loading for me in SSMS2014? Is there anything I can do to help figure out why it isn't loading?

[argrithmag]

Great project, however, because I had previously installed another package that didn't clean up after itself, the Ctrl-Shift-E was already mapped to that other packages step. What is the name of the command you use to execute? I need to remap it.

@shining01 - you downloaded the source, not the package. unless you plan on building it yourself, that won't work.

[devvcat]

Hi @argrithmag,

in the current implementation the keyboard shortcut is hardcoded in the code. You won't find a command in SSMS options (don't know yet how to add it).

I think you should manually remove the left over Ctrl+Shift+E assignment. Go to Options->Keyboard find the command that has the assignment and remove it. Restart SSMS, now if you point you mouse over the "Execute Current Statement" button you should see the shortcut.

[sampSCS]

@devvcat : Finally upgraded to SSMS 2016 and thought I would try to get your addin working again.

Unfortunately, I'm seeing the same behavior I saw, and documented, with SSMS 2014.

Perhaps I'm not installing it correctly?

Just to check... I am downloading the SSMSExecutor-2.0-alpha.zip file, opening it, and copying the SSMSExecutor folder to my "C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\Extensions" folder.

After doing this for the first time, upon opening a new query window in SSMS 2016, I get the error message in the first post of this thread. After clicking "No" and restarting, I no longer get the message, but I don't any new icons on the toolbar, and the hotkey, CTRL+SHFT+E, does nothing. I have verified that the original plugin was uninstalled, and nothing else is using that hotkey.

Any ideas?

[devvcat]

Hi @sampSCS,

because you see the initial error, the extension must be loading. After restarting SSMS and opening new query you should see the 'Execute current statement' button. In the next few days I'll setup a clean VM and will test the plugin.

Do you have any version of Visual Studio installed on your machine?

Stanislav

[sampSCS]

@devvcat RE: Do you have any version of Visual Studio installed on your machine?

I have VS2005, 2008, and 2012 installed, though most of my current work is done in VS2012 (when not in SSMS). There is probably a copy of VS2010 with Data Tools installed somewhere as well.

[argrithmag]

@devvcat Thanks. I got the keyboard short cleaned up. However, I've gone through the restart several times, ignore error etc. and about every other time I start ssms, I get the popup with the error message.

[devvcat]

@sampSCS, tested on clean Windows 7 VM with only SSMS2016 installed (without any version of Visual Studio or Sql Server), the plug in worked as expected.

@argrithmag, which version of SSMS are you using. 2014 or 2016? Can you open Regedit.exe, navigate to node: HKEY_CURRENT_USER\SOFTWARE\Microsoft\SQL Server Management Studio\12.0\Packages and HKEY_CURRENT_USER\SOFTWARE\Microsoft\SQL Server Management Studio\13.0\Packages

Do you see key '{A64D9865-B938-4543-BF8F-A553CC4F67F3}' Inside do you see value 'SkipLoading=1'

@sampSCS, please find my email in the commits and contact me directly, may we can schedule a quick teamviewer session to resolve your issue.

Stanislav

[BFASJRStyons]

I have the same issues described above. When I use the /log parameter, the generated log file has these two entries at the end:

  <entry>
    <record>1121</record>
    <time>2017/04/04 21:20:57.209</time>
    <type>Information</type>
    <source>VisualStudio</source>
    <description>Entering function CVsPackageInfo::HrInstantiatePackage</description>
    <guid>{A64D9865-B938-4543-BF8F-A553CC4F67F3}</guid>
  </entry>
  <entry>
    <record>1122</record>
    <time>2017/04/04 21:20:57.209</time>
    <type>Warning</type>
    <source>VisualStudio</source>
    <description>Appid denied the loading of package</description>
    <guid>{A64D9865-B938-4543-BF8F-A553CC4F67F3}</guid>
  </entry>

[ktaranov]

Same issue for latest on this moment SSMS 17.3 https://i.imgur.com/7QnWvDl.png

[ghost]

Same problem for me with SSMS 17.3. Helped launching SSMS with Admin rights. You don't need to launch it under Admin every time - just once after extension extracted.

[Betlista]

Same problem for me with SSMS 17.4 . I tried to start with admin rights and I have same problem.

[gcmicah]

I have tried the recommended installation and all above suggested tips and tricks, but none could make this plugin work for sSMS v17.7 Component info. of my environment is as below. Hope it gets fixed soon.

Microsoft SQL Server Management Studio 14.0.17254.0 Microsoft Analysis Services Client Tools 14.0.1016.251 Microsoft Data Access Components (MDAC) 10.0.16299.15 Microsoft MSXML 3.0 6.0 Microsoft Internet Explorer 9.11.16299.0 Microsoft .NET Framework 4.0.30319.42000 Operating System 6.3.16299

[webgep]

Hey guys - had the same issue. - but now its working (using 18.5)

I don't know if some of steps can be ignored ...

1. I copied the sqlexecuter from the zip file and placed it in extensions folder( create it if it's not there) .... It came with the "not loaded" error message
2. I then installed from the msi package with ADMINISTRATOR rights.

now its working ( i didn'r reboot yet :) )