Forum Discussion

tmcdevitt's avatar
tmcdevitt
Advocate II
7 years ago

Direct Query connectivity issues with Redshift in the last few days; Production reports won't load

We've got a few Direct Query reports pointing at a Redshift cluster. This has worked great the last few weeks but over the last two or three days, we're getting schema load errors when attempting to ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago
I agree. We are not working on some toy projects here, but serious business applications. The issue is not resolved for us at the moment. There was a brief interval during which it has been working, but not anymore.
kevhav's avatar
kevhav
Continued Contributor
7 years ago

This appears to be fixed for us, since ~11:00 p.m. last night (Pacific). We've had 9 consecutive successful (hourly) refreshes since then.

 

Our dataset is in Premium capacity and its data source is Redshift. But our situation might be a bit different, in that our dataset is in Import mode, not Direct Query.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    This seems to be fixed for us, too. However no one from Microsoft ever told us that it was fixed or told us to try again. Thanks to others here reporting success, I manually refreshed datasets and we re-embedded our Direct Query report and it is working as of right now. I hope others have success, too.

    • tmcdevitt's avatar
      tmcdevitt
      Advocate II
      7 years ago

      We ran into this issue again about an hour ago. Appears to be working now but we're skeptical that this is really fixed.

      Can we please get some sort of response from ms on this? If it's still in progress, let us know and we can at least set expectations with our users.

      • kevhav's avatar
        kevhav
        Continued Contributor
        7 years ago

        Yeah, it actually just started happening for us, again, a few hours ago.