Ok, in fact this is my datasources. file:
<?xml version="1.0" encoding="UTF-8"?>
<DataSources>
<DataSource>
<DataSourceName>OpenHealthData</DataSourceName>
<DataSourceDescription>OpenHealth Test Data</DataSourceDescription>
<URL>http://localhost:8080/openhealth-fp/xmla</URL>
<DataSourceInfo>Provider=mondrian;
Jdbc=jdbc:postgresql://<server>/DB_TEST; JdbcDrivers=org.postgresql.Driver;
JdbcUser=postgres; JdbcPassword=postgres; PoolNeeded=true</DataSourceInfo>
<ProviderName>Mondrian</ProviderName>
<ProviderType>MDP</ProviderType>
<AuthenticationMode>Unauthenticated</AuthenticationMode>
<Catalogs>
<Catalog name="OpenHealth">
<Definition>cubes.xml</Definition>
</Catalog>
</Catalogs>
</DataSource>
</DataSources>
my cube is created on this new db connection, but when I try to access
openhealth the errors are:
* INFO 15:14:37,687 Reading datasource config file from
datasources.xml,
file:/C:/Programmi/DHIS2OH-2.0/tomcat/webapps/openhealth-fp/WEB-INF/classes/datasources.xml
(MondrianOlapQueryProcessor.java [Thread-1])
4-nov-2008 15.14.38 org.apache.catalina.core.StandardContext listenerStart
GRAVE: Exception sending context initialized event to listener instance
of class org.springframework.web.context.ContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating
bean with name 'simpleOlapDiscoverRequest' defined in URL
[file:/C:/Programmi/DHIS2OH-2.0/tomcat/webapps/openhealth-fp/WEB-INF/classes/routes.xml]:
Cannot resolve reference to bean 'olapQueryProcessor' while setting bean
property 'handler'; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating
bean with name 'olapQueryProcessor' defined in URL
[file:/C:/Programmi/DHIS2OH-2.0/tomcat/webapps/openhealth-fp/WEB-INF/classes/application.xml]:
Invocation of init method failed; nested exception is
mondrian.xmla.XmlaException: Mondrian Error:XMLA Discover unparse
results error
Caused by: org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'olapQueryProcessor' defined in URL
[file:/C:/Programmi/DHIS2OH-2.0/tomcat/webapps/openhealth-fp/WEB-INF/classes/application.xml]:
Invocation of init method failed; nested exception is
mondrian.xmla.XmlaException: Mondrian Error:XMLA Discover unparse
results error
Caused by: mondrian.xmla.XmlaException: Mondrian Error:XMLA Discover
unparse results error
at mondrian.xmla.XmlaHandler.discover(XmlaHandler.java:2081)
at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:132)
at
intl.who.openhealth.olap.service.MondrianOlapQueryProcessor.executeXmlaQuery(MondrianOlapQueryProcessor.java:483)
at
intl.who.openhealth.olap.service.MondrianOlapQueryProcessor.executeDiscoverQuery(MondrianOlapQueryProcessor.java:394)
at
intl.who.openhealth.olap.service.MondrianOlapQueryProcessor.init(MondrianOlapQueryProcessor.java:145)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1241)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1206)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1172)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:428)
at
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:261)
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:109)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1100)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:862)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:424)
at
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:156)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160)
at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:287)
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:352)
at
org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)
at
org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)
at
org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3830)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4337)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)
at
org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at
org.apache.catalina.core.StandardService.start(StandardService.java:516)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal
error: while parsing catalog
/C:/Programmi/DHIS2OH-2.0/tomcat/webapps/openhealth-fp/WEB-INF/classes/cubes.xml
at
mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755)
at mondrian.olap.Util.newInternal(Util.java:1083)
at mondrian.olap.Util.newError(Util.java:1099)
at mondrian.rolap.RolapSchema.load(RolapSchema.java:303)
at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:213)
at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:76)
at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:835)
at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:657)
at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:148)
at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:79)
at mondrian.olap.DriverManager.getConnection(DriverManager.java:122)
at mondrian.olap.DriverManager.getConnection(DriverManager.java:87)
at mondrian.xmla.XmlaHandler.getConnection(XmlaHandler.java:2165)
at
mondrian.xmla.RowsetDefinition$MdschemaDimensionsRowset.populate(RowsetDefinition.java:3641)
at mondrian.xmla.Rowset.unparse(Rowset.java:148)
at mondrian.xmla.XmlaHandler.discover(XmlaHandler.java:2076)
... 54 more
Caused by: org.eigenbase.xom.XOMException: Document parse failed: [Fatal
Error] :176:66: Invalid byte 1 of 1-byte UTF-8 sequence.
at org.eigenbase.xom.wrappers.GenericDOMParser.handleErrors(Unknown
Source)
at org.eigenbase.xom.wrappers.JaxpDOMParser.parseInputSource(Unknown
Source)
at org.eigenbase.xom.wrappers.GenericDOMParser.parse(Unknown Source)
at mondrian.rolap.RolapSchema.load(RolapSchema.java:284)
... 66 more
4-nov-2008 15.14.38 org.apache.catalina.core.StandardContext start
GRAVE: Error listenerStart
4-nov-2008 15.14.38 org.apache.catalina.core.StandardContext start
GRAVE: Context [/openhealth-fp] startup failed due to previous errors
4-nov-2008 15.14.38 org.apache.catalina.core.ApplicationContext log
INFO: Closing Spring root WebApplicationContext
4-nov-2008 15.14.39 org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
4-nov-2008 15.14.39 org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextInitialized()
4-nov-2008 15.14.39 org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8180
4-nov-2008 15.14.40 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8109
4-nov-2008 15.14.40 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/328 config=null
4-nov-2008 15.14.40 org.apache.catalina.startup.Catalina start
INFO: Server startup in 51918 ms
Could I define cube like that?
<Cube name="cubo2">
<View alias="chiamata_time">
<SQL dialect="postgres">
<![CDATA[ select ...............
]]>
</SQL>
</View>
<Dimension name="....................................>
etc. etc. .....
Thanks
Knut Staring ha scritto:
> On Tue, Nov 4, 2008 at 12:45 PM, Fabio D'Ovidio
> <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote:
>
> Hello.
> I want now to try change cube...
> I change my cubes.xml and my DB connection in the following files:
>
> * datasources.xml
> * hibernate.properties
>
> what about the other xml files in /WEB-INF/calsses directory such as
> openhealth.xml?
>
>
> openhealth.xml is just an old cube definition file. You control the
> name of your cube definition file in datasources.xml.
>
> Knut
>
>
>
> Thanks
>
> --
> Fabio D'Ovidio
> Geospatial solutions
>
> INOVA s.r.l.
> Web : http://www.inovaos.it
> Tel.: 081 197 57 600
> mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
>
> _______________________________________________
> Dhis-users mailing list
> [email protected] <mailto:[email protected]>
> http://www.hisp.info/mailman/listinfo/dhis-users
>
>
>
>
> --
> Cheers,
> Knut Staring
> ------------------------------------------------------------------------
>
> _______________________________________________
> Dhis-users mailing list
> [email protected]
> http://www.hisp.info/mailman/listinfo/dhis-users
>
--
Fabio D'Ovidio
Geospatial solutions
INOVA s.r.l.
Web : http://www.inovaos.it
Tel.: 081 197 57 600
mail: [EMAIL PROTECTED]
_______________________________________________
Dhis-users mailing list
[email protected]
http://www.hisp.info/mailman/listinfo/dhis-users
