Getting error 'ORA-02290: check constraint (SWM.TPRJ_PROJECT_REF_CHK) violated' when loading a notice with a Project Reference containing lowercase letters
Request Notice is resent changing letters to uppercase.
Note from CoP Page 51Notes1. Project and works references apply to both works promoters and authorities. All references consist of a 2-character organisation prefix (the SWA_ORG_PREFIX value), a 3-character district number (the DISTRICT_REF value as a numeric string) and a 19-character works reference.Values for works references are determined by the sending organisation and should be unique within the district. Each works reference should therefore be unique, nationally. All references are limited to uppercase alphabetic characters A-Z, numeric characters 0-9 and the separators “/” and “-“. Spaces must not be used.
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!