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 | 6 months ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    GitHub comment 254#247941744

    GitHub | 6 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

    Error processing file CRITERIA_PERFORMANCE_REPORT

    GitHub | 2 years ago | spospy
    org.hibernate.exception.DataException: could not perform addBatch
  3. 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
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Solved: java.sql.BatchUpdateException: Row x was cut by GROUP_CONCAT()

    Stack Overflow | 2 years ago | Onur Yılmaz
    java.sql.BatchUpdateException: Row 276751 was cut by GROUP_CONCAT()
  6. 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

  1. linxiaolong 2 times, last 4 days ago
  2. mortalman7 32 times, last 8 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