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
ODBC: Unrecognized argument error
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 27
- Joined: Tue Nov 02, 2004 5:34 pm
ODBC: Unrecognized argument error
Thanks,
Ramesh
Ramesh
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.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.