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.
SAP Knowledge Base Article - Preview