shteng87

Anyone can help me...please

Hi all, After few weeks not login to Jasper Reports page, today when I open it can't load the welcome page, I has try many times stop/start the services or restart the pc still can't load the welcome page. Please help!!! Thank you.

Anyone can help? Thank you.

Anyone can help? Thank you.

Hi, My Jasper Report URL can't load after i try so many times to stop/start services So I decide to uninstall & install again, I has encounter this error message when try to install again, please help Error running C:Program Filesjasperreports-server-cp-4.5.0/postgresql/bin/psql.exe -U postgres -p 5432 -h localhost -c "ALTER USER postgres PASSWORD '****'" : psql: server closed the connection unexpectedly This probably means the server terminated abnormally --------------------------------------------------------------------------------------------------------------------------------------------------------------------- Code:Part of Error Log[15:24:49] Before running cacls[15:24:50] postgres_grantedPermissions = [15:24:50] postgres_deniedPermissions = [15:24:50] Running caclsExecuting cacls "C:Program Filesjasperreports-server-cp-4.5.0/postgresql/data" /e /c /t /p shine:cScript exit code: 0Script output: processed dir: C:Program Filesjasperreports-server-cp-4.5.0postgresqldataScript stderr: [15:24:56] cacls "C:Program Filesjasperreports-server-cp-4.5.0/postgresql/data" /e /c /t /p shine:c"[15:24:56] postgres_grantedPermissions = delete file_append_data file_execute file_generic_execute file_generic_read file_generic_write file_read_attributes file_read_data file_read_ea file_write_attributes file_write_data file_write_ea read_control standard_rights_execute standard_rights_read standard_rights_write synchronize[15:24:56] postgres_deniedPermissions = [15:24:56] Running setWindowsACL[15:24:56] postgres_grantedPermissions = delete file_append_data file_execute file_generic_execute file_generic_read file_generic_write file_read_attributes file_read_data file_read_ea file_write_attributes file_write_data file_write_ea read_control standard_rights_execute standard_rights_read standard_rights_write synchronize[15:24:56] postgres_deniedPermissions = [15:24:56] Initializing databaseExecuting vcredist_x64.exe /qScript exit code: 1603Script output: Script stderr: Program ended with an error exit codeError running vcredist_x64.exe /q : Program ended with an error exit codeExecuting initdb.exe -U postgres -E UTF8 -D C:/PROGRA~1/JASPER~1.0/POSTGR~1/dataScript exit code: 0Script output:Script stderr: [15:25:44] [15:25:44] [15:25:44] Database initialized OKExecuting C:Program Filesjasperreports-server-cp-4.5.0/postgresql/bin/registerservice.bat Script exit code: 0Script output:Script stderr:Executing cmd /C start /MIN /WAIT net start jasperreportsPostgreSQLScript exit code: 0Script output:Script stderr:[15:25:52] Wait for PostmasterWaiting for Postmaster[15:26:02] Port 5432 in useExecuting C:Program Filesjasperreports-server-cp-4.5.0/postgresql/bin/psql.exe -U postgres -p 5432 -h localhost -c "ALTER USER postgres PASSWORD '****'"Script exit code: 2Script output:Script stderr: psql: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.Error running C:Program Filesjasperreports-server-cp-4.5.0/postgresql/bin/psql.exe -U postgres -p 5432 -h localhost -c "ALTER USER postgres PASSWORD '****'" : psql: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.Executing sc stop jasperreportsPostgreSQLScript exit code: 0Script output: SERVICE_NAME: jasperreportsPostgreSQL TYPE : 10 WIN32_OWN_PROCESS STATE : 3 STOP_PENDING (STOPPABLE, PAUSABLE, ACCEPTS_SHUTDOWN) WIN32_EXIT_CODE : 0 (0x0) SERVICE_EXIT_CODE : 0 (0x0) CHECKPOINT : 0x0 WAIT_HINT : 0x2710Script stderr: Executing sc delete jasperreportsPostgreSQLScript exit code: 0Script output: [sC] DeleteService SUCCESSScript stderr: Cannot delete file C:/Program Files/jasperreports-server-cp-4.5.0/postgresql/dataCannot delete file C:/Program Files/jasperreports-server-cp-4.5.0/postgresqlExecuting sc stop jasperreportsTomcatScript exit code: 1060Script output: [sC] OpenService FAILED 1060:The specified service does not exist as an installed service.Script stderr: Program ended with an error exit codeError running sc stop jasperreportsTomcat : Program ended with an error exit codeExecuting sc delete jasperreportsTomcatScript exit code: 1060Script output: [sC] OpenService FAILED 1060:The specified service does not exist as an installed service.Script stderr: Program ended with an error exit codeError running sc delete jasperreportsTomcat : Program ended with an error exit code Post Edited by shteng87 at 07/23/2012 08:33

deleted Post Edited by shteng87 at 07/06/2012 03:07

Anyone can help?? pls

deleted Post Edited by shteng87 at 07/06/2012 03:07

deleted Post Edited by shteng87 at 07/06/2012 03:08

deleted Post Edited by shteng87 at 07/06/2012 03:09

deleted Post Edited by shteng87 at 07/06/2012 03:09

deleted Post Edited by shteng87 at 07/06/2012 03:09

anyone can help? thx

Hi all, I have been stuck in this issues few week already, appreciate if anyone can help due to my column (EngineCapacity) datatype in db is INT, and i need to display 'All' on top of drop down list, so my code at input controls is ------------------------------------------------------------------------------------------------------------------ Select CAST(EngineCapacity AS varchar(10)) AS 'EngineCapacity' from Abbyy inner join eDaftarOwnerDetail on Abbyy.EngineNo = eDaftarOwnerDetail.EngineNo UNION Select 'All' AS EngineCapacity; ------------------------------------------------------------------------------------------------------------------ and my report query is =================================== select DealerCode, Name, Region, FormNo, (sum(Piece149cc) + sum(Piece249cc) + sum(Piece250cc)) as TotalPieces, (sum(Amount149cc) + sum(Amount249cc) + sum(Amount250cc)) as TotalAmount, sum(Piece149cc) as Piece149cc, sum(Amount149cc) as Amount149cc, sum(Piece249cc) as Piece249cc, sum(Amount249cc) as Amount249cc, sum(Piece250cc) as Piece250cc, sum(Amount250cc) as Amount250cc, ActualSubmit, (ActualSubmit - (sum(Piece149cc) + sum(Piece249cc) + sum(Piece250cc))) as TotalReject from ( select a.DealerCode as DealerCode, a.FormNo as FormNo, a.ActualSubmit as ActualSubmit, CAST(EngineCapacity AS varchar(10)) AS EngineCapacity, b.Name as Name, b.Region as Region, d.Category as cate, d.EngineCapacityUpto as EngineCapacity1, case when c.EngineCapacity < '150' then count(1) else 0 end as Piece149cc, case when c.EngineCapacity < '150' then sum(d.Price) else 0.00 end as Amount149cc, case when (c.EngineCapacity >= '150' and c.EngineCapacity <= '249') then count(1) else 0 end as Piece249cc, case when (c.EngineCapacity >= '150' and c.EngineCapacity <= '249') then sum(d.Price) else 0.00 end as Amount249cc, Case when c.EngineCapacity >= '250' then count(1) else 0 end as Piece250cc, case when c.EngineCapacity >= '250' then sum(d.Price) else 0.00 end as Amount250cc from abbyy a INNER JOIN DealerMaster b on a.DealerCode = b.DealerCode INNER JOIN eDaftarOwnerDetail c on c.EngineNo = a.EngineNo INNER JOIN PriceStructureClaim d on d.Category = b.Category where d.EngineCapacityUpto = ( case when c.EngineCapacity <= '149' then 149 when c.EngineCapacity >= '150' and c.EngineCapacity <= '249' then 249 when c.EngineCapacity >= '250' then 250 end ) and (a.DealerCode = $P{DealerCode} or ($P{DealerCode} = 'All' and a.DealerCode != '')) and (b.Region = $P{Region} or ($P{Region} = 'All' and b.Region != '')) and (b.Category = $P{Category} or ($P{Category} = 'All' and b.Category != '')) and (c.ModelNo = $P{ModelNo} or ($P{ModelNo} = 'All' and c.ModelNo != '')) and (c.EngineCapacity = $P{EngineCapacity} or ($P{EngineCapacity} = 'All' and c.EngineCapacity != '')) and (a.ProcessingDate >= $P{startDate} and a.ProcessingDate <= $P{endDate}) group by a.DealerCode, a.FormNo, a.ActualSubmit , b.Name, b.Region, c.EngineCapacity, d.EngineCapacityUpto, d.Category, a.EngineNo)e group by DealerCode, Name, Region, FormNo, ActualSubmit; ====================================================== i have no idea how to convert int to string for code above when i select drop down list for EngineCapacity, value load from EngineCapacity db is work fine except 'All', i will get error 'null' or Error Messagecom.microsoft.sqlserver.jdbc.SQLServerException: Conversion failed when converting the varchar value 'All' to data type int. Error Tracecom.microsoft.sqlserver.jdbc.SQLServerException: Conversion failed when converting the varchar value 'All' to data type int. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:4853) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1781) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1034) at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:168) at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:99) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneResultSetDataSource.next(JRTimezoneResultSetDataSource.java:54) at net.sf.jasperreports.engine.fill.JRFillDataset.advanceDataSource(JRFillDataset.java:944) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:857) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:837) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1434) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:126) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:836) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:118) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:435) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:773) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:731) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:389) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeReport(EngineServiceImpl.java:890) at com.jaspersoft.jasperserver.api.engine.jasperreports.domain.impl.ReportUnitRequest.execute(ReportUnitRequest.java:57) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.execute(EngineServiceImpl.java:320) at com.jaspersoft.jasperserver.war.action.ViewReportAction.executeReport(ViewReportAction.java:499) at com.jaspersoft.jasperserver.war.action.ViewReportAction.executeReport(ViewReportAction.java:489) at com.jaspersoft.jasperserver.war.action.ViewReportAction.runReport(ViewReportAction.java:322) 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.springframework.webflow.action.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:98) at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:123) at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188) at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51) at org.springframework.webflow.action.EvaluateAction.doExecute(EvaluateAction.java:79) at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188) at org.springframework.webflow.execution.AnnotatedAction.execute(AnnotatedAction.java:145) at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51) at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:101) at org.springframework.webflow.engine.State.enter(State.java:194) at org.springframework.webflow.engine.Transition.execute(Transition.java:227) at org.springframework.webflow.engine.impl.FlowExecutionImpl.execute(FlowExecutionImpl.java:391) at org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214) at org.springframework.webflow.engine.TransitionableState.handleEvent(TransitionableState.java:119) at org.springframework.webflow.engine.Flow.handleEvent(Flow.java:555) at org.springframework.webflow.engine.impl.FlowExecutionImpl.handleEvent(FlowExecutionImpl.java:386) at org.springframework.webflow.engine.impl.RequestControlContextImpl.handleEvent(RequestControlContextImpl.java:210) at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:105) at org.springframework.webflow.engine.State.enter(State.java:194) at org.springframework.webflow.engine.Transition.execute(Transition.java:227) at org.springframework.webflow.engine.impl.FlowExecutionImpl.execute(FlowExecutionImpl.java:391) at org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214) at org.springframework.webflow.engine.Flow.handleEvent(Flow.java:560) at org.springframework.webflow.engine.impl.FlowExecutionImpl.handleEvent(FlowExecutionImpl.java:386) at org.springframework.webflow.engine.impl.RequestControlContextImpl.handleEvent(RequestControlContextImpl.java:210) at org.springframework.webflow.engine.ViewState.handleEvent(ViewState.java:230) at org.springframework.webflow.engine.ViewState.resume(ViewState.java:196) at org.springframework.webflow.engine.Flow.resume(Flow.java:545) at org.springframework.webflow.engine.impl.FlowExecutionImpl.resume(FlowExecutionImpl.java:259) at org.springframework.webflow.executor.FlowExecutorImpl.resumeExecution(FlowExecutorImpl.java:163) at sun.reflect.GeneratedMethodAccessor359.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.security.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy19.resumeExecution(Unknown Source) at org.springframework.webflow.mvc.servlet.FlowHandlerAdapter.handle(FlowHandlerAdapter.java:183) at org.springframework.webflow.mvc.servlet.FlowController.handleRequest(FlowController.java:174) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:399) at com.jaspersoft.jasperserver.api.security.IPadSupportFilter.doFilter(IPadSupportFilter.java:67) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.JSSwitchUserProcessingFilter.doFilterHttp(JSSwitchUserProcessingFilter.java:154) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:139) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:184) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:184) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.JSCsrfGuardFilter.doFilter(JSCsrfGuardFilter.java:81) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.WebAppSecurityFilter.doFilter(WebAppSecurityFilter.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.MultipartRequestWrapperFilter.doFilter(MultipartRequestWrapperFilter.java:90) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:188) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:558) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555) at java.lang.Thread.run(Thread.java:619)

Hi all, I have stuck with this issues as well, pls help me, urgent!! How to Add "Select All" to parameter lists in ireport??

Hi, I am facing this problem too. Urgently need this solution. if I want to display 'ALL' in the single select query at the top of other values which are being fetched from database using a query.And on selecting 'ALL' It should return records for all