[Export Issue]

Hi All, 

when i am exporting to Excel its working fine. but for same set of records if i export to csv . i am getting the following error. 

 

com.jaspersoft.jasperserver.api.JSException: Error filling report

at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$FillResultListener.reportFillError(EngineServiceImpl.java:1266)

at net.sf.jasperreports.engine.fill.BaseFillHandle.notifyError(BaseFillHandle.java:210)

at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:134)

at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:890)

at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:164)

at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1808)

at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousReportFiller.fillReport(EngineServiceImpl.java:794)

at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1735)

at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1090)

at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1019)

at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:912)

at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:890)

at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:607)

at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeReportUnitRequest(EngineServiceImpl.java:1941)

at com.jaspersoft.jasperserver.api.engine.jasperreports.domain.impl.ReportUnitRequest.execute(ReportUnitRequest.java:67)

at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.execute(EngineServiceImpl.java:493)

at sun.reflect.GeneratedMethodAccessor641.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:497)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:80)

at com.jaspersoft.ji.license.LicenseCheckAspect.runReport(LicenseCheckAspect.java:139)

at sun.reflect.GeneratedMethodAccessor640.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:497)

at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621)

at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610)

at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:65)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)

at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

at com.sun.proxy.$Proxy65.execute(Unknown Source)

at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.runReport(ReportExecutionJob.java:776)

at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeReport(ReportExecutionJob.java:741)

at com.jaspersoft.ji.report.options.engine.ReportOptionsExecutionJob.executeReport(ReportOptionsExecutionJob.java:140)

at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeReport(ReportExecutionJob.java:630)

at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:468)

at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:236)

at com.jaspersoft.ji.report.options.engine.ReportOptionsExecutionJob.execute(ReportOptionsExecutionJob.java:49)

at org.quartz.core.JobRunShell.run(JobRunShell.java:213)

at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)

Caused by: net.sf.jasperreports.governors.MaxPagesGovernorException: Report "TD Non Financial Extract" exceeded the limit of 1,000 maximum pages.

at net.sf.jasperreports.governors.MaxPagesGovernor.afterPageInit(MaxPagesGovernor.java:70)

at net.sf.jasperreports.engine.fill.JRFillDatasetScriptlet.afterPageInit(JRFillDatasetScriptlet.java:114)

at net.sf.jasperreports.engine.JRAbstractScriptlet.callAfterPageInit(JRAbstractScriptlet.java:225)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillPageBreak(JRVerticalFiller.java:1914)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBreak(JRVerticalFiller.java:1953)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:731)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:282)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:126)

at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:551)

at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:119)

... 41 more

 

please Help on this 

 

Regards,

Harish. 

 

 

 

[cross tab data is not moving in jasper server]

I Developed one report using cross tab component. while viewing the report output in jasper server only columns are moving but not data.

could Any one suggest on these issue.

Regards,

Harish

  

[unable to cast from java.lang.integer to java.lang.bigdecimal]

when i am running the report with stored procedure report is running fine. in that  report there are several expressions.

due to performance issues i converted sp to sql code , now same code when i am running in jaspersoft studio , while reading the fields its showing an error

 

Error: cannot cast from java.lang.integer to java.lang.bigdecimal.

please suggest me any one

 

Best Regards,

Harish.

 

[invalid column index]

when i am running SQL Query in oracle database is working fine. same query when i am executing in jasper soft studio i am getting invalid column index.

 

please suggest me any one.

 

Best Regards,

Harish.

[unable to get next record]

when i am executing sql statement for some parameters the report is running fine , and for other parameters sometimes the report is running in jasper server  and some times its giving an error called

"unable to get next record".

could any one suggest  me.

Regards,

Harish.

[i am facing unable to get next record error while executing my sql statement.]

when i am running report from strored procedure its working fine. for the same report from sql statment its shows an error unable to get next record.

could any one suggest me.

 

Regards,

Harish.

[wrap text in a report with iReport Designer 5.1.0]

Hi guys,

 wrapping  text in jaspersoft studio.

select all rows and set properities :

Set position type of the field to "float"
- Set stretch type to "Relative to Band height"
- Turn stretch with overflow on (True).

Regards,

Harish