mip/Data/Seed/comsg.ctl

LOAD DATA
INFILE *
INTO TABLE constraint_messages
REPLACE
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS
(
constraint_name CHAR(4000) "translate(:constraint_name,'`~',chr(13)||chr(10))"
,msg CHAR(4000) "translate(:msg,'`~',chr(13)||chr(10))"
)
BEGINDATA
ADDR_PK|Attempting to create a duplicate Addresses entry
ADIT_PK|Attempting to create a duplicate Additional_Items entry
ALTY_PK|Attempting to create a duplicate Asset_Location_Types entry
AUTH_PK|Attempting to create a duplicate Apex_Authorization entry
AUTH_RT_FK|Application Error: Attempting to violate foreign key constraint AUTH_RT_FK. Please report this error to Advantica.
BAS_DRWG_FK|Application Error: Attempting to violate foreign key constraint BAS_DRWG_FK. Please report this error to Advantica.
BAS_PK|Attempting to create a duplicate Bases entry
BUILDING_OR_SUBBUILDING_REQ|Application Error: Attempting to violate check constraint BUILDING_OR_SUBBUILDING_REQ. Please report this error to Advantica.
BYRE_PK|Attempting to create a duplicate Bypass_Reasons entry
CACA_PK|Attempting to create a duplicate Care_Categories entry
CATE_ENTY_FK|Application Error: Attempting to violate foreign key constraint CATE_ENTY_FK. Please report this error to Advantica.
CATE_METY_FK|Application Error: Attempting to violate foreign key constraint CATE_METY_FK. Please report this error to Advantica.
CATE_PK|Attempting to create a duplicate Caveat_Texts entry
CATE_SVCPT_FK|Application Error: Attempting to violate foreign key constraint CATE_SVCPT_FK. Please report this error to Advantica.
CNOR_PK|Attempting to create a duplicate Connection_Orientations entry
CNTY_PK|Attempting to create a duplicate Connection_Types entry
COME_COMT_FK|Application Error: Attempting to violate foreign key constraint COME_COMT_FK. Please report this error to Advantica.
COME_PK|Attempting to create a duplicate Contact_Mechanisms entry
COMSG_PK|Attempting to create a duplicate Constraint_Messages entry
COMT_PK|Attempting to create a duplicate Contact_Mechanism_Types entry
COSTS_AICO_MANDATORY_CK|Additional item is mandatory
COSTS_BACO_MANDATORY_CK|Base is mandatory
COSTS_HOCO_MANDATORY_CK|Housing is mandatory
COSTS_LACO_MANDATORY_CK|Enquiry type and meter type are mandatory
COSTS_MECO_MANDATORY_CK|Meter is mandatory
COSTS_MOCO_MANDATORY_CK|Module is mandatory
REEX_PK|Attempting to create a duplicate Regi_Enqu_Exclusions entry
REEX_REEX_UK|This Non-Tripartite Exclusion has already been defined
REEX_REGI_FK|Application Error: Attempting to violate foreign key constraint REEX_REGI_FK. Please report this error to Advantica.
REGI_PK|Attempting to create a duplicate Regions entry
REGU_PK|Attempting to create a duplicate Regulators entry
REGU_RETY_FK|Application Error: Attempting to violate foreign key constraint REGU_RETY_FK. Please report this error to Advantica.
RETY_PK|Attempting to create a duplicate Regulator_Types entry
REVA_PK|Attempting to create a duplicate Relief_Valves entry
REVA_RVTY_FK|Application Error: Attempting to violate foreign key constraint REVA_RVTY_FK. Please report this error to Advantica.
RT_PK|Attempting to create a duplicate Role_Types entry
RVTY_PK|Attempting to create a duplicate Relief_Valve_Types entry
SLTY_PK|Attempting to create a duplicate Slamshut_Types entry
SLVA_PK|Attempting to create a duplicate Slamshut_Valves entry
SLVA_SLTY_FK|Application Error: Attempting to violate foreign key constraint SLVA_SLTY_FK. Please report this error to Advantica.
SVCPT_PK|Attempting to create a duplicate Service_Pressure_Types entry
SVCP_PK|Attempting to create a duplicate Service_Pressures entry
SVCP_SVCPT_FK|Application Error: Attempting to violate foreign key constraint SVCP_SVCPT_FK. Please report this error to Advantica.
SYCO_PK|Attempting to create a duplicate System_Configuration entry
PADDR_ADDR_FK|Application Error: Attempting to violate foreign key constraint PADDR_ADDR_FK. Please report this error to Advantica.
PADDR_PK|Attempting to create a duplicate Party_Addresses entry
PADDR_PRTY_FK|Application Error: Attempting to violate foreign key constraint PADDR_PRTY_FK. Please report this error to Advantica.
PARL_PK|Attempting to create a duplicate Party_Roles entry
PARL_PRTP_MISMATCH|Application Error: Attempting to violate check constraint PARL_PRTP_MISMATCH. Please report this error to Advantica.
PARL_PRTY_FK|Application Error: Attempting to violate foreign key constraint PARL_PRTY_FK. Please report this error to Advantica.
PARL_RT_FK|Application Error: Attempting to violate foreign key constraint PARL_RT_FK. Please report this error to Advantica.
PAR_PADDR_FK|Application Error: Attempting to violate foreign key constraint PAR_PADDR_FK. Please report this error to Advantica.
PAR_PK|Attempting to create a duplicate Party_Address_Roles entry
PAR_RT_FK|Application Error: Attempting to violate foreign key constraint PAR_RT_FK. Please report this error to Advantica.
PCMR_PCM_FK|Application Error: Attempting to violate foreign key constraint PCMR_PCM_FK. Please report this error to Advantica.
PCMR_PK|Attempting to create a duplicate Party_Contact_Mechanism_Roles entry
PCMR_RT_FK|Application Error: Attempting to violate foreign key constraint PCMR_RT_FK. Please report this error to Advantica.
PCM_COME_FK|Application Error: Attempting to violate foreign key constraint PCM_COME_FK. Please report this error to Advantica.
PCM_PADDR_FK|Application Error: Attempting to violate foreign key constraint PCM_PADDR_FK. Please report this error to Advantica.
PCM_PK|Attempting to create a duplicate Party_Contact_Mechanisms entry
PCM_PRTY_FK|Application Error: Attempting to violate foreign key constraint PCM_PRTY_FK. Please report this error to Advantica.
POCO_PK|Attempting to create a duplicate Postcodes entry
POCO_POCO_UK|This postcode already exists.
POCO_REGI_FK|Application Error: Attempting to violate foreign key constraint POCO_REGI_FK. Please report this error to Advantica.
PREL_PARL_FROM_FK|Application Error: Attempting to violate foreign key constraint PREL_PARL_FROM_FK. Please report this error to Advantica.
PREL_PARL_TO_FK|Application Error: Attempting to violate foreign key constraint PREL_PARL_TO_FK. Please report this error to Advantica.
PREL_PK|Attempting to create a duplicate Party_Relationships entry
PREL_PRTP_FK|Application Error: Attempting to violate foreign key constraint PREL_PRTP_FK. Please report this error to Advantica.
PRTP_PK|Attempting to create a duplicate Party_Relationship_Types entry
PRTP_RT_FK|Application Error: Attempting to violate foreign key constraint PRTP_RT_FK. Please report this error to Advantica.
PRTP_RT_FROM_FK|Application Error: Attempting to violate foreign key constraint PRTP_RT_FROM_FK. Please report this error to Advantica.
PRTY_MANU_MANU_REF_UK|Attempting to enter a duplicate value (defined by unique constraint PRTY_MANU_MANU_REF_UK).
PRTY_MKTP_MKTP_REF_UK|This Market Participant Reference has already been assigned to another market participant
PRTY_MKTP_SHORTCODE_UK|This Market Participant Shortcode has already been assigned to another market participant
PRTY_ORG_NAME_UK|An organization with this name already exists.
PRTY_PK|Attempting to create a duplicate Parties entry
PWD_PK|Attempting to create a duplicate Passwords entry
PWD_PRTY_FK|Application Error: Attempting to violate foreign key constraint PWD_PRTY_FK. Please report this error to Advantica.
QUEV_PK|Attempting to create a duplicate Quote_Events entry
QUEV_QUST_FK|Application Error: Attempting to violate foreign key constraint QUEV_QUST_FK. Please report this error to Advantica.
QUEV_QUTE_FK|Application Error: Attempting to violate foreign key constraint QUEV_QUTE_FK. Please report this error to Advantica.
QUIT_ADIT_FK|Application Error: Attempting to violate foreign key constraint QUIT_ADIT_FK. Please report this error to Advantica.
QUIT_BAS_FK|Application Error: Attempting to violate foreign key constraint QUIT_BAS_FK. Please report this error to Advantica.
QUIT_ENTY_FK|Application Error: Attempting to violate foreign key constraint QUIT_ENTY_FK. Please report this error to Advantica.
QUIT_HOU_FK|Application Error: Attempting to violate foreign key constraint QUIT_HOU_FK. Please report this error to Advantica.
QUIT_MESC_FK|Application Error: Attempting to violate foreign key constraint QUIT_MESC_FK. Please report this error to Advantica.
QUIT_METY_FK|Application Error: Attempting to violate foreign key constraint QUIT_METY_FK. Please report this error to Advantica.
QUIT_MODU_FK|Application Error: Attempting to violate foreign key constraint QUIT_MODU_FK. Please report this error to Advantica.
QUIT_PK|Attempting to create a duplicate Quote_Items entry
QUIT_QUTE_FK|Application Error: Attempting to violate foreign key constraint QUIT_QUTE_FK. Please report this error to Advantica.
QUIT_SVCPT_FK|Application Error: Attempting to violate foreign key constraint QUIT_SVCPT_FK. Please report this error to Advantica.
QURE_ENQU_FK|Application Error: Attempting to violate foreign key constraint QURE_ENQU_FK. Please report this error to Advantica.
QURE_PK|Attempting to create a duplicate Quote_Reasoning entry
QURO_PK|Attempting to create a duplicate Quote_Roles entry
QURO_PRTY_FK|Unable to delete a party that is associated with a quote
QURO_QUTE_FK|Application Error: Attempting to violate foreign key constraint QURO_QUTE_FK. Please report this error to Advantica.
QURO_RT_FK|Application Error: Attempting to violate foreign key constraint QURO_RT_FK. Please report this error to Advantica.
QUST_PK|Attempting to create a duplicate Quote_Statuses entry
QUTE_ENQU_FK|Application Error: Attempting to violate foreign key constraint QUTE_ENQU_FK. Please report this error to Advantica.
QUTE_PK|Attempting to create a duplicate Quotes entry
REEX_ADIT_FK|Application Error: Attempting to violate foreign key constraint REEX_ADIT_FK. Please report this error to Advantica.
REEX_ENTY_FK|Application Error: Attempting to violate foreign key constraint REEX_ENTY_FK. Please report this error to Advantica.
FLTR_PK|Attempting to create a duplicate Filters entry
HOTY_PK|Attempting to create a duplicate Housing_Types entry
HOU_DRWG_FK|Application Error: Attempting to violate foreign key constraint HOU_DRWG_FK. Please report this error to Advantica.
HOU_HOTY_FK|Application Error: Attempting to violate foreign key constraint HOU_HOTY_FK. Please report this error to Advantica.
HOU_PK|Attempting to create a duplicate Housings entry
HOU_PRTY_FK|Application Error: Attempting to violate foreign key constraint HOU_PRTY_FK. Please report this error to Advantica.
LETI_ENTY_FK|Application Error: Attempting to violate foreign key constraint LETI_ENTY_FK. Please report this error to Advantica.
LETI_MESC_FK|Application Error: Attempting to violate foreign key constraint LETI_MESC_FK. Please report this error to Advantica.
LETI_METY_FK|Application Error: Attempting to violate foreign key constraint LETI_METY_FK. Please report this error to Advantica.
LETI_PK|Attempting to create a duplicate Lead_Times entry
LETI_SVCPT_FK|Application Error: Attempting to violate foreign key constraint LETI_SVCPT_FK. Please report this error to Advantica.
MESC_PK|Attempting to create a duplicate Meter_Size_Codes entry
METR_DRWG_FK|Application Error: Attempting to violate foreign key constraint METR_DRWG_FK. Please report this error to Advantica.
METR_METY_FK|Application Error: Attempting to violate foreign key constraint METR_METY_FK. Please report this error to Advantica.
METR_PK|Attempting to create a duplicate Meters entry
METR_PRTY_FK|Application Error: Attempting to violate foreign key constraint METR_PRTY_FK. Please report this error to Advantica.
METY_PK|Attempting to create a duplicate Meter_Types entry
MODU_BAS_FK|Cannot delete a base that is associated with a module.
MODU_CNOR_INLET_FK|Application Error: Attempting to violate foreign key constraint MODU_CNOR_INLET_FK. Please report this error to Advantica.
MODU_CNOR_OUTLET_FK|Application Error: Attempting to violate foreign key constraint MODU_CNOR_OUTLET_FK. Please report this error to Advantica.
MODU_CNTY_INLET_FK|Application Error: Attempting to violate foreign key constraint MODU_CNTY_INLET_FK. Please report this error to Advantica.
MODU_CNTY_OUTLET_FK|Application Error: Attempting to violate foreign key constraint MODU_CNTY_OUTLET_FK. Please report this error to Advantica.
MODU_DRWG_FK|Application Error: Attempting to violate foreign key constraint MODU_DRWG_FK. Please report this error to Advantica.
MODU_FLTR_FK|Application Error: Attempting to violate foreign key constraint MODU_FLTR_FK. Please report this error to Advantica.
MODU_HOU_FK|Application Error: Attempting to violate foreign key constraint MODU_HOU_FK. Please report this error to Advantica.
MODU_METR_FK|Application Error: Attempting to violate foreign key constraint MODU_METR_FK. Please report this error to Advantica.
MODU_PK|Attempting to create a duplicate Modules entry
MODU_PRTY_FK|Application Error: Attempting to violate foreign key constraint MODU_PRTY_FK. Please report this error to Advantica.
MODU_REGU_FK|Application Error: Attempting to violate foreign key constraint MODU_REGU_FK. Please report this error to Advantica.
MODU_REVA_FK|Application Error: Attempting to violate foreign key constraint MODU_REVA_FK. Please report this error to Advantica.
MODU_SLVA_FK|Application Error: Attempting to violate foreign key constraint MODU_SLVA_FK. Please report this error to Advantica.
MODU_SVCP_FK|Application Error: Attempting to violate foreign key constraint MODU_SVCP_FK. Please report this error to Advantica.
COST_ADIT_FK|Application Error: Attempting to violate foreign key constraint COST_ADIT_FK. Please report this error to Advantica.
COST_BAS_FK|Application Error: Attempting to violate foreign key constraint COST_BAS_FK. Please report this error to Advantica.
COST_ENTY_FK|Application Error: Attempting to violate foreign key constraint COST_ENTY_FK. Please report this error to Advantica.
COST_HOU_FK|Application Error: Attempting to violate foreign key constraint COST_HOU_FK. Please report this error to Advantica.
COST_MESC_FK|Application Error: Attempting to violate foreign key constraint COST_MESC_FK. Please report this error to Advantica.
COST_METR_FK|Application Error: Attempting to violate foreign key constraint COST_METR_FK. Please report this error to Advantica.
COST_METY_FK|Application Error: Attempting to violate foreign key constraint COST_METY_FK. Please report this error to Advantica.
COST_MODU_FK|Application Error: Attempting to violate foreign key constraint COST_MODU_FK. Please report this error to Advantica.
COST_PK|Attempting to create a duplicate Costs entry
COST_REGI_FK|Application Error: Attempting to violate foreign key constraint COST_REGI_FK. Please report this error to Advantica.
COST_SVCPT_FK|Application Error: Attempting to violate foreign key constraint COST_SVCPT_FK. Please report this error to Advantica.
COST_UK|Attempting to create a duplicate Costs entry. Labour costs should be unique across enquiry type, service pressure, meter size, meter type, valid from and region. Costs for modules, housings, bases and additional items should be unique across valid from and region.
DIR_ENTY_FK|Application Error: Attempting to violate foreign key constraint DIR_ENTY_FK. Please report this error to Advantica.
DIR_PK|Attempting to create a duplicate Data_Item_Roles entry
DOCU_PK|Attempting to create a duplicate Documents entry
DOEV_DOCU_FK|Application Error: Attempting to violate foreign key constraint DOEV_DOCU_FK. Please report this error to Advantica.
DOEV_DOST_FK|Application Error: Attempting to violate foreign key constraint DOEV_DOST_FK. Please report this error to Advantica.
DOEV_PK|Attempting to create a duplicate Document_Events entry
DORO_CK|Application Error: Attempting to violate check constraint DORO_CK. Please report this error to Advantica.
DORO_DOCU_FK|Application Error: Attempting to violate foreign key constraint DORO_DOCU_FK. Please report this error to Advantica.
DORO_DORO_UK|Attempting to enter a duplicate value (defined by unique constraint DORO_DORO_UK).
DORO_DRWG_FK|Application Error: Attempting to violate foreign key constraint DORO_DRWG_FK. Please report this error to Advantica.
DORO_ENQU_FK|Application Error: Attempting to violate foreign key constraint DORO_ENQU_FK. Please report this error to Advantica.
DORO_PK|Attempting to create a duplicate Document_Roles entry
DORO_QUTE_FK|Application Error: Attempting to violate foreign key constraint DORO_QUTE_FK. Please report this error to Advantica.
DORO_RT_FK|Application Error: Attempting to violate foreign key constraint DORO_RT_FK. Please report this error to Advantica.
DOST_PK|Attempting to create a duplicate Document_Status_Types entry
DRWG_PK|Attempting to create a duplicate Drawings entry
ENEV_ENQU_FK|Application Error: Attempting to violate foreign key constraint ENEV_ENQU_FK. Please report this error to Advantica.
ENEV_ENST_FK|Application Error: Attempting to violate foreign key constraint ENEV_ENST_FK. Please report this error to Advantica.
ENEV_PK|Attempting to create a duplicate Enquiry_Events entry
ENQU_ALTY_FK|Application Error: Attempting to violate foreign key constraint ENQU_ALTY_FK. Please report this error to Advantica.
ENQU_CACA_FK|Application Error: Attempting to violate foreign key constraint ENQU_CACA_FK. Please report this error to Advantica.
ENQU_COMT_AGENT_FK|Application Error: Attempting to violate foreign key constraint ENQU_COMT_AGENT_FK. Please report this error to Advantica.
ENQU_ENTY_FK|Application Error: Attempting to violate foreign key constraint ENQU_ENTY_FK. Please report this error to Advantica.
ENQU_MESC_EXISTING_FK|Application Error: Attempting to violate foreign key constraint ENQU_MESC_EXISTING_FK. Please report this error to Advantica.
ENQU_MESC_REQUIRED_FK|Application Error: Attempting to violate foreign key constraint ENQU_MESC_REQUIRED_FK. Please report this error to Advantica.
ENQU_METY_FK|Application Error: Attempting to violate foreign key constraint ENQU_METY_FK. Please report this error to Advantica.
ENQU_PK|Attempting to create a duplicate Enquiries entry
ENQU_SVCP_REQUIRED_FK|Application Error: Attempting to violate foreign key constraint ENQU_SVCP_REQUIRED_FK. Please report this error to Advantica.
ENRO_ENQU_FK|Application Error: Attempting to violate foreign key constraint ENRO_ENQU_FK. Please report this error to Advantica.
ENRO_PK|Attempting to create a duplicate Enquiry_Roles entry
ENRO_PRTY_FK|Unable to delete a party that is associated with an enquiry
ENRO_RT_FK|Application Error: Attempting to violate foreign key constraint ENRO_RT_FK. Please report this error to Advantica.
ENST_PK|Attempting to create a duplicate Enquiry_Status_Types entry
ENTY_ADIT_MUTEX|Must enter EITHER enquiry type OR additional item
ENTY_PK|Attempting to create a duplicate Enquiry_Types entry
ERLO_PK|Attempting to create a duplicate Error_Logs entry
EXME_PK|Attempting to create a duplicate Exception_Messages entry
FITY_PK|Attempting to create a duplicate Filter_Types entry
FLTR_FITY_FK|Application Error: Attempting to violate foreign key constraint FLTR_FITY_FK. Please report this error to Advantica.