Post reply

Same Query , Same Database, Different Server ....Different Result!!!

  • April 16, 2012 at 2:12 pm

    #254313

    Hi folks..

    I am working on strange issue hope some one can help me out.

    When i am running a query in production environment i get required result.

    Same query when i execute in report environment no output. ( Report server has same database as production, It get refreshed every night)

    Any idea ? Any guesses?

    Thanks

  • April 16, 2012 at 2:16 pm

    #1474387

    Not without seeing the proc, no. Way too vague a description for us to do a disconnected troubleshoot. More, not less, in this instance. Server settings, versions, execution plans, actual code... you name it, the more you give us the more of a chance we have to help.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • April 16, 2012 at 2:17 pm

    #1474388

    My guess is that data is not actually there. How do you know it got refreshed? Can you use a SELECT * and verify that the data is there?

    Jared
    CE - Microsoft

  • April 16, 2012 at 2:20 pm

    #1474392

    SQLKnowItAll (4/16/2012)

    My guess is that data is not actually there. How do you know it got refreshed? Can you use a SELECT * and verify that the data is there?

    we had an issue where we were getting a stale copy of our production database refreshed nightly. since you are not getting any results on the report server i would look at the backup and restore process. other than that with out seeing what you are running im not sure where else we can go.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

  • April 16, 2012 at 3:00 pm

    #1474420

    SQL version numbers for both instances please?

    Also, how is the data getting "refreshed"?

    Has the data changed in live since the refresh so that the query returns only on live? Get some PK's from the live environment and check they exist in the same state on the other environment.

  • April 16, 2012 at 3:22 pm

    #1474436

    Thanks folks for kind reply..

    I found out its Date time stamp issue with query...Sorry couldn't post the query here because of my companies privacy but appreciate all of your's help.

    Thanks Again

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply