You need to sign in to do that
Don't have an account?
David Danzig
Automated Lead Inserts Failing
We've been having trouble with lead inserts both via VisualForce pages andvia Web-to-Lead. Here is the error email of the first failed Lead insert of this type.
Please help! This is a huge problem and we havene't found a solution other than removing the most important fields from our forms, including Email address.
From: support@emea.salesforce.com <support@emea.salesforce.com>
Date: Sat, Jul 19, 2014 at 11:50 AM
Subject: Salesforce Could Not Create This Lead
To: ""
Salesforce could not create this lead because of the reason listed below. We will try creating the lead again. For more information about this error or help with Web-to-Lead, please contact Customer Support.
Reason: Your Lead could not be processed.
common.exception.SfdcSqlException: ORA-20025:
ORA-06512: at "HAPPY.CACCESS", line 2258
ORA-06512: at "HAPPY.CACCESS", line 579
ORA-06512: at "HAPPY.CACCESS", line 650
ORA-06512: at "HAPPY.CTASK", line 565
ORA-06512: at line 1
{call cTask.insert_tasks(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
{call cTask.insert_tasks(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
Lead Capture Page: http://www.zzz.php
Record Information:
<LIST OF FIELDS>
To incorporate this lead into salesforce.com you can key in the data above.
If you have any questions, please click on Support at the top right of any page within salesforce.com.
Customer Support
salesforce.com
Please help! This is a huge problem and we havene't found a solution other than removing the most important fields from our forms, including Email address.
From: support@emea.salesforce.com <support@emea.salesforce.com>
Date: Sat, Jul 19, 2014 at 11:50 AM
Subject: Salesforce Could Not Create This Lead
To: ""
Salesforce could not create this lead because of the reason listed below. We will try creating the lead again. For more information about this error or help with Web-to-Lead, please contact Customer Support.
Reason: Your Lead could not be processed.
common.exception.SfdcSqlException: ORA-20025:
ORA-06512: at "HAPPY.CACCESS", line 2258
ORA-06512: at "HAPPY.CACCESS", line 579
ORA-06512: at "HAPPY.CACCESS", line 650
ORA-06512: at "HAPPY.CTASK", line 565
ORA-06512: at line 1
{call cTask.insert_tasks(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
{call cTask.insert_tasks(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
Lead Capture Page: http://www.zzz.php
Record Information:
<LIST OF FIELDS>
To incorporate this lead into salesforce.com you can key in the data above.
If you have any questions, please click on Support at the top right of any page within salesforce.com.
Customer Support
salesforce.com
Reason: Your Lead could not be processed.
common.exception.SfdcSqlException: ORA-20025:
ORA-06512: at "HAPPY.CACCESS", line 2258
ORA-06512: at "HAPPY.CACCESS", line 579
ORA-06512: at "HAPPY.CACCESS", line 650
ORA-06512: at "HAPPY.CTASK", line 565
ORA-06512: at line 1
i don't know what else to do.
This is the issue since long time. I had a requirement to convert the lead when it comed via web to lead form. This error occurs when lead comes via web-to-lead form and you have a trigger to convert the lead on insert of lead. I tried to move the logic into future method, but convert method not working in future method as it says "Future method cannot be called from another future or batch", I guess convert method is itself batch and due to which its not allowed. Then I tried Queable method, but the issue remains the same.
Finally the solution for this is to delay conversion of lead either via time based workflow, process builder flow or scheduled class. Built a formula field which is basically 2 mins after the creation on lead. So using process builder, I had updated a field on lead (2 mins after created date). On update of field, trigger called to convert the lead.
Thanks,
Vinay Vernekar
https://sfdcdevelopers.com/Author