AnsweredAssumed Answered

Salesforce to MySQL Error : Parameter index out of range (1 number of parameters, which is 0)

Question asked by JaeEmans2311 on Oct 7, 2015
Latest reply on Oct 7, 2015 by JaeEmans2311
Hello,

I am retrieving salesforce data with a heirarchy like so:

Lead (parent)
 -CampaignMember (child)
 -Event (child)
 -Task (child)

I have built a database profile using a parent INSERT for lead, and then have created 3 child statements for each of the respective SFDC objects.

Even with the simplest INSERTS, I am always receiving Error : Parameter index out of range (1 > number of parameters, which is 0) .
From all my searches, this looks to be thinking that I am using parameter values in my SQL, but I am not. I am simply mapping the SFDC data to the Database map.

Is there a way I can get a more specific error, or has anyone dealt with this before?
 

Outcomes