Select is getting failed with error "SELECT Failed 3610"

General

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
N/A

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.

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

Thank you very much Dnoeth.