Salesforce Developer Community

gina.lasita1.3920678327807358E12
NEWBIE
0 Points
Member since 2014

Chatter

Feed
0

Best Answers
0

Likes Received
0

Likes Given
1

Questions
2

Replies

Apex CPU Time Limit

Hello Salesforce community! I keep receiving the "Apex CPU Time Limit" error when adding many products to an opportunity after saving / adding more and then resaving.

I know that my Apex execution time is too long, and that the Salesforce limit is exceeded. I read that the Maximum CPU time on the salesforce servers is 10,000 milliseconds (Synchronous limit) 60,000 milliseconds (Asynchronous limit). The answer to fix this issue is to refine my code by removing unnecessary loop for better efficiency. (Ex: Inserting a "Map" field to bypass some things)... etc. Can anyone assist me when time permits? Please see my "opportunityProductEntry" visualforce page code below:

<apex:page standardController="Opportunity" extensions="opportunityProductEntryExtension" action="{!priceBookCheck}" >
<apex:sectionHeader Title="Manage {!$ObjectType.Product2.LabelPlural}" subtitle="{!opportunity.Name}"/>
<apex:messages style="color:red"/>
<style type="text/css">
.search{
font-size:14pt;
margin-right: 20px;}
.fyi{
color:red;
font-style:italic;}
.label{
margin-right:10px;
font-weight:bold;
}
        .custPopup{
           background-color: white;
            border-width: 2px;
            border-style: solid;
            z-index: 9999;
            left: 50%;
            padding:10px;
            position: absolute;
            /* These are the 3 css properties you will need to change so the popup
            displays in the center of the screen. First set the width. Then set
            margin-left to negative half of what the width is. You can add
            the height property for a fixed size pop up if you want.*/
            width: 500px;
            margin-left: -250px;
            top:100px;
        }
        .popupBackground{
            background-color:green;
            opacity: 0.20;
            filter: alpha(opacity = 20);
            position: absolute;
            width: 100%;
            height: 100%;
            top: 0;
            left: 0;
            z-index: 9998;
        }
</style>
<script type='text/javascript'>
var waitTime = 1;
var countDown = waitTime+1;
var started = false;
function resetTimer(){
countDown=waitTime+1;
if(started==false){
started=true;
                runCountDown();
            }
        }
function runCountDown(){
countDown--;
if(countDown<=0){
fetchResults();
started=false;
            }
else{
window.setTimeout(runCountDown,1000);
            }
        }
function checkBoxChecked(isChecked, obj)
        {
            if(isChecked.checked)
            {
                recs += obj + ',';
                ShowPopup(obj);
            }
        }

        function selRelatedRecs(isChecked, obj)
        {
            if(isChecked.checked)
                recs += obj + ',';
            else
            {
                var str = obj + ',';
                recs = recs.replace(str, '');
            }
        }

        function addRecs()
        {
            addSelectedRecs(recs);
            return false;
        }
    </script>

    <apex:form >

        <apex:outputPanel id="mainBody">

            <apex:outputLabel styleClass="label">PriceBook: </apex:outputLabel>
            <apex:outputText value="{!theBook.Name}"/> 
            <apex:commandLink action="{!changePricebook}" value="change" immediate="true"/>
            <br/>
            
            <apex:outputPanel rendered="{!multipleCurrencies}">
                <apex:outputLabel styleClass="label">Currency: </apex:outputLabel>
                <apex:outputText value="{!chosenCurrency}"/>
                <br/>
            </apex:outputPanel>
            <br/>



            
            <apex:pageBlock title="Selected {!$ObjectType.Product2.LabelPlural}" id="selected" >
                <apex:pageMessages id="pgMsg" />
                <apex:pageblockTable value="{!shoppingCart}" var="s">
                    <apex:column >
                        <apex:commandLink value="Remove" action="{!removeFromShoppingCart}" reRender="selected,searchResults" immediate="true">
                            
                            <apex:param value="{!s.PriceBookEntryId}" assignTo="{!toUnselect}" name="toUnselect"/>
                        </apex:commandLink>
                    </apex:column>

                    <apex:column headerValue="{!$ObjectType.Product2.LabelPlural}" value="{!s.PriceBookEntry.Product2.Name}"/>
                    <apex:column headerValue="{!$ObjectType.OpportunityLineItem.Fields.Quantity.Label}">
                        <apex:inputField value="{!s.Quantity}" style="width:70px" required="true" onkeyup="refreshTotals();"/>
                    </apex:column>

                    <apex:column headerValue="{!$ObjectType.OpportunityLineItem.Fields.Hours_Needed__c.Label}">
                        <apex:inputField value="{!s.Hours_Needed__c}" style="width:70px" required="false" onkeyup="refreshTotals();"/>
                    </apex:column>

                    <apex:column headerValue="{!$ObjectType.OpportunityLineItem.Fields.Feet_Needed__c.Label}">
                        <apex:inputField value="{!s.Feet_Needed__c}" style="width:70px" required="false" onkeyup="refreshTotals();"/>
                    </apex:column>

                    <apex:column headerValue="{!$ObjectType.OpportunityLineItem.Fields.ListPrice.Label}">
                        <apex:inputField value="{!s.ListPrice}" style="width:70px" required="false" onkeyup="refreshTotals();"/>
                    </apex:column>

                    <apex:column headerValue="{!$ObjectType.OpportunityLineItem.Fields.UnitPrice.Label}">
                        <apex:inputField value="{!s.UnitPrice}" style="width:70px" required="true" onkeyup="refreshTotals();"/>
                    </apex:column>

                    <apex:column headerValue="{!$ObjectType.OpportunityLineItem.Fields.Description.Label}">
                        <apex:inputField value="{!s.Description}" required="false"/>
                    </apex:column>

                </apex:pageblockTable>
                <apex:pageBlockButtons >
                    <apex:commandButton action="{!onSave}" value="Save"/>
                    <apex:commandButton action="{!onCancel}" value="Cancel" immediate="true"/>
                </apex:pageBlockButtons>

            </apex:pageBlock>



            <apex:pageBlock id="pb">

                <apex:outputPanel styleClass="search">
                    Search for {!$ObjectType.Product2.LabelPlural}:
                </apex:outputPanel>

                <apex:actionRegion renderRegionOnly="false" immediate="true">

                    <apex:actionFunction name="fetchResults" action="{!updateAvailableList}" reRender="searchResults" status="searchStatus"/>

                    
                    <apex:inputText value="{!searchString}" onkeydown="if(event.keyCode==13){this.blur();}else{resetTimer();}" style="width:300px"/>
                      
                    <i>
                        
                        <apex:actionStatus id="searchStatus" startText="searching..." stopText=" "/>
                    </i>

                </apex:actionRegion>

                <br/>
                <br/>

                <apex:pageBlockButtons >
                        <apex:commandButton onclick="return addRecs();" value="Add Selected Records" />
                        <apex:commandButton action="{!reset}" value="Reset Selection" immediate="true" />
                </apex:pageBlockButtons>
                <apex:actionFunction name="addSelectedRecs" action="{!addSelectedRecords}" immediate="true" rerender="selected">
                    <apex:param value="" assignTo="{!selectedRelatedProds}" name="selectedRelatedProds"/>
</apex:actionFunction>
<apex:outputPanel id="searchResults">
<apex:pageBlockTable value="{!AvailableProducts}" var="a">
<apex:column >
<apex:inputCheckbox id="idSelected" onclick="checkBoxChecked(this,'{!a.Id}');"/>
</apex:column>
<apex:column headerValue="{!$ObjectType.Product2.Fields.Name.Label}">
<apex:commandLink action="/{!a.Product2.Id}" value="{!a.Product2.Name}"/>
</apex:column>
<apex:column headerValue="{!$ObjectType.PricebookEntry.Fields.UnitPrice.Label}" value="{!a.UnitPrice}"/>

<apex:column headerValue="{!$ObjectType.Product2.Fields.Family.Label}" value="{!a.Product2.Family}"/>
<br/>
<div>
<apex:panelGroup >
<apex:commandLink action="{!First}" value="First" immediate="true" reRender="pb" />
  
<apex:commandLink action="{!Previous}" reRender="pb" value="Previous" immediate="true" rendered="{!hasPrevious}"/>
  
<apex:outputLabel > Page No# {!pageno} </apex:outputLabel>    
<apex:commandLink action="{!Next}" value="Next" immediate="true" rendered="{!hasNext}" reRender="pb"/>
  
<apex:commandLink action="{!Last}" value="Last" immediate="true" reRender="pb"/>
  
</apex:panelGroup>
</div>
</apex:outputPanel>
<apex:outputPanel id="custompopup">
<apex:outputPanel styleClass="popupBackground" layout="block" rendered="{!displayPopUp}"/>
<apex:outputPanel styleClass="custPopup" layout="block" rendered="{!displayPopUp}">
<apex:pageBlock title="Related Products">
<apex:pageBlockTable value="{!RelatedProducts}" var="a">
<apex:column >
<apex:inputCheckbox id="idRelSelected" onclick="selRelatedRecs(this, '{!a.Id}');"/>
</apex:column>
<apex:column headerValue="{!$ObjectType.Product2.Fields.Name.Label}">
<apex:commandLink action="/{!a.Product2.Id}" value="{!a.Product2.Name}"/>
</apex:column>
<apex:column headerValue="{!$ObjectType.PricebookEntry.Fields.UnitPrice.Label}" value="{!a.UnitPrice}"/>

<apex:column headerValue="{!$ObjectType.Product2.Fields.Family.Label}" value="{!a.Product2.Family}"/>
</apex:pageBlockTable><br/>
<apex:pageBlockButtons >
<apex:commandButton value="Close" action="{!closePopup}" immediate="true" rerender="custompopup" />
</apex:pageBlockButtons>
</apex:pageBlock>
</apex:outputPanel>
</apex:outputPanel>
<apex:actionFunction name="ShowPopup" action="{!showPopup}" immediate="true" rerender="custompopup">
<apex:param value="" assignTo="{!toSelect}" name="toSelect"/>
</apex:actionFunction>
</apex:pageBlock>
</apex:outputPanel>
</apex:form>
</apex:page>

Thank you!

Andrew

gina.lasita1.3920678327807358E12
June 10, 2014
Like
0

3 replies

Apex CPU Time Limit

gina.lasita1.3920678327807358E12
June 10, 2014
Like
0

7 replies

Force.com for Amazon Web Services -- Access Denied

Hi all,

I installed the Force.com for Amazon Web Services app into my Developer org and set up my S3 credentials, carefully following the instructions on this page:

http://wiki.developerforce.com/page/Installing_Force_for_Amazon_Web_Services

However, I consistently get this message, e.g. when I click on the "S3 Samples" tab:

Web service callout failed: WebService returned a SOAP Fault: Access Denied faultcode=soapenv:Client.AccessDenied faultactor=

Is there something I have missed in the setup that would cause this error?

thanks!

Matt

matthewsmith
April 11, 2013
Like
0