Salesforce中MIXED_DML_OPERATION错误(Setup与Non-Setup对象)的解决方案
- 7月
- 21
- Posted by Lin
- Posted in APEX, Salesforce
The folloing error will be occured if you’re trying to perform DML operation on both setup and non-setup objects in the same transation.
` MIXED_DML_OPERATION, DML operation on setup object is not permitted after you have updated a non-setup object (or vice versa): CustomObject__c, original object: User: [] `
Here is the sample code that can explain this case.
Setup objects are the sObjects that affect the user’s access to records in the organization. For operations with correct access-level permissions, you must insert or update these types of sObject in a different transaction.
Here are examples of the Setup Objects:
・ObjectPermissions
・PermissionSet
・PermissionSetAssignment
・QueueSObject
・Territory
・UserTerritory
・UserRole
・User
fields: UserRoleId, IsActive, ForecastEnabled, IsPortalEnabled, Username, ProfileId
Happy Coding!
Reference :
https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_dml_non_mix_sobjects.htm
` MIXED_DML_OPERATION, DML operation on setup object is not permitted after you have updated a non-setup object (or vice versa): CustomObject__c, original object: User: [] `
Here is the sample code that can explain this case.
Setup objects
So, which objects are setup objects in Salesforce?Setup objects are the sObjects that affect the user’s access to records in the organization. For operations with correct access-level permissions, you must insert or update these types of sObject in a different transaction.
Here are examples of the Setup Objects:
・ObjectPermissions
・PermissionSet
・PermissionSetAssignment
・QueueSObject
・Territory
・UserTerritory
・UserRole
・User
fields: UserRoleId, IsActive, ForecastEnabled, IsPortalEnabled, Username, ProfileId
Solution
To fix this kind of error, you can perform DML operations on more than one transation, e.g. using a Future method.Happy Coding!
Reference :
https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_dml_non_mix_sobjects.htm
Post Tagged with @future, DML, IsActive, MIXED_DML_OPERATION, non-setup object, setup object, User, UserRole
近期文章
- Salesforce DevTools的开发者用户突破10,000名!THANK YOU!
- Lightning Component中使用Promise处理Apex服务端请求
- Pipeline for Salesforce – Be less busy, less mistake in Salesforce metadata deploy
- Salesforce Smart Importer – 1-Drag to import Excel / CSV in Salesforce, supports both Classic and Lightning!
- 用Visual Studio Code架设Salesforce DX的快速开发IDE环境
Top Posts
- 用Sublime Text 3架设Salesforce的快速开发环境 - 92.3K views
- Salesforce DevTools – Saleforce.com开发者必备Chrome扩展 - 62K views
- Salesforce批量编辑 (Chrome扩展) – 在任何标准视图上进行批量插入, 拷贝, 更新, 删除, 支持Classic与Lightning! - 43.2K views
- 编写一个可被计划执行的Batch Apex - 34.8K views
- Date format 与 DateTime format - 33.3K views
分类目录
- APEX
- 应用
- Custom Label
- Custom Metadata
- Custom Setting
- Design & UI
- 交流会
- Heroku
- iOS & Object-c
- Lightnint Component
- Linux & Mac OS
- Metadata API
- Node.js
- Open Source
- Other
- PHP Framework
- Release Notes
- REST API
- Salesforce
- Salesforce DX
- SOQL
- Tesforce
- Tooling API
- Unit Tests
- Validation Rule
- Visualforce
- WordPress