--------------------------------------------------------------  -- [21:48]
sink() diverted to this file, " ~/git/orch/log/MgmtReport/Automation_ETL+MGMT_LogFile_20141202_0048.logr " 

--------------------------------------------------------------  -- [21:48]
sink() diverted to this file, " ~/git/orch/log/MgmtReport/Automation_ETL+MGMT_LogFile_20141202_0048.logr " 

    -------- FRESH / RESET HAPPENED HERE --------               -- [21:48] 
Loading required package: XML
Loading required package: DBI
Warning in setDBsettings(drv.str) : cluster is NULL, defaulting to 09
Warning in eval(expr, envir, enclos) :
  There are '_new' tables for analytics.
This is likely due to a previous error.  Try running:
   qShowTables(name='analytics', schema='bi')

   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

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

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

Reloading utils ...   LOADED.
Updating tables  analytics AND accounting                                   -- [21:48] 
 ---- bucket ::   ' s3://dev-rsaporta/BI_Tables/analytics/20141202/analytics_ '
  -----------{       STARTING   LOAD ANALYTICS  }-----------   -- [23:25]
Cluster is 9 and DB.settings being used are: 
         drv = PostgreSQL
        host = orcd-dw-prod-09.ccvpswrgleoi.us-east-1.redshift.amazonaws.com
        user = rsaporta
    password = ******
        port = 5439
      dbname = dev 

Cluster is 9 and DB.settings being used are: 
         drv = PostgreSQL
        host = orcd-dw-prod-09.ccvpswrgleoi.us-east-1.redshift.amazonaws.com
        user = rsaporta
    password = ******
        port = 5439
      dbname = dev 

   Populating  bi.analytics_new_20141202  from bucket  s3://dev-rsaporta/BI_Tables/analytics/20141202/ -- [23:25] 
Error in notifyIfError(expr = e, msg = sprintf("There was an error in running\n  updateDeNormTable(%s)",  : 
  ERROR in ETL Occurred


There was an error in running
  updateDeNormTable(analytics):
 <<Error in `[.default`(qMaxDate(tbl = tbl, schema = schema, dateCols = dateCols, : incorrect number of dimensions
>>
11: stop(msg.out) at notify.r#86
10: notifyIfError(expr = e, msg = sprintf("There was an error in running\n  updateDeNormTable(%s)", 
        tbl), subj = "ERROR in ETL Occurred", fail = TRUE) at MGMT_REPORT_FULL_AUTO.r#135
9: value[[3L]](cond)
8: tryCatchOne(expr, names, parentenv, handlers[[1L]])
7: tryCatchList(expr, classes, parentenv, handlers)
6: tryCatch(expr = {
       for (tbl in tbls_to_update) {
           ret[[tbl]] <- 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)
           timeCheck[[sprintf("end.%s", tbl)]] <- Sys.time()
       }
   }, error = function(e) notifyIfError(expr = e, msg = sprintf("There was an error in running\n  updateDeNormTable(%s)", 
       tbl), subj = "ERROR in ETL Occurred", fail = TRUE)) at MGMT_REPORT_FULL_AUTO.r#113
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()
 -------------------------------------------------------------- -- [07:41]