Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: Third Party Data
-
Labels:None
-
Environment:
BidMgr Build:/usr/local/tsa/tsa-build-bidmgr-2010-10-20-p44-r27718
Services:465
UI Build:#6
Description
While processing the Zip file, we got the following exception:
java.text.ParseException: Unparseable date: "FB_20101001"
at java.text.DateFormat.parse(DateFormat.java:335)
at com.thesearchagency.datafeeds.BaseDataFeed.formatSQLTime(BaseDataFeed.java:1618)
at com.thesearchagency.datafeeds.BaseDataFeed.formatSQLTime(BaseDataFeed.java:1599)
at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.getTimeDayFormat(PublisherGenericDataFeed.java:474)
at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.processArray(PublisherGenericDataFeed.java:298)
at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.process(PublisherGenericDataFeed.java:548)
at com.thesearchagency.datafeeds.BaseDataFeed.processZipFile(BaseDataFeed.java:984)
at com.thesearchagency.datafeeds.BaseDataFeed.processDataFile(BaseDataFeed.java:798)
at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.processDataFile(PublisherGenericDataFeed.java:422)
at com.thesearchagency.datafeeds.BaseDataFeed.run(BaseDataFeed.java:378)
.
.
.
.
010-10-22 05:45:07.930 (1) [main]: Exception [Error saving record]:com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Column 'startTime' cannot be null
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3170)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1316)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1235)
at com.carldunham.jst.db.Database.executeUpdate(Database.java:401)
at com.carldunham.jst.db.BaseDatabaseTable.replace(BaseDatabaseTable.java:521)
at com.carldunham.jst.db.BaseDatabaseTableRow.save(BaseDatabaseTableRow.java:480)
at com.thesearchagency.datafeeds.PublisherDataFeedUtils.setPublisherProductSummary(PublisherDataFeedUtils.java:357)
at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.processArray(PublisherGenericDataFeed.java:298)
at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.process(PublisherGenericDataFeed.java:548)
at com.thesearchagency.datafeeds.BaseDataFeed.processZipFile(BaseDataFeed.java:984)
at com.thesearchagency.datafeeds.BaseDataFeed.processDataFile(BaseDataFeed.java:798)
at com.thesearchagency.datafeeds.generic.PublisherGenericDataFeed.processDataFile(PublisherGenericDataFeed.java:422)
at com.thesearchagency.datafeeds.BaseDataFeed.run(BaseDataFeed.java:378)
Please find the datafeed,ConfigurationXml and Log file attached.
