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 | 5 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    GitHub comment 254#247941744

    GitHub | 5 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 | 2 years 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 | 3 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 1 times, last 2 months ago
  2. mortalman7 32 times, last 7 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