alamuvinai

Hi, I am working with jasper 6.1.0 - the home page displays recently viewed items, popular resources, data sources, adhoc views, dashboards, domains, reports, admin etc when you login with http but when you go using the https url - homepage doesn't display any of the above items, it's just blank with the top menus. but once you navigate - running reports etc. works fine with https and http. why there is an issue with the home page display? thank you!

Having issues in display of the UI when clicking on "Create adhoc reports". Pop up is minimized and the icons are not displayed correctly. Jasper is build using the jasper source code. Not running IE in compatability mode. Also, tested in Chrome, it's the same issue. Can someone please give some suggestions how to fix the issue. thanks!

Hi, Initially I installed jasper 6.1 trial version in my local - used the trial license. After 30 days, it expired. We do have commercial license - when I copy this over to the users home directory, it says "License Failed Your license has expired. If you evaluated JasperReports Server and have just installed a new version of it, your evaluation license has expired. Please contact eval@jaspersoft.com for assistance" Can someone point out how to fix this issue? Using windows 7 and tomcat

I used ant build-ce, build-pro for war file. copied the war file to tomcat webapps directory; started the tomcat server. fyi: copied the license file that comes with the pro edition to the users directory under C; Can you please let me know what is missing here - is it license file or some other settings? thanks so much!

I am using pro edition 6.1, did a brand new install; did the build, deployed the war file; able to login fine as superuser; but unable to see the menu Manage > server settings? I need to import reports etc. from the previous jasper version. can someone please point out what is missing? Thanks, Alamu

had to run the dbscripts for oracle on top of jasper 5 db; then it fixed the above issue. thanks!

Hi All, I am trying to upgrade from version 5.6 to 6.1; made lot of customization code in 5.6; need to integrate those changes to 6.1; steps taken so far: 1) download 6.1 source code, built successfully; deployed war file in tomcat. if using post-gres sample db, able to login from UI. 2) but i've to use the oracle jasper db. right now using the oracle jasper 5.6 db that I've already. but getting error on tomcat start up. 3) How do I fix this error. I am trying to connect from jasper 6.1 source code to jasper5.6 database. 4) Is there any db script for oracle that needs to be run on oracle 5.6? Can someone please let me know ASAP? ORA-00904: "REPOPROFIL0_"."OWNER": invalid identifier org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'proOnStartPropagator' defined in ServletContext resource [/WEB-INF/applicationContext-onStart-web-pro.xml]: Invocatio n of init method failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select repoprofil0_.id as id12_, repoprofil0_.attrName as attrNam e12_, repoprofil0_.attrValue as attrValue12_, repoprofil0_.description as descript4_12_, repoprofil0_.owner as owner12_, repoprofil0_.principalobjectclass as principa6_12_, repoprofil0_.principalobjectid a s principa7_12_ from JIProfileAttribute repoprofil0_ where repoprofil0_.principalobjectclass=? and repoprofil0_.principalobjectid=?]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1514) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521)

Hi All, I am trying to upgrade from version 5.6 to 6.1; made lot of customization code in 5.6; need to integrate those changes to 6.1; steps taken so far: 1) download 6.1 source code, built successfully; deployed war file in tomcat. if using post-gres sample db, able to login from UI. 2) but i've to use the oracle jasper db. right now using the oracle jasper 5.6 db that I've already. but getting error on tomcat start up. 3) How do I fix this error. I am trying to connect from jasper 6.1 source code to jasper5.6 database. Can someone please let me know ASAP? ORA-00904: "REPOPROFIL0_"."OWNER": invalid identifier org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'proOnStartPropagator' defined in ServletContext resource [/WEB-INF/applicationContext-onStart-web-pro.xml]: Invocatio n of init method failed; nested exception is org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select repoprofil0_.id as id12_, repoprofil0_.attrName as attrNam e12_, repoprofil0_.attrValue as attrValue12_, repoprofil0_.description as descript4_12_, repoprofil0_.owner as owner12_, repoprofil0_.principalobjectclass as principa6_12_, repoprofil0_.principalobjectid a s principa7_12_ from JIProfileAttribute repoprofil0_ where repoprofil0_.principalobjectclass=? and repoprofil0_.principalobjectid=?]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1514) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521)

Hi, In addition to the above changes, modified the file jasperserver_config.properties file and added this line: report.scheduling.output.format.13=pipe Able to run the scheduled job output for pipe only once after the job is scheduled. On subsequent runs from the same job, pipe delimiter output doesnot show up. Is there any caching involved for this? Also, when run immediately, pipe delimiter doesn't output at all. Is there any other setting to be changed for this?

Custom checkbox in Scheduler Job UI: Requirement is to add a custom checkbox (Pipe) and when scheduleder is run, it should export txt file with pipe delimiter (very similar to csv output) added a custom check box (Pipe) in addition to the existing ones - Pdf, Csv, Excel, Docx etc - these code changes works fine viewReportBeans.xml reportJobBeans.xml ReportJob.java (added a constant for pipe with value of 13) jasperserver_messages.properties (for UI display) When scheduling the report to run (immediately or in interval), the pipe delimiter code (custom) is not picked up. For scheduler, made changes to applicationContext-report-scheduling.xml added customCode - PipeReportOutput.java added loggging in the CSVReportOutput, PipeReportOutput, and other reportOutput classes; when the scheduled job is run, there is no logging output from any of these files. (including CSVReportOutput) But the job runs fine and able to see the report output in the path specified. (not for pipe delimiter though) Can someone please share your ideas of what files to be modified so that scheduler picks up this custom code when exporting? FYI: applicationContext-adhoc.xml changes (very similar to csvExport but with pipe delimiter and txt extension, so using csvExportParameters as parent): bean id="jobPipeExportParameters" parent="csvExportParameters" .. util:map id="jobExportParametersMap" entry key="pipe" value-ref="jobPipeExportParameters" .. util:map id="outputKeyMapping" entry key="13" value="pipe" .. bean id="pipeOutput" class="com.jaspersoft.jasperserver.api.engine.scheduling.quartz.PipeReportOutput" property name="exportParams" ref="jobPipeExportParameters" bean .. util:map id="outputFormatMap" entry key="pipe" value-ref="pipeOutput" PipeReportOutput.java public class PipeReportOutput extends AbstractReportOutput { private CsvExportParametersBean exportParams; ........ ...... public ReportOutput getOutput( EngineService engineService, ExecutionContext executionContext, String reportUnitURI, DataContainer csvData, JRHyperlinkProducerFactory hyperlinkProducerFactory, RepositoryService repositoryService, JasperPrint jasperPrint, String baseFilename, Locale locale, String characterEncoding) throws JobExecutionException { try { System.out.println("pipe getOutput method entry ** "); JRCsvExporter exporter = new JRCsvExporter(); exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); boolean close = false; OutputStream csvDataOut = csvData.getOutputStream(); try { exporter.setParameter(JRExporterParameter.CHARACTER_ENCODING, characterEncoding); exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, csvDataOut); if(exportParams != null) exporter.setParameter(JRCsvExporterParameter.FIELD_DELIMITER, "|"); exporter.exportReport(); close = false; csvDataOut.close(); String fileName = baseFilename + ".txt"; return new ReportOutput(csvData, ContentResource.TYPE_CSV, fileName); } catch (IOException e) { throw new JSExceptionWrapper(e); } finally { if (close) { try { csvDataOut.close(); } catch (IOException e) { log.error("Error closing stream", e); } } } } catch (JRException e) { throw new JSExceptionWrapper(e); } }

Hi, Requirement is to add a new checkbox (pipe delimiter output) to the existing output formats. (html, csv, pdf etc). I am able to make the changes to UI by modifying the jsp and properties file. But when the actual report is run by the scheduler, unable to produce the new report output (pipe delimiter). Modified the following files to achieve this: applicationContext-report-scheduling.xml added new custom class and added the bean in the above xml, but still jasper doesn't invoke the custom code. Can someone please share your ideas on how to achieve this?

Hi, Tried the above, but it still doesn't work. Can anyone please give more inputs on this?

Hi, I've to ouput the csv with pipe delimeter instead of ",". changed this value in applicationContext.xml, but still the output when the report runs is "," delimited. It should open without any columns/rows, but just data with "|" delimiter. Can someone please let me know how to do this? Thanks

change your location from http://jasperforge.org/svn/repos/maven2 to http://code.jaspersoft.com/svn/repos/maven2 so that jasperserver builds correctly.

hi, thanks so much for the response code.jaspersoft.com/svn/repos requires authorization. The error above is during the build process "ant build-ce build-pro" during the build process, building jasperserver points to http://jasperforge.org/svn/repos/maven2, can you please point out which file to modify to use the updated url - so that the build would be success?

hi, code.jaspersoft.com/svn/repos requires authorization. The error above is during the build process "ant build-ce build-pro" during the build process, building jasperserver points to http://jasperforge.org/svn/repos/maven2, can you please point out which file to modify to use the updated url - so that the build would be success?

Hi, Can anyone please help to resolve the following build error issue? Was able to build the japserserver without any issues until last Tuesday, 11/20. Since 11/21 unable to do the build with this error: http://jasperforge.org/svn/repos/maven2 unavailable. Is there a way to tell maven to not look in that URL? Error: (java) (ERROR) Failed to execute goal on project jasperserver-war: Could not resolve dependencies for project com.jaspersoft.jasperserver:jasperserver-war:war:4.7.1: Failed to collect dependencies for [com.jaspersoft.jasperserver:jasperserver-war-jar:jar:4.7.1 (compile), com.jaspersoft.jasperserver:jasperserver-export-tool:jar:4.7.1 (compile), com.jaspersoft.jasperserver:jasperserver-ws-server:jar:4.7.1 (compile), com.jaspersoft.jasperserver:jasperserver-search:jar:4.7.1 (compile), com.jasperso ework:spring-core:jar:3.1.0.RELEASE (compile), org.springframework:spring-beans:jar:3.1.0.RELEASE (compile), org.springframework:spring-tx:jar:3.1.0.RELEASE (compile), org.springframework:spring-context:jar:3.1.0.RELEASE (compile), org.springframework.ldap:spring-ldap-core:jar:1.3.0.RELEASE (compile), org.springframework.ldap:spring-ldap-core-tiger:jar:1.3.0.RELEASE (compile), org.springframework.security:spring-security-cas-client:jar:2.0.7.RELEASE (compile), org.hibernate:hibernate-jmx:jar:3.3.2.G ar:2.2 (compile), commons-net:commons-net:jar:3.1 (compile), org.easymock:easymock:jar:3.0 (test), com.jaspersoft.jasperserver.api.metadata.impl:jasperserver-repository-hibernate:jar:4.7.1 (compile), net.sf.jasperreports:jasperreports-fonts:jar:4.5.0 (compile), net.sf.jasperreports:jasperreports-chart-themes:jar:4.7.0 (compile), net.sf.jasperreports:jasperreports-ofc:jar:4.7.0 (compile), org.apache.velocity:velocity:jar:1.7 (compile), iReport:iReport-utils:jar:2.0.1 (compile), rhino:js:jar:1.7R1 (ru ve:hive-service:jar:0.8.1 (compile), org.apache.hive:hive-exec:jar:0.8.1 (compile), org.apache.thrift:libfb303:jar:0.7.0 (compile), org.slf4j:slf4j-api:jar:1.6.1 (compile), org.slf4j:slf4j-log4j12:jar:1.6.1 (compile), junit:junit:jar:4.8.1 (test), commons-logging:commons-logging:jar:1.0.4 (compile)]: Failed to read artifact descriptor for org.apache.hadoop:hadoop-core:jar:0.20.1: Could not transfer artifact org.apache.hadoop:hadoop-core:pom:0.20.1 from/to JasperForge Maven Repository (http://jasperf (java) (ERROR) (java) (ERROR) To see the full stack trace of the errors, re-run Maven with the -e switch. (java) (ERROR) Re-run Maven using the -X switch to enable full debug logging. (java) (ERROR) (java) (ERROR) For more information about the errors and possible solutions, please read the following articles: (java) (ERROR) [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/DependencyResolutionException (java) (ERROR) (java) (ERROR) After correcting the problems, you can resume the build with the command (java) (ERROR) mvn -rf :jasperserver-war