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 , Data Services 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.