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

Hi,

I've created a simple BusinessModel  (SalesFact and product) with data coming from PostGreSql DB. When I generate the datamodel, the first time returns an error reporting below, then at the next attempt, it saves correctly. I go in the workspace area, I find the my metamodel, but when I run it in qbe, it returns a blank page.

Can anybody help me? Thanks in advance.

Stefano

The error is:

org.jboss.resteasy.spi.UnhandledException: org.apache.commons.jxpath.JXPathNotFoundException: No pointer for xpath: /businessModels[1]/businessTables[2]/properties[2]/value/propertyType/admissibleValues[6]

org.jboss.resteasy.core.SynchronousDispatcher.handleApplicationException(SynchronousDispatcher.java:365)

org.jboss.resteasy.core.SynchronousDispatcher.handleException(SynchronousDispatcher.java:233)

org.jboss.resteasy.core.SynchronousDispatcher.handleInvokerException(SynchronousDispatcher.java:209)

org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:557)

org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:524)

org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:126)

org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)

org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)

org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)

javax.servlet.http.HttpServlet.service(HttpServlet.java:728)

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

root cause
Environment Knowage CE version 6.0.0, Chrome, Win environment
in Business Model by (300 points)

1 Answer

0 votes
Hi,
after the creation of the metamodel you need to generate the datamart.jar, did you press the "Generate" button in the business model catalogue?
by (11.6k points)
Hi mcortella,
thanks for your attention. I confirm that I've pressed "Generate" button, I've created .jar. In workspace area I find my metamodel, but when I open business model in qbe, it returns a blank page. Thanks a lot.
Can you please describe more in detail what operation have you done to construct metamodel (added, deleted o renamed business classes or  business relationships)?
Thanks.
Hi mcortella, I've a simple business model: a salesfact table as a cube, a product table as dimension, an outbound relationship n to 1 from salesfact to product, a value as a measure in salesfact. The business class comes from postgresql table with own primary key and foreign key. So I follow the steps described in the official manual. I add that the Sales Cube included as example in Knowage environment works correctly in qbe. I don't know if I've explained all your dubts, tell me if you need other info. Thanks!
Hi pozzatos, thanks for answer.
The error after the save is not normal, did you tried to create the model from scratch? You always get that error?
Try to build the metamodel as it comes from the database and do not to set the value as a measure and tell me if you still get the error.
Hi mcortella, I tried as you've told to me. I created a new business model coming from db, without a measure and when I save it returns the following error. Thanks for your support

Error while checking meta model

Apache Tomcat/7.0.50 - Error report
HTTP Status 500 - org.apache.commons.jxpath.JXPathNotFoundException: No pointer for xpath: /businessModels[1]/businessTables[1]/properties[2]/value/propertyType/admissibleValues[6]

type Exception report

message org.apache.commons.jxpath.JXPathNotFoundException: No pointer for xpath: /businessModels[1]/businessTables[1]/properties[2]/value/propertyType/admissibleValues[6]

description The server encountered an internal error that prevented it from fulfilling this request.

exception

org.jboss.resteasy.spi.UnhandledException: org.apache.commons.jxpath.JXPathNotFoundException: No pointer for xpath: /businessModels[1]/businessTables[1]/properties[2]/value/propertyType/admissibleValues[6]
    org.jboss.resteasy.core.SynchronousDispatcher.handleApplicationException(SynchronousDispatcher.java:365)
    org.jboss.resteasy.core.SynchronousDispatcher.handleException(SynchronousDispatcher.java:233)
    org.jboss.resteasy.core.SynchronousDispatcher.handleInvokerException(SynchronousDispatcher.java:209)
    org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:557)
    org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:524)
    org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:126)
    org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
    org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
    org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
    org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
root cause

org.apache.commons.jxpath.JXPathNotFoundException: No pointer for xpath: /businessModels[1]/businessTables[1]/properties[2]/value/propertyType/admissibleValues[6]
    org.apache.commons.jxpath.ri.JXPathContextReferenceImpl.getPointer(JXPathContextReferenceImpl.java:468)
    org.apache.commons.jxpath.ri.JXPathContextReferenceImpl.getPointer(JXPathContextReferenceImpl.java:452)
    it.eng.knowage.meta.service.MetaService.remove(MetaService.java:1284)
    it.eng.knowage.meta.service.MetaService.applyPatch(MetaService.java:1238)
    it.eng.knowage.meta.service.MetaService.applyDiff(MetaService.java:1210)
    it.eng.knowage.meta.service.MetaService.checkRelationships(MetaService.java:195)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    java.lang.reflect.Method.invoke(Method.java:606)
    org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:167)
    org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:257)
    org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:222)
    org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:211)
    org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:542)
    org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:524)
    org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:126)
    org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
    org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
    org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
    org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.50 logs.
...