I'm trying to create a Named Query in a Data Source View for a Analysis
Services Project in VS 2005 Team Suite Team Edition. When I try to add a
new Named Query to my Data Source View (by using the "New Named Query..."
option from the pop-up menu or the VS "Data Source View" menu) I get the
"Object reference not sent to an instance of an object" error. The happens
in my current DSV, a new DSV in my solution or a brand new DSV in a brand
new solution and project. Adding tables works fine.

How can I get this to work?



Below is my version info:


Microsoft Visual Studio 2005
Version 8.0.50727.762 (SP.050727-7600)
Microsoft .NET Framework
Version 2.0.50727 SP2

Installed Edition: Enterprise

Microsoft Visual Basic 2005 90613-246-0000007-41039
Microsoft Visual Basic 2005

Microsoft Visual C# 2005 90613-246-0000007-41039
Microsoft Visual C# 2005

Microsoft Visual C++ 2005 90613-246-0000007-41039
Microsoft Visual C++ 2005

Microsoft Visual J# 2005 90613-246-0000007-41039
Microsoft Visual J# 2005

Microsoft Visual Studio 2005 Tools for Applications
90613-246-0000007-41039
Microsoft Visual Studio 2005 Tools for Applications

Microsoft Visual Studio Tools for Office 90613-246-0000007-41039
Microsoft Visual Studio Tools for the Microsoft Office System

Microsoft Visual Web Developer 2005 90613-246-0000007-41039
Microsoft Visual Web Developer 2005

Microsoft Web Application Projects 2005 90613-246-0000007-41039
Microsoft Web Application Projects 2005
Version 8.0.50727.762

Visual Studio 2005 Team Edition for Architects 90613-246-0000007-41039
Microsoft Visual Studio 2005 Team Edition for Software Architects

Visual Studio 2005 Team Edition for DB Professionals
90613-246-0000007-41039
Microsoft Visual Studio Team Edition for Database Professionals Version
2.0.50727.354

Visual Studio 2005 Team Edition for Developers 90613-246-0000007-41039
Microsoft Visual Studio 2005 Team Edition for Software Developers

Visual Studio 2005 Team Edition for Testers 90613-246-0000007-41039
Microsoft Visual Studio 2005 Team Edition for Software Testers

Crystal Reports AAC60-G0CSA4B-V7000AY
Crystal Reports for Visual Studio 2005


Dundas OLAP Services for ASP.NET 6.2
Dundas OLAP Services for ASP.NET v6.2

Enterprise Library Configuration Editor 3.0
Microsoft patterns & practices Enterprise Library Configuration Editor

Microsoft Visual Studio 2005 Team Suite - ENU Service Pack 1 (KB926601)
This service pack is for Microsoft Visual Studio 2005 Team Suite - 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

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

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

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 Studio 2005 Team Edition for Database
Professionals - Trial - ENU (KB936612)
This Update is for Microsoft Visual Studio 2005 Team Edition for Database
Professionals - Trial - 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/936612

Application Styling Configuration Dialog
For more information about Application Styling, please see the Infragistics,
Inc., website at
http://www.infragistics.com
Copyright (c) 2007 Infragistics, Inc. All Rights Reserved.

Hi cpnet,
Welcome to Microsoft MSDN Managed Newsgroup.

This is a quick note to let you know that I am performing research on this
post and may need more time to post back to you. Thank you for your
patience.


Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =======
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Cpnet,
To help isolate this issue, please confirm with me:
Did you install Microsoft SQL Server 2005 Business Intelligence Development
Studio (BIDS) on your computer?
What is the result if you use BIDS to add a new Named Query to your data
source view?

Thank you!


Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =======
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Charles,

I get the same result when using BIDS (2005). I tried both with a brand new
project created in BIDS and also with a project previously created in VS
2005. The same thing happens with both projects.

Dear cpnet,
Thank you for your response.

Regarding this issue, I performed a test at my side, however I could not
reproduce your issue everything worked fine. Probably there might be some
corrutpion in your BIDS. I recommend that you first try resetting your BIDS
settings:
1. Open your BIDS, click Tools->Import and Export Settings...
2. Follow the wizard to choose Business Intelligence Settings and click
next to reset all the settings.
3. After that, close your BIDS and re-open it to see if it helps.

If this method does not work, I recommend that you try uninstalling SQL
Server 2005 Workstation Components from Control Panel and then re-install
it again.
To remove the workstation component, please follow the steps:
1. Open Add and remove programs and find Microsoft SQL Server 2005;
2. Click Remove, only select Worksation components and then follow the
wizard to remove it.

When you re-install the workstation components from your SQL Server 2005
setup program, please make sure that all the BIDS components in the
worstation components are selected.

Please do not hesitate to let me know if you have any further questions or
concerns.

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 2 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions. Issues of this
nature are best handled working with a dedicated Microsoft Support Engineer
by contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi cpnet,
What is this issue going on? If there is any issue, please feel free to
post back. I will do my best to help.

Thank you!

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =======
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Charles,

I've finally gotten the 'go ahead' to move to SQL Server 2008 and VS 2008.
I'm also on a tight deadline so rather than fiddle with VS/SQL/BIDS 2005
right now, I'm moving stuff over to 2008. Hopefully that will deal with my
issue. If I have time in a couple of weeks, I'll have another look at
VS/BIDS 2005.

Thanks,
cpnet

I was able to get my projects and databases moved over to VS 2008 and SQL
Server 2008. There were no issues with the move to 2008. However I'm
having the exact same issue in VS and BIDS 2008. It happens with my updated
projects and also with a new Analysis Services project created in VS 2008.
I tried a repair install of VS 2008. I also tried resetting the settings in
both VS 2008 and BIDS 2008. Nothing so far has helped. I'm in the middle
of packing for a move so I don't have easy access to my MSDN DVD's (other
than a Nov 2007 download of VS2008) . I'm downloading the SQL Server 2008
Developer edition now, and I'll try uninstalling and re-installing the
client tools. However, since this issue impacts both 2005 and 2008 VS and
BIDS (all on the same machine), I'm suspecting this won't likely help.

Is there any way to determine what object or registry entry is
missing/corrupt? Does the fact that this happens in VS and BIDS 2005 and
2008 help narrow down a possible cause?

Thanks,
cpnet

Hi cpnet,
Good morning!

If possible, I recommend that you perform a test on another computer with
only SQL Server 2008 BIDS or SQL Server 2005 BIDS installed to see if you
can use it for development purpose.

The error message you saw was a run-time error thrown out from .NET CLR, so
it is hard to determine what the object is except debugging or dump
analysis which can only be done by Microsoft Customer Support Services
(CSS). If this issue is urgent to your business, I recommend that you
contact CSS via telephone so that a dedicated Support Professional can
assist you in a more efficient manner. Please be advised that contacting
phone support will be a charged call.

To obtain the phone numbers for specific technology request please take a
look at the web site listed below.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS

If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.

Thank you!

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =======
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Charles,

I had a test (Virtual PC) machine with XP sp2 and VS 2005 and BIDS 2005 (no
2008 stuff). This machine is able to create a named query in a DSV (Data
Source View) so I created a simple named query in this Virtual PC, then cut
and pasted the relevant XML from the DSV on the Virtual PC to the XML in the
DSV on my 'broken' machine. After altering the XML content a bit to get the
query I actually wanted, I am able to use the named query on my 'broken'
machine. I can "Explore Data" for the named query, it just seems like I
can't open the actual editor for the named query. As long as I edit the XML
directly, it's fine.

FYI, when I right click on the named query to edit it, I get the "object
reference not set to instance of object" error. I press [ok] to clear the
error dialog and the named query editing dialog flashes on the screen for a
fraction of a second before disappearing. I assume the missing object must
have something to do with the editing dialog for named queries in VS/BIDS
2005/2008.

I'm going to need to keep using my 'broken' machine for now... I don't have
time to re-install it, and it seems to be working ok otherwise. So for now,
I'll just have to manually edit the XML for named queries.