We receive the following error message when trying to run the script below.
Environment: Production
Date & Time: 2/14/2014 3:32 pm
Execution Time: 790.35s
Script Usage: 10005
Script: UpdateAllBisac
Type: Scheduled
Function: updateAllBisac
Error: SSS_USAGE_LIMIT_EXCEEDED
Script Execution Usage Limit Exceeded
Stack Trace: updateAllBisac(updateallbisac.js$843955:52)
function updateAllBisac() {
var searchResults = nlapiSearchRecord('item', 'customsearch5022' , null, null);
var searchedItemId;
var lastId;
var completeResults = new Array();
var arrNewFilters = [];
if (searchResults != null) {
completeResults = completeResults.concat(searchResults);
}
else {
completeResults = null;
nlapiLogExecution('Debug', 'No item found', weight + ' Null result');
}
if (completeResults != null) {
if (searchResults.length == 1000) {
while (searchResults.length == 1000) {
//Initialize variable
lastId = "";
//Get Record Id of Last record,
//to search the item record again from that record
searchResults.sort();
lastId = searchResults[999].getId();
//start after the last id searched
arrNewFilters.push(new nlobjSearchFilter("internalidnumber",
null, "greaterthan", lastId));
//Lets search again
var searchResults = nlapiSearchRecord('item', 'customsearch5022', arrNewFilters, null);
if (searchResults != null) {
//Append the search result to the result present before
completeResults = completeResults.concat(searchResults);
}
}
}
}
var bisacs = new Array("ANT000000","ANT001000")
var translation = new Array("ANTIQUES & COLLECTIBLES / General","ANTIQUES & COLLECTIBLES / Americana")
for ( var j = 0; j < completeResults.length; j++)
{
var record = nlapiLoadRecord(completeResults[j].getRecordType(), completeResults[j].getId());
for (var i = 1 ; i < 4; i++)
{
if (String(record.getFieldValue('custitem_itm_bisac_' + i)).length == 0)
{
record.setFieldValue('custitem_itm_bisac_' + i + '_translation', null);
}
else
{
var bisac = String(record.getFieldValue('custitem_itm_bisac_' + i));
var index, value, result;
for (index = 0; index < bisacs.length; index++)
{
value = bisacs[index];
if (value == bisac)
{
record.setFieldValue('custitem_itm_bisac_' + i + '_translation', translation[index]);
}
}
}
}
nlapiSubmitRecord(record);
}
}
The above script is referencing a search I created, which at first had 52,000 records in it. Because it said there was a limit I reduced the search down so that it only returned 2700 records. This error still occurred. I'm not clear on what "Script Usage" is but it says it was at 10,005. Any assistance provided is appreciated!