Symptom
-
Adapter log error: Column - doesn't support constrain by query.
While interacting with SuccessFactors, an error occured: Column - doesn't support constrain by query.
Exception occurs when executing 'begin' method of the adapter operation with ID [4]. While interacting with SuccessFactors, an error occured: Column - doesn't support constrain by query. - Job log error: Error preparing to read <adhocreport>: <Exception occurs when executing 'begin' method of the adapter operation with ID [4]. While interacting with SuccessFactors, an error occured: Invalid SFQL! Error: query "SELECT users_sysinfo_USERS_ID , ectintJobInfo_emp_job_info_t_business_unit_OBJECT_NAME FROM AdhocReport CONSTRAIN BY 20171031" is not properly formed>.
- Parameters required in SFDC to run the adhoc report.
- Prompts in the report.
- SalesForce Adapter does not work with a particular adhoc report.
- SFDC.
Read more...
Environment
SAP Data Services
Product
SAP Data Services 4.2
Keywords
SFDC, DS, constraint, parameters , KBA , EIM-DS-EXE , Job Execution , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.