Unknown Stream Error: Java.Lang.ArrayIndexOutOfBoundsException 2000

[Former Member]

Hello All,

I am using MII 12.2 version and my concern here is,

1. In MII Display Template, I found there are some common issues when i run the template within MII or from Web Page.

2. When i tried to Pull the records using the select query from the table, I restricted the row count to 10000 in the Query Template Properties  "General" Tab. when i ran the query it showd up all the records but when i load this query template through web page or if i run directly from display template it throws an error like "Unknown Stream Error: Java.Lang.ArrayIndexOutOfBoundsException 2000".

3. But when i restrict the row count to less than 1500 then display template does not throw any exception and also it pulls the records as required.

4. we are not able to arrive at an optimal solution and hence request you guys to provide us the root cause and the solution how it can be done.

Would appreciate all your help in advance.

-Praveen

[Former Member]

Praveen,

As Swaroop suggested, it should be the data.

In similar cases, I would start my debugging my limiting the data in the SELECT statement instead of the QT (top 1500 for MSMSQL and rownum for Oracle)

Also, you can play around by eliminating certain columns (description, user comments etc are potential suspects) and see if it works for rows greater than 1500..

-Rajath

[swaroop_anasane]

Hi Praveen,

There's some format exception post row number 1500 that's breaking cast of your result on web page as well on display temp.

Would suggest to go through the records once to check if it's posting any unexpected character on web, if it is, you will have to handle it.

Hope it helps.

Regards,

Swaroop

[Former Member]

Hi Swaroop,

As you said we again tried verifying the table data returned. we couldn't see such unexpected character on web. Actually what happened is it shows data sometimes in the grid for the same filter criteria but it shows no data available for the same criteria often when the row count returned by the query is high.

Is it due to the JRE ??

-Praveen

[swaroop_anasane]

Hi Praveen,

I don't see any reason for JRE behaving in this way. It has to be data issue. Are you doing some manipulation on data post retrieval?

You said testing QT returned proper result but it's failing in DT, i would suggest export the result in xml structure and check it in some xml editor. It would be easier to identify if there are some issues.

The problem i sense is, xml format of result set is breaking and hence out of bound excepton.

Regards,

Swaroop