Babu Sreekanth wrote:
Hello,
I found an issue with create category. The screen shot is attached.
The scenario is.
1. Through the setup application (ofbiz setup), created an organization
2. Added Facility, Product store etc. and came to the last section
'First product"
3. Created a product catalog , then tried to create a category. It
throws the below exception.
A TRUNCATION ERROR WAS ENCOUNTERED TRYING TO SHRINK VARCHAR
'ABJ_CATALOG_PROMOTIONS' TO LENGTH 20.
CALLING SERVICE CREATEPRODUCTCATEGORY IN
CREATEPRODUCTCATEGORYANDADDTOPRODCATALOG
The issue was on SVN trun, retrieved on 02/12/2010 (Yesterday).
Well the error seems to occur when it try to shrink to fit into the 20
char table name. In the setup UI, there is no place to give the name
for catalog promotion table.
Do you think I should raise a Jira issue. I just created one related
to ofbizsetup --> update contact .
https://issues.apache.org/jira/browse/OFBIZ-3477 . I wanted to make
sure I am following the practice to raise a bug. Do I need to discuss
it in the group prior to create a JIRA ticket?
Thanks,
Babu.
Hi Babu,
createProductCategoryAndAddToProdCatalog event appends the word
"__PROMOTIONS" to catalog id in order to create the promotion category
Id. In my opinion this should be changed to a shorter string.
Feel free to create a jira issue. In the mean time, you can continue
testing by using a shorter catalog Id
Bilgin
