User is attempting to add the co-ordinates either manually or via locator (Get From Map). On saving the changes an error occurs for both records. The same error occurs if an attempt is done to delete either of the ASD records
To fix this error please follow steps listed below:
create table nm_inv_items_old as select * from nm_inv_items;
update nm_inv_items inv set iit_chr_attrib29= substr(iit_chr_attrib29,1,2)||':'||substr(iit_chr_attrib29,3,2),
iit_chr_attrib30= substr(iit_chr_attrib30,1,2)||':'||substr(iit_chr_attrib30,3,2)
where iit_inv_type = 'TP23'
and instr (iit_chr_attrib29,':')=0;
select * from v_nm_tp23 where instr (tp23_start_time,':')=0;
commit;
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!