Welcome to Knowage Q&A, where you can ask questions and receive answers from other members of the community.

Categories

Most popular tags

cockpit dataset error chart datasource installer datasets installation widget parameters business-model olap knowage knowage_7_1 integration login knowage_7_1-ce report-designer cross-navigation analyticaldriver

generic error in cockpit

0 votes
1 view
Hi,

I am using MongoDB and All-in-One-Knowage-6.0.0_RC_CE, when I want to create a simple bar chart inside a Cockpit, I received an error "generic error". However I can create a bar chart for foodmart data base (that default is in Knowage) previasouly.

Also I must mention that I have another problem: The information I am trying to display is stored on a remote MongoDB server. I have created DATA SOURCE and DATA SET (simple QUERY statement) in Knowage admin area and the PREVIEW works fine (I can see all the date from our DB). But, as I try to show these information by a final user from workspace area in SHARED DATA SET section I receive this error :

Unable to load data from dataset

Please help me ASAP.

Thank you in advance
Environment All-in-One-Knowage-6.0.0_RC_CE, windows 7, MongoDB, FireFox
in Charting by (730 points)

1 Answer

+2 votes

I found my answer and solved the problem. My problem was related to installation stage.

I needed to install a relational Database for storing Knowage Metadata (such as : MySQL, Oracle, Postgres, Ingres or HSQLDB); also specific JDBC library for the relational Database.

Also the metadata database must be created and configured KNOWAGE_SERVER_HOME/conf/server.xml. Then edit the following files in order to set the proper dialect for the database:

  • KNOWAGE_SERVER_HOME/webapps/Knowage/WEB-INF/classes/hibernate.cfg.xml (set hibernate.dialect property according to your database)
  • KNOWAGE_SERVER_HOME/webapps/Knowage/WEB-INF/classes/jbpm.hibernate.cfg.xml (set hibernate.dialect property according to your database)
  • KNOWAGE_SERVER_HOME/webapps/Knowage/WEB-INF/classes/quartz.properties (set org.quartz.jobStore.driverDelegateClass property according to your database)

At the end I needed to configuration of a data source, that is mandatory for ad-hoc reporting functionalities. I needed to define a JDBC data source (MySQL, HSQLDB, ...) as described in the above paragraph, but pay attention that this data source should be configured (in the Knowage web GUI detail page) as "Read and write" and "Write default", and it must be enabled in all tenants.

by (730 points)
hi,

I am facing the same problem can you plz just elobrate what changes needed to be done in hibernate.cfg.xml.
by (240 points)
Powered by Question2Answer
...