You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Xue-Feng Yang <ju...@yahoo.com> on 2014/02/05 23:01:22 UTC
Export Products to eBay: empty eBay Category
Hi all,
I am testing to Export Products to eBay. After choose a product, I have the last step to the dropdown box eBay Category. However, there is nothing inside.
What is the rule to have eBay Category? I googled, but found nothing.
I would be appreciated if anyone could help.
Thanks,
Xuefeng
Re: Export Products to eBay: empty eBay Category
Posted by Xue-Feng Yang <ju...@yahoo.com>.
Hi Jacques:
You may know the meaning of the following error message:
The Following Errors Occurred:
The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by:
Failure in create operation for entity [ProductCategoryRole]: org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:ProductCategoryRole][comments,609549(java.lang.String)]
[createdStamp,2014-02-06 22:13:10.725(java.sql.Timestamp)]
[createdTxStamp,2014-02-06 22:13:10.076(java.sql.Timestamp)]
[fromDate,2014-02-06 22:13:10.725(java.sql.Timestamp)]
[lastUpdatedStamp,2014-02-06 22:13:10.725(java.sql.Timestamp)]
[lastUpdatedTxStamp,2014-02-06 22:13:10.076(java.sql.Timestamp)]
[partyId,DemoEbayAccount1(java.lang.String)]
[productCategoryId,eBay_Category(java.lang.String)]
[roleTypeId,EBAY_ACCOUNT(java.lang.String)]
(SQL Exception while executing the following:
INSERT INTO PRODUCT_CATEGORY_ROLE (PRODUCT_CATEGORY_ID, PARTY_ID, ROLE_TYPE_ID, FROM_DATE, THRU_DATE, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate entry 'eBay_Category-DemoEbayAccount1-EBAY_ACCOUNT-2014-02-06 22:13:10' for key 'PRIMARY')
).
Rolling back transaction.org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:ProductCategoryRole][comments,609549(java.lang.String)]
[createdStamp,2014-02-06 22:13:10.725(java.sql.Timestamp)]
[createdTxStamp,2014-02-06 22:13:10.076(java.sql.Timestamp)]
[fromDate,2014-02-06 22:13:10.725(java.sql.Timestamp)]
[lastUpdatedStamp,2014-02-06 22:13:10.725(java.sql.Timestamp)]
[lastUpdatedTxStamp,2014-02-06 22:13:10.076(java.sql.Timestamp)]
[partyId,DemoEbayAccount1(java.lang.String)]
[productCategoryId,eBay_Category(java.lang.String)]
[roleTypeId,EBAY_ACCOUNT(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO PRODUCT_CATEGORY_ROLE (PRODUCT_CATEGORY_ID, PARTY_ID, ROLE_TYPE_ID, FROM_DATE, THRU_DATE, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate entry 'eBay_Category-DemoEbayAccount1-EBAY_ACCOUNT-2014-02-06 22:13:10' for key 'PRIMARY')
) (Error while inserting: [GenericEntity:ProductCategoryRole]
[comments,609549(java.lang.String)]
[createdStamp,2014-02-06 22:13:10.725(java.sql.Timestamp)]
[createdTxStamp,2014-02-06 22:13:10.076(java.sql.Timestamp)]
[fromDate,2014-02-06 22:13:10.725(java.sql.Timestamp)]
[lastUpdatedStamp,2014-02-06 22:13:10.725(java.sql.Timestamp)]
[lastUpdatedTxStamp,2014-02-06 22:13:10.076(java.sql.Timestamp)]
[partyId,DemoEbayAccount1(java.lang.String)]
[productCategoryId,eBay_Category(java.lang.String)]
[roleTypeId,EBAY_ACCOUNT(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO PRODUCT_CATEGORY_ROLE (PRODUCT_CATEGORY_ID, PARTY_ID, ROLE_TYPE_ID, FROM_DATE, THRU_DATE, COMMENTS, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Duplicate entry 'eBay_Category-DemoEbayAccount1-EBAY_ACCOUNT-2014-02-06 22:13:10' for key 'PRIMARY')
)
)
Thanks
Re: Export Products to eBay: empty eBay Category
Posted by Xue-Feng Yang <ju...@yahoo.com>.
Thank you Jacques. Although it sounds very bad, I'll try more on this. At least, I saw some info in Ofbiz related my account from eBay when setup a store.
Xuefeng
On Thursday, February 6, 2014 6:48:57 AM, Jacques Le Roux <ja...@les7arts.com> wrote:
It's half baked stuff. IIRW I was able to test that complety once (some years ago)
But I can't find any notes, nor in our ML, with http://ofbiz.markmail.org/search/?q=Export+Products+to+eBay
only noticed
http://markmail.org/message/fzxtrszh3bk7ipdk
http://markmail.org/message/hrufslnlldkiqp6i
http://markmail.org/message/mzkttzr6buitcfmu
http://markmail.org/message/5c4najhfd4kk4465
HTH
Jacques
On Wednesday, February 05, 2014 11:01 PM, just4look@yahoo.com wrote
> Hi all,
>
> I am testing to Export Products to eBay. After choose a product, I have the last step to the dropdown box eBay Category. However,
> there is nothing inside.
>
> What is the rule to have eBay Category? I googled, but found nothing.
>
> I would be appreciated if anyone could help.
>
> Thanks,
>
> Xuefeng
Re: Export Products to eBay: empty eBay Category
Posted by Jacques Le Roux <ja...@les7arts.com>.
It's half baked stuff. IIRW I was able to test that complety once (some years ago)
But I can't find any notes, nor in our ML, with http://ofbiz.markmail.org/search/?q=Export+Products+to+eBay
only noticed
http://markmail.org/message/fzxtrszh3bk7ipdk
http://markmail.org/message/hrufslnlldkiqp6i
http://markmail.org/message/mzkttzr6buitcfmu
http://markmail.org/message/5c4najhfd4kk4465
HTH
Jacques
On Wednesday, February 05, 2014 11:01 PM, just4look@yahoo.com wrote
> Hi all,
>
> I am testing to Export Products to eBay. After choose a product, I have the last step to the dropdown box eBay Category. However,
> there is nothing inside.
>
> What is the rule to have eBay Category? I googled, but found nothing.
>
> I would be appreciated if anyone could help.
>
> Thanks,
>
> Xuefeng
Re: Export Products to eBay: empty eBay Category
Posted by Xue-Feng Yang <ju...@yahoo.com>.
I just found the newest eBay java SDK version for ofbiz is 635, but current eBay release is 849. Sounds interesting. So I will go SDK 849 first and back to ofbiz code later to fix the problems.
On Saturday, February 8, 2014 2:06:07 PM, Xue-Feng Yang <ju...@yahoo.com> wrote:
Here is the most recent testing result in log.
13:49:48,763 (http-bio-0.0.0.0-8443-exec-10) [ RequestHandler.java:661:INFO ] Ran Event [service:#exportToEbay] from [request], result is [success]
13:49:48,766 (http-bio-0.0.0.0-8443-exec-10) [ SequenceUtil.java:348:INFO ] Got bank of sequenced IDs for [ServerHitBin]; curSeqId=10130, maxSeqId=1014
13:49:48,768 (http-bio-0.0.0.0-8443-exec-10) [ RequestHandler.java:763:INFO ] Rendering View [ProductsExportToEbay], sessionId=BCD04207ED463B5820F60CC22F
13:49:48,830 (http-bio-0.0.0.0-8443-exec-10) [ ScreenFactory.java:130:INFO ] Got 10 screens in 0.005s from: file:/C:/Programs/ofbiz/specialpurpose/ebay/
It looks successful. However, neither the ofbiz page show anything, nor ebay sandbox show any new list. It's not successful with the word "success".
Any thought?
On Wednesday, February 5, 2014 5:04:42 PM, Xue-Feng Yang <ju...@yahoo.com> wrote:
Hi all,
I am testing to Export Products to eBay. After choose a product, I have the last step to the dropdown box eBay Category. However, there is nothing inside.
What is the rule to have eBay Category? I googled, but found nothing.
I would be appreciated if anyone could help.
Thanks,
Xuefeng
Re: Export Products to eBay: empty eBay Category
Posted by Xue-Feng Yang <ju...@yahoo.com>.
Here is the most recent testing result in log.
13:49:48,763 (http-bio-0.0.0.0-8443-exec-10) [ RequestHandler.java:661:INFO ] Ran Event [service:#exportToEbay] from [request], result is [success]
13:49:48,766 (http-bio-0.0.0.0-8443-exec-10) [ SequenceUtil.java:348:INFO ] Got bank of sequenced IDs for [ServerHitBin]; curSeqId=10130, maxSeqId=1014
13:49:48,768 (http-bio-0.0.0.0-8443-exec-10) [ RequestHandler.java:763:INFO ] Rendering View [ProductsExportToEbay], sessionId=BCD04207ED463B5820F60CC22F
13:49:48,830 (http-bio-0.0.0.0-8443-exec-10) [ ScreenFactory.java:130:INFO ] Got 10 screens in 0.005s from: file:/C:/Programs/ofbiz/specialpurpose/ebay/
It looks successful. However, neither the ofbiz page show anything, nor ebay sandbox show any new list. It's not successful with the word "success".
Any thought?
On Wednesday, February 5, 2014 5:04:42 PM, Xue-Feng Yang <ju...@yahoo.com> wrote:
Hi all,
I am testing to Export Products to eBay. After choose a product, I have the last step to the dropdown box eBay Category. However, there is nothing inside.
What is the rule to have eBay Category? I googled, but found nothing.
I would be appreciated if anyone could help.
Thanks,
Xuefeng