shankarpanda003

I am facing some little issue with JRS5.I have installed JRS on Redhat Linux environment. When i click on change password link it gives two field to enter password and confirm password(re type password) , but when i am giving two different values ,it does not show any error like password doesnt match and any thing like that. rather it changes the password as per the first filed value.

I ma using hive and mysql as metastore db.how can i connect to hive through ireport.When i am giving jdbc:hive://localhost:10000/default,,it is prompting as connection refused.irt was working file untill i had not used mysql as metastore for hive.Please suggest what to do.

Hi Matt...I am getting some problem. when i am running hive server from root i mean when my present working directory is root then only i am able to establish the connection between ireport and hive and also i am not able to execute any query in hive cli which runs in root directory but it runs if i start the hive cli from hive installed direcory.Please help where i am doing wrong?

Hive is running fine untill and unless hive connection established in ireport.when i am not connected to ireport ,i can create ,load and everything i can do in hive shell.But i connect to ireport ,i am getting error in hive shell.error is like hive> show tables;FAILED: Error in metadata: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClientFAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask Anyone has any idea about this?Thnaks for the help :)

Its solved. :)

Your database must have been there at cloud,so Its best practice to run iReport on cloud and compile your report there and upload the jrxml file directly onto the server or through iReport...

Hi Anu,Your aws is running on which platform ,i mean its windows or linux?there you must have installed jasperReport server.If u cant find ireport there u can download and run there.

My script is like this but i am not able to load the data successfully#!/bin/bash> bin/hive> load data local inpath '/usr/local/hadoop_dir/hadoop/input/sample.txt'> overwrite into table sample;> exit;[/code]can anyone help me on this?

I am using Hive-0.10.0.i have created a table account create table account(id int,city_id int,name string,address string) >row format delimited >fields terminated by ','; table is created successfully in hive and i have loaded the local csv file into that load data local 'path/account.csv' into table account; and i can also anle to see those records who has been created but when i am connecting to hive trough ireport and in the report query when i am writing select * from account,it says Error:error executing sql statement for null though it is showing correctly on hive cell. Please Help

Thanks Marianol. It is solved.Actually before connecting to hive from ireport,first i had to set the hive port=10000 and i should have to start the hiveserver.Thats why that error was coming.And yes it should be localhost instead of HOST

When I am giving localhost also,,it is saying connection refused.Dont know what to do.

My hadoop version is 1.1.1 and so i am using hadoop-0.9.0.I am not able to establish the connection to hive through ireport. iam getting this error.CCan anyone help me out?

Successfully done the installation of hadoop but while compiling hive getting this error repeatedly. Logging initialized using configuration in jar:file:/install/hive-0.8.0-bin/lib/hive-common-0.8.0.jar!/hive-log4j.properties Hive history file=/tmp/root/hive_job_log_root_201301092207_549512300.txt Exception in thread "main" java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: java.lang.RuntimeException: Could not load shims in class null at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:277) at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:603) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:554) 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.hadoop.util.RunJar.main(RunJar.java:192) Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: java.lang.RuntimeException: Could not load shims in class null at org.apache.hadoop.hive.ql.metadata.HiveUtils.getAuthenticator(HiveUtils.java:225) at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:270) ... 7 more Caused by: java.lang.RuntimeException: java.lang.RuntimeException: Could not load shims in class null at org.apache.hadoop.hive.ql.security.HadoopDefaultAuthenticator.setConf(HadoopDefaultAuthenticator.java:53) at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:70) at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:125) at org.apache.hadoop.hive.ql.metadata.HiveUtils.getAuthenticator(HiveUtils.java:222) ... 8 more Caused by: java.lang.RuntimeException: Could not load shims in class null at org.apache.hadoop.hive.shims.ShimLoader.createShim(ShimLoader.java:102) at org.apache.hadoop.hive.shims.ShimLoader.loadShims(ShimLoader.java:94) at org.apache.hadoop.hive.shims.ShimLoader.getHadoopShims(ShimLoader.java:65) at org.apache.hadoop.hive.ql.security.HadoopDefaultAuthenticator.setConf(HadoopDefaultAuthenticator.java:51) ... 11 more Caused by: java.lang.NullPointerException at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:169) at org.apache.hadoop.hive.shims.ShimLoader.createShim(ShimLoader.java:99) ... 14 more Can anyone suggest me on this.

[java] Creating ActionModelService object. [java] Creating action model infrastructure. [java] Creating action model infrastructure. [java] Creating action model infrastructure. BUILD FAILED/usr/games/jasperreports-server-cp-4.7.0-bin/buildomatic/bin/db-common.xml:759: The following error occurred while executing this line:/usr/games/jasperreports-server-cp-4.7.0-bin/buildomatic/bin/import-export.xml:270: The following error occurred while executing this line:/usr/games/jasperreports-server-cp-4.7.0-bin/buildomatic/bin/import-export.xml:158: Java returned: 137 if anyone has came across it or anyone do have idea,,please help me

i am also facing the same problem.how did u resolve that.can u tell briefly?

i am also facing same problem.but in my case it is:java returnes 137. can anyone help me in this

i have made changes in the default_master.properties and uncommented CATALINA_HOME AND CATALINA_BASE.when i am running the script js-install-ce.sh,following error is occuring. BUILD FAILED/bin/jasperreports-server-cp-4.7.0-bin/jasperreports-server-cp-4.7.0-bin/buildomatic/bin/setup.xml:808: The following error occurred while executing this line:/bin/jasperreports-server-cp-4.7.0-bin/jasperreports-server-cp-4.7.0-bin/buildomatic/bin/validation.xml:319: The following error occurred while executing this line:/bin/jasperreports-server-cp-4.7.0-bin/jasperreports-server-cp-4.7.0-bin/buildomatic/bin/validation.xml:335: Error: appServerDir property is not set what i need to do?Please Help

Hi Everyone, I am doing the JRF WAR file installation with mysql as database on ubuntu. I have follwed the document but i having the issue like jdbc driver is not setup correctly.what i need to do.Can anyone please help me over this issue.

Anyone can please tell what should i do about this issue,,which css file i need to change.

In file "apache-tomcat/webapps/jasperserver/WEB-INF/classes/esapi/security-config.properties" we have to Update "encryption.on=false" to "encryption.on=true".Then restart japerserver.

i have also found the same way to reslove this issue.Its really grt.So nice discovery.even jaspersoft employees also could not have answered.and they had said me that,,it cant be resolved in this version 4.7,,you please wait for next release.

I have rebranded JasperReport Server.It is working fine in mozilla and chrome.But it doesnt take fully effect in Internet Explorer.Which css file i need to change.

Log Out the page button is not functioning properly when i am drilling through the Mondrian report (Foodmart Sample Analysis View).I have installed JasperReports Server at cloud.It is working fine at cloud.But when i m accessing the report using the url in some other machine,i am facing problem.At cloud i have turned off the windows firewall,but still not able to logout from the page when drilling through Mondrian report.please help me.

Log Out the page button is not functioning properly when i am drilling through the Mondrian report (Foodmart Sample Analysis View).I have installed JasperReports Server at cloud.It is working fine at cloud.But when i m accessing the report using the url in some other machine,i am facing problem.At cloud i have turned off the windows firewall,but still not able to logout from the page when drilling through Mondrian report.please help me.

Yes really it is so needed for the customer.And what i got the reply,this cant be fixed and we have to wait for next version release and that will be on december.