Post reply

Reports not getting most recent data

  • September 6, 2011 at 4:46 am

    #390347

    For a pet project of mine I developed a series of views, stored procedures and functions to give me statistics about my activity in the game EvE Online.

    Since last Friday an odd thing is occurring the report that has to show me the evolution of the value of a certain item class is no longer fetching the most recent data.

    So on Friday it displayed the graph with all the data up to Thursday but the Friday data was not included, when I created a new report the latest data was there, but then yesterday the same thing happened as Friday on the new report, the data up until Friday is displayed but the info for Monday is not.

    Anyone else had this problem

  • September 6, 2011 at 8:15 am

    #1377429

    Have you scheduled these reports?

  • September 13, 2011 at 5:51 am

    #1380534

    Sorry for this late response I've been buried in an urgent project.

    No I haven't scheduled the reports yet, its in the report designer in Visual Studio where it stopped collecting the most recent data unless the report is remade.

  • September 13, 2011 at 5:56 am

    #1380537

    Resender (9/13/2011)

    Sorry for this late response I've been buried in an urgent project.

    No I haven't scheduled the reports yet, its in the report designer in Visual Studio where it stopped collecting the most recent data unless the report is remade.

    You mean refresh or rebuilt from scratch?

    I've had a similar issue, but a couple refresh usually did the job (or at worse close & open bids).

  • September 13, 2011 at 6:15 am

    #1380548

    Rebuild

  • September 13, 2011 at 6:17 am

    #1380551

    Resender (9/13/2011)

    Rebuild

    No idea what's wrong!

  • September 13, 2011 at 6:22 am

    #1380554

    Closing and reopening doesn't help, I notice now that most recent data gets loaded but like 2-3 hours after that data was inserted/altered.

  • September 13, 2011 at 6:23 am

    #1380555

    Resender (9/13/2011)

    Closing and reopening doesn't help, I notice now that most recent data gets loaded but like 2-3 hours after that data was inserted/altered.

    Mirroring, log shipping, replication?

  • September 13, 2011 at 7:03 am

    #1380586

    I had a mirroring up one time to test how that worked but it's been inactive for months now and the reports always got generated from the original.

    Which was odd, so the following happened

    On Thursday I ran the SSIS package that inserted that day's historical (inventory records) at around 10 AM, I check the reports and I see the changes immediately after (so within a 1-5 min from inserting the data)

    On the Friday I ran the SSIS package at around 10AM, checked the reports immediately and they hadn't fetched the change.

    The report showed the data until and including Thursday, when creating a new report using the same datainput it showed me the data with Friday included.

    But when I hit reload on the original it still showed only to and including Thursday.

  • September 13, 2011 at 7:09 am

    #1380589

    you must have a process that is harvesting the data off of the web site, right?

    if the format of the data changed, that would throw off the import of the data, and this the rest of the report, right?

    look to see if the source of the data changed...whether the url you used, the login, maybe the page, or maybe the forat of the data itself.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • September 13, 2011 at 7:34 am

    #1380615

    I got a 3th party tool that fetches the data via my api key from the game server.

    The developer recently made some changes to the structure of the api, but the raw data I got before import is consistent with what I see in game.

    I did change from only getting inventory from 1 place to collecting inventory of multiple places in game, I made the necessary tables and views for that to make it work but that was all before

  • September 14, 2011 at 3:45 am

    #1381134

    I got 2 pictures to demonstrate the problem

    After I made this report I added new data and filled in the gaps between the dates that were still present, I made a new report using the same shared dataset

    Even 30 min after the new data was added the Quota report remains as it is while the Quota2 report has picked up the new data

  • September 14, 2011 at 5:03 am

    #1381168

    The only close experience I have with this was back in Access where the data in the report was correct but the graphics were lagging behind.

    Now I know how unlikely this is, but that's all I have.

    Maybe you could add a little textbox with MAX(date) to see (on the report) what is the latest data you have in there to see if this is your problem.

    What bugs me is that this problem was <almost> always solved by a single refresh which takes way less than 30 minutes in my world :blink:

  • September 14, 2011 at 5:19 am

    #1381179

    I did that just last date is 9/14/2011 12:00:00 AM

    I added a second dataset and chart with different names but the same data and now it fetched everything correctly now, I have to wait until tomorrow though to see the newest data.

  • September 15, 2011 at 1:59 am

    #1381746

    On the left is the result in SQL Server on the right the Graph

Viewing 15 posts - 1 through 15 (of 33 total)

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