shreecs

Hi, I was using Jaspersoft Studio professional 5.5 edition on windows machine 64 bit. Now it's license is expired. 1) So how can i renew this license. Does renewal of the license costs or it's free one? 2) Also let me know the procedure to get the license and install the license? Thanks

Hi, I'm connecting to Hive database and creating reports in Jaspersoft studio 5.5. Here i'm joining 2 tables and creating a pie chart which is working fine. But i'm not able to see the value on keeping mose over the chart.Even i have checked "show tooltip" in the chart properties. So what might be the problem? Do i need to make any more setting in chart properties to view the tooptip on mouse over? Below is the source code for the chart <summary> <band height="379" splitType="Stretch"> <componentElement> <reportElement x="30" y="20" width="310" height="240" uuid="516c366b-d126-4b38-b60a-3bdcbdba59ce"/> <hc:chart xmlns:hc="http://jaspersoft.com/highcharts" xsi:schemaLocation="http://jaspersoft.com/highcharts http://jaspersoft.com/schema/highcharts.xsd" type="Pie"> <hc:hyperlink> <hyperlinkTooltipExpression><![CDATA[$F{order_id}]]></hyperlinkTooltipExpression> </hc:hyperlink> <hc:chartSetting name="default"> <hc:chartProperty name="chart.showAxes"> <hc:propertyExpression><![CDATA[boolean.TRUE]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="chart.zoomType"> <hc:propertyExpression><![CDATA["xy"]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="credits.enabled"> <hc:propertyExpression><![CDATA[false]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="credits.href"> <hc:propertyExpression><![CDATA[""]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="credits.text"> <hc:propertyExpression><![CDATA[""]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="plotOptions.pie.showInLegend" value="true"/> <hc:chartProperty name="title.text"> <hc:propertyExpression><![CDATA[""]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="tooltip.shared"> <hc:propertyExpression><![CDATA[boolean.FALSE]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="tooltip.useHTML"> <hc:propertyExpression><![CDATA[boolean.FALSE]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="tooltip.valuePrefix"> <hc:propertyExpression><![CDATA["$F{customer_desc}"]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="tooltip.valueSuffix"> <hc:propertyExpression><![CDATA["$F{customer_desc}"]]></hc:propertyExpression> </hc:chartProperty> <hc:chartProperty name="yAxis.title.text"> <hc:propertyExpression><![CDATA[""]]></hc:propertyExpression> </hc:chartProperty> </hc:chartSetting> <multiAxisData> <multiAxisDataset/> <dataAxis axis="Rows"> <axisLevel name="CUSTOMER_DESC"> <labelExpression><![CDATA["Level Label expression"]]></labelExpression> <axisLevelBucket class="java.lang.String"> <bucketExpression><![CDATA[$F{customer_desc}]]></bucketExpression> </axisLevelBucket> </axisLevel> </dataAxis> <multiAxisMeasure name="Total Orders" class="java.lang.Integer" calculation="Count"> <labelExpression><![CDATA["Total Orders"]]></labelExpression> <valueExpression><![CDATA[$F{order_id}]]></valueExpression> </multiAxisMeasure> </multiAxisData> <hc:series name="Measure1"/> <hc:series name="Total Orders"/> </hc:chart> </componentElement> </band> </summary> Please help in this regard. Thanks in advance, ShreeCS

Hi, After adding the Groovy-all.2.2.0 jar into the lib folder of jasperstudio i m able to preview the report but when i publish the report on JasperReport server 5.5 it its giving an error "java.lang.reflect.InvocationTargetException". How to resolve this issue?

Hi , I have installed Jasperstudio 5.5 professional edition and JasperReport Server 5.5 evaluation edition on 2 windows machines,both are 64bit machines. I created Hive connection in JaspersoftStudio and created a report(.jrxml file) and able to preview the report sucessfully on one windows machine. The same thing i tried on the other windows machine as well i.e., i created Hive connection and created a .jrxml file, but when i preview the report it's giving me an error "java.lang.NoClassDefFoundError: org/codehaus/groovy/runtime/callsite/CallSiteArray". Below is the error detail: java.lang.NoClassDefFoundError: org/codehaus/groovy/runtime/callsite/CallSiteArray at orderReport_1390897832410_691952.$createCallSiteArray(calculator_orderReport_1390897832410_691952) at orderReport_1390897832410_691952.$getCallSiteArray(calculator_orderReport_1390897832410_691952) at orderReport_1390897832410_691952.__$swapInit(calculator_orderReport_1390897832410_691952) at orderReport_1390897832410_691952.<clinit>(calculator_orderReport_1390897832410_691952) 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.newInstance(Unknown Source) at net.sf.jasperreports.engine.design.JRAbstractJavaCompiler.loadEvaluator(JRAbstractJavaCompiler.java:112) at net.sf.jasperreports.engine.design.JRAbstractCompiler.loadEvaluator(JRAbstractCompiler.java:340) at net.sf.jasperreports.engine.JasperCompileManager.getEvaluator(JasperCompileManager.java:265) at net.sf.jasperreports.engine.fill.JRFillDataset.createCalculator(JRFillDataset.java:462) at net.sf.jasperreports.engine.fill.JRBaseFiller.<init>(JRBaseFiller.java:382) at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:88) at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:103) at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:61) at net.sf.jasperreports.engine.fill.JRFiller.createFiller(JRFiller.java:179) at net.sf.jasperreports.engine.fill.BaseFillHandle.<init>(BaseFillHandle.java:75) at net.sf.jasperreports.engine.fill.AsynchronousFillHandle.<init>(AsynchronousFillHandle.java:98) at net.sf.jasperreports.engine.fill.AsynchronousFillHandle.<init>(AsynchronousFillHandle.java:87) at net.sf.jasperreports.engine.fill.AsynchronousFillHandle.createHandle(AsynchronousFillHandle.java:189) at com.jaspersoft.studio.editor.preview.view.control.ReportControler$4.run(ReportControler.java:344) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54) Caused by: java.lang.ClassNotFoundException: org.codehaus.groovy.runtime.callsite.CallSiteArray at java.lang.ClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) ... 24 more When i google this error they are saying to replace groovy-all-2.0.0.jar with groovy-all-2.2.0.jar . Does it really solve my problem? If it is really because of the groovy jar version ,how it is working fine on the other machine? Please help me regarding this. Thanks in advance ShreeCS

Does it supports MapR Hadoop ?

Hi, I was using JasperReport Server 5.5 and Jaspersoft studio 5.5 to create reports on Apache hadoop 1.1.1 and i was able to craete reports on apache hadoop data.Also i think jaspersoft supports Cloldera,if yes please let me know which versions of clouldera it supports. Now i wanted to use jaspersoft with MapR Hadoop.Does it supports mapR Hadoop distribution,if yes please let me know which are the versions it supports?

Hi Abroitman, For my Hive database authentication is required .So which email i should use to get the new beta connector from you as i did not see any email. Also one more thing is , my JasperReport server 5.5 evaluation edition and JasperStudio 5.5 professional license has come to an end.So where should i contact to extend it so that i can further use jaspersoft. Does it cost? So help and guide me in this regard. Thanks, ShreeCS

Hi Abroitman, So now in the existing hive connection how it can be achieved if not can not work with Hive connection because my hadoop services will stop once i establish the haive connection from Jaspersoft Studio 5.5. Thank you, ShreeCS

hi, I have installed Jaspersoft Studio 5.5 and JasperReport Server 5.5 on windows 64 bit machine. I have created Hive Connection to access the hadoop(HDFS) datas from Jaspersoft Studio.After the Hive connection creation i'm able to access the hive tables from jaspersoft Studio. Also i have created report(.jrxml file) on hive tables and published the report on JasperReport Server as well which is working fine and able see the reports as well from the Report server. But the problem is on my hadoop side,if i check the namenode log it says " ERROR org.apache.hadoop.security.UserGroupInformation: PriviledgedActionException as:webuser cause:org.apache.hadoop.security.AccessControlException: Permission denied: user=webuser, access=READ_EXECUTE, inode="system":hduser:supergroup:rwx". I think this error is due to jaspersoft Hive connection because when we create "HIve Connection" from jaspersoft studio, it does not ask Username and Password for hadoop.That's why in namenode log it says "Permission Denied for Web user" and at the end my Hadoop stops running So tell me how this can be solved .i.e., how can we specify the username and password while creating Hive connection fron Jaspersoft Studio 5.5? Thanks in Advance, ShreeCS

Hi ilona, Yes it's a new installation. I'm able to connect to the Hadoop-Hive data source connection.When i changed hive default metastore to mysql solved the problem.

Hi rmiller, As you said ,i have created Hadoop-Hive data source on server and pointed the published report to it but still when i open the published report on server it's saying "Report is Empty". What to be done to solve this issue?

Hi, I have created Hadoop-Hive connection in Jaspersoft Studio 5.5 and created one sample report.When i run the report on studio i'm able to see the report(selected fields and values). Also published the report on JasperReport Server 5.5 and got the "successfully published" message. When i open the published report on JasperReport Server getting "Record is Empty" . While publishing the report i have choosen "Don't use any Data Source" option in the Configure Data Source wizard. Why i'm not able to see the published report ? Is it because of the above option. Please suggest the solution. Thanks in Advance. Shree

Hi, i'm trying to conncet to Hadoop-Hive connection from Jaspersoft Studio 5.5 proffesional edition. So I have done " New Data Adapter > Database JDBC Connection > Hadoop_Hive Connection ". Once i test the connection i'm getting the error " Unable to connect to repository http://jasperstudio.sf.net/jssproductrepo_5_1_x_PRO/content.xml". I have not added any Hadoop hive jars externally to the jaspersoft studio 5.5.My Apache hadoop and Hive are running properly. Also Thrift server is also running properly. Below is the Exception stack trace related to the above error java.net.ConnectException: Connection timed out: connect at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method) at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source) at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source) at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source) at java.net.AbstractPlainSocketImpl.connect(Unknown Source) at java.net.PlainSocketImpl.connect(Unknown Source) at java.net.SocksSocketImpl.connect(Unknown Source) at java.net.Socket.connect(Unknown Source) at org.eclipse.ecf.provider.filetransfer.events.socket.SocketEventCreateUtil.createSocket(SocketEventCreateUtil.java:43) at org.eclipse.ecf.internal.provider.filetransfer.httpclient.ECFHttpClientProtocolSocketFactory.createSocket(ECFHttpClientProtocolSocketFactory.java:81) at org.eclipse.ecf.internal.provider.filetransfer.httpclient.ECFHttpClientProtocolSocketFactory.createSocket(ECFHttpClientProtocolSocketFactory.java:73) at org.eclipse.ecf.internal.provider.filetransfer.httpclient.ECFHttpClientProtocolSocketFactory.createSocket(ECFHttpClientProtocolSocketFactory.java:65) at org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:707) at org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$HttpConnectionAdapter.open(MultiThreadedHttpConnectionManager.java:1361) at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:387) at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171) at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397) at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:346) at org.eclipse.ecf.provider.filetransfer.httpclient.HttpClientFileSystemBrowser.runRequest(HttpClientFileSystemBrowser.java:232) at org.eclipse.ecf.provider.filetransfer.browse.AbstractFileSystemBrowser$DirectoryJob.run(AbstractFileSystemBrowser.java:69) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)[/code]Please help me in this regard.What can be done to solve the above error? Thanks in advance Shree

Hi, I'm using Jaspersoft Studio 5.5 professional edition on 64bit windows machine.Also i have installed JasperReport Server 5.5 on the same machine. Now i wanted to create Hive connection form jaspersoft studio 5.5. To achieve this do we need to add hadoop hive jars externally to the studio or by default studio 5.5 provides these jars? If yes, where and how to add these jars into the jaspersoft studio 5.5 ? Thanks in Advance ShreeCS

Hi, I have installed Jaspersoft studio 5.5 professional edition and JasperReport Server 5.5 enterprise evaluation edition on the same machine(64bit windows machine). Now i wanted to create reports on hadoop data using hive as a connector. So in Jaspersoft Studio , i have chosen Hive Connection to create new Data Adapter and specified URL as jdbc:hive://172.20.30.84:10000/default (my hive is installed on remote machine) When i test the connection it stops there itself i.e, it doesn't proceed further to finish and save the hive connection. On my remote machine my Thrift Server is running properly. I'm using jdk 1.6 and eclipse 4.3.0 version. What could be the problem ? How to overcome this problem ? Thanks in advance Shreecs