You are currently reviewing an older revision of this page.
M_MGR-0234: Contracts pricing by area not allowed on cyclic works orders occuring when trying to instruct a Cyclic OrderReplication Steps: Contractor assigned to the contract has Road Group Type field populated this causes the issue as not allowed.
MAI3800A Cyclic Works Ordering M_MGR-0234: Contracts pricing by area not allowed on cyclic works orders occuring when trying to instruct a Cyclic OrderReplication Steps: Contractor assigned to the contract has Road Group Type field populated this causes the issue as not allowed.Description Either assign a new contractor to the contract with the Road Group Type field blank. To see if blank go to mai3881 to quey back contractor details.
Or if that is not possible, check to see if any contract items against any contract assigned to that contractor is using group type assigned .If not then can clear using sql below.
The customer had duplicated an old contractor that had Road Group Type = AREA, but had not actually used any of the group names in contract items to setup different prices. So can put to null.
Determine the contractor id - see org_units table to identify oun_org_id
select * from org_unitswhere oun_org_id = 688;
select count(*) from contract_itemswhere cni_con_id in(select con_id from contractswhere con_contr_org_id = 688)and cni_cng_disc_group is not null;
If this returns zero rows - then continue else cannot do sql below.
update org_unitsset oun_gty_group_type = nullwhere oun_org_id = 688;
1 row should get updated
commit;Problem Number 58259
Product TechNotes and FAQs
Bentley Technical Support KnowledgeBase
Bentley LEARN Server
Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!