none
BUG? Shared Datasource Connection String Gets Wiped Out

    Question

  • Any time I make a change to the report's main query or any of the datasource properties (not shared), another shared datasource's connection string gets wiped out. I have to go into the datasource's connection string, edit, and "OK" back out to recommitt what is already there. Has anybody else experienced this? Pain in the butt.

    John


    "A bus station is where a bus stops. A train station is where a train stops. On my desk I have a workstation..."
    Friday, April 23, 2010 3:53 PM

Answers

All replies

  • That is not normal. Are you up-to-date with service packs?


    Kalman Toth, SQL Server & Business Intelligence Training; BI TRIO 2008
    Friday, April 23, 2010 5:59 PM
  • Can you please provide example step by step.

    Also Whenever we create a Shared Datasource , we should save it and save solution / project.

    Also , if you change the Connection string of Shared datasource in a RDl dataset , it will actually change the Shared Datasource Connection String. 


    ~~ Mark it as Answer if you find it correct~~
    Friday, April 23, 2010 9:06 PM
  • Hello Kalman,

    As far as I know, yes, but I'm not the admin, so I don't really know. Here's where we are.

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

    Installed Edition: Professional

    Microsoft Visual Basic 2008   91605-270-9071542-60753
    Microsoft Visual Basic 2008

    Microsoft Visual C# 2008   91605-270-9071542-60753
    Microsoft Visual C# 2008

    Microsoft Visual C++ 2008   91605-270-9071542-60753
    Microsoft Visual C++ 2008

    Microsoft Visual Studio 2008 Tools for Office   91605-270-9071542-60753
    Microsoft Visual Studio 2008 Tools for Office

    Microsoft Visual Studio Tools for Applications 2.0   91605-270-9071542-60753
    Microsoft Visual Studio Tools for Applications 2.0

    Microsoft Visual Web Developer 2008   91605-270-9071542-60753
    Microsoft Visual Web Developer 2008

    Crystal Reports    AAJ60-G0MSA4K-68000CF
    Crystal Reports Basic for Visual Studio 2008


    Dynamics AX 2009 Reporting Tools   5.0.593.0
    Dynamics AX 2009 Reporting Tools

    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 (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 (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 (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 (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 (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.

    Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB945282)   KB945282
    This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - 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 Shell (integrated mode) - ENU (KB946040)   KB946040
    This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - 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 Shell (integrated mode) - ENU (KB946308)   KB946308
    This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - 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 Shell (integrated mode) - ENU (KB946344)   KB946344
    This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - 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 Shell (integrated mode) - ENU (KB946581)   KB946581
    This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - 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 Shell (integrated mode) - ENU (KB947173)   KB947173
    This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - 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 Shell (integrated mode) - ENU (KB947540)   KB947540
    This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - 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 Shell (integrated mode) - ENU (KB947789)   KB947789
    This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - 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.

    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.

    Microsoft Visual Studio 2008 Professional Edition - ENU Service Pack 1 (KB947888)   KB947888
    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/947888.

    Security Update for Microsoft Visual Studio 2008 Professional Edition - ENU (KB973675)   KB973675
    This security update is for Microsoft Visual Studio 2008 Professional Edition - 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/973675.

    Security Update for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB972222)   KB972222
    This security update is for Microsoft Visual Studio 2008 Shell (integrated mode) - 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/972222.

    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

    Update for Microsoft Visual Studio 2008 Professional Edition - ENU (KB956453)   KB956453
    This update is for Microsoft Visual Studio 2008 Professional 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/956453.

    Update for Microsoft Visual Studio 2008 Professional Edition - ENU (KB967143)   KB967143
    This update is for Microsoft Visual Studio 2008 Professional 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/967143.

    Visual Studio Comparison Tools
    For more information about , see the  website at
    http://www.codeplex.com/ComparisonTools
    License:  GNU General Public License (GPL) v2


    "A bus station is where a bus stops. A train station is where a train stops. On my desk I have a workstation..."
    Monday, April 26, 2010 1:47 PM
  • Hello Sandeep,

    Thanks for your post. It seems to be a little intermittent, but I can usually do this to reproduce the problem:

    I open my VS2008, which opens my last opened solution, a solution I have that houses all of our OLAP reporting. The main datasource and accompanying shared datasource in the report I currently have under development are fine. I can run the report and it runs just fine.

    I can go into the main reporting dataset query (not the shared datasource, this one is embedded) and if I just add a new criteria to the filter on the dataset properties and then save my changes and then run the report, I'll get this.

    [rsInvalidReportDefinition] The report definition is not valid. Details: The report definition element 'ConnectionProperties' is empty at line 13, position 9. It is missing a mandatory child element of type 'DataProvider'.
    Build complete -- 1 errors, 0 warnings

    I'll then have to open my shared datasource and then "Edit" my datasource reference. Then I have to "Edit" my Connection String. I don't actually have to change anything though. I just hit the "Edit..." button on the Data Source Properties dialog box under "Use shared data source reference), then hit the "Edit..." button on the Shared Data Source Properties dialog box under "Connection string" (which, incidently, DOES display the correct connection string). Then, on the Connection Properties dialog box, I just hit "OK", then "OK" again, then "OK" again. Now, I'm back at my report design pane. If I hit "Preview" now, everything renders just fine.

    It's this kind of quirky, inexplicable behavior that has been driving me nuts for the past few months. I'm still pretty new to all this technology, which makes it that much worse. I'd gladly trade this IDE in for my trusty COBOL compiler at this point.

    Thanks, John.


    "A bus station is where a bus stops. A train station is where a train stops. On my desk I have a workstation..."
    Monday, April 26, 2010 2:01 PM
  • Another related quirk. I just went back into the main query property box to delete the filter I added for the example above, expecting the same behavior when I rendered the report. But, when I deleted the filter, saved the report design, and then tried to preview it again, it ran fine. I didn't have to update the connection string. So, it might be just when I add the filter? Don't know...

     


    "A bus station is where a bus stops. A train station is where a train stops. On my desk I have a workstation..."
    Monday, April 26, 2010 2:04 PM
  • So, I went back into the main datasource properties again, added a new filter, saved and tried to preview the report and it runs just fine. That's what I mean about it being intermittent. Sometimes it will work, other times it won't. I can't nail down when or why, it's just random.

    o_O!


    "A bus station is where a bus stops. A train station is where a train stops. On my desk I have a workstation..."
    Monday, April 26, 2010 2:07 PM
  • Nobody in Microsoft land care to field this one? It's totally annoying. I just went into a report and highlighted a single row, added a border, and tried to preview the change. I got the same error. I had to go into my Data Source Properties dialog box and I found that I can just hit "OK" from there to set things right again. I don't have to go all the way to the connection string edit.

    I then reverted the change and changed a different row's border and hit preview expecting it to error out again. This time it did not. Sometimes it errors... sometimes it doesn't... I can't make any sense of it. I'm beginning to lose faith in this tool set.

    Miffed.

    >=o(


    "A bus station is where a bus stops. A train station is where a train stops. On my desk I have a workstation..."
    Thursday, April 29, 2010 6:08 PM
  • You can report the issue at Connect: https://connect.microsoft.com/SQLServer?wa=wsignin1.0

    If you do, can you post the link? Thanks.


    Kalman Toth, SQL Server & Business Intelligence Training; SQLUSA.com
    Thursday, April 29, 2010 6:20 PM
  • Not sure what this is going to buy me; aren't all these forums tied together?

    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/ac1e93ee-970b-4969-84cf-79d5a9fa96ea


    "A bus station is where a bus stops. A train station is where a train stops. On my desk I have a workstation..."
    Friday, April 30, 2010 3:04 PM
  • Not sure what this is going to buy me; aren't all these forums tied together?

    Well, SQL Server topics yes. Nonetheless, searching for a thread can be a real challange. The biggest reason is some poor thread titles.


    Kalman Toth, SQL Server & Business Intelligence Training; SQLUSA.com
    Friday, April 30, 2010 3:43 PM
  • This is now a redundant thread. Please refer to:

    http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/ac1e93ee-970b-4969-84cf-79d5a9fa96ea


    "A bus station is where a bus stops. A train station is where a train stops. On my desk I have a workstation..."
    • Marked as answer by jrmunn Wednesday, May 05, 2010 4:52 PM
    Wednesday, May 05, 2010 4:52 PM