function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Yehuda MelamedYehuda Melamed 

Convert lead to contact trigger error

Hello

I have written a simple trigger to convert lead to contact.
It has an error I can't understand:
Error
Reason: Could not process your referral.
common.exception.SfdcSqlException: ORA-20025:
ORA-06512: at "SNEEZY.CACCESS", line 2399
ORA-06512: at "SNEEZY.CACCESS", line 585
ORA-06512: at "SNEEZY.CACCESS", line 656
ORA-06512: at "SNEEZY.CTASK", line 552
ORA-06512: at line 1


{call cTask.insert_tasks(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}

{call cTask.insert_tasks(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}

I have found several links about this error:
https://developer.salesforce.com/forums/?id=906F0000000An21IAC

https://success.salesforce.com/issues_view?id=a1p30000000Sup5AAC

The scond link suggests the following:
Repro
Conditions that cause this: 
- database.leadConvert is executed for the lead inside Lead after insert trigger. 
- There is workflow associated with the Lead to create a new task as an immediate action.
Workaround
Set the workflows's "new task" task as time-dependent instead of immediate. The problem only manifest itself if the task is created at the same time the lead is converted.

Has anyone done this before? Set the workflows's "new task" task as time-dependent...?

Thank you
Yehuda MelamedYehuda Melamed
So this post:

https://developer.salesforce.com/forums/?id=906F0000000Ao0MIAS
Says the workaround does not work.
Any ideas?
Robin De BondtRobin De Bondt
When you see one of the dwarfs pop up, it means an internal platform error has occurred. Your only shot is to contact sfdc support again, as it can only be diagnosed by them.
Yehuda MelamedYehuda Melamed
As states by salesforce support:
"As I understand that Web to Lead is not generating from Oracle platform, which requires Developer Support and Developer support is currently available only to our premier customers and partners. We apologize for any impact this may be having on you.

We support our standard customers and partners through the developer support boards at https://developer.salesforce.com/. If you have a developer support question, are looking for technical documentation, best practices, code samples and other ways to speed your development time the developer forums are the place for just that. We have dedicated support agents that work the boards to answer questions and review questions to ensure that you get a response."


They do not support their own system Nor do they fix bugs on the system - beware!!
David Catindoy 101David Catindoy 101
Have you managed to solve this?