--------------------------------------------------------------  -- [16:30]
sink() diverted to this file, " ~/git/orch/log/MgmtReport/Automation_ETL+MGMT_LogFile_20141120_1930.logr " 

--------------------------------------------------------------  -- [16:30]
sink() diverted to this file, " ~/git/orch/log/MgmtReport/Automation_ETL+MGMT_LogFile_20141120_1930.logr " 

    -------- FRESH / RESET HAPPENED HERE --------               -- [16:30] 
Loading required package: XML
Loading required package: DBI
   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

        ------------------
         git Pull Request
        ------------------ 

        Executing git pull under user rsaporta 
        Already up-to-date.
   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Reloading utils ...   LOADED.


 ------- BEGINNING VIEW (DROP & RE)CREATE ON CLUSTER  7 -------- 
Dropping view         fa_errors_view  ...... DONE. 
Dropping view            artist_view  ...... DONE. 
Dropping view             label_view  ...... DONE. 
Dropping view             genre_view  ...... DONE. 
Dropping view            period_view  ...... DONE. 
Dropping view   release_product_view  ...... DONE. 
Dropping view             store_view  ...... DONE. 
Dropping view   transactiontype_view  ...... DONE. 
Dropping view           country_view  ...... DONE. 
--------------------------------------------------- 
Creating view           country_view  ...... DONE. 
Creating view   transactiontype_view  ...... DONE. 
Creating view             store_view  ...... DONE. 
Creating view   release_product_view  ...... DONE. 
Creating view            period_view  ...... DONE. 
Creating view             genre_view  ...... DONE. 
Creating view             label_view  ...... DONE. 
Creating view            artist_view  ...... DONE. 
Creating view         fa_errors_view  ...... DONE. 


 ------- BEGINNING VIEW (DROP & RE)CREATE ON CLUSTER  9 -------- 
Dropping view         fa_errors_view  ...... DONE. 
Dropping view            artist_view  ...... DONE. 
Dropping view             label_view  ...... DONE. 
Dropping view             genre_view  ...... DONE. 
Dropping view            period_view  ...... DONE. 
Dropping view   release_product_view  ...... DONE. 
Dropping view             store_view  ...... DONE. 
Dropping view   transactiontype_view  ...... DONE. 
Dropping view           country_view  ...... DONE. 
--------------------------------------------------- 
Creating view           country_view  ...... DONE. 
Creating view   transactiontype_view  ...... DONE. 
Creating view             store_view  ...... DONE. 
Creating view   release_product_view  ...... DONE. 
Creating view            period_view  ...... DONE. 
Creating view             genre_view  ...... DONE. 
Creating view             label_view  ...... DONE. 
Creating view            artist_view  ...... DONE. 
Creating view         fa_errors_view  ...... DONE. 
   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

        ------------------
         git Pull Request
        ------------------ 

        Executing git pull under user rsaporta 
        Already up-to-date.
   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Reloading utils ...   LOADED.
Updating tables  analytics AND accounting                                   -- [16:32] 
Error in if (!is.null(minDate) && !is.character(minDate) || grepl("\\d+\\-\\d+\\-\\d+",  : 
  missing value where TRUE/FALSE needed
10: makeWhereClause.default(whereIn = whereIn, dateCol = dateCol, 
        minDate = minDate, maxDate = maxDate, lte.maxDate = lte.maxDate, 
        gte.minDate = gte.minDate, tbl = tbl, prependCols.with.tbl = prependCols.with.tbl, 
        conjunction = "AND", ...) at DB_Utils_WhereClause.r#10
9: makeWhereClause(whereIn = whereIn, dateCol = dateCol, minDate = minDate, 
       maxDate = maxDate, lte.maxDate = lte.maxDate, gte.minDate = gte.minDate, 
       tbl = tbl, prependCols.with.tbl = prependCols.with.tbl, conjunction = "AND", 
       ...) at DB_Utils.r#1334
8: makeQry(tbl = tbl.fact, colsToPull = NULL, colsToAgg = c(maxdateprocessed = col.maxdate.fact), 
       AggFunc = "max", schema = "production") at DB_Utils.r#999
7: runQry(makeQry(tbl = tbl.fact, colsToPull = NULL, colsToAgg = c(maxdateprocessed = col.maxdate.fact), 
       AggFunc = "max", schema = "production"), cluster = cluster.in, 
       verbose = FALSE) at automate new.r#139
6: updateDeNormTable(tbl = tbl, schema = "bi", delim = "\t", manifest = FALSE, 
       gzip = FALSE, cluster.in = 9, cluster.out = 9, projName = "DeNormalizing", 
       add_aggregated = FALSE, dontRename = FALSE, stamp = stamp, 
       skip.select = skip.select.in_Denormalizing, verbose = TRUE) at MGMT_REPORT_FULL_AUTO.r#103
5: eval(expr, envir, enclos)
4: eval(ei, envir)
3: withVisible(eval(ei, envir))
2: source("~/git/orch/src/MGMT_REPORT_FULL_AUTO.r")
1: source("~/git/orch/src/MGMT_REPORT_FULL_AUTO.r")
Turning off sink()
 -------------------------------------------------------------- -- [16:34]