Dennis,


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 <neon@service-now.com>
Sent: Monday, May 7, 2018 3:25:42 PM
To: Bob Carter
Subject: INC0012747 has been commented!
 

 

Battelle Ecology Service Management
INC0012747 has been commented!
 
 
Short Description:
Add FK to AOP.DP_PUB_STAGING
 
Description: 
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.
 
Category:
Data Processing (AOP)
 
Priority: 
3 - Moderate
 
Opened on behalf of:
Dennis Ward
 
 
Comments:
2018-05-07 15:25:16 MDT - Gretchen Smith Additional comments
Bob,
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.
Thank you,
gretchen
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.
 
 
Ref:MSG0062085

Thank you,
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
  Battelle Ecology Service Management


http://www.neonscience.org/