Failure 3610: Teradata Crashes. Do not resubmit the last request
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.