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 generating model

+3 votes
1 view

Hi,

I'm not able to Generate a Datamart in the Business Model Catalog section. I have a "Generic Error".

Some ideas?

Grazie

Admin note: please provide more details on this question. It is really difficult to help if no useful info are provided. Thanks

in Business Model by (540 points)
edited by
Hi,

The same for me. I created the Business Classes, and the relations between the classes, but when I want to generate the datamart, I get this "Generic Error" too.

Here is the KnowageMeta.log message:

01 août 2017 14:22:07,654 ERROR it.eng.knowage.meta.service.MetaService.buildModel:700 - java.lang.NullPointerException

Thank you for your help.
by (140 points)
edited by

1 Answer

+1 vote
Hi Marco,
did you created the metamodel first? Check the log files in the application server. Also check if there are some compilations problems in the "Saved Version" section, three dots icon and see if there is a "Download log" option.

Regards.
by (11.6k points)
I have the same problem only the message Error while generating model when I click on Create (with default options, but I tried with advanced options and it's the same) and no useful details in logs.
by (250 points)
Hi,

the following is what I can see in the log:

--------
lug 24, 2017 4:43:49 PM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet [Resteasy] in context with path [/knowagemeta] threw exception
org.jboss.resteasy.spi.UnhandledException: org.apache.commons.jxpath.JXPathNotFoundException: No pointer for xpath: /businessModels[1]/businessTables[1]/columns[8]/properties[2]/value/propertyType/admissibleValues[3]
    at org.jboss.resteasy.core.SynchronousDispatcher.handleApplicationException(SynchronousDispatcher.java:365)
    at org.jboss.resteasy.core.SynchronousDispatcher.handleException(SynchronousDispatcher.java:233)
    at org.jboss.resteasy.core.SynchronousDispatcher.handleInvokerException(SynchronousDispatcher.java:209)
    at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:557)
    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:524)
    at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:126)
    at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
    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:313)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
Caused by: org.apache.commons.jxpath.JXPathNotFoundException: No pointer for xpath: /businessModels[1]/businessTables[1]/columns[8]/properties[2]/value/propertyType/admissibleValues[3]
    at org.apache.commons.jxpath.ri.JXPathContextReferenceImpl.getPointer(JXPathContextReferenceImpl.java:468)
    at org.apache.commons.jxpath.ri.JXPathContextReferenceImpl.getPointer(JXPathContextReferenceImpl.java:452)
    at it.eng.knowage.meta.service.MetaService.remove(MetaService.java:1284)
    at it.eng.knowage.meta.service.MetaService.applyPatch(MetaService.java:1238)
    at it.eng.knowage.meta.service.MetaService.applyDiff(MetaService.java:1210)
    at it.eng.knowage.meta.service.MetaService.checkRelationships(MetaService.java:195)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:167)
    at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:257)
    at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:222)
    at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:211)
    at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:542)
    ... 25 more
--------

In the consolle of the Inspector Web (Safari) I can see the following info:

-------
ARIA: Attribute " (3)
"aria-label"
"\", required for accessibility, is missing on node:"
<md-radio-button value="5" class="ng-scope md-knowage-theme md-checked" id="radio_29" role="radio" aria-checked="true">
<div class="_md-container md-ink-ripple" md-ink-ripple md-ink-ripple-checkbox>…</div>
<div ng-transclude class="_md-label"></div>
</md-radio-button>
------

Any suggestions?

Tks
by (540 points)
Hi, i got the same error. I´m using mssql database and the logs are:

- On Knowagemeta.log:
08 ago 2017 20:00:08,464 ERROR it.eng.knowage.meta.service.MetaService.buildModel:700 - java.lang.NullPointerException
08 ago 2017 20:00:43,155 ERROR it.eng.knowage.meta.service.MetaService.buildModel:700 - java.lang.NullPointerException
08 ago 2017 20:02:00,410 ERROR it.eng.knowage.meta.service.MetaService.buildModel:700 - java.lang.NullPointerException

- On knowagedatasetaudit.log:
[DefaultQuartzScheduler_Worker-2] 08 ago 2017 19:55:12,781  INFO it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.load:122 - Executing query SELECT * FROM SbiTest0 ...
[DefaultQuartzScheduler_Worker-2] 08 ago 2017 19:55:12,823  INFO it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.getResultNumber:209 - Executing query SELECT COUNT(*) FROM (SELECT * FROM SbiTest0) temptable ...
[localhost-startStop-1] 08 ago 2017 19:55:17,129  INFO it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.load:122 - Executing query SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE 'sbicache%' ...
[localhost-startStop-1] 08 ago 2017 19:55:17,189  INFO it.eng.spagobi.tools.dataset.common.dataproxy.JDBCDataProxy.getResultNumber:209 - Executing query SELECT COUNT(*) FROM (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE 'sbicache%') temptable ...

- On localhost_access_log.2017-08-08.txt:
0:0:0:0:0:0:0:1 - - [08/Aug/2017:20:01:58 -0500] "GET /knowagemeta/restful-services/1.0/metaWeb/modelInfos/162?user_id=demo_admin HTTP/1.1" 200 51
0:0:0:0:0:0:0:1 - - [08/Aug/2017:20:02:00 -0500] "GET /knowagemeta/restful-services/1.0/metaWeb/buildModel/162?user_id=demo_admin&model=Pruebas%20negocio%20Suppla&schema=&catalog=Base_Modelo_Dimensional_CargueSAP&registry=false&includeSources=false HTTP/1.1" 200 42
0:0:0:0:0:0:0:1 - - [08/Aug/2017:20:02:00 -0500] "GET /knowage/restful-services/2.0/businessmodels/162/versions/ HTTP/1.1" 200 274
0:0:0:0:0:0:0:1 - - [08/Aug/2017:20:02:07 -0500] "PUT /knowage/restful-services/2.0/businessmodels/162 HTTP/1.1" 200 176
0:0:0:0:0:0:0:1 - - [08/Aug/2017:20:02:07 -0500] "GET /knowage/restful-services/2.0/businessmodels HTTP/1.1" 200 852
0:0:0:0:0:0:0:1 - - [08/Aug/2017:20:02:07 -0500] "PUT /knowage/restful-services/2.0/businessmodels/162/versions/253/ HTTP/1.1" 200 93204

Please help me validating if you see something wrong.

Regards,
by (120 points)
Hi, I had the "No pointer for xpath" exception when I did not exclude a timestamp field from one of my source tables  (postgresql). Also I noticed that I get errors when I try to change more than one attribute of my fact table from "attribute" to measure before I click "save". This happens both with Oracle and postgresql source tables. Once I click "save" after every change, it works without errors.
Hope this helps.
by (2.6k points)
In my case, the solution was to change JRE_HOME to indicate jdk folder. At the top of both startup.sh and shutdown.sh I have now :

export JAVA_HOME="/usr/java/jdk1.8.0_151"
export JRE_HOME="/usr/java/jdk1.8.0_151"
export PATH=$JAVA_HOME/bin:$PATH

I don't know why, but know, Meta Web generates correctly Business Model !
by (250 points)
Thanks, it worked!!!

Now I have to find the solution of an error in OLAP Designer, when I select a Cube, knowage raise an error with the MDX. I created the schema with SQL Power Architect and works using Wabit
by (400 points)
Powered by Question2Answer
...