You need to sign in to do that
Don't have an account?
JohnR Llewellyn ACS
sObject exception: This error occurred when the flow tried to look up records:
We are working on a donation page and the flow runs correctly within the flow, but not externally. It returns the following error:
Error element Search_Database_for_Email_Address (FlowRecordLookup).
This error occurred when the flow tried to look up records: ; nested exception is: common.exception.ApiQueryException: sObject type 'Contact' is not supported. If you are attempting to use a custom object, be sure to append the '__c' after the entity name. Please reference your WSDL or the describe call for the appropriate names. (There was a problem executing your command.). For details, see API Exceptions.
Any help or direction would be appreciated.
Thanks,
JohnR Llewellyn
--
Here is the full flow error alert:
Error element Search_Database_for_Email_Address (FlowRecordLookup).
This error occurred when the flow tried to look up records: ; nested exception is: common.exception.ApiQueryException: sObject type 'Contact' is not supported. If you are attempting to use a custom object, be sure to append the '__c' after the entity name. Please reference your WSDL or the describe call for the appropriate names. (There was a problem executing your command.). For details, see API Exceptions.
This report lists the elements that the flow interview executed. The report is a beta feature.
We welcome your feedback on IdeaExchange.
Flow Details
Flow Name: ACS_Finn_Public_New_Donation
Type: Flow
Version: 10
Status: Active
Flow Interview Details
Interview Label: ACS - Finn Public New Donation 4/5/2017 4:19 PM
Current User: Give Site Guest User (005G0000004t1Wj)
Start time: 4/5/2017 4:18 PM
Duration: 70 seconds
How the Interview Started
Give Site Guest User (005G0000004t1Wj) started the flow interview.
Some of this flow's variables were set when the interview started.
CampaignCode = null
SCREEN: Make_a_Donation_to_ACS
Display Text: MakeAGift
Value at run time: Please select a gift amount:
Radio Buttons: Gift_Amount_RB
Label: Gift Amount
Data Type: Currency
Choices selected at runtime:
Choice selected at runtime: $25 (X25_Public_Nonprofit_Sector)
Value of choice: 25
Dropdown List: Credit_Card_Type
Label: Credit Card Type
Data Type: Text
Choices selected at runtime:
Choice selected at runtime: Visa (Visa)
Value of choice: Visa
Textbox: Credit_Card_Number_Masked
Label: Credit Card Number
Value at run time: 4111111111111111
Textbox: Credit_Card_Security_Code
Label: Credit Card Security Code
Value at run time: 111
Dropdown List: Expiration_Month
Label: Expiration Month
Data Type: Text
Choices selected at runtime:
Choice selected at runtime: 02 (X02)
Value of choice: 02
Dropdown List: Expiration_Year
Label: Expiration Year
Data Type: Text
Choices selected at runtime:
Choice selected at runtime: 2019 (X2019)
Value of choice: 2019
Display Text: IntroText8
Value at run time:
Checkbox: Would_you_like_to_make_this_a_recurring_monthly_gift
Label: Would you like to provide ACS with vital ongoing support and make this a recurring monthly gift?
Value at run time: false
Display Text: IntroText9
Value at run time:
Checkbox: anonymous
Label: Please make my gift anonymous.
Value at run time: false
Display Text: PersonalInfo
Value at run time:
We need a few details from you in order to process your gift:
Textbox: First_Name1
Label: First Name
Value at run time: JohnR
Textbox: Last_Name1
Label: Last Name
Value at run time: Llewellyn
Textbox: Billing_Address_1
Label: Billing Address 1
Value at run time: 20101 Stalvey Hill Place
Textbox: Billing_Address_2
Label: Billing Address 2
Value at run time:
Textbox: Billing_City
Label: Billing City
Value at run time: Montgomery Village
Dropdown List: Billing_State_Choice
Label: Billing State
Data Type: Text
Choices selected at runtime:
Choice selected at runtime: Maryland (Maryland)
Value of choice: MD
Textbox: Zip_Code
Label: Zip Code
Value at run time: 20886
Textbox: Email_Address
Label: Email Address
Value at run time: jrl212@earthlink.net
Display Text: spacer
Value at run time:
Selected Navigation Button: NEXT
ASSIGNMENT: Assing_User_Inputs_to_Variables
{!varUserEmail} Equals {!Email_Address}
{!varUserFirstName} Equals {!First_Name1}
{!varUserLastName} Equals {!Last_Name1}
{!varGiftAmount} Equals null
{!varUserStreetAddress} Equals {!Billing_Address_1}
{!varUserStreetAddress2} Equals {!Billing_Address_2}
{!varUserCity} Equals {!Billing_City}
{!varUserState} Equals {!Billing_State_Choice}
{!varUserZip} Equals {!Zip_Code}
{!varshippingstreet} Equals {!Billing_Address_1}
{!varshippingstreet2} Equals {!Billing_Address_2}
{!varshippingcity} Equals {!Billing_City}
{!varshippingstate} Equals {!Billing_State_Choice}
{!varshippingzip} Equals {!Zip_Code}
{!varAnon} Equals {!anonymous}
{!varCCSecurityCode} Equals {!Credit_Card_Security_Code}
{!varCCExpirationMonth} Equals {!Expiration_Month}
{!varCCExpirationYear} Equals {!Expiration_Year}
{!varCreditCardNumberMasked} Equals cred
{!varCreditCardType} Equals {!Credit_Card_Type}
Result
{!varUserEmail} = "jrl212@earthlink.net"
{!varUserFirstName} = "JohnR"
{!varUserLastName} = "Llewellyn"
{!varGiftAmount} = "null"
{!varUserStreetAddress} = "20101 Stalvey Hill Place"
{!varUserStreetAddress2} = ""
{!varUserCity} = "Montgomery Village"
{!varUserState} = "MD"
{!varUserZip} = "20886"
{!varshippingstreet} = "20101 Stalvey Hill Place"
{!varshippingstreet2} = ""
{!varshippingcity} = "Montgomery Village"
{!varshippingstate} = "MD"
{!varshippingzip} = "20886"
{!varAnon} = "false"
{!varCCSecurityCode} = "111"
{!varCCExpirationMonth} = "02"
{!varCCExpirationYear} = "2019"
{!varCreditCardNumberMasked} = "cred"
{!varCreditCardType} = "Visa"
LUHNCLASS (APEX): Check_card_number
Inputs:
ccnumbers = {!Credit_Card_Number_Masked} (4111111111111111)
Outputs:
{!varluhntruefalse} () = output (true)
DECISION: Luhn_Check
Executed this outcome: Pass
Outcome conditions: and
1. {!varluhntruefalse} (true) Equals true
Logic: All conditions must be true (AND)
RECORD QUERY: Search_Database_for_Email_Address
Find one Contact record where:
Email Equals {!varUserEmail} (jrl212@earthlink.net)
Result
Failed to find record.
Error Occurred: ; nested exception is: common.exception.ApiQueryException: sObject type 'Contact' is not supported. If you are attempting to use a custom object, be sure to append the '__c' after the entity name. Please reference your WSDL or the describe call for the appropriate names. (There was a problem executing your command.)
Salesforce Error ID: 1144548263-25867 (2057743502)
Error element Search_Database_for_Email_Address (FlowRecordLookup).
This error occurred when the flow tried to look up records: ; nested exception is: common.exception.ApiQueryException: sObject type 'Contact' is not supported. If you are attempting to use a custom object, be sure to append the '__c' after the entity name. Please reference your WSDL or the describe call for the appropriate names. (There was a problem executing your command.). For details, see API Exceptions.
Any help or direction would be appreciated.
Thanks,
JohnR Llewellyn
--
Here is the full flow error alert:
Error element Search_Database_for_Email_Address (FlowRecordLookup).
This error occurred when the flow tried to look up records: ; nested exception is: common.exception.ApiQueryException: sObject type 'Contact' is not supported. If you are attempting to use a custom object, be sure to append the '__c' after the entity name. Please reference your WSDL or the describe call for the appropriate names. (There was a problem executing your command.). For details, see API Exceptions.
This report lists the elements that the flow interview executed. The report is a beta feature.
We welcome your feedback on IdeaExchange.
Flow Details
Flow Name: ACS_Finn_Public_New_Donation
Type: Flow
Version: 10
Status: Active
Flow Interview Details
Interview Label: ACS - Finn Public New Donation 4/5/2017 4:19 PM
Current User: Give Site Guest User (005G0000004t1Wj)
Start time: 4/5/2017 4:18 PM
Duration: 70 seconds
How the Interview Started
Give Site Guest User (005G0000004t1Wj) started the flow interview.
Some of this flow's variables were set when the interview started.
CampaignCode = null
SCREEN: Make_a_Donation_to_ACS
Display Text: MakeAGift
Value at run time: Please select a gift amount:
Radio Buttons: Gift_Amount_RB
Label: Gift Amount
Data Type: Currency
Choices selected at runtime:
Choice selected at runtime: $25 (X25_Public_Nonprofit_Sector)
Value of choice: 25
Dropdown List: Credit_Card_Type
Label: Credit Card Type
Data Type: Text
Choices selected at runtime:
Choice selected at runtime: Visa (Visa)
Value of choice: Visa
Textbox: Credit_Card_Number_Masked
Label: Credit Card Number
Value at run time: 4111111111111111
Textbox: Credit_Card_Security_Code
Label: Credit Card Security Code
Value at run time: 111
Dropdown List: Expiration_Month
Label: Expiration Month
Data Type: Text
Choices selected at runtime:
Choice selected at runtime: 02 (X02)
Value of choice: 02
Dropdown List: Expiration_Year
Label: Expiration Year
Data Type: Text
Choices selected at runtime:
Choice selected at runtime: 2019 (X2019)
Value of choice: 2019
Display Text: IntroText8
Value at run time:
Checkbox: Would_you_like_to_make_this_a_recurring_monthly_gift
Label: Would you like to provide ACS with vital ongoing support and make this a recurring monthly gift?
Value at run time: false
Display Text: IntroText9
Value at run time:
Checkbox: anonymous
Label: Please make my gift anonymous.
Value at run time: false
Display Text: PersonalInfo
Value at run time:
We need a few details from you in order to process your gift:
Textbox: First_Name1
Label: First Name
Value at run time: JohnR
Textbox: Last_Name1
Label: Last Name
Value at run time: Llewellyn
Textbox: Billing_Address_1
Label: Billing Address 1
Value at run time: 20101 Stalvey Hill Place
Textbox: Billing_Address_2
Label: Billing Address 2
Value at run time:
Textbox: Billing_City
Label: Billing City
Value at run time: Montgomery Village
Dropdown List: Billing_State_Choice
Label: Billing State
Data Type: Text
Choices selected at runtime:
Choice selected at runtime: Maryland (Maryland)
Value of choice: MD
Textbox: Zip_Code
Label: Zip Code
Value at run time: 20886
Textbox: Email_Address
Label: Email Address
Value at run time: jrl212@earthlink.net
Display Text: spacer
Value at run time:
Selected Navigation Button: NEXT
ASSIGNMENT: Assing_User_Inputs_to_Variables
{!varUserEmail} Equals {!Email_Address}
{!varUserFirstName} Equals {!First_Name1}
{!varUserLastName} Equals {!Last_Name1}
{!varGiftAmount} Equals null
{!varUserStreetAddress} Equals {!Billing_Address_1}
{!varUserStreetAddress2} Equals {!Billing_Address_2}
{!varUserCity} Equals {!Billing_City}
{!varUserState} Equals {!Billing_State_Choice}
{!varUserZip} Equals {!Zip_Code}
{!varshippingstreet} Equals {!Billing_Address_1}
{!varshippingstreet2} Equals {!Billing_Address_2}
{!varshippingcity} Equals {!Billing_City}
{!varshippingstate} Equals {!Billing_State_Choice}
{!varshippingzip} Equals {!Zip_Code}
{!varAnon} Equals {!anonymous}
{!varCCSecurityCode} Equals {!Credit_Card_Security_Code}
{!varCCExpirationMonth} Equals {!Expiration_Month}
{!varCCExpirationYear} Equals {!Expiration_Year}
{!varCreditCardNumberMasked} Equals cred
{!varCreditCardType} Equals {!Credit_Card_Type}
Result
{!varUserEmail} = "jrl212@earthlink.net"
{!varUserFirstName} = "JohnR"
{!varUserLastName} = "Llewellyn"
{!varGiftAmount} = "null"
{!varUserStreetAddress} = "20101 Stalvey Hill Place"
{!varUserStreetAddress2} = ""
{!varUserCity} = "Montgomery Village"
{!varUserState} = "MD"
{!varUserZip} = "20886"
{!varshippingstreet} = "20101 Stalvey Hill Place"
{!varshippingstreet2} = ""
{!varshippingcity} = "Montgomery Village"
{!varshippingstate} = "MD"
{!varshippingzip} = "20886"
{!varAnon} = "false"
{!varCCSecurityCode} = "111"
{!varCCExpirationMonth} = "02"
{!varCCExpirationYear} = "2019"
{!varCreditCardNumberMasked} = "cred"
{!varCreditCardType} = "Visa"
LUHNCLASS (APEX): Check_card_number
Inputs:
ccnumbers = {!Credit_Card_Number_Masked} (4111111111111111)
Outputs:
{!varluhntruefalse} () = output (true)
DECISION: Luhn_Check
Executed this outcome: Pass
Outcome conditions: and
1. {!varluhntruefalse} (true) Equals true
Logic: All conditions must be true (AND)
RECORD QUERY: Search_Database_for_Email_Address
Find one Contact record where:
Email Equals {!varUserEmail} (jrl212@earthlink.net)
Result
Failed to find record.
Error Occurred: ; nested exception is: common.exception.ApiQueryException: sObject type 'Contact' is not supported. If you are attempting to use a custom object, be sure to append the '__c' after the entity name. Please reference your WSDL or the describe call for the appropriate names. (There was a problem executing your command.)
Salesforce Error ID: 1144548263-25867 (2057743502)
sfdcFanBoy
Visual workflow runs with the security settings of the currrent user. Make sure the user has CRUD and FLS access to the object/fields.
JohnR Llewellyn ACS
Thanks! It is some kind of security based issue. I am slowly narrowing the potential causes.
Dana Karaffa 25
Did you ever resolve your issue? I'm having similar issue at the moment and could use some pointers.