Baanboard.com

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

User login

Frontpage Sponsor

Main

Google search


Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
33%
Installation Wizard into new VRC
39%
Manual into existing VRC
6%
Manual into new VRC
22%
Total votes: 49

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 26th August 2011, 16:38
macahu's Avatar
macahu macahu is offline
Member
 
Join Date: Feb 2002
Location: France
Posts: 49
macahu is on a distinguished road
Baan: Baan IV C4 - DB: Oracle 10g (R1) - OS: W3k
Question Trouble in archiving statistics
Baan: Other/Unknown

H team,

I faced trouble in archiving sales (tssst0202m000) and purchase (tspst0202m000) statistics. At the end of the process tables tdsst020, tdsst025 and tdsst030 (tdpst020,tdpst025,tdpst030) should be deleted but the data are still in the live company.

What is missing. I use the script B40U C4 stnd of 16/03/2003.

Thanks for your help
Reply With Quote
Sponsored Links
  #2  
Old 27th August 2011, 15:56
macahu's Avatar
macahu macahu is offline
Member
 
Join Date: Feb 2002
Location: France
Posts: 49
macahu is on a distinguished road
Baan: Baan IV C4 - DB: Oracle 10g (R1) - OS: W3k
Sorry guys,

I just check again the tables and I found that only tdsst030 and tdpst030 which are not deleted.

I don't know what's going wrong !!!

thanks for your help
Reply With Quote
  #3  
Old 31st August 2011, 04:18
BaanInOhio BaanInOhio is offline
Senior Member
 
Join Date: Oct 2005
Location: Northeast Ohio
Posts: 182
BaanInOhio is on a distinguished road
Baan: Baan 4c4, 5C, LN - DB: Informix, Oracle, SQL - OS: HP UX, Win2K
The pst/sst010, pst/sst015, and pst/sst018 tables contain master data so are always archived and deleted. The pst/sst020, pst/sst025, and pst/sst028 tables are built using a sort key (pst/sst030) so are worthless when archived. Therefore, the standard sessions do not handle these tables. If you need to have active statistics in the archive company, you must rebuild them from the archived master data into compression (by sort key) tables.

Records in pst/sst020, pst/sst025, pst/sst028 resulting from archived master data tables are removed when "clear data for all companies" is set to "yes" in the "Update Sales Statistics" or "Update Purchase Statistics" sessions. The sort key (pst/sst030) tables are cleared as well.
Reply With Quote
  #4  
Old 13th September 2011, 10:27
macahu's Avatar
macahu macahu is offline
Member
 
Join Date: Feb 2002
Location: France
Posts: 49
macahu is on a distinguished road
Baan: Baan IV C4 - DB: Oracle 10g (R1) - OS: W3k
Thanks BaanInOhio for this replay,

I did the full update of statistics (tdsst0201m000 and tdpst0201m000) and it didn't work for tdsst030 and tdpst030. (The full update in our case takes 2 weeks: it's horrible).

Are these tables important ?

In your comment BaanInOhio, what do you mean by "clear data for all companies" is set to "yes"? which program do ypu speak about because in tdsst0201m000 I have not this parameter !!!

Best regards
Reply With Quote
  #5  
Old 20th September 2011, 20:21
macahu's Avatar
macahu macahu is offline
Member
 
Join Date: Feb 2002
Location: France
Posts: 49
macahu is on a distinguished road
Baan: Baan IV C4 - DB: Oracle 10g (R1) - OS: W3k
Hi gys

any replay ?

Thanks in advance for your help
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 Questions dmanick Archiving & Multisite 2 16th June 2010 17:30
Archiving for Baan spar1964 Third Party Products 0 15th May 2008 21:22
Archiving PCS Projects (tipcs2260m000) r_nagu Archiving & Multisite 4 10th August 2004 20:33
Error Msg "Purchase statistics not updated yet" while archiving Projects alisba Archiving & Multisite 1 26th February 2003 15:19
analyzing tables naabi0 Operating Systems & Databases 1 6th October 2001 01:26


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


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