Topics Topics Edit Profile Profile Help/Instructions Help Member List Member List  
Search Last 1|3|7 Days Search Search Tree View Tree View  

Bulk revise REALLY REALLY slow after ...

Blackthorne Discussion Group » Blackthorne Pro » Bulk revise REALLY REALLY slow after upgrade « Previous Next »

  Start New Thread Last Poster Posts Pages Last Post
  Start New Thread        

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this message

Lindsey Weaver (gadzooks)
Junior Member
Username: gadzooks

Post Number: 24
Registered: 06-2006
Posted on Tuesday, June 29, 2010 - 09:24 pm:   Edit Post Delete Post Print Post

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?
Top of pagePrevious messageNext messageBottom of page Link to this message

Jonathan Levie (jonlevie)
Moderator
Username: jonlevie

Post Number: 1170
Registered: 02-2005


Posted on Tuesday, June 29, 2010 - 10:23 pm:   Edit Post Delete Post Print Post

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"




Top of pagePrevious messageNext messageBottom of page Link to this message

Lindsey Weaver (gadzooks)
Junior Member
Username: gadzooks

Post Number: 25
Registered: 06-2006
Posted on Wednesday, June 30, 2010 - 07:46 am:   Edit Post Delete Post Print Post

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!
Top of pagePrevious messageNext messageBottom of page Link to this message

Steve (stevel)
Moderator
Username: stevel

Post Number: 1328
Registered: 08-2004


Posted on Wednesday, June 30, 2010 - 08:49 am:   Edit Post Delete Post Print Post

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
Top of pagePrevious messageNext messageBottom of page Link to this message

Lindsey Weaver (gadzooks)
Junior Member
Username: gadzooks

Post Number: 26
Registered: 06-2006
Posted on Wednesday, June 30, 2010 - 09:59 am:   Edit Post Delete Post Print Post

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.
Top of pagePrevious messageNext messageBottom of page Link to this message

Lindsey Weaver (gadzooks)
Junior Member
Username: gadzooks

Post Number: 27
Registered: 06-2006
Posted on Wednesday, June 30, 2010 - 10:31 am:   Edit Post Delete Post Print Post

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!
Top of pagePrevious messageNext messageBottom of page Link to this message

Lindsey Weaver (gadzooks)
Junior Member
Username: gadzooks

Post Number: 28
Registered: 06-2006
Posted on Wednesday, June 30, 2010 - 11:12 am:   Edit Post Delete Post Print Post

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!
Top of pagePrevious messageNext messageBottom of page Link to this message

Lindsey Weaver (gadzooks)
Junior Member
Username: gadzooks

Post Number: 29
Registered: 06-2006
Posted on Wednesday, June 30, 2010 - 11:16 am:   Edit Post Delete Post Print Post

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)
Top of pagePrevious messageNext messageBottom of page Link to this message

Lindsey Weaver (gadzooks)
Junior Member
Username: gadzooks

Post Number: 30
Registered: 06-2006
Posted on Wednesday, June 30, 2010 - 12:24 pm:   Edit Post Delete Post Print Post

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.
Top of pagePrevious messageNext messageBottom of page Link to this message

Lindsey Weaver (gadzooks)
Junior Member
Username: gadzooks

Post Number: 31
Registered: 06-2006
Posted on Wednesday, June 30, 2010 - 12:32 pm:   Edit Post Delete Post Print Post

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!
Top of pagePrevious messageNext messageBottom of page Link to this message

Chet Kresiak (chetkres)
Junior Member
Username: chetkres

Post Number: 20
Registered: 02-2008
Posted on Wednesday, June 30, 2010 - 05:24 pm:   Edit Post Delete Post Print Post

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.
Top of pagePrevious messageNext messageBottom of page Link to this message

Ruben Vontalge (ruben12375)
Senior Member
Username: ruben12375

Post Number: 3137
Registered: 06-2005


Posted on Wednesday, June 30, 2010 - 05:41 pm:   Edit Post Delete Post Print Post

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"
Top of pagePrevious messageNext messageBottom of page Link to this message

Zoulfia Moret (zmoret)
Moderator
Username: zmoret

Post Number: 723
Registered: 12-2008


Posted on Wednesday, June 30, 2010 - 05:53 pm:   Edit Post Delete Post Print Post

Ruben, are you using "Pay on Pickup" and "Require Immediate Pay" options in your payment presets?
_____
Zoulfia Moret
eBay Blackthorne software
Top of pagePrevious messageNext messageBottom of page Link to this message

Ruben Vontalge (ruben12375)
Senior Member
Username: ruben12375

Post Number: 3139
Registered: 06-2005


Posted on Wednesday, June 30, 2010 - 06:15 pm:   Edit Post Delete Post Print Post

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"
Top of pagePrevious messageNext messageBottom of page Link to this message

Lindsey Weaver (gadzooks)
Junior Member
Username: gadzooks

Post Number: 32
Registered: 06-2006
Posted on Thursday, July 01, 2010 - 11:40 am:   Edit Post Delete Post Print Post

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?
Top of pagePrevious messageNext messageBottom of page Link to this message

Leslie Van Allen (leslie)
Moderator
Username: leslie

Post Number: 2205
Registered: 03-2004


Posted on Sunday, July 04, 2010 - 02:29 pm:   Edit Post Delete Post Print Post

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."
Top of pagePrevious messageNext messageBottom of page Link to this message

Ruben Vontalge (ruben12375)
Senior Member
Username: ruben12375

Post Number: 3146
Registered: 06-2005


Posted on Sunday, July 04, 2010 - 02:59 pm:   Edit Post Delete Post Print Post

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"
Top of pagePrevious messageNext messageBottom of page Link to this message

Leslie Van Allen (leslie)
Moderator
Username: leslie

Post Number: 2212
Registered: 03-2004


Posted on Monday, July 05, 2010 - 02:01 pm:   Edit Post Delete Post Print Post

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."
Top of pagePrevious messageNext messageBottom of page Link to this message

Briansway00 (briansway00)
New member
Username: briansway00

Post Number: 3
Registered: 06-2010
Posted on Tuesday, July 06, 2010 - 01:13 pm:   Edit Post Delete Post Print Post

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!
Top of pagePrevious messageNext messageBottom of page Link to this message

Moshe (mozray)
Member
Username: mozray

Post Number: 159
Registered: 07-2007


Posted on Tuesday, July 06, 2010 - 01:19 pm:   Edit Post Delete Post Print Post

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
Top of pagePrevious messageNext messageBottom of page Link to this message

Leslie Van Allen (leslie)
Moderator
Username: leslie

Post Number: 2217
Registered: 03-2004


Posted on Tuesday, July 06, 2010 - 01:30 pm:   Edit Post Delete Post Print Post

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."
Top of pagePrevious messageNext messageBottom of page Link to this message

Briansway00 (briansway00)
New member
Username: briansway00

Post Number: 5
Registered: 06-2010
Posted on Tuesday, July 06, 2010 - 01:39 pm:   Edit Post Delete Post Print Post

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!
Top of pagePrevious messageNext messageBottom of page Link to this message

Matthew P. (countrystarr)
New member
Username: countrystarr

Post Number: 6
Registered: 04-2010
Posted on Friday, July 09, 2010 - 01:51 pm:   Edit Post Delete Post Print Post

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.
Top of pagePrevious messageNext messageBottom of page Link to this message

T. L. (tl408)
Junior Member
Username: tl408

Post Number: 19
Registered: 05-2008
Posted on Thursday, July 15, 2010 - 12:41 am:   Edit Post Delete Post Print Post

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.
Top of pagePrevious messageNext messageBottom of page Link to this message

B. A. Murry (bam)
Senior Member
Username: bam

Post Number: 12417
Registered: 03-2004


Posted on Thursday, July 15, 2010 - 01:26 am:   Edit Post Delete Post Print Post

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.

cb

Dell Win7 PC with SQL2005. An older eB version - 3.2.172 with a much smaller dB size.
**
a
Top of pagePrevious messageNext messageBottom of page Link to this message

T. L. (tl408)
Junior Member
Username: tl408

Post Number: 20
Registered: 05-2008
Posted on Thursday, July 15, 2010 - 10:56 am:   Edit Post Delete Post Print Post

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
Top of pagePrevious messageNext messageBottom of page Link to this message

B. A. Murry (bam)
Senior Member
Username: bam

Post Number: 12418
Registered: 03-2004


Posted on Thursday, July 15, 2010 - 11:54 am:   Edit Post Delete Post Print Post

Here's your jpg. You could use the 'Upload Attachment' button to display within your post.

a

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.
Top of pagePrevious messageNext messageBottom of page Link to this message

T. L. (tl408)
Junior Member
Username: tl408

Post Number: 21
Registered: 05-2008
Posted on Thursday, July 15, 2010 - 12:42 pm:   Edit Post Delete Post Print Post

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.



Blackthorne DB
Top of pagePrevious messageNext messageBottom of page Link to this message

T. L. (tl408)
Junior Member
Username: tl408

Post Number: 22
Registered: 05-2008
Posted on Thursday, July 15, 2010 - 12:48 pm:   Edit Post Delete Post Print Post

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.
Top of pagePrevious messageNext messageBottom of page Link to this message

B. A. Murry (bam)
Senior Member
Username: bam

Post Number: 12419
Registered: 03-2004


Posted on Thursday, July 15, 2010 - 12:54 pm:   Edit Post Delete Post Print Post

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.
Top of pagePrevious messageNext messageBottom of page Link to this message

T. L. (tl408)
Junior Member
Username: tl408

Post Number: 23
Registered: 05-2008
Posted on Thursday, July 15, 2010 - 01:15 pm:   Edit Post Delete Post Print Post

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
Top of pagePrevious messageNext messageBottom of page Link to this message

B. A. Murry (bam)
Senior Member
Username: bam

Post Number: 12420
Registered: 03-2004


Posted on Thursday, July 15, 2010 - 01:54 pm:   Edit Post Delete Post Print Post

...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.
Top of pagePrevious messageNext messageBottom of page Link to this message

Leslie Van Allen (leslie)
Moderator
Username: leslie

Post Number: 2236
Registered: 03-2004


Posted on Thursday, July 15, 2010 - 02:21 pm:   Edit Post Delete Post Print Post

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."
Top of pagePrevious messageNext messageBottom of page Link to this message

Leslie Van Allen (leslie)
Moderator
Username: leslie

Post Number: 2239
Registered: 03-2004


Posted on Thursday, July 15, 2010 - 02:28 pm:   Edit Post Delete Post Print Post

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."
Top of pagePrevious messageNext messageBottom of page Link to this message

Leslie Van Allen (leslie)
Moderator
Username: leslie

Post Number: 2240
Registered: 03-2004


Posted on Thursday, July 15, 2010 - 02:39 pm:   Edit Post Delete Post Print Post

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."
Top of pagePrevious messageNext messageBottom of page Link to this message

B. A. Murry (bam)
Senior Member
Username: bam

Post Number: 12421
Registered: 03-2004


Posted on Thursday, July 15, 2010 - 02:45 pm:   Edit Post Delete Post Print Post

I knew that!! Sure (use to, I suppose).

Gotten to the point I never really look anymore.
No stink'n problems.
Top of pagePrevious messageNext messageBottom of page Link to this message

T. L. (tl408)
Junior Member
Username: tl408

Post Number: 24
Registered: 05-2008
Posted on Thursday, July 15, 2010 - 03:02 pm:   Edit Post Delete Post Print Post

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.
Top of pagePrevious messageNext messageBottom of page Link to this message

Leslie Van Allen (leslie)
Moderator
Username: leslie

Post Number: 2242
Registered: 03-2004


Posted on Thursday, July 15, 2010 - 03:17 pm:   Edit Post Delete Post Print Post

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."
Top of pagePrevious messageNext messageBottom of page Link to this message

Leslie Van Allen (leslie)
Moderator
Username: leslie

Post Number: 2243
Registered: 03-2004


Posted on Thursday, July 15, 2010 - 03:23 pm:   Edit Post Delete Post Print Post

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."
Top of pagePrevious messageNext messageBottom of page Link to this message

sidney benchetrit (sabbashop)
Member
Username: sabbashop

Post Number: 200
Registered: 05-2006
Posted on Thursday, July 15, 2010 - 03:43 pm:   Edit Post Delete Post Print Post

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
Top of pagePrevious messageNext messageBottom of page Link to this message

Lindsey Weaver (gadzooks)
Junior Member
Username: gadzooks

Post Number: 39
Registered: 06-2006
Posted on Thursday, July 15, 2010 - 04:06 pm:   Edit Post Delete Post Print Post

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.
Top of pagePrevious messageNext messageBottom of page Link to this message

sidney benchetrit (sabbashop)
Member
Username: sabbashop

Post Number: 201
Registered: 05-2006
Posted on Thursday, July 15, 2010 - 04:57 pm:   Edit Post Delete Post Print Post

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
Top of pagePrevious messageNext messageBottom of page Link to this message

Terra Faubel (bucsgirl5671)
New member
Username: bucsgirl5671

Post Number: 2
Registered: 02-2009
Posted on Friday, July 16, 2010 - 08:10 pm:   Edit Post Delete Post Print Post

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!!!!!!
Top of pagePrevious messageNext messageBottom of page Link to this message

T. L. (tl408)
Junior Member
Username: tl408

Post Number: 25
Registered: 05-2008
Posted on Monday, July 19, 2010 - 10:51 am:   Edit Post Delete Post Print Post

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.
Top of pagePrevious messageNext messageBottom of page Link to this message

T. L. (tl408)
Junior Member
Username: tl408

Post Number: 26
Registered: 05-2008
Posted on Tuesday, July 20, 2010 - 11:52 pm:   Edit Post Delete Post Print Post

Bump....anyone else have figured a work-around this bulk revise issue for listings with parts compatibility?
Top of pagePrevious messageNext messageBottom of page Link to this message

sidney benchetrit (sabbashop)
Member
Username: sabbashop

Post Number: 203
Registered: 05-2006
Posted on Wednesday, July 21, 2010 - 05:01 pm:   Edit Post Delete Post Print Post

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
Top of pagePrevious messageNext messageBottom of page Link to this message

James Bass (nkyphotos)
Member
Username: nkyphotos

Post Number: 201
Registered: 10-2007


Posted on Wednesday, July 21, 2010 - 10:41 pm:   Edit Post Delete Post Print Post

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
Top of pagePrevious messageNext messageBottom of page Link to this message

B. A. Murry (bam)
Senior Member
Username: bam

Post Number: 12468
Registered: 03-2004


Posted on Wednesday, July 21, 2010 - 11:09 pm:   Edit Post Delete Post Print Post

Not all cats will require IC.

Do you know, for sure, that all your cats do?

http://pages.ebay.com/sellerinformation/news/itemconditionlookup.html
Top of pagePrevious messageNext messageBottom of page Link to this message

James Bass (nkyphotos)
Member
Username: nkyphotos

Post Number: 206
Registered: 10-2007


Posted on Wednesday, July 21, 2010 - 11:16 pm:   Edit Post Delete Post Print Post

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
Top of pagePrevious messageNext messageBottom of page Link to this message

James Bass (nkyphotos)
Member
Username: nkyphotos

Post Number: 207
Registered: 10-2007


Posted on Wednesday, July 21, 2010 - 11:33 pm:   Edit Post Delete Post Print Post

Yipee after a closer inspection of the categories I do not have the changes in yet.
1st Armored Division
1971 - 1973
Top of pagePrevious messageNext messageBottom of page Link to this message

B. A. Murry (bam)
Senior Member
Username: bam

Post Number: 12470
Registered: 03-2004


Posted on Wednesday, July 21, 2010 - 11:46 pm:   Edit Post Delete Post Print Post

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.
Top of pagePrevious messageNext messageBottom of page Link to this message

T. L. (tl408)
Junior Member
Username: tl408

Post Number: 27
Registered: 05-2008
Posted on Friday, July 23, 2010 - 05:12 pm:   Edit Post Delete Post Print Post

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)



Top of pagePrevious messageNext messageBottom of page Link to this message

Zoulfia Moret (zmoret)
Moderator
Username: zmoret

Post Number: 751
Registered: 12-2008


Posted on Friday, July 23, 2010 - 05:39 pm:   Edit Post Delete Post Print Post

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
Top of pagePrevious messageNext messageBottom of page Link to this message

James Bass (nkyphotos)
Member
Username: nkyphotos

Post Number: 210
Registered: 10-2007


Posted on Friday, July 23, 2010 - 05:51 pm:   Edit Post Delete Post Print Post

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
Top of pagePrevious messageNext messageBottom of page Link to this message

Thomas Sestak (birdparts)
Member
Username: birdparts

Post Number: 150
Registered: 04-2006
Posted on Friday, July 23, 2010 - 05:53 pm:   Edit Post Delete Post Print Post

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.
Top of pagePrevious messageNext messageBottom of page Link to this message

Thomas Sestak (birdparts)
Member
Username: birdparts

Post Number: 151
Registered: 04-2006
Posted on Friday, July 23, 2010 - 06:35 pm:   Edit Post Delete Post Print Post

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,
Top of pagePrevious messageNext messageBottom of page Link to this message

Ruben Vontalge (ruben12375)
Senior Member
Username: ruben12375

Post Number: 3204
Registered: 06-2005


Posted on Friday, July 23, 2010 - 06:43 pm:   Edit Post Delete Post Print Post

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"
Top of pagePrevious messageNext messageBottom of page Link to this message

Thomas Sestak (birdparts)
Member
Username: birdparts

Post Number: 152
Registered: 04-2006
Posted on Friday, July 23, 2010 - 06:46 pm:   Edit Post Delete Post Print Post

OK, what about 30 seconds per change in .019? Is that acceptable in 2010?
Top of pagePrevious messageNext messageBottom of page Link to this message

Thomas Sestak (birdparts)
Member
Username: birdparts

Post Number: 153
Registered: 04-2006
Posted on Friday, July 23, 2010 - 06:54 pm:   Edit Post Delete Post Print Post

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??!!!!!
Top of pagePrevious messageNext messageBottom of page Link to this message

sidney benchetrit (sabbashop)
Member
Username: sabbashop

Post Number: 206
Registered: 05-2006
Posted on Friday, July 23, 2010 - 07:00 pm:   Edit Post Delete Post Print Post

That happened to me. When I checked the ones that had errors, many of them (but not all) were outdated categories
Thanks,

Sid
Top of pagePrevious messageNext messageBottom of page Link to this message

Thomas Sestak (birdparts)
Member
Username: birdparts

Post Number: 154
Registered: 04-2006
Posted on Friday, July 23, 2010 - 07:07 pm:   Edit Post Delete Post Print Post

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)
Top of pagePrevious messageNext messageBottom of page Link to this message

Jonathan Levie (jonlevie)
Moderator
Username: jonlevie

Post Number: 1185
Registered: 02-2005


Posted on Friday, July 23, 2010 - 08:39 pm:   Edit Post Delete Post Print Post

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"




Top of pagePrevious messageNext messageBottom of page Link to this message

T. L. (tl408)
Junior Member
Username: tl408

Post Number: 28
Registered: 05-2008
Posted on Monday, July 26, 2010 - 11:30 am:   Edit Post Delete Post Print Post

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.
Top of pagePrevious messageNext messageBottom of page Link to this message

Thomas Sestak (birdparts)
Member
Username: birdparts

Post Number: 155
Registered: 04-2006
Posted on Monday, July 26, 2010 - 09:43 pm:   Edit Post Delete Post Print Post

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.
Top of pagePrevious messageNext messageBottom of page Link to this message

Zoulfia Moret (zmoret)
Moderator
Username: zmoret

Post Number: 779
Registered: 12-2008


Posted on Thursday, July 29, 2010 - 06:22 pm:   Edit Post Delete Post Print Post

Try reducing the number of listings to 300 or so and go up from there.
_____
Zoulfia Moret
eBay Blackthorne software
Top of pagePrevious messageNext messageBottom of page Link to this message

T. L. (tl408)
Junior Member
Username: tl408

Post Number: 29
Registered: 05-2008
Posted on Tuesday, August 03, 2010 - 02:46 am:   Edit Post Delete Post Print Post

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.
Top of pagePrevious messageNext messageBottom of page Link to this message

Jonathan Levie (jonlevie)
Moderator
Username: jonlevie

Post Number: 1211
Registered: 02-2005


Posted on Tuesday, August 03, 2010 - 03:33 pm:   Edit Post Delete Post Print Post

Hello Tuan,

I am downloading the database and will get back to you soon.
Regards,

Jonathan
eBay Blackthorne Technical Support

"Just walk away"




Top of pagePrevious messageNext messageBottom of page Link to this message

Harvey (hei83)
New member
Username: hei83

Post Number: 3
Registered: 04-2010
Posted on Thursday, August 05, 2010 - 07:30 pm:   Edit Post Delete Post Print Post

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

Add Your Message Here
Post:
Bold text Italics Underline Create a hyperlink Insert a clipart image

Username: Posting Information:
This is a private posting area. Only registered users and moderators may post messages here.
Password:
Options: Enable HTML code in message
Automatically activate URLs in message
Action:

Administration Administration Log Out Log Out   Previous Page Previous Page Next Page Next Page