openthc / ccrs

Tracking for the WSLCB CCRS
https://lcb.wa.gov/ccrs
MIT License
4 stars 0 forks source link

Product Name is Truncated #45

Open djbusby opened 1 year ago

djbusby commented 1 year ago

This may be the reason for so many 'Invalid Product' and 'Invalid Area' issues.

We uploaded a Product file with a Product that is exactly 75 characters long; the limit defined in the CCRS specifications; INSERT and UPDATE succeeded w/o issue.

Then we uploaded Inventory with the product name. And we received the error 'Invalid Product'. And in the error-response-file the record had the last character of the product name removed; that is Product Name was only 74 characters!

It appears the Product Name field is truncated. This may be why the CCRS cannot accept this data.