0 votes
1 view
ERROR it.eng.spagobi.analiticalmodel.document.dao.ObjTemplateDAOHibImpl.insertBIObjectTemplate:561 - Error while inserting function dependencies; check template format

org.hibernate.exception.SQLGrammarException: could not execute query

at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)

at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

at org.hibernate.loader.Loader.doList(Loader.java:2536)

at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)

at org.hibernate.loader.Loader.list(Loader.java:2271)

at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)

at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)

at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)

at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)

at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Unknown Source)

Caused by: java.sql.SQLSyntaxErrorException: (conn=60) Table 'knowage_demo.sbi_obj_function' doesn't exist

at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:177)

at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:110)

at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:228)

at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:216)

at org.mariadb.jdbc.MariaDbPreparedStatementClient.execute(MariaDbPreparedStatementClient.java:150)

at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeQuery(MariaDbPreparedStatementClient.java:164)

at sun.reflect.GeneratedMethodAccessor71.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114)

at com.sun.proxy.$Proxy81.executeQuery(Unknown Source)

at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)

at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)

at org.hibernate.loader.Loader.doQuery(Loader.java:802)

at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)

at org.hibernate.loader.Loader.doList(Loader.java:2533)

... 77 more

Caused by: java.sql.SQLException: Table 'knowage_demo.sbi_obj_function' doesn't exist

Query is: select sbiobjfunc0_.biobj_function_id as biobj1_58_, sbiobjfunc0_.USER_IN as USER2_58_, sbiobjfunc0_.USER_UP as USER3_58_, sbiobjfunc0_.USER_DE as USER4_58_, sbiobjfunc0_.TIME_IN as TIME5_58_, sbiobjfunc0_.TIME_UP as TIME6_58_, sbiobjfunc0_.TIME_DE as TIME7_58_, sbiobjfunc0_.SBI_VERSION_IN as SBI8_58_, sbiobjfunc0_.SBI_VERSION_UP as SBI9_58_, sbiobjfunc0_.SBI_VERSION_DE as SBI10_58_, sbiobjfunc0_.ORGANIZATION as ORGANIZ11_58_, sbiobjfunc0_.biobj_id as biobj12_58_, sbiobjfunc0_.function_id as function13_58_ from SBI_OBJ_FUNCTION sbiobjfunc0_ where sbiobjfunc0_.organization=? and sbiobjfunc0_.biobj_id=3253, parameters ['DEMO']

at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:153)

at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:254)

at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:209)

... 89 more

[http-nio-8080-exec-6] 20 Sep 2021 18:30:10,022 ERROR it.eng.spagobi.analiticalmodel.execution.service.v2.SaveDocumentResource.doInsertDocument:213 - it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: Impossible to insert object [1st_test]
Environment Knowage 7.4 Mysql 8.0 Tomcat 8.5
asked Sep 20, 2021 in Cockpit, Dashboard and Console by ramin (390 points) | 1 view
Hi,

how did you install Knowage? With the official installer or you did a manual installation?
Hi mlibanor,

I install with the official installer
Could you specify also the version and the steps you took to install Knowage? For example, did you choose Charts.js or Highcharts? Did you use the embedded database or you used your own? Did you install the demo contents?
1. first of all i choose Highcharts Js.  installation with demo contents(recommended for beginner)

2. after destination directory

3. i choose use an already installed DBMS

4. I select DBMS for metadata -- MariaDb

5. And DBMS server url -- jdbc:mariadb://localhost:3306

But i use MySQL Db in my local computer. When i try to select DBMS for metadata --MySQL Db then problems occured. that's way i choose MariaDb
can you help me for correct installation?

you can e-mail me
I'll try to replicate your case and I let you know.
I've found the problem. I will fix it in the new 7.4.11 soon.

1 Answer

0 votes
Hi,

the problem was fixed in the version 7.4.9: see http://release.ow2.org/knowage/7.4.9/Installers/

The problem was related to the initialization of the DB.
answered Sep 28, 2021 by mlibanor (5,090 points)
1,553 questions
1,017 answers
2,037 comments
2,567 users