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

load_business_areas.sh content load script is failing.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Fuji
    • Fix Version/s: Fuji
    • Component/s: None
    • Labels:
      None
    • Environment:

      AML-qa7-monman1 Latest Fuji Builds.

    • Sprint:
      Sprint 10

      Description

      Trying to upload the latest Y!J content with the new contentrepository-client-2.7.0-YAHOO-SNAPSHOT-t20141028-172213.one-jar.jar jar fails and produces the error seen below. I have updated aml-qa7 with the latest content and jar files (both contentrepository-client-2.7.0-YAHOO-SNAPSHOT-t20141028-172213.one-jar.jar and batch-import-jar-with-dependencies.jar) and got this error. Manasa is seeing this on AML13 as well.

      on QA7, the files are at /home/amlops/taxo/ in the util folder.

      amlops@aml-qa7-monman1 business_taxonomy]$ ./load_business_areas.sh spike tar63t aml-qa7-mysql1
      batch importing business areas into mms_common.businessAreaLoader
      2014-10-30 17:45:31.956 (3) [main]: Debug Level set to 3
      2014-10-30 17:45:31.969 (3) [main]: BatchInsertUtilRunner params: User: spike Password: tar63t Host: aml-qa7-mysql1 Schema: mms_common dbTableName: businessAreaLoader columns: bc_id,description,id,status filename: business_areas.csv fieldDelim: , numLinesIgnored: 1
      2014-10-30 17:45:32.508 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
      2014-10-30 17:45:32.572 (1) [main]: Exception [Error on line 1: values=[15001,ビジネスホテル,150004,active,]]:java.sql.SQLException: No value specified for parameter 5
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)
      at com.mysql.jdbc.PreparedStatement.checkAllParametersSet(PreparedStatement.java:2611)
      at com.mysql.jdbc.PreparedStatement.addBatch(PreparedStatement.java:1032)
      at com.thesearchagency.db.util.BatchInsertUtil.parseCSV(BatchInsertUtil.java:208)
      at com.thesearchagency.db.util.BatchInsertUtil.batchInsertFromFile(BatchInsertUtil.java:145)
      at com.thesearchagency.db.util.BatchInsertUtilRunner.run(BatchInsertUtilRunner.java:158)
      at com.thesearchagency.db.util.BatchInsertUtilRunner.main(BatchInsertUtilRunner.java:40)

      2014-10-30 17:45:32.575 (1) [main]: Exception [error inserting SQL rows into businessAreaLoader from file business_areas.csv]:java.sql.SQLException: No value specified for parameter 5
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)
      at com.mysql.jdbc.PreparedStatement.checkAllParametersSet(PreparedStatement.java:2611)
      at com.mysql.jdbc.PreparedStatement.addBatch(PreparedStatement.java:1032)
      at com.thesearchagency.db.util.BatchInsertUtil.parseCSV(BatchInsertUtil.java:208)
      at com.thesearchagency.db.util.BatchInsertUtil.batchInsertFromFile(BatchInsertUtil.java:145)
      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:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: