Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
karthik Jonnalagaddakarthik Jonnalagadda 

Error While adding a record into object

Hi,
I am getting bellow error while adding a record into projects object, what is this exactly mean.

Error: Invalid Data. 
Review all error messages below to correct your data.
You must have a Group Name in order to create Projects. Contact an LM2 Admin in order to correct.
Best Answer chosen by karthik Jonnalagadda
Chidambar ReddyChidambar Reddy
There is a trigger on Project object

projectToNetDocuments 

Check Line number 32 

 

All Answers

Ashish_Sharma_DEVSFDCAshish_Sharma_DEVSFDC
Hi karthik Jonnalagadda,

I suggest to check required fields for Projects.
Please paste your code .

Let us know if it helps you.
Chidambar ReddyChidambar Reddy
Hi Karthik,

Please check Project Validation Rules.

There is a validation rule to check the Group Name is blank, and fires the error.
karthik Jonnalagaddakarthik Jonnalagadda
HI Chidambar Reddy,
I have only these validation rules.
User-added image
Nothing related to Group name or something.
 
karthik Jonnalagaddakarthik Jonnalagadda
HI  Ashish Sharma,

Only two fields are required and I am passing values for those two fields.
User-added image
Why it is saying contact LM2 Admin ? Is this something related to Permissions If so where can I resolve this issue.
 
Chidambar ReddyChidambar Reddy
Where from you are creating Projects?

Is it a visualforce page with Apex Controller/Extension?

Why don't you check Debug Logs to trace the exception. https://www.salesforce.com/us/developer/docs/apexcode/Content/code_setting_debug_log_levels.htm
karthik Jonnalagaddakarthik Jonnalagadda
HI Chidambar Reddy,

No Its not Visualforce page. Its direct custom object, its working for production account but not for sandbox account(System Administrator).
Chidambar ReddyChidambar Reddy
Okay, Is it a child of a Master-Detail Relationship? If so check parent object Validation Rules.

And post Debug Log Screenshots if you are not able to trace.
karthik Jonnalagaddakarthik Jonnalagadda
Hi,
Project it self is master Object,It having few child objects.

User-added image
Nothing related to object in the Debug log.
Chidambar ReddyChidambar Reddy
Hi Karthik,

Go to Setup > Monitor > Logs > Debug Logs.

Click New and add your user to monitor. then repeat the process of creating the Projects.

Then refresh the debug logs page, then you would be getting a log with something like a01/e
KeyPrefix/e

Open that log and click Ctrl + F and search for the insert

Post screenshots of the Log
karthik Jonnalagaddakarthik Jonnalagadda
Hi,

I got traced bellow code in  log.

  
Log    
29.0 APEX_CODE,DEBUG;APEX_PROFILING,INFO;CALLOUT,INFO;DB,INFO;SYSTEM,DEBUG;VALIDATION,INFO;VISUALFORCE,INFO;WORKFLOW,INFO
02:50:23.070 (70023918)|EXECUTION_STARTED
02:50:23.070 (70061685)|CODE_UNIT_STARTED|[EXTERNAL]|TRIGGERS
02:50:23.070 (70098928)|CODE_UNIT_STARTED|[EXTERNAL]|01qj0000000KlDM|projectBefore on Ibanking_Project trigger event BeforeInsert for [new]
02:50:23.070 (70851853)|SYSTEM_METHOD_ENTRY|[14]|com.salesforce.api.interop.apex.bcl.DatetimeMethods.now()
02:50:23.070 (70911131)|SYSTEM_METHOD_EXIT|[14]|com.salesforce.api.interop.apex.bcl.DatetimeMethods.now()
02:50:23.070 (70932946)|SYSTEM_METHOD_ENTRY|[14]|com.salesforce.api.interop.apex.bcl.DatetimeMethods.format(String)
02:50:23.070 (70974805)|SYSTEM_METHOD_EXIT|[14]|com.salesforce.api.interop.apex.bcl.DatetimeMethods.format(String)
02:50:23.071 (71273511)|SYSTEM_METHOD_ENTRY|[17]|List<Ibanking_Project__c>.iterator()
02:50:23.071 (71477974)|SYSTEM_METHOD_EXIT|[17]|List<Ibanking_Project__c>.iterator()
02:50:23.071 (71507246)|SYSTEM_METHOD_ENTRY|[17]|system.ListIterator.hasNext()
02:50:23.071 (71534352)|SYSTEM_METHOD_EXIT|[17]|system.ListIterator.hasNext()
02:50:23.071 (71728675)|SYSTEM_METHOD_ENTRY|[21]|String.replace(String, String)
02:50:23.071 (71770797)|SYSTEM_METHOD_EXIT|[21]|String.replace(String, String)
02:50:23.071 (71843436)|SYSTEM_METHOD_ENTRY|[22]|String.replace(String, String)
02:50:23.071 (71871273)|SYSTEM_METHOD_EXIT|[22]|String.replace(String, String)
02:50:23.071 (71923349)|SYSTEM_METHOD_ENTRY|[23]|String.replace(String, String)
02:50:23.071 (71950000)|SYSTEM_METHOD_EXIT|[23]|String.replace(String, String)
02:50:23.071 (71998933)|SYSTEM_METHOD_ENTRY|[24]|String.replace(String, String)
02:50:23.072 (72024598)|SYSTEM_METHOD_EXIT|[24]|String.replace(String, String)
02:50:23.072 (72073364)|SYSTEM_METHOD_ENTRY|[25]|String.replace(String, String)
02:50:23.072 (72098291)|SYSTEM_METHOD_EXIT|[25]|String.replace(String, String)
02:50:23.072 (72145253)|SYSTEM_METHOD_ENTRY|[26]|String.replace(String, String)
02:50:23.072 (72170220)|SYSTEM_METHOD_EXIT|[26]|String.replace(String, String)
02:50:23.072 (72223490)|SYSTEM_METHOD_ENTRY|[27]|String.replace(String, String)
02:50:23.072 (72248045)|SYSTEM_METHOD_EXIT|[27]|String.replace(String, String)
02:50:23.072 (72296794)|SYSTEM_METHOD_ENTRY|[28]|String.replace(String, String)
02:50:23.072 (72321894)|SYSTEM_METHOD_EXIT|[28]|String.replace(String, String)
02:50:23.072 (72368955)|SYSTEM_METHOD_ENTRY|[29]|String.replace(String, String)
02:50:23.072 (72394917)|SYSTEM_METHOD_EXIT|[29]|String.replace(String, String)
02:50:23.072 (72451804)|SYSTEM_METHOD_ENTRY|[30]|String.endsWith(String)
02:50:23.072 (72475374)|SYSTEM_METHOD_EXIT|[30]|String.endsWith(String)
02:50:23.072 (72528807)|SYSTEM_METHOD_ENTRY|[17]|system.ListIterator.hasNext()
02:50:23.072 (72542184)|SYSTEM_METHOD_EXIT|[17]|system.ListIterator.hasNext()
02:50:23.072 (72561701)|CUMULATIVE_LIMIT_USAGE
02:50:23.072 (72561701)|LIMIT_USAGE_FOR_NS|(default)|
  Number of SOQL queries: 0 out of 100
  Number of query rows: 0 out of 50000
  Number of SOSL queries: 0 out of 20
  Number of DML statements: 0 out of 150
  Number of DML rows: 0 out of 10000
  Maximum CPU time: 0 out of 10000
  Maximum heap size: 0 out of 6000000
  Number of callouts: 0 out of 100
  Number of Email Invocations: 0 out of 10
  Number of future calls: 0 out of 50
  Number of queueable jobs added to the queue: 0 out of 50
  Number of Mobile Apex push calls: 0 out of 10

02:50:23.072 (72561701)|CUMULATIVE_LIMIT_USAGE_END

02:50:23.072 (72683116)|CODE_UNIT_FINISHED|projectBefore on Ibanking_Project trigger event BeforeInsert for [new]
02:50:23.080 (80566266)|CODE_UNIT_STARTED|[EXTERNAL]|Validation:Ibanking_Project:new
02:50:23.080 (80580475)|VALIDATION_RULE|03dj00000009s4m|Deal_Lead_Change_Limitation
02:50:23.080 (80946306)|VALIDATION_FORMULA|AND( 
    ISCHANGED( Deal_Lead__c ), 
    NOT( BEGINS($User.Username, 'ghacic@lm2network.com') ), 
    NOT( BEGINS($User.Username, 'greg.hacic@offerboard.com') ), 
    OR( 
        AND( 
            ISNULL( PRIORVALUE( Deal_Lead__c ) ), 
            OwnerId  <> $User.Id
        ), 
        AND( 
            NOT( ISNULL( PRIORVALUE( Deal_Lead__c ) ) ), 
            PRIORVALUE( Deal_Lead__c ) <> $User.Id
        )
    )
)|Deal_Lead__c=null , OwnerId=005g00000020JkH , $User.Username=anil@offerboard.com , $User.Id=005g00000020JkH
02:50:23.080 (80959354)|VALIDATION_PASS
02:50:23.080 (80963486)|VALIDATION_RULE|03dj00000009s4n|Project_Name_Cannot_Be_Changed
02:50:23.081 (81194953)|VALIDATION_FORMULA|AND( 
    ISCHANGED( Name ), 
    NOT( CONTAINS($User.Username, 'greg.hacic@offerboard.com') ), 
    NOT( ISNEW() )
)|Name=test - 513 , $User.Username=anil@offerboard.com
02:50:23.081 (81206973)|VALIDATION_PASS
02:50:23.081 (81211097)|VALIDATION_RULE|03dj00000009s4o|Project_Name_Cannot_Contain_Ampersand
02:50:23.081 (81279588)|VALIDATION_FORMULA|CONTAINS( Name, '&')|Name=test - 513
02:50:23.081 (81287915)|VALIDATION_PASS
02:50:23.081 (81291074)|VALIDATION_RULE|03dj00000009s4l|Deal_Burden_May_Not_Exceed_100_Percent
02:50:23.081 (81657663)|VALIDATION_FORMULA|Deal_Burden_From_DTE__c + Deal_Burden__c + Deal_Burden_Project_Specific__c > 100.0|Deal_Burden_Project_Specific__c=null , Deal_Burden__c=0 , Deal_Burden_From_DTE__c=null
02:50:23.081 (81667838)|VALIDATION_PASS
02:50:23.081 (81671301)|VALIDATION_RULE|03dj00000009s4p|TVP_Cannot_be_UnChecked
02:50:23.081 (81857992)|VALIDATION_FORMULA|AND( 
    NOT( CONTAINS($User.Username, 'greg.hacic@offerboard.com') ), 
    PRIORVALUE( TVP__c ) = true, 
    TVP__c = false
)|TVP__c=0 , $User.Username=anil@offerboard.com
02:50:23.081 (81868029)|VALIDATION_PASS
02:50:23.081 (81883310)|CODE_UNIT_FINISHED|Validation:Ibanking_Project:new
02:50:23.152 (152692423)|CODE_UNIT_STARTED|[EXTERNAL]|01qj0000000KlDN|projectToNetDocuments on Ibanking_Project trigger event AfterInsert for [a0Bg00000042yLZ]
02:50:23.153 (153054602)|SYSTEM_CONSTRUCTOR_ENTRY|[10]|<init>(Integer)
02:50:23.153 (153084838)|SYSTEM_CONSTRUCTOR_EXIT|[10]|<init>(Integer)
02:50:23.153 (153157324)|SYSTEM_CONSTRUCTOR_ENTRY|[11]|<init>()
02:50:23.153 (153176667)|SYSTEM_CONSTRUCTOR_EXIT|[11]|<init>()
02:50:23.153 (153284677)|SYSTEM_METHOD_ENTRY|[12]|System.UserInfo.getUserId()
02:50:23.153 (153333105)|SYSTEM_METHOD_EXIT|[12]|System.UserInfo.getUserId()
02:50:23.154 (154268223)|SOQL_EXECUTE_BEGIN|[13]|Aggregations:0|SELECT Group_Name__c, Profile.Name FROM User WHERE Id = :tmpVar1
02:50:23.165 (165627334)|SOQL_EXECUTE_END|[13]|Rows:1
02:50:23.165 (165880926)|SYSTEM_METHOD_ENTRY|[16]|String.toLowerCase()
02:50:23.165 (165912220)|SYSTEM_METHOD_EXIT|[16]|String.toLowerCase()
02:50:23.165 (165930470)|SYSTEM_METHOD_ENTRY|[16]|String.contains(String)
02:50:23.165 (165941714)|SYSTEM_METHOD_EXIT|[16]|String.contains(String)
02:50:23.165 (165959075)|SYSTEM_METHOD_ENTRY|[19]|com.salesforce.api.interop.apex.bcl.DateMethods.today()
02:50:23.166 (166004138)|SYSTEM_METHOD_EXIT|[19]|com.salesforce.api.interop.apex.bcl.DateMethods.today()
02:50:23.166 (166032497)|SYSTEM_METHOD_ENTRY|[20]|String.valueOf(Date)
02:50:23.166 (166065974)|SYSTEM_METHOD_EXIT|[20]|String.valueOf(Date)
02:50:23.166 (166089383)|SYSTEM_METHOD_ENTRY|[22]|List<Ibanking_Project__c>.iterator()
02:50:23.166 (166108274)|SYSTEM_METHOD_EXIT|[22]|List<Ibanking_Project__c>.iterator()
02:50:23.166 (166117559)|SYSTEM_METHOD_ENTRY|[22]|system.ListIterator.hasNext()
02:50:23.166 (166129017)|SYSTEM_METHOD_EXIT|[22]|system.ListIterator.hasNext()
02:50:23.166 (166186425)|SYSTEM_METHOD_ENTRY|[23]|Set<Id>.add(Object)
02:50:23.166 (166208074)|SYSTEM_METHOD_EXIT|[23]|Set<Id>.add(Object)
02:50:23.166 (166215594)|SYSTEM_METHOD_ENTRY|[22]|system.ListIterator.hasNext()
02:50:23.166 (166226081)|SYSTEM_METHOD_EXIT|[22]|system.ListIterator.hasNext()
02:50:23.166 (166439927)|SOQL_EXECUTE_BEGIN|[26]|Aggregations:0|SELECT Name FROM Ibanking_Project__c WHERE Id = :tmpVar1
02:50:23.170 (170267904)|SOQL_EXECUTE_END|[26]|Rows:1
02:50:23.170 (170372211)|SYSTEM_METHOD_ENTRY|[28]|List<Ibanking_Project__c>.iterator()
02:50:23.170 (170417069)|SYSTEM_METHOD_EXIT|[28]|List<Ibanking_Project__c>.iterator()
02:50:23.170 (170434264)|SYSTEM_METHOD_ENTRY|[28]|system.ListIterator.hasNext()
02:50:23.170 (170452893)|SYSTEM_METHOD_EXIT|[28]|system.ListIterator.hasNext()
02:50:23.170 (170596294)|SYSTEM_METHOD_ENTRY|[32]|SObject.addError(String, String)
02:50:23.170 (170642374)|SYSTEM_METHOD_EXIT|[32]|SObject.addError(String, String)
02:50:23.170 (170652086)|SYSTEM_METHOD_ENTRY|[28]|system.ListIterator.hasNext()
02:50:23.170 (170663937)|SYSTEM_METHOD_EXIT|[28]|system.ListIterator.hasNext()
02:50:23.170 (170683677)|SYSTEM_METHOD_ENTRY|[49]|List<Attachment>.isEmpty()
02:50:23.170 (170699784)|SYSTEM_METHOD_EXIT|[49]|List<Attachment>.isEmpty()
02:50:23.170 (170713664)|SYSTEM_METHOD_ENTRY|[53]|Set<Id>.isEmpty()
02:50:23.170 (170729478)|SYSTEM_METHOD_EXIT|[53]|Set<Id>.isEmpty()
02:50:23.170 (170751349)|SYSTEM_CONSTRUCTOR_ENTRY|[54]|<init>()
02:50:23.170 (170767686)|SYSTEM_CONSTRUCTOR_EXIT|[54]|<init>()
02:50:23.170 (170785700)|SYSTEM_METHOD_ENTRY|[54]|List<ANY>.add(Object)
02:50:23.170 (170796546)|SYSTEM_METHOD_EXIT|[54]|List<ANY>.add(Object)
02:50:23.170 (170803979)|SYSTEM_CONSTRUCTOR_ENTRY|[54]|<init>()
02:50:23.170 (170808772)|SYSTEM_CONSTRUCTOR_EXIT|[54]|<init>()
02:50:23.170 (170819440)|SYSTEM_METHOD_ENTRY|[54]|List<ANY>.add(Object)
02:50:23.170 (170830395)|SYSTEM_METHOD_EXIT|[54]|List<ANY>.add(Object)
02:50:23.205 (205820675)|CUMULATIVE_LIMIT_USAGE
02:50:23.205 (205820675)|LIMIT_USAGE_FOR_NS|(default)|
  Number of SOQL queries: 2 out of 100
  Number of query rows: 2 out of 50000
  Number of SOSL queries: 0 out of 20
  Number of DML statements: 0 out of 150
  Number of DML rows: 0 out of 10000
  Maximum CPU time: 0 out of 10000
  Maximum heap size: 0 out of 6000000
  Number of callouts: 0 out of 100
  Number of Email Invocations: 0 out of 10
  Number of future calls: 1 out of 50
  Number of queueable jobs added to the queue: 0 out of 50
  Number of Mobile Apex push calls: 0 out of 10

02:50:23.205 (205820675)|CUMULATIVE_LIMIT_USAGE_END

02:50:23.205 (205905953)|CODE_UNIT_FINISHED|projectToNetDocuments on Ibanking_Project trigger event AfterInsert for [a0Bg00000042yLZ]
02:50:23.244 (244051692)|CODE_UNIT_FINISHED|TRIGGERS
02:50:23.244 (244070315)|EXECUTION_FINISHED

 
Chidambar ReddyChidambar Reddy
There is a trigger on Project object

projectToNetDocuments 

Check Line number 32 

 
This was selected as the best answer
karthik Jonnalagaddakarthik Jonnalagadda
Hi Chidambar Reddy,

I didn't understood completly.
Is that trigger is failing ?. I think trigger is AfterInsert I check the values from the developer console, I didn't see any values in the object.
Chidambar ReddyChidambar Reddy
Hi Karthik,

I don't understand your company's requirements, I only understand Apex.

When I say that there is a trigger on Project and the line number where you are adding the error, you are coming back to me that you don't understand.

I don't know any reason why is that trigger unless you post that trigger code here. You, as a developer of your company must have known why is that trigger and when would it throws the error.

FYI, trigger is not failing, trigger is adding an error message. at 32 line
Chidambar ReddyChidambar Reddy
Hi Karthik,

Check your user record for the field Group_Name__c

Fill it and try again. I hope that would work.
karthik Jonnalagaddakarthik Jonnalagadda
Hi Chidambar Reddy,

Sorry for asking too many questions, I am very new to Salesforce, 
Finally its working, Thanks for your posts.
 
Chidambar ReddyChidambar Reddy
It's fine Karthik.

Was that the Group_Name__c in your user record empty? and Was that the reason for this error?
karthik Jonnalagaddakarthik Jonnalagadda
Hi ,
Reason is group name is different. Now I changed group name from my profile then its working.
  
  String groupName = runningUser.Group_Name__c;
if (groupName == null || groupName == '' || groupName == 'Group Name')

Thanks