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

Error while creating chart reports in cockpit [closed]

0 votes
1 view
Hi ,

I am trying to create  chart on cockpit.

but when i add dataset and go to select chart getting error below

"

The content of element type "session-factory" must match "(property*,mapping*,(class-cache|collection-cache)*,event*,listener*)".

at org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source)

P.S = I am able to create tables in cockpit error only when  i add chart

Knowage log:

18 Aug 2018 06:31:27,989 ERROR it.eng.knowage.engine.interceptors.RestExceptionMapper.toResponseFromGenericException:73 - Catched service error:

it.eng.spagobi.utilities.exceptions.SpagoBIServiceException: An unexpected error occured while executing service: JsonChartTemplateService.fieldsMetadataforCockpit

at it.eng.spagobi.engine.chart.api.JsonChartTemplateService.getDatasetMetadataForCockpit(JsonChartTemplateService.java:321)

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:728)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:409)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1044)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:315)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

at java.lang.Thread.run(Thread.java:748)

Caused by: it.eng.spagobi.commons.dao.SpagoBIDAOException: An unexpected error occured while loading dataset whose id is equal to [105]

at it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.loadDataSetById(DataSetDAOImpl.java:131)

at it.eng.spagobi.engine.chart.api.JsonChartTemplateService.getDatasetMetadataForCockpit(JsonChartTemplateService.java:308)

... 33 more

Caused by: it.eng.spagobi.commons.dao.SpagoBIDAOException: An error occured while creating the new transaction

at it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.loadDataSetById(DataSetDAOImpl.java:113)

... 34 more

Caused by: org.hibernate.MappingException: invalid configuration

at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:2214)

at org.hibernate.cfg.Configuration.configure(Configuration.java:2131)

at it.eng.spagobi.commons.utilities.HibernateSessionManager.initSessionFactory(HibernateSessionManager.java:45)

at it.eng.spagobi.commons.utilities.HibernateSessionManager.getSessionFactory(HibernateSessionManager.java:52)

at it.eng.spagobi.commons.utilities.HibernateSessionManager.getCurrentSession(HibernateSessionManager.java:63)

at it.eng.spagobi.commons.dao.AbstractHibernateDAO.getSession(AbstractHibernateDAO.java:131)

at it.eng.spagobi.tools.dataset.dao.DataSetDAOImpl.loadDataSetById(DataSetDAOImpl.java:108)

... 34 more

Caused by: org.xml.sax.SAXParseException; lineNumber: 245; columnNumber: 20; The content of element type "session-factory" must match "(property*,mapping*,(class-cache|collection-cache)*,event*,listener*)".

at org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source)

at org.apache.xerces.util.ErrorHandlerWrapper.error(Unknown Source)

at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)

at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)

at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)

at org.apache.xerces.impl.dtd.XMLDTDValidator.handleEndElement(Unknown Source)

at org.apache.xerces.impl.dtd.XMLDTDValidator.endElement(Unknown Source)

at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)

at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)

at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)

at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)

at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)

at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)

at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)

at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)

at org.dom4j.io.SAXReader.read(SAXReader.java:465)

at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:2211)

... 40 more
closed with the note: Problem Solved
in Caching by (240 points)
closed by
Hi,

   seems that Hibernate cannot create a new session to load the dataset. Which database are you using for knowage metadata? Did you update the correct dialect within the hibernate.cfg.xml file?

 Furthermore I don't understand your P.S... are you able to create table widget with the same dataset? The problem is there just with chart widget?
by (4.4k points)
Hi,

Thanks for your reply.

Yes the same dataset is working for table creation in cockpit. only charts are not woring

I am using mysql for metadata so have not done any changes in hibernate.cfg as mysql dialects already by default.
by (240 points)
That's strange...

Which type of dataset are you using (query, file,..) ? Can you post its configuration?

Which Knowage version are you using?
by (4.4k points)
My datasource is postgresql  and i am using queries for dataset.

Configuration : data read write and cache ticked

Knowage version - 6-2
by (240 points)
Other questions :) :

Which type of datasource are you using? JDBC or JNDI ? Which postgres driver?

Are you able to show dataset metadata (within the dataset gui)? They are correct?

Can you try to use the mysql db to create  a chart widget? For example you can try with the knowage metadata (with a query like this: select domain_cd, count(*) num from sbi_domains group by domain_Cd)... just to understand if the problem is linked to the target datasource

At last, you can try to set mysql as cache db (if it's possible with a dedicated schema)
by (4.4k points)
Hi,

Thanks a lot for your help was struggling with it from quite long.

I dont know exactly how it worked but when i tried chart with foodmart i could generate a chart.

So i tried by adding my dataset and i could generate chart.

Thanks .
by (240 points)
Powered by Question2Answer
...