Domain Calculated Field Error

[brian.cummings]

I am creating a report using JasperSoft Studio that uses a domain.  I have a calculated field in that domain that strips the first 2 characters from another field using the following command:

substr(SPRINTS.SPRINT_NAME,1,2).

This works fine.

What I really want is for this field to show the first 2 words of that field, but when I replace the command above with the following command:

substr(SPRINTS.SPRINT_NAME,1,INSTR(SPRINTS.SPRINT_NAME,' ',1,2))

I get the following error message below when I try and preview the report in Jaspersoft Studio:

If I use this syntax directly using a SQL command against the Oracle db, it works just fine.  Can anyone tell me how to write an expression in the domain calculated fields to give me the first 2 words of another field?

ERROR MESSAGE:

net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRException: javax.ws.rs.ProcessingException: Error reading entity from input stream.

at com.jaspersoft.studio.editor.preview.view.control.ReportControler.fillReport(ReportControler.java:530)

at com.jaspersoft.studio.editor.preview.view.control.ReportControler.access$20(ReportControler.java:505)

at com.jaspersoft.studio.editor.preview.view.control.ReportControler$5.run(ReportControler.java:386)

at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

Caused by: net.sf.jasperreports.engine.JRException: javax.ws.rs.ProcessingException: Error reading entity from input stream.

at com.jaspersoft.studio.server.domain.conn.DomainQueryExecuter.createDatasource(DomainQueryExecuter.java:229)

at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1129)

at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:696)

at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:437)

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

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

at java.lang.Thread.run(Thread.java:745)

Caused by: javax.ws.rs.ProcessingException: Error reading entity from input stream.

at org.glassfish.jersey.message.internal.InboundMessageContext.readEntity(InboundMessageContext.java:866)

at org.glassfish.jersey.message.internal.InboundMessageContext.readEntity(InboundMessageContext.java:810)

at org.glassfish.jersey.client.ClientResponse.readEntity(ClientResponse.java:368)

at org.glassfish.jersey.client.InboundJaxrsResponse$2.call(InboundJaxrsResponse.java:122)

at org.glassfish.jersey.internal.Errors.process(Errors.java:315)

at org.glassfish.jersey.internal.Errors.process(Errors.java:297)

at org.glassfish.jersey.internal.Errors.process(Errors.java:228)

at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:399)

at org.glassfish.jersey.client.InboundJaxrsResponse.readEntity(InboundJaxrsResponse.java:119)

at com.jaspersoft.studio.server.protocol.restv2.RESTv2ExceptionHandler.handleErrorDescriptorList(RESTv2ExceptionHandler.java:84)

at com.jaspersoft.studio.server.protocol.restv2.RESTv2ExceptionHandler.handleErrorDescriptor(RESTv2ExceptionHandler.java:108)

at com.jaspersoft.studio.server.protocol.restv2.RESTv2ExceptionHandler.handleException(RESTv2ExceptionHandler.java:58)

at com.jaspersoft.studio.server.protocol.restv2.ARestV2ConnectionJersey.toObj(ARestV2ConnectionJersey.java:55)

at com.jaspersoft.studio.server.domain.protocol.RestV2.executeQuery(RestV2.java:147)

at com.jaspersoft.studio.server.domain.protocol.DomainProxy.executeQuery(DomainProxy.java:41)

at com.jaspersoft.studio.server.domain.DomainManager.executeQuery(DomainManager.java:85)

at com.jaspersoft.studio.server.domain.conn.DomainQueryExecuter.createDatasource(DomainQueryExecuter.java:226)

... 6 more

Caused by: com.fasterxml.jackson.databind.JsonMappingException: Can not deserialize instance of java.util.ArrayList out of START_OBJECT token

 at [source: org.glassfish.jersey.message.internal.ReaderInterceptorExecutor$UnCloseableInputStream@6b34e798; line: 1, column: 1]

at com.fasterxml.jackson.databind.JsonMappingException.from(JsonMappingException.java:148)

at com.fasterxml.jackson.databind.DeserializationContext.mappingException(DeserializationContext.java:749)

at com.fasterxml.jackson.databind.DeserializationContext.mappingException(DeserializationContext.java:745)

at com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.handleNonArray(CollectionDeserializer.java:275)

at com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.deserialize(CollectionDeserializer.java:216)

at com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.deserialize(CollectionDeserializer.java:206)

at com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.deserialize(CollectionDeserializer.java:25)

at com.fasterxml.jackson.databind.ObjectReader._bind(ObjectReader.java:1232)

at com.fasterxml.jackson.databind.ObjectReader.readValue(ObjectReader.java:676)

at com.fasterxml.jackson.jaxrs.base.ProviderBase.readFrom(ProviderBase.java:808)

at org.glassfish.jersey.message.internal.ReaderInterceptorExecutor$TerminalReaderInterceptor.invokeReadFrom(ReaderInterceptorExecutor.java:264)

at org.glassfish.jersey.message.internal.ReaderInterceptorExecutor$TerminalReaderInterceptor.aroundReadFrom(ReaderInterceptorExecutor.java:234)

at org.glassfish.jersey.message.internal.ReaderInterceptorExecutor.proceed(ReaderInterceptorExecutor.java:154)

at org.glassfish.jersey.message.internal.MessageBodyFactory.readFrom(MessageBodyFactory.java:1124)

at org.glassfish.jersey.message.internal.InboundMessageContext.readEntity(InboundMessageContext.java:851)

... 22 more

 

 

[brian.cummings]

It appears as if the issue has to do with the single quotes. Any command that I use with single quotes in it returns the same error.  I also tried the following expression syntax:  TO_CHAR(SPRINTS.ISSUE_ID,'99999999') and received the exact same error message.

[ghudson_1]

i'm curious if a different error server-side also also occurring.  Anything juicy in jasperserver.log?