error 3610 looking for an alternative solution

Database
Enthusiast

error 3610 looking for an alternative solution

Hi All,

 

I encountered error 3610 when running the code below

CREATE VOLATILE MULTISET TABLE  table1 AS (
SEL QT,
GID,
SESS_SKEY,
SESS_START_DT,
EP_UID,
CNL_ID,
SITE,
-- XMLAGG(COBR) (VARCHAR(1000)) AS COBRS,
-- XMLAGG(EXPE_LEVEL1) (VARCHAR(1000)) AS EXPE_LEVEL1S,
-- XMLAGG(SESS_SOURCE) (VARCHAR(1000)) AS SESS_SOURCES,
COUNT(QT) OVER (PARTITION BY GID, SESS_SKEY, SESS_START_DT, EP_UID, CNL_ID, SITE) AS CNT_QT
FROM GSS_GET_SRP_15769
GROUP BY 1, 2, 3, 4, 5, 6, 7
) WITH DATA PRIMARY INDEX (SITE_ID, GUID, SESSION_SKEY, SESSION_START_DT) ON COMMIT PRESERVE ROWS;

 

When I delete the three rows in bold, the query runs fine, but when I keep them I met error 3610. I have checked that the teradata version of mine supports function xmlagg, and it works fine in the test code below:

 

SELECT UQT,
GID,
SESS_SKEY,
SESS_START_DT,
SITE,
XMLAGG(COBR) (VARCHAR(10000)) AS COBRS,
FROM TEMP
GROUP BY 1, 2, 3, 4, 5;

 

I am not sure how to revise my code to achieve the same result. Can anyone help me with it? Thanks!

Tags (1)

Accepted Solutions
Junior Contributor

Re: error 3610 looking for an alternative solution

It might be as simple as rearranging the column list in Select.

But every 3610 is an optimizer crash, the DBAs should have been noticed already, so approach them for an incident.

1 ACCEPTED SOLUTION
3 REPLIES
Junior Contributor

Re: error 3610 looking for an alternative solution

You should not try to fix a 3610 error, open an incident with Teradata support.

Enthusiast

Re: error 3610 looking for an alternative solution

Hi Dnoeth,

 

Thanks for your answer. I know I cannot fix a 3610 error, but do you know how I can revise my query to achieve the same result?

Junior Contributor

Re: error 3610 looking for an alternative solution

It might be as simple as rearranging the column list in Select.

But every 3610 is an optimizer crash, the DBAs should have been noticed already, so approach them for an incident.