Author Topic: FOR statement causes XQE-GEN-0002 java.lang.ArrayIndexOutOfBoundsException error  (Read 89 times)

Offline rareone

  • Associate
  • **
  • Join Date: Jul 2015
  • Posts: 1
  • Forum Citizenship: +0/-0

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?