• deepak_tintri
  • NEWBIE
  • 0 Points
  • Member since 2013

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 5
    Questions
  • 3
    Replies
Hi ,

I am getting "common.exception.SfdcSqlException: ORA-20067: OPPORTUNITY.PRICEBOOK2_ID
ORA-06512: at "DOC.SOPPORTUNITY", line 2423" error while updating opporunity through apex.

Below is the snippet of debug log.

14:01:40.137 (1137506030)|HEAP_ALLOCATE|[2]|Bytes:657
14:01:40.137 (1137602940)|FATAL_ERROR|System.DmlException: Update failed. First exception on row 0 with id 006G000000XLZPUIA5; first error: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY, 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.PRICEBOOK2_ID
ORA-06512: at "DOC.SOPPORTUNITY", line 2423
ORA-06512: at line 1

{call sOpportunity.update_opportunities(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}

{call sOpportunity.update_opportunities(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}: []

/**************
Opportunity o=new Opportunity(Id='006G000000XLZPU', OwnerId='005G000000259h8');
update o;
****/
When I try to update onwer through UI, I get below error.

Unable to Access Page
The value of a parameter contains a character that is not allowed or the value exceeds the maximum allowed length. Remove the character from the parameter value or reduce the value length and resubmit. If the error still persists, report it to our Customer Support team. Provide the URL of the page you were requesting as well as any other related information.
---------
URL after update through UI  :https://na11.salesforce.com/ex/ex.jsp?retURL=%2F006G000000XLZPU%2Fa%3FnewOwn_lspfsub%3D0%26newOwn_lkid%3D%26ids%3D006G000000XLZPU%26newOwn%3DMarc%2BSchneider%26newOwn_lspf%3D0%26newOwn_lktp%3DStandardUserLookup%26_CONFIRMATIONTOKEN%3DIHKTJXKPqrDoEooI6BQEYdmhLJAnjnLg0qSOMCedZt.ZKwTz7SPClNkixbhe6i1aWz0ARgFI2Hud2J8UNwA6lrcbvLnjzhxm2bC.bH7KibOLGDGjVDEqDD8dX2Qa7GdvoonZbLwaJHpchM_3RC5YYkiPnTU%253D%26newOwn_mod%3D1%26id%3D006G000000XLZPU%26retURL%3D%252F006G000000XLZPU%253Fnewid%253D006G000000XLZPU%26cancelURL%3D%252F006G000000XLZPU%253Fnewid%253D006G000000XLZPU%26newOwn_lkold%3Dnull&handledEx=core.workflow.FieldUpdateException

---


 

We are getting below error while updating some opportunities.

 

 

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.SOPPORTUNITY", line 2447 ORA-06512: at line 1

 

 

Did anyone get this error before?

 

Thanks ,

Deepak

 

 

Hi 

 

When I am trying to schedule report and when I choose "To me and/or others.." as option for Email Report, I am not getting Public Groups/Users drop down.

After entering valid public group name or user name and cliking on "Find" button, I am not getting any results.

 

This was working before. It looks like after Winter 14 release this bug has been introduced.  

 

Anybody experiencing same issue while scheduling report?

 

Thanks,

 

 

 

 

When I tried to schedule a report today in our production instance, User/Public group dropdown is getting displayed  on the schedule report page.

find button is also not working. I do not get any results. 

 

Schedule Report  


    Running User
 
 
            Email Report
To me   To me and/or others...
     
Search Public Groups for:  
 
Select From
--None--
Add
 
 
Remove
Send Email To
  --None--
    Schedule Report
Frequency Daily
Weekly
Monthly
Every weekday
Every day 
*Start
 
10/2/2013 ]
*End
 
10/2/2013 ]
Preferred Start Time

Exact start time will depend on job queue activity.
    Save Changes Save report modifications with this schedule
 

Discard report modifications

 

Anybody experienced same issue before.

Has anybody implemented RichText Editor with full CKEditor toolbar with fileupload?

 

Has anybody used "/_ui/common/request/servlet/RtaImageUploadServlet" as URL for file upload?

 

 

When I access URL "https://cs11.salesforce.com/_ui/common/request/servlet/RtaImageUploadServlet" , I get below error.

 

while(1); {"errMsg":["\u003Cb\u003EError:\u003C/b\u003E Invalid parameters.","\u003Cb\u003EError:\u003C/b\u003E Invalid parameters."]}

 

When I use below code , it shows full toolbar . But Image upload does not work.

 

---

 

CKEDITOR.on('instanceReady', function(e) {
if (e.editor.config.magic) return;
var target = e.editor.config.bodyId;
var name = e.editor.name;

e.editor.destroy();

CKEDITOR.editorConfig = function( config ) { config.magic = true; }
CKEDITOR.replace(name, {
height : 600,
bodyId : target ,
sharedSpaces : { top : 'cke_topSpace', bottom : ' cke_bottomSpace' },
filebrowserImageUploadUrl : '/_ui/common/request/servlet/RtaImageUploadServlet',
contentsCss : ['/sCSS/29.0/sprites/1377821920000/Theme3/default/gc/HtmlDetailElem.css', '/sCSS/29.0/sprites/1377821920000/Theme3/default/gc/CKEditor.css'],
language : 'en-us',
sfdcLabels : {
CkeMediaEmbed : {
title : 'Embed Multimedia Content',
description : 'Use <iframe> code from DailyMotion, Vimeo, and Youtube.',
subtitle : 'Paste <iframe> code here:',
exampleTitle : 'Example:',
example : '\n \n <iframe width=\"560\" height=\"315\" src=\"https://www.youtube.com/embed/KcOm0TNvKBA\" frameborder=\"0\" allowfullscreen></iframe>\n \n ',
iframeMissing : 'Invalid <iframe> element. Please use valid code from the approved sites.'
},
sfdcSwitchToText : { sfdcSwitchToTextAlt : 'Use plain text'},
CkeImageDialog : {
uploadTab : 'Upload Image',
infoTab_url : 'URL',
error : 'Error:',
uploadTab_desc_info : 'Enter a description of the image for visually impaired users',
uploadTab_desc : 'Description',
infoTab_url_info : 'Example: http://www.mysite.com/myimage.jpg',
btn_insert : 'Insert',
missingUrlError : 'You must enter a URL',
uploadTab_file : 'Select Image',
infoTab_desc : 'Description',
btn_upadte : 'Update',
wrongFileTypeError : 'You can insert only .gif .jpeg and .png files.',
infoTab : 'Web Address',
title : 'Insert Image',
infoTab_desc_info : 'Enter a description of the image for visually impaired users',
imageUploadLimit_info : 'Max number of upload images exceeded',
uploadTab_file_info : 'Maximum size 1 MB. Only png, gif or jpeg'
} ,
CkeImagePaste : { CkeImagePasteWarning : 'Pasting an image is not working properly with Firefox, please use [Copy Image location] instead.' }
}
});
});

-----

 

Any ideas on how to use full toolbar with Salesforce OOB image upload functionality?

 

We are getting below error while updating some opportunities.

 

 

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.SOPPORTUNITY", line 2447 ORA-06512: at line 1

 

 

Did anyone get this error before?

 

Thanks ,

Deepak

 

 

Hi 

 

When I am trying to schedule report and when I choose "To me and/or others.." as option for Email Report, I am not getting Public Groups/Users drop down.

After entering valid public group name or user name and cliking on "Find" button, I am not getting any results.

 

This was working before. It looks like after Winter 14 release this bug has been introduced.  

 

Anybody experiencing same issue while scheduling report?

 

Thanks,

 

 

 

 

When I tried to schedule a report today in our production instance, User/Public group dropdown is getting displayed  on the schedule report page.

find button is also not working. I do not get any results. 

 

Schedule Report  


    Running User
 
 
            Email Report
To me   To me and/or others...
     
Search Public Groups for:  
 
Select From
--None--
Add
 
 
Remove
Send Email To
  --None--
    Schedule Report
Frequency Daily
Weekly
Monthly
Every weekday
Every day 
*Start
 
10/2/2013 ]
*End
 
10/2/2013 ]
Preferred Start Time

Exact start time will depend on job queue activity.
    Save Changes Save report modifications with this schedule
 

Discard report modifications

 

Anybody experienced same issue before.