ODBC: Unrecognized argument error

[rkacham_DSX]

Hi,

we are getting following error randomly in pX job

SrcCommonPropertyODBC: Unrecognized argument: SELECT DISTINCT
CP.Common_Property_ID, CP.Originating_Network_ID ,rtrim(ltrim(Pet.Title)) Title
FROM
common_property CP inner join Property P on
CP.Common_Property_ID=P.Common_Property_ID and
CP.Originating_Network_ID=P.Network_ID
inner join Prop_Episode_title Pet on P.Property_id=Pet.property_id and P.Network_id=Pet.Network_id
where Pet.episode_number = 0 and Pet.Current_Title_Flag = 'y'

we are not able to reproduce the error job is getting aborted once in a while, we have checked with pds server ops they said they didn't have any issue loged,
any help is appriciated

[DSguru2B]

Well its hard to tell if the error is random. Next time the job aborts try resetting the job to see if you get any "From previous run..." messages. Use generated sql instead of user defined. Thats the best I can give you as of yet.