6

In our Salesforce.com organization, we have a trigger on the OpportunityLineItem object (insert/update), automatically generating OpportunityLineItemSchedule. The product is schedule by revenue, splitted using two dates available in the master OpportunityLineItem record (start/end date).

Everything is working fine, except when the OpportunityLineItem quantity is lower than 1 (like 0.25). In this case, Salesforce is triggering this weird error:

A workflow or approval field update caused an error when saving this record. Contact your administrator to resolve it. java.sql.SQLException: ORA-20067: ORA-06512: at "GRUMPY.SOPPLINEITEM", line 1211 ORA-06512: at line 1

Any idea what it means? I've been digging in the Salesforce log, but can't find much.

Mike Chale
  • 13,364
  • 6
  • 47
  • 89
jpmonette
  • 4,440
  • 8
  • 38
  • 69

2 Answers2

9

@jpmonette, Congrats you've captured one of the 7 dwarves. (GRUMPY) So far as I know whenever you capture one of the 7 dwarves, all you can do is take a shot, and file a case with support.

Can you post example code that triggers the issue without, you know, giving away all the secret sauce your company pays you to develop? Perhaps with some code we can provide further advice.

Kevin P
  • 7,208
  • 2
  • 27
  • 40
  • 5
    I've captured DOPEY and SLEEPY as well, but that was years ago. – sfdcfox Oct 09 '13 at 14:29
  • I've been troubleshooting with a Salesforce engineer. For some reason, the UnitPrice of my OpportunityLineItem ended up at null. It shouldn't be possible since this is a required field on Salesforce side. Can't wait to fix this awkward bug. – jpmonette Oct 09 '13 at 16:44
  • @jpmonette make sure to take a screen capture. The seven dwarves make for good war stories. – Kevin P Oct 09 '13 at 16:56
  • I contacted Salesforce two weeks ago and gave them access to a sandbox to test, with use case and showed the problem to a tech using GoToMeeting. Strangely, after 2 weeks without an answer, the Salesforce tech updated the case asking me for another use case since the first one wasn't working anymore. I checked, and I noticed the bug stopped happening (both in production and sandbox). I have no idea what was change, but I guess there was an update server-side that fixed it. Great! – jpmonette Oct 25 '13 at 15:15
4

Anytime you get errors that refer to sql/oracle you're seeing errors which shouldn't be happening and are originating from logic internal platform. Salesforce keeps far more detailed log than exposed to us, most appropriate thing is to contact them through a support case

Samuel De Rycke
  • 9,550
  • 8
  • 45
  • 73