Hi,

We are having problem with the archiving session (tfgld6205m000). Since this session deletes table106, is it possible to delete tfgld106 manually? what will be the effect if we manually delete the this table, instead of running tfgld6205m000. We will just backup the table in the tape, instead of copying this to archiving company.

Thanks.

emma2001

Hi,

I've never used this session myself but can I suggest that before you go down the route of deleting directly from the table that you post some more detail about the exact problem you are having. It is possible that somebody on the board maybe able to solve the problem you are having with the archiving session.

Regards
Neal Matthews
Intier Automotive

Hi,

When running the archiving session, we encounter error 1458 and the session gets hang, archiving is not succesful.

Thanks.

emma2001

1458 is a database error and I'm not quite sure what database you're running on but we're on informix and this sort of error is generally caused by a lack of logical log space see text below.

"finderr 458
-458 Long transaction aborted.

The database server ran out of log space in which to record this
transaction. A transaction that is not fully recorded cannot be rolled
back. To preserve database integrity, the operating system ended the
transaction and rolled it back automatically. All changes made since
the start of the transaction have been removed. Terminate the
application, and replan it so that it modifies fewer rows per
transaction. Alternatively, contact the database server administrator
to discuss increasing the number or the size of the logical logs. Be
prepared to talk about the number of rows being updated or inserted and
the size of each row".

Hope this helps.

Regards
Neal Matthews
Intier Automotive

Hi,

When running the archiving session, we encounter error 1458 and the session gets hang, archiving is not succesful.

Thanks.

emma2001

Hi,

We have already done this, and the error still persists, that's why we would like to do it manually, by deleting tfgld106 and other tables related to archiving session. Is this possible?

Thanks.

emma2001

Personally I would only do this if Baan support said it was OK to do so and I couldn't do it through the session.

I have heard of people manually deleting tfgld410 but not tfgld106. You really need to find out what other tables may be effected before proceeding.

Sorry I can't be of more help.

Regards
Neal Matthews
Intier Automotive

I'd also be very sure there was no other way before deleting tfgld106 manually. The archiving session must do quite a few checks before it actually deletes each record. I'm not sure how you would be able to do this manually.

Sounds to me like you need some more table space.
The archiving sessions either work, dont work or report an error.

If you really want to delete transactions in tfgld106 it can be done quite easially by deleting a selected range of transactions

You should also change the status for each record tfgld018 Documents table to Deleted.

If your data is for closed financial years eg 1999 you should not have any problems after doing this as long as all invoices have been paid. You will loose data integrity between tfgld 410 and tfgld106.

You must run Rebuild History after you have done it

I have deleted records in 106 before where archiving does not work

Sounds to me like you need some more table space.
The archiving sessions either work, dont work or report an error.

If you really want to delete transactions in tfgld106 it can be done quite easially by deleting a selected range of transactions

You should also change the status for each record tfgld018 Documents table to Deleted.

If your data is for closed financial years eg 1999 you should not have any problems after doing this as long as all invoices have been paid. You will loose data integrity between tfgld 410 and tfgld106.

What you can do is copy tfgld106 & tfgld 018 from the live company to the archiving company before deleting in the live company