cancel
Showing results for 
Search instead for 
Did you mean: 

QUERY_TOO_COMPLICATED: Query is either selecting too many fields

mohan_salla
Participant
0 Kudos

Hi,

I'm receiving the following error message when running my DS job. Source Table is having around 150 columns and require all those columns in Target table and There is only a Query transform.

Error reading from <Query>: <QUERY_TOO_COMPLICATED: Query is either selecting too many fields or the filter conditions are too

complicated.>.

Could you please advise me.

Thanks

Mohan

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

what is the version of DS ?

what is source table type ? database table ? file ?

mohan_salla
Participant
0 Kudos

Hi Manoj,

Thanks for your help.

The version of DS: 3.1

Source application is Sales Force.

Source data base is MYSQL.

I'm directly extracting the data from SF.

Please let me know if any further details.

thanks

Former Member
0 Kudos

the error is coming from salesforce, there is a limit on the length of the SQL Query that can be submitted to the salesforce, enable tracing for salesforce Adapter and check the sql statement that is submitted by DS salesforce adpter, do you see alias used in the sql statement ?

are you doing any transformations in the Query transform before loading to target table ?