CA Service Management

Hello Community,

We created a report in jasperstudio where its datasource is the Service Desk Manager Database . We're extracting information from the cr table (Ticket number, group, category, etc).

We' re trying to use a parameter that we created called Categories to use it in an input control of Multi Value Query of sdm categories.

In the query we already set the WHERE CLAUSE with $X(IN, category_symbol, Categories).

We created the Input control in Jasper Server with the same name of the parameter (Categories).

When we run the report, it shows us all categories right, but when we select one or more to filter data it shows the following error:

*******************************************
The server has encountered an error. Please excuse the inconvenience.

Error Message
Error filling report

Error Message
net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query: SELECT ref_num, affected_end_user_combo_name, open_date, close_date, category_symbol, group_name, assignee_combo_name, priority_description, type_symbol, predicted_sla_violation FROM cr WHERE category_symbol IN (?, ?) ORDER BY open_date DESC
*******************************************

QUERY:

SELECT ref_num,
affected_end_user_combo_name,
open_date,
close_date,
category_symbol,
group_name,
assignee_combo_name,
priority_description,
type_symbol,
predicted_sla_violation
FROM cr
WHERE $X{IN, category_symbol, Categorias}
ORDER BY open_date DESC

Please help!

Regards,

Jose, what error message can be seen in stdlog? Thanks _Chi

This was the error shown in stdlogs.

Regards,

Jose Pichardo

Jose, the syntax error shows that there is something on the data modeler side that constructs something it does not like.

From the screen shots I think maybe $X{IN, category_symbol, Categorias}. Sorry I am not an Xtraction expert. I would say wait for bit to see what others say and if not, you should open a CA Support case so we can engage Ivanti if necessary. Thanks _Chi

Hy

I just see some secounds this article but i see mispelled variable name.

Your query include categorias but variable use catagores.

G.