+ Start a Discussion
Tim BarsottiTim 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.
Welcome to the Seven Dwarves Club.

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.