You need to sign in to do that
Don't have an account?
Tim Barsotti
API error - Sleepy one of the seven dwarves
The request to create a new opportunity line item through the web service API (salesforce.com/servlet/servlet.Api) is throwing an error if there are any field updates on the Opportunity Product object.
A workflow or approval field update caused an error when saving this record. Contact your administrator to resolve it.
common.exception.SfdcSqlException: ORA-20067: OPPORTUNITY_LINEITEM.TOTAL_PRICE
ORA-06512: at "SLEEPY.SOPPLINEITEM", line 1211
ORA-06512: at line 1
If there are no workflow rules enabled, there is no error. Please advise.
A workflow or approval field update caused an error when saving this record. Contact your administrator to resolve it.
common.exception.SfdcSqlException: ORA-20067: OPPORTUNITY_LINEITEM.TOTAL_PRICE
ORA-06512: at "SLEEPY.SOPPLINEITEM", line 1211
ORA-06512: at line 1
If there are no workflow rules enabled, there is no error. Please advise.
The first rule of the Seven Dwarves Club is: Talk about the Seven Dwarves club.
The second rule of the Seven Dwarves Club is: Collect all 7.
That said, whenever I have run into one of the 7 dwarves, i've ended up having to contact support. Which isn't fun.
I believe, however, that this is the same error I ran into awhile back. I wasn't using the webservices api, but other than that... we're talking the same basic setup.
My issue was the field update was trying to manipulate the total price field. I ended up replacing the workflow with an after-update trigger.