Home Dashboard Directory Help
Search

SSIS projects and maintenance plans do not work after applying CU3 for SQL Server 2012 SP1 by Alberto Morillo


Status: 

Closed
 as Duplicate Help for as Duplicate


25
0
Sign in
to vote
Type: Bug
ID: 781921
Opened: 3/22/2013 4:38:10 AM
Access Restriction: Public
4
Workaround(s)
view
13
User(s) can reproduce this bug

Description

SSIS projects and maintenance plans do not work after applying CU3 for SQL Server 2012 SP1.

Please see the following threads in MSDN forums:

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/94b78c79-e12a-49d2-8153-bba3904ad9a7

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/749ea170-f24b-4983-875f-4971e985ab01
Details
Sign in to post a comment.
Posted by Alberto Morillo on 4/5/2013 at 7:32 PM
Thank you Peter for the workaround you shared with us!

Regards, Alberto Morillo
Posted by Peter Jenks on 4/3/2013 at 2:20 PM
Thanks Alberto.
Posted by Alberto Morillo on 4/3/2013 at 6:24 AM
Thank you for your feedback and patience Chenn!
Posted by Chenn Ronen - SolidBI on 4/3/2013 at 5:12 AM
Many thanks!
Posted by Alberto Morillo on 4/3/2013 at 3:41 AM
Hello,

The hotfix is available on the following support article:

http://support.microsoft.com/kb/2832017

Hope this helps.

Regards,
Alberto Morillo
SQLCoffee.com
Posted by Chenn Ronen - SolidBI on 4/2/2013 at 11:35 PM
Thanks Alberto, It worked. ( Ineeded to use the installation disc from some reason...) .
Posted by Alberto Morillo on 4/1/2013 at 7:17 AM
Hello Chenn,

Please try to uninstall CU3 and install CU2 as a workaround.

Regards,
Alberto Morillo

Posted by Chenn Ronen - SolidBI on 3/30/2013 at 10:39 PM
The workarround did not work for me.
Is the 3-Apr firm?
Thanks!!!
Posted by Alberto Morillo on 3/27/2013 at 8:40 AM
Thank you again Guy!
Posted by Microsoft on 3/27/2013 at 8:24 AM
Hopefully a KB will be ready around 4/3.
Posted by Microsoft on 3/27/2013 at 8:12 AM
Hi guys, please note 1232978 is the internal MS reference for the hotfix/defect.

The KB is 2832017. It was only coded last night, so the KB probably isn’t available quite yet but will be soon.
Regards
Guy
Posted by Alberto Morillo on 3/27/2013 at 6:51 AM
Hello Mark,
That’s the hotfix number I received. Hotfix 1232978.
I am trying to get a confirmation.
Thank you for reporting this situation.
Regards,
Alberto Morillo
Posted by Mark HPA on 3/27/2013 at 2:06 AM
Alberto, Just phoned Microsoft for this hotfix and they said it doesn't exist. Is 1232978 the right number? I can't find anything about it on the Microsoft website. I've had to log a tech. support call. Waiting for a call back now. Regards, Mark
Posted by Alberto Morillo on 3/22/2013 at 6:23 PM
Hello,

Microsoft has released Hotfix 1232978 for this issue, if anyone needs to reference it with Customer Service & Support.

Thank you to Guy Bowerman (MSFT).

Regards,
Alberto Morillo
Posted by Alberto Morillo on 3/22/2013 at 1:39 PM
Thank you Klaus.
Posted by Alberto Morillo on 3/22/2013 at 1:38 PM
Hello,

Please go to Control Panel -> Programs -> Under “Programs and Features” click on “View installed updates” . Select the update and click “Uninstall”.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com
Posted by Klaus Ondrich on 3/22/2013 at 1:30 PM
Go to control panel - Add and Remove Programs. In the left pane there is an option to show updates. This will group programs with their respective updates. From there you will be able to uninstall updates as well. It works. Believe me. ;-)
You may want to reinstall CU2 after uninstalling CU3.

Klaus
Posted by CarriageTB on 3/22/2013 at 1:22 PM
Alberto, I do not see an option to uninstall CU3, nor do I ever recall the option to uninstall individual SQL Service Packs and Updates from a machine. Would you be so kind as to provide some instructions, or a screenshot? Thanks!

TB
Posted by Alberto Morillo on 3/22/2013 at 5:51 AM
Hello,

Users cannot open SSIS projects and cannot create maintenance plans after installing CU3 for SQL Server 2012 SP1.

Regards,

Alberto Morillo
SQLCoffee.com
Posted by Klaus Ondrich on 3/22/2013 at 5:44 AM
I can confirm this problem and the work around posted by Alberto:

Fresh Install SSMS 2012: No problems

Update SSMS 2012 to CU3: Mentioned problem occurs

Uninstall of CU3: No problem any more

Install CU2: Still no problem

Regards,

Klaus
Sign in to post a workaround.
Posted by Peter Jenks on 4/4/2013 at 10:11 PM
Applying the hotfix failed because it couldn't find the file C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies\devenv.exe.config.tmp. We worked around it by copying the file C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe.config to that location/name. it applied successfully after that.
Posted by Alberto Morillo on 4/3/2013 at 3:51 AM
The hotfix for this issue is now available on the following support article:

http://support.microsoft.com/kb/2832017
Posted by Alberto Morillo on 3/26/2013 at 3:49 AM
Hello, Microsoft has released Hotfix 1232978 for this issue, if anyone needs to reference it with Customer Service & Support. Thank you to Guy Bowerman (MSFT). Regards, Alberto Morillo
Posted by Alberto Morillo on 3/22/2013 at 4:49 AM
Hello,

Uninstall this Cumulative Update using Control Panel. Packages and Maintenance plans will open again.

Hope this helps.


Regards,

Alberto Morillo
SQLCoffee.com