Error creating a model from MSSQL Database. Presents "Generic error".

Question

I´m trying to create a model, but it is not possible due to when i tried to generate appears a message "Generic Error". I´m using mssql database and i found at the logs this information:

- 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.

Answer 1

Hi,

on the system where Knowage is installed, did you set the JAVA_HOME environment variable pointing to a JDK (not JRE) 1.7 or more recent?

Comments

Hi thanks for the answer. I set JAVA_HOME in C:\Program Files\Java\jdk1.8.0_144. This is on system environment variable and i set JRE_HOME in C:\Program Files\Java\jre1.8.0_144.