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 <[email protected]>
Sent: Monday, May 7, 2018 3:25:42 PM
To: Bob Carter
Subject: INC0012747 has been commented!
[Battelle Ecology Service Management]<http://www.neonscience.org/>
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!
Take me to the
Incident<https://neon.service-now.com/incident.do?sys_id=1f1ba714db30174004fbd2c75e9619a8&sysparm_stack=incident_list.do?sysparm_query=active=true>
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/
