SAP Knowledge Base Article - Preview

2573230 - SFDC Column - doesn't support constrain by query - Data Services

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.