topic Re: Error Query Builder "No services available" in SAS Visual Analytics

Error Query Builder "No services available"

rodrigo_pereira — Fri, 22 Sep 2017 12:39:56 GMT

Hello experts,

I'm getting an error with Query Builder when trying to run a query. Bellow I send you the screenshot with the message.

Do you know how to resolve?

Thank you in advance,

Rodrigo

Re: Error Query Builder "No services available"

Madelyn_SAS — Fri, 22 Sep 2017 13:22:42 GMT

I would suggest that you restart your servers. This topic explains the correct order for a restart:

http://support.sas.com/documentation/cdl/en/bisag/68240/HTML/default/viewer.htm#p0d9d5nzmd8i4yn1usv2l22vpa7t.htm

Re: Error Query Builder "No services available"

rodrigo_pereira — Fri, 22 Sep 2017 15:02:19 GMT

Hello Madelyn,

We did the restart but now he have another problem.

All the LASR tables are "Unloaded" and the reload isn't working.

This should be automatic, right?

Thank you,

Rodrigo

Re: Error Query Builder "No services available"

Madelyn_SAS — Fri, 22 Sep 2017 15:28:13 GMT

The reloading depends on several different factors.

http://support.sas.com/documentation/cdl/en/vaag/69958/HTML/default/viewer.htm#p0ehlxuj60aw6qn161pr8rq5f85w.htm

Re: Error Query Builder "No services available"

rodrigo_pereira — Fri, 22 Sep 2017 16:09:26 GMT

Hi Madelyn,

In fact it was an authorization issue in some tables problem because the option "load on start" was activated.

We were able to solve to the tables that were loaded automatically.

However we still have the problem for the tables generated by the "Query Builder". We always need to run the query again or this can be done automatically (in VA 7.1).

Thank you,

Rodrigo

Re: Error Query Builder "No services available"

rodrigo_pereira — Wed, 27 Sep 2017 16:11:13 GMT

Hi again Madelyn,

the original problem is ocurring again (from my screenshot).

The same message appears and we are unable to execute Data Query - the explorations seem to work fine.

Do you know why this could be happening?

We did a restart today (and VA worked fine after the restart) and we didn't have any interventation that can justify this abnormal behaviour.

Thank you in advance,

Rodrigo