Failure 3610: Teradata Crashes. Do not resubmit the last request

Database

Failure 3610: Teradata Crashes. Do not resubmit the last request

Hi All,

I am facing an issue after I upgraded the teradata db to v12. When I join two specific tables with INNER Join on one column, it works fine. But when I use an outer join (may it be LEFT OUTER / RIGHT OUTER JOIN), the query fails and results in "Failure 3610: Teradata Crashes. Do not resubmit the last request". This is really critical as this is in Production. Please help me in resolving this issue asap.

Query1 which executes correctly : SELECT COUNT(*) FROM TABLE1 INNER JOIN TABLE2 ON (TABLE1.COLUMN1 = TABLE2.COLUMN1)
Query1 which fails : SELECT COUNT(*) FROM TABLE1 LEFT OUTER JOIN TABLE2 ON (TABLE1.COLUMN1 = TABLE2.COLUMN1)

Thank you in advance.

PS: I am not able to retrieve the snapshot dump in this scenario, as the database server is at different location and am connecting remotely.

1 REPLY
Enthusiast

Re: Failure 3610: Teradata Crashes. Do not resubmit the last request

If you have a critical production issue, you should contact you Terdadata suppport representative immediately. Your company is paying for Teradata support, so why not use it?