Select is getting failed with error "SELECT Failed 3610"

General
Enthusiast

Select is getting failed with error "SELECT Failed 3610"

Hi,

In my prod environment "SELECT * FROM DB.TBL1" is getting failed with error "SELECT Failed 3610:  Internal error. Please do not resubmit the last request. SubCode: 0, 3701". Same query is running in my DEV environment.

This table has 42 columns.

SEL col1,col2, col3, col4 ... FROM DB.TBL1;

col3: DECIMAL(12,0) COMPRESS 

col4: YR SMALLINT TITLE 'YEAR'

When I comment either col3 or col4 select is giving ouput else getting failed with the above error.

Please suggest me on this.

Thank You,

Regards,

GnanaReddy.

2 REPLIES
Junior Contributor

Re: Select is getting failed with error "SELECT Failed 3610"

There might be different patch levels in dev and prod. If dev has a higher patch this issue might been fixed already and you just need to upgrade prod, too.

Otherwise open an incident with Teradata support.

In both cases contact your DBA.

Enthusiast

Re: Select is getting failed with error "SELECT Failed 3610"

Thank you very much Dnoeth.