[#4926] - Unable to use date filters in adHoc query. produces "literal does not match format string" in java stack trace

Category:
Bug report
Priority:
Normal
Status:
Feedback Requested
Project: Severity:
Major
Resolution:
Open
Component: Reproducibility:
Always
Assigned to:
0

Any filter that uses date type field causes Oracle to produce an error ORA-01861: literal does not match format string.

AttachmentSize
Binary Data ora-01861-stacktrace.log16.33 KB
v6.1.0
jadon's picture
2
Joined: Dec 8 2014 - 7:11pm
Last seen: 6 years 5 months ago

6 Comments:

#1
  • Status:New» Feedback Requested

I can reproduce it too and it's really annoying: date filters just not working at least with oracle jdbc Data Sources. Is there any changes or plans to fix this past 2 month from original bug report?

#2

When is this getting fixed? Having a lot of trouble as I am working with date filters!<strong><<<<<< This comment was blocked and unpublished because <a href="http://www.projecthoneypot.org/">Project Honeypot</a> indicates it came from a suspicious IP address.</strong>

#3

It has been indicated to me that this will be fixed in the next release.

#4

Here is a work around I received from support.

There is a workaround and to make this change, edit WEB-INF/applicationContext-semanticLayer.xml and look for the property "excludeFunctionTemplates" in the bean "defaultSQLGenerator".

Comment out the two <value> elements as shown:

<bean id="defaultSQLGenerator"
class="com.jaspersoft.commons.semantic.dsimpl.SQLGenerator" scope="prototype">
<property name="excludeFunctionTemplates">
<list>
<!-- <value>Integer</value> -->
<!-- <value>Timestamp</value> -->
</list>
</property>
<property name="functionTemplates">
<map>
...

#5

In the workaround above, you should uncomment the Integer value:

<value>Integer</value>

Otherwise, you may get this exception if you have a numeric field set to "Dimension" in a domain.

java.lang.RuntimeException: groovy evaluation failed on string args[0].value and expression Integer(24)

#6

Also try this setting in the driver URL.

FetchTSWTZasTimestamp=true

Feedback