PDA

View Full Version : BI 2.0 stable on MS SQLServer: file missing


framar97
01-16-2009, 09:15 AM
I'm installing BI 2.0 stable on MS SQLServer. I'm following pgraju's post http://forums.pentaho.org/showthread.php?t=66901
in biserver-ce\pentaho-solutions\system\hibernate I can't find the config file for MS SQLServer. There are the following files for dbms:
hsql.hibernate.cfg.xml
mysql5.hibernate.cfg.xml
oracle10g.hibernate.cfg.xml
postgresql.hibernate.cfg.xml

I try to edit a new file called sqlserver.hibernate.cfg.xml but I don't know how to config the dialect and the resource, like this one for hsql:
<property name="dialect">org.hibernate.dialect.HSQLDialect</property>
<mapping resource="hibernate/hsql.hbm.xml" />

I write:
<property name="dialect">org.hibernate.dialect.SqlServerDialect</property>
<mapping resource="hibernate/SQLServer.hbm.xml" />


but it doesn't work. Has anyone configured it successfully?
Thank you, Francesco
framar97
01-20-2009, 04:37 AM
I need to install BI 2.0 stable with SQLServer, I can't believe it is not possible! Can anyone help me?
Thank you, Francesco
framar97
01-23-2009, 11:26 AM
I know that MS SQLServer is not your favorite dbms, but my customer claims it! Please let me know how can I complete the installation :-(

Thank you, Francesco
4ndr34
01-23-2009, 11:38 AM
could depend on missing libraries???
if u post the error u receive, perhaps it could be easier;)
framar97
01-26-2009, 06:34 AM
Here it is pentaho.log:

2009-01-26 12:30:11,250 ERROR [org.pentaho.platform.repository.hibernate.HibernateUtil] HIBUTIL.ERROR_0006 - Costruzione SessionFactory fallita.
org.hibernate.MappingNotFoundException: resource: hibernate/SQLServer.hbm.xml not found
at org.hibernate.cfg.Configuration.addResource(Configuration.java:569)
at org.hibernate.cfg.Configuration.parseMappingElement(Configuration.java:1593)
at org.hibernate.cfg.Configuration.parseSessionFactory(Configuration.java:1561)
at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1540)
at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1514)
at org.hibernate.cfg.Configuration.configure(Configuration.java:1468)
at org.pentaho.platform.repository.hibernate.HibernateUtil.initialize(HibernateUtil.java:145)
at org.pentaho.platform.repository.hibernate.HibernateUtil.<clinit>(HibernateUtil.java:94)
at org.pentaho.platform.repository.solution.dbbased.DbBasedSolutionRepository.getRootFolder(DbBasedSolutionRepository.java:908)
at org.pentaho.platform.repository.solution.dbbased.DbBasedSolutionRepository.init(DbBasedSolutionRepository.java:113)
at org.pentaho.platform.repository.solution.dbbased.DbBasedSolutionRepository.<init>(DbBasedSolutionRepository.java:98)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoObjectFactory.instanceClass(AbstractSpringPentahoObjectFactory.java:85)
at org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoObjectFactory.retreiveObject(AbstractSpringPentahoObjectFactory.java:124)
at org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoObjectFactory.get(AbstractSpringPentahoObjectFactory.java:72)
at org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoObjectFactory.get(AbstractSpringPentahoObjectFactory.java:64)
at org.pentaho.platform.engine.core.system.PentahoSystem.get(PentahoSystem.java:520)
at org.pentaho.platform.plugin.action.kettle.KettleSystemListener.startup(KettleSystemListener.java:60)
at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:319)
at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:299)
at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:220)
at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:131)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:926)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:889)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:448)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
2009-01-26 12:30:11,250 ERROR [org.pentaho.platform.repository.hibernate.HibernateUtil] HIBUTIL.ERROR_0006 - Costruzione SessionFactory fallita.
org.hibernate.MappingNotFoundException: resource: hibernate/SQLServer.hbm.xml not found
at org.hibernate.cfg.Configuration.addResource(Configuration.java:569)
at org.hibernate.cfg.Configuration.parseMappingElement(Configuration.java:1593)
at org.hibernate.cfg.Configuration.parseSessionFactory(Configuration.java:1561)
at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1540)
at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1514)
at org.hibernate.cfg.Configuration.configure(Configuration.java:1468)
at org.pentaho.platform.repository.hibernate.HibernateUtil.initialize(HibernateUtil.java:145)
at org.pentaho.platform.repository.hibernate.HibernateUtil.<clinit>(HibernateUtil.java:94)
at org.pentaho.platform.repository.solution.dbbased.DbBasedSolutionRepository.getRootFolder(DbBasedSolutionRepository.java:908)
at org.pentaho.platform.repository.solution.dbbased.DbBasedSolutionRepository.init(DbBasedSolutionRepository.java:113)
at org.pentaho.platform.repository.solution.dbbased.DbBasedSolutionRepository.<init>(DbBasedSolutionRepository.java:98)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoObjectFactory.instanceClass(AbstractSpringPentahoObjectFactory.java:85)
at org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoObjectFactory.retreiveObject(AbstractSpringPentahoObjectFactory.java:124)
at org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoObjectFactory.get(AbstractSpringPentahoObjectFactory.java:72)
at org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoObjectFactory.get(AbstractSpringPentahoObjectFactory.java:64)
at org.pentaho.platform.engine.core.system.PentahoSystem.get(PentahoSystem.java:520)
at org.pentaho.platform.plugin.action.kettle.KettleSystemListener.startup(KettleSystemListener.java:60)
at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:319)
at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:299)
at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:220)
at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:131)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:926)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:889)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:448)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
2009-01-26 12:30:11,343 ERROR [org.pentaho.platform.util.logging.Logger] Error: Pentaho
2009-01-26 12:30:11,343 ERROR [org.pentaho.platform.util.logging.Logger] Error: Pentaho
2009-01-26 12:30:11,343 ERROR [org.pentaho.platform.util.logging.Logger] misc-org.pentaho.platform.engine.core.system.PentahoSystem: PentahoSystem.ERROR_0014 - Errore nel tentativo di eseguire la sequenza di startup per org.pentaho.platform.plugin.action.kettle.KettleSystemListener
org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 - Errore nel tentativo di eseguire la sequenza di startup per org.pentaho.platform.plugin.action.kettle.KettleSystemListener
at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:324)
at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:299)
at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:220)
at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:131)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:926)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:889)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:448)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
Caused by: java.lang.ExceptionInInitializerError
at org.pentaho.platform.repository.hibernate.HibernateUtil.initialize(HibernateUtil.java:191)
at org.pentaho.platform.repository.hibernate.HibernateUtil.<clinit>(HibernateUtil.java:94)
at org.pentaho.platform.repository.solution.dbbased.DbBasedSolutionRepository.getRootFolder(DbBasedSolutionRepository.java:908)
at org.pentaho.platform.repository.solution.dbbased.DbBasedSolutionRepository.init(DbBasedSolutionRepository.java:113)
at org.pentaho.platform.repository.solution.dbbased.DbBasedSolutionRepository.<init>(DbBasedSolutionRepository.java:98)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoObjectFactory.instanceClass(AbstractSpringPentahoObjectFactory.java:85)
at org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoObjectFactory.retreiveObject(AbstractSpringPentahoObjectFactory.java:124)
at org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoObjectFactory.get(AbstractSpringPentahoObjectFactory.java:72)
at org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoObjectFactory.get(AbstractSpringPentahoObjectFactory.java:64)
at org.pentaho.platform.engine.core.system.PentahoSystem.get(PentahoSystem.java:520)
at org.pentaho.platform.plugin.action.kettle.KettleSystemListener.startup(KettleSystemListener.java:60)
at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:319)
... 27 more
Caused by: org.hibernate.MappingNotFoundException: resource: hibernate/SQLServer.hbm.xml not found
at org.hibernate.cfg.Configuration.addResource(Configuration.java:569)
at org.hibernate.cfg.Configuration.parseMappingElement(Configuration.java:1593)
at org.hibernate.cfg.Configuration.parseSessionFactory(Configuration.java:1561)
at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1540)
at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1514)
at org.hibernate.cfg.Configuration.configure(Configuration.java:1468)
at org.pentaho.platform.repository.hibernate.HibernateUtil.initialize(HibernateUtil.java:145)
... 44 more
2009-01-26 12:30:11,343 ERROR [org.pentaho.platform.util.logging.Logger] misc-org.pentaho.platform.engine.core.system.PentahoSystem: PentahoSystem.ERROR_0014 - Errore nel tentativo di eseguire la sequenza di startup per org.pentaho.platform.plugin.action.kettle.KettleSystemListener
org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 - Errore nel tentativo di eseguire la sequenza di startup per org.pentaho.platform.plugin.action.kettle.KettleSystemListener
at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:324)
at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:299)
at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:220)
at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:131)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:926)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:889)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:448)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
Caused by: java.lang.ExceptionInInitializerError
at org.pentaho.platform.repository.hibernate.HibernateUtil.initialize(HibernateUtil.java:191)
at org.pentaho.platform.repository.hibernate.HibernateUtil.<clinit>(HibernateUtil.java:94)
at org.pentaho.platform.repository.solution.dbbased.DbBasedSolutionRepository.getRootFolder(DbBasedSolutionRepository.java:908)
at org.pentaho.platform.repository.solution.dbbased.DbBasedSolutionRepository.init(DbBasedSolutionRepository.java:113)
at org.pentaho.platform.repository.solution.dbbased.DbBasedSolutionRepository.<init>(DbBasedSolutionRepository.java:98)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoObjectFactory.instanceClass(AbstractSpringPentahoObjectFactory.java:85)
at org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoObjectFactory.retreiveObject(AbstractSpringPentahoObjectFactory.java:124)
at org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoObjectFactory.get(AbstractSpringPentahoObjectFactory.java:72)
at org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoObjectFactory.get(AbstractSpringPentahoObjectFactory.java:64)
at org.pentaho.platform.engine.core.system.PentahoSystem.get(PentahoSystem.java:520)
at org.pentaho.platform.plugin.action.kettle.KettleSystemListener.startup(KettleSystemListener.java:60)
at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:319)
... 27 more
Caused by: org.hibernate.MappingNotFoundException: resource: hibernate/SQLServer.hbm.xml not found
at org.hibernate.cfg.Configuration.addResource(Configuration.java:569)
at org.hibernate.cfg.Configuration.parseMappingElement(Configuration.java:1593)
at org.hibernate.cfg.Configuration.parseSessionFactory(Configuration.java:1561)
at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1540)
at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1514)
at org.hibernate.cfg.Configuration.configure(Configuration.java:1468)
at org.pentaho.platform.repository.hibernate.HibernateUtil.initialize(HibernateUtil.java:145)
... 44 more
2009-01-26 12:30:11,390 ERROR [org.pentaho.platform.util.logging.Logger] Error end:
2009-01-26 12:30:11,390 ERROR [org.pentaho.platform.util.logging.Logger] Error end:
4ndr34
01-26-2009, 06:52 AM
Here it is pentaho.log:

2009-01-26 12:30:11,250 ERROR [org.pentaho.platform.repository.hibernate.HibernateUtil] HIBUTIL.ERROR_0006 - Costruzione SessionFactory fallita.
org.hibernate.MappingNotFoundException: resource: hibernate/SQLServer.hbm.xml not found
........
it seems like there is not the above mentioned file....
i don't know where it should be....
but u can trying without modifying it, the hbm file probably is not dbms dependant (so leave <mapping resource="hibernate/hsql.hbm.xml" />)
framar97
01-26-2009, 09:21 AM
Andrea,
thank you for your answer.
The problem is due to the lack, in pentaho-bi-platform-repository-2.0.0.stable.jar, of a hbm for SQLServer.

Then I use the postgres 's hbm and it seems to work well.

Thank you, Francesco