cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Impex import error : Product,,,,sql error inserting EJBPropertyRowCache

Former Member
0 Likes
960

while inserting the product01 I'm getting Product,,,,sql error inserting EJBPropertyRowCache error

  • My Insert Impex Script**

$catalogVersion=catalogversion(catalog(id[default='apparelProductCatalog']),version[default='Staged'])[unique=true] $approved=approvalstatus(code)[default='approved'] INSERT_UPDATE Product;code[unique=true];varianttype(code);name[lang=en];description[lang=en];ean;manufacturerName;onlineDate[dateformat='MM/dd/yyyy hh:mm:ss a'];offlineDate[dateformat='MM/dd/yyyy hh:mm:ss a'];summary[lang=en];supercategories(code,$catalogVersion);minorderquantity;maxorderquantity;pricequantity;manufacturerAID;unit(code)[default=pieces];$approved;Europe1PriceFactory_PTG(code)[default=eu-vat-full];$catalogVersion;sequenceId[translator=de.hybris.platform.acceleratorservices.dataimport.batch.converter.SequenceIdTranslator] ;product01;colourvariant;"Product Superman King T-shirt – Superman Logo";"

  • Want to wear something unique and still support your favourite team?
  • The Blue army is back and it is going to be better than ever
  • Join the crowd with this comfortable  bright blue t shirt with superman logo print on it
  • This fun t-shirt is a great addition to the wardrobe of any sports fan
  • Product Superman King will give you a great look!
";;PUMA;02/25/2018 12:00:00 AM;02/25/2019 12:00:00 AM;10;"1000,2000";1;5;1;A1234E;pieces;approved;IN_GST_5;

When I remove special character in name field and description field it is working fine.

Is there any limit for description field ? can we use special character in product name field ?

with product description text I'm including unordered list HTML tag also

Thanks, Tejus.R

Accepted Solutions (0)

Answers (0)