Exception executing batch [java.sql.BatchUpdateException: data exception: string data, right truncation ; size limit: 75 table: COMMERCEVIRTUALORDERITEM column: URL]

Issue

  • Virtual Product URLs can contain only 75 characters
  • Steps To Reproduce
    1. Create a Minium
    2. Money Order is enabled
    3. Create a Virtual Product with a price
    4. Into the URL, put something that contains more than 75 characters
    5. Save
    6. Start the checkout with that virtual product on Minium
    7. Go into the Admin Order
    8. Set the payment to Completed and finish the checkout
    9. Go into the Placed Order on Minium
    10. Deploy the widget "Product Downloads"
    Expected Behavior: The entry to download the product is present.
    Observed Behavior: The entry to download the product is not present.
    The following error is thrown inside the Tomcat console:
    ERROR [liferay/commerce_payment_status-2][BatchingBatch:134] HHH000315: Exception executing batch [java.sql.BatchUpdateException: data exception: string data, right truncation ; size limit: 75 table: COMMERCEVIRTUALORDERITEM column: URL], SQL: insert into CommerceVirtualOrderItem (mvccVersion, uuid_, groupId, companyId, userId, userName, createDate, modifiedDate, commerceOrderItemId, fileEntryId, url, activationStatus, duration, usages, maxUsages, active_, startDate, endDate, commerceVirtualOrderItemId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Environment

  • Liferay DXP 7.4
  • Commerce 4.0

Resolution

  • The observed behavior is a known bug of commerce which is being addressed via COMMERCE-11337 

Additional Information

Was this article helpful?
0 out of 0 found this helpful