Unable to use the query builder in the webapp - data is not loading

[VMFnet]

What version were you using?

Open Source, v7.0.0, release ll-20210301-594ef496d8a9411340404301a55cf95de0079a6d

What steps can we follow to reproduce the behaviour?

• Log in to the web interface
• Choose an Organisation
• Go to Data -> Source in the main left menu
• Try to explore the statements by building a query

What is the actual behaviour?

the fields don't display a list of stored data from the database, like so :
https://ibb.co/k5jS7yw

What is the expected behavior?

The queryfieds should load an actual list of the data, like this (example taken from version 6.03) :
https://ibb.co/R0hrR8H

Is there any additional information that will help us replicate/understand the problem?

The server is located at a private domain and runs CentOS 7.
SELinux is enabled and configured.
we've followed the LearningLocker installation guide.
mongo is installed and configured following the guide at https://docs.mongodb.com/manual/installation/

[PhilippJKoch]

Same problem here.
I've checked multiple instances and can add that the query builder is working on Learning Locker v.7.0.0 release
ll-20200826-bec94daa7bd602a4752ca570db03b13e9c02d037
but not
ll-20210303-594ef496d8a9411340404301a55cf95de0079a6d

The Server response from the older release is

while the response from the newer release does not contain any information for the GUI to display

[PhilippJKoch]

Update:
It seems to be not just the query-builder.

The axes-selection for visualizations also does not display any extensions:

My guess would be that all types of filter use the same functions and the problem lies somewhere within those.
But it might also be a seperate or even local issue, so if anyone could confirm the behaviour itself (no extensions selectable for visualisations in LL release 594ef49), it would already be much appreciated.

[mzilak]

The same problem here (Learning Locker v2, open source):

• list of possible suggestions in query fields does not show up
• when creating a visualization, charts are visible but cannot be filtered because there are no suggestions in the query fields.

The only thing that I was able to filter was the Who field after adding a specific person from the statements in the People section of LL.

[PhilippJKoch]

WE SOLVED IT!
For whatever reason the workers responsible for creating filters/personas/etc. are simply not running.
But they can be restarted by following the documentation (https://docs.learninglocker.net/guides-cli/ to be precise) and running

node cli/dist/server batchJobs
or
node cli/dist/server batchJobs -j personas
etc.

That should get everything working again.

[VMFnet]

Good news @PhilippJKoch !

Just a question, does this batchJobs command need to be run just once (e.g. after the server is restarted), or does it need to be run regularly via a cronjob (e.g. after new statements have been inserted) ?

[PhilippJKoch]

So far, we had to run it once for every worker we needed to reactivate (e.g. once for "querybuildercache" and once for "personas"), but they seem to be running since.
Cant't be 100% sure though, because we don't know exactly if any "new" verbs (for example) were introduced since we manually set off the qerybuildercache worker. Will keep an eye on it.