| Author |
Message |
   
Lindsey Weaver (gadzooks)
Junior Member Username: gadzooks
Post Number: 24 Registered: 06-2006
| | Posted on Tuesday, June 29, 2010 - 09:24 pm: |
|
Just upgraded to 4.03.012 and I have been trying to change the shipping preset on about 300 listings. BTP kept locking up completely for hours. It wouldn't even pop up with the message "you're about to revise these listings online..." I tried with just 1 listing and it took about 10 minutes. I am only changing that ONE field! I'm trying to get all 300+ of these revised tonight but I just did 9 at once and it took half an hour. Any thoughts? Anyone having the same problem. I did a database repair but no help there. Should I just roll back to the older version or maybe it is ebay's site acting up or something? |
   
Jonathan Levie (jonlevie)
Moderator Username: jonlevie
Post Number: 1170 Registered: 02-2005

| | Posted on Tuesday, June 29, 2010 - 10:23 pm: |
|
Hello Lindsey, I did have another customer report similar issues with the revise. I tested their database and was able to reproduce the issue with their listings, but when I added our test account to the database, submitted some listings then revised, I could not reproduce it. Can you please try re-authorizing to get a new token and see if that helps? To do so, go to help-support and select the "Connection" tab. Next, click "Re-authorize Ebay Blackthorne". When the "Blackthorne Authorization" screen comes up, enter your password for your seller ID, click "sign-in", then "agree" on the next page. If this issue continues, please follow the instructions below to upload your database and we'll take a look. In Blackthorne, click "Help-Support" to open the “Support Troubleshooter” select the 6th tab named "Contact Support”. For the "Request Type" field choose "Database Requested by Blackthorne Support" from the dropdown menu. In the "From" dropdown menu, select your e-mail account. In the text area for "Detailed Description" provide details about the problem, record IDs and any steps that reproduce the issue. Also, please include the link to this board thread. Finally, click "Send" to start the database upload process. In the lower right corner of the window you’ll see the progress of the database upload. After the database is uploaded the program will send the email to Blackthorne Database Support. If you see errors sending the email or uploading the database please reply to this email letting us know you had an issue sending the database. Regards, Jonathan eBay Blackthorne Technical Support "Just walk away"
|
   
Lindsey Weaver (gadzooks)
Junior Member Username: gadzooks
Post Number: 25 Registered: 06-2006
| | Posted on Wednesday, June 30, 2010 - 07:46 am: |
|
Thank you for your assistance. I tried the token renewal but there was no change. I emailed the database late last night. I really need this up and running. I have a backup from just before the update. If I uninstall everything and replace the database, will that restore everything to normal (shipping presets, folders, etc. ) or is there still going to be a ton of work to get back to functional? I know it will carry the listings over but are all of the other settings transferred as well? Thank you! |
   
Steve (stevel)
Moderator Username: stevel
Post Number: 1328 Registered: 08-2004

| | Posted on Wednesday, June 30, 2010 - 08:49 am: |
|
We will take a look. Regards, Steve Technical Support Blackthorne Software "Common looking people are the best in the world: that is the reason the Lord makes so many of them." Abraham Lincoln
|
   
Lindsey Weaver (gadzooks)
Junior Member Username: gadzooks
Post Number: 26 Registered: 06-2006
| | Posted on Wednesday, June 30, 2010 - 09:59 am: |
|
Just in case this is useful info.... I tried installing an older version (4.02.019) of BTP on a different computer that has never had BT on it and I transferred our backup database (from immediately before the upgrade) over to that PC. I just moved our backup copy to the C drive of the new PC and told BTP to "switch database" to look at that one. BTP got TONS of error messages. I got big, long, error pop-ups when I tried to view any Ad Template, switch to "running listings" tab and several other times. I closed the software and attempted a database repair directly from the start menu. It said "repair failed". Back on the original computer, I also attempted a database repair from the start menu and it also said "repair failed". Now I'm getting REALLY nervous that our backup copy is also no good. I'm not sure how old the next previous backup is. I figured I'd provide this info just in case any of that is useful in investigating the problem. I REALLY appreciate your help with this and I hope we can get this resolved ASAP. We are really close to getting back into the top-rated program and I'd hate to have some down time now that may affect our DSRs. |
   
Lindsey Weaver (gadzooks)
Junior Member Username: gadzooks
Post Number: 27 Registered: 06-2006
| | Posted on Wednesday, June 30, 2010 - 10:31 am: |
|
Oddly, the new computer, running 4.02.19 with a backup copy of our database seems to be running fine now after a system reboot and the attempted database repair. I haven't refreshed listings or anything but was able to quickly bulk edit and haven't gotten any new error messages while moving around through the program. Whenever I try to re-authorize the token from the new version of BTP, that window pops up over and over and over. It says "successful" or whatever the exact message is but then it pops up again right at the beginning. It isn't like it is completely failing because the revisions work eventually, they just take a really long time. I'm in the process of trying to get back in to try those things that you suggested but the system was still locked up from the attempted database repair. I did check our prostores account though and everything is perfect. The link between ebay and prostores is active and does not expire for several months (but I renewed it anyway just to be sure). All of these weird issues are only happening with the newer version of BTP. I was able to authorize the token with no trouble on the other computer running the older version. I'll update again once I've tried everything else. Thank you! |
   
Lindsey Weaver (gadzooks)
Junior Member Username: gadzooks
Post Number: 28 Registered: 06-2006
| | Posted on Wednesday, June 30, 2010 - 11:12 am: |
|
Tried re-entering the API. It was the exact same link so it didn't prompt me to re-authorize or anything. I tried deleting it, clicking OK and then re-entering but it just accepted the API address without prompting me any further (it seemed from your instructions that there should be some other steps). We only use the custom fields for Prostores listings and don't have any called "Condition". I noticed a few days ago that there were some "extra" listings in the "Running" folder. They said <custom> for just about every field and did not link to actual listings. I figured that something just didn't update correctly. They seemed to be listings that had ended but did not move correctly. The number of running listings was incorrect (high) by exactly the number of these weird ghost entries. I just highlighted them and chose "delete" and everything seemed fine but this problem occurred before the upgrade so perhaps our database was corrupt before the upgrade? I think that may be what the activity log error was about though (unable to update, divide by zero...). I just upgraded BT yesterday but those errors were from several days ago. I'm running a checkdisk on that computer to see if the hard drive is OK. Thanks! |
   
Lindsey Weaver (gadzooks)
Junior Member Username: gadzooks
Post Number: 29 Registered: 06-2006
| | Posted on Wednesday, June 30, 2010 - 11:16 am: |
|
Oh, I'm sorry, I forgot to mention that we were attempting to change all items with a title that starts with the word "Leatherman" AND use the shipping preset "Calculated Priority $2/$3" to the shipping preset "Actual Cost Priority". I first selected all 300+ but then just started alphabetically at the top and tried small chunks at a time (first 9, next 40, etc) |
   
Lindsey Weaver (gadzooks)
Junior Member Username: gadzooks
Post Number: 30 Registered: 06-2006
| | Posted on Wednesday, June 30, 2010 - 12:24 pm: |
|
One more bit of information that may be useful. When I do that very first suggested step of re-authorizing the token. The window opens up with something weird automatically entered in where "ebay ID" should go. It is a web address that starts with http://prostores. I change that to my ebay ID and enter the password. It accepts that and displays "authorization successful" but then I click "done" and it pops back up with the original web address entered into the ebay ID field again. I click Done or Cancel several more times and then the box finally disappears. I think you may be on to something with the authorization thing. Maybe it only affects users that also have a prostores account?? I ran checkdisk with no errors found. |
   
Lindsey Weaver (gadzooks)
Junior Member Username: gadzooks
Post Number: 31 Registered: 06-2006
| | Posted on Wednesday, June 30, 2010 - 12:32 pm: |
|
Eureka! A new breakthrough.... The problem ONLY occurs when I have the box checked to "apply this change to all future listings of this item" If I don't have that box checked, everything is really quick and behaves as usual. Getting closer! |
   
Chet Kresiak (chetkres)
Junior Member Username: chetkres
Post Number: 20 Registered: 02-2008
| | Posted on Wednesday, June 30, 2010 - 05:24 pm: |
|
Also having the same problem with the bulk change. Editing multiple listings also is very, very slow. I am also using the "apply changes to all future listing" check box, so that could be the key. |
   
Ruben Vontalge (ruben12375)
Senior Member Username: ruben12375
Post Number: 3137 Registered: 06-2005

| | Posted on Wednesday, June 30, 2010 - 05:41 pm: |
|
I just upgraded to 4.03.012 ( reluctantly ), and am using SQL. I just did a bulk change on 15 running fixed price listings, just to check this out, and it took less than 15 seconds. (with box checked) However, I still have the problem of my Payment Preset change from the preset name (Payment Preset 1) to a number like 4523 or other 4 digit number. This is a PITA! This has been reported on the BUGS section weeks ago, to no avail. "I can't see!, I can't see!" WHAT'S THE MATTER? "I got my eyes closed"
|
   
Zoulfia Moret (zmoret)
Moderator Username: zmoret
Post Number: 723 Registered: 12-2008

| | Posted on Wednesday, June 30, 2010 - 05:53 pm: |
|
Ruben, are you using "Pay on Pickup" and "Require Immediate Pay" options in your payment presets? _____ Zoulfia Moret eBay Blackthorne software
|
   
Ruben Vontalge (ruben12375)
Senior Member Username: ruben12375
Post Number: 3139 Registered: 06-2005

| | Posted on Wednesday, June 30, 2010 - 06:15 pm: |
|
No neither. Just Paypal and my email address it goes to. Heres the Bugs link: http://www.blackthornesw.com/discus/messages/79779/80195.html?1277934185 "I can't see!, I can't see!" WHAT'S THE MATTER? "I got my eyes closed"
|
   
Lindsey Weaver (gadzooks)
Junior Member Username: gadzooks
Post Number: 32 Registered: 06-2006
| | Posted on Thursday, July 01, 2010 - 11:40 am: |
|
Chet - someone from BT called me and I've emailed in my database. Hopefully they'll be able to reproduce the problem on their systems and figure out the cause. Everything seems to be OK if I don't check the "apply changes to all future listing" box but then I still have a TON of errors in my activity log. Not sure yet if there are other problems (things not actually changing online or something) that I just haven't noticed yet. Have you noticed lots of errors in your Activity log too? |
   
Leslie Van Allen (leslie)
Moderator Username: leslie
Post Number: 2205 Registered: 03-2004

| | Posted on Sunday, July 04, 2010 - 02:29 pm: |
|
Hi Ruben, Your issue is being looked at. CS reference FBZ-3528 date 6/2 ETA version fix for 4.03.013 Regards, Leslie Technical Support eBay Blackthorne Software Occam's razor "The simplest explanation is most likely the correct explanation."
|
   
Ruben Vontalge (ruben12375)
Senior Member Username: ruben12375
Post Number: 3146 Registered: 06-2005

| | Posted on Sunday, July 04, 2010 - 02:59 pm: |
|
Hi Leslie, It looks like you drew the short stick with having to work today. Thanks so much for the update.
 "I can't see!, I can't see!" WHAT'S THE MATTER? "I got my eyes closed"
|
   
Leslie Van Allen (leslie)
Moderator Username: leslie
Post Number: 2212 Registered: 03-2004

| | Posted on Monday, July 05, 2010 - 02:01 pm: |
|
Hi Ruben, You are most welcome, my pleasure. Regards, Leslie Technical Support eBay Blackthorne Software Occam's razor "The simplest explanation is most likely the correct explanation."
|
   
Briansway00 (briansway00)
New member Username: briansway00
Post Number: 3 Registered: 06-2010
| | Posted on Tuesday, July 06, 2010 - 01:13 pm: |
|
We're having the same issue! It takes an EXTREMELY long time to Bulk Revise (I have tried NUMEROUS fields as tests, and they all take the same amount of time) and Bulk Change Item Condition. It only happens when you check "Apply this change to all future listings of this item". When you click on "Change All" in the Bulk Revise window, Blackthorne hangs for an extremely long time before finally revising the items - the Bulk Revise window goes in and out of "Not Responding" every 20+ seconds or so. BT.exe bounces between 0%-2% CPU usage, and sqlservr.exe stays pegged around 12% CPU usage. I'm running Blackthorne Pro 04.03.012 and SQL Server 2005 Express, on Windows 7 64-bit. I tried to bulk revise 250 items, and Blackthorne has been hanged (Not Responding) for 3 hours and counting. Please fix this issue ASAP.. this is a crucial function! Thanks so much! |
   
Moshe (mozray)
Member Username: mozray
Post Number: 159 Registered: 07-2007

| | Posted on Tuesday, July 06, 2010 - 01:19 pm: |
|
Among others, we're having the same issue. Hangs for a long while. Bulk changed Description "_Instructions to _Instructions (copy)" for only 15 items . Have a great day! MmmmmmmmmmmMooooooooooooo
|
   
Leslie Van Allen (leslie)
Moderator Username: leslie
Post Number: 2217 Registered: 03-2004

| | Posted on Tuesday, July 06, 2010 - 01:30 pm: |
|
Hi, The slow down-issues in bulk changes has been reported, current ETA for the fix is version 4.03.014. I do not yet have an exact date for the version but the issue is being worked on and we’ll get the release out as soon as possible. If anything changes with the ETA we will let you know. Regards, Leslie Technical Support eBay Blackthorne Software Occam's razor "The simplest explanation is most likely the correct explanation."
|
   
Briansway00 (briansway00)
New member Username: briansway00
Post Number: 5 Registered: 06-2010
| | Posted on Tuesday, July 06, 2010 - 01:39 pm: |
|
Awesome, it's great to hear that it'll be fixed soon! Do you know if version 04.03.014 is the next version to be released? Thanks! |
   
Matthew P. (countrystarr)
New member Username: countrystarr
Post Number: 6 Registered: 04-2010
| | Posted on Friday, July 09, 2010 - 01:51 pm: |
|
Hello, I've been having the same problems as everybody else trying to bulk change the 'Item Condition' to meet the new ebay requirements. So, hopefully when version 4.03.014 is released...we should be able to: 1) Select the listings under the "Monitor Listings" tab that we need to bulk change (which in my case is all of them, about 2,500) 2) Go to the "Listing Actions" drop down menu item at the top of the screen and select "Bulk Change Item Condition." 3) When the "Bulk Change Item Condition" box comes up we can change our Item Condition as necessary (in my case change to "New With Tags"). Next, click the check box "Apply Changes to All Future Listings of the Item," and then click "Change All." Then hopefully BT can update all the listings more or less within the 'normal' bulk change time frame (for me about 2 listings changed every 3 seconds). Am I getting that right? Thanks for any help. I've been confused and have been having a hard time finding explicit instructions on how to use BT to comply with the ebay required change for Item Condition. I stumbled on this thread which seems to be the most relevant so far. |
   
T. L. (tl408)
Junior Member Username: tl408
Post Number: 19 Registered: 05-2008
| | Posted on Thursday, July 15, 2010 - 12:41 am: |
|
Hi Leslie. I would like to add my name to this list of users having the same exact issue. Not sure if anyone else have also noticed the exponential increase in the database size as well. We are currently running blackthorne on Win2008 with SQL 2005. Before we tried to revise about 800 listings, our database size was at around 9GB. Now, the Blackthorne database grew to 153GB!!!! We tried running the DB repair, as well as DB shrink within SQL Server Management Studio. But that didn't have any impact on the database size. Not sure how the heck Blackthorne DB grew 144GB in size within 1 day. Many of our eBay listings have the part compatibility information added.....We didn't run into this problem revising other listings without the compatibility information. Maybe the issues are caused with something associated with part compatibility information. |
   
B. A. Murry (bam)
Senior Member Username: bam
Post Number: 12417 Registered: 03-2004

| | Posted on Thursday, July 15, 2010 - 01:26 am: |
|
hmmmm... By comparison to mine, your original dB is large and the new one is 'extremely' large. My dB numbers About 10K active Listings with many more archived. About 30K total Items including archived.
 Dell Win7 PC with SQL2005. An older eB version - 3.2.172 with a much smaller dB size. **
 |
   
T. L. (tl408)
Junior Member Username: tl408
Post Number: 20 Registered: 05-2008
| | Posted on Thursday, July 15, 2010 - 10:56 am: |
|
Hi BAM. Thanks for the feedback. We have slightly over 100K listings total including archived ones....So the original 9GB size seems to be relatively "normal" compare to your database size. It seems like it does matter how much space I throw at the database drive, the Blackthorne database will use it all up until the drive is running down to few KB left. That leads me to believe Blackthorne must be writing some error into the log some where causing the database to grow this enormous. I have gone into "Activity Log" and was able to clear out "Listing History", "Email History", "Feedback History" and "eBay Updates". The two tabs remain, "Program Errors" and "Import Errors", I could not pull them up. The SQL server went nuts and pegged at 98% CPU utilization when I selected either one of these two tabs. It also drained the entire 16GB of memory on this Dell PowerEdge 2900. Is there another place that you could go in and manually clear out the error logs for "Program Errors" and "Import Errors"? I'm a little hesitant to poke around directly inside the SQL database table. http://img716.imageshack.us/img716/9008/blackthornedb.jpg |
   
B. A. Murry (bam)
Senior Member Username: bam
Post Number: 12418 Registered: 03-2004

| | Posted on Thursday, July 15, 2010 - 11:54 am: |
|
Here's your jpg. You could use the 'Upload Attachment' button to display within your post.
Apparently these logs are a problem. In the olden days (maybe back to SA Pro) the Activity log was just a text file separate from the dB. Would there be a problem returning/going back to a backup dB? The revision effort was completed in this dB and you really want to keep? Have you closed and then been able to reopen this dB? If these logs are indeed fattening the dB I think Support needs to weigh in...SOOOON! There must be some explanation. But a backup may be the necessary remedy. |
   
T. L. (tl408)
Junior Member Username: tl408
Post Number: 21 Registered: 05-2008
| | Posted on Thursday, July 15, 2010 - 12:42 pm: |
|
Well, well, well....it turned out the "Program Errors" log is the culprit as suspected....Looking through the SQL database table, the "dbo.MsgProgramErrors" table chews up 140GB. Now, I just need a helping hand on how to clear out this log and reclaim back this 140GB.
 |
   
T. L. (tl408)
Junior Member Username: tl408
Post Number: 22 Registered: 05-2008
| | Posted on Thursday, July 15, 2010 - 12:48 pm: |
|
Hopefully the developers would consider redoing the way error logs are saved with newer versions. There should be a maximum log-size limit setting. The logs can just over the write older events as needed....something similar to the Windows Event Viewer. |
   
B. A. Murry (bam)
Senior Member Username: bam
Post Number: 12419 Registered: 03-2004

| | Posted on Thursday, July 15, 2010 - 12:54 pm: |
|
Appears you found the culprit. And maybe the problem for the others commenting earlier. Since 'I know nothing' about SQL (happy enough not) don't have much of a clue. Sooooo...hello! Need some help here! Is there an SQL doctor in the house? And BT....your wizards behind the screen need to figure out how this happens. And, of course, how to have it not happen. |
   
T. L. (tl408)
Junior Member Username: tl408
Post Number: 23 Registered: 05-2008
| | Posted on Thursday, July 15, 2010 - 01:15 pm: |
|
I went ahead and compare all the table sizes inside the SQL database. After excluding the MsgProgramErrors table, everything else seems to add up to the 9GB size as before. Below are the list of the biggest tables. One other table that also caught my attention is the FitmentCompatibilityData. This table alone chews up almost 2GB. That is crazy!!! I didn't pay attention on what the SQL size was before the new Blackthorne 4.03.xx upgrade. But if my math is correct, it sounds like the SQL database just went up 25% in size with that new FitmentCompatibilityData table. (Or is that normal because each listing compatibility data is save separately in this table?.....Meaning the more listing you have with compatibility data, the larger this table would get) Categories 177MB DescriptionFields 1818MB FitmentCompatibilityData 1842MB Items 454MB Listings 630MB Pictures 195MB |
   
B. A. Murry (bam)
Senior Member Username: bam
Post Number: 12420 Registered: 03-2004

| | Posted on Thursday, July 15, 2010 - 01:54 pm: |
|
...The SQL server went nuts....98% CPU utilization when I selected either one of these two tabs ....drained the entire 16GB of memory on this Dell PowerEdge 2900. Most users PCs would have probably 'vaporized' facing this load. |
   
Leslie Van Allen (leslie)
Moderator Username: leslie
Post Number: 2236 Registered: 03-2004

| | Posted on Thursday, July 15, 2010 - 02:21 pm: |
|
T. L. (tl408), I'm running a few tests, get back with you shortly with the results but, you should be able to delete the table dbo.MsgProgramErrors run the BT repairs and get a new empty table. I'll let you know shortly. If you list to motors parts, the FitmentCompatibilityData table reflects data for the number of items you have in the motors parts categories. Regards, Leslie Technical Support eBay Blackthorne Software Occam's razor "The simplest explanation is most likely the correct explanation."
|
   
Leslie Van Allen (leslie)
Moderator Username: leslie
Post Number: 2239 Registered: 03-2004

| | Posted on Thursday, July 15, 2010 - 02:28 pm: |
|
Deleting the dbo.MsgProgramErrors table worked. In SQL delete the table. Run the database repairs. Start-All Programs-eBay-Blackthorne Software-eBay Blackthorne Database Repair Regards, Leslie Technical Support eBay Blackthorne Software Occam's razor "The simplest explanation is most likely the correct explanation."
|
   
Leslie Van Allen (leslie)
Moderator Username: leslie
Post Number: 2240 Registered: 03-2004

| | Posted on Thursday, July 15, 2010 - 02:39 pm: |
|
In BT, you can clear data from other Log entries (log tabs like listing history, email...) using: "Tools-Activity Log" Click "Clear log", located on the right side of the Activity log. The button clears data from the currently viewed log tab. Regards, Leslie Technical Support eBay Blackthorne Software Occam's razor "The simplest explanation is most likely the correct explanation."
|
   
B. A. Murry (bam)
Senior Member Username: bam
Post Number: 12421 Registered: 03-2004

| | Posted on Thursday, July 15, 2010 - 02:45 pm: |
|
I knew that!! Sure (use to, I suppose). Gotten to the point I never really look anymore. No stink'n problems. |
   
T. L. (tl408)
Junior Member Username: tl408
Post Number: 24 Registered: 05-2008
| | Posted on Thursday, July 15, 2010 - 03:02 pm: |
|
Hi Leslie. I've tried going into the "Tool"->"Activity Log"->"Program Errors" to clear it out but no luck. The server would get hammered to death...and the CPU activity eventually drop back down to normal 3%-5%. But the "Clear Log" button would be grayed out. It didn't have any log entry either. But I didn't think it would be able to load up all 140GB of error log either. LOL..... So the other option is to remove it inside SQL database. Are you saying I can just right click on the "dbo.MsgProgramErrors" table and chose "Delete". That is it and run Blackthorne database repair afterward? Just wanted to make sure it won't corrupt the SQL database.....Thanks again for your assistance. |
   
Leslie Van Allen (leslie)
Moderator Username: leslie
Post Number: 2242 Registered: 03-2004

| | Posted on Thursday, July 15, 2010 - 03:17 pm: |
|
I did not say "clear the log for program errors" I said to delete the "table" for program errors. Regards, Leslie Technical Support eBay Blackthorne Software Occam's razor "The simplest explanation is most likely the correct explanation."
|
   
Leslie Van Allen (leslie)
Moderator Username: leslie
Post Number: 2243 Registered: 03-2004

| | Posted on Thursday, July 15, 2010 - 03:23 pm: |
|
Yes..this simple Deleting the dbo.MsgProgramErrors table worked. In SQL delete the table. Run the database repairs. Start-All Programs-eBay-Blackthorne Software-eBay Blackthorne Database Repair Didn't corrupt my SQL database here hence the term "worked". Regards, Leslie Technical Support eBay Blackthorne Software Occam's razor "The simplest explanation is most likely the correct explanation."
|
   
sidney benchetrit (sabbashop)
Member Username: sabbashop
Post Number: 200 Registered: 05-2006
| | Posted on Thursday, July 15, 2010 - 03:43 pm: |
|
Hi Guys Back to the original reason for this thread... Ruben mentioned earlier he didnt have a problem the bulk revise issue: I just did a bulk change on 15 running fixed price listings, just to check this out, and it took less than 15 seconds. (with box checked) Is the bulk revise issue only for access users, or SQL users as well ? Ruben on SQL did not seem to have this issue Also is the program log size error described by tl408 also exclusive to the new version 4.03.012 ? Thanks Sid Thanks, Sid
|
   
Lindsey Weaver (gadzooks)
Junior Member Username: gadzooks
Post Number: 39 Registered: 06-2006
| | Posted on Thursday, July 15, 2010 - 04:06 pm: |
|
We first encountered the issue immediately after upgrading to 4.03.012 but had not ever had it in the past. We were running an Access database and converted to SQL in hopes that it might solve the problem. It didn't but I'm not sure if it is possible that when we experienced the problem once it could have made changes in the database that may have carried over into SQL. Unfortunately, I can't remember if we had reverted to a backup database immediately before converting to SQL or not. We were also experiencing problems with the TrimHTML feature in the new version so we ended up uninstalling 4.03.012 and going all the way back to a version from several months ago (that other users on the forum said solved their TrimHTML issues.) As soon as we installed the older version of BT, we brought in the same database that had all of these problems were immediately solved. Bulk change was very quick and the TrimHTML feature worked perfectly. We're sticking with that version for now but I'm not sure if we're going to have issues with the new Item Condition requirement. I know some categories (clothing mostly) will require the new condition distinctions of "new with tags" etc. Does anyone know if ebay will need the item condition to be in the new field for ALL categories or will they still accept it as an Item Specifics field for most non-clothing categories? Really hoping this just gets resolved before the new requirement goes into effect but figured I should prepare myself for either situation. |
   
sidney benchetrit (sabbashop)
Member Username: sabbashop
Post Number: 201 Registered: 05-2006
| | Posted on Thursday, July 15, 2010 - 04:57 pm: |
|
From what I understand I should only experience issues with 4.03.012 if I: 1) Bulk revise items WITH "apply this change to all future listings of this item" checked. (meaning bulk change without this checked works normally) OR 2) Use the parts compatibility feature. _______________________________________ Is this true ? Also is the giant activity log error mentioned by tl408 also a problem with 4.03.012 ? Thanks, Sid
|
   
Terra Faubel (bucsgirl5671)
New member Username: bucsgirl5671
Post Number: 2 Registered: 02-2009
| | Posted on Friday, July 16, 2010 - 08:10 pm: |
|
I would love to add my name to the list of people having bulk change issues. My program keeps locking up and not responding. Also, it is very slow to sync with ebay or to move between tabs or folders. Please help ASAP as this is really getting frustrating and costly when I sit at my computer to submit 100 items and it takes 30 minutes. Help now!!!!! I read above that I should try to reautorize my account and when I did it gave my an error page and now I have no ebay connection. Help I have to list tonight!!!!!! |
   
T. L. (tl408)
Junior Member Username: tl408
Post Number: 25 Registered: 05-2008
| | Posted on Monday, July 19, 2010 - 10:51 am: |
|
Hi Leslie. Can you let us know if eB 4.03.014 is still on schedule for release this week? We have several thousands of listing needed to be revises. All of these listings have part compatibility information in them. Regardless if the "Apply changes to all future listings of the item" is checked or not, it will always take EXTREMELY long time to revise. Thank you again for your assistance. |
   
T. L. (tl408)
Junior Member Username: tl408
Post Number: 26 Registered: 05-2008
| | Posted on Tuesday, July 20, 2010 - 11:52 pm: |
|
Bump....anyone else have figured a work-around this bulk revise issue for listings with parts compatibility? |
   
sidney benchetrit (sabbashop)
Member Username: sabbashop
Post Number: 203 Registered: 05-2006
| | Posted on Wednesday, July 21, 2010 - 05:01 pm: |
|
Sorry I don't have a workaround. But I went ahead and installed 4.03.012 with SQL a few days ago and I am not experiencing the bulk change freeze up unless I bulk change a large quantity like a few hundred items Thanks, Sid
|
   
James Bass (nkyphotos)
Member Username: nkyphotos
Post Number: 201 Registered: 10-2007

| | Posted on Wednesday, July 21, 2010 - 10:41 pm: |
|
I need to change 17,000+ listings to add the new Item Condition and it is hanging and hanging and hanging and hanging. Done a database repair and view which does not help much. I am using Windows 7 and do not use SQL. Don't all items in certain categories have to have this field updated by July 27th or the GTC listing will be ended. It is not acceptable if they have to wait till another release to fix this. I will have thousands of items being shut down on ebay if this is true. 1st Armored Division 1971 - 1973
|
   
B. A. Murry (bam)
Senior Member Username: bam
Post Number: 12468 Registered: 03-2004

| | Posted on Wednesday, July 21, 2010 - 11:09 pm: |
|
Not all cats will require IC. Do you know, for sure, that all your cats do? http://pages.ebay.com/sellerinformation/news/itemconditionlookup.html |
   
James Bass (nkyphotos)
Member Username: nkyphotos
Post Number: 206 Registered: 10-2007

| | Posted on Wednesday, July 21, 2010 - 11:16 pm: |
|
I probably got several thousand items in the military category. If I was to guess 5-10K of items in all the various military categories. 1st Armored Division 1971 - 1973
|
   
James Bass (nkyphotos)
Member Username: nkyphotos
Post Number: 207 Registered: 10-2007

| | Posted on Wednesday, July 21, 2010 - 11:33 pm: |
|
Yipee after a closer inspection of the categories I do not have the changes in yet. 1st Armored Division 1971 - 1973
|
   
B. A. Murry (bam)
Senior Member Username: bam
Post Number: 12470 Registered: 03-2004

| | Posted on Wednesday, July 21, 2010 - 11:46 pm: |
|
Products work...are mostly 'IC-able'. Many 'collectible' cats won't require ICs as these are currently defined. If ever. It would be a nightmare eBay really doesn't want to face. The cats I use don't use IC. Really I'm down to one cat. For (my) simplicity, I just lump almost all my stuff in one high level cat, 'BB cards - Major League'. I don't worry about year/maker/other eBay defined junk. It seems to me lookers use their own 'search clues' anyway. I DO when searching for the same kind of stuff. |
   
T. L. (tl408)
Junior Member Username: tl408
Post Number: 27 Registered: 05-2008
| | Posted on Friday, July 23, 2010 - 05:12 pm: |
|
Blackthorne Support: I am disappointed to report back the newest version 04.03.019 released today did not fix the issue with "Bulk Change" items with "Part Compatibility" information. It still taking extremely long time to revise. Even if you do not have the check the "Apply changes to all future listings of the item" box. It seems like this problem is only associated with with listings that have "Part Compatibility" information. Even if you "Bulk Change" just a single listing, it still took up several minutes to complete. And some time it stopped and hangs. We are doing this "Bulk Change" locally on the SQL-Server. It has dual quad-core CPU's with 48GB and you can see CPU spiked up to 97% and just stay there. For a single listing revision, it generated a total of 582 error entries in the "Program Errors" log (all of those errors reference to database query error with FitmentCompatibilityData). This explained why our "dbo.MsgProgramErrors" database table jumped to over 140GB in size. (See pictures below. Sorry about the large picture size)
 |
   
Zoulfia Moret (zmoret)
Moderator Username: zmoret
Post Number: 751 Registered: 12-2008

| | Posted on Friday, July 23, 2010 - 05:39 pm: |
|
You are correct, the bug was related to listings that contained compatibility information but we do not see it happening on our side after fixing it in 4.03.019. We'll get back to you after doing more tests. _____ Zoulfia Moret eBay Blackthorne software
|
   
James Bass (nkyphotos)
Member Username: nkyphotos
Post Number: 210 Registered: 10-2007

| | Posted on Friday, July 23, 2010 - 05:51 pm: |
|
I do not use compatibility or what ever it is but I have the problem all the time in any category I list in. I can make it happen 24 hours per day 7 days per week when trying to do a mass update to item condition. I use 04.03.12. When I tried to do this the other night I think blackthorne spun off 38 different processes to update the same 2000+ records. It was simply amazing. No wonder BTPro bogged down to a crawl. With that said I did not have to do the update anyway so this is off my priority list. 1st Armored Division 1971 - 1973
|
   
Thomas Sestak (birdparts)
Member Username: birdparts
Post Number: 150 Registered: 04-2006
| | Posted on Friday, July 23, 2010 - 05:53 pm: |
|
I just update to .012 two hours ago, and bulk change item condition is not working in Ebay Motors, the program just hangs, and I have to restart my computer to get out. Any suggestions? The 7/27 deadline looks like a joke at this rate. |
   
Thomas Sestak (birdparts)
Member Username: birdparts
Post Number: 151 Registered: 04-2006
| | Posted on Friday, July 23, 2010 - 06:35 pm: |
|
Just updated to .019. Bulk item condition change is taking 30 seconds per change. I have 3200 to change, that is 27 hours. Doesn't seem reasonable to me. Also there are about 15 BT icons in my tray, |
   
Ruben Vontalge (ruben12375)
Senior Member Username: ruben12375
Post Number: 3204 Registered: 06-2005

| | Posted on Friday, July 23, 2010 - 06:43 pm: |
|
If there are 15 catagories being changed, then for a short while, there will be 15 BT icons. "I can't see!, I can't see!" WHAT'S THE MATTER? "I got my eyes closed"
|
   
Thomas Sestak (birdparts)
Member Username: birdparts
Post Number: 152 Registered: 04-2006
| | Posted on Friday, July 23, 2010 - 06:46 pm: |
|
OK, what about 30 seconds per change in .019? Is that acceptable in 2010? |
   
Thomas Sestak (birdparts)
Member Username: birdparts
Post Number: 153 Registered: 04-2006
| | Posted on Friday, July 23, 2010 - 06:54 pm: |
|
I just changed (100) listings. It took 45 minutes. I just checked a few of the listings, and item condition is not changed in about 50% of them??!!!!! |
   
sidney benchetrit (sabbashop)
Member Username: sabbashop
Post Number: 206 Registered: 05-2006
| | Posted on Friday, July 23, 2010 - 07:00 pm: |
|
That happened to me. When I checked the ones that had errors, many of them (but not all) were outdated categories Thanks, Sid
|
   
Thomas Sestak (birdparts)
Member Username: birdparts
Post Number: 154 Registered: 04-2006
| | Posted on Friday, July 23, 2010 - 07:07 pm: |
|
My categories are all current. This is in my activity log: Access to the path 'C:\Documents and Settings\owner\Application Data\eBay\Blackthorne\System.pvt' is denied. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share) at System.Xml.XmlTextWriter..ctor(String filename, Encoding encoding) at System.Xml.XmlDocument.Save(String filename) at Blackthorne.PrivateRegistry.SaveSetting(RegistryCodeType Registry, String Group, String Section, String Key, String KeyValue) |
   
Jonathan Levie (jonlevie)
Moderator Username: jonlevie
Post Number: 1185 Registered: 02-2005

| | Posted on Friday, July 23, 2010 - 08:39 pm: |
|
Hello all, For anyone that is still experiencing a slow revise, please follow the instructions below to upload your database so we can take a look. When you send the database email, please give an example of what you're revising and how many at a time so we can test here. Also, please include the link to this thread in your email. In Blackthorne, click "Help-Support" to open the “Support Troubleshooter” select the 6th tab named "Contact Support”. For the "Request Type" field choose "Database Requested by Blackthorne Support" from the dropdown menu. In the "From" dropdown menu, select your e-mail account. In the text area for "Detailed Description" provide details about the problem, record IDs and any steps that reproduce the issue. Finally, click "Send" to start the database upload process. In the lower right corner of the window you’ll see the progress of the database upload. After the database is uploaded the program will send the email to Blackthorne Database Support. If you see errors sending the email or uploading the database please reply to this email letting us know you had an issue sending the database. Regards, Jonathan eBay Blackthorne Technical Support "Just walk away"
|
   
T. L. (tl408)
Junior Member Username: tl408
Post Number: 28 Registered: 05-2008
| | Posted on Monday, July 26, 2010 - 11:30 am: |
|
Hi Jonathan. I just sent you an email. Our database was previously uploaded to you guys on June 12th. It is the same DB. Let me know if any other information is needed. Thank you. |
   
Thomas Sestak (birdparts)
Member Username: birdparts
Post Number: 155 Registered: 04-2006
| | Posted on Monday, July 26, 2010 - 09:43 pm: |
|
I tried to bulk change item condition for 2700 listings in Ebay Motors. I started it Saturday morning before I left for vacation. I just got back, and it failed. I have an out of memory error of some sort, and 217,652 program errors in my activity log! Help. |
   
Zoulfia Moret (zmoret)
Moderator Username: zmoret
Post Number: 779 Registered: 12-2008

| | Posted on Thursday, July 29, 2010 - 06:22 pm: |
|
Try reducing the number of listings to 300 or so and go up from there. _____ Zoulfia Moret eBay Blackthorne software
|
   
T. L. (tl408)
Junior Member Username: tl408
Post Number: 29 Registered: 05-2008
| | Posted on Tuesday, August 03, 2010 - 02:46 am: |
|
Hi Jonathan. As you've requested, I have uploaded our SQL database. Let me know if anything else is needed. Thank you again for your assistance. |
   
Jonathan Levie (jonlevie)
Moderator Username: jonlevie
Post Number: 1211 Registered: 02-2005

| | Posted on Tuesday, August 03, 2010 - 03:33 pm: |
|
Hello Tuan, I am downloading the database and will get back to you soon. Regards, Jonathan eBay Blackthorne Technical Support "Just walk away"
|
   
Harvey (hei83)
New member Username: hei83
Post Number: 3 Registered: 04-2010
| | Posted on Thursday, August 05, 2010 - 07:30 pm: |
|
Hi Tech Support I've tried every different ways to increase the speed of this 4.03.019. The access database size was reduced from 1.5G to 300mb now and it is still extremely slow. I used to have all my items (3000+) from all my accounts (8 accounts) running on the same database and now I have them running in 7 different databases I make changes or upload those database one by one. The speed is still not acceptable after the parts compatibility was added to it. My current setup: Windows 7 32bit Intel I5 661 4GB ram SSD Please let me know if further improvement will be available soon or I would have to use turbo lister like back then. Thank you Harvey |