Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > Archiving & Multisite

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
18%
200 - 500 GB
26%
500 - 800 GB
3%
800 - 1200 GB
9%
1200 - 1500 GB
12%
1500 - 2000 GB
12%
> 2000 GB
21%
Total votes: 34

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 7th February 2002, 11:08
emma2001 emma2001 is offline
Junior Member
 
Join Date: Feb 2002
Location: philippines
Posts: 9
emma2001 is on a distinguished road
archiving

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
Reply With Quote
  #2  
Old 7th February 2002, 12:31
Neal Matthews's Avatar
Neal Matthews Neal Matthews is offline
Guru
 
Join Date: Sep 2001
Location: Nottingham
Posts: 483
Neal Matthews is on a distinguished road
Baan: Baan IVc4 ags0 - DB: Informix 9.40 UC4 - OS: Sun Solaris 9
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
Reply With Quote
  #3  
Old 7th February 2002, 12:38
emma2001 emma2001 is offline
Junior Member
 
Join Date: Feb 2002
Location: philippines
Posts: 9
emma2001 is on a distinguished road
Hi,

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

Thanks.

emma2001
Reply With Quote
  #4  
Old 7th February 2002, 12:52
Neal Matthews's Avatar
Neal Matthews Neal Matthews is offline
Guru
 
Join Date: Sep 2001
Location: Nottingham
Posts: 483
Neal Matthews is on a distinguished road
Baan: Baan IVc4 ags0 - DB: Informix 9.40 UC4 - OS: Sun Solaris 9
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
Reply With Quote
Sponsored Links
  #5  
Old 7th February 2002, 14:56
emma2001 emma2001 is offline
Junior Member
 
Join Date: Feb 2002
Location: philippines
Posts: 9
emma2001 is on a distinguished road
Hi,

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

Thanks.

emma2001
Reply With Quote
  #6  
Old 7th February 2002, 15:03
emma2001 emma2001 is offline
Junior Member
 
Join Date: Feb 2002
Location: philippines
Posts: 9
emma2001 is on a distinguished road
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
Reply With Quote
  #7  
Old 7th February 2002, 15:21
Neal Matthews's Avatar
Neal Matthews Neal Matthews is offline
Guru
 
Join Date: Sep 2001
Location: Nottingham
Posts: 483
Neal Matthews is on a distinguished road
Baan: Baan IVc4 ags0 - DB: Informix 9.40 UC4 - OS: Sun Solaris 9
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
Reply With Quote
  #8  
Old 7th February 2002, 16:17
MariaC's Avatar
MariaC MariaC is offline
Guru
 
Join Date: Sep 2001
Location: South Africa
Posts: 386
MariaC is on a distinguished road
Baan: BaanIV, BaanV, BaanERPLN - DB: SQL, Oracle - OS: Unix, Windows
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.
__________________
Regards
Maria

Last edited by MariaC : 7th February 2002 at 16:19.
Reply With Quote
  #9  
Old 13th February 2002, 14:15
mattcull's Avatar
mattcull mattcull is offline
Junior Member
 
Join Date: Jan 2002
Location: London, UK
Posts: 19
mattcull is on a distinguished road
Deleting tfgld106

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
__________________
Matt Cull
Reply With Quote
  #10  
Old 13th February 2002, 14:18
mattcull's Avatar
mattcull mattcull is offline
Junior Member
 
Join Date: Jan 2002
Location: London, UK
Posts: 19
mattcull is on a distinguished road
Lightbulb Deleting tfgld106

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
__________________
Matt Cull
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Archiving of Text in Baan IVb kclewley Archiving & Multisite 1 8th November 2002 16:52
PST needs archiving? hope not... karlovac Distribution, Transportation & Warehousing 6 15th October 2002 07:32
Archiving in BaaN ERP Atul Khungar Archiving & Multisite 2 6th May 2002 01:43
Archiving Baan 5.0b Francesco Tools Administration & Installation 0 1st September 2001 00:43


All times are GMT +2. The time now is 04:04.


©2001-2018 - Baanboard.com - Baanforums.com