Hi All,

I am sending a request to one system for matching record. It will send the response back with matching record ((to SFDC) with standard 9 digit postal code. But SFDC is trimming to 5 digits and saves into DB.  Means we are degrading data quality from SFDC side, Right?

Is there any way to stop that process?

any suggestion would be appreciated !!

Hi,

I have a trigger on opportunity, which submits the record for approval when it mets the criteria. But some how it is giving error:

Error Message when saving an opportunity:

OpportunityObject: execution of AfterInsert caused by: System.DmlException: Process failed. First exception on row 0; first error: INACTIVE_OWNER_OR_USER, owner or user is inactive. Org Id:00D80000000aP47 User Id:005800000036h9Y: [] Trigger.OpportunityObject: line 258, column 1

Line 258 in my trigger:

// create the new approval request to submit
Approval.ProcessSubmitRequest req = new Approval.ProcessSubmitRequest();
req.setComments('Submitted for approval. Please approve.');
req.setObjectId(Trigger.new[i].Id);

// submit the approval request for processing
Approval.ProcessResult result = Approval.process(req);

Debug Log:

16:40:26.868 (1868370000)|WF_PROCESS_NODE|Step 1(Approval based on first response)
16:40:26.873 (1873156000)|WF_NEXT_APPROVER|Test User1|User|
16:40:26.874 (1874235000)|WF_NEXT_APPROVER|Test User2|User|  -->(Users defined in Approvel Process)
16:40:26.875 (1875200000)|WF_NEXT_APPROVER|Test User3|User|
16:40:27.512 (2512015000)|EXCEPTION_THROWN|[EXTERNAL]|System.NoAccessException: Invalid connected application: Chatter_for_iOS with Namespace: sf_chttr_apps
16:40:27.515 (2515129000)|EXCEPTION_THROWN|[EXTERNAL]|System.NoAccessException: Invalid connected application: Chatter_for_Android with Namespace: sf_chttr_apps
16:40:27.644 (2644188000)|CODE_UNIT_FINISHED|Workflow:ApprovalProcessActions
16:40:27.644 (2644403000)|DML_END|[258]
16:40:27.644 (2644565000)|EXCEPTION_THROWN|[258]|System.DmlException: Process failed. First exception on row 0; first error: INACTIVE_OWNER_OR_USER, owner or user is inactive. Org Id:00DV00000087oVG User Id:00580000003SS10: []
16:40:27.646 (2646404000)|SYSTEM_METHOD_EXIT|[258]|Approval.process(Approval.ProcessRequest)
16:40:27.646 (2646531000)|FATAL_ERROR|System.DmlException: Process failed. First exception on row 0; first error: INACTIVE_OWNER_OR_USER, owner or user is inactive. Org Id:00DV00000087oVG User Id:00580000003SS10: []

Trigger.OpportunityObject: line 258, column 1
16:40:27.646 (2646558000)|FATAL_ERROR|System.DmlException: Process failed. First exception on row 0; first error: INACTIVE_OWNER_OR_USER, owner or user is inactive. Org Id:00DV00000087oVG User Id:00580000003SS10: []

Trigger.OpportunityObject: line 258, column 1

My Understanding: I tried to execute this code in full sandbox & UAT. Error is coming with different inactive user. I believe who ever is inActive and retrived by code and error is coming with that inActive User.

1. I jus want to know the whats the relation between opportnity crating User & inActive User. 

2. Is this causing Error: Chatter_for_iOS with Namespace: sf_chttr_apps

                                           Chatter_for_Android with Namespace: sf_chttr_apps

Any suggestions would be greatly appreciated !!

Hello:

I am having issues with an Apex trigger designed to create a child records (Rep_Summary__c) after update of parent record (Video_Turf__c) where certain conditions are met.

Here is my trigger:

trigger RepSummaryCreation on Video_Turf__c (after update) {

    List<Rep_Summary__c> newSummary = new List<Rep_Summary__c>();
    for(Video_Turf__c a: trigger.new){
        if(a.Assigned__c==TRUE && a.Rep_One__c!=NULL){
            newSummary.add(new Rep_Summary__c(
                  Date__c = a.Date__c,
                  Release__c = a.ID,
                  Doors__c = a.Doors_Per_Rep__c,
                  Name = a.Rep_One__c));
        }
       }
  
    insert newSummary;
    
    List<Rep_Summary__c> newSummary2 = new List<Rep_Summary__c>();
    for(Video_Turf__c b: trigger.new){
        if(b.Assigned__c==TRUE && b.Rep_Two__c!=NULL){
            newSummary2.add(new Rep_Summary__c(
                  Date__c = b.Date__c,
                  Release__c = b.ID,
                  Doors__c = b.Doors_Per_Rep__c,
                  Name = b.Rep_Two__c));
        }
       }
  
    insert newSummary2;
    
    List<Rep_Summary__c> newSummary3 = new List<Rep_Summary__c>();
    for(Video_Turf__c c: trigger.new){
        if(c.Assigned__c==TRUE && c.Rep_Three__c!=''){
            newSummary3.add(new Rep_Summary__c(
                  Date__c = c.Date__c,
                  Release__c = c.ID,
                  Doors__c = c.Doors_Per_Rep__c,
                  Name = c.Rep_Three__c));
    }
   }
  
    insert newSummary3;
    
    List<Rep_Summary__c> newSummary4 = new List<Rep_Summary__c>();
    for(Video_Turf__c d: trigger.new){
        if(d.Assigned__c==TRUE && d.Rep_Four__c!=''){
            newSummary4.add(new Rep_Summary__c(
                  Date__c = d.Date__c,
                  Release__c = d.ID,
                  Doors__c = d.Doors_Per_Rep__c,
                  Name = d.Rep_Four__c));
    }
   }
  
    insert newSummary4;
    
    List<Rep_Summary__c> newSummary5 = new List<Rep_Summary__c>();
    for(Video_Turf__c e: trigger.new){
        if(e.Assigned__c==TRUE && e.Rep_Five__c!=''){
            newSummary5.add(new Rep_Summary__c(
                  Date__c = e.Date__c,
                  Release__c = e.ID,
                  Doors__c = e.Doors_Per_Rep__c,
                  Name = e.Rep_Five__c));
    }
   }
  
    insert newSummary5;
    
    List<Rep_Summary__c> newSummary6 = new List<Rep_Summary__c>();
    for(Video_Turf__c f: trigger.new){
        if(f.Assigned__c==TRUE && f.Rep_Six__c!=''){
            newSummary6.add(new Rep_Summary__c(
                  Date__c = f.Date__c,
                  Release__c = f.ID,
                  Doors__c = f.Doors_Per_Rep__c,
                  Name = f.Rep_Six__c));
    }
   }
  
    insert newSummary6;
    
    List<Rep_Summary__c> newSummary7 = new List<Rep_Summary__c>();
    for(Video_Turf__c g: trigger.new){
        if(g.Assigned__c==TRUE && g.Rep_Seven__c!=''){
            newSummary7.add(new Rep_Summary__c(
                  Date__c = g.Date__c,
                  Release__c = g.ID,
                  Doors__c = g.Doors_Per_Rep__c,
                  Name = g.Rep_Seven__c));
    }
   }
  
    insert newSummary7;
    
    List<Rep_Summary__c> newSummary8 = new List<Rep_Summary__c>();
    for(Video_Turf__c h: trigger.new){
        if(h.Assigned__c==TRUE && h.Rep_One__c!=''){
            newSummary8.add(new Rep_Summary__c(
                  Date__c = h.Date__c,
                  Release__c = h.ID,
                  Doors__c = h.Doors_Per_Rep__c,
                  Name = h.Rep_Eight__c));
    }
   }
  
    insert newSummary8;
    
    List<Rep_Summary__c> newSummary9 = new List<Rep_Summary__c>();
    for(Video_Turf__c i: trigger.new){
        if(i.Assigned__c==TRUE && i.Rep_Nine__c!=''){
            newSummary9.add(new Rep_Summary__c(
                  Date__c = i.Date__c,
                  Release__c = i.ID,
                  Doors__c = i.Doors_Per_Rep__c,
                  Name = i.Rep_Nine__c));
    }
   }
  
    insert newSummary9;
    
    List<Rep_Summary__c> newSummary10 = new List<Rep_Summary__c>();
    for(Video_Turf__c j: trigger.new){
        if(j.Assigned__c==TRUE && j.Rep_Ten__c!=''){
            newSummary10.add(new Rep_Summary__c(
                  Date__c = j.Date__c,
                  Release__c = j.ID,
                  Doors__c = j.Doors_Per_Rep__c,
                  Name = j.Rep_Ten__c));
    }
   }
    insert newSummary10;
                                        
}

 This seems to be a fairly straight forward trigger. What am I missing here that is not firing to create the records?

Thanks,

Hampton

Hi,

I am trying to find the photos of list of users. I am using below SOQL to get the PhotoUrl of USER:

SELECT Id,Name, FullPhotoUrl FROM User WHERE Id='123456789'

With that i can get the current page URL. 

Also, if someone uploads a second profile photo, I’m not sure where to find the original.

Any suggestions would be appreciated.

Hi,

I want to to extract Attachment Owner 'Photo' along with 'body' of the Attachment. Can anyone suggest SOQL to fetch the 'photo'?

I am trying this SOQL, but goving error like No such column:

Query from Attachment:

Select a.Body, a.Owner.FullPhotoUrl From Attachment a

ERROR at Row:1:Column:16

No such column 'FullPhotoUrl' on entity 'Name'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.

Query from USER:

Select FullPhotoUrl from User --> is working fine w/out error.

Any suggestions would be appreciated..

Hi,

Occasionally we seem to have a problem where emails received by Salesforce do not create cases. his causes us a serious issue as requests (orders) from customers will likely be missed. 

We receive a warning by email which states: 

"...The following errors were encountered while processing an incoming email: 

UNABLE_TO_LOCK_ROW : unable to obtain exclusive access to this record..."

What i did for this is:

We have 3 triggers on Case Object, which fires upon case creation for an incoming Email from customers. Put all the code in try catch blocks and write a chatter post in catch block. There by chatter group people will get a chatter post upon any lock error from any trigger. There by we can move that code to batch class and call it in future method. So that, we can remove that lock error.

Does my approach solve this problem?

Any suggestions would be appreciated?

Hi All,

If i create a Case through Email-to-Case standard SFDC functionality, I should be able to execute all the triggers on Case Object, Right?

I couldn't see case object triggers firing eventhough i created a case record sucessfully in my org through 'Email Service Address' provided by Email-to-Case functionality?

should i configure anything else?

Any help would be appreciated !!

Hi EVeryone,

We are facing service issue..

 Below is error description. We are getting this, when we are trying to log in to any one of our sandboxes..

Hi,

   I am getting this one Error while executing my opportunity Wizard: List has more than 1 row for assignment to SObject

I have enabled my debugs and try to find out in which line error happened. But nothing can findout 4m my debug log. It doen't display any error details.

Reasons might be:  Any SOQL is getting 2 or more records insted of single record.

we can eliminate this situation by putting 'Limit 1' to SOQL....Right?

NOTE: This error is not happening at all times, Error coming only in Some times...

Any guess for this error and any suggestions how to solve this error?

Any help would be greatly appreciated....!!!

-Srinu

Hi,

 I am working on a trigger, which changes the default "UserRoleId" to "Executive" from "User".

 To achieve above functionality, I have written trigger like below:

//
//Trigger that changes the default role of a new user that is NOT a Standard user from the “User” role to the “Executive” role
//

trigger ChnageDefaultUserRole on User(before insert,before update) {

    Set<Id> accIdSet = new Set<Id>();
    Set<Id> conIdSet = new Set<Id>();
    Map<Id, Contact> conMap = new Map<Id, Contact>();
    Map<Id, Id> userAcctMap = new Map<Id, Id>();
    
    for(user u:trigger.new) {
        if(Trigger.isInsert) {
            if(u.contactId != null){ 
              if(u.UserType != 'Standard'){
                conIdSet.add(u.contactId);
                userAcctMap.put(u.AccountId, u.Id);
               }
             }
        } else {
            if((u.AccountId != null)){
              if(u.UserType != 'Standard'){
                accIdSet.add(u.AccountId);
                userAcctMap.put(u.AccountId, u.Id);
               }
            }
        }
    }
        

    if(trigger.isinsert){
        List<UserRole> usrRole  = new List<UserRole>();
        if(!conIdSet.isEmpty()) {
            conMap = new Map<Id, Contact>([Select Id, AccountId, Account.Name from Contact where id IN: conIdSet]);
            for(Contact con: conMap.values()) {
                accIdSet.add(con.AccountId);
            }
        }    
    }
    //@future methods call out happens here
   if(accIdSet.size()!= Null && accIdSet.size() > 0){
     UserDefaultRoleChange.RoleChange(userAcctMap,accIdSet, conIdSet);
   }
}

  Class:

Public Class UserDefaultRoleChange{
    @future
     public static void RoleChange(Map<Id, Id> userAcctMap,Set<Id> accIdSet, Set<Id> conIdSet){
         Map<Id, Account> accInfoMap = new Map<Id, Account>([Select Id, Name,OwnerId from Account where Id IN: accIdSet]);
         Set<String> accNameSet = new Set<String>();
         Map<Id, Contact> conMap = new Map<Id, Contact>();
         List<User> UpdateUserList = new List<User>();
         
        for(Account acc: accInfoMap.Values()) {    
            accNameSet.add(acc.name + ' Customer Executive');
        }        
        
        List<UserRole> usrRole = [Select Id, Name From UserRole Where Name IN: accNameSet];
        Map<String, Id> usrMap = new Map<String, Id>();        
        for(UserRole ur: usrRole) {
            usrMap.put(ur.name, ur.Id); 
        }
        
        for(Account acct : accInfoMap.Values()){
          if((acct.name + ' Customer Executive') != null){
            if(usrMap.get(acct.name + ' Customer Executive') != null) {
                User us = new User();
                us.UserRoleId = usrMap.get(acct.name + ' Customer Executive');                
                UpdateUserList.add(us));
            }
          }
        }
        
        if(UpdateUserList.size() > 0)
           update UpdateUserList;           
        
     }
}

 I am geeting this error:

EXCEPTION_THROWN|[51]|System.DmlException: Update failed. First exception on row 0; first error: MISSING_ARGUMENT, Id not specified in an update call: []

//UpdateUserList.add(new User(Id=acct.OwnerId, UserRoleId = usrMap.get(acct.name + ' Customer Executive')));

    Error For Above line:

Class.UserDefaultRoleChange.RoleChange: line 50, column 1
00:35:06.428 (428327000)|FATAL_ERROR|System.DmlException: Update failed. First exception on row 0 with id 005600000018VhmAAE; first error: FIELD_INTEGRITY_EXCEPTION, role type must match user type: []

any hep would be appreciated?

Hello Guys,

We are having one huge class , which is around 1500 lines of code in it and contains only one method.

now when we are trying to add any new code in methhod it shows compile error as below 

Compile Error : Method exceeds maximum number of allowed op codes, please break this method into multiple ,smaller methods.

Does is there any limit for code length in class function.

Any help will be apritiated .

Thanks,

Bala

{faultcode:'soapenv:Client', faultstring:'System.CalloutException: Web service callout failed: Unexpected element. Parser was expecting element 'http://schemas.xmlsoap.org/soap/envelope/:Envelope' but found ':HTML'

Class.ApexcallingBpelSimple.ApexCalling_BPEL_SimplePort.process: line 19, column 13
Class.SFDCSyncWrapper.CreateFunction: line 12, column 17
External entry point', }

how to fix this

Thanks,

Vivek.

We have a trigger on the Account object that's part of a managed package.

If an unlicensed user edits something on the account page, I'm getting a general System.Exception exception saying that an object doesn't have an 'Id' field... 

Wondering two things:

1. Can I wrap all of the contents of my trigger in a try/catch statement to prevent this error, and
2. Can I use a System.NoAccessException to catch this so that other exceptions are handled differently?