4096 error message

[alarge23]

I am getting a "4096 error" on my coldfusion page: "java.lang.ArrayIndexOutOfBoundsException: 4096"

The line number identified is in the middle of select statement. The query is valid if run directly on the database, but in a coldfusion page returns this error. I am using coldfusion version 6,1,0,63958. JDBC: macromedia.jdbc.sqlserver.SQLServerDriver is 3.2

Any ideas what is causing this error? Could it have something to do with the JDBC driver version?

 

[FALCONSEYE]

are you referring an array with something like myArray[0] coming out of that query?

http://www.jetansolutions.com

 

[alarge23]

No arrays involved. It is just a select statement using some aggregate functions/grouping. And the query does run fine if executed in Query Analyzer.

 

[r937]

can you show the CFQUERY with the query inside it?

r937.com | rudy.ca

 

[alarge23]

<CFQUERY NAME="GET_CUSTOMER" DATASOURCE="TEST">
SELECT
CUSTOMER.CUSTNAME,
CUSTOMER.CUSTID,
ULT_CUSTOMER.CUSTNAME ULT_PARENT_CUSTNAME,
ULT_CUSTOMER.CUSTID ULT_PARENT_CUSTID,
LOWER(OFFICER.OFFID) OFFID,
OFFICER.FIRSTNAM,
OFFICER.LASTNAM,
MIN(FST_DETAIL.TRACKING_DATE) TRACKING_DATE_ANNUAL,
MIN(FST_DETAIL_INTERIM.TRACKING_DATE) TRACKING_DATE_INTERIM,
MIN(FST_DETAIL.FREQUENCY) FREQUENCY,
MIN(FST_LOOKUP.LOOKUP_DESC) FREQUENCY_DESC,
MIN(EXPOSURESUM.TOTALASSETS + EXPOSURESUM.MEMOAVAILABLE) CLIENT_EXPOSURE,
MIN(EXPOSURERSUM.TOTALASSETS + EXPOSURERSUM.MEMOAVAILABLE) ULTPARENT_EXPOSURE
FROM
CUSTOMER
INNER JOIN CUSTOMER ULT_CUSTOMER ON (CUSTOMER.ULTPARENTID = ULT_CUSTOMER.CUSTID)
INNER JOIN FIN_STMT_REQUIRED FSR ON (CUSTOMER.CUSTID = FSR.CUSTID)
INNER JOIN FIN_STMT_PASTDUE FSD ON (CUSTOMER.CUSTID = FSD.CUSTID)
INNER JOIN FST_DETAIL ON (CUSTOMER.CUSTID = FST_DETAIL.CUSTID AND FST_DETAIL.TRACKING_TYPE = 'FINANCIAL' AND FST_DETAIL.FREQUENCY_TYPE = 'FREQUENCY' AND FREQUENCY = 'A')
INNER JOIN FST_LOOKUP ON (FST_DETAIL.FREQUENCY_TYPE = FST_LOOKUP.LOOKUP_TYPE AND FST_DETAIL.FREQUENCY_CODE = FST_LOOKUP.LOOKUP_CODE)
INNER JOIN OFFICER ON OFFICER.OFFID = CUSTOMER.OFFID
INNER JOIN OLINK ON OLINK.CUSTID = CUSTOMER.CUSTID
LEFT JOIN FST_DETAIL FST_DETAIL_INTERIM ON
(CUSTOMER.CUSTID = FST_DETAIL_INTERIM.CUSTID AND
FST_DETAIL_INTERIM.TRACKING_TYPE = 'FINANCIAL' AND
FST_DETAIL_INTERIM.FREQUENCY_TYPE = 'FREQUENCY' AND
FST_DETAIL_INTERIM.FREQUENCY = 'I' AND
FST_DETAIL_INTERIM.FREQUENCY_CODE not in ('WVD','WBC','WPO','CLD','UKN'))
LEFT JOIN EXPOSURERSUM ON (ULT_CUSTOMER.CUSTID = EXPOSURERSUM.CUSTID)
LEFT JOIN EXPOSURESUM ON (CUSTOMER.CUSTID = EXPOSURESUM.CUSTID)
WHERE
OLINK.OFFID = '#TRIM(OFFICER)#' AND
fst_detail.frequency_code not in ('WVD','WBC','WPO','CLD','UKN')
GROUP BY
CUSTOMER.CUSTNAME,
CUSTOMER.CUSTID,
ULT_CUSTOMER.CUSTNAME,
ULT_CUSTOMER.CUSTID,
LOWER(OFFICER.OFFID),
OFFICER.FIRSTNAM,
OFFICER.LASTNAM

ORDER BY
<CFIF TRIM(SORT_BY) IS "CLIENT_EXPOSURE_ASC">
MIN(EXPOSURESUM.TOTALASSETS + EXPOSURESUM.MEMOAVAILABLE),
<CFELSEIF TRIM(SORT_BY) IS "CLIENT_EXPOSURE_DESC">
MIN(EXPOSURESUM.TOTALASSETS + EXPOSURESUM.MEMOAVAILABLE) DESC,
<CFELSEIF TRIM(SORT_BY) IS "RELATIONSHIP_EXPOSURE_ASC">
MIN(EXPOSURERSUM.TOTALASSETS + EXPOSURERSUM.MEMOAVAILABLE),
<CFELSEIF TRIM(SORT_BY) IS "RELATIONSHIP_EXPOSURE_DESC">
MIN(EXPOSURERSUM.TOTALASSETS + EXPOSURERSUM.MEMOAVAILABLE) DESC,
</CFIF>
ULT_CUSTOMER.CUSTNAME,
CUSTOMER.CUSTNAME,
OFFICER.LASTNAM
</CFQUERY>

 

[r937]

yeah, that looks okay, sorry, no idea where the java error might be coming from

r937.com | rudy.ca