Uploaded image for project: 'SMB - Optus'
  1. SMB - Optus
  2. OPTUS-51

sesumm exception: Unknown column 'tmp12.qualityScore'

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: 1.3.0
    • Fix Version/s: 1.3.0
    • Component/s: Data Summarization
    • Labels:
      None
    • Environment:

      optus-qa-agency1

      Description

      Running sesumm without -U causes exception

      I ran sepull3.sh -d4, and I get the following exception in sesumm: (full log found: /tmp/sepull.txt)

      2012-06-16 04:18:22.613 (4) [P1T2]: replicated 0 rows to `st-tracker`.`tmp2`
      2012-06-16 04:18:22.613 (4) [P1T11]: replicated 0 rows to `st-tracker`.`tmp1`
      2012-06-16 04:18:22.617 (4) [P1T2]: spike: SQL->[select `st-tracker`.`searchEngineGroups`.`searchEngineAccountID`,`st-tracker`.`searchEngineGroups`.`id` AS `searchEngineGroupID`,`tmp2`.`creativeid`,`tmp2`.`kwType` AS `searchEngineMatchType`,`tmp2`.`keywordid` AS `searchEngineIdentifier`,SUM(`tmp2`.`imps`) AS `imps`,SUM(`tmp2`.`clicks`) AS `clicks`,SUM(`tmp2`.`cost`) AS `cost`,SUM(`tmp2`.`pos` * `tmp2`.`imps`)/SUM(`tmp2`.`imps`) AS `pos`,`tmp2`.`qualityScore` AS `qualityScore`,`tmp2`.`firstPageCPC` AS `firstPageCPC` from `st-tracker`.`tmp2` inner join `st-tracker`.`searchEngineGroups` on (((((`tmp2`.`adgroupid`=`st-tracker`.`searchEngineGroups`.`searchEngineIdentifier`)) and ((`st-tracker`.`searchEngineGroups`.`searchEngineAccountID` in (405776,405777,405775,405774)))))) where ((`tmp2`.`campaignid` in (83977714,83977954,83977834,83977594)) and (`tmp2`.`startTime`="2012-06-15 00:00:00") and (`tmp2`.`adwordsType`="Search Only") and (`tmp2`.`kwType` in ("Broad","BroadMatch","Exact","Phrase"))) group by `tmp2`.`adgroupid`,`tmp2`.`creativeid`,`keywordid`,`kwType`]
      2012-06-16 04:18:22.617 (4) [P1T11]: spike: SQL->[select `st-tracker`.`searchEngineGroups`.`searchEngineAccountID`,`st-tracker`.`searchEngineGroups`.`id` AS `searchEngineGroupID`,`tmp1`.`creativeid`,`tmp1`.`kwType` AS `searchEngineMatchType`,`tmp1`.`keywordid` AS `searchEngineIdentifier`,SUM(`tmp1`.`imps`) AS `imps`,SUM(`tmp1`.`clicks`) AS `clicks`,SUM(`tmp1`.`cost`) AS `cost`,SUM(`tmp1`.`pos` * `tmp1`.`imps`)/SUM(`tmp1`.`imps`) AS `pos`,`tmp1`.`qualityScore` AS `qualityScore`,`tmp1`.`firstPageCPC` AS `firstPageCPC` from `st-tracker`.`tmp1` inner join `st-tracker`.`searchEngineGroups` on (((((`tmp1`.`adgroupid`=`st-tracker`.`searchEngineGroups`.`searchEngineIdentifier`)) and ((`st-tracker`.`searchEngineGroups`.`searchEngineAccountID` in (405747,405748)))))) where ((`tmp1`.`campaignid` in (565761,565760)) and (`tmp1`.`startTime`="2012-06-15 00:00:00") and (`tmp1`.`adwordsType`="Search Only") and (`tmp1`.`kwType` in ("Broad","BroadMatch","Exact","Phrase"))) group by `tmp1`.`adgroupid`,`tmp1`.`creativeid`,`keywordid`,`kwType`]
      2012-06-16 04:18:22.620 (2) [P1T11]: Exception [pulling/processing report for account (57225) "12321669_1"]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'tmp1.qualityScore' in 'field list'
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:3170)
      at com.mysql.jdbc.Connection.execSQL(Connection.java:3099)
      at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172)
      at com.carldunham.jst.db.Database.executeQuery(Database.java:364)
      at com.carldunham.jst.db.Database.executeQuery(Database.java:316)
      at com.carldunham.jst.db.JoinTable.select(JoinTable.java:180)
      at com.carldunham.jst.db.JoinTable.select(JoinTable.java:169)
      at com.carldunham.jst.db.JoinTable.select(JoinTable.java:151)
      at com.thesearchagency.searchengines.google.GoogleAPISearchEngine.getCostAndClicks(GoogleAPISearchEngine.java:918)
      at com.thesearchagency.searchengines.SearchEngineSummarizer$SearchEngineUserWorker.run(SearchEngineSummarizer.java:486)
      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
      at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      at java.util.concurrent.FutureTask.run(FutureTask.java:138)
      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
      at java.lang.Thread.run(Thread.java:662)

      No exception when running: ./sesummarize.sh -U57229 -d4 2> /tmp/sesumm.txt

        Attachments

          Activity

            People

            • Assignee:
              caitlyn Caitlyn Duggan (Inactive)
              Reporter:
              jelliott Jen Clarke (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: