Adding 130 materials to Param2 in a standard fixed query times out?

[Former Member]

When I add 130 materials to a param2 in a fixed query the times out saying fatal error? When I limit this to 100 materials through param 2 it works fine. A direct oracle query with 130 material works fine. Is there a limit to the Param2 in MII for queries? Can this be changed?

SELECT SUM(TABLETCNT) AS TBCNT, SUM(LOTSIZE) AS LOTS, TRUNC(ACTIVITYDT) AS ACTDATE FROM eforms_user.V_YIELD

WHERE ACTIVITYDT > to_date('[Param.1]', 'yyyy/mm/dd')

AND itemno IN ([Param.2])

AND PONO < '000044444444'

GROUP BY TRUNC(ACTIVITYDT)

[jcgood25 · Accepted solution]

Where is the timeout? If you are calling this query in an SQLQuery action block in a transaction make sure to increase the timeout setting in the configure dialog.

[agentry_src · Accepted solution]

Just for curiosity sake, can you try it with 128 and 129 materials?

Also, what is the size of the whole string that you pass into Param.2? I think the limit is 4k, so it is unlikely that your list would be that large, but try testing for a 2k limit as well.

Regards,

Mike

[Former Member · Accepted solution]

Thank you sooo much. This worked!!!!!!