Cant Open New Order

[murf]

We have just downloaded a new order but cannot open it. Having looked at it in the access db, the order details appear ok.

Actinic then has to close as it reports an internal error.

ANy ideas ?

[Darren]

Hello Mike.

Is it only the one order that is affected? Can you open any other new orders?

[murf]

darren

i have found one more that we cant open

all others are fine

murf

[Darren]

Were these two orders created around the same time? Also, have you ever opened them before, and if you get an error message when Actinic closes, please post it here.

[murf]

these orders were created at almost the same time......

the error says that acatalog needs to close as it encountered an internal problem

we have deleted the orders now, so this is sorted now, until next time (if!) of course

Mike

[Darren]

Thanks for letting me know.

One suggestion just in case your database has become corrupted somehow. Go to Housekeeping | Compact databases and select both of them. Always a good idea to do a snapshot first though.

Thanks

[danielle]

hi there,

we had the same problem, Actinic quitting when attempting to view a new order.

You need to lay your hands on a copy of Access 2000, and amend the databases slightly.

Contact me on coleman@ukf.net for more info.

[murf]

ok.......contact u seperately.

are actinic ok with the db changes ?.........or do they know about it ??

[danielle]

Hi Murf

Yes, actinic were the ones who told me how to rectify the situation.

heres how you do it.....

You will need to edit the database so you need to have a copy of MS Access 2000. We also need to convert your databases to ensure that they works correctly. Follow the steps below:

1. Open MS Access 2000

2. Click on the 'Tools' menu and 'Convert Database' and 'To Current Access Database Version'.

3. Find the following file - 'c:\program files\actinic ecommerce v6\sites\site1\ActinicCatalog.mdb'. Highlight the file and click on the 'Convert' button.

4. You will have to save the database under a different name so accept the default of 'db1.mdb' and click on the 'Save' button.

5. Follow points 2 - 4 again but this time with the file 'c:\program files\actinic ecommerce v6\sites\site1\ShipControl\SimpleShipping.mdb'

6. Open (in MS Access) 'c:\program files\actinic ecommerce v6\sites\site1\ShipControl\db1.mdb'

7. Open the 'Bands' table.

8. For Record 1 (159 in BandID column), change the 'ClassID' from 1 to 'UK Mainland Courier' (there should be a drop-down box to choose this option from).

9. Close the table and the database (it will automatically save the changes).

10. Open Windows Explorer and go to the 'c:\program files\actinic ecommerce v6\sites\site1' directory.

11. Find the file - 'ActinicCatalog.mdb' and rename it to 'OldActinicCatalog.mdb'.

12. Find the file - 'db1.mdb' and rename it to 'ActinicCatalog.mdb'

13. Still in Windows Explorer, go to 'c:\program files\actinic ecommerce v6\sites\site1\ShipControl' directory.

14. Find the file 'SimpleShipping.mdb' and rename it to 'OldSimpleShipping.mdb'.

15. Find the 'db1.mdb' file and rename it to 'SimpleShipping.mdb.

You should now be able to open Actinic and open the orders that you were having problems with.

(Replace all instances of 'site1' to the name of the site if you have changed it.)

If any of this is unclear, please email me at coleman@ukf.net.

This worked for us, however I cant guarantee it will work for you, its just that the "symptoms" are the same as ours. :)

[murf]

Hi danielle

This does not cure the problem....we now have more dodgy order we cant open. !!!!!!!!

Regards

Mike

[Jan]

I can take a look at it if you like.

Regards

[murf]

Hi Jan

Lifesaver !..............i'll email you

thanx

mike

[Jan]

Hello Mike,

The first thing that I noticed was that the database is a windows 2002 database and I am wondering whether this would matter at all. How did it get to be a 2002 database by the way?

I am wondering whether your shipping database and your main database are of different versions?

I would suggest making your catalog and shipping databases access 2000 databases - there is a 'save as prior version' feature available in access to do this.

If that doesn't work send the shipping database over and I will continue looking. My gut feeling is that you have something unusal set up for shipping and that is causing the problem.

Actinic: Does business work with access 2002 databases?

Regards

[murf]

Hi Jan

We carried out the details as per danielle, so this converted to the latest access database.

I'll send you the shipping db asap.

All seems to work fine with Access 2002.

Regards

Mike

[Jan]

Sorry Mike, I did read through that post but read what I expected to see rather than what it actually said.

[Jan]

Your shipping opaque data appears to be incorrect. This is generated by catalog based on your shipping settings and the order location. Your dodgy orders have opaque shipping data along these lines :-

ShippingClass;21;ShippingZone;61;BasisTotal;1.000000;Simple;1084;NoRecalculation;

I think that the value after ShippingZone should map to a zone in the zones table on the shipping database but you haven't got a zone 61. If you change the value from 61 to 13 (which is correct for this particular order because it is from Florida) you will be able to access your order again.

I couldn't see why the incorrect data was being generated - I think that you need to talk to Dr. Actinic to get it properly diagnosed. IMHO this might be an upgrade issue, there are V5 orders on the database with this shipping zone as well so either the zone used to exist OR the V5 shipping OCX didn't mind invalid zones - interestingly the zone is set to -1 before the crash occurs so maybe this is a subscript out of range type thingy.

Regards,