Hi,

I am trying to run a report def to load students. It is a pretty basic table with 3 columns.

However when the rep-def is run it throws below error.

Query is as below

SELECT "PC0".`school_id` AS "school_id" , "PC0".`school_name` AS "school_name" , "PC0".`school_desc` AS "school_desc" FROM school "PC0" WHERE ( "PC0".`school_id` = ? OR "PC0".`school_name` = ? )

I tried to run the query in MYSQL and I get the same error. it looks like MYSQL does not agree with the way PEGA generates the query.

I found out that MYSQL does not like prefix to be in double quotes such as "PC0". I manually removed them and MYSQL runs it perfectly. (see below query)

SELECT PC0.`school_id` AS "school_id" , PC0.`school_name` AS "school_name" , PC0.`school_desc` AS "school_desc" FROM school PC0 WHERE ( PC0.`school_id` = 1 OR PC0.`school_name` = 'name1' )

Is this a knows issue or behavior ? Please let me know possible solution.

Thanks

Chamila