Tables Volatiles

Database

Tables Volatiles

Hi, I have a nesting of sub queries from 9 to more levels and when I create a volatile table I have the problem that in the last top level the data is corrupted and it can not create the volatile table and return the following error. CREATE TABLE Internal error. Crashcode 3701.
2 REPLIES
Teradata Employee

Re: Tables Volatiles

Not sure why you state "the data is corrupted".

The 3701 is a parser error. You can open an incident with Teradata support to analyze the associated  "crashdump". They will probably also need all the associated DDL (both the CREATE TABLE and the definitions of any tables/views referenced in the subqueries).

Teradata Employee

Re: Tables Volatiles

Need to open an incident with Teradata support. They can guide you through diagnosis and workaroud/resolution.

If you don't have access to Teradata support, find your Teradata DBA/Admin team member who should have that access.