Jump to content

Jasper reports SQL query error upgraded to v6.1


Recommended Posts

I upgraded the Jasper server from v6.0.1 to v6.1, all my reports which have SQL queries associcated with them are now crashing with the following error:

org.teiid.api.exception.query.QueryParserException: TEIID30378 Direct usage of XQuery is no longer supported, use XMLQUERY instead.

org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "[*]declare[*] @InputTable LegalApps_dbo.udtGlobalEntityId" at line 1, column 1. Was expecting: "alter" | "begin" | "call" | "create" | "delete" | "drop" | "exec" | "execute" | "insert" | "merge" ...


My SQL query is as follows:

declare  @InputTable utd

insert into @InputTable

select PersonID from dbo.vPersonTable where ($X{IN,PersonID,ic_SelectUser})
select *  from dbo.foobar
where someID in (select * from someFunction(@InputTable,$P{ic_IncludeTeam}))
How do I change the SQL query to run the report successfully. Can anyone please give me any pointers.
Link to comment
Share on other sites

  • 2 months later...
  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...