rossi_jeff

this is ruby, but hopefully it applies to whatever you are using data[:trigger] = {} data[:trigger][:calendarTrigger] = {} data[:trigger][:calendarTrigger][:timezone] = user_time_zone data[:trigger][:calendarTrigger][:hours] = scheduled_report.hour data[:trigger][:calendarTrigger][:minutes] = scheduled_report.minutes data[:trigger][:calendarTrigger][:startType] = 1 if ScheduledReport::FREQUENCIES[scheduled_report.frequency] == "Monthly" data[:trigger][:calendarTrigger][:daysType] = 'MONTH' data[:trigger][:calendarTrigger][:monthDays] = scheduled_report.month_day elsif ScheduledReport::FREQUENCIES[scheduled_report.frequency] == "Quarterly" data[:trigger][:calendarTrigger][:daysType] = 'ALL' data[:trigger][:calendarTrigger][:monthDays] = 1 else data[:trigger][:calendarTrigger][:daysType] = 'WEEK' data[:trigger][:calendarTrigger][:weekDays] = {} data[:trigger][:calendarTrigger][:weekDays][:day] = [] CALENDAR_TRIGGER_DAYS.each do |weekday,number| if scheduled_report.on?(weekday) data[:trigger][:calendarTrigger][:weekDays][:day] << number.to_s end end end data[:trigger][:calendarTrigger][:months] = {} data[:trigger][:calendarTrigger][:months][:month] = [] if ScheduledReport::FREQUENCIES[scheduled_report.frequency] == "Quarterly" [1,4,7,10].each do |month| data[:trigger][:calendarTrigger][:months][:month] << month.to_s end else for month in (1..12).to_a data[:trigger][:calendarTrigger][:months][:month] << month.to_s end end

I have been using jasper server for a few years. We have several hundred reports and several thousand users all using older version of api with soap scheduling that has been deprecated. Basically every single scheduled report uses calendarTrigger. I have been trying to migrate our reports to use a new version of jasper server and do the scheduling with rest using json data. I have seen nearly all the errors the server can generate. Does anyone have a application/job+json sample of a job description using calendarTrigger with multiple weekDays and months Thanks, A very desperate developer

We have around 1B records in our readings table and have reached a point where we might have to shard our databse, where accounts would be separated between shards. Accounts have many devices, each of which has many readings. I currently have hundreds of existing jasper reports all accessing the single database. Once i shard the database all thos reports will be broken, how do i pass the shard to use to the report. Does anyone have any relevent experience?

I have several hundred reports with names like geofence-multi and stops-jobs, the new version of jaspersoft studio has started removing the - which is COMPLETELY UNACCEPTIBLE how do i revert to the old and proper behavior of keeping wht I typed.

Anybody? I'd really like to use the scheduling on the jasper server instead of requesting at specific times from a rails daemon. This is something that really SHOULD be documented in the guides. Thanks, Jeff

I have webservices running on my server connecting to jasper server but scheduled reports are sent at the wrong time. <calendarTrigger xsi:type="ns1:JobCalendarTrigger"> <timezone>Eastern Time (US & Canada)</timezone> <hours>8</hours> <minutes>0</minutes> <daysType>WEEK</daysType> <weekDays xsi:type="ns1:ArrayOf_xsd_int"> <weekDays xsi:type="xsd:int">2</weekDays> </weekDays> <months xsi:type="ns1:ArrayOf_xsd_int"> <months xsi:type="xsd:int">0</months> <months xsi:type="xsd:int">1</months> <months xsi:type="xsd:int">2</months> <months xsi:type="xsd:int">3</months> <months xsi:type="xsd:int">4</months> <months xsi:type="xsd:int">5</months> <months xsi:type="xsd:int">6</months> <months xsi:type="xsd:int">7</months> <months xsi:type="xsd:int">8</months> <months xsi:type="xsd:int">9</months> <months xsi:type="xsd:int">10</months> <months xsi:type="xsd:int">11</months> </months> </calendarTrigger> Can anyone tell if ther is an issue in my xml or if I am just missing a setting on my jasper server.

I used the soap interface and scheduled a job, then fetched a job descriptor using rest. The xml is quite different. The parameters prortion is below <source> <parameters> <parameterValues> <entry> <key>time_zone</key> <value xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xs="http://www.w3.org/2001/XMLSchema" xsi:type="xs:string">Eastern Time (US & Canada)</value> </entry> <entry> <key>duration</key> <value xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xs="http://www.w3.org/2001/XMLSchema" xsi:type="xs:string">One Day</value> </entry> <entry> <key>device_id</key> <value xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xs="http://www.w3.org/2001/XMLSchema" xsi:type="xs:int">7</value> </entry> </parameterValues> </parameters> <reportUnitURI>/Consumer/test-readings</reportUnitURI> </source> Using that in generating a rest request resulted in the follwing error 2012-09-14 07:28:37,778 ERROR JobsServiceCallTemplate,http-8080-6:80 - Unexpected error occurs com.jaspersoft.jasperserver.api.JSExceptionWrapper: org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [insert into JIReportJobParameter (job_id, parameter_name, parameter_value) values (?, ?, ?)]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update Does anyone have working parameter xml?

By putting the xml as the body of the put request I got a folder created, but it returned an empty document code 201 instead of the xml resource descriptor it says I should receive in the manual.

I'm having trouble scheduling a job though the rest v2 interface. Could really use an xml sample with calendar trigger and parameters My xml <job> <baseOutputFilename>test-readings</baseOutputFilename> <repositoryDestination> <folderURI>/Scheduled/e986aa60-dfe6-012f-d7dd-38ac6fdf26f8</folderURI> <overwriteFiles>false</overwriteFiles> <sequentialFilenames>true</sequentialFilenames> </repositoryDestination> <label>test readings from new server</label> <outputFormats> <outputFormat>PDF</outputFormat> </outputFormats> <reportUnitURI>/Consumer/test-readings</reportUnitURI> <jobMailNotification> <subject>Scheduled Report</subject> <resultSendType>SEND_ATTACHMENT</resultSendType> <toAddresses>spamme@spam.com</toAddresses> <toAddresses>removed@toprotectme.com</toAddresses> </jobMailNotification> <calendarTrigger> <startDate>2012-09-13T11:50:39-0400</startDate> <timezone>Eastern Time (US & Canada)</timezone> <hours>8</hours> <minutes>0</minutes> <daysType> <value>WEEK</value> </daysType> <weekDays>2</weekDays> <weekDays>3</weekDays> <weekDays>4</weekDays> <weekDays>5</weekDays> <weekDays>6</weekDays> <months>0</months> <months>1</months> <months>2</months> <months>3</months> <months>4</months> <months>5</months> <months>6</months> <months>7</months> <months>8</months> <months>9</months> <months>10</months> <months>11</months> </calendarTrigger> <parameters> <parameter> <name>duration</name> <value>One Day</value> </parameter> <parameter> <name>device_id</name> <value>7</value> </parameter> </parameters> </job> the response xml <?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?><errorDescriptor><errorCode>unexpected.error</errorCode><parameters><parameter>java.lang.NullPointerException</parameter></parameters></errorDescriptor> The error trace 2012-09-13 08:50:39,401 ERROR JobsServiceCallTemplate,http-8080-5:80 - Unexpected error occurs java.lang.NullPointerException at com.jaspersoft.jasperserver.api.engine.scheduling.domain.ReportJobCalendarTrigger.getDaysType(ReportJobCalendarTrigger.java:189) at com.jaspersoft.jasperserver.api.engine.scheduling.DefaultReportJobValidator.validateJobCalendarTrigger(DefaultReportJobValidator.java:209) at com.jaspersoft.jasperserver.api.engine.scheduling.DefaultReportJobValidator.validateJobTrigger(DefaultReportJobValidator.java:177) at com.jaspersoft.jasperserver.api.engine.scheduling.DefaultReportJobValidator.validateJob(DefaultReportJobValidator.java:104) at com.jaspersoft.jasperserver.api.engine.scheduling.ReportSchedulingFacade.validate(ReportSchedulingFacade.java:630) at com.jaspersoft.jasperserver.api.engine.scheduling.ReportSchedulingFacade.scheduleJob(ReportSchedulingFacade.java:487) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at $Proxy21.scheduleJob(Unknown Source)

I'm using multipart-post gem in a rails 3 app opening connection to reports.intouchgps.com... opened <- "PUT /jasperserver/rest/resource HTTP/1.1\r\nAccept: */*\r\nUser-Agent: Ruby\r\nContent-Type: multipart/form-data; boundary=-----------RubyMultipartPost\r\nContent-Length: 457\r\nAuthorization: Basic d2Vic2VydmljZXM6d2Vic2VydmljZXM=\r\nConnection: close\r\nHost: reports.intouchgps.com:8080\r\n\r\n" <- "-------------RubyMultipartPost\r\nContent-Disposition: form-data; name=\"ResourceDescriptor\"\r\n\r\n<resourceDescriptor name=\"75a425c0-de74-012f-d7d6-38ac6fdf26f8\" wsType=\"folder\" uriString=\"/Scheduled/75a425c0-de74-012f-d7d6-38ac6fdf26f8\" isNew=\"false\"><label>User Folder 75a425c0-de74-012f-d7d6-38ac6fdf26f8</label><resourceProperty name=\"PROP_PARENT_FOLDER\"><value>/Scheduled</value></resourceProperty></resourceDescriptor>\r\n-------------RubyMultipartPost--\r\n\r\n" -> "HTTP/1.1 400 Bad Request\r\n" -> "Server: Apache-Coyote/1.1\r\n" -> "Pragma: No-cache\r\n" -> "Cache-Control: no-cache\r\n" -> "Expires: Wed, 31 Dec 1969 16:00:00 PST\r\n" -> "P3P: CP=\"ALL\"\r\n" -> "Set-Cookie: JSESSIONID=BE57A2C851D02CB1CB448052D9246DB3; Path=/jasperserver\r\n" -> "Content-Type: text/xml;charset=UTF-8\r\n" -> "Content-Length: 27\r\n" -> "Date: Tue, 11 Sep 2012 20:14:48 GMT\r\n" -> "Connection: close\r\n" -> "\r\n" reading 27 bytes... -> "Invalid resource descriptor" read 27 bytes Conn close This was in the log 2012-09-11 12:45:48,673 DEBUG RESTServlet,http-8080-7:131 - request params: Path: /resource Requested Service: resource Service from registry: class com.jaspersoft.jasperserver.rest.services.RESTResource$$EnhancerByCGLIB$$79dc9457 2012-09-11 12:45:48,676 DEBUG RESTAbstractService,http-8080-7:100 - execute: Resource=/resource Method=put 2012-09-11 12:45:48,815 DEBUG Utils,http-8080-7:158 - 0 attachments were extracted from the POST 2012-09-11 12:45:48,817 ERROR RESTResource,http-8080-7:237 - Unexpected error during resource descriptor marshaling: Premature end of file. org.xml.sax.SAXParseException: Premature end of file.

Did you get this working? I'm having the same issue.

Was my error I had put /jasperserver in the base url that was being parsed and it wasn't part of the requests

Has anybody got rest v2 api working? I'm using net/http in a rails 3 app. opening connection to reports.intouchgps.com... opened <- "GET /rest_v2/reports/Consumer/test-readings.pdf?time_zone=Eastern+Time+%28US+%26+Canada%29&time_zone_offset=0&include=true&start_date=2012-09-04+00%3A00&end_date=2012-09-11+00%3A00&device_id=7 HTTP/1.1\r\nAccept: */*\r\nUser-Agent: Ruby\r\nAuthorization: Basic cmVwb3J0cnVubmVyOnJlcG9ydHJ1bm5lcg==\r\nConnection: close\r\nHost: reports.intouchgps.com:8080\r\n\r\n" -> "HTTP/1.1 404 Not Found\r\n" -> "Server: Apache-Coyote/1.1\r\n" -> "Content-Type: text/html;charset=utf-8\r\n" -> "Content-Length: 1081\r\n" -> "Date: Tue, 11 Sep 2012 13:57:51 GMT\r\n" -> "Connection: close\r\n" -> "\r\n" reading 1081 bytes... -> "<html><head><title>Apache Tomcat/6.0.35 - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 404 - /rest_v2/reports/Consumer/test-readings.pdf</h1><HR size=\"1\" noshade=\"noshade\"><p><b>type</b> Status report</p><p><b>message</b> <u>/rest_v2/reports/Consumer/test-readings.pdf</u></p><p><b>description</b> <u>The requested resource (/rest_v2/reports/Consumer/test-readings.pdf) is not available.</u></p><HR size=\"1\" noshade=\"noshade\"><h3>Apache Tomcat/6.0.35</h3></body></html>" read 1081 bytes Conn close Basic auth doesn't seem to work at all I log the url generated and if i visit it while logged in it works.

I removed openjdk-7-jdk and installed sun-java6-jdk and it worked. However the query designer will not open using openjdk-7

If I send the data with a different parameter name as a comma separated string how would I use that parameter to populate the original parameter that is used in an $X{IN} in my query?

I've got scheduling working fairly well from a rails app but I ran in to an unexpected snafu. I have about 6 dozen reports, around 3 dozen each for staging and production servers. Each report has enough parameters that it made more sense to me to send a soap request from the server on the scheduled day and have it run immediately. However when reports run immediately then getJob will report that the job was not found making my storing of the id pointless. <?xml version='1.0' ?> <env:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"> <env:Header /> <env:Body> <n1:getJob xmlns:n1="http://www.jasperforge.org/jasperserver/ws"> <id xsi:type="xsd:long">90</id> </n1:getJob> </env:Body> </env:Envelope> #<Handsoap::Fault: Handsoap::Fault { :code => 'ns1:Client', :reason => 'Job 90 was not found' }> I was hoping to use the id I had saved to look up job information and possibly delete the file from the repo after some period of time. Is there any way to do that or do I need to write a cron script on the jasper server.

If it helps here's my soap response <?xml version="1.0" encoding="utf-8"?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><soapenv:Body><soapenv:Fault><faultcode xmlns:ns1="http://xml.apache.org/axis/">ns1:Client</faultcode><faultstring>Unable to convert value "2" of type java.lang.String to parameter type java.util.List</faultstring><detail><ns2:exceptionName xmlns:ns2="http://xml.apache.org/axis/"><![CDATA[com.jaspersoft.jasperserver.api.JSException: report.scheduling.ws.value.conversion.not.supported at com.jaspersoft.jasperserver.ws.axis2.scheduling.ReportJobBeanTraslator.convertToParameter(ReportJobBeanTraslator.java:546) at com.jaspersoft.jasperserver.ws.axis2.scheduling.ReportJobBeanTraslator.toParameterValue(ReportJobBeanTraslator.java:398) at com.jaspersoft.jasperserver.ws.axis2.scheduling.ReportJobBeanTraslator.copyParameters(ReportJobBeanTraslator.java:365) at com.jaspersoft.jasperserver.ws.axis2.scheduling.ReportJobBeanTraslator.copy(ReportJobBeanTraslator.java:343) at com.jaspersoft.jasperserver.ws.axis2.scheduling.ReportSchedulerServiceImpl.scheduleJob(ReportSchedulerServiceImpl.java:89) at sun.reflect.GeneratedMethodAccessor1325.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) 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.aop.framework.adapter.ThrowsAdviceInterceptor.invoke(ThrowsAdviceInterceptor.java:126) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy16.scheduleJob(Unknown Source) at com.jaspersoft.jasperserver.ws.axis2.scheduling.ReportScheduler.scheduleJob(ReportScheduler.java:43) at sun.reflect.GeneratedMethodAccessor1324.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397) at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186) at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:453) at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281) at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:83) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) 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:390) 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:390) 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:390) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:139) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.PasswordExpirationProcessingFilter.doFilter(PasswordExpirationProcessingFilter.java:85) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) 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:390) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.JIPortletAuthenticationProcessingFilter.doFilter(JIPortletAuthenticationProcessingFilter.java:81) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) 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:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) 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:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11B 1e1 aseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595) ]]></ns2:exceptionName></detail></soapenv:Fault></soapenv:Body></soapenv:Envelope>

I'm trying to schedule reports using a soap service and have had success with normal parameters. I'm using files created with wsdl2ruby.rb in a rails environment I tried sending as either individually or as a comma separated list and either way got an error. SOAP::FaultError (Unable to convert value "2" of type java.lang.String to parameter type java.util.List): #<SOAP::Mapping::Object:0xb5ec2c90> SOAP::FaultError (Unable to convert value "2,39,51,127,784" of type java.lang.String to parameter type java.util.List): #<SOAP::Mapping::Object:0xb5ec8c80> The soap structure is different for parameters in scheduling service and I'm not sure how to add the :isListItem => true Any help would be greatly appreciated

Solved using MySQL IFNULL function but an issue remain w/ null in integer fields. Should it be reported as a bug?

$F{MyIntegerField} == null ? "In Progress" : $F{MyIntegerField}.toString() $F{MyStringField} == null ? "In Progress" : $F{MyStringField} $F{MyTimestampField} == null ? "In Progress" : $F{MyTimestampField}.toString()

No actually I had tried that before. The issue seems to only occur if the field is an integer, it work fine in other tables where field is a varchar or timestamp.

No the entire expression evaluates to null instead of giving the true value of the ternary expression. When I expect "In Progress" I get null Post Edited by rossi_jeff at 02/25/2011 16:06

I my application I have several events tables that store duration in minutes. When the event is in progress the duration is null. I my report I want to show the text "In Progress" or the formatted value, in csv the formatted value is integer $V{duration_hours} -> integer ($F{stop_events_duration}.intValue() / 60).intValue() $V{duration_minutes} -> integer ($F{stop_events_duration}.intValue() % 60) $V{duration_hrs_min} -> type string (($F{stop_events_duration}.equals(null)) || ($V{duration_hours}.equals(null)) || ($V{duration_minutes}.equals(null))) ? "In Progress" : (($V{duration_hours} == 0) ? ($V{duration_minutes}.toString() + " min") : ($V{duration_hours}.toString() + ($V{duration_hours} == 1 ? " hr, " : " hrs, ") + $V{duration_minutes}.toString() + " min")) The textfield in details ($F{stop_events_duration}.intValue() == null) ? "In Progress" : (($P{output_format} == "PDF") ? $V{duration_hrs_min} : ($P{output_format} == "RTF") ? $V{duration_hrs_min} : $F{stop_events_duration}.toString())

This worked but I'd still like to know why swictch did not. ("Integer,String,Float,Digital,Complex,Location,Diagnostics,Bitmap".split(",")[$F{sensor_readings_sensor_type}.intValue()])

Is there a way to make this work? I have various values I need to show according to the value of an integer value in a field. I've tried many different syntax but all end in compile errors. Code:switch ( $F{sensor_readings_sensor_type}.intValue() ) { case 0: "Integer"; break; case 1: "String"; break; case 2: "Float"; break; case 3: "Digital"; break; case 4: "Complex"; break; case 5: "Location"; break; case 6: "Diagnostics"; break; case 7: "Bitmap"; break;}