- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-03-2019 07:33 PM
We have 2 business service field in incident table, one is out of box and another field is from task table . both referenced to CMDB_CI table. I'm trying to copy u_business_service to business_service using fix script as below. its just updating few records for each execution. i have about 9000 records to update. initially i received data policy error and i've included "gr.setUseEngines(false);" in the script . Is there any limitation for updating records? what could be the problem?
var gr = new GlideRecord('incident');
gr.addEncodedQuery('u_business_serviceISNOTEMPTY');
gr.addQuery();
gr.query();
while(gr.next()){
gr.business_service = gr.u_business_service;
gr.setWorkflow(false);
gr.setUseEngines(false);
gr.update();
}
Solved! Go to Solution.
- Labels:
-
Field Service Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-03-2019 11:42 PM
Hi All,
this is fixed, its due to rules set for fix script to execute any script just for few minutes to avoid system slowness while execute the scripts.
I run fix script few times to update the records.
Thanks for the suggestions.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-03-2019 08:24 PM
You can check any existing Data Policies for mandatory field rules.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-03-2019 11:42 PM
Hi All,
this is fixed, its due to rules set for fix script to execute any script just for few minutes to avoid system slowness while execute the scripts.
I run fix script few times to update the records.
Thanks for the suggestions.