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.