From dev-return-37914-apmail-drill-dev-archive=drill.apache.org@drill.apache.org Mon May 7 23:12:22 2018 Return-Path: X-Original-To: apmail-drill-dev-archive@www.apache.org Delivered-To: apmail-drill-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 9BFEE17391 for ; Mon, 7 May 2018 23:12:22 +0000 (UTC) Received: (qmail 75954 invoked by uid 500); 7 May 2018 23:12:22 -0000 Delivered-To: apmail-drill-dev-archive@drill.apache.org Received: (qmail 75877 invoked by uid 500); 7 May 2018 23:12:22 -0000 Mailing-List: contact dev-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@drill.apache.org Delivered-To: mailing list dev@drill.apache.org Delivered-To: moderator for dev@drill.apache.org Received: (qmail 4511 invoked by uid 99); 7 May 2018 22:34:57 -0000 X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.999 X-Spam-Level: * X-Spam-Status: No, score=1.999 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_FONT_LOW_CONTRAST=0.001, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (1024-bit key) header.d=neoninc.onmicrosoft.com DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=neoninc.onmicrosoft.com; s=selector1-BattelleEcology-org; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=QBkwmbuxowU6vt5zoj5FTh+2j64qENSFHMd5zys5LcA=; b=3lgBCevKuveycZiJPwaqYjcVP6N8v+E24dMoM9EhRRpW6PIsd4T4EhbOH8fM36/h1wDlH2WeX5LPztmUDF4YhZCAk14+HUPQi1zXAUAJJzJ41qGr/FkqvmZhsxhDK1+CR6kBouRlrGrD2VaynSQ5cL6Mzg17W7sALnub2S3W4mQ= From: Bob Carter To: "dev@drill.apache.org" Subject: Re: INC0012747 has been commented! Thread-Topic: INC0012747 has been commented! Thread-Index: AQHT5kn1TurYCiNB/k+3Hv/jpJ6vnKQk2lVL Date: Mon, 7 May 2018 22:34:46 +0000 Message-ID: References: <21616390.1733.1525728342017@app128144.iad104.service-now.com> In-Reply-To: <21616390.1733.1525728342017@app128144.iad104.service-now.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: yes X-MS-TNEF-Correlator: authentication-results: spf=none (sender IP is ) smtp.mailfrom=bcarter@battelleecology.org; x-originating-ip: [129.19.149.2] x-ms-publictraffictype: Email x-microsoft-exchange-diagnostics: 1;BL0PR07MB4081;7:0kn1mJDiTl7SnCWeGM4xRWSqehY6I98epBYVN0ksq/46gKzu/AYu+N6zijlmMOuX2ioSTgmqmL4XN0XkI02gju6liY2ha8qpgqoxL/COH9k+ZaNL/m7kSfj+/LZKSFyEZnVCrA7W0vMTZq6/GwVu+8imki0GCjz2GW3IaPIg7cFHK44i9I7twkRAInIJCBeRAUzNRgHOre1LUlQY6nybphSg115sm8HePkHDTTTpedGu2jU+0rVKb8D1W78aNNPm x-ms-exchange-antispam-srfa-diagnostics: SOS; x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:(7020095)(4652020)(5600026)(4534165)(4627221)(201703031133081)(201702281549075)(2017052603328)(7153060)(49563074)(7193020);SRVR:BL0PR07MB4081; x-ms-traffictypediagnostic: BL0PR07MB4081: x-microsoft-antispam-prvs: x-exchange-antispam-report-test: UriScan:(169633505665273)(275809806118684)(25456226137038); x-ms-exchange-senderadcheck: 1 x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(8211001083)(102415395)(6040522)(2401047)(8121501046)(5005006)(93006095)(93001095)(3231254)(944501410)(52105095)(3002001)(10201501046)(149027)(150027)(6041310)(201703131423095)(201702281528075)(20161123555045)(201703061421075)(201703061406153)(20161123560045)(20161123562045)(20161123558120)(20161123564045)(6072148)(201708071742011);SRVR:BL0PR07MB4081;BCL:0;PCL:0;RULEID:;SRVR:BL0PR07MB4081; x-forefront-prvs: 066517B35B x-forefront-antispam-report: SFV:NSPM;SFS:(10009020)(376002)(346002)(39380400002)(366004)(39850400004)(396003)(50944005)(377424004)(189003)(199004)(59450400001)(6506007)(53546011)(102836004)(186003)(9686003)(966005)(54556002)(6306002)(236005)(54896002)(5640700003)(97736004)(606006)(26005)(5660300001)(76176011)(99286004)(7696005)(53936002)(74316002)(486006)(6246003)(68736007)(86362001)(476003)(478600001)(11346002)(55016002)(14454004)(446003)(2501003)(5250100002)(25786009)(33656002)(2351001)(3846002)(6116002)(7736002)(6606003)(1730700003)(6436002)(2906002)(81166006)(81156014)(8676002)(99936001)(226693001)(66066001)(3660700001)(8936002)(2900100001)(316002)(106356001)(733005)(6916009)(229853002)(105586002)(19627405001)(3280700002);DIR:OUT;SFP:1101;SCL:1;SRVR:BL0PR07MB4081;H:BL0PR07MB3908.namprd07.prod.outlook.com;FPR:;SPF:None;LANG:en;PTR:InfoNoRecords;MX:1;A:1; received-spf: None (protection.outlook.com: battelleecology.org does not designate permitted sender hosts) x-microsoft-antispam-message-info: QQePX55JUbA28nsqp+yz5VJ5fCBqgYUhCfUXM5RiekLhCpC69rHcv/tfNWpYCKpAUZNj8/CVMw8SAUp1kJXGK35vEYXweQ2bzm/Qjq4fb8cUBnvoMI/rWIMTZjcUQGueSu0pX2ViJ+STpQbnAtSCqN9QJwTCP9CIITBXDUtFlyr6I4UyzFI91H2x4okierWV spamdiagnosticoutput: 1:99 spamdiagnosticmetadata: NSPM Content-Type: multipart/related; boundary="_004_BL0PR07MB39086D68E5D854F7E2743630A89B0BL0PR07MB3908namp_"; type="multipart/alternative" MIME-Version: 1.0 X-MS-Office365-Filtering-Correlation-Id: 41a075e1-5818-4347-2f3d-08d5b46abc57 X-OriginatorOrg: BattelleEcology.org X-MS-Exchange-CrossTenant-Network-Message-Id: 41a075e1-5818-4347-2f3d-08d5b46abc57 X-MS-Exchange-CrossTenant-originalarrivaltime: 07 May 2018 22:34:46.1531 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: f44d2ab3-9099-4d85-9986-10165a8619f5 X-MS-Exchange-Transport-CrossTenantHeadersStamped: BL0PR07MB4081 --_004_BL0PR07MB39086D68E5D854F7E2743630A89B0BL0PR07MB3908namp_ Content-Type: multipart/alternative; boundary="_000_BL0PR07MB39086D68E5D854F7E2743630A89B0BL0PR07MB3908namp_" --_000_BL0PR07MB39086D68E5D854F7E2743630A89B0BL0PR07MB3908namp_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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 K= EY ("SITE") REFERENCES "PDR"."NAM_LOCN" ("NAM_LOCN_NAME") ENABLE; ________________________________ From: NEON Service Management 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-ex= istent site names. When this occurs, subsequent publication processing fail= s, 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 m= oving 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 suggest= ed 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 pl= ease advise? Thanks! Take me to the Incident 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 privi= leged and confidential, and therefore, protected from disclosure. If you ha= ve received this communication in error, please notify us immediately by re= plying to this message and deleting it from your computer without copying o= r disclosing it Battelle Ecology Service Management http://www.neonscience.org/ --_000_BL0PR07MB39086D68E5D854F7E2743630A89B0BL0PR07MB3908namp_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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<= /div>
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAUL= T)
  TABLESPACE "PDRINDX03" ;
  
  ALTER TABLE aop.dp_pub_staging  ADD CONSTRAINT "FK_DP= _PUB_SITE" FOREIGN KEY ("SITE")
  REFERENCES "PDR&quo= t;."NAM_LOCN" ("NAM_LOCN_NAME") ENABLE;



From: NEON Service Manageme= nt <neon@service-now.com>
Sent: Monday, May 7, 2018 3:25:42 PM
To: Bob Carter
Subject: INC0012747 has been commented!
 

 

3D"Battelle
INC0012747 has been commented!
 
 
Short Description:
Ad= d FK to AOP.DP_PUB_STAGING
&n= bsp;
Description: 
Cu= rrent configuration allow addition of records with non-standard or non-exis= tent 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 m= oving 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.=
&n= bsp;
Category:
Data Processing (AOP)
&n= bsp;
Priority: 
3 = - Moderate
&n= bsp;
Opened on behalf of:
Dennis Wa= rd
 
&n= bsp;
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 suggest= ed 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 comme= nts
Nathan, the Service Desk is unsure who to assign this ticket t= o. Can you please advise? Thanks!

&n= bsp;
&n= bsp;
&n= bsp;
 
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 o= r 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 electro= nic mail transmission may be privileged and confidential, and therefore, pr= otected 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 disc= losing it
  Battelle= Ecology Service Management


http://www.neonscience.org/
--_000_BL0PR07MB39086D68E5D854F7E2743630A89B0BL0PR07MB3908namp_-- --_004_BL0PR07MB39086D68E5D854F7E2743630A89B0BL0PR07MB3908namp_--