Upload Freezes

[PC Int]

I've been running two sites on Actinic Business MultiSite 8.5.1 HIZA on a well-specified Vista Home Premium machine (with UAC turned off) for over 3 months with no problems (worth mentioning ... ).

But now - for one of the sites - the site upload fails at 'Checking Search Indices' stage with 'check product index' showing (it runs through the 'Checking HTML files' and 'Checking Catalog stages' without a hitch).

For information, there is no problem uploading to the other site in Actinic.

I've done an Actinic Compact Database (Catalog and Shipping) but without any change.

As mentioned in these forums, I deleted all CAT and FIL files from both the server (acatalog folder) and from the PC's local site folder but same error appears. Have also tried Web > Generate Website but still fails at same point.

I have since re-instated all the FIL and CAT files back onto the server and web site works after a fashion. (To get back a working website I recreated the missing OldText.Fil and OldProducts.Fil files I'd deleted by copying and renaming PrevText.Fil and PrevProducts.Fil onto the server. This at least allows the existing site to function again, though the cart is slow.)

However I can't update the website at all as the upload problem has got worse.

When I try to upload now (or do a Site Refresh or a Generate Files), all that happens is that the egg timer appears but nothing else happens (no progress window) and Task Manager reports 0% CPU time against the Catalogue.exe process and there is no disk activity. I've kept the egg-timer running for several hours, but nothing doing. (No probs uploading to the other site on Actinic.)

Any ideas how to resolve this problem? It looked like a 'straightforward' corrupt search index problem, but deleting all the FIL and CAT files didn't help. Maybe a corrupt MDB file, in which case <scream> ... ?

Paul Tanner

[pinbrook]

Maybe a corrupt MDB file, i

if you think this is the problem, the only thing i can see that you haven't tried is a repair database from within Access (take backups first)

if you don't have Access, one of Jan's tools from Mole-end has a repair feature, you can downoad the 30 day trial (search the forum for Access to see if you can find a post that mentions it - or wait for jan - if she sees this thread)

[PC Int]

Thanks Jo, tried the DB compact/repair within Access 2000 but no luck.

I also tried running Actinic with 2 week old version of the Site1 directory but still has same problem - egg timer but no action when try to do Upload or Refresh. Will roll back further to beginning of January.

Have also tried GG's (Actinic) suggestion of hierarchical export of site followed by re-import, which resequences the database. On importing, actinic reported an unexpected error followed by 'import abnormally terminated'. It did give a line number so maybe this will help identify problem.

Also, I don't know if this is relevant, and I've never noticed it before, but in the acatalog folder on server I'm getting several session files each minute, 24/7. The site is big but I'm surprised it's getting that many visitors ;-) Usually there's a gap of at least a few minutes between session files.

Will roll back a month and pray... somehow I don't relish rebuilding site from scratch (even using our Access inventory databases) with 30,000 products!

[PC Int]

Upload Progress window disappeared

8.5.1 HIZA (Multi-Site) on Vista Home Premium

have spent most of Saturday rolling back the 'dodgy' site first by 2 weeks then back to early December.

Site Upload / Site Refresh / Download Orders still just bring up the egg timer and nothing else (no progress window, CPU or disk activity). As before, all the other sites in Actinic continue to upload/download as normal.

Same result after uninstalling and re-installing Actinic 8.5.1 HIZA. Even tried the dreaded upgrade to 8.5.2, but Upload/Refresh/Order Download still just hang without any progress window. Actinic works fine for all other operations (design, adding/changing/removing products) !

Following on from the growing list of similar v8 reports on the forums (Jeff on 28 Jan, Dagmar on 5 Jan, back to Lee in Oct 06) I have tried messing with network settings with curious results:

- If I import the network settings from the 'dodgy' site to the Actinic default site or other sites, these Sites upload fine;
- if I import network settings from another site, the 'dodgy' site uploads fine;
- if I overtype all the network settings, makes no difference;
- if I use the network Wizard to re-input the network settings, it fails at the final stage with "An error occurred while sending an HTTP request to the server..." despite the fact that the Wizard has already tested and passed this and the same settings work on other sites.

Any ideas? I'm bracing myself to rebuild the website from scratch (30k products, 1000 sections, though product data is in databases but there's the customisation, layout editing, etc, ... <shudder> ....

deperate dan (if my name was Dan)

Paul T.

[jont]

Have you tried licensing a new site .. input the network settings and test.... then hierarchal import into that from the "dodgy" site?

[PC Int]

Woohoo! Tried as Jont suggested and it works .... with caveat that only the first 5 top level sections (plus subsections and products therein) were imported, followed by loads of 'missing image' errors in import log. But no problem uploading/downloading these with the imported "dodgy" network settings.

I store my product images in separate folders outside of the Actinic folder on the PC (I know, this is heresy, but there are good reasons for this).

From the Import error log, it appears that the hierarchical import rejects any sections/products with image files in the section as it thinks they are missing. However, the sections & products it has imported do all contain images! This may be a red herring as my original problem was a problem with search/product indices and this behaviour may be a product of that.

Enough already - getting late so I'll stop now!

[PC Int]

Quick update on above - I had two probs:

First was the Disappearing Progress Window when doing a Site Upload, Site Refresh or even Order Download. After many trials (see above), the solution was to change Script ID. Why this works currently remains a mystery, and why it happens, likewise.

Second was upload kept failing at Checking Search Indices stage. Many thanks to GG at Actinic who spotted that my SimpleShipping.mdb file was in the wrong file format (probably Access 2007, instead of Access 2000). How this happened is a mystery (honest!), but my newish PC did have one of those 30-use trials for MS Office 2007, and somehow it got at the Shipping DB (how ActinicCatalog.mdb escaped who knows). Needless to say, the Office 2007 trial has been binned from this machine.