Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Identical XML Expand / Collapse
Author
Message
Posted Monday, June 23, 2014 2:13 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 2:34 PM
Points: 1,207, Visits: 3,898
We have a live and failover Report Server and I'm currently in the process of making sure that all the reports and procs match across the two. The problem I've come across is that they do actually match exactly and I'm not sure that they should. I've been using Beyond Compare to compare them and I've discovered that in most cases, where I should have a difference there hasn't been one. Each piece of XML I've compared has had a short section and the bottom like so:

<rd:ReportServerUrl>http://MyServer</rd:ReportServerUrl>


That has been the case for all the reports that I've checked on both servers. I was expecting that the XML on one server would have the URL for that server and the XML on the other would have the corresponding URL ie

<rd:ReportServerUrl>http://MyOtherServer</rd:ReportServerUrl>


Some of the reports have what I think is the correct URL but the majority of them don't. When I investigated the reports manually everything appeared correct and both versions ran on the appropriate servers. Can anybody shed any light on this please? If you need more information just ask.



On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher

How to post a question to get the most help
Post #1584938
Posted Monday, June 23, 2014 3:23 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 2:34 PM
Points: 1,207, Visits: 3,898
This is bad form I know but can anybody help? Has anybody seen anything like this before? We're looking at a bit of investment and the answer to this question will affect whether or not the dynamite is used on the company wallet fastener.


On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher

How to post a question to get the most help
Post #1585360
Posted Monday, June 23, 2014 5:27 PM This worked for the OP Answer marked as solution


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 3:38 PM
Points: 1,805, Visits: 5,870
That property comes from ReportDesigner, and is used to identify the original source of the report.

I don't believe it is relevant for the everyday running of a report as ReportServer will not even read that property.


MM


  • MMGrid Addin
  • MMNose Addin


  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • Post #1585364
    Posted Tuesday, June 24, 2014 1:00 AM
    Ten Centuries

    Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

    Group: General Forum Members
    Last Login: Today @ 2:34 PM
    Points: 1,207, Visits: 3,898
    Thanks MM, I had a feeling the answer was going to be something like that. What is now the fail-over used to be live so we did create reports on there then copy them across.


    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help
    Post #1585399
    « Prev Topic | Next Topic »

    Add to briefcase

    Permissions Expand / Collapse