./googlemcc.sh: 5: [[: not found
2011-07-05 08:17:36.723 (3) [main]: Debug Level set to 3
2011-07-05 08:17:36.730 (3) [main]: =============== Starting Google MCC Report ================
2011-07-05 08:17:36.730 (3) [main]: ----------------Google MCC Report starting
2011-07-05 08:17:36.882 (3) [P1T1]: === Starting user #8, WWMW - Cellular Safety Commission ===
2011-07-05 08:17:36.883 (3) [P1T1]: Using filename: /var/local/tsa/sedata/google/tsa-mcc-report-2011-06-28-U8.xml.gz
2011-07-05 08:17:37.078 (3) [P1T1]: Created shared sesystem connection rw
2011-07-05 08:17:37.584 (3) [P1T1]: Downloading MCC report...
2011-07-05 08:17:37.586 (3) [P1T1]: Scheduling report attempt 1: name=tsamccreport_2011-06-28_otto@worldwidemediaworks.com_33  with id=null
2011-07-05 08:17:37.586 (3) [P1T1]: validating report job...
2011-07-05 08:17:38.842 (3) [P1T1]: ...success
2011-07-05 08:17:40.209 (3) [P1T1]: Scheduled report. Report Job ID = 1642245491
2011-07-05 08:18:36.882 (3) [main]: Waiting for tasks to be done
2011-07-05 08:19:56.549 (3) [P1T1]: Downloading report attempt 1: name=/var/local/tsa/sedata/google/tsa-mcc-report-2011-06-28-U8.xml.gz  with id=1642245491  from url https://adwords.google.com/api/adwords/ReportDownload?t=AAAAAGHirXMAAAEw-uLLwgEAAAABJ8_c5AJ1_j4zkj9f6IPzYuMVbPkn3aXj
2011-07-05 08:19:56.902 (3) [P1T1]: Connected to URL "https://adwords.google.com/api/adwords/ReportDownload?t=AAAAAGHirXMAAAEw-uLLwgEAAAABJ8_c5AJ1_j4zkj9f6IPzYuMVbPkn3aXj"
2011-07-05 08:19:58.467 (3) [P1T1]: MCC report download (Tue Jun 28 00:00:00 PDT 2011, "/var/local/tsa/sedata/google/tsa-mcc-report-2011-06-28-U8.xml.gz") -> success:true
2011-07-05 08:19:58.467 (3) [P1T1]: Parsing MCC report into staging database...
2011-07-05 08:19:58.491 (3) [P1T1]: DatabasePool with a limit of 3 created
2011-07-05 08:19:58.519 (3) [P1T1]:   Finding column names...
2011-07-05 08:19:58.529 (3) [P1T1]:   Writing temp infile...
2011-07-05 08:19:58.530 (2) [P1T1]:  Adding Campaign: 3568841
2011-07-05 08:19:58.539 (2) [P1T1]:  Adding Campaign: 35709401
2011-07-05 08:19:58.542 (2) [P1T1]:  Adding Campaign: 31372391
2011-07-05 08:19:58.542 (3) [P1T1]:   Deleting existing records where ((`startTime`="2011-06-28 00:00:00"))
2011-07-05 08:19:58.554 (3) [P1T1]:   Loading data infile into temp table...
2011-07-05 08:19:58.567 (2) [P1T1]: Warning(s) detected in statement [LOAD DATA LOCAL INFILE "/tmp/go2011-06-289216204014477046278.tmp" INTO TABLE `tmp`.`tmp1` (`startTime`,`campaignid`,`adgroupid`,`keywordid`,`keyword`,`kwType`,`firstPageCpc`,`qualityScore`,`creativeid`,`adwordsType`,`maxCpc`,`maxCpm`,`kwDestUrl`,`imps`,`clicks`,`cost`,`pos`,`conv`,`transactions`,`purchases`,`purchaseValue`,`leads`,`leadValue`,`signups`,`signupValue`,`pageviews`,`pageviewValue`,`defaultConv`,`defaultConvValue`)] executed by user [spike]
2011-07-05 08:19:58.568 (2) [P1T1]: SQL Warning: Field 'creativeDestUrl' doesn't have a default value (code:1364)
2011-07-05 08:19:58.568 (2) [P1T1]: SQL Warning: Data truncated for column 'qualityScore' at row 1 (code:1265)
2011-07-05 08:19:58.568 (2) [P1T1]: SQL Warning: Data truncated for column 'qualityScore' at row 2 (code:1265)
2011-07-05 08:19:58.568 (2) [P1T1]: SQL Warning: Data truncated for column 'qualityScore' at row 6 (code:1265)
2011-07-05 08:19:58.568 (2) [P1T1]: SQL Warning: Data truncated for column 'qualityScore' at row 7 (code:1265)
2011-07-05 08:19:58.568 (2) [P1T1]: SQL Warning: Data truncated for column 'qualityScore' at row 8 (code:1265)
2011-07-05 08:19:58.568 (2) [P1T1]: SQL Warning: Data truncated for column 'qualityScore' at row 9 (code:1265)
2011-07-05 08:19:58.568 (2) [P1T1]: SQL Warning: Data truncated for column 'qualityScore' at row 10 (code:1265)
2011-07-05 08:19:58.568 (2) [P1T1]: SQL Warning: Data truncated for column 'qualityScore' at row 11 (code:1265)
2011-07-05 08:19:58.568 (3) [P1T1]:   Inserting into staging database...
2011-07-05 08:19:58.577 (3) [P1T1]: ...done
2011-07-05 08:19:58.578 (3) [P1T1]: Sending message to topic...
2011-07-05 08:19:58.579 (3) [P1T1]: Connecting using URL: failover:(tcp://event-msg-broker-01:61616,tcp://event-msg-broker-02:61616)?randomize=false&jms.prefetchPolicy.all=1 to topic tsa.data.events
2011-07-05 08:19:59.076 (3) [P1T1]: Sent.
2011-07-05 08:19:59.077 (3) [P1T1]: === Completed user #8, WWMW - Cellular Safety Commission ===
2011-07-05 08:20:16.883 (3) [main]: ------------Google MCC Report done
2011-07-05 08:20:16.884 (3) [main]: =============== Completed Google MCC Report ================
2011-07-05 08:20:16.885 (3) [main]: Google MCC Report:	2m 40.155s
2011-07-05 08:20:16.885 (3) [main]:     by key:
2011-07-05 08:20:16.885 (3) [main]:         google:	12.858s
2011-07-05 08:20:16.885 (3) [main]:         db:	0.208s
2011-07-05 08:20:16.885 (3) [main]:             by thread:
2011-07-05 08:20:16.885 (3) [main]:                 main:	0.011s
2011-07-05 08:20:16.885 (3) [main]:                 P1T1:	0.197s
2011-07-05 08:20:16.885 (3) [main]:         other:	2m 27.089s