Hello, I'm trying to configure a MySql/MariaDB multischema datasource using a user profile attribute on Knowage. The test is ok.
Tomcat configuration server.xml :
Tomcat configuration context
webapps/knowage/META-INF/context.xml
webapps/knowagegeoreportengine/META-INF/context.xml
webapps/knowagebirtreportengine/META-INF/context.xml
webapps/knowagecommonjengine/META-INF/context.xml
webapps/knowagedataminingengine/META-INF/context.xml
webapps/knowagetalendengine/META-INF/context.xml
webapps/knowageqbeengine/META-INF/context.xml
webapps/knowagecockpitengine/META-INF/context.xml
webapps/knowagewhatifengine/META-INF/context.xml
webapps/knowagekpiengine/META-INF/context.xml
webapps/knowagejasperreportengine/META-INF/context.xml
webapps/knowagemeta/META-INF/context.xml
webapps/knowagesvgviewerengine/META-INF/context.xml :
I am logged in with a user who has a connectionName profile attribute with the same value as the Tomcat resource name.
Then I create a Business Model using this datasource with Meta Web. The physical model is available, I have the right SQL tables.
Then I generate the model and delete Shema Name and Catalog Name :
But when I want to create a dataset using this datasource and Business Model, I get an error when retrieving the user profile. I can't open the dataset.
and knowageQbeEngine module log :
it.eng.spagobi.utilities.engines.SpagoBIEngineServiceException: An unpredicted error occurred while executing GET_TREE_ACTION service.
The root cause of the error is: Datasource is multischema, but User profile object is not provided
at it.eng.spagobi.utilities.engines.SpagoBIEngineServiceExceptionHandler.getWrappedException(SpagoBIEngineServiceExceptionHandler.java:89)
...
Caused by: java.lang.RuntimeException: Impossible to build model structure
at it.eng.qbe.model.structure.builder.jpa.JPAModelStructureBuilder.build(JPAModelStructureBuilder.java:128)
...
Caused by: it.eng.spagobi.utilities.assertion.NullReferenceException: Datasource is multischema, but User profile object is not provided
at it.eng.spagobi.utilities.assertion.Assert.assertNotNull(Assert.java:39)
at it.eng.spagobi.tools.datasource.bo.DataSource.getJNDIRunTime(DataSource.java:229)
...
I used this documentation for Tomcat : https://knowage-suite.readthedocs.io/en/7.2/installation-guide/manual-installation.html
I used this documentation for datasource :https://knowage-suite.readthedocs.io/en/7.2/administrator-guide/configure-data-sources.html
I can't find a solution, maybe I forgot to set parameters ? If someone has a solution it would be great.
