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