Error occurred on loading federation models

Question

I have a problem with the Data models view in "My Workspace" where the federations can be created.

When I open this page I get an error message notification "Error occurred on loading federation models". However I only see one error being reported in the knowage log files. I also have done some verification in the source files but no results (probably somewhere a setting?).

Message in the logfile:

'2017-12-22-09-54 17';'0:0:0:0:0:0:0:1';'0:0:0:0:0:0:0:1';'0:0:0:0:0:0:0:1';'';'';'';'biadmin';'admin,';'[Service:/federateddataset/ ; Class:class it.eng.spagobi.tools.dataset.service.federated.RestFederationDefinition ; Method:public java.util.List it.eng.spagobi.tools.dataset.service.federated.RestFederationDefinition.get()]';'biadmin';'/knowage/restful-services/federateddataset/';'';'ERR (400)';'-1';'CHROME';'63.0.3239.84';'WINDOWS_7';1c4faee11d47f7f4016798d84e1b2c49

When entering URL http://localhost:8080/knowage/restful-services/federateddataset/ i see following message:

{"errors":[{"message":"not-enabled-to-call-service"}]}

Any suggestions on solving this issue?

Thanks in advance

Answer 1

Dear,
it's an already known bug, we've just fixed and we'll release on the next version.
As workaround, try to add the "Federated Dataset" authorization to the role.

Best regards
Angelo

Comments

After enabling this option and restarting knowage this issue was solved.

Thanks for the help Angelo!

---

Angelo,

I have an additional issue with the federations I have created. They are not able to be loaded in the cockpits.

What do I need to do to solve this issue?

Unable to load data from dataset <name>
Please check dataset & widget config

Thanks in advance.

---

Dear,

check the log file to find out more information

Best regards

Angelo

---

Found the issue, it was related to persistence on tables where 2 columns which are linked had different types on them.

---

Dear Kristof,

Did you solve the problems ?

Best Regards

A.

---

Yes the problem was related to a type mismatch on 2 columns which needed to be linked.