Fri Jan 11 09:03:02 2013: Starting load_psc
db_name          = cpro.psmfc.org
file_type        = rl
agency           = YAKA
year             = none
translate        = N
stage            = Y
validate         = Y
move             = Y
midyear          = N
fullset          = N
fmt_version      = 4.1
file_name        = /home/yaka/up/RL_YAKA_none.txt
std_file_name    = rl_YAKA_none.csv
unvalidated_dir  = /usr/mc2/csv/cpro/unvalidated
validated_dir    = /usr/mc2/csv/cpro/validated
log_dir          = /usr/ftp/pub/logs
Fri Jan 11 09:03:02 2013: Connecting to cpro.psmfc.org database
Fri Jan 11 09:03:02 2013: Populating hashes
Fri Jan 11 09:03:03 2013: STAGING /home/yaka/up/RL_YAKA_none.txt to /usr/mc2/csv/cpro/unvalidated/rl_YAKA_none.csv

Fri Jan 11 09:03:03 2013: Populating tagcode hash and field array from RL table
Fri Jan 11 09:03:08 2013: Populating tagcode hash RC table
Fri Jan 11 09:03:12 2013: Populating tagcode and first_rc_date array from RC table
Fri Jan 11 09:03:20 2013: STARTING rl_validate.pm 
Fri Jan 11 09:03:20 2013: Date Today is 20130111 
Fri Jan 11 09:03:20 2013: Doing pre-check filtering of CSV file: /usr/mc2/csv/cpro/unvalidated/rl_YAKA_none.csv
Fri Jan 11 09:03:20 2013: Checking format of CSV file: /usr/mc2/csv/cpro/unvalidated/rl_YAKA_none.csv
 9: 3:20 - CSV file format okay
Fri Jan 11 09:03:20 2013: VALIDATING release records.... 
Fri Jan 11 09:03:20 2013: Truncating table rgid_evaluate
Fri Jan 11 09:03:21 2013: Table truncated
Fri Jan 11 09:03:21 2013: Populating table rgid_evaluate with rows on-file from releases_041..
Fri Jan 11 09:03:21 2013: Populating table rgid_evaluate with rows from new dataset..
Fri Jan 11 09:03:21 2013: 0 processed, 0 inserted, 0 updated
Fri Jan 11 09:03:22 2013: Table rgid_evaluate prepared for DIT RGID analysis..
Fri Jan 11 09:03:22 2013: Checking for any rows which fail RGID AD-CLIP condition..
Fri Jan 11 09:03:22 2013: RGID AD-CLIP check complete.
Fri Jan 11 09:03:22 2013: Checking for any rows which fail RGID NON-AD-CLIP condition..
Fri Jan 11 09:03:22 2013: RGID NON-AD-CLIP check complete.
Fri Jan 11 09:03:22 2013: Checking for any rows which fail RGID SPECIES condition..
Fri Jan 11 09:03:22 2013: RGID SPECIES check complete.
Fri Jan 11 09:03:22 2013: Checking for any rows which fail RGID BROOD YEAR condition..
Fri Jan 11 09:03:22 2013: RGID BROOD YEAR check complete.
Result: 1 rows validated, 0 rows not validated, 0 total errors, 0 total messages.
Fri Jan 11 09:03:22 2013: EXITING rl_validate.pm 

Fri Jan 11 09:03:22 2013 Please submit a description file for this VALIDATED dataset  
Fri Jan 11 09:03:22 2013 
Fri Jan 11 09:03:22 2013: STARTING rl_load.pm 
Fri Jan 11 09:03:22 2013: Preparing CSV file for SQL loader
Fri Jan 11 09:03:22 2013: 1 records prepared for SQL loader
Fri Jan 11 09:03:22 2013: Truncating table releases_csv
Fri Jan 11 09:03:22 2013: Table truncated
Fri Jan 11 09:03:22 2013: Dropping Index releases_csv_x1
Fri Jan 11 09:03:22 2013: loading data with sqlldr

SQL*Loader: Release 11.1.0.6.0 - Production on Fri Jan 11 09:03:22 2013

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

Commit point reached - logical record count 1
Fri Jan 11 09:03:22 2013: Updating release_date year, month, day columns
Fri Jan 11 09:03:22 2013: Updating release_location, hatchery_location and stock_location columns
Fri Jan 11 09:03:22 2013: Setting location_key = 0 for null location_code values
Fri Jan 11 09:03:22 2013: Setting midyear flag
Fri Jan 11 09:03:22 2013: Handling special case of 4.1 translated data
Fri Jan 11 09:03:22 2013: Creating index releases_csv_x1
Fri Jan 11 09:03:22 2013: 0 rows indexed
Fri Jan 11 09:03:22 2013: Loading releases_csv tag codes into array
Fri Jan 11 09:03:22 2013: Populating midyear hash
Fri Jan 11 09:03:22 2013: Populating releases_041 hash
Fri Jan 11 09:03:22 2013: LOADING releases_041 records.... 
Fri Jan 11 09:03:22 2013: Iterating through releases_csv array
Fri Jan 11 09:03:22 2013: 0 processed, 0 inserted, 0 updated, 0 rejected
Fri Jan 11 09:03:23 2013: 1 processed, 1 inserted, 0 updated, 0 rejected
Fri Jan 11 09:03:23 2013: Dropping Index releases_csv_x1
Fri Jan 11 09:03:23 2013: EXITING rl_load.pm 

Fri Jan 11 09:03:23 2013: MOVING rl_YAKA_none.csv from /usr/mc2/csv/cpro/unvalidated to /usr/mc2/csv/cpro/validated

Fri Jan 11 09:03:23 2013: APPENDING time stamp: updated file name - /home/yaka/up/RL_YAKA_none.txt-201301110903-PASS 

Fri Jan 11 09:03:23 2013: Refreshing Data Status tables
Fri Jan 11 09:04:21 2013: Disconnecting from cpro.psmfc.org database
       1 = |  Release Group is NEW;