org.springframework.orm.hibernate4.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [insert into AW_ReportKeyword (ACCOUNT_ID, DATE_END, DATE_RANGE_TYPE, DATE_START, PARTNER_ID, TIMESTAMP, TOP_ACCOUNT_ID, ACCOUNT_DESCRIPTIVE_NAME, ACCOUNTTIMEZONEID, NETWORK, NETWORK_PARTNERS, ALL_CONVERSION_RATE, ALL_CONVERSION_VALUE, ALL_CONVERSIONS, AVERAGE_COST, AVERAGE_CPC, AVERAGE_CPE, AVERAGE_CPM, AVERAGE_CPV, AVERAGE_POSITION, CLICK_TYPE, CLICKS, CONVERSIONCATEGORYNAME, CONVERSION_RATE, CONVERSIONTYPENAME, CONVERSION_VALUE, CONVERSIONS, COST, COST_PER_ALL_CONVERSION, COST_PER_CONVERSION, CTR, CURRENCY_CODE, CUSTOMER_DESCRIPTIVE_NAME, DAY, DAYOFWEEK, DEVICE, ENGAGEMENT_RATE, ENGAGEMENTS, IMPRESSIONS, INTERACTION_RATE, INTERACTIONS, MONTH, MONTH_OF_YEAR, PRIMARYCOMPANYNAME, QUARTER, VALUE_PER_ALL_CONVERSION, VALUE_PER_CONVERSION, VIDEO_VIEW_RATE, VIDEO_VIEWS, VIEWTHROUGHCONVERSIONS, WEEK, YEAR, ACTIVE_VIEW_CPM, ACTIVE_VIEW_CTR, ACTIVE_VIEW_IMPRESSIONS, ACTIVE_VIEW_MEASURABILITY, ACTIVE_VIEW_MEASURABLE_COST, ACTIVE_VIEW_MEASURABLE_IMPRESSIONS, ACTIVE_VIEW_VIEWABILITY, ADGROUP_ID, ADGROUP_NAME, AVERAGE_PAGEVIEWS, AVERAGE_TIME_ON_SITE, BOUNCE_RATE, CAMPAIGN_ID, CAMPAIGN_NAME, CONVERSION_TRACKER_ID, CREATIVE_QUALITY_SCORE, CRITERIA, CRITERIA_DESTINATION_URL, ENHANCED_CPC_ENABLED, ESTIMATED_ADD_CLICKS_AT_FIRST_POSITION_CPC, ESTIMATED_ADD_COST_AT_FIRST_POSITION_CPC, FINAL_APP_URLS, FINAL_MOBILE_URLS, FINAL_URLS, FIRST_PAGE_CPC, FIRST_POSITION_CPC, GMAIL_FORWARDS, GMAIL_SAVES, GMAIL_SECONDARY_CLICKS, KEYWORD_ID, KEYWORD_MATCH_TYPE, LABELS, MAX_CPC, MAX_CPM, IS_NEGATIVE, PERCENT_NEW_VISITORS, POST_CLICK_QUALITY_SCORE, QUALITY_SCORE, SEARCH_EXACT_MATCH_IMPRESSION_SHARE, SEARCH_IMPRESSION_SHARE, SEARCH_LOST_IS_RANK, SEARCH_PREDICTED_CTR, SLOT, STATUS, SYSTEM_SERVING_STATUS, TOP_OF_PAGE_CPC, TRACKING_URL_TEMPLATE, URL_CUSTOM_PARAMETERS, VIDEO_QUARTILE_100_RATE, VIDEO_QUARTILE_25_RATE, VIDEO_QUARTILE_50_RATE, VIDEO_QUARTILE_75_RATE, ROW_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [HY000]; error code [1366]; could not perform addBatch; nested exception is org.hibernate.exception.GenericJDBCException: could not perform addBatch

GitHub | praflo | 2 months ago
  1. 0

    GitHub comment 254#247941744

    GitHub | 2 months ago | praflo
    org.springframework.orm.hibernate4.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [insert into AW_ReportKeyword (ACCOUNT_ID, DATE_END, DATE_RANGE_TYPE, DATE_START, PARTNER_ID, TIMESTAMP, TOP_ACCOUNT_ID, ACCOUNT_DESCRIPTIVE_NAME, ACCOUNTTIMEZONEID, NETWORK, NETWORK_PARTNERS, ALL_CONVERSION_RATE, ALL_CONVERSION_VALUE, ALL_CONVERSIONS, AVERAGE_COST, AVERAGE_CPC, AVERAGE_CPE, AVERAGE_CPM, AVERAGE_CPV, AVERAGE_POSITION, CLICK_TYPE, CLICKS, CONVERSIONCATEGORYNAME, CONVERSION_RATE, CONVERSIONTYPENAME, CONVERSION_VALUE, CONVERSIONS, COST, COST_PER_ALL_CONVERSION, COST_PER_CONVERSION, CTR, CURRENCY_CODE, CUSTOMER_DESCRIPTIVE_NAME, DAY, DAYOFWEEK, DEVICE, ENGAGEMENT_RATE, ENGAGEMENTS, IMPRESSIONS, INTERACTION_RATE, INTERACTIONS, MONTH, MONTH_OF_YEAR, PRIMARYCOMPANYNAME, QUARTER, VALUE_PER_ALL_CONVERSION, VALUE_PER_CONVERSION, VIDEO_VIEW_RATE, VIDEO_VIEWS, VIEWTHROUGHCONVERSIONS, WEEK, YEAR, ACTIVE_VIEW_CPM, ACTIVE_VIEW_CTR, ACTIVE_VIEW_IMPRESSIONS, ACTIVE_VIEW_MEASURABILITY, ACTIVE_VIEW_MEASURABLE_COST, ACTIVE_VIEW_MEASURABLE_IMPRESSIONS, ACTIVE_VIEW_VIEWABILITY, ADGROUP_ID, ADGROUP_NAME, AVERAGE_PAGEVIEWS, AVERAGE_TIME_ON_SITE, BOUNCE_RATE, CAMPAIGN_ID, CAMPAIGN_NAME, CONVERSION_TRACKER_ID, CREATIVE_QUALITY_SCORE, CRITERIA, CRITERIA_DESTINATION_URL, ENHANCED_CPC_ENABLED, ESTIMATED_ADD_CLICKS_AT_FIRST_POSITION_CPC, ESTIMATED_ADD_COST_AT_FIRST_POSITION_CPC, FINAL_APP_URLS, FINAL_MOBILE_URLS, FINAL_URLS, FIRST_PAGE_CPC, FIRST_POSITION_CPC, GMAIL_FORWARDS, GMAIL_SAVES, GMAIL_SECONDARY_CLICKS, KEYWORD_ID, KEYWORD_MATCH_TYPE, LABELS, MAX_CPC, MAX_CPM, IS_NEGATIVE, PERCENT_NEW_VISITORS, POST_CLICK_QUALITY_SCORE, QUALITY_SCORE, SEARCH_EXACT_MATCH_IMPRESSION_SHARE, SEARCH_IMPRESSION_SHARE, SEARCH_LOST_IS_RANK, SEARCH_PREDICTED_CTR, SLOT, STATUS, SYSTEM_SERVING_STATUS, TOP_OF_PAGE_CPC, TRACKING_URL_TEMPLATE, URL_CUSTOM_PARAMETERS, VIDEO_QUARTILE_100_RATE, VIDEO_QUARTILE_25_RATE, VIDEO_QUARTILE_50_RATE, VIDEO_QUARTILE_75_RATE, ROW_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [HY000]; error code [1366]; could not perform addBatch; nested exception is org.hibernate.exception.GenericJDBCException: could not perform addBatch
  2. 0

    URL performance report exception

    GitHub | 3 years ago | gcm-boa
    org.springframework.dao.DataIntegrityViolationException: could not perform addBatch; SQL [insert into AW_ReportURL (ACCOUNT_ID, DATE_END, DATE_RANGE_TYPE, DATE_START, PARTNER_ID, TIMESTAMP, TOP_ACCOUNT_ID, ACCOUNT_DESCRIPTIVE_NAME, ACCOUNTTIMEZONEID, NETWORK, NETWORK_PARTNERS, AVERAGE_CPC, AVERAGE_CPM, AVERAGE_POSITION, CLICK_TYPE, CLICKS, CONVERSIONCATEGORYNAME, CONVERSIONRATE, CONVERSIONRATEMANYPERCLICK, CONVERSIONTYPENAME, CONVERSIONVALUE, CONVERSIONS, CONVERSIONSMANYPERCLICK, COST, COSTPERCONVERSION, COSTPERCONVERSIONMANYPERCLICK, CTR, CURRENCY_CODE, CUSTOMER_DESCRIPTIVE_NAME, DAY, DAYOFWEEK, DEVICE, IMPRESSIONS, MONTH, MONTH_OF_YEAR, PRIMARYCOMPANYNAME, PRIMARYUSERLOGIN, QUARTER, VALUEPERCONV, VALUEPERCONVMANYPERCLICK, VALUEPERCONVERSION, VALUEPERCONVERSIONMANYPERCLICK, VIEWTHROUGHCONVERSIONS, WEEK, YEAR, AD_FORMAT, AD_GROUP_CRITERION_STATUS, AD_GROUP_ID, AD_GROUP_NAME, AD_GROUP_STATUS, CAMPAIGN_ID, CAMPAIGN_NAME, CAMPAIGN_STATUS, CRITERIA_PARAMETERS, DISPLAY_NAME, DOMAIN, IS_AUTO_OPTIMIZED, IS_BID_ON_PATH, IS_PATH_EXCLUDED, URL, ROW_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.DataException: could not perform addBatch
  3. 0

    Error processing file CRITERIA_PERFORMANCE_REPORT

    GitHub | 1 year ago | spospy
    org.hibernate.exception.DataException: could not perform addBatch
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Truncate offline cause

    GitHub | 3 years ago | cbos
    java.lang.RuntimeException: javax.persistence.PersistenceException: org.hibernate.exception.DataException: Could not execute JDBC batch update
  6. 0

    bug while using Kratus

    GitHub | 2 years ago | mauromazzucco
    org.springframework.dao.DataIntegrityViolationException: could not perform addBatch; SQL [update AW_ReportKeyword set ACCOUNT_ID=?, DATE_END=?, DATE_RANGE_TYPE=?, DATE_START=?, PARTNER_ID=?, TIMESTAMP=?, TOP_ACCOUNT_ID=?, ACCOUNT_DESCRIPTIVE_NAME=?, ACCOUNTTIMEZONEID=?, NETWORK=?, NETWORK_PARTNERS=?, AVERAGE_CPC=?, AVERAGE_CPM=?, AVERAGE_POSITION=?, CLICK_TYPE=?, CLICKS=?, CONVERSIONCATEGORYNAME=?, CONVERSIONRATE=?, CONVERSIONRATEMANYPERCLICK=?, CONVERSIONTYPENAME=?, CONVERSIONVALUE=?, CONVERSIONS=?, CONVERSIONSMANYPERCLICK=?, COST=?, COSTPERCONVERSION=?, COSTPERCONVERSIONMANYPERCLICK=?, CTR=?, CURRENCY_CODE=?, CUSTOMER_DESCRIPTIVE_NAME=?, DAY=?, DAYOFWEEK=?, DEVICE=?, IMPRESSIONS=?, MONTH=?, MONTH_OF_YEAR=?, PRIMARYCOMPANYNAME=?, PRIMARYUSERLOGIN=?, QUARTER=?, VALUEPERCONV=?, VALUEPERCONVMANYPERCLICK=?, VALUEPERCONVERSION=?, VALUEPERCONVERSIONMANYPERCLICK=?, VIEWTHROUGHCONVERSIONS=?, WEEK=?, YEAR=?, ADGROUP_ID=?, AVERAGE_PAGEVIEWS=?, AVERAGE_TIME_ON_SITE=?, BOUNCE_RATE=?, CAMPAIGN_ID=?, CAMPAIGN_NAME=?, CONVERSIONMANYPERCLICKSIGNIFICANCE=?, CONVERSIONRATEMANYPERCLICKSIGNIFICANCE=?, CONVERSIONRATESIGNIFICANCE=?, CONVERSIONSIGNIFICANCE=?, COSTPERCONVERSIONMANYPERCLICKSIGNIFICANCE=?, COSTPERCONVERSIONSIGNIFICANCE=?, DESTINATION_URL=?, KEYWORD_ID=?, KEYWORD_MATCH_TYPE=?, KEYWORD_TEXT=?, IS_NEGATIVE=?, PERCENT_NEW_VISITORS=?, QUALITY_SCORE=?, STATUS=? where ROW_ID=?]; nested exception is org.hibernate.exception.DataException: could not perform addBatch

  1. linxiaolong 26 times, last 3 weeks ago
  2. linxiaolong 4 times, last 3 months ago
  3. mortalman7 32 times, last 5 months ago
9 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.BatchUpdateException

    Incorrect decimal value: ' --' for column 'QUALITY_SCORE' at row 1

    at com.mysql.jdbc.PreparedStatement.executeBatchedInserts()
  2. MySQL jdbc
    PreparedStatement.executeBatch
    1. com.mysql.jdbc.PreparedStatement.executeBatchedInserts(PreparedStatement.java:1469)
    2. com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1071)
    2 frames