Hi,
I have a relational FM based report which has a data item: count(distinct [Customer User ID] for [Channel Name]),
It seems that after the JDBC change to the FM, the report has stopped working and throws a "XQE-GEN-0002 An unexpected exception occurred: java.lang.ArrayIndexOutOfBoundsException" error after running for several hours. The report validates though.
The report SQL does not show this data item in the select clause. If I use count(distinct [Customer User ID]) without the FOR statement, the Select clause will show this data item.
I think the FOR statement is not supported after the JDBC change. Can someone please suggest something?