[#13476] - Error updating sql in dataset and query dialog

Category:
Bug report
Priority:
High
Status:
Confirmed
Project: Severity:
Major
Resolution:
Open
Component: Reproducibility:
Always
Assigned to:
0

Hi, We use jaspersoft studio 6.6.0 on windows 10 with oracle 12c database (ojdbc8.jar).

Frequently when trying to edit a report query it fails consistently (depending on query) with popup windows "Problem Occurred" with following message:
"An internal error occurred during: "XtextReconcilerJob"."
"java.lang.IllegalArgumentException: SelectQuery.op does not exist"

This only seems to happen with queries with combination of with clause and union as far as I can tell.
This can be reproduced with following simple example query on empty report (detail section no fields):
with data1 as (select 1 as value from dual),
data2 as (select 2 as value from dual)
select value from data1
union all
select value from data2

For the rest the report seems to run fine with preview working and generated report (.jasper) working.

I have tested with version jaspersoft studio 6.6.0 on laptop, jaspersoft studio 6.16.0 on same laptop and reproduced issue on different machines with jaspersoft studio 6.6.0

AttachmentSize
File xtext_error_jaspersoft_studio_6.6.0.bmp275.19 KB
v6.6
Jaspersoft® Studio
PaulvanH's picture
Joined: Mar 23 2021 - 1:43am
Last seen: 3 weeks 1 day ago

2 Comments:

#1
  • Priority:Normal» High
#2
  • Status:Acknowledged» Confirmed
Feedback
randomness