mysql - Coldfusion / ORM -- Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect) -

mysql - Coldfusion / ORM -- Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect) -

i working on application using coldbox , orm. have local environment, development environment, , actual production environment. when trying import info spreadsheet , store results database, local environment works without error. if utilize same code , seek upload info production or development environments, error saying

row updated or deleted transaction (or unsaved-value mapping incorrect).

contract

145

145

145

201

do { seek { monthlyusage = getmonthlyusageservice().new({ commodity = structfind(usagereport, "commodity"), term = structfind(usagereport, "term"), usage = structfind(usagereport, "usage"), startdate = structfind(usagereport, "startdate"), enddate = structfind(usagereport, "enddate"), expectedpayment = structfind(usagereport, "expectedpayment"), supplierpayment = structfind(usagereport, "supplierpayment"), supplierid = arguments.supplierid, commissionrate = commissionrate, contractlocationid = arguments.contractlocationid, modifieduser = loggedinuser, user = loggedinuser }); contract.addcommission(getcommissionservice().new({ commissiondate = now(), amount = amount, usage = structfind(usagereport, "usage"), agent = agent, contract = contract, commissioncontractlocation = location, monthlyusage = monthlyusage, modifieduser = loggedinuser, user = loggedinuser })); } grab (any e) { rethrow; } } while ( action != 'done' ); save(entity=contract, flush=true, transactional=true);

the issue having after first 145 database updated. when trying update database sec 145 contract, noted error

all code loop through contracts, sets info in appropriate positions , tries update database. there thought why if have contracts of same number back, error have feeling error in development / production based off speed in database updated, not sure how resolve issue.

mysql orm coldbox