QoQ HSQLDB: error executing sql statement on query

dev support
1

Hi all,

After updating to 5.4.3.2 we’ve started getting these errors

QoQ HSQLDB: error executing sql statement on query.

data exception: string data, right truncation ; size limit: 32768 table: QCATALOGUEITEMS column: TEXT1

It’s a QoQ joining two other queries.

The same thing is working fine on Lucee 5.3.12.1

I’d be grateful for any suggestions how to deal with it.

OS: Linux 6.2.0-1009-aws
Java Version: 11.0.7
Lucee Version: 5.4.3.2

2

what’s the DDL for the source table?

3

Both tables are from MS SQL Server

4

yeah, that’s not very helpful, what I’m asking is what does the column definition look like in sql server?

or share what you get when you dump a getMetaData for the source query

5

They are quite lengthy, only way I could get them is like this:

qGetStoreProfile
qGetStoreProfile1381×4280 364 KB

6

And the other one

qGetCatalogueItems
qGetCatalogueItems1381×11000 671 KB

And the QoQ that’s erroring out is:

SELECT 
	qCatalogueItems.*, qGetStoreProfile.DisplayPreviousPriceYN, qGetStoreProfile.DetailPageBuyIcon, qGetStoreProfile.DetailPageBuyLabel, 
	qGetStoreProfile.ViewLargerIcon, qGetStoreProfile.ViewLargerText, qGetStoreProfile.ListingBuyIcon, qGetStoreProfile.CatalogueItemCode, 
	qGetStoreProfile.Price, qGetStoreProfile.PreviousPrice, qGetStoreProfile.CostPrice, qGetStoreProfile.Tax, qGetStoreProfile.TaxOption, 
	qGetStoreProfile.TaxNote, qGetStoreProfile.ErrorOutOfStockYN, qGetStoreProfile.ErrorNotOnSaleYN, qGetStoreProfile.PreviousPricingLabel, 
	qGetStoreProfile.CurrentPricingLabel, qGetStoreProfile.TaxDisplayLabel, qGetStoreProfile.CatalogueAttributeProfileCode, 
	qGetStoreProfile.DynamicBasketForModifiersYN, qGetStoreProfile.StockLevel, qGetStoreProfile.ShippingStatus, qGetStoreProfile.EnableSubscriptionYN, 
	qGetStoreProfile.ShowStockLevelYN, qGetStoreProfile.CatalogueID, qGetStoreProfile.CatalogueISBN, qGetStoreProfile.CatalogueASIN, qGetStoreProfile.CatalogueASIN, 
	qGetStoreProfile.CatalogueEAN, qGetStoreProfile.CatalogueUPC, qGetStoreProfile.CatalogueGTIN, qGetStoreProfile.InventoryYN, qGetStoreProfile.StockLevelText, 
	qGetStoreProfile.PriceNote, qGetStoreProfile.eCommerceSetup, qGetStoreProfile.CurrencyCode, qGetStoreProfile.PrimaryCurrencyCode, qGetStoreProfile.SpecialOfferYN, 
	qGetStoreProfile.SpecialOfferImage, qGetStoreProfile.MaxQuantityLimit 
FROM qCatalogueItems, qGetStoreProfile
7

I appreciate you looking into it. Do you need any more information?

8

Hi all, is there any update on this one?

What’s the current thinking?

9

I would download and try the latest version and or come through the change log of the RC and beta versions if this is a concern.

10

please try 5.4.3.10-SNAPSHOT