Thu Sep  3 09:38:02 2015: Starting load_psc
db_name          = cpro.psmfc.org
file_type        = rl
agency           = NIFC
year             = none
translate        = N
stage            = Y
validate         = Y
move             = Y
midyear          = Y
fullset          = N
fmt_version      = 4.1
file_name        = /home/phillipk/up/RL041_NIFC_PARTIAL_2015midyear3.TXT
std_file_name    = rl_NIFC_none.csv
unvalidated_dir  = /usr/mc2/csv/cpro/unvalidated
validated_dir    = /usr/mc2/csv/cpro/validated
log_dir          = /usr/ftp/pub/logs
processing       = PRELIM
Thu Sep  3 09:38:02 2015: Connecting to cpro.psmfc.org database
Thu Sep  3 09:38:02 2015: Populating hashes
Thu Sep  3 09:38:02 2015: STAGING /home/phillipk/up/RL041_NIFC_PARTIAL_2015midyear3.TXT to /usr/mc2/csv/cpro/unvalidated/rl_NIFC_none.csv

Thu Sep  3 09:38:02 2015: Populating tagcode hash and field array from RL table
Thu Sep  3 09:38:03 2015: Populating tagcode hash RC table
Thu Sep  3 09:38:06 2015: Populating tagcode and first_rc_date array from RC table
Thu Sep  3 09:38:15 2015: STARTING rl_validate.pm 
Thu Sep  3 09:38:15 2015: Date Today is 20150903 
Thu Sep  3 09:38:15 2015: Checking format of CSV file: /usr/mc2/csv/cpro/unvalidated/rl_NIFC_none.csv
 9:38:15 - CSV file format okay
Thu Sep  3 09:38:15 2015: VALIDATING release records.... 
Thu Sep  3 09:38:15 2015: Truncating table rgid_evaluate
Thu Sep  3 09:38:15 2015: Table truncated
Thu Sep  3 09:38:15 2015: Populating table rgid_evaluate with rows on-file from releases_041..
Thu Sep  3 09:38:15 2015: Populating table rgid_evaluate with rows from new dataset..
Thu Sep  3 09:38:15 2015: 0 processed, 0 inserted, 0 updated
Thu Sep  3 09:38:16 2015: Table rgid_evaluate prepared for DIT RGID analysis..
Thu Sep  3 09:38:16 2015: Checking for any rows which fail RGID AD-CLIP condition..
Thu Sep  3 09:38:16 2015: RGID AD-CLIP check complete.
Thu Sep  3 09:38:16 2015: Checking for any rows which fail RGID NON-AD-CLIP condition..
Thu Sep  3 09:38:16 2015: RGID NON-AD-CLIP check complete.
Thu Sep  3 09:38:16 2015: Checking for any rows which fail RGID SPECIES condition..
Thu Sep  3 09:38:16 2015: RGID SPECIES check complete.
Thu Sep  3 09:38:16 2015: Checking for any rows which fail RGID BROOD YEAR condition..
Thu Sep  3 09:38:16 2015: RGID BROOD YEAR check complete.
Thu Sep  3 09:38:16 2015: Total csv records - 4
Thu Sep  3 09:38:16 2015: Total val records - 4
Result: 4 rows validated, 0 rows not validated, 0 total errors, 0 total messages.
Thu Sep  3 09:38:16 2015: EXITING rl_validate.pm 

Thu Sep  3 09:38:16 2015: Please submit a description file for this VALIDATED dataset  
Thu Sep  3 09:38:16 2015 
Thu Sep  3 09:38:16 2015: STARTING rl_load.pm 
Thu Sep  3 09:38:16 2015: Preparing CSV file for SQL loader
Thu Sep  3 09:38:16 2015: 4 records prepared for SQL loader
Thu Sep  3 09:38:16 2015: Truncating table releases_csv
Thu Sep  3 09:38:17 2015: Table truncated
Thu Sep  3 09:38:17 2015: Dropping Index releases_csv_x1
Thu Sep  3 09:38:17 2015: loading data with sqlldr

SQL*Loader: Release 11.1.0.6.0 - Production on Thu Sep 3 09:38:17 2015

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Commit point reached - logical record count 4
Thu Sep  3 09:38:17 2015: Updating release_date year, month, day columns
Thu Sep  3 09:38:17 2015: Updating release_location, hatchery_location and stock_location columns
Thu Sep  3 09:38:17 2015: Setting location_key = 0 for null location_code values
Thu Sep  3 09:38:17 2015: Setting midyear flag
Thu Sep  3 09:38:17 2015: Handling special case of 4.1 translated data
Thu Sep  3 09:38:17 2015: Creating index releases_csv_x1
Thu Sep  3 09:38:17 2015: 0 rows indexed
Thu Sep  3 09:38:17 2015: Loading releases_csv tag codes into array
Thu Sep  3 09:38:17 2015: Populating midyear hash
Thu Sep  3 09:38:17 2015: Populating releases_041 hash
Thu Sep  3 09:38:17 2015: LOADING releases_041 records.... 
Thu Sep  3 09:38:17 2015: Iterating through releases_csv array
Thu Sep  3 09:38:17 2015: 0 processed, 0 inserted, 0 updated, 0 rejected
210183;     |  Release Group is NEW;
210437;     |  Release Group is NEW;
211085;     |  Release Group is NEW;
211140;     |  Release Group is NEW;
Thu Sep  3 09:38:18 2015: 4 processed, 4 inserted, 0 updated, 0 rejected
Thu Sep  3 09:38:18 2015: Dropping Index releases_csv_x1
Thu Sep  3 09:38:18 2015: EXITING rl_load.pm 

Thu Sep  3 09:38:18 2015: MOVING rl_NIFC_none.csv from /usr/mc2/csv/cpro/unvalidated to /usr/mc2/csv/cpro/validated

Thu Sep  3 09:38:18 2015: APPENDING time stamp: updated file name - /home/phillipk/up/RL041_NIFC_PARTIAL_2015midyear3.TXT-201509030938-PASS 

Thu Sep  3 09:38:18 2015: Refreshing Data Status tables
Thu Sep  3 09:39:41 2015: Disconnecting from cpro.psmfc.org database