Issue wit data extraction
Posted: Thu Apr 28, 2011 4:16 am
I Have query defined in Teradata enterprise stage as below:
select trim( Fsc_Yr_Num-1 || '0101') as TIMEID from dev_user_view.cldr
where cldr_dt = '#Current_Date#'
'#Current_Date#' is a parameter which I am passing through sequencer.
But the job aborts with below error :
Teradata_Enterprise_24,0: APT_TeraReadOperator:DB Call Failure(success check) Info = 0, Code = 3695, Message = A Single AMP Select statement has been issued in FastExport. 3,695
APT_TeraReadOperator:ExecuteImmediate failed for 'select trim( Fsc_Yr_Num-1 || '0101') as TIMEID from dev_user_view.cldr where cldr_dt = '2011-04-27' '. Error Code = 3695 3,695
If just run this query in SQL assistant it works fine:
select trim( Fsc_Yr_Num-1 || '0101') as TIMEID from dev_user_view.cldr where cldr_dt = '2011-04-27'
Please help me out with this.
Thanks
Sagar
select trim( Fsc_Yr_Num-1 || '0101') as TIMEID from dev_user_view.cldr
where cldr_dt = '#Current_Date#'
'#Current_Date#' is a parameter which I am passing through sequencer.
But the job aborts with below error :
Teradata_Enterprise_24,0: APT_TeraReadOperator:DB Call Failure(success check) Info = 0, Code = 3695, Message = A Single AMP Select statement has been issued in FastExport. 3,695
APT_TeraReadOperator:ExecuteImmediate failed for 'select trim( Fsc_Yr_Num-1 || '0101') as TIMEID from dev_user_view.cldr where cldr_dt = '2011-04-27' '. Error Code = 3695 3,695
If just run this query in SQL assistant it works fine:
select trim( Fsc_Yr_Num-1 || '0101') as TIMEID from dev_user_view.cldr where cldr_dt = '2011-04-27'
Please help me out with this.
Thanks
Sagar