Frequently Asked Question
Profile Object failed with source filter. Query runs fine query tool.
Last Updated 7 years ago
Question: Profile Object failed with source filter. Source extract query runs fine query tool, but fails as part of profile object execution.
Answer: This can happen due to two reasons.
1) Filter contains a semi-colon
2) In case of an Oracle source and if the filter contains a date format that is different than 'mm/dd/yyyy hh24:mi:ss'. By default, A2B Data uses the above mentioned date format.
To fix the date format, use database TO_DATE function to explicitly convert value to a date in SQL filter.
Answer: This can happen due to two reasons.
1) Filter contains a semi-colon
2) In case of an Oracle source and if the filter contains a date format that is different than 'mm/dd/yyyy hh24:mi:ss'. By default, A2B Data uses the above mentioned date format.
To fix the date format, use database TO_DATE function to explicitly convert value to a date in SQL filter.