Hi all,

We are trying to do archiving. I follow the steps given in the document from infor BaaN documentation, but when i run any of the sessions for archiving i get an error 606.

The event viewer says is between tccom010 y tcmcs010, apparently the session is trying to insert a Blank inthe country code in tccom010. But in the origin company there is no blank in that field...

ideas? suggestions?

Have you established company parameters in your achieve company?

Have you established company parameters in your achieve company?

Hi David,

If you mean with the session tfgld0103m000 (Mantain Company Parameters), the documentation says i have to clear all fields for FORMS 2 and 3... then initialize parameters with tcmcs0295m000

Hi,

Could you brief us about what data you are archiving? Any Sales Orders/Purchase Orders/Prod Orders?
OR
Are you setting up Archive company?

Before starting the process, you have to set up parameter tables in archive company, other wise 606 (Reference) errors are bound to appear...

Before an initial archive (after company setup), I set up and review the codes/parameters tables (tcmcs) in the archive companies based on the source company. You can use bdbpre/bdbpost to do so. Also ensure that your table sharing between the source and archive company (or companies) structure is identical. Failure to do so may cause some reference errors. Doesn't hurt to set up calendars and financial company info as well.

Hi,

Could you brief us about what data you are archiving? Any Sales Orders/Purchase Orders/Prod Orders?
OR
Are you setting up Archive company?

Before starting the process, you have to set up parameter tables in archive company, other wise 606 (Reference) errors are bound to appear...

I'm setting up an archive company. i follow the steps in the attached manual (when copy data from the tables specified in page 2-16 i had to include tcmcr000 and tcmcr001 because i was getting an error when initializing parameters)

You need to load master tables first and then, their child tables.

e.g. in your case, tcmcs010 is master and tccom010 is its child. A child table can have more than 1 master tables and you need to load all of them. You can find parent tables by refering the Data Dictionary...In your case other master tables are "Titles tcmcs019", "Languages tcmcs046", etc....

Regards,
Kaustubh

You need to load master tables first and then, their child tables.

e.g. in your case, tcmcs010 is master and tccom010 is its child. A child table can have more than 1 master tables and you need to load all of them. You can find parent tables by refering the Data Dictionary...In your case other master tables are "Titles tcmcs019", "Languages tcmcs046", etc....

Regards,
Kaustubh

what i'm doing is to run the session tcmcs4200m000 "Archive general data"... while processing it gives me an error message "reference does not exist", the event viewer shows me that the value it can't find is a ¿blank space? (see attached images)

when i compare the values of the tccom010.ccty (real company) with the values in tcmcs010.ccty (archive company) i found that all values that should be copied to tccom010 (archive company) are already in tcmcs010 (archive company).

PS: tables tcmcs019 and tcmcs046 in archive company already have values

create a blank entry in table "tcmcs010" of archive company.
after this, run the archive session.

this might resolve the current error...

(i think the problem is due to a blank "Country" field present in "Customer Master" of your Production company for one/more of the customers)

do rever back with your results...

do rever back with your results...

just for the record...

we need to include the table tdcms018 to those that are copied from the real company (we already had added tcmcr000 and tcmcr001)

we need to include the table tdcms018 to those that are copied from the real company

This table has a "text" field. So, if you want to access text in archive company, text tables will also have to archived.

Our company provides an archiving tool for Baan if you are interested.
ken.chance@businessdecision.com