On premise gateway only visible on some models

Anonymous · ‎10-26-2017

My IT team updated the on premise gateway a few weeks back. The day after 2 of my models could no longer see the gateway. All of my other models had no issues with this upgrade and the gateway is still visible.

On the 2 that are not visible my models were working fine and still refreshing, until yesterday.

Any clues to what may have caused this and how to mix it.

shill1000 · ‎10-26-2017

Your description is a little inconsistent. Do you mean the 2 models cannot access the gateway/data source or are they simply not refreshing? Do they use different data sources to the other models or are they all using the same source data? Could it be a credentials issue?

Anonymous · ‎10-26-2017

Sorry, thought I wasn't entirely clear in my first explaination.

The two fault data models use different SQL views to the working models, however all are through the identical gateway. Same data source (all same database), however different tables from that database.

Would be surprised if it is credentials based on what is in the models.

They all were historically refreshing, until two of them completely failed a few days ago. The part I find strange is that since the day the gateway was updated, the two faulty models had no option to select a gateway as they couldn't see any, however the others could.

I have experienced same behaviour of not seeing a gateway when i pull in excel files that were outside of a location on the shared drives that the credentials of the gateway did not allow, when put in the correct location they worked. Did any of the permissions alter for gateways between Jan 2017 (previous gateway prior to update) and the latest gateway update?

shill1000 · ‎10-27-2017

I assume you can use the same connections for new models? If so, you may be faced with recreating the failing queries.

Only other thign I could suggest is revisiting teh failing queries and step through the processing via the query editor. IF there's something wrong in the query that might show it up.

Anonymous · ‎10-27-2017

@shill1000 Thanks for your help with this. I think you are right, the step method is going to be the way to go. Will post the solution/error if I work it out the fault.