Visual Studio 2005 (2008 installed too) + Visual Source Safe 2005, on Windows 7 64 bit - Trying to Save a checked out Reporting Services .RDL, gives error 'Operation could not complete'

Question

When I try to save the .rdl in VS2005, the title bar of Visual Studio changes to 'Not responding', there's a lonnnnnggggg pause... and then it says 'Operation could not complete' and a dialog popup appears showing me the checked out folder and allowing me to click Save or Cancel. If I click Save again, the same happens again, with a gap between 5 seconds and 30 seconds, and normally errors out again. However, after (on average) about 6-9 save attempts, it will then succeed, after a pause of upto 2 minutes. As you can imagine, it takes an eternity to get any work done.

I'm expecting this is a DLL issue. Could be because I've got both VS2005 and VS2008 on the same machine.. or possible VS Source Safe 2005 doesn't like Windows 7??

Everything is service packed up (Source Safe even has that patch to improve compatability with VS2008)

There is 1 article in the forum referring to VS2003, Visual Source Safe, and the 'Operation could not complete', but it's dated around 2005 and refers to MDAC dll's, so I'm reluctant to follow the advice as I doubt it applies to Windows 7.. Any ideas please??

Answer 1

Hello,

Is this problem only happen on .rdl files or else? do you know when this happen? have you installed the VS2005 SP1 for Vista?
I only know SQL2005 is not compatible with Win7, not sure if VS2005 has problem with it.

Sincerely,
Wesley

---

Please mark the replies as answers if they help and unmark them if they provide no help. Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 2

Hi there,


"Is this problem only happen on .rdl files or else?"

As far as I know, only on .rdl's, but possibly on any VS project.

"do you know when this happen?"

Well, only with .RDL so far.

"have you installed the VS2005 SP1 for Vista?"

Yes.

"I only know SQL2005 is not compatible with Win7, not sure if VS2005 has problem with it."

Hmm, not heard of SQL2005 not being compatible - do you mean the tools or the server? I have the SQL 2005 and SQL 2008 tools installed on this machine too. I have noticed that when using SQL2008 Management Studio to administer our SQL servers, if I right click a View and try to 'Edit the top 200 rows', it does the same 'Not responding' thing for 20 or so seconds, before opening up the correct window. This also leads me to believe something isn't right when installing both SQL 2005/2008 Management Studio or/and VS2005/VS2008 on the same machine - but I am led to believe this should not be an issue.

Answer 3

In VS2005 About page:


Microsoft Visual Studio 2005
Version 8.0.50727.867  (vsvista.050727-8600)
Microsoft .NET Framework
Version 2.0.50727 SP2

Installed Edition: IDE Standard

Microsoft Visual Studio 2005 Tools for Applications   xxxxx-xxx-xxxxxxx-xxxxx
Microsoft Visual Studio 2005 Tools for Applications

Microsoft Visual Studio 2005 Premier Partner Edition - ENU Service Pack 1 (KB926601)  
This service pack is for Microsoft Visual Studio 2005 Premier Partner Edition - ENU.
If you later install a more recent service pack, this service pack will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/926601

SQL Server Analysis Services  
Microsoft SQL Server Analysis Services Designer
Version 9.00.4035.00

SQL Server Integration Services  
Microsoft SQL Server Integration Services Designer
Version 9.00.4035.00

SQL Server Reporting Services  
Microsoft SQL Server Reporting Services Designers
Version 9.00.4035.00

Update for Microsoft Visual SourceSafe 2005 - ENU (KB943847)  
This Update is for Microsoft Visual SourceSafe 2005 - ENU.
If you later install a more recent service pack, this Update will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/943847

Update for Microsoft Visual Studio 2005 Premier Partner Edition - ENU (KB932232)  
This Update is for Microsoft Visual Studio 2005 Premier Partner Edition - ENU.
If you later install a more recent service pack, this Update will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/932232

VMDebugger
For more information about VMware Inc, see their website at
http://www.vmware.com
Copyright (c) 2008 VMware, Inc.



In VS2008 About page:


Microsoft Visual Studio 2008
Version 9.0.30729.1 SP
Microsoft .NET Framework
Version 3.5 SP1

Installed Edition: Professional

Microsoft Visual Basic 2008   xxxxx-xxx-xxxxxxx-xxxxx
Microsoft Visual Basic 2008

Microsoft Visual C# 2008   xxxxx-xxx-xxxxxxx-xxxxx
Microsoft Visual C# 2008

Microsoft Visual Studio 2008 Tools for Office   xxxxx-xxx-xxxxxxx-xxxxx
Microsoft Visual Studio 2008 Tools for Office

Microsoft Visual Web Developer 2008   xxxxx-xxx-xxxxxxx-xxxxx
Microsoft Visual Web Developer 2008

Crystal Reports    xxxxx-xxx-xxxxxxx-xxxxx
Crystal Reports Basic for Visual Studio 2008

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB944899)   KB944899
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/944899.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB945282)   KB945282
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/945282.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946040)   KB946040
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/946040.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946308)   KB946308
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/946308.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946344)   KB946344
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/946344.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946581)   KB946581
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/946581.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947171)   KB947171
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947171.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947173)   KB947173
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947173.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947180)   KB947180
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947180.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947540)   KB947540
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947540.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947789)   KB947789
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947789.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB948127)   KB948127
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/948127.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB952241)   KB952241
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/952241.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB953256)   KB953256
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/953256.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB971091)   KB971091
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/971091.

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB971092)   KB971092
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/971092.

Microsoft Visual Studio 2008 Professional Edition - ENU Service Pack 1 (KB945140)   KB945140
This service pack is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this service pack will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/945140.

SQL Server Analysis Services  
Microsoft SQL Server Analysis Services Designer
Version 10.0.2531.0

SQL Server Integration Services  
Microsoft SQL Server Integration Services Designer
Version 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )

SQL Server Reporting Services  
Microsoft SQL Server Reporting Services Designers
Version 10.0.2531.0

VMDebugger
For more information about VMware Inc, see their website at
http://www.vmware.com
Copyright (c) 2008 VMware, Inc.




Visual SourceSafe About page:

Microsoft Visual SourceSafe Explorer - 32-bit
Visual SourceSafe Version 8.0.50727.1551

Answer 4

By the way, I'm using VS2005, because it's a SQL2005 server that's running Reporting Services.

Answer 5

"do you mean the tools or the server?"

It's the server.

Have you installed SQL Server 2005 SP3 or SQL Server 2008 SP1? Microsoft SQL Server Release Services
Because it's hard to reproduce in a while, I can only give you some suggestion currently.  I will contact with other members in our group to see if they have experience about it.

Sorry for that.

Wesley

---

Please mark the replies as answers if they help and unmark them if they provide no help. Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 6

Hi,

I believe the answer is yes to both, but looking at the About pages in each Management Studio it's hard to immediately tell. Your link 404'd for me by the way.
Thanks for planning to look in to it - it takes about 2 whole days to prep this pc, so I'm reluctant to nuke and start again, methodically testing this as I install at each stage.. a solution will be very helpful.

SQL Server 2005 tools/services:

Microsoft SQL Server Management Studio         9.00.4035.00
Microsoft Analysis Services Client Tools            2005.090.4035.00
Microsoft Data Access Components (MDAC)      6.1.7600.16385 (win7_rtm.090713-1255)
Microsoft MSXML                                             3.0 4.0 5.0 6.0
Microsoft Internet Explorer                              8.0.7600.16385
Microsoft .NET Framework                               2.0.50727.4927
Operating System                                          6.1.7600

SQL Server 2008 tools/services:

Microsoft SQL Server Management Studio        10.0.2531.0
Microsoft Analysis Services Client Tools           10.0.1600.22
Microsoft Data Access Components (MDAC)     6.1.7600.16385
Microsoft MSXML                                            3.0 4.0 5.0 6.0
Microsoft Internet Explorer                             8.0.7600.16385
Microsoft .NET Framework                              2.0.50727.4927
Operating System                                         6.1.7600

Answer 7

BTW, the checked out .RDL's exist on a network share which I have full admin rights to, so they are not local. Since they are checked out already and thus not read-only, I'd surprised there is any issue trying to save them. I can't see how Visual SourceSafe can be involved really, so it looks like a simple issue where VSC2005 can't save to a network share.

AHA! I just proved it - I saved to my C: and there was zero delay. So, it's upset at using a network share. Any ideas? I've got a feeling this is related to Windows 7.

Answer 8

In case it helps, the path I am trying to save the checked out .rdl back to is:

"P:\SBO\ssrs\SBO Reports\SBO Reports"

Now that I think about it, I do recall Visual SourceSafe being upset with us hosting the SourceSafe database on a network share - this only started after we moved to Windows 7. I remember my colleague got some weird errors, but I think my issues resolved after I installed that last SourceSafe SP and patch for VS 2008 - I might be wrong though, and the initial issue might still be there. Ring any bells?

Answer 9

I tried saving the file to a different drive letter, and it saved immediately. I believe the issue is that VS2005 Reporting Services doesn't have success when trying to overwrite the old file of the same name in the checked out path I mentioned, having about a 10% success rate.

BTW, you have to wait at least 20 seconds before trying to Save again, otherwise it comes up with the error immediately.

Answer 10

BTW, you have to wait at least 20 seconds before trying to Save again, otherwise it comes up with the error immediately.

Answer 11

Correction to above for clarity (forum won't let me edit post):

"I tried saving the file to a different network drive letter, and it saved immediately."

Answer 12

Further breakthrough! In the Save dialog, I deleted the old file, before clicking Save. As I hoped, after a 2 second delay, it Saved!! Woohoo!

I then took this a stage further:

Tried to overwrite the file I had previously saved on my C: drive = Success.
Tried to overwrite the file I had previously saved on another network mapped drive = Success.
Tried to overwrite the file in a checked out project folder = FAIL.
Tried to delete the file above, before Saving again = 10 second delay, and then Success!

Workaround: Delete the file beforehand, and then Success (2 out of 2 attempts).

Answer 13

Hi,

The problem has miraculously disappeared - I believe the culprit was Kaspersky Antivirus Technical Preview for Windows 7. Saves are now instant. That explanation does seem the likely cause.