Create a dataset with nearby datetimes as category and random values as measure.

Datetimes must have same date and increasing times by 10-seconds steps (e.g. '2018-02-08 10:27:10', '2018-02-08 10:27:20', '2018-02-08 10:27:30').

Create a line chart within a chart widget based on that dataset, setting datetimes on X axis and random values on Y axis.

Check that chart is displayed as expected.

Then in chart wizard enter "date time and grouping" settings, check "Enable datetime" and set date format equals to "Monday, Jan 1, 00:00:00".

Chart is not properly displayed anymore, because now all X coordinates are the same, making a straight vertical line.

when I try to create a cockpit in a client browser thru accessing to a remote knowage server.
the function dialog can not be shown, a blank UI left.

I try to debug client Javascript thru browser debug console, finding the error info as follows:
" Failed to load resource: can not connect server。 http://localhost:8080/knowage/js/lib/angular/angular_1.4/angular.min.js"

Using OLAP, the DimensionUsage uses the source (which appears to be equal to the dimension name) rather than the name of te DimensionUsage (see "Nr17-DateOnOlapMondrian.txt")

Result is that all fields can have the same name, since the originate from different dimensions and are all named "Datum" (in the case of the example "Nr17-DateOnOlap.png" in the attachment).

Solution : the screen should use the field "name" from DimensionUsage.

On trying to save customized view application is returning error .

If I disable cache than I select (one or more) values in a cockpit, the database returns this error:

jdbc.SQLServerException: An expression of non-boolean type specified in a context where a condition is expected, near ','

.

The error is due to MSSQL not accepting IN statements in WHERE clause.
This is the query I got from the losgs when doing a selection.

select "ATC_1" AS "ATC_1", SUM("Importo_Scarto") AS "Importo_Scarto", SUM("Q_Scarto") AS "Q_Scarto" 
from (SELECT [ATC_1] ,[MESE] ,[ANNO] ,[Q_Scarto] ,[Importo_Scarto] FROM [dbo].[MyTable]) T 
where (("ANNO","MESE") IN ('2017','10'),('2018','03') 
and ("Invio") IN ('3') ) 
group by "ATC_1"

By now, a workaroung is to work with cache enabled, so this syntax is handled by MySQL and not by SQL-Server

I tryed installing new version (ubuntu-server x86_64 18.04 LTS, java 1.8, mysql 5.7), but situation worsen: now the cockpit interface doesn't even start. (I installed)
But I can see that datasets beeing audited.

ADD: I get this error (and some other of same kind) in JS console:

angular.js:1 Failed to load resource: net::ERR_CONNECTION_REFUSED

this is the URL it looks for: http://localhost:8080/knowage/js/lib/angular/angular_1.4/angular.js

(it looks like it have localhost:8080 hardcoded somewhere) as I'm not running it on localhost but natted behind another port

If you need further information, just ask.

Test-issue2

See the screenshot attached. The problem is on both PC and Linux installation, and persistent. No problem when access with localhost http://www.localhost:8080/knowage (PC installation)

The guide states the MySQL version should be: MySQL Server 5.5 or above already installed.
https://www.knowage-suite.com/site/wp-content/uploads/2018/03/Knowage-CE-Installer-Getting-started_6_1_1.pdf

But it does not work with MySQL8

In the sbi_config table you can configure date formats. Per language there are 2.

In Holland, and I think more countries, it is use to use the format:

date: dd-MM-yyyy

extjs date: d-m-Y

Unfortunately the datepicker returns only the day and not the month and year.

As a demo_admin: all is fine, no problem

As a demo_user I can not access PM -> KPI-Cards
I can not access PM -> KPI-Cards
I get the following error message:
HTTP Status 500
root cause:
The root cause of the error is: JSONObject["chart"] not found.
rg.apache.jasper.JasperException: An exception occurred processing JSP page /WEB-INF/jsp/kpiVisualization.jsp at line 57
54: <%
55:
56: JSONObject templateObj = engineInstance.getTemplate();
57: JSONObject chartObj = templateObj.getJSONObject("chart");
58: //JSONObject optionsObj = chartObj.getJSONObject("options");
59: String type = (String)chartObj.get("type");
60: // String model = (String)chartObj.get("model");
Console: xxxxx
Environment:
Oracle JVM1.8.0.x
Windows 10

Seems like than the Foodmart example is only available for MySQL/ MariaDB.

Would it be possible to port it to Postgres & oracle ?

By the way, the foodmart.sql script is available inside the Knowage_CE installer, but not here on Github.

Describe the bug
In user management attempting to delete a user via the GUI appears to work but when you restart the server the users are recreated.

To Reproduce
Steps to reproduce the behavior:

1. Delete "bitest" user from GUI
2. Restart tomcat
3. View user accounts in GUI
4. "bitest" user is back

Expected behavior
User should be permanently deleted.

As a demo_admin: all is fine, no problem
I can't access PA -> WHAT-IF
I get the following error message:
"Impossible to get template's content
Description: Impossible to get template's content: There are no template associated to document [2477]
How to fix it:
Check the document's template"

Environment:
Oracle JVM1.8.0.x
Windows 10

Describe the bug
The downloadable PG_create_6.2.sql script is not well recognized by psql -f, so the first CREATE statement is dropped with a syntax error.

To Reproduce
Steps to reproduce the behavior:

1. create the knowage user and the knowage_ce database with the knowage user as the owner

su postgres
createuser --no-createdb --no-createrole --no-superuser --pwprompt knowage
createdb -O knowage knowage_ce
exit

2. Download and unzip the PG_create_6.2.sql script

wget https://release.ow2.org/knowage/postgres-dbscripts-6_2_0-20180719.zip
unzip postgres-dbscripts-6_2_0-20180719.zip
cd postgres
psql -h localhost -U knowage -d knowage_ce -a -q -f ./PG_create.sql

3. See error
   psql the give the following error:

psql:PG_create.sql:5: ERROR:  syntax error at or near "CREATE"
LINE 1: CREATE TABLE hibernate_sequences (
        ^

The following tables and constrains are correctly created in the default public schema.

Expected behavior
The hibernate_sequences table is correctly created.

Workaround
Seem like the problem is because the first line of the .sql script is either not a comment nor an empty line.
So at the begin of the file replace:

CREATE TABLE hibernate_sequences (
  sequence_name VARCHAR(200) NOT NULL,
  next_val INTEGER NOT NULL,
  PRIMARY KEY (sequence_name)
)WITHOUT OIDS;

by

-- PG_create script for Knowage 6.2

CREATE TABLE hibernate_sequences (
  sequence_name VARCHAR(200) NOT NULL,
  next_val INTEGER NOT NULL,
  PRIMARY KEY (sequence_name)
) WITHOUT OIDS;

A descriptive comment and a new line before CREATE where added.

(This is probably, not related by i have also changed the file line ending from CRLF to LF.)

Can I contribute with the localization to Brazilian Portuguese?

Please confirm that this guide is still valid:
http://wiki.spagobi.org/xwiki/bin/view/spagobi_server/Internazionalization

Thank you very much!

Brazil is a country with a population of more than 200 million, very rich and I am sure that Knowage solution will be very well received by the open source community
Fork created:
https://github.com/WandreyRangon/Knowage-Server

Since #45 and the recommended use of aktivecortex-foo-commonj fork in replacement to the foo-commonj, the slj4j-api library seems to be a requirement for aktivecortex-foo-commonj. (I am not sure if it was already the case for the original foo-commonj library).

Please update the documentation to add this library as a requirement in manual install.

PS: This may also be relevant to update the Docker; Chef and Installer projects accordingly.

Wrong work with UTF8. In AdapterHTTP.handleMultipartForm replace

String value = item.getString();

on

String value = item.getString("UTF-8");

You don't see defference in latin, but in cyrillic it's а big problem. 

The actual documentation for manual install did not ask to add in server.xml the line:

<Environment description="HMAC key" name="hmacKey" type="java.lang.String" value="abc123"/>

but his hmacKey line is added by the knowage_installer (and is also present in the many context.xml files).

1. please tell if this parameter is mandatory for Knowage CE
2. and what is it use

I used mysql database with charset utf8,

"character_set_client","utf8"
"character_set_connection","utf8"
"character_set_database","utf8"
"character_set_filesystem","binary"
"character_set_results","utf8"
"character_set_server","utf8"
"character_set_system","utf8"

and changed server.xml like this:

url="jdbc:mysql://localhost:3306/knowage_ce?characterEncoding=utf-8"

But, When i save Chinese chars, Chinese not work ok.
Such as,menu manage page ,users manage page.
Pls. tell me what i can do?

I tryed to start the OLAP wizard template and I got the following error:

Also i perfomed the tests with firewall rules deactivated and skype closed.

Could you please help me with this error?

BR,

error while attempt to load filtersjava.lang.NullPointerException 

when the value of description for a LOV is to long !

See KnowageLabs/Knowage-Server-Docker#8

In short, foo-commonj.jar is not available where he used to be. Please update the documentation with a downlable link alternative.

Describe the bug
Deploying the metaweb war file when using a datasource for the knowage database other than mysql results in the metaweb application never loading.

To Reproduce
Steps to reproduce the behavior:

1. Install Knowage.war
2. Configure Knowage to use the correct hibernate dialect (e.g postgresql)
3. Install MetaWeb.war
4. Attempt to create a BusinessModel
5. The application never loads and the following error is thrown:

30 Jul 2018 11:58:58,732 ERROR it.eng.knowage.meta.service.PageResource.getPage:206 - Error

during Metamodel initialization: it.eng.spagobi.commons.dao.SpagoBIDAOException: An unexpected error occured while loading active content for model with id [2]
30 Jul 2018 14:28:30,098 ERROR org.hibernate.util.JDBCExceptionReporter.logExceptions:234 - ERROR: operator does not exist: boolean = integer
Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Position: 840
30 Jul 2018 14:28:30,099 ERROR it.eng.spagobi.commons.dao.AbstractHibernateDAO.logException:254 - org.hibernate.exception.SQLGrammarException could not execute query
org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2536)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:890)
at it.eng.spagobi.tools.catalogue.dao.MetaModelsDAOImpl.loadActiveMetaModelContentById(MetaModelsDAOImpl.java:839)
at it.eng.knowage.meta.service.PageResource.getPage(PageResource.java:143)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140)
at org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:294)
at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:248)
at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:235)
at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:398)
at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:205)
at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:228)
at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)
at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1460)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: boolean = integer
Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Position: 840
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2412)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2125)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:297)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:169)
at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:117)
at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:82)
at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:82)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
at org.hibernate.loader.Loader.doQuery(Loader.java:802)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2533)
... 46 more

Expected behavior
The MetaWeb application should deploy and work.

This can be fixed by editing the hibernate.cfg.xml file. Either the documentaitons should be updated or the application should use the hibernate dialect as set up in the knowage application.

I can't compile the project with maven. Return ERROR is:

[INFO] Reactor Summary:
[INFO]
[INFO] knowage-ce-parent .................................. SUCCESS [ 0.522 s]
[INFO] knowage-jdbc-core .................................. SUCCESS [ 2.251 s]
[INFO] knowage-utils-json ................................. SUCCESS [ 0.875 s]
[INFO] knowage-utils ...................................... SUCCESS [ 6.559 s]
[INFO] qbe-core ........................................... SUCCESS [ 2.391 s]
[INFO] spagobi-cwm ........................................ SUCCESS [ 0.892 s]
[INFO] spagobi-commons-core ............................... SUCCESS [ 6.772 s]
[INFO] spagobi-metamodel-core ............................. SUCCESS [ 1.746 s]
[INFO] spagobi-metamodel-utils ............................ SUCCESS [ 0.920 s]
[INFO] knowage-dao ........................................ FAILURE [ 0.326 s]
[INFO] knowage-core ....................................... SKIPPED
[INFO] knowageoauth2securityprovider ...................... SKIPPED
[INFO] knowage ............................................ SKIPPED
[INFO] knowagejasperreportengine .......................... SKIPPED
[INFO] spagobi.birt.oda ................................... SKIPPED
[INFO] knowagebirtreportengine ............................ SKIPPED
[INFO] slimerjs-wrapper ................................... SKIPPED
[INFO] knowagecockpitengine ............................... SKIPPED
[INFO] knowagecommonjengine ............................... SKIPPED
[INFO] knowagedataminingengine ............................ SKIPPED
[INFO] knowagegeoreportengine ............................. SKIPPED
[INFO] knowagekpiengine ................................... SKIPPED
[INFO] knowagemeta ........................................ SKIPPED
[INFO] knowagenetworkengine ............................... SKIPPED
[INFO] knowageqbeengine ................................... SKIPPED
[INFO] knowagesvgviewerengine ............................. SKIPPED
[INFO] knowagetalendenginclientapi ........................ SKIPPED
[INFO] knowagetalendengine ................................ SKIPPED
[INFO] knowagewhatifengine ................................ SKIPPED
[INFO] knowagesdk ......................................... SKIPPED
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 29.239 s
[INFO] Finished at: 2018-06-11T14:45:24+00:00
[INFO] Final Memory: 53M/470M
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal on project knowage-dao: Could not resolve dependencies for project it.eng.knowage:knowage-dao:jar:6.1.1-SNAPSHOT: Could not transfer artifact it.eng.knowage:knowage-utils:jar:tests:6.1.1-SNAPSHOT from/to jaspersoft (http://jaspersoft.artifactoryonline.com/jaspersoft/jr-ce-releases): Failed to transfer file: http://jaspersoft.artifactoryonline.com/jaspersoft/jr-ce-releases/it/eng/knowage/knowage-utils/6.1.1-SNAPSHOT/knowage-utils-6.1.1-SNAPSHOT-tests.jar. Return code is: 409 , ReasonPhrase:. -> [Help 1]
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/DependencyResolutionException
[ERROR]
[ERROR] After correcting the problems, you can resume the build with the command
[ERROR] mvn -rf :knowage-dao

This is a test issue

1. While adding the new Cross Table widget in Cockpit with the data that is available in a database table with Arabic Langauge then it is not showing the data in Arabic Characters. Although the Arabic characters are properly showing in normal Table widget.
2. In Cross Table, if select the Date field in the row it is showing with time and there is no any setting where we can change it to show the only date instead of date and time.

[KNOW-54] created by iftikharalam

In trying to complete the local install of CE on a Windows 64 bit, we see an error when connecting to data sets. What are we missing?

Error

{"service"."An unexpected error occurred while instatiating |sic| the dao","errors".[\{}]}

MySQL was configured on local server with correct JDBC credentials.

There is a documentation to setup CAS with Knowage at Readthedocs but i's a bit lacking and confusing. I have a few questions that need clarifications:

• where to download the cas.war file ? (at Apereo.org ?)
• did this install/setup the CAS client or a CAS server ? (seem like it's the later with a CAS overlay)
• how to setup the client only ? (if a CAS server is already available)
• witch client can be used with Knowage (only the legacy Yale.edu client ?)
• where to download the recommended CAS client ? (this one ?)

If you made a cockpit table with a dataset that has parameters with no default value, the table show data in cockpit (because you can valorize them) but when I export the cockpit to excel it does not generate data.

If the same dataset i will remove the parameters and export the cockpit, it generates data in the excel file.

Error log is:

it.eng.spagobi.tools.dataset.exceptions.ParametersNotValorizedException: The following parameters have no value [fecha_desde, fecha_hasta]
        at it.eng.spagobi.tools.dataset.DatasetManagementAPI.setDataSetParameters(DatasetManagementAPI.java:2052)
        at it.eng.spagobi.tools.dataset.DatasetManagementAPI.getDataStore(DatasetManagementAPI.java:365)
        at 
[http-bio-8585-exec-3] 20 Nov 2017 13:33:56,550 ERROR it.eng.spagobi.rest.interceptors.RestExceptionMapper.toResponseFromGenericException:73 - Catched service error:
it.eng.spagobi.utilities.exceptions.SpagoBIRestServiceException: generic.error
        at it.eng.spagobi.api.v2.DataSetResource.getDataStorePost(DataSetResource.java:712)
        at sun.reflect.GeneratedMethodAccessor836.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140)
        at org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:294)
        at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:248)
        at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:235)
        at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:398)
        at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:205)
        at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:228)
        at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)
        at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)

The issue has been raised from here: QA Question

Knowage installer create a demo talent by default. but, I find the talent-configurate functionality in the old spagobi release (e.g. ver 5.2) has been removed in the new knowage release. how to create a new talent in the version 6? otherwise, the community version is just a toy-version only for demo usage?

The following works in 6.0, but not in the versions after.

Creating a template does give a problem with load file. Error message in the text here, example jpivot in the enclosure.

30 Oct 2017 13:49:00,581 ERROR it.eng.spagobi.engines.whatif.model.PivotJsonHTMLSerializer.serialize:296 - Error serializing the pivot table
java.lang.NullPointerException
    at it.eng.spagobi.engines.whatif.calculatedmember.MDXFormulaHandler.loadFile(MDXFormulaHandler.java:74)
    at it.eng.spagobi.engines.whatif.calculatedmember.MDXFormulaHandler.getFormulasFromXML(MDXFormulaHandler.java:84)
    at it.eng.spagobi.engines.whatif.calculatedmember.MDXFormulaHandler.getFormulas(MDXFormulaHandler.java:96)
    at it.eng.spagobi.engines.whatif.model.PivotJsonHTMLSerializer.serializeFunctions(PivotJsonHTMLSerializer.java:382)
    at it.eng.spagobi.engines.whatif.model.PivotJsonHTMLSerializer.serialize(PivotJsonHTMLSerializer.java:280)
    at it.eng.spagobi.engines.whatif.model.PivotJsonHTMLSerializer.serialize(PivotJsonHTMLSerializer.java:76)
    at com.fasterxml.jackson.databind.ser.DefaultSerializerProvider.serializeValue(DefaultSerializerProvider.java:108)
    at com.fasterxml.jackson.databind.ObjectMapper._configAndWriteValue(ObjectMapper.java:2407)
    at com.fasterxml.jackson.databind.ObjectMapper.writeValueAsString(ObjectMapper.java:1983)
    at it.eng.spagobi.engines.whatif.model.PivotJsonSerializer.serialize(PivotJsonSerializer.java:49)
    at it.eng.spagobi.engines.whatif.model.PivotJsonSerializer.serialize(PivotJsonSerializer.java:32)
    at it.eng.spagobi.engines.whatif.serializer.SerializationManager.serialize(SerializationManager.java:121)
    at it.eng.spagobi.engines.whatif.common.AbstractWhatIfEngineService.serialize(AbstractWhatIfEngineService.java:141)
    at it.eng.spagobi.engines.whatif.common.AbstractWhatIfEngineService.renderModel(AbstractWhatIfEngineService.java:81)
    at it.eng.spagobi.engines.whatif.api.ModelResource.setMdx(ModelResource.java:174)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140)
    at org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:294)
    at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:248)
    at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:235)
    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:398)
    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:205)
    at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:228)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at it.eng.spagobi.utilities.filters.SpagoBIAccessFilter.doFilter(SpagoBIAccessFilter.java:206)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at it.eng.spagobi.utilities.filters.EngineCheckSessionFilter.doFilter(EngineCheckSessionFilter.java:92)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at it.eng.spagobi.utilities.filters.EncodingFilter.doFilter(EncodingFilter.java:54)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1115)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
    at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2549)
    at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2538)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Thread.java:748)
30 Oct 2017 13:49:00,581 ERROR it.eng.spagobi.engines.whatif.model.PivotJsonSerializer.serialize:51 - Error serializing the MemberEntry
com.fasterxml.jackson.databind.JsonMappingException: Error serializing the pivot table
    at com.fasterxml.jackson.databind.ser.DefaultSerializerProvider.serializeValue(DefaultSerializerProvider.java:123)
    at com.fasterxml.jackson.databind.ObjectMapper._configAndWriteValue(ObjectMapper.java:2407)
    at com.fasterxml.jackson.databind.ObjectMapper.writeValueAsString(ObjectMapper.java:1983)
    at it.eng.spagobi.engines.whatif.model.PivotJsonSerializer.serialize(PivotJsonSerializer.java:49)
    at it.eng.spagobi.engines.whatif.model.PivotJsonSerializer.serialize(PivotJsonSerializer.java:32)
    at it.eng.spagobi.engines.whatif.serializer.SerializationManager.serialize(SerializationManager.java:121)
    at it.eng.spagobi.engines.whatif.common.AbstractWhatIfEngineService.serialize(AbstractWhatIfEngineService.java:141)
    at it.eng.spagobi.engines.whatif.common.AbstractWhatIfEngineService.renderModel(AbstractWhatIfEngineService.java:81)
    at it.eng.spagobi.engines.whatif.api.ModelResource.setMdx(ModelResource.java:174)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140)
    at org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:294)
    at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:248)
    at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:235)
    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:398)
    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:205)
    at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:228)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at it.eng.spagobi.utilities.filters.SpagoBIAccessFilter.doFilter(SpagoBIAccessFilter.java:206)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at it.eng.spagobi.utilities.filters.EngineCheckSessionFilter.doFilter(EngineCheckSessionFilter.java:92)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at it.eng.spagobi.utilities.filters.EncodingFilter.doFilter(EncodingFilter.java:54)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1115)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
    at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2549)
    at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2538)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Thread.java:748)
Caused by: it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: Error serializing the pivot table
    at it.eng.spagobi.engines.whatif.model.PivotJsonHTMLSerializer.serialize(PivotJsonHTMLSerializer.java:297)
    at it.eng.spagobi.engines.whatif.model.PivotJsonHTMLSerializer.serialize(PivotJsonHTMLSerializer.java:76)
    at com.fasterxml.jackson.databind.ser.DefaultSerializerProvider.serializeValue(DefaultSerializerProvider.java:108)
    ... 52 more
Caused by: java.lang.NullPointerException
    at it.eng.spagobi.engines.whatif.calculatedmember.MDXFormulaHandler.loadFile(MDXFormulaHandler.java:74)
    at it.eng.spagobi.engines.whatif.calculatedmember.MDXFormulaHandler.getFormulasFromXML(MDXFormulaHandler.java:84)
    at it.eng.spagobi.engines.whatif.calculatedmember.MDXFormulaHandler.getFormulas(MDXFormulaHandler.java:96)
    at it.eng.spagobi.engines.whatif.model.PivotJsonHTMLSerializer.serializeFunctions(PivotJsonHTMLSerializer.java:382)
    at it.eng.spagobi.engines.whatif.model.PivotJsonHTMLSerializer.serialize(PivotJsonHTMLSerializer.java:280)
    ... 54 more
30 Oct 2017 13:49:00,582 ERROR it.eng.spagobi.engines.whatif.exception.RestExceptionMapper.toResponse:62 - Catched error
it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: Error serializing the MemberEntry
    at it.eng.spagobi.engines.whatif.model.PivotJsonSerializer.serialize(PivotJsonSerializer.java:52)
    at it.eng.spagobi.engines.whatif.model.PivotJsonSerializer.serialize(PivotJsonSerializer.java:32)
    at it.eng.spagobi.engines.whatif.serializer.SerializationManager.serialize(SerializationManager.java:121)
    at it.eng.spagobi.engines.whatif.common.AbstractWhatIfEngineService.serialize(AbstractWhatIfEngineService.java:141)
    at it.eng.spagobi.engines.whatif.common.AbstractWhatIfEngineService.renderModel(AbstractWhatIfEngineService.java:81)
    at it.eng.spagobi.engines.whatif.api.ModelResource.setMdx(ModelResource.java:174)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140)
    at org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:294)
    at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:248)
    at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:235)
    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:398)
    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:205)
    at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:228)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at it.eng.spagobi.utilities.filters.SpagoBIAccessFilter.doFilter(SpagoBIAccessFilter.java:206)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at it.eng.spagobi.utilities.filters.EngineCheckSessionFilter.doFilter(EngineCheckSessionFilter.java:92)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at it.eng.spagobi.utilities.filters.EncodingFilter.doFilter(EncodingFilter.java:54)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1115)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
    at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2549)
    at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2538)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Thread.java:748)
Caused by: com.fasterxml.jackson.databind.JsonMappingException: Error serializing the pivot table
    at com.fasterxml.jackson.databind.ser.DefaultSerializerProvider.serializeValue(DefaultSerializerProvider.java:123)
    at com.fasterxml.jackson.databind.ObjectMapper._configAndWriteValue(ObjectMapper.java:2407)
    at com.fasterxml.jackson.databind.ObjectMapper.writeValueAsString(ObjectMapper.java:1983)
    at it.eng.spagobi.engines.whatif.model.PivotJsonSerializer.serialize(PivotJsonSerializer.java:49)
    ... 49 more
Caused by: it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: Error serializing the pivot table
    at it.eng.spagobi.engines.whatif.model.PivotJsonHTMLSerializer.serialize(PivotJsonHTMLSerializer.java:297)
    at it.eng.spagobi.engines.whatif.model.PivotJsonHTMLSerializer.serialize(PivotJsonHTMLSerializer.java:76)
    at com.fasterxml.jackson.databind.ser.DefaultSerializerProvider.serializeValue(DefaultSerializerProvider.java:108)
    ... 52 more
Caused by: java.lang.NullPointerException
    at it.eng.spagobi.engines.whatif.calculatedmember.MDXFormulaHandler.loadFile(MDXFormulaHandler.java:74)
    at it.eng.spagobi.engines.whatif.calculatedmember.MDXFormulaHandler.getFormulasFromXML(MDXFormulaHandler.java:84)
    at it.eng.spagobi.engines.whatif.calculatedmember.MDXFormulaHandler.getFormulas(MDXFormulaHandler.java:96)
    at it.eng.spagobi.engines.whatif.model.PivotJsonHTMLSerializer.serializeFunctions(PivotJsonHTMLSerializer.java:382)
    at it.eng.spagobi.engines.whatif.model.PivotJsonHTMLSerializer.serialize(PivotJsonHTMLSerializer.java:280)
    ... 54 more

The knowagewhatifengine/META-INF/context.xml file distributed, in the downlodable .war file for 6.2 version, still have the outdated SpagoBI module name as path :

Context is:

<Context path="/SpagoBIWhatIfEngine" >

instead of

<Context path="/knowagewhatifengine" >

The QBE has the relationship manager.

When you have multiple relationships between tables, in my case a date information table and the date fields.

And you've selected also multiple tables that have links to this date table. The program defaults by having from each table a link to this date information table.

When deselecting one of the links between the tables and selecting a new one, it looks like all goes ok, but on the back (generated query), you see that the link that is removed in the Relationships wizard is not removed. The result is wrong/no data in your qbe results.

As reported by a user on Q&A it seems that using a Postgres JNDI datasource the schema is not correctly retrieved and is set always to "public".

See also: https://www.knowage-suite.com/qa/530/how-to-set-up-multischema-postgresql-datasource-as-type-jndi

How to support Presto-JDBC for hive ? have any support plan?

This screenshot shows when the "3rd-level menu" is created successfully

Following screenshot shows the "3rd-level menu" is not shown to user

Our business usecase need this feature to be working. please fix ASAP. thanks!!

don't find pom.xml in most projects...

When trying to create a KPI Alert, no option is available to select an action type. See screenshot attached.

To reproduce, follow steps at: knowage.readthedocs.io/en/6.1.1/user/NGSI/README/index.html

Running version: 6.1.1

The pivot selection is generating the correct collumns but the meta data (column table names) are not fully supported. Please refer to the QA section on Knowage webpage:

https://www.knowage-suite.com/qa/2098/pivot-transformed-columns-complete-missing-field-metadata

Arabic data is not showing in Cockpit filter. The combo box is showing "??????".

i wanted to know whether i can show the filters to end user something like in the attachment.

I have cockpit with one dataset and two widgets: barchart (sales by filials) and text-widget with sum of all sales from this dataset. Then I do internal CrossNavigation from barchart and get selections filter by one filial 

Expectation:  data in text-widget refresh automatically

Fact: data in text-widget refresh only after edit widget 

after I create a new dataset and import an excel file, the function field "description" shows "??????" instead of Chinese string, and the function "field metadata" show "dataset field name" with "?????" instead of Chinese name as well. it's maybe an encoding problem. I can not fixed it because I can not import source code into Eclipse correctly since the projects haven't been maven-ized yet.

Describe the bug
Using metaweb to generate a model results in the error:

Impossible to load template file [/var/lib/tomcat8/webapps/knowagemeta/WEB-INF/classes/it/eng/knowage/meta/generator/templates/sbi_table.vm]

To Reproduce
Steps to reproduce the behavior:

1. Create a business model using metaweb and save it
2. Click on "Generate" to create the model - button appears after model is saved
3. Click on create on the popup that appears
4. You get an error message

Expected behavior
Model should generate.

I turned on trace logging in metaweb log4j.properties but it didn't provide any, useful, additional info. Here is the snippet:

07 Aug 2018 06:25:20,114 TRACE it.eng.knowage.meta.generator.jpamapping.wrappers.impl.AbstractJpaTable.getPackage:161 - IN
07 Aug 2018 06:25:20,114 TRACE it.eng.knowage.meta.generator.jpamapping.wrappers.impl.AbstractJpaTable.getPackage:172 - OUT
07 Aug 2018 06:25:20,145 TRACE it.eng.knowage.meta.generator.jpamapping.JpaMappingJarGenerator.generate:74 - OUT
07 Aug 2018 06:25:20,145 ERROR it.eng.knowage.meta.service.MetaService.buildModel:718 - it.eng.knowage.meta.generator.GenerationException: Impossible to load template file [/var/lib/tomcat8/webapps/knowagemeta/WEB-INF/classes/it/eng/knowage/meta/generator/templates/sbi_table.vm]
07 Aug 2018 06:25:20,156 DEBUG org.hibernate.impl.SessionImpl.:265 - opened session at timestamp: 15336231201
07 Aug 2018 06:25:20,157 DEBUG org.hibernate.transaction.JDBCTransaction.begin:78 - begin
07 Aug 2018 06:25:20,157 DEBUG org.hibernate.jdbc.ConnectionManager.openConnection:444 - opening JDBC connection
07 Aug 2018 06:25:20,157 DEBUG org.hibernate.transaction.JDBCTransaction.begin:83 - current autocommit status: true
07 Aug 2018 06:25:20,157 DEBUG org.hibernate.transaction.JDBCTransaction.begin:86 - disabling autocommit
07 Aug 2018 06:25:20,157 TRACE org.hibernate.jdbc.JDBCContext.afterTransactionBegin:258 - after transaction begin
07 Aug 2018 06:25:20,157 TRACE org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan:122 - unable to locate HQL query plan in cache; generating ( from SbiConfig)
07 Aug 2018 06:25:20,159 DEBUG org.hibernate.hql.ast.QueryTranslatorImpl.parse:272 - parse() - HQL: from it.eng.spagobi.commons.metadata.SbiConfig

We have created the calculated field in QBE Data Set, here we can able to see the calculated field contains float values (like 0.25).
 
After creating the cockpits using same QBE data set , it is showing the null values(the calculated field does not showing any values on cockpit chart).
 
The cache db tables also does not have any values (all are zero).

First of all, I moved the demo database to the MySql Database, so far so good.

But when I trying to define a Lovs with UTF-8 characters, it seems like occur an encoding problem when previewing.

Please see the snapshot for details

commons-logging.jar & commons-logging-api.jar are both dependencies requirement for Knowage webaps. Without them, some webapps will not start (knowagekpiengine, knowagesvgviewerengine,
knowagemeta, etc.

But, the documentation only list Apache Geronimo, Concurrency JSR-166 and aktivecortex-foo-commonj

Please also add commons-logging as a requirement in manual install documentation.

the hint: -bash: ./startup.sh: Permission denied