Does anybody have any experience of using tfgld4210m000 in c3 to purge integration transactions.

I am attempting to remove Integration Transactions from our history companies for 1999 which have been transferred from our live company to our history companies using the session tfgld4210m000 with the copy to history option.

The session returns "No data found" despite their being numerous records which I believe the session should be purging.

Attached is a word document showing the options I am using and an example of a record which is not being removed.

I can confirm that the Purchase Order does not exist in tdpur040.

Any assistance would be appreciated.

Regards
Neal Matthews
Intier Automotive - Project Leader

Hi Neal,

The records will not be deleted in the following cases :

- tfgld410.sint has a value <> tfgld.sint.posted (now changed to check tfgld418.sint instead)
- tfgld410.cprj has a value <> ""
- Purchase orders exist in Purchase Order table tdpur040
- Sales orders exist in Sales Order table tdsls040
- Production orders exists in Production Order table tisfc001
- Replenishment orders exists in Replinishment Order table tdrpl105

What version of Baan are you doing this on?

Hello,

I'm running this on Baan IV c3 and I believe that all the conditions are being met.

PO does not exist in tdpur040, the project is blank and tfgld418.sint = posted.

Any other ideas ?

Thanks
Neal Matthews
Intier Automotive - Project Leader

I've now received a solution from support regarding this issue.

Despite loading the debug object for this session the support analyst still cannot see why the records in question are not being deleted. Although as the session successfully removes records for company 001 and not 002 we suspect that the problem may be related to the multicompany structure.

Anyway the final solution I've been given is to manually delete the records from tables tfgld410 and tfgld417 using GTM and use sql to produce a report of records deleted. My only concern regarding this solution is the fact that all the checks that tfgld4210m000 will not be run.

Has anybody else had to archive by actually deleting the records using GTM and are there any risks to referentail integrity by removing the integration transactions in this manner.

Regards
Neal Matthews
Intier Automotive - Project Leader

There are many patches for this session.

E.g.
This is from sp8 for c4:

Solution: 106054
SITUATION IDENTIFIED IN:
"Archive and Purge Integration Transactions" (tfgld4210m000)

SITUATION DESCRIPTION:
In session tfgld4210m000, 'Archive and Purge Integration Transactions', the company number on the session header displays
as the archive company number. As a result, when archiving data, errormessage "No data within selection." appears.

SOLUTION DESCRIPTION:
In session tfgld4210m000, 'Archive and Purge Integration Transactions', the company number on the session header
displays as the current company number.


In your case on session header company is 101, history company - 102, original company from 002 to 002. In which company the session was started? Also in gld410 - company origin is 002 and financial company is 002. Are you using multi finance/multi logistic configuration? Check logical tables in Database management.

Hello,

We do already have the latest version of this object.

I am running the session from company 101 which does have its tfgld410-418 shared with companies 102 etc. This is a multi / multi setup which is mirrored from our live companies 001 and 002.

I have moved the records in question from 002 (table tfgld410001) to 101 (tfgld410101) and I know that the records for 002 do exist in this table.

However according to support the session doesn't want to see these records in the table.

Cheers
Neal Matthews
Intier Automotive

Hello,

I have the same situation (3 multi/multi companies). May be there is something wrong in gld00x tables in history companies or in shared tables. If you want e-mail me.

Hello,

Have you successfully ran this session in your setup from the archive companies to purge transactions.

If so I would certainly like to look at your logical table setup in your archive companies. Any chance you could mail this to me.

Regards
Neal Matthews
Intier Automotive
neal.matthews@intier.com

I'm now looking at the Print Integration Transactions session tfgld4410m000 in order to report on the transactions I may have to remove via GTM.

Intriguingly enough when running this session in 101 it also cannot find the integration transactions for 002 but when running in 102 does find the records in tfgld410101.

Unfortunately the archiving session tfgld4210m000 will not run in 102 as I get the error message tfglds0414 Invalid History Company. So the problem must be somewhere in my company setup.

Neal

This problem has now been solved thanks to Ivan.

When trying to print integration transactions from company 101 I noticed the same problem whereby the print would not pick up company 002 transactions. However when I ran the report from company 102 the transactions were printed.

Therefore the answer is to run the session from 102 but when I tried to do this previously I received the error message "Invalid history company". At Ivan's suggestion I changed the history company to 000 in the company parameters the error message was cleared and the session ran OK purging the integration transactions.

Thanks to everyone
Neal Matthews
Intier Automotive