If you are unable to create a new account, please email support@bspsoftware.com

 

FOR statement causes XQE-GEN-0002 java.lang.ArrayIndexOutOfBoundsException error

Started by rareone, 12 Jul 2019 01:45:43 PM

Previous topic - Next topic

rareone

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?