Error: data source partially online

[jhaastBI]

Hello,

Currently, one of my data sources returns the following error:

The dataset is of the type ODBC and returns the erorr "Partially Online" since this monday. Before this monday, there was no error.

The dataset returns the following error:

Can somebody tell me how we can resolve the partially refesh error?

I have alreay reinstalled the gateway and the ODBC connection.

Thank you in advance.

[jhaastBI]

Thank you for your response.

Only in one of the gateway clusters is the ODBC source defined and findable. Is that problemen? Until monday last week it was not.

[lbendlin]

yes, it is a problem. The Azure service has a built in load balancer that randomly picks the gateway cluster member it offers the mashup job (or the direct query) to.  Maybe you got lucky until now that the service always picked the cluster member that had a functioning connection.

[lbendlin]

One of your gateway cluster members is missing the ODBC definition for that data source. On all gateway cluster members go to the 64bit ODBC control panel, System DSN, and do a test of that connection.