Uploaded image for project: 'AdMaxLocal'
  1. AdMaxLocal
  2. AML-3203

load_business_locations.sh script failing

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: Fuji
    • Fix Version/s: Fuji
    • Component/s: None
    • Labels:
      None
    • Sprint:
      Sprint 10

      Description

      load_business_locations.sh script is failing when running. Using bidg mgr jars from build 472.

      [amlops@aml-qa7-monman1 location_taxonomy]$ ./load_business_locations.sh spike tar63t aml-qa7-mysql1
      batch importing business locations into mms_common.businessLocationsLoader
      rm: cannot remove `/tmp/biz_locs_*': No such file or directory
      2014-10-30 20:16:51.144 (3) [main]: Debug Level set to 3
      2014-10-30 20:16:51.157 (3) [main]: BatchInsertUtilRunner params: User: spike Password: tar63t Host: aml-qa7-mysql1 Schema: mms_common dbTableName: businessLocationsLoader columns: id,description,shortDescription,status,type,parentID,budgetEstimateTarget,budgetEstimateMultiplier,useSEDefinedTargets,usePointRadiusTargets,isSellable filename: /tmp/biz_locs_aa fieldDelim: , numLinesIgnored: 1
      2014-10-30 20:16:51.690 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
      2014-10-30 20:16:51.756 (1) [main]: Exception [Error on line 1: values=[400001,日本,日本,active,日本,0,1,0,1,]]:java.lang.NullPointerException
      at com.thesearchagency.db.util.BatchInsertUtil.getTypeClass(BatchInsertUtil.java:432)
      at com.thesearchagency.db.util.BatchInsertUtil.parseCSV(BatchInsertUtil.java:209)
      at com.thesearchagency.db.util.BatchInsertUtil.batchInsertFromFile(BatchInsertUtil.java:151)
      at com.thesearchagency.db.util.BatchInsertUtilRunner.run(BatchInsertUtilRunner.java:158)
      at com.thesearchagency.db.util.BatchInsertUtilRunner.main(BatchInsertUtilRunner.java:40)

      2014-10-30 20:16:51.759 (1) [main]: Exception [error inserting SQL rows into businessLocationsLoader from file /tmp/biz_locs_aa]:java.lang.NullPointerException
      at com.thesearchagency.db.util.BatchInsertUtil.getTypeClass(BatchInsertUtil.java:432)
      at com.thesearchagency.db.util.BatchInsertUtil.parseCSV(BatchInsertUtil.java:209)
      at com.thesearchagency.db.util.BatchInsertUtil.batchInsertFromFile(BatchInsertUtil.java:151)
      at com.thesearchagency.db.util.BatchInsertUtilRunner.run(BatchInsertUtilRunner.java:158)
      at com.thesearchagency.db.util.BatchInsertUtilRunner.main(BatchInsertUtilRunner.java:40)

      done

        Attachments

          Activity

            People

            • Assignee:
              stacie.waleyko Stacie Waleyko (Inactive)
              Reporter:
              jeff.brown Jeff Brown (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: