An error occurred in EXEC_QUERY_ACTION service while executing query

Question

I can't perview the result of query from QBE after creating my model and an error message appear 

this is a perview of KnowageQbeEngine.log file:

25 sept. 2018 14:57:58,235 ERROR it.eng.qbe.utility.CustomizedFunctionsReader.getCustomDefinedFunctionListFromJSON:93 - problems in finding custom functions for oracle

25 sept. 2018 14:58:22,104 ERROR org.hibernate.util.JDBCExceptionReporter.logExceptions:234 - ORA-00942: Table ou vue inexistante

25 sept. 2018 14:58:22,108 ERROR org.hibernate.util.JDBCExceptionReporter.logExceptions:234 - ORA-00942: Table ou vue inexistante

25 sept. 2018 14:58:22,109 ERROR it.eng.qbe.statement.jpa.JPQLDataSet.getResultNumber:139 - javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query

25 sept. 2018 14:58:22,114 ERROR it.eng.spagobi.engines.qbe.services.core.ServiceExceptionAction.logError:97 - An error occurred in EXEC_QUERY_ACTION service while executing query: [SELECT DISTINCT t_0.CATEGORIE FROM Produit t_0    ORDER BY 1 ASC]

25 sept. 2018 14:58:22,115 ERROR it.eng.spagobi.engines.qbe.services.core.ServiceExceptionAction.logError:98 - The error root cause is: ORA-00942: Table ou vue inexistante

25 sept. 2018 14:58:22,116 ERROR it.eng.spagobi.engines.qbe.services.core.ServiceExceptionAction.logError:107 - The error root cause stack trace is:

java.lang.RuntimeException: Impossible to load data

at it.eng.qbe.statement.jpa.JPQLDataSet.loadData(JPQLDataSet.java:55)

at it.eng.spagobi.engines.qbe.services.core.ExecuteQueryAction.executeQuery(ExecuteQueryAction.java:296)

at it.eng.spagobi.engines.qbe.services.core.ExecuteQueryAction.service(ExecuteQueryAction.java:141)

at it.eng.spago.dispatching.action.ActionCoordinator.invokeServiceBusiness(ActionCoordinator.java:209)

at it.eng.spago.dispatching.action.ActionCoordinator.service(ActionCoordinator.java:158)

at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:494)

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)

Comments

Hi Rahama,

can you take the query  

SELECT DISTINCT t_0.CATEGORIE FROM Produit t_0   ORDER BY 1 ASC

and execute it in some SQL client? 

Thank you in advance,

Nunzia

---

I did it. The problem is that i utilize a common oracle user so it starts with "C##username". Knowage when it generates the query, it makes "C.tablename" instead of "C##username.tablename" as consequence it generates the exception: java.lang.RuntimeException and the error: Table ou vue inexistante.

I try it with system as user of oracle and it works.

---

I see. I suggest you to go back to the business model catalog and generate the datamart again. Then click on the advanced options and change the schema name as I show you in the picture:

If it is not working I think you should check the datasource connection. 

---

Yes, it works !!! 

The default schema name is C##... it is configured from the beginning when i create my datasource.

It doesn't understand C## it reads it as C so i deleted the schema name on advanced options and it works. 

Thank you 

---

Perfect! You're welcome.

Regards,

Nunzia