Data Truncated Error

[Mox]

Hi, I've had a look through the archives and couldn't find this exact problem, although I see there are alot of threads with this type of error.

I was doing a back order request on one of my orders when it gave me a "Data Truncated" error.

I restarted Actinic and all seems fine apart from this one order, which if I try to access I get " Data Truncated" initially, and then:

There was a problem with the database

Operation: Moving through the [Order] table where [Order Sequence Number] = 342 OR [nParentSequenceNumber] = 342 sorted by [Order Sequence Number]

Data truncated

This order sequence number referenced is the order in question that I was trying to back order on.

I literally today downloaded the trial version of Mole End's one-stop plug in. When I view this particular order via the plugin I can view it fine, so I figure there can't be that much wrong with the database.

Rollback isn't an option as we would lose too many orders that way and I need to keep them in the database.

Anyone have any ideas?

What I was wondering was, if I could try to delete this one order within Actinic and then copy the entry back in from the Order table, although without a schema I wasn't sure if any of the order detail was stored in any other tables?

Many thanks in advance
Michelle

[Jan]

Have you compacted your database (housekeeping menu option), that would usually sort out this sort of thing.

Regards,

[Mox]

Hi Jan, thanks for your reply.

Unfortunately, yes I had read that on an old thread, so I compacted both the catalog and the shipping databases. No luck tho - same errors.

Many thanks
Michelle

[Mox]

Actually, I was just wondering .... since new order loss and some order processing is my only concern since my last backup (no other changes have been made) - what is the viability (on v6) of rolling back to the last backup and then doing File - Import and importing the missing orders from the current database that will be discarded?

Is something like that at all possible?!!

[pinbrook]

importing orders is a feature new to V8.

Have you tried a DB repair in Access?

otherwise i'd be inclined to ask Actinicto look at it, as they seem to be quite good at DB repair

[Mox]

Hi Jo, many thanks for the reply.

Unfortunately, no DB repair didn't find anything, and I don't have Actinic Support.

Do you know what tables are used for an order? Is it just the order table or are there others?

I'm thinking to go into a previous backup mdb and copy over the offending order number or am I oversimplifying here?!

Michelle

[Jan]

Order details are stored in lots of tables, I wouldn't recommend trying to copy the details over - what I would suggest you do is delete the order (this might fail as well in which case that you will have to ask Actinic for help) then recreate it manually - using offline ordering, then edit the order table in access to change the order number to the one generated before (this is a fairly safe thing to do because it's a text field only and isn't used to index any other tables.

As always backup the database first and do this at your own risk.

Regards,

[Mox]

Hi Jan, thanks for your reply - unfortunately, it won't let me delete the order within Actinic - that gives me the same error

Many thanks
Michelle

[Mox]

Well, I fixed it!

I went through every table to check for any relationship to the order sequence key and could only see a relationship between the Order and Order Detail tables, so I basically overwrote the order in just those 2 tables with the entry from my back up and it all worked ... phew!

However, I still can't back order that one particular order, so there's obviously something a bit iffy about it which I still need to fathom

Many thanks Jan & Jo for your advice.

Michelle