[Logo] SpagoWorld Forums
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
[Groups] Back to home page  [Moderation Log] Moderation Log   [Register] Register /  [Login] Login 
Postgresql data source: Impossible to retrive the value of attribute [pgd] form user profil  XML
Forum Index » Technical Help - SpagoBI Server - CORE
Author Message
cyk.spw

Newby

Joined: 30/01/2013 23:24:12
Messages: 20
Offline

Hi,

I have a Postgresql data source (database name: pgd, schema: gps) , I used Studio to create the BM and Query, could get the data result from the query, I uploaded and deployed them to server, also
1) added a postgresql data source jndi to server.xml
2) add "<ResourceLink global="jdbc/pgd" name="jdbc/pgdw" type="javax.sql.DataSource"/>" to webapps/SpagoBIQbeEngine/META-INF/context.xml
3) restarted the server

However, when trying to check the data set (Query) in server GUI, I got error:
An unpredicted error occurred while executing SpagoBIQbeEngine service. The root cause of the error is: Impossible to retrive the value of attribute [pgd] form user profile

In the log file, it has the following:
08 Mar 2013 19:58:33,660 ERROR it.eng.spagobi.utilities.engines.EngineStartupExceptionTrapAction.logError:70 - An unpredicted error occurred while executing SpagoBIQbeEngine service.
The root cause of the error is: Impossible to retrive the value of attribute [pgs] form user profile
08 Mar 2013 19:58:33,661 ERROR it.eng.spagobi.utilities.engines.EngineStartupExceptionTrapAction.logError:71 - The error root cause is: Impossible to retrive the value of attribute [pgs] form user profile
08 Mar 2013 19:58:33,661 ERROR it.eng.spagobi.utilities.engines.EngineStartupExceptionTrapAction.logError:80 - The error root cause stack trace is:
it.eng.spagobi.utilities.engines.SpagoBIEngineRuntimeException: Impossible to retrive target schema for datasource [pgd]
at it.eng.spagobi.engines.qbe.services.initializers.BuildQbeDatasetStartAction.getDataSource(BuildQbeDatasetStartAction.java:205)
at it.eng.spagobi.utilities.engines.AbstractEngineStartAction.getEnv(AbstractEngineStartAction.java:516)
at it.eng.spagobi.engines.qbe.services.initializers.BuildQbeDatasetStartAction.service(BuildQbeDatasetStartAction.java:70)
at it.eng.spago.dispatching.action.ActionCoordinator.invokeServiceBusiness(ActionCoordinator.java:209)
at it.eng.spago.dispatching.action.ActionCoordinator.service(ActionCoordinator.java:15
at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:496)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at it.eng.spagobi.utilities.filters.SpagoBIAccessFilter.doFilter(SpagoBIAccessFilter.java:193)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at it.eng.spagobi.utilities.filters.EngineCheckSessionFilter.doFilter(EngineCheckSessionFilter.java:80)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:12
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:662)
Caused by: it.eng.spagobi.utilities.assertion.NullReferenceException: Impossible to retrive the value of attribute [pgs] form user profile
at it.eng.spagobi.utilities.assertion.Assert.assertNotNull(Assert.java:24)
at it.eng.spagobi.engines.qbe.services.initializers.BuildQbeDatasetStartAction.getDataSource(BuildQbeDatasetStartAction.java:201)
... 24 more
08 Mar 2013 19:58:33,661 ERROR it.eng.spagobi.utilities.engines.EngineStartupExceptionTrapAction.logError:81 - The error full stack trace is:
it.eng.spagobi.utilities.engines.SpagoBIEngineStartupException: An unpredicted error occurred while executing SpagoBIQbeEngine service.
The root cause of the error is: Impossible to retrive the value of attribute [pgs] form user profile
at it.eng.spagobi.engines.qbe.services.initializers.BuildQbeDatasetStartAction.service(BuildQbeDatasetStartAction.java:124)
at it.eng.spago.dispatching.action.ActionCoordinator.invokeServiceBusiness(ActionCoordinator.java:209)
at it.eng.spago.dispatching.action.ActionCoordinator.service(ActionCoordinator.java:15
at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:496)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at it.eng.spagobi.utilities.filters.SpagoBIAccessFilter.doFilter(SpagoBIAccessFilter.java:193)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at it.eng.spagobi.utilities.filters.EngineCheckSessionFilter.doFilter(EngineCheckSessionFilter.java:80)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:12
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:662)
Caused by: it.eng.spagobi.utilities.engines.SpagoBIEngineRuntimeException: Impossible to retrive target schema for datasource [pgd]
at it.eng.spagobi.engines.qbe.services.initializers.BuildQbeDatasetStartAction.getDataSource(BuildQbeDatasetStartAction.java:205)
at it.eng.spagobi.utilities.engines.AbstractEngineStartAction.getEnv(AbstractEngineStartAction.java:516)
at it.eng.spagobi.engines.qbe.services.initializers.BuildQbeDatasetStartAction.service(BuildQbeDatasetStartAction.java:70)
... 22 more
Caused by: it.eng.spagobi.utilities.assertion.NullReferenceException: Impossible to retrive the value of attribute [pgs] form user profile
at it.eng.spagobi.utilities.assertion.Assert.assertNotNull(Assert.java:24)
at it.eng.spagobi.engines.qbe.services.initializers.BuildQbeDatasetStartAction.getDataSource(BuildQbeDatasetStartAction.java:201)
... 24 more

How to fix it?
cyk.spw

Newby

Joined: 30/01/2013 23:24:12
Messages: 20
Offline

resolved
sadiqkhoja.spw

Newby

Joined: 11/03/2013 14:33:21
Messages: 29
Offline

how did you resolve that?
 
Forum Index » Technical Help - SpagoBI Server - CORE
Go to:   
Powered by JForum 2.1.9 © JForum Team