Submit Feedback
Legacy Knowledge Base
Published Jun. 30, 2025

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

Written By

Kanchan Bisht

How To articles are not official guidelines or officially supported documentation. They are community-contributed content and may not always reflect the latest updates to Liferay DXP. We welcome your feedback to improve How To articles!

While we make every effort to ensure this Knowledge Base is accurate, it may not always reflect the most recent updates or official guidelines.We appreciate your understanding and encourage you to reach out with any feedback or concerns.

Legacy Article

You are viewing an article from our legacy "FastTrack" publication program, made available for informational purposes. Articles in this program were published without a requirement for independent editing or verification and are provided"as is" without guarantee.

Before using any information from this article, independently verify its suitability for your situation and project.

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

Did this article resolve your issue ?
Legacy Knowledge Base
Did this article resolve your issue ?