AnsweredAssumed Answered

Problem in pentaho AAAR tool

Question asked by alfresco_shaikh on Sep 8, 2014
Latest reply on Jun 16, 2016 by sandeepreddy1
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: jdbc:postgresql://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)

Outcomes