This is similar to the constraint on dp_pub.
CREATE INDEX aop.FK_DP_PUB_SITE ON aop.dp_pub_staging ("SITE")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 10M NEXT 10 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "PDRINDX03" ;
ALTER TABLE aop.dp_pub_staging ADD CONSTRAINT "FK_DP_PUB_SITE" FOREIGN KEY ("SITE")
REFERENCES "PDR"."NAM_LOCN" ("NAM_LOCN_NAME") ENABLE;
From: NEON Service Management <email@example.com>
Sent: Monday, May 7, 2018 3:25:42 PM
To: Bob Carter
Subject: INC0012747 has been commented!
INC0012747 has been commented!
Add FK to AOP.DP_PUB_STAGING
Current configuration allow addition of records with non-standard or non-existent site names. When this occurs, subsequent publication processing fails, completely halting publication of
new data to the Data Portal (AOP, IS, and/or OS).
Adding a FK constraint to table AOP.DP_PUB_STAGING should prevent insertion of invalid records. Something along these lines should resolve the issue moving forward...
ALTER TABLE AOP.DP_PUB_STAGING
FOREIGN KEY (SITE)
REFERENCES PDR.NAM_LOCN (NAM_LOCN_NAME) --or NAM_LOCN_UK1 ?
Not sure how to categorize this request, please route to Bob Carter.
Data Processing (AOP)
3 - Moderate
Opened on behalf of:
2018-05-07 15:25:16 MDT - Gretchen Smith Additional comments
I am going through some old tickets and I found this one and it was suggested that it be routed to you. Please let me know if it shouldn't be given to you.
2018-04-04 10:55:12 MDT - Josh Long Additional comments
Nathan, the Service Desk is unsure who to assign this ticket to. Can you please advise? Thanks!
Replying to this email will add a note to this incident.
If you choose to reply to this email, do not change the subject line or msg line below so your reply can be recorded in this ticket.
DO NOT include any sensitive information in your reply.
Battelle Ecology Service Management
The information contained in this electronic mail transmission may be privileged and confidential, and therefore, protected from disclosure. If you have received this communication in error, please notify us immediately by replying
to this message and deleting it from your computer without copying or disclosing it