All Forums General
gnanareddy 19 posts Joined 03/14
10 Aug 2015
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.

dnoeth 4628 posts Joined 11/04
10 Aug 2015

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.

Dieter

gnanareddy 19 posts Joined 03/14
10 Aug 2015

Thank you very much Dnoeth.

You must sign in to leave a comment.