Questions tagged [dml]

Use this tag for questions about DML, the data manipulation language used in apex to perform operations as insert, update, delete, and restore data in the database.

Filter by
Sorted by
Tagged with
3
votes
2answers
4k views

How to create thousands of records using batch apex

I have a scenario where I have to create 30000 contacts and 15,000 accounts (i.e. 2 contacts per account) in an org. I have been trying to do this by using batch apex but I still have error of "First ...
2
votes
4answers
175 views

DmlException: Update Failed. Maximum Trigger Depth Exceeded

I have below trigger code getting - DML Exception 'Maximum Trigger Depth Exceeded'. Can someone help me please? Apex Trigger trigger updateAoC on Contract_vod__c(after update) { List<...
4
votes
1answer
1k views

Mixed DML Operation Error when Trying to Insert Contact

The basic premise of this code, for those of you who have not seen my 600+ other posts about it, is that it creates a Contact whenever someone creates a User. Certain fields of the contact are then ...
2
votes
1answer
1k views

Upsert with External ID: DUPLICATE_VALUE Error

I'm trying up upsert Asset records with an external Id and am getting the DUPLICATE_VALUE error which makes no sense to me: I want it to UPDATE the record if it finds a duplicate, that's what UPSERT ...
1
vote
2answers
2k views

null values of some fields on inserting data in test class

I have 2 custom object namely ServiceContract & ServiceRole and 1 standard object Account.In service role object,Account is Master-detail relationship to Account and ServiceContract is also Master-...
-2
votes
1answer
2k views

System.DmlException: Insert failed. First exception on row 0; first error: REQUIRED_FIELD_MISSING, Required fields are missing

Can any one help me out with this error : System.DmlException: Insert failed. First exception on row 0; first error: REQUIRED_FIELD_MISSING, Required fields are missing: [OpportunityId]: [...
6
votes
2answers
570 views

DML Limits are reset when?

I have a scenario where I need to update 500,000 Accounts in production to change their Record Type, but I want to avoid writing a Batch class for one-time use. In addition, using DataLoader would ...
0
votes
0answers
105 views

Able to make isactive = false for such users who are manager of some other users

I am able to make isactive=false for such users who are manager of some other users.As per salesforce funtionality i should not be able to make isactive=false using DML as it will throw dependency ...
0
votes
1answer
141 views

Successful DML operation not getting updated in database

I am using below code for batch update : List<Database.SaveResult> updateResults; updateResults = Database.update(listUserDeactivate, false); System.debug('value of users for ...
0
votes
1answer
93 views

Param values are not being passed to the custom controller using commandbutton

Need pro's help. Below are my code snippets. This is what I have tried I have initialized the object Event_Request__c {get; set;} in my controller class. I have created a public method to update the ...
0
votes
1answer
280 views

Will a parent record be updated if you update it's child object (including related fields on the parent)

I can write a SOQL relationship query to lookup Contacts, and at the same time get some data on the related Account. This returns a list of Contacts, each of which has data on it's related parent ...
0
votes
1answer
218 views

delete multiple records from an object [closed]

I want to delete multiple records of an object...How should I do it. public class del_acc { public List<String> sel_id{get;set;} set<id> sid = new set<id>(); List<...
6
votes
1answer
554 views

DML not allowed on NetworkMemberGroup

I am trying to automate the process whereby all profiles are given access to communities. This section when managing a community: As I understand it, this is the NetworkMemberGroup object. I ...
4
votes
2answers
702 views

Performance issue when deleting Opportunity Line Items

I'm writing APEX REST API that creates OpportunityLineItem, Product2, Quote objects, updates Opportunity etc. based on data in JSON format received from external system. During testing I experienced ...
3
votes
2answers
130 views

Links to Documentation for Database.* DML Method? Gone from APEX Docs

So we've got the usual DML statements insert accts; and we've got the database class dml statements, e.g. Database.insert(accts, false). Had a team member ask me a question about the parameter ...
7
votes
1answer
102 views

Combining DML, Callouts and Triggers gives CalloutException

When running unit tests, I'm currently getting: System.CalloutException: You have uncommitted work pending. Please commit or rollback before calling out The issue is that I have a trigger that ...
1
vote
2answers
878 views

scheduled apex+Too many DML rows: 10001

I am getting this error when i look at my apex jobs UI "Scheduler: failed to execute scheduled job: jobId: 7072000002391Am, class: common.apex.async.AsyncApexJobObject, reason: Too many DML ...
0
votes
2answers
426 views

Update a text field from custom object to Notes Related List

I have a requirement in which I have a custom object. I have a text field in that object. When that text field is filled with a value it show create a note in the related list in which i need to map ...
2
votes
1answer
687 views

Database DML Update partial success versus Data Loader

I have a Trigger On OpportunityLineItem when it's get updated, it will update the Opportunity. I need to update OpportunityLineItem in Bulk. For that, Using Dataloader I kept the (batch size =200) of ...
3
votes
2answers
134 views

How to iterate and update a value of a field throughout considerable number of records?

Attempted to set a value to a field of the account object across 70000 records using anonymous apex execution causes below exception; System.LimitException: Apex CPU time limit exceeded This is ...
0
votes
2answers
684 views

How do I Mass update owner in Contact and Account?

In my ORG I have a 20K Accounts and 50K Contacts. I want to update Contact and Account owner where owner is "Jai" to "Mrugesh". How to update all Contact and Account owner?
0
votes
1answer
53 views

Trigger to check for dupes and get data from them - Insert failed - cannot specify Id in an insert call

So I'm receiving some Accounts from an external source. They could be exactly the ones I already have on the org but this external ones also have some custom Ids that I need to assign to the old ones. ...
10
votes
1answer
2k views

How To Cause DmlException - Delete

I thought I would be able to take a User who does not have delete privileges on an object, delete records from that object, and get a DmlException. No dice. Below are the Case permissions for the ...
2
votes
1answer
591 views

How can I show the progress of a chain batch process?

I have an Apex class that is a controller for a Visualforce page. The VF page has a commandButton that calls a function in the controller that executes a batch process that processes some data, then ...
5
votes
1answer
5k views

Can't Insert User in Test Class

I've created a Trigger on the User object and I'm trying to test creation, update, deletion and undeletion of a User. Starting with Insert DML, I've got the following code: Profile p = [SELECT Id ...
0
votes
1answer
280 views

Delete a Record Using Visualforce

I tried this code i m getting error like this "List has no rows for assignment to SObject" public class delrecords { public string cid{get;set;} public list<contact> conlist{get;set;} ...
1
vote
1answer
712 views

Use addError method and make a DML operation

The problem that I am having is that I am using addError method in before insert trigger which actually rollback every DML I make including @future method calls, sending email, queueing batch jobs, or ...
3
votes
1answer
715 views

How many DML statements will be execute?

Given the code below, and assuming there are 500 accounts in the system, how many DML statements will be executed? for (List<Account> accounts : [SELECT Id, Name]) { update Accounts; }
1
vote
0answers
146 views

Large time gap in debug log before ENTERING_MANAGED_PKG

When viewing a debug log where the logging level was set to: APEX_CODE,FINEST;APEX_PROFILING,INFO;CALLOUT,INFO;DB,INFO;SYSTEM,DEBUG;VALIDATION,INFO;VISUALFORCE,INFO;WORKFLOW,INFO I am seeing a large ...
1
vote
1answer
479 views

Modifying data using SOQL?

I'm using SOQL along with the SOAP API in order to pull a certain set of data to my webpage. However, I want to modify this data (two custom fields) and update the records in Salesforce itself. As I ...
1
vote
1answer
1k views

Unable to Assign Owner to Record

We have a custom object called Lead__c for which I'm trying to execute DML on it to insert a record. However, I need to assign the owner to it. I've got the following query to search for an owner: ...
2
votes
1answer
687 views

Http callout test class “uncommitted work pending” error with no clear cause

We have method EnrollmentUtil.createNewEnrollment which contains a http callout on create of custom object Enrolment__c, and a test class to test this method. I'm trying to figure out how this class ...
0
votes
0answers
32 views

Unexpected System.CalloutException in test while using startTest method

@isTest global class xxx_UT implements WebServiceMock { static { Account account = new Account(Name = 'Test Account'); insert account; Qwerty__c q = new Qwerty__c(); insert q; ...
0
votes
1answer
36 views

Edit Account after Update DML statement

Is there a way to continue editing an account after using the update DML statement? I keep getting the error: "attempt to dereference a null object". The reason that I am trying to update the account ...
5
votes
2answers
183 views

Difference between defining these Inserts

Apologies if the title is a little vague here. I was using the following code to attempt a insert DML: for (ts2__Placement__c pla : selectedPlacements) { Timecards__c t = new Timecards__c( t....
4
votes
1answer
241 views

How to put DML operation outside the for loop?

I wrote one for loop and perform insert,update operation inside the for loop, it is working clearly but i need to perform that operation outside the for loop so is the better way to do it ? for(...
0
votes
1answer
63 views

Having error (NullPointerexception : Attemp to de-reference Null)

I am trying my best with this code but don't know why i am getting error System.NullPointerException: Attempt to de-reference a null object can you please tell me that what i have did wrong. ...
0
votes
1answer
62 views

Trigger Governor limits concern [closed]

I have a concern for below triggers, should we hit governor limits for more than 200 records updated at one go? Trigger 1: trigger BatchTrigger on Compliance_Incident_abv__c (after update) { if(...
0
votes
2answers
979 views

Error while doing a DML after a Webservice call

I need to parse a webservice result first to take actions afterwards. "You have uncommitted work pending. Please commit or rollback before calling out" I'm getting now this error, and there are a ...
1
vote
1answer
63 views

writing apex DML and soql using less number of statements [closed]

i recently started working with Force.com. I use SOQL and Apex to do DML a lot. I recently learnt a way to do something i do very frequently with very less number of lines. I would like to know if ...
0
votes
2answers
3k views

Apex - populate field with a value stored in mapping object

I am trying to solve the following problem: There is a text field "Product" on Opportunity object and I need to change the values of that and map it to picklist. There is already data in the system ...
2
votes
1answer
717 views

Apex scope for creating temporary sObjects

I have a trigger that creates child objects on insert/update. The update trigger has logic based on a field on the parent object. Depending on this field, it may create 1 or 2 child objects. When I ...
1
vote
1answer
60 views

Getting trigger's changes after dml statement

I'm trying to use object's fields updated in a trigger in the context where the DML statement is executed, however I'm not being able to get the new values assigned by the trigger. I did the ...
1
vote
2answers
792 views

Apex After Update delete child then create new child

I have a simple trigger where when an opportunity is inserted, it creates a child object. If the opportunity is updated, it deletes all child objects and creates a new one. However, I receive an error ...
1
vote
1answer
222 views

weird behaviour of insert when doing calling before getContent() call?

I am trying to generate multiple documents(which are VF page rendered as Word doc), by iterating over a map. As my first step, i am reading a report, generating a map(where key is a string and value ...
3
votes
2answers
727 views

Exception Handling on child records when parent is updated

Please let me know how to perform exception handling in this scenario? Though we have added error message on child record we couldn't see it on the parent while the parent record is being updated (as ...
1
vote
1answer
151 views

Update standard object fields from custom object

is it possible to update number of fields of standard object from custom object using apex and visualforce. We cannot call the API within the org. But however could we use SOQL for DML transaction ...
1
vote
1answer
163 views

Is there a way to update duplicate leads in an apex list

Hoping you can help.. We receive bulk email marketing data into Salesforce which creates 'events'. These events include things like the date, if any URL was clicked and if so, what the URL was. We ...
2
votes
1answer
167 views

DML not allowed on Network

My requirement needs to change the "from email address" for the welcome mail that is sent from a community after a new user is registered. But this needs to be done dynamically based on some ...
3
votes
2answers
706 views

Is it possible to create the SkillUser object from apex

We are using Live Agents for a service implementation, but due to implementation decisions made, cant use Profiles to assign Skills for the Live Agents, and need to assign individual users to their ...