Hyland Community
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Problem in pentaho AAAR tool

alfresco_shaikh
Champ in-the-making
Champ in-the-making

‎09-08-2014 05:31 AM

Hi
When I goto Tools->AAAR at that I got following error in  pentaho.log

2014-09-08 14:50:59,694 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] could not get database metadata
java.sql.SQLException: Invalid URL: jdbcSmiley Tongueostgresql://localhost:5432/hibernate
   at org.apache.hadoop.hive.jdbc.HiveConnection.<init>(HiveConnection.java:77)
   at org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:104)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:622)
   at org.pentaho.hadoop.shim.common.DriverProxyInvocationChain$DriverInvocationHandler.invoke(DriverProxyInvocationChain.java:163)
   at com.sun.proxy.$Proxy142.connect(Unknown Source)
   at org.apache.hadoop.hive.jdbc.HiveDriver$1.call(HiveDriver.java:136)
   at org.apache.hadoop.hive.jdbc.HiveDriver$1.call(HiveDriver.java:133)
   at org.pentaho.hadoop.hive.jdbc.JDBCDriverCallable.callWithDriver(JDBCDriverCallable.java:57)
   at org.apache.hadoop.hive.jdbc.HiveDriver.callWithActiveDriver(HiveDriver.java:122)
   at org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:133)
   at java.sql.DriverManager.getConnection(DriverManager.java:615)
   at java.sql.DriverManager.getConnection(DriverManager.java:167)
   at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)
   at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:51)
   at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:168)
   at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:375)
   at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1872)
   at org.pentaho.platform.repository.hibernate.HibernateUtil.initialize(HibernateUtil.java:169)
   at org.pentaho.platform.repository.hibernate.HibernateUtil.<clinit>(HibernateUtil.java:90)
   at org.pentaho.cdf.environment.configurations.PentahoHibernanteConfigurations.getConfiguration(PentahoHibernanteConfigurations.java:17)
   at org.pentaho.cdf.utils.PluginHibernateUtil.initialize(PluginHibernateUtil.java:61)
   at org.pentaho.cdf.storage.StorageEngine.getInstance(StorageEngine.java:65)
   at org.pentaho.cdf.context.ContextEngine.getStorage(ContextEngine.java:308)
   at org.pentaho.cdf.context.ContextEngine.buildContextScript(ContextEngine.java:239)
   at org.pentaho.cdf.context.ContextEngine.getContext(ContextEngine.java:123)
   at org.pentaho.cdf.CdfContentGenerator.getContext(CdfContentGenerator.java:208)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:622)
   at pt.webdetails.cpf.InterPluginCall.run(InterPluginCall.java:352)
   at pt.webdetails.cpf.InterPluginCall.call(InterPluginCall.java:365)
   at pt.webdetails.cpf.InterPluginCall.call(InterPluginCall.java:67)
   at pt.webdetails.cdf.dd.InterPluginBroker.getCdfContext(InterPluginBroker.java:57)
   at pt.webdetails.cdf.dd.api.RenderApi.render(RenderApi.java:148)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:622)
   at pt.webdetails.cpf.InterPluginCall.run(InterPluginCall.java:352)
   at pt.webdetails.cpf.InterPluginCall.call(InterPluginCall.java:365)
   at pt.webdetails.cpf.InterPluginCall.call(InterPluginCall.java:67)
   at pt.webdetails.cpk.InterPluginBroker.run(InterPluginBroker.java:38)
Labels:
0 Kudos
4 REPLIES 4

fcorti
Elite Collaborator
Elite Collaborator

‎09-11-2014 03:16 AM

Hi,

This is not a AAAR problem but a Pentaho Installation problem… you can see it from 'jdbcSmiley Tongueostgresql://localhost:5432/hibernate' that is not a AAAR database or component.
I suggest you to find support in the Pentaho forum.

Cheers.
0 Kudos

alfresco_shaikh
Champ in-the-making
Champ in-the-making
In response to fcorti

‎09-11-2014 03:31 AM

Thanks for your reply fcorti..
I solved this..
0 Kudos

fcorti
Elite Collaborator
Elite Collaborator

‎09-11-2014 03:38 AM

Good job! 🙂
0 Kudos

sandeepreddy1
Star Contributor
Star Contributor
In response to fcorti

‎06-16-2016 04:58 AM

Hello Francesco,

When pentaho starting it is showing statu 404 error
in Pentaho.log file it is showing like this

2016-06-14 17:02:11,131 ERROR [org.pentaho.platform.util.logging.Logger] Error: Pentaho
2016-06-14 17:02:11,132 ERROR [org.pentaho.platform.util.logging.Logger] misc-org.pentaho.platform.engine.core.system.PentahoSystem: org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 - Error while trying to execute startup sequence for org.pentaho.platform.engine.services.connection.datasource.dbcp.DynamicallyPooledDatasourceSystemListener
org.pentaho.platform.api.engine.PentahoSystemException: org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 - Error while trying to execute startup sequence for org.pentaho.platform.engine.services.connection.datasource.dbcp.DynamicallyPooledDatasourceSystemListener
    at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:373)
    at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:335)
    at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:231)
    at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:162)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4811)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5251)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1092)
    at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1834)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
    at java.util.concurrent.FutureTask.run(FutureTask.java:262)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:745)
Caused by: org.pentaho.platform.api.engine.PentahoSystemException: PentahoSystem.ERROR_0014 - Error while trying to execute startup sequence for org.pentaho.platform.engine.services.connection.datasource.dbcp.DynamicallyPooledDatasourceSystemListener
    at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:455)
    at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:437)
    at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:416)
    at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:437)
    at org.pentaho.platform.engine.core.system.PentahoSystem.access$000(PentahoSystem.java:89)
    at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:368)
    at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:365)
    at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:416)
    at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:365)
    … 16 more
Caused by: java.lang.NullPointerException
    at org.pentaho.platform.repository.JcrBackedDatasourceMgmtService.init(JcrBackedDatasourceMgmtService.java:67)
    at org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoObjectFactory.retreiveObject(AbstractSpringPentahoObjectFactory.java:266)
    at org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoObjectFactory.get(AbstractSpringPentahoObjectFactory.java:82)
    at org.pentaho.platform.engine.core.system.objfac.AggregateObjectFactory.get(AggregateObjectFactory.java:273)
    at org.pentaho.platform.engine.core.system.objfac.AggregateObjectFactory.get(AggregateObjectFactory.java:137)
    at org.pentaho.platform.engine.services.connection.datasource.dbcp.NonPooledDatasourceSystemListener.getListOfDatabaseConnections(NonPooledDatasourceSystemListener.java:136)
    at org.pentaho.platform.engine.services.connection.datasource.dbcp.NonPooledDatasourceSystemListener.startup(NonPooledDatasourceSystemListener.java:53)
    at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:446)
    … 24 more
2016-06-14 17:02:11,134 ERROR [org.pentaho.platform.util.logging.Logger] Error end:
2016-06-14 17:02:11,134 INFO  [org.pentaho.platform.engine.core.system.status.PeriodicStatusLogger] Warning, one or more errors occurred during the initialization process.
2016-06-14 17:02:11,135 INFO  [org.pentaho.platform.engine.core.system.status.PeriodicStatusLogger] Warning, one or more errors occurred during the initialization process.
2016-06-14 17:02:11,867 ERROR [pt.webdetails.cdf.dd.CdeEngine] Error initializing CdeEngine: [ java.lang.NullPointerException ] - null
2016-06-14 17:02:12,074 INFO  [org.pentaho.platform.engine.core.system.status.PeriodicStatusLogger] Warning, one or more errors occurred during the initialization process.
2016-06-14 17:02:13,042 ERROR [org.pentaho.platform.util.logging.Logger] Error: Pentaho
2016-06-14 17:02:13,042 ERROR [org.pentaho.platform.util.logging.Logger] misc-org.pentaho.platform.engine.core.system.PentahoSystem: PentahoSystem.ERROR_0015 - Error while trying to execute shutdown sequence for org.pentaho.platform.plugin.services.pluginmgr.PluginAdapter
java.lang.IllegalStateException: Service already unregistered.
    at org.apache.felix.framework.ServiceRegistrationImpl.unregister(ServiceRegistrationImpl.java:123)
    at org.pentaho.platform.engine.core.system.objfac.OSGIRuntimeObjectFactory$OSGIPentahoObjectRegistration.remove(OSGIRuntimeObjectFactory.java:178)
    at org.pentaho.platform.plugin.services.pluginmgr.PentahoSystemPluginManager.unloadPlugins(PentahoSystemPluginManager.java:225)
    at org.pentaho.platform.plugin.services.pluginmgr.PentahoSystemPluginManager.unloadAllPlugins(PentahoSystemPluginManager.java:917)
    at org.pentaho.platform.plugin.services.pluginmgr.PluginAdapter.shutdown(PluginAdapter.java:47)
    at org.pentaho.platform.engine.core.system.PentahoSystem.shutdown(PentahoSystem.java:1075)
    at org.pentaho.platform.web.http.context.SolutionContextListener.contextDestroyed(SolutionContextListener.java:282)
    at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:4858)
    at org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5474)
    at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:224)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:159)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1092)
    at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1834)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
    at java.util.concurrent.FutureTask.run(FutureTask.java:262)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:745)
2016-06-14 17:02:13,042 ERROR [org.pentaho.platform.util.logging.Logger] Error end:
2016-06-14 17:02:13,634 INFO  [org.pentaho.platform.engine.core.system.status.PeriodicStatusLogger] Warning, one or more errors occurred during the initialization process.
2016-06-14 17:02:13,635 WARN  [org.pentaho.platform.web.http.context.PentahoSolutionSpringApplicationContext] Exception thrown from ApplicationListener handling ContextClosedEvent
java.lang.IllegalStateException: Service already unregistered.
    at org.apache.felix.framework.ServiceRegistrationImpl.unregister(ServiceRegistrationImpl.java:123)
    at org.pentaho.platform.engine.core.system.objfac.OSGIRuntimeObjectFactory$OSGIPentahoObjectRegistration.remove(OSGIRuntimeObjectFactory.java:178)
    at org.pentaho.platform.engine.core.system.objfac.spring.PublishedBeanRegistry$1.onApplicationEvent(PublishedBeanRegistry.java:125)
    at org.pentaho.platform.engine.security.event.OrderedApplicationEventMulticaster$2.run(OrderedApplicationEventMulticaster.java:87)
    at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
    at org.pentaho.platform.engine.security.event.OrderedApplicationEventMulticaster.multicastEvent(OrderedApplicationEventMulticaster.java:85)
    at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:334)
    at org.springframework.context.support.AbstractApplicationContext.doClose(AbstractApplicationContext.java:1051)
    at org.springframework.context.support.AbstractApplicationContext.close(AbstractApplicationContext.java:1012)
    at org.springframework.web.context.ContextLoader.closeWebApplicationContext(ContextLoader.java:586)
    at org.springframework.web.context.ContextLoaderListener.contextDestroyed(ContextLoaderListener.java:143)
    at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:4858)
    at org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5474)
    at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:224)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:159)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1092)
    at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1834)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
    at java.util.concurrent.FutureTask.run(FutureTask.java:262)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:745)


how to resolve it. help me out please
0 Kudos
Getting started

Tags

Find what you came for

We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.

Copyright © 2025 Khoros, LLC