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

Demographic id's are not inserting into table if they are long values

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Venus
    • Fix Version/s: Venus
    • Component/s: None
    • Labels:
      None
    • Sprint:
      Sprint 8

      Description

      Steps:
      1. Run the script after placing the business_areas_demographics.csv in business_taxonomy

      Script: ./load_business_areas_social_demographics.sh spike tar63t aq-qa2-mysql1

      Actual Result:
      ./load_business_areas_social_demographics.sh spike tar63t aq-qa2-mysql1
      batch importing business demographics into mms_common.businessDemographicsLoader
      OpenJDK 64-Bit Server VM warning: Using incremental CMS is deprecated and will likely be removed in a future release
      OpenJDK 64-Bit Server VM warning: If the number of processors is expected to increase from one, then you should configure the number of parallel GC threads appropriately using -XX:ParallelGCThreads=N
      2018-04-23 11:05:00.085 (3) [main]: Debug Level set to 3
      2018-04-23 11:05:00.109 (3) [main]: BatchInsertUtilRunner params: User: spike Password: tar63t Host: aq-qa2-mysql1 Schema: mms_common dbTableName: businessDemographicsLoader columns: ba_id,description,type,id,name filename: business_areas_demographics.csv fieldDelim: , numLinesIgnored: 1
      2018-04-23 11:05:00.780 (3) [main]: JDBC Driver Version: 5.1 (com.mysql.jdbc.Driver)
      ERROR 1062 (23000) at line 14: Duplicate entry '10001-interests-2147483647' for key 'social'
      done

      Expected Result: Script should run successfully and insert the data properly in businessDemographics table.

      Note: File has proper data, there is no duplicate entry.

        Attachments

          Activity

            People

            • Assignee:
              rahul.honakande Rahul Honakande
              Reporter:
              rahul.honakande Rahul Honakande
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: