Home

Research and Development BAAN IV Conversion TRITON 3 to

1. Error Enter parameters in tcmcs000 Message 36 physical quantity lt description gt has duplicates conversion factor 1 0 Error message will be logged when duplicate units with conversion factor 1 0 and same physical quantity are found in tcmcs001 The program will abort Fatal error Enter units for all physical quantities to tcmcs001 Message 37 No units present Error message will be logged when duplicate units with conversion factor 1 0 and same physical quantity are found in tcmcs001 The program will abort Fatal error Enter units for all physical quantities to tcemcs001 Message 38 base unit physical quantity lt description gt not known conversion factor 1 0 Error message will be logged when no unit is found with a certain physical quantity and conversion factor 1 0 The program will abort Fatal error Enter unit for that physical quantity to temcs001 Conversion TRITON 3 to BAAN IV 7 26 BAAN E Type of message Possible actions Type of message Possible actions Type of message Possible actions Type of message Possible actions 7 10 39 7 10 40 7 10 41 7 11 7 11 1 7 Appendix B Troubleshooting Message 39 domain domain name has enumerated values This error will be logged when a certain domain has not enumerated values The program will abort Fatal error Ask for support from software vendor or enter enumerated va
2. Error message will be logged when Base Area Unit is not filled in tcemcs000 The program will abort Fatal error Enter Area Unit in temcs000 and run program again Conversion TRITON 3 to BAAN IV BddN dc 7 Appendix B Troubleshooting m Type of message Possible actions Type of message Possible actions Type of message Possible actions Type of message Possible actions Type of message Possible actions 7 11 11 7 11 12 7 11 13 7 11 14 7 11 15 Message 11 Base Volume Unit not filled Error message will be logged when Base Volume Unit is not filled in temcs000 The program will abort Fatal error Enter Volume Unit in temcs000 and run the program again Message 12 Base Time Unit not filled Error message will be logged when Base Time Unit is not filled in temcs000 The program will abort Fatal error Enter Time Unit in tcmcs000 and run the program again Message 13 parameters MCS not present Error message will be logged when parameters are not present in tcemcs000 Error Enter parameters in tcemcs000 Message 14 physical quantity lt description gt has duplicates conversion factor 1 0 Error message will be logged when duplicate units with conversion factor 1 0 and same physical quantity are found in temcs001 The program will abort Fatal error Remove unused units from tcmcs001 or change conversion factors of duplicate units with same physical
3. The conversion of conversion factors may involve the following conflicting situation In versions 3 1 and lower it was possible to record any conversion factor In BAAN IV however it will not be possible to record a customized item specific conversion factor for conversion between two units except for units with the same physical quantities The session will recognize these conflicting situations and write them to the log file However if a final conversion is performed a different conversion factor will be generated Fill Auxiliary Item Table tiitm100 tecov3004m000 With the introduction of item containers in BAAN IV this session is used to ensure that the number of records in the tiitm100 table is the same as in the tiitm001 table BddN Conversion TRITON 3 to BAAN IV 5 9 5 Correction program and checking the conversion both scenarios 5 2 3 BAAN Finance Change Sign in Open Item Table tfacp200 tccov2001m000 By means of this session the symbol for all currency differences of anticipated payments is modified Note that tfacp200 cdam is multiplied with 1 Change Step for Antic Unalloc Adv Payments tccov2002m000 For anticipated advance unallocated anticipated or standing orders in tfacp200 the field tfacp200 step will be filled in as follows depending on the payment method with the first possible option When tfcmg003 rs01 yes then document sent to customer else if tfcmg003 rs02 yes
4. The database tables for TBASE and must be registered in BAAN IV This is done by means of the register6 1 script which must be run under the tables directory This script must be located in the BSE bin directory while its permissions must be set by means of the chmod 755 BSE bin register6 1 command for i in find name bdt print do tbase6 1 R r I Use tbase tp6 1 for TBASE TP database done TRITON 3 0 For TRITON 3 0 an additional step is necessary Make sure all TRITON 3 0 tables are registered correctly at the beginning of this step Set BSE to the TRITON 3 0 environment and make a list of all the existing tables but not the dictionary tables tbase6 0 R d awk print 1 bid grep v dict gt usr tmp conv list tbase6 0 awk print 1 bid grep v dict gt usr tmp regr list Conversion TRITON 3 to BAAN IV 3 10 BAAN 3 4 9 3 4 10 3 4 11 3 4 12 3 4 13 3 Converting to BAAN IV two environments scenario Set BSE to the BAAN IV environment now and convert all tbase tables into the new tbase format tbaseconv6 1 is located in BSE bin of the BAAN IV environment tbaseconv6 1 bsp usr tmp conv list Now register all tbase tables for BAAN IV This is done by means of the register6 1 script which must be run under the tables directory This script must be located in the BSE bin directory while its permissions must be set by means of the chmod 7
5. Year mm Minutes SS Seconds bs Message Message 1 START OF CONVERSION tccov2002m000 by user lt name gt This message informs you about the start date and time of the session by the specified user Information No action required Message 2 tfacp200 lt supplier gt lt transactiontype gt lt document gt lt linenumbers gt lt transactiontype gt lt document gt lt linenumber gt For each filled step in tfacp200 the key information is logged Information No action required Message 3 tfacr200 lt customer gt lt transactiontype gt lt document gt lt linenumber gt lt transactiontype gt lt document gt lt linenumber gt For each filled step in tfacr200 the key information is logged Information No action required Message 4 END OF CONVERSION This message informs you about the end date and time of session Information No action required Conversion TRITON 3 to BAAN IV BAAN e 7 Appendix B Troubleshooting m 7 5 tccov2003m000 Checking standing order tfcmg114 This section lists the messages that can be displayed during the execution of tccov2003m000 The messages are stored in the log file BSE log log cov2003 The messages are stored as follows Type of output Only process information will be logged into this file Full description Start and end of process will be logged Format of output MM DD YY mm ss s MM Month DD Day YY Year
6. mm Minutes SS Seconds bs Message 7 5 1 Message 1 START OF CONVERSION tccov2003m000 by user lt name gt This message informs you about the start date and time of the session by the specified user Type of Information message Possible No action required actions 7 5 2 Message 2 Posting Data lt bank gt lt document gt lt company gt lt transactiontype gt lt document gt lt supplier gt standing order gt lt serial number gt For each changed standing order in tfcmg114 the information is logged Type of Information message Possible No action required actions 7 5 3 END OF CONVERSION This message informs you about the end date and time of session Type of Information message Possible No action required actions Conversion TRITON 3 to BAAN IV BAAN Type of message Possible actions Type of message Possible actions Type of message Possible actions 7 6 7 6 1 7 6 2 7 6 3 7 Appendix B Troubleshooting tccov2004m000 Changing anticipated documents in tfacp200 tfacr200 tfgld102 tfgld106 This section lists the messages that can be displayed during the execution of tccov2004m000 The messages are stored in the log file BSE og log cov2004 The messages are stored as follows Type of output Only process information will be logged into this file Full description Start and end of process will be logged Format of output MM DD
7. 3 Converting to BAAN IV two environments scenario check tables ttaad4232m000 change PC users ttaad2200m000 convert to runt DD ttaad4200m000 leave bshell and start bshell again empty TMP_001 PC ttaad1121m000 delete TMP 001 PC ttaad1120m000 create new tables ttaad4230m000 run parameters tcmcs0295m000 correction program tccov0000m000 Set tbase back to tbase tp if required LEGEND Start test and accep lt gt 3 0 3 1 tance procedures C BAANIV Figure 3 4 of 4 Converting to BAAN IV two environments scenario Conversion TRITON 3 to BAAN IV BddN is 3 Converting to BAAN IV two environments scenario 3 2 3 2 1 General This step is executed from within the data conversion menu of BAAN IV mttcon2130m000 18 2 JN IN NW IP ie te dL os Date 20 05 96 Company 000 Data Conversion 6 1 3 1 BAAN IV Copy Package Combination Copy datadef files from 3 1 to Temporary Package Combination Maintain Companies Assign Tables to Databases Maintain Table Directories BAAN Base TP Maintain Logical Tables Maintain User Data Create Table from Sequential Dump Check Tables Convert 3 1 b tables to BAAN IV Import Users Authorizations Devices etc from 6 1 Choice 11 Import Users Authorizations Devices Currencies Logical Tables ttcon61import At this point the file which was saved in TRITON Tools 6 1 is imported Instead of importing the old definitions it is also
8. 5 Correction program and checking the conversion both scenarios Table Field filed in Item Default Data tiitm002 cuni stgu cuqp cuqs cups cups uset Calculation Parts tipcs002 cuni uset Customized Items tipcs021 cuni stgu uset Equipment tppdm025 cuni uset Subcontracting tppdm035 cuni uset Alternative units by project item tppdm604 cuni Project items Project Equipment tppdm605 cuni cuqp cupp uset tppdm625 uset Project subcontracting tppdm635 cuni cuti uset Unit sets temcs006 will be created and the corresponding unit set in the tables will be filled in Also the table unit by unit set will be filled in temcs012 Conversion Unit Conversion Factors tccov3003m000 Because of the new way in which alternative units are handled the following conversion factors are converted and modified by using this session Tables Units tcemcs001 Item Table tiitm001 Alternative Units tiitm003 Customized Items tipcs021 Table conversion factor tiitm004 will be filled in based on found conversion factors between different units Conversion factor will be stored on different levels General Item Group Item The tables Units Alternative Units and Customized Items must remain unchanged in the BAAN IV version as in 3 1 which has the following two advantages The conversion can be performed after the installation of BAAN IV The conversion can be performed anew
9. and devices is exported by means of the following steps Copy the ocon6lexport program from the BAAN IV environment The ocon6lexport program must be copied from the new BAAN IV BSE tools ttB40_a ottcon environment to the TRITON environment For TRITON 3 1 to the BSE tools tt6 1 ottcon directory and for TRITON 3 0 to the BSE tools tt6 0_ ottcon directory This program is referred to as an object and does not have to be patched For example baan4 bse tools ttB40_a ottcon ocon61 exporte triton31 bse tools tt6 1 a ottcon ocon61 export The permissions and the owner of the ottcon6lexport program must be set to bsp Execute the ottcon61lexport session The ottcon6 lexport session in TRITON 3 is used to export all users authorizations currencies devices and logical databases to an ASCII file This program can be started from the command line of a menu by typing p followed by ottcon6lexport Export Users Data Export Authorizations Export Currencies Export Device Data Export Logical Tables File usr8 bse tmp baaniv Continue Conversion TRITON 3 to BAAN IV BAAN 2 Preparing TRITON for conversion the two environments scenario 2 3 Software export This step only applies to customized software components 2 3 1 Export Data Dictionary ttiex1280m000 This session is used to export the customized VRCs from TRITON 3 to an ASCII file For each VRC a separate export directory must be created tti
10. 7 10 26 Message 26 tppdm605 lt project gt lt itemcode gt lt unit set gt copied from pdm635 7 24 7 10 27 Message 27 tppdm605 lt project gt lt itemcode gt Error unit not in unit set of pdm635 7 24 7 10 28 Message 28 tppdm604 lt project gt lt itemcode gt lt unitset gt copied from tppdm605 7 24 7 10 29 Message 29 tppdm604 project lt itemcode gt lt unitset gt Error unit not in unit set of pdm605 7 25 7 10 30 Message 30 Base Weight Unit not filled 7 25 7 10 31 Message 31 Base Length Unit not filled 7 25 7 10 32 Message 32 Base Area Unit not filled 7 25 7 10 33 Message 33 Base Volume Unit not filled 7 25 7 10 34 Message 34 Base Time Unit not filled 7 26 7 10 35 Message 35 parameters MCS not present 7 26 7 10 36 Message 36 physical quantity lt description gt has duplicates conversion factor 1 0 7 26 7 10 37 Message 37 No units present 7 26 7 10 38 Message 36 base unit physical quantity lt description gt not known conversion factor 1 0 7 26 7 10 39 Message 39 domain lt domain name gt has no enumerated values 7 27 7 10 40 Message 40 Error lt error code gt in qss search lt search mode gt lt search argument gt lt table gt definition lt number gt 7 27 7 10 41 Message 41 Error lt error code gt in qss sort lt table gt definition lt number gt 7 27 tccov3003m000 Conversion Unit Conversion Factors 7 27 7 11 1 Message 1 START OF CONVERSION tccov3003m000
11. Conversion error sls036 cuno lt sls036 cuno gt sls036 item lt sls036 item gt sls036 cntr sls036 cntr sls036 dile lt sls036 dile gt 7 2 34 Message 34 Conversion error 515037 lt 515037 gt sls037 item lt sls037 item gt sls037 cntr lt sls037 cntr gt sls037 dile lt sls037 dile gt 7 2 35 Message 35 Conversion error 515045 lt sls045 orno gt sls045 pono lt sls045 pono gt sls045 srnb lt sls045 srnb gt 7 2 36 Message 36 Conversion error 51505 1 sls051 orno sls051 trdt lt slsO051 trdt gt slsO51 trtm lt slsO51 trtm gt 7 2 37 Message 37 Conversion error com999 sern tccom999 sern 7 2 38 Message 38 Conversion error mcs042 blcs blocking stepno not in procedure 7 2 39 Message 39 Conversion error tcmcs042 pmsk lt tcmcs042 cotp gt temcs042 pmsk 7 2 40 Message 40 Conversion error tdrpl004 pmsk lt tdrpl004 cotp gt tdrpl004 pmsk 7 2 41 Message 41 Conversion error tdpur045 pmsk lt tdpur045 orno gt lt tdpur045 pono gt lt tdpur045 srnb gt lt tdpur045 pmsk gt 7 2 42 Message 42 Conversion error tdrpl100 pmsk lt tdrpl100 orno gt lt tdrpl100 pono gt lt tdrpl100 srnb gt tdrpl100 pmsk Changing a sign in open item table tccov2001 m000 7 5 7 5 7 6 7 6 7 6 7 6 7 6 7 7 7 7 77 77 7 8 7 8 7 8 7 8 7 8 7 9 Conversion error sls002 opol lt 515002 4 gt lt 515002
12. Postal Address the following two situations can occur When the location is not filled the postal address code is copied When location is filled the Postal Address data is derived from the location General data check Although there are no extensive changes in the data structure it is necessary to check whether or not the data has been converted This can be done by drawing a number of samples from a number of tables in the different packages TRITON Common TRITON 3 1b BAAN IV Description tccom1401m000 tccom1401m000 Print Customers tccom2401m000 tccom2401m000 Print Suppliers TRITON Distribution tdsls5401m000 tdsls5401m000 Print Sales Order History by Customer and Item tdsls6401m000 tdsls6401m000 Print Chart of Accounts Invoice Analysis tdsls6402m000 tdsls6402m000 Print Chart of Accounts Invoice Analysis by VAT Code tdsls6403m000 tdsls6403m000 Print Chart of Accounts Invoice Details tdsst0401m000 tdsst0401m000 Print Sales Statistics TRITON 3 1b Description tdilc1414m000 Print Inventories by Warehouse and Item tdinv6220m000 Perform Slow Moving Analysis by Item tdinv6230m000 Perform Inventory Valuation by Item tdinv7410m000 Print Stock Transactions by Item tdinv8450m000 Print Chart of Accounts for Stock and WIP Transactions tdpst0401m000 Print Purchase Statistics tdpur4404m000 Print Purchase Invoices tdpur4407m000 Print Purchase Orders by Order Number tdpur4431m000 Print Receipts tdpur5401m000 Print Purcha
13. Price Lists Print Product Variant Statistics Print Cost Price by Budget Print Cost Price Calculation by Budget Print Customized Bills of Material Multi Level tipcf6410m000 Print Cost Price by Project Print Actual Cost Price by Project tipcs8410m000 Print Financial Project Transactions Print Chart of Accounts for Financial Project Transactions tisfc0401m000 Print Production Order Report Print Work in Process al al o o o 5 5 5 5 5 5 5 5 15 5 alo alo ala o0 ololo 5151515 oo G 7 0 oo ee RS YVIVIS mo w Co Plaja RISIN olco a NIS 1 SIA R RIAA aJ RIR RIX oja ojo iji o um e 3 51918191 513131313 3 3 3 5 9 3 3 3 3 3 3 3 3 2 2 3 e amp ilsialslal ia o ojo olo olo olo olojo eoileio ojo olo fo Rod ro olojo o ol o olo Print Subcontracted Operations by Supplier Conversion TRITON 3 to BAAN IV 5 15 5 Correction program and checking the conversion both scenarios m 5 3 4 TRITON Finance TRITON 3 1b Description tfacp2420m000 Print Aging Analysis by Supplier tfacp2415m000 Print Control Account Checklist tfacr2420m000 Print Aging Analysis by Customer tfacr2415m000 Print Control Account Checklist tffst1404m000 Print Financial Statements tfgld0411m000 Print Transaction Type
14. Receipts The Financial Company from the Purchase Order Header is copied to the Purchase Receipts The field tdpur045 fico will be filled in with tdpur040 comp Sales Orders The Financial Customer Group is filled in with the Financial Customer Group of the customer of the Sales Order The field tdsls040 cfcg will be filled in with tccom010 cfcg for the corresponding tdsls040 cuno BddN Conversion TRITON 3 to BAAN IV 5 3 5 Correction program and checking the conversion both scenarios TRITON Common Note Note Messages to be generated The Parent Relation is filled in with the Relation The field tcedi700 pren will be filled in with tcedi700 reno Generated Batch Numbers The table Generated Batch Numbers is filled in with the corresponding data from Generated Messages The following fields will be converted tcedi720 netw tcedi701 netw tcedi720 bano tcedi701 bano tcedi720 pren tcedi701 reno tcedi720 send tcedi701 send tcedi720 sent tcedi701 sent tcedi720 stat tcedi701 stat tcedi720 Inst tcedi701 mstt tccov1002m000 conversion of distribution 3 1B gt BAAN IV By using this session the following tables are converted Parameter Tables The following parameter tables are created tdinv000 Inventory Parameters tdilc000 Location Control Parameters tdltc000 Lot Control Parameters tdpur000 Purchase Control Parameters tdsls000 Sales Control Parameters tcedi000 Electro
15. This section lists the messages that can be displayed during the execution of tccov3002m000 The messages are stored in the log file BSE og log cov3002 The messages are stored as follows of output Only process information will be logged into this file Full Description Start and end of process will be logged Format of output MM DD YY mm ss s MM Month DD Day YY Year mm Minutes ss Seconds bs Message Message 1 START OF CONVERSION tccov3002m000 by user lt name gt This message informs you about the start date and time of the session by the specified user Information No action required Message 2 END OF CONVERSION This message informs you about the end date and time of the session Information No action required Conversion TRITON 3 to BAAN IV BddN 7 Appendix B Troubleshooting m 7 10 8 Message 3 tiitm001 lt item code gt lt unit set gt lt units gt For each converted item in tiitm001 the unit set with its units will be logged Type of Information message Possible No action required actions 7 10 4 Message 4 tiitm002 lt item group gt lt unit set gt lt units gt For each converted item default in tiitm002 the unit set with its units will be logged Type of Information message Possible No action required actions 7 10 5 Message 5 tipcs021 lt project code gt lt item code gt lt unit set gt lt units gt For each conve
16. Type of message Possible actions Type of message Possible actions 7 10 14 7 10 15 7 10 16 7 10 17 7 10 18 Message 14 tppdm625 lt project gt lt equipment code gt lt unit set gt copied from pcs021 lt unit gt Message will be logged when unit of project equipment in tppdm625 is found in the already generated unit set Information No action required Message 15 tppdm625 lt project gt lt equipment code gt Error unit not in unit set of pcs021 Error message will be logged when there is an integration to TRITON Distribution and unit of project equipment in tppdm625 is NOT found in the already generated unit set Error Add unit of project equipment to a unit set and run this program again Message 16 tppdm625 lt project gt lt equipment code gt lt unit set gt lt units gt Message will be logged for each project equipment in tppdm625 when there is NO integration to TRITON Distribution and unit is not found in an already existing unit set Information No action required Message 17 tppdm635 lt project gt lt subcontracting code gt lt unit set gt copied from pcs021 lt unit gt Message will be logged when unit of project subcontracting in tppdm635 is found in the already generated unit set Information No action required Message 18 tppdm635 lt project gt lt subcontracting code gt Error unit not in unit set of pcs021 Error message will be logged when there is an int
17. YY mm ss s MM Month DD Day YY Year mm Minutes 55 Seconds bs Message Message 1 START OF CONVERSION tccov2004m000 by user lt name gt This message informs you about the start date and time of the session by the specified user Information No action required Message 2 tfacp200 lt transactiontype gt lt document gt lt anticipated transactiontype gt lt anticipated document gt For each blanked anticipated document in tfacp200 information is logged Information No action required Message 3 tfacr200 lt transactiontype gt lt document gt lt anticipated transactiontype gt lt anticipated document gt For each blanked anticipated document in tfacr200 information is logged Information No action required BddN Conversion TRITON 3 to BAAN IV 7 15 7 Appendix B Troubleshooting m 7 6 4 Message 4 tfgld102 fiscal year lt batchnumber gt lt transactiontype gt lt document gt lt correction transactiontype gt lt correction document gt For each blanked correction document in tfgld102 information is logged Type of Information message Possible No action required actions 7 6 5 Message 5 tfgld106 lt transactiontype gt lt document gt lt correction transactiontype gt lt correction invoice gt For each blanked correction document in tfgld106 information is logged Type of Information message Possible No action required actio
18. a physical database problem for example it is corrupted The purpose of this conversion is to fill the planner field in inv310 Error Use the key value printed in the error message to check the table manually Message 29 Conversion error sls002 opol sls002 qono lt sls002 pono gt This message informs you that the table tdsls002 has a physical database problem for example it is corrupted The purpose of this conversion is to fill the order policy field in 515002 Error Use the key value printed in the error message to check the table manually Message 30 Conversion error sls011 0pol lt sis011 qono gt lt sls011 pono gt This message informs you that the table 10518011 has a physical database problem for example it is corrupted The purpose of this conversion is to fill the order policy field in 515011 Error Use the key value printed in the error message to check the table manually Message 31 Conversion error sls034 cuno sls034 cuno sls034 cpgp lt sls034 cpgp gt sls034 dile lt sls034 dile gt This message informs you that the table tdsls034 has a physical database problem for example it is corrupted The purpose of this conversion is to fill unit field in sls034 Error Use the key value printed in the error message to check the table manually Message 32 Conversion error sls035 cpls sls035 cpls sls035 cpgp lt sls035 cpgp gt sls035 dile lt sls035 dile gt This
19. by Location tssmal125m000 can be used to verify the conversion tssma301 Service Orders The major changes is that for the Service Orders the address data is removed from the table The session Maintain Service Orders tssma3101m000 can be used to verify the conversion There are two types of addresses introduced for the Service Order Postal and Work site Addresses For the conversion of Worksite the following two situations can occur When the location on the order is not filled The conversion will check if the customer data within the order is the same as the data in the customer table If the data is the same not specific worksite address will created When the data differs a specific worksite address is created The location on the order is filled In this case the following can be done The conversion will check if there is specific location worksite address data when this differs from the order data a specific worksite address is created When no specific location address data is specified but only a worksite address code the system will check this data against the order data when differs a specific worksite address is created When no worksite address code is and the customer data differs from the order data a specific worksite address is created Conversion TRITON 3 to BAAN IV 5 13 5 3 5 3 1 5 3 2 5 Correction program and checking the conversion both scenarios m For the conversion of
20. by user lt login name gt 7 27 7 11 2 Message 2 END OF CONVERSION 7 28 7 11 3 Message 3 CONFLICT item gt lt item code gt gt lt item unit gt gt lt alternate unit gt gt lt conversion factor gt gt conflict general conversion 7 28 7 11 4 Message 4 CONFLICT proj item gt lt project gt gt lt item code gt gt lt unit gt gt lt purchase unit gt gt lt conversion factor gt gt conflict general conversion 7 28 7 11 5 Message 5 CONFLICT proj item gt lt project gt gt lt item code gt gt lt unit gt gt lt purchase price unit gt gt lt conversion facto r gt gt conflict general conversion 7 28 7 11 6 Message 6 CONFLICT proj item gt lt project gt gt lt item code gt gt lt unit gt gt lt storage unit gt gt lt conversion factor gt gt conflict general conversion 7 29 7 11 7 Message 7 tiitm004 lt project gt lt item code gt lt item group gt lt base unit gt lt unit gt lt conversi on factor gt 7 29 7 11 8 Message 8 Base Weight Unit not filled 7 29 7 11 9 Message 9 Base Length Unit not filled 7 29 7 11 10 Message 10 Base Area Unit not filled 7 29 7 11 11 Message 11 Base Volume Unit not filled 7 30 7 11 12 Message 12 Base Time Unit not filled 7 30 7 11 13 Message 13 parameters MCS not present 7 30 Conversion TRITON 3 to BAAN IV xi Conversion TRITON 3 to BAAN IV Conversion TRITON 3 to BAAN IV xii 7 11 14 Message 14 physical quantity lt description gt has duplicates conversion fa
21. documents in tfacp200 tfacr200 tfgld102 tfgld106 7 15 7 6 1 Message 1 START OF CONVERSION tccov2004m000 by user login name 7 15 7 6 2 Message 2 tfacp200 transactiontype document anticipated transactiontype gt lt anticipateddocument gt 7 15 7 6 3 Message 3 tfacr200 transactiontype document anticipated transactiontype gt lt anticipateddocument gt 7 15 7 6 4 Message 4 tfgld102 fiscal year lt batchnumber gt lt transactiontype gt document correction transactiontype gt lt correction document 7 16 7 6 5 Message 5 tfgld106 transactiontype document correction transactiontype gt lt correctioninvoice gt 7 16 7 6 6 Message 6 END OF CONVERSION 7 16 tccov2005m000 Changing enumerated field tfcmg108 7 16 7 7 1 Message 1 START OF CONVERSION tccov2005m000 by user login name 7 17 7 7 2 Message 2 tfcmg108 payment batch original company payment type lt supplier gt lt order gt 7 17 7 7 3 Message 3 END OF CONVERSION 7 17 tccov2006m000 Updating payment difference for anticipated document 7 17 7 8 1 Message 1 START OF CONVERSION tccov2006m000 by user login name 7 17 7 6 2 Message 2 tfacp200 supplier transactiontype document linenumber transactiontype document linenumber payment difference 7 18 7 8 3 Message 3 tfacr200 customer transactiontype document lt linenumber gt lt transa
22. gt 7 9 Conversion error sls011 opol sls011 qono lt 515011 gt 7 9 7 9 7 9 7 10 7 10 7 10 7 10 7 10 7 11 7 11 7 12 7 12 BAAN 7 4 7 5 7 6 7 7 7 8 BddN Conversion TRITON 3 to BAAN IV 7 3 1 Message 1 START OF CONVERSION 2001 000 by user login name gt 7 12 7 3 2 Message 2 Convert CDAM error supplier transactiontype document lt linenumber gt lt transactiontype gt lt document gt linenumber currency difference 7 12 7 3 3 Message 3 END OF CONVERSION 7 12 Change step for anticipated unallocated advance payments tccov2002m000 7 13 7 4 1 Message 1 START OF CONVERSION tccov2002m000 by user login name gt 7 13 7 4 2 Message 2 tfacp200 supplier transactiontype document lt linenumber gt lt transactiontype gt document linenumber 7 13 7 4 3 Message 3 tfacr200 customer transactiontype document lt linenumber gt lt transactiontype document linenumber 7 13 7 44 Message 4 END OF CONVERSION 7 13 tccov2003m000 Checking standing order tfcmg114 7 14 7 5 1 Message 1 START OF CONVERSION tccov2003m000 by user login name gt 7 14 7 5 2 Message 2 Posting Data bank document company lt transactiontype gt lt document gt lt supplier gt standing order serial number 7 14 7 5 3 END OF CONVERSION 7 14 tccov2004m000 Changing anticipated
23. has been started correctly Step 17 Create the audit database and assign tables to it BAAN IV includes an audit facility that can log all parameter changes To use this audit you must first create an audit database and assign tables to it To do so follow the steps described below 1 Logon as user bsp 2 Selectthe Database Management menu from the Tools main menu 3 Select the Maintain Database Definitions ttaad4110m000 session from the Maintenance menu 4 Insert a new database named AUDIT As description use AUDIT Database The type of database depends on the running RDBMS Select the Audit Trail check box Clear the Force to Read and Copies Present check boxes 5 Select the Maintain Audit File Directories ttaad4116m000 session from the Maintenance menu 6 Select All other tables in the Table Selection field and insert the path name for the audit directory for example usr3 audit the number sign indicates that for each company a separate directory is created under usr3 audit 7 Select the Convert to Runtime option from the Application menu 8 Select the Database Management menu from the Tools main menu Conversion TRITON 3 to BAAN IV 4 14 BAAN 4 3 18 4 3 19 4 3 20 4 3 21 4 3 22 4 3 23 4 Converting to BAAN IV the single environment scenario 9 Select the Assign Tables to Databases ttaad4111m000 session from the Maintenance menu 10 Insert all tables you want to be audited Note
24. i 4 Converting to BAAN IV the single environment scenario m Note 4 3 3 Step 3 Running preinst during or right after the installation of BAAN IV During an installation or upgrade of the BAAN IV software on a UNIX platform the install6 1 installation script calls the preinst utility The preinst utility is part of the BAAN IV installation process and is used to perform different checks on the UNIX environment The checks performed by preinst concern Kernel parameters Checking singlebyte multibyte database Disk space Maximum file size Required standard users TCP IP configuration Environment variables Runtime environment versus data dictionary Options to speeding up installation Install data Checking tables Customization VRC Client server installation Existence of fixes The preinst utility uses the values in the file kernel_cfg to check the items listed above The kernel_cfg file contains the minimal kernel parameters of the system and is installed in the directory BSE lib If preinst detects that the current value of a parameter is less than the value defined in the kernel_cfg file a warning is displayed After having finished all the checks preinst displays the following message if one or more errors are detected Errors found during system check continue You can choose one of the following options 1 Cancel the installation of the BAAN IV software and tune the UNIX opera
25. line for those customers using the Proforma Invoice feature 5 6 2 EDI Message Generated Conversion from BAAN IVa to BAAN IVb tccovi999m000 The utility tccovl999m000 is optional This utility sets the EDI Message Generated flag on Sales and Purchase Orders 5 7 Removing the 3 x software after the conversion After the transition to BAAN IVb has been successfully completed the TRITON 3 x software including package VRCs package combinations custimizations and localizations must be removed Conversion TRITON 3 to BAAN IV BAAN 5 Correction program and checking the conversion both scenarios Conversion TRITON 3 to BAAN IV PS BAAN 6 Appendix A Upgrading customizations This chapter describes the steps needed to upgrade both external and in house customizations This applies especially to between TRITON 3 to BAAN IV For small differences between BAAN IVa and BAAN IVb see also the online Help of the Upgrade Customizations to New Standard method in BAAN Tools 6 1 Recommendations After a new version release has been installed by means of the installation program this new software is not yet active To activate this software a new package combination can be created to which a company can be linked to test the software In the meantime the remaining companies continue using the old TRITON 3 1 software After the software has been tested and approved these remaining companies are also migrated to the
26. lt tdpur045 pono gt lt tdpur045 srnb gt converted This message informs you that the financial company in tdpur045 is updated For each purchase order in tdpur045 it is recorded if the financial company has been updated Information No action required Message 9 Financial Customer Group Sales Order lt tdsls040 orno gt converted This message informs you that the financial customer group in tdsls040 is updated For each sales order in tdsls040 it is recorded if the Financial Customer Group has been updated Information No action required Conversion TRITON 3 to BAAN IV 7 2 BAAN Note Type of message Possible actions Type of message Possible actions Type of message Possible actions 7 2 7 2 1 7 2 2 7 2 3 7 Appendix B Troubleshooting Conversion of Distribution 3 1 to BAAN IV tccov1002m000 This section lists the messages that can be displayed during the conversion of Distribution 3 1 to BAAN IV tccov1002m000 The messages are stored in the log file BSE log log cov1002 The messages 3 up to 18 can only be printed if the Convert Statistics parameter is set to Yes The purpose of all these conversions is to convert all sort strings in the statistics tables to a new domain The messages are stored as follows Type of output Only process information will be logged into this file Full Description Start and end of process will be logged Format of o
27. message informs you that the table tdsls035 has a physical database problem for example it is corrupted The purpose of this conversion is to fill the unit field in 515035 Error Use the key value printed in the error message to check the table manually Conversion TRITON 3 to BAAN IV BddN 5 7 Appendix B Troubleshooting m 7 2 33 Message 33 Conversion error sls036 cuno sls036 cuno sls036 item lt sls036 item gt sls036 cntr lt sls036 cntr gt sls036 dile sls036 dile This message informs you that the table tdsls036 has a physical database problem for example it is corrupted The purpose of this conversion is to fill the unit field in 515036 Type of Error message ec Use the key value printed in the error message to check the table manually actions 7 2 34 Message 34 Conversion error sIs037 cpls sls037 cpls sls037 item lt sls037 item gt sls037 cntr sls037 cntr sls037 dile lt sls037 dile gt This message informs you that the table tdsls037 has a physical database problem for example it is corrupted The purpose of this conversion is to fill the unit field in 515037 Type of Error message ee Use the key value printed in the error message to check the table manually actions 7 2 35 Message 35 Conversion error sls045 orno lt sls045 orno gt sls045 pono lt sls045 pono gt sls045 srnb lt sls045 srnb gt This message informs you that the table tdsls045 has a physical datab
28. message will be logged when Base Length Unit is not filled in temcs000 The program will abort Fatal error Enter Length Unit in tcemcs000 and run the program again Message 31 Base Length Unit not filled Error message will be logged when Base Length Unit is not filled in temcs000 The program will abort Fatal error Enter Length Unit in tcemcs000 and run the program again Message 32 Base Area Unit not filled Error message will be logged when Base Area Unit is not filled in temcs000 The program will abort Fatal error Enter Area Unit in 000 and run the program again Message 33 Base Volume Unit not filled Error message will be logged when Base Volume Unit is not filled in temcs000 The program will abort Fatal error Enter Volume Unit in temcs000 and run the program again Conversion TRITON 3 to BAAN IV BddN Te 7 Appendix B Troubleshooting Type of message Possible actions Type of message Possible actions Type of message Possible actions Type of message Possible actions Type of message Possible actions 7 10 34 7 10 35 7 10 36 7 10 37 7 10 38 Message 34 Base Time Unit not filled Error message will be logged when parameters are not present in tcmcs000 Fatal error Enter Time Unit in temcs000 and run the program again Message 35 parameters MCS not present Error message will be logged when parameters are not present in tcmcs000
29. new software A distinction is made between migrating customizations developed by Baan or a Baan dealer and customizations developed by the customer so called in house customizations In this context customizations are modifications to the standard software 6 2 Print differences between two PVRCs In a single environment scenario you can print all the differences by means of the Compare Package VRCs ttadv6450m000 session You can either print global change information or detailed information by selecting the Detailed Information excl Technical Documentation check box 6 3 Upgrade of in house customizations To upgrade in house customizations take the following steps 1 The tdB400_a_cu01 and tdB40O a cu02 PVRCs must be created 2 The directories for software components must be set for both PVRCs 3 The software components must be exported from the TRITON 3 1 environment by means of the Export Data Dictionary ttiex1280m000 session and imported in the BAAN IV environment by means of the Import Data Dictionary ttiex1285m000 session namely from td3 1O b 01 to 400 a cu01 from td3 1O b 02 to tdB40O a cu02 4 The VRC tree must be defined OPER 001 DSGN 001 td3 1O b cu01 td3 1O b cu02 Figure 6 1 Start position Conversion TRITON 3 to BAAN IV BddN 6 Appendix A Upgrading customizations m OPER 001 DSGN 001 td3 10_b_cu01 td3 10_b_cu02 B40Sa tdB40_a tdB40_b tdB40_b1 tdB40_b2 Figure 6 2 Te
30. on the evening of the first day allow 4 to 8 hours on the second day to complete the job This may be considerably more to the point of having to allow a third day if Informix or Oracle installations and or the conversion of many or large test companies are involved The time frame on the first day is 1 to 5 hours to read out the tape s a master tape takes longer than a normal installation tape Allow an additional half hour to prepare the update and to discuss the procedure with the customer Try to take into account that the customer may want to run a backup at the last moment The installation script takes between 3 hours and several days in case of logged databases on a relatively small system to run 4 2 4 Prerequisites Reserve 300 MB to 400 MB for reading the tape A full update requires 350 to over 450 MB for one language excluding customization under bisam Allow an extra 200 MB per additional language Determine if there is sufficient disk space on the system at the proper places see previous section Check the derived from structure the package combinations and associated companies After installation the existing TRITON 3 structure that can still be used must be copied into BAAN IV This requires the creation of at least one new BAAN IV package combination for testing 4 2 5 Test This test package combination is referred to in this document as 001 and is a copy of the operational package combination
31. possible to define new users authorizations devices currencies and logical tables ttcon6limpor alphanum single occ 4 Form 1 1 Import Users Authorizations Devices etc from 6 1 Path 6 1 Data usr8 bse tmp baaniv Conversion TRITON 3 to BAAN IV 3 6 Example 3 3 3 3 1 3 3 2 3 Converting to BAAN IV two environments scenario Software conversion Import Data Dictionary ttiex1285m000 This session is mandatory for customized software components and is used to import the customized VRCs which originate from TRITON 3 in the proper B40 VRCs ttiex1285m000 single occ 4 Form 1 1 Import Data Dictionary usrl TRITON6 bse export tc Path Sequential Dumps Path Runtime Dictionary BSE application Overwrite Delete dumps after installation Write software components Yes in other Package VRC Package VRC tc TRITON Common 400 a 01 tc3 1O a cu02 gt tcB40O a cu02 Maintain Packages by Package Combination ttaad1121m000 This session is mandatory for customized software components and is used to create an operational package combination in BAAN IV which is referred to as OPER 001 Prior to converting the data tables the data model must be assessed as being the correct data model In addition the derived structure of the VRCs must be determined For more information on how to upgrade customized VRCs see Chapter 6 Upgrading Customizations Conversion TRI
32. printed in the error message to check the table manually actions 7 2 15 Message 15 Conversion error pst025 sstr lt pst025 sstr gt This message informs you that the table tdpst025 has a physical database problem for example it is corrupted Type of Error message ne Use the key value printed in the error message to check the table manually actions 7 2 16 Message 16 Conversion error pst028 sstr lt pst028 sstr gt This message informs you that the table tdpst028 has a physical database problem for example it is corrupted Type of Error message Use key value printed in the error message to check the table manually actions 7 2 17 Message 17 Conversion error pst050 sstr lt pst050 sstr gt This message informs you that the table tdpst050 has a physical database problem for example it is corrupted Type of Error message ee Use the key value printed in the error message to check the table manually actions 7 2 18 Message 18 Conversion error pst030 sstr lt pst050 sstr gt This message informs you that the table tdpst030 has a physical database problem for example it is corrupted Type of Error message brand Use the key value printed in the error message to check the table manually actions Conversion TRITON 3 to BAAN IV id BAAN Type of message Possible actions Type of message Possible actions Type of message Possible actions
33. quantity Message 15 No units present Error message will be logged when no units are found in temcs001 The program will abort Fatal error Enter units for all physical quantities to tcmcs001 Conversion TRITON 3 to BAAN IV 7 30 BAAN E Type of message Possible actions Type of message Possible actions Type of message Possible actions Type of message Possible actions Type of message Possible actions Type of message Possible actions 7 11 16 7 11 17 7 11 18 7 11 19 7 11 20 7 11 21 7 Appendix B Troubleshooting Message 16 base unit physical quantity lt description gt not known conversion factor 1 0 Error message will be logged when no unit is found with a certain physical quantity and conversion factor 1 0 The program will abort Fatal error Enter unit for that physical quantity to temcs001 Message 17 domain lt domain name gt has no enumerated values This error will be logged when a certain domain has not enumerated values The program will abort Fatal error Ask for support from software vendor or enter enumerated values to enum domain Message 18 Error lt error code gt in qss search lt search mode gt lt search argument gt lt table gt lt definition gt lt number gt This will be a program error The program will abort Fatal error Ask for support from software vendor Message 19 Error lt error code gt in q
34. test conversion its causes must be traced and cleared so that the test conversion can be repeated without having the error block the final conversion Provide certainty about the results of the conversion run The results of the test conversion are assessed based on the data and procedure tests Because all functions and procedures in the new BAAN IV application can be used based on the data of the users own company maximum certainty is achieved regarding the continuity of business processes Integration of implementation and data conversion Data conversion must be an integral part of the installation and is therefore included in the plan of action This plan of action includes the following aspects Upgrade or installation of hardware Installation of BAAN IV if applicable Training of end users BAAN IV tools and applications Development of customizations Implementation of BAAN IV Tools Preparation of test conversion Test conversion Data test Procedure test Go No Go decisions a Final conversion Conversion TRITON 3 to BAAN IV 1 4 BAAN 1 Introduction 1 4 Terms and abbreviations Term Abbreviation BSE BSE Environment Data Conversion Software Conversion VRC 1 5 References Description BSE refers to the BAAN Shell Environment By means of the BSE variable a short link is established which refers to the directory in which all BAAN programs and directories are locat
35. then document accepted by customer or else if tfcmg003 rs03 yes then document sent to bank orelse if tfcmg003 ps01 yes then document received orelse if tfcmg003 ps02 z yes then document accepted sent In tfacr200 the same happens for advance anticipated and unallocated anticipated Check Standing Order tfcmg114 Posting Data tecov2003m000 By means of this session the Standing Order Number field is added to the Posting Data for Anticipated Payments without Invoice table This program reads the anticipated table and will update tfcmg114 In tf3 1b an extra field for the standing order is added to tfemg114 This field will be filled in with this program From tfemg111 the standing orders are read which are of type cost in tfcmg114 The field tfemg114 orno will be filled in with tfcmg11 1 docn Check Anticipated Document tfacp200 tfacr200 tecov2004m000 By means of this session the tables for unallocated advance receipts payments are checked to ensure that the anticipated document number is not specified If the anticipated document number is specified this is corrected after which the selected records are saved in a file This program reads the open item tables for unallocated advance receipts payments It will check if the anticipated document number is filled in For unallocated advance payments it should not be filled in If these fields are filled in it will cause differences on the checklist tfacp2415 tfacr2415 for b
36. tp to tbase for the conversion import 000 FERE ottcon61 import a lt gt 3 0 3 1 C3 lt gt BAANIV Figure 3 1 of 4 Converting to BAAN IV two environments scenario Conversion TRITON 3 to BAAN IV dd 3 Converting to BAAN IV two environments scenario create O VRC s ttadv1111m000 maintain directories ttadv1115m000 import O VRC s ttiex1285m000 check derived from fields for all VRC s reate PC OPER_001 ttaad1120m000 fill PC with VRC s ttaad1121m000 copy PC to TMP 001 ttaad1220m000 copy DD 3 1 to BIV ttcon2140 or UNIX maintain companies ttaad1100m000 assign tables to db ttaad4111m0000 LEGEND o gt 3 0 3 1 lt gt BAANIV Figure 3 2 of 4 Converting to BAAN IV two environments scenario Conversion TRITON 3 to BAAN IV BddN ui 3 Converting to BAAN IV two environments scenario maintain table dirs ttaad4115m000 maintain logical tables ttaad4120m000 maintain user data ttaad2100m000 leave bshell and start bshell again import data comp ttaad4226m000 3 0X environment import data comp run conv2tbase database specific register tables tbase tp 6 1 R referential integrity ttaad4225m000 check tables ttaad4232m000 convert tabl to BIV LEGEND ttaad1 102000 m 3 0 3 1 lt gt BAANIV Figure 3 3 of 4 Converting to BAAN IV two environments scenario Conversion TRITON 3 to BAAN IV BAAN
37. update the order policy field in table pur011 Error Use the key value printed in the error message to check the table manually Conversion TRITON 3 to BAAN IV BddN dii 7 Appendix B Troubleshooting m Type of message Possible actions Type of message Possible actions Type of message Possible actions Type of message Possible actions Type of message Possible actions 7 2 23 7 2 24 7 2 25 7 2 26 7 2 27 Message 23 Conversion error pur034 suno lt pur034 suno gt pur034 cpgp lt pur034 cpgp gt pur034 dile lt pur034 dile gt This message informs you that the table tdpur034 has a physical database problem for example it is corrupted The purpose of this conversion is to fill the unit field in pur034 Error Use the key value printed in the error message to check the table manually Message 24 Conversion error pur035 cplp pur035 cplp pur035 cpgp lt pur035 cpgp gt pur035 dile lt pur035 dile gt This message informs you that the table tdpur035 has a physical database problem for example it is corrupted The purpose of this conversion is to fill the unit field in pur035 Error Use the key value printed in the error message to check the table manually Message 25 Conversion error pur036 suno lt pur036 suno gt pur036 item lt pur036 item gt pur036 cntr lt pur036 cntr gt pur036 dile lt pur036 dile gt This message informs you that the table t
38. used to create the validation key When you receive this key in a printout from Baan proceed with the validation Choose menu options 1 Software Installation 6 Maintain Security Code Validation Key ttiex3102m000 Press C to edit the screen enter the Validation Key Tools and the Validation Key Software Standard Make sure the Security Key on the Baan printout is exactly the same as the one in this session Press E to exit To run the next session user has to be root Change back to bsp after completing Validate Toolset and starting the license daemon 7 Validate Toolset ttiex3220m000 To the question about starting the license server answer Yes At this point an error message may appear If a message appears check if the license daemon is running You may have to start the license daemon manually The license daemon must be running in order to complete the next step otherwise another error message appears Check the license daemon by leaving the bshell via at the Choice prompt and by entering ps ef grep licd The license daemon is a process with the name licd6 1 If necessary start the license daemon by entering the licd6 1 command Return to your bshell type exit and perform the following action 8 Configure Application ttiex3225m000 This is also known as patching the software Enter Yes the next field No is skipped Yes Press Y to confirm If you see Sorting message the process
39. 00 4 13 4 3 16 Step 16 Validate the system 4 13 4 3 17 Step 17 Create the audit database and assign tables to it 4 14 4 3 18 Step 18 Create tables ttaad4230m000 4 15 4 3 19 Step 19 Parameters tcmcs0295m000 4 15 4 3 20 Step 20 Maintain Company Parameters tfgld0103m000 4 15 4 3 21 Step 21 Maintain ITM Parameters tiitm0100m000 4 15 4 3 22 Step 22 Maintain Base Units 0100 000 4 15 4 3 23 Step 23 Checking and finalizing 4 15 5 Correction program and checking the conversion both scenarios 5 1 5 1 Conversion matrix release 3 release 4 5 1 5 2 Conversion of TRITON 3 x gt BAAN IV tccov0000m000 53 5 2 1 BAAN Distribution 5 3 5 2 2 BAAN Manufacturing 5 8 5 2 5 BAAN Finance 5 10 5 2 4 BAAN Transportation 5 11 5 2 5 Converting TRITON Service version 3 0b to BAAN IV 5 11 5 3 General data check 5 14 5 3 1 TRITON Common 5 14 5 3 2 TRITON Distribution 5 14 Conversion TRITON 3 to BAAN IV j BAAN 5 4 5 5 5 6 Conversion TRITON 3 to BAAN IV 5 3 3 TRITON Manufacturing 5 3 4 TRITON Finance Specific data check 5 4 1 BAAN Distribution 5 42 BAAN Manufacturing 5 4 3 BAAN Finance 5 4 4 BAAN Manufacturing Conversion BAAN IVa to BAAN IVb 5 5 1 BAAN Tools 5 5 2 BAAN Enterprise Modeler 5 5 3 BAAN Enterprise Performance Manager 5 5 4 Data conversion from BAAN IVa to BAAN IVb Converting localizations to BAAN IV 5 6 1 Proforma Invoice Conversion from 3 1x to BAAN IVx tfcmgl900m000 5 6 2 EDI Message G
40. 00 padh will be converted from tfacp200 padi using the currencies from tfcmg111 Sales invoices are converted similarly in tfacr200 5 2 4 BAAN Transportation Conversion of Transportation 3 x gt BAAN IV TCO tccov5001m000 By means of this sessions the value of the Match Status cost line field is set to All Approved if there is a link with Finance and a cost line with status Posted Each of these sessions has an indicator which displays the conversion status The following statuses can be distinguished Status not defined This means that the initial value is displayed Execution not necessary This means that the conversion does not apply to the original version and packages which were selected Not executed This means that the conversion must still be executed Execution aborted This means that the conversion was aborted due to an error which occurred during the conversion In process This means that the session is running Execution completed This means that the conversion was successful For each session a logfile is created in which data regarding the events the converted components and the errors which occurred during each conversion These log files are located in the BSE log directory For example BSE log log cov1001 5 2 5 Converting TRITON Service version 3 0b to BAAN IV This section describes the conversion of TRITON Service version 3 0b to BAAN IV This conversion is needed because of the d
41. 0408m000 Print Currency Rates 5 4 3 BAAN Finance Change Sign in Open Item Table tfacp200 tccov2001m000 Change Step for Antic Unalloc Adv Payments tccov2002m000 Check Standing Order tfcmg114 Posting Data tccov2003m000 Check Anticipated Document tfacp200 tfacr200 tecov2004m000 Change Enumerated Field tfcmg108 tccov2005m000 Update Payment Differences from Anticipated Payment tccov2006m000 BAAN IV Description tfacp2421m000 Print Purchase Invoices tfacr2421m000 Print Sales Invoices 5 4 4 BAAN Manufacturing Conversion of Manufacturing 3 1 A gt BAAN IV tccov3001m000 BAAN IV Description timps5410m000 Print Planned MPS Interplant Orders timps5430m000 Print Planned MPS Purchase Orders timrp1421m000 Print Planned MRP Purchase Orders Conversion Units to Units by Unit Sets tccov3002m000 Conversion Unit Conversion Factors tccov3003m000 BAAN IV Description tiitm0401m000 Print Item Data tiitm0410m000 Print Item Default Data tiedm0410m000 Print Engineering Items tipcs2421m000 Print Customized Item Data Conversion TRITON 3 to BAAN IV BddN id 5 Correction program and checking the conversion both scenarios m 5 5 5 5 1 5 5 2 5 5 3 5 5 4 Conversion BAAN IVa to BAAN IVb BAAN Tools After the BAAN IVb version is installed no conversion between BAAN IVa and BAAN IVb is required for BAAN Tools BAAN Enterprise Modeler Create a file in BAAN IVa that contains all Enterp
42. 1 unit 7 21 7 10 13Message 13 tppdm035 lt subcontracting code gt lt unit set gt lt units gt 7 21 7 10 14 Message 14 tppdm625 lt project gt lt equipment code gt lt unit set gt copied from pcs021 lt unit gt 7 22 7 10 15 Message 15 tppdm625 lt project gt lt equipment code gt Error unit not in unit set of pcs021 7 22 7 10 16 Message 16 tppdm625 lt project gt lt equipment code gt lt unit set gt lt units gt 7 22 7 10 17 Message 17 tppdm635 lt project gt lt subcontracting code gt lt unit set gt copied from pcs021 lt unit gt 7 22 7 10 18 Message 18 tppdm635 lt project gt lt subcontracting code gt Error unit not in unit set of pcs021 4 22 7 10 19 Message 19 tppdm635 lt project gt lt subcontracting code gt lt unit set gt units 7 23 7 10 20 Message 20 tppdm605 project project item Error item not in pdm625 7 23 7 10 21 Message 21 tppdm605 project project item Error item not in pdm635 7 23 7 10 22 Message 22 tppdm605 lt project gt lt itemcode gt lt unit set gt lt units gt 7 23 7 10 23 Message 23 tppdm605 lt project gt lt itemcode gt Error unit not in unit set of pcs021 7 23 7 10 24 Message 24 tppdm605 lt project gt lt itemcode gt lt unit set gt copied from pdm625 7 24 7 10 25 Message 25 tppdm605 lt project gt lt itemcode gt Error unit not in unit set of pdm625 7 24 BAAN 7 11 BddN Conversion TRITON 3 to BAAN IV
43. 19 Conversion error mcs047 ckon lt mcs047 ckon gt mcs047 grno mcs047 grno 7 2 20 Message 20 Conversion error edi005 mess lt tcedi005 mess gt 7 2 21 Message 21 Conversion error pur002 opol lt pur002 gono gt lt pur002 pono gt 7 2 22 Message 22 Conversion error pur011 opol lt pur011 gono gt lt pur011 pono gt 7 2 23 Message 23 Conversion error pur034 suno lt pur034 suno gt pur034 cpgp lt pur034 cpgp gt pur034 dile lt pur034 dile gt 7 2 24 Message 24 Conversion error pur035 cplp lt pur035 cplp gt pur035 cpgp lt pur035 cpgp gt pur035 dile lt pur035 dile gt 7 2 25 Message 25 Conversion error pur036 suno lt pur036 suno gt pur036 item lt pur036 item gt pur036 cntr lt pur036 cntr gt pur036 dile lt pur036 dile gt 7 2 26 Message 26 Conversion error pur037 cplp lt pur037 cplp gt pur037 item lt pur037 item gt pur037 cntr lt pur037 cntr gt pur037 dile lt pur037 dile gt 7 2 27 Message 27 Conversion error inv300 orno lt tdinv300 orno gt 7 2 28 Message 28 Conversion error inv310 orno tdinv310 orno 7 2 29 Message 29 7 2 30 Message 30 7 2 31 Message 31 Conversion error sls034 cuno lt sls034 cuno gt sls034 cpgp lt sls034 cpgp gt sls034 dile lt sls034 dile gt 7 2 32 Message 32 Conversion error 515035 lt sls035 cpls gt sls035 cpgp lt sls035 cpgp gt sls035 dile lt sls035 dile gt 7 2 33 Message 33
44. 2 Software export 3 Data export Each of these main steps may consist of a number of additional steps Conversion TRITON 3 to BAAN IV BAAN 2 Preparing TRITON for conversion the two environments scenario install BIV fresh import B C VRC s ttiex1285m000 tbase tp create new db instance OR install database fresh export O VRC s ttiex1280m000 create O VRC s ttadv1111m000 maintain directories ttadv1115m000 import O VRC s ttiex1285m000 adapt DataModel O VRC s to BAANIV adjust correction pro gram to DataModel LEGEND start test con com 3 0 3 1 co lt gt BAANIV Figure 2 1 Preparing TRITON 3 for conversion the two environments scenario Conversion TRITON 3 to BAAN IV i m 2 Preparing TRITON for conversion the two environments scenario Note 2 2 General 2 2 1 Checking the consistency of the TRITON 3 data If the item data in Triton 3 0b 3 0b1 are inconsistent the conversion to BAAN IV will fail For this reason you must run a query before you start the actual conversion This query will detect inconsistencies in the TRITON database and is described in the procedure below You must carry out the query for each company to be converted 1 Use vito create a file for example check db containing the query below select tdpur036 suno tdpur036 item from tdpur036 where not exists Select tiitm001 item from tiitm001 where tiitm001 ite
45. 55 BSE bin register6 1 command for i in find name bdt print do tbase6 1 R r I 3t Use tbase tp6 1 for TBASE TP database done Informix or Oracle The approach for these RDBMS highly depends on the customer s situation and is therefore too complex to be discussed in the context of this document For more information contact the local BAAN supplier who may contact the ISC for assistance Partners and dealers in the EMEA area can contact the department of Technical Services of BAAN Netherlands Check Tables ttaad4232m000 This session is used to check the tables that must be converted for consistency in relation to table definitions If there are no inconsistencies no error messages will occur other than the Table Does Not Exist message related to error 506 which is prompted by the new tables in BAAN IV These tables can be created after the conversion Since the tables are locked after this session has been used the bshell must be restarted after this session is closed Convert 3 0 3 1 Tables to BAAN IV ttaad1102m000 This session is used to convert the table format from the temporary package combination to the operational package combination Check Tables ttaad4232m000 After the tables have been converted this session is used to check the tables for consistency in relation to table definitions If there are no inconsistencies no error messages will occur Since the tables are locked after this session has
46. BAAN IV m Conversion TRITON 3 to BAAN IV Conversion Guide U7025C US Research Development Conversion TRITON 3 to BAAN IV m Conversion TRITON 3 to BAAN IV BAAN Conversion TRITON 3 to BAAN IV Document information Document Number U7025C US Group User documentation Name Conversion TRITON 3 to BAAN IV Edition C Date July 1997 1997 Baan Development B V All rights reserved The information in this document is subject to change without notice No part of this document may be reproduced stored or transmitted in any form or by any means electronic or mechanical for any purpose without the express written permission of Baan Development B V Baan Development B V assumes no liability for any damages incurred directly or indirectly from any errors omissions or discrepancies between the software and the information contained in this document Conversion TRITON 3 to BAAN IV BAAN Conversion TRITON 3 to BAAN IV m Conversion TRITON 3 to BAAN IV BAAN Table of contents 1 1 1 2 1 3 1 4 1 5 2 1 2 2 2 3 24 3 1 3 2 3 3 3 4 BddN Introduction Scope Target group Remarks and recommendations 1 3 1 Conversion to BAAN IV two possible scenarios 1 3 2 Customizations 1 3 3 Localizations 1 3 4 Disk space 1 3 5 Straight migration 1 3 6 Test conversion 1 3 7 Integration of implementation and data conversion Terms and abbreviations Refer
47. ERSION tccov2001m000 by user lt name gt This message informs you about the start date and time of the session by the specified user Type of Information message Possible No action required actions 7 3 2 Message 2 Convert CDAM error lt supplier gt lt transactiontype gt lt document gt lt linenumbers lt transactiontype gt lt document gt lt linenumbers gt currency difference gt For each changed sign in tfacp200 the information is logged Type of Information message Possible No action required actions 7 3 3 Message 3 END OF CONVERSION This message informs you about the end date and time of the session Type of Information message Possible No action required actions Conversion TRITON 3 to BAAN IV BAAN Type of message Possible actions Type of message Possible actions Type of message Possible actions Type of message Possible actions 7 4 7 4 1 7 4 2 7 4 3 7 4 4 7 Appendix B Troubleshooting Change step for anticipated unallocated advance payments tccov2002m000 This section lists the messages that can be displayed during the execution of tccov2002m000 The messages are stored in the log file BSE log log cov2002 The messages are stored as follows Type of output Only process information will be logged into this file Full description Start and end of process will be logged Format of output MM DD YY mm ss s MM Month DD Day YY
48. Logical Tables ttaad4120m000 Two new tables were introduced Customer Balances by Company tccom011 and Supplier Balances by Company tccom021 The new tables tccom011 and tccom021 must be logically linked in the same way as the existing tables Customers tccom010 and Suppliers tecom020 are logically linked 5 Execute the Recalculate Open Entries otfcor0260 for all financial companies to fill in automatically the invoice balance of the suppliers 6 Execute the Recalculate Open Entries otfcor0261 for all financial companies to fill in automatically the invoice balance of the customers 7 Execute the Rebuild Customer Order Balance tccom2210m000 to fill in automatically all customer order balances 8 Execute the Rebuild Supplier Order Balance tccom2220m000 to fill in automatically all customer order balances Conversion TRITON 3 to BAAN IV 5 18 BAAN m 5 Correction program and checking the conversion both scenarios 5 6 Converting localizations to BAAN IV The sections below describe the conversion programs for the localizations 5 6 1 Proforma Invoice Conversion from 3 1x to BAAN IVx tfcmgl900m000 The conversion program tfcmgl900m000 converts the Proforma Invoice tables present in 3 1xGLO to the standard BAAN IVx tables This utility is optional The Proforma Invoice feature was moved into the standard for BAAN IVa and as such all table names were changed This conversion program is executed from the command
49. Master tfgld0408m000 Print Chart of Accounts tfgld1406m000 tfgld1406m000 Print Finalized Transactions by Ledger Account tfgld3402m000 tfgld3402m000 Print Trial Balance tfgld3409m000 tfgld3409m000 Print Column Balance tfgld3405m000 tfgld3405m000 Print Trial Balance with Dimensions 5 4 Specific data check During the final step in the conversion a number of sessions are automatically activated if required to convert specific data The lists of sessions below can be used to check the modifications Read also the session help of the conversion sessions for more information about the modifications 5 4 1 BAAN Distribution Conversion of Distribution 3 X gt 3 1B tccov1001m000 BAAN IV Description tdsmi0470m000 Print Selections tdsmi1450m000 Print Letters tdinv3420m000 Print Planned INV Purchase Orders tcedi7401m000 Print History of Generated Messages tdpur4401m000 Print Purchase Orders tdpur4431m000 Print Receipts tdsls4405m000 Print Sales Orders by Customer tccom1401m000 Print Customers Conversion TRITON 3 to BAAN IV 5 16 BAAN m 5 Correction program and checking the conversion both scenarios 5 4 2 BAAN Manufacturing Conversion of Manufacturing 3 1A gt BAAN IV tccov1002m000 BAAN IV Description tdpst0401m000 Print Purchase Statistics tdpur0404m000 Print Prices by Price List and Item tdpur1401m000 Print Inquiries tdsst0401m000 Print Sales Statistics tdsls0404m000 Print Prices by Price List and Item temcs
50. N IV BddN ms 1 Introduction 1 3 5 1 3 6 1 3 7 Straight migration In case of a straight migration the business functions which are used in TRITON 3 are migrated to BAAN IV where they will be used in the same way if possible Consequently a straight migration offers maximum security while the complexity of the project is reduced because new functionality is not implemented until later Test conversion The application tables data in TRITON 3 are converted to BAAN IV by one of the conversion specialists of Baan or the customer s own conversion specialists The test conversion simulates the final conversion with the following objectives Attune the conversion environment to customizations if any In case the TRITON 3 version includes customized table definitions the standard conversion program must be modified to fit the customer s configuration In this case the test conversion can only be carried out after the customizations have been redefined under BAAN IV Provide information about the run time of the actual conversion The planning of the final conversion is based on the run time of the test conversion After the final conversion has been started no new transactions must be created in TRITON 3 because these transactions will not be included in the conversion Provide certainty about the progress of the conversion run The final conversion must take place without errors If any error occurs during the
51. RITON 3 environment will be frozen You must copy BSE tools tt6 X X ottadv oadvstd2 to a backup directory If TRITON 3 0 is running on Oracle you must create the file BSE lib defaults db resource containing the following line ora levell 1 Conversion TRITON 3 to BAAN IV 4 6 BAAN m 4 Converting to BAAN IV the single environment scenario 4 3 Installation procedure 4 3 1 Step 1 Reading out tapes Read each of the tape s into a new empty directory On a suitable file system create a temporary empty directory baan for example to read the installation tape into This directory may NOT be below BSE Read the tape for C VRCs if available into another directory and the tape for B VRCs if available in yet another A Regular tape Go to the empty directory and read the tape using the cpio icuvdB dev device command B Master tape Go to the empty directory and read the first block of the tape see also the TRITON Tools 6 1 Installation Manual 5966US Chapter 4 pages 12 32 When the first block is read a script called mas read6 1 is copied to disk Start this script Select the package VRCs and languages to be installed The script takes care of reading these from tape 4 3 2 Step 2 Start installation script The user must be root while the installation is running the customer cannot use this environment Check if everyone has left the bshell and has been advised through the system mana
52. TON 3 to BAAN IV 7 28 BAAN Type of message Possible actions Type of message Possible actions Type of message Possible actions Type of message Possible actions Type of message Possible actions 7 11 6 7 11 7 7 11 8 7 11 9 7 11 10 7 Appendix B Troubleshooting Message 6 CONFLICT proj item gt lt project gt gt lt item code gt gt lt unit gt gt lt storage unit gt gt lt conversion factor gt gt conflict general conversion A message will be logged when a conversion factor is found for an project item whose item unit has the same physical quantity not pieces as the physical quantity of the storage unit of that project item Warning Change conversion factors afterwards optional Message 7 tiitm004 lt project gt lt item code gt lt item group gt lt base unit gt lt unit gt conversion factor This message will be logged for each written general conversion factor Information No actions required Message 8 Base Weight Unit not filled Error message will be logged when Base Weight Unit is not filled in temcs000 The program will abort Fatal error Enter Weight Unit in temcs000 and run program again Message 9 Base Length Unit not filled Error message will be logged when Base Length Unit is not filled in temcs000 The program will abort Fatal error Enter Length Unit in temcs000 and run program again Message 10 Base Area Unit not filled
53. TON 3 to BAAN IV BddN n 3 Converting to BAAN IV two environments scenario m 3 4 3 4 1 3 4 2 Data conversion Copy Package Combination ttaad1220m000 This session is used to copy the standard or customized package combination of BAAN IV referred to as OPER 001 to a new temporary package combination referred to as 001 These package combinations must have the same VRC structure and the same data model data definitions Copy data definition files The data definition files are located in the directory which was specified by means of the Maintain Package Combinations ttaad1120m000 session in the TRITON 3 environment The target directory of the TMP 001 package combination can be determined by means of the same session in the BAAN IV environment If the TRITON 3 and BAAN IV environments are located on the same system the Copy datadef files from 3 1 to Temporary Package Combination ttcon2140m000 session must be used to copy the data definition files of the 001 operational package from TRITON 3 to the 001 temporary package combination in BAAN IV ttcon2140m000 single occ 4 Form 1 1 Copy datadef files from 3 1 to Temporary Package Combination BSE environment 3 1 usrl TRITON6 bse Package Comb 3 1 environment OPER 001 Temporary Package Combination TMP 001 Choice If the TRITON 3 and BAAN IV environments are located on different systems there are two options to copy the d
54. Type of message Possible actions 7 2 19 7 2 20 7 2 21 7 2 22 7 Appendix B Troubleshooting Message 19 Conversion error mcs047 ckon lt mcs047 ckon gt mcs047 grno mcs047 grno This message informs you that the table tcmcs047 has a physical database problem for example it is corrupted The purpose of this conversion is to update the first free numbers for proforma sales invoices Error Use the key value printed in the error message to check the table manually Message 20 Conversion error edi005 mess lt tcedi005 mess gt This message informs you that the table tcedi005 has a physical database problem for example it is corrupted The purpose of this conversion is to update the names of libraries used within EDI Error Use the key value printed in the error message to check the table manually Message 21 Conversion error pur002 opol lt pur002 qono gt lt pur002 pono gt This message informs you that the table tdpur002 has a physical database problem for example it is corrupted The purpose of this conversion is to update the order policy field in table pur002 Error Use the key value printed in the error message to check the table manually Message 22 Conversion error pur011 0pol lt pur011 qono gt lt pur011 pono gt This message informs you that the table tdpur011 has a physical database problem for example it is corrupted The purpose of this conversion is to
55. able by running setbse After the validation process log on as bsp again and start the bshell Never give the Baan default password to customers Choose menu options 6 Maintain Security Code Validation Key ttiex3102m000 Enter the customers data from the printout of commercial information for this customer For Baan NL customers place a 2 before the customer number All the other information can be found on the customer data printout 2 Maintain Requested System Configuration Tools ttiex3101m000 Type S to enter the correct date Then type C to edit the screen Enter the data provided in the commercial printout Do not make any changes 1 Maintain Requested System Configuration ttiex3100m000 For BAAN IVa enter Yes for all entries for all packages Press N to go to the next page Ctrl N to go to the next package For BAAN IVb only special items t103 Development Tools have to be set to Yes when they are bought and not the entire software configuration as in BAAN IVa 3 Print Requested System Configuration Press Y Enter D Display or ASCIF ASCII file by default this file will be placed in the current directory In the latter case choose a logical file name If applicable read in the file via a subshell Conversion TRITON 3 to BAAN IV BddN 4 Converting to BAAN IV the single environment scenario Note 4 3 17 Provide this printout to Baan This will be
56. alue printed in the error message to check the table manually Message 10 Conversion error sst030 sstr lt sst030 str gt This message informs you that the table tdsst030 has a physical database problem for example it is corrupted Error Use the key value printed in the error message to check the table manually Message 11 Conversion error pst010 sstr lt pst010 sstr gt This message informs you that the table tdpst010 has a physical database problem for example it is corrupted Error Use the key value printed in the error message to check the table manually Message 12 Conversion error pst015 sstr lt pst015 sstr gt This message informs you that the table tdpst015 has a physical database problem for example it is corrupted Error Use the key value printed in the error message to check the table manually Message 13 Conversion error pst018 sstr lt pst018 sstr gt This message informs you that the table tdpst018 has a physical database problem for example it is corrupted Error Use the key value printed in the error message to check the table manually Conversion TRITON 3 to BAAN IV BddN 7 Appendix B Troubleshooting m 7 2 14 Message 14 Conversion error pst020 sstr lt pst020 sstr gt This message informs you that the table tdpst020 has a physical database problem for example it is corrupted Type of Error message Aesan Use the key value
57. ames for the Exchange objects Import log file and Sequential files This path must refer to the directory in which the tables dumps of TRITON 3 0 reside Use the Create Import Scripts tuxch0227m000 session to compile all condition scripts Create all BAAN IV tables for the second Company the company for the coversion results Enter the Company data for the Company for the conversion results by using the session Maintain Companies tccom0100m000 Run the conversion program Import data tuxch0223m000 The Overrule batch Company option must be set to Yes and the Company number must be the Company for the Conversion results If you have customizations run the session Copy Exchange Scheme tuxch0201m000 to copy the entire Exchange Scheme Use the session Create Runtime Data Dictionary ttadv5120m000 for the Package Combination with Conversion results The referential integrity will become active All references must be checked and built up using the session Reorganize Tables ttaad4225m000 Checking the conversion This section only describes the major changes which are essential for the consistency of the new Service environment To describe all the changes is too time consuming but you can use session Print Field Relations Import tuxch0422m000 to print the field relations Conversion TRITON 3 to BAAN IV 5 12 BAAN 5 Correction program and checking the conversion both scenarios The following tables are co
58. ase problem for example it is corrupted The purpose of this conversion is to fill the procedure mask rate and rate factor in sls045 Type of Error message ne Use the key value printed in the error message to check the table manually actions 7 2 36 Message 36 Conversion error sls051 orno sls051 0rno sls051 trdt lt sls051 trdt gt sls051 trtm lt sls051 trtm gt This message informs you that the table 515051 has a physical database problem for example it is corrupted The purpose of this conversion is to fill the procedure mask rate and rate factor in 515051 Type of Error message ony Use the key value printed in the error message to check the table manually actions 7 2 37 Message 37 Conversion error com999 sern lt tccom999 sern gt This message informs you that the table tccom999 has a physical database problem for example it is corrupted The purpose of this conversion is to fill com999 from table mcs095 Type of Error message Use key value printed in the error message to check the table manually actions Conversion TRITON 3 to BAAN IV BAAN Type of message Possible actions Type of message Possible actions Type of message Possible actions Type of message Possible actions 7 2 38 7 2 39 7 2 40 7 2 41 7 Appendix B Troubleshooting Message 38 Conversion error mcs042 blcs blocking stepno not in procedure In TRITON 3 th
59. ata definition files The first option is to manually transfer the data definitions to the new system This means that the existing data definitions in the temporary 001 BAAN IV package combination are removed after which the TRITON 3 data definition files are transferred or copied to the BAAN IV system Conversion TRITON 3 to BAAN IV 3 8 BAAN 3 4 3 3 4 4 3 4 5 3 4 6 3 Converting to BAAN IV two environments scenario In the example below a tape is used to transfer this data to the BAAN IV system System TRITON 3 installed in TRITON bse Dictionary installed in TRITON dict Operational Package Combination OPER_001 System II BAAN IV installed in baaniv bse Dictionary installed in baaniv dict Operational Package Combination TMP_001 Step 1 Copy the data dictionary files to tape Login as root on system cd TRITON dict ddOPER_001 find print cpio ocvudB gt dev lt device gt device of your own system for AIX rmtO or rmt1 for HP rmt Om Step 2 Login as root on system II Put the tape from system into the tapestreamer of system II cd baaniv dict ddTMP_001 rm r d remove all existing data in this directory cpio icvudB lt dev lt device gt device of your own system for AIX rmtO or rmt1 for HP rmt 0m chown R bsp bsp d setting permissions The other option is to mount the system with the TRITON 3 environment on the BAAN IV system after which the pro
60. ate test user s ttaad2200m000 Y convert to runt DD ttaad4200m000 leave bshell and start bshell again 4 Converting to BAAN IV the single environment scenario Figure 4 2 of 3 Converting to BAAN IV the single environment scenario BddN Conversion TRITON 3 to BAAN IV 4 3 4 Converting to BAAN IV the single environment scenario dump forms amp menus ttadv5214m000 Y compile reports ttadv3240m000 patch the software ttiex3225m000 maintain audittables ttaad41 11 ttaad4116 create tables ttaad4230m000 run parameters tcmcs0295m000 O VRC s tandard DM2 adapt DataModel O VRC s to BAANIV adapt correction pro gram to O VRC s correction program tccov0000m000 Set tbase back to tbase tp if required start test and accep tance procedures Figure 4 3 of 3 Converting to BAAN IV the single environment scenario Conversion TRITON 3 to BAAN IV Ut BAAN m 4 Converting to BAAN IV the single environment scenario 4 2 Preparation 4 2 1 Backup The customer must have a good recent backup of the software and the tables 4 2 2 TRITON While the installation script is running the customer cannot use TRITON Furthermore you must run correction programs before companies migrated to BAAN IV can be used for testing 4 2 3 Time frame The time frame of the update very much depends on the system and database types Assuming that the installation script is started
61. been used the bshell must be restarted after this session is closed Change Package Combination for Users ttaad2200m000 This session is used to link the users to the new operational BAAN IV package combination which is referred to as OPER 001 Convert User Data to Runtime Data Dictionary ttaad4200m000 This session is used to convert the modified user data to the run time data dictionary After this session has been used the bshell must be restarted Use a user name which is linked to the 001 operational package combination Conversion TRITON 3 to BAAN IV BddN 3 Converting to BAAN IV two environments scenario m 3 444 Maintain Package Combinations ttaad1120m000 This session is used to delete the 001 temporary package combination This is done by means of the Delete option on the Edit menu 3 4 15 Create Tables ttaad4230m000 This session is used to create the new BAAN IV tables for specific companies and tables 3 4 16 Reorganize Tables ttaad4225m000 This session is used to repair the reference counters of the imported tables Do this for all involved companies by entering the following fields Data and Indices No Reference Integrity field to Yes Repair Reference Counters field to Yes other fields No In addition the errors in the BSE log log aad4225 logfile must be checked Since the approximately 200 tables that were added to BAAN IV are not yet available the No DD Found For messa
62. cedure for two environments on the same system Maintain Companies ttaad1100m000 This session is used to define the companies which must be converted without creating the tables These companies are linked to the temporary package combination by means of the Package Combination field Assign Tables to Databases ttaad4111m000 This session is used to check the data definitions Any changes which were made in this session must be converted to run time prior to exiting the session Maintain Table Directories BAAN Base TP ttaad4115m000 This session is used to check the table directories These table directories must refer to the new path for the BAAN IV tables that must be converted from TRITON 3 Any changes that were made in this session must be converted to run time prior to exiting the session This is an optional session which is used for the BAAN Base database program tbase or tbase tp Consequently this session must not be used for Oracle or Informix databases Maintain Logical Tables ttaad4120m000 This session is used to define the logical companies This data can also be exported and imported by means of the Export Users Authorizations Devices Currencies Logical Tables ottcon61export session and the Import Users Authorizations Devices Currencies Logical Tables ttcon61import session Conversion TRITON 3 to BAAN IV BddN ds 3 Converting to BAAN IV two environments scenario m 3 4 7 3 4 8 Maintain Us
63. contains a matrix that gives an insight in which conversion programs are used converting to BAAN IVb coming from release 3 Note the following points There is no conversion required for the extensions sch nl1 that are not mentioned in the table below There is no conversion required for the packages tt tc cp ps that are not mentioned in the table below No conversion is required for T3 x extension CMS import export All package related conversion programs are included and automatically executed by conversion program tccov0000m000 BAAN Conversion TRITON 3 to BAAN IV 5 1 5 Correction program and checking the conversion both scenarios Release T30b T30b1 T31a T31a1 T31b T31b2 B4a tccov3001 tccov3002 tccov3003 tccov3004 tccov3001 tccov3002 tccov3003 tccov3004 tccov3002 tccov3003 tccov3004 tccov3002 tccov3003 tccov3004 tccov3002 tccov3003 tccov3004 tccov3002 tccov3003 tccov3004 tccov1001 tccov1002 tccov5001 tccov2001 tccov2002 tccov2003 tccov2004 tccov2005 tccov2006 tccov3005 otfcor0260 otfcor0261 tccov5001 tccov2003 tccov2004 tccov2005 tccov2006 tccov3005 otfcor0260 otfcor0261 tccov5001 tccov2001 tccov2002 tccov2003 tccov2004 tccov2005 tccov2006 tccov3005 otfcor0260 otfcor0261 tccov1002 tccov5001 tccov2003 tccov2004 tccov2005 tccov2006 tccov3005 otfcor0260 otfcor0261 tccov1002 tccov5001 tccov2006 tfcor0300 tccov3005 o
64. cpr320 Cost Price Surcharge Bases by Effective Date ticpr330 This will only be done if the parameter CPR 3101 is not present in Statuses The value of the Drawing field in the Engineering Item Revisions table is deleted The drawing code can be empty because the user did not have the functionality before The ECO Lines table is set to the initial value of the data definition For all records in ECO Lines tiedm320 field Replace Type tiedm320 korp will become multiplication tiedm korp multiplication The Device for Messages in Generate MPS parameter is set to the initial value of the data definition The Only Reschedule Messages for Total Order Quantity parameter is set to the initial value in the data definition Effective Data of the Bill of Critical Capacity is set to 01 01 1990 if the date field was left empty The value of the Finance Company field in the Planned MPS Interplant Orders Planned MPS Purchase Orders and Planned MRP Purchase Orders tables is entered The value of the Financial Supplier Group field in the Financial Project Transactions table is deleted The horizon for the company calendar will be set to 50 days in the past and 500 days into the future Conversion Units to Units by Unit Sets tccov3002m000 Because of the new way in which alternative units are handled the following tables are converted and modified by means of this session Conversion TRITON 3 to BAAN IV 5 8 BAAN Note
65. ctiontype gt lt document gt linenumber payment difference 7 18 Conversion TRITON 3 to BAAN IV ix Conversion TRITON 3 to BAAN IV 7 9 7 10 Conversion TRITON 3 to BAAN IV 7 8 4 Message 1 END OF CONVERSION 7 18 tccov3001m000 Converting Manufacturing 3 1 to BAAN IV 7 18 7 9 1 Message 1 START OF CONVERSION tccov3001m000 by user login name 7 19 7 9 2 Message 2 END OF CONVERSION 7 19 tccov3002m000 Conversion Units to Units by Unit Sets 7 19 7 10 1 Message 1 START OF CONVERSION tccov3002m000 by user login name 7 19 7 10 2 Message 2 END OF CONVERSION 7 19 7 10 3 Message 3 tiitm001 item code unit set units 7 20 7 10 4 Message 4 tiitm002 item group unit set units 7 20 7 10 5 Message 5 tipcs021 project code item code unit set units 7 20 7 10 6 Message 6 tipcs002 lt budget code gt lt calculation part gt lt unit set gt units 7 20 7 10 7 Message 7 tiedm010 lt enginering item gt lt unit set gt lt units gt 7 20 7 10 8 Message 8 tppdm025 equipment code unit set7 copied from itm001 unit 7 20 7 10 9 Message 9 tppdm025 lt equipment code gt Error unit not in unit set of itm001 7 21 7 10 10 Message 10 tppdm025 equipment code unit set units 7 21 7 10 11 Message 11 tppdm035 subcontracting code unit set copied from itm001 unit 7 21 7 10 12 Message 12 tppdm035 subcontracting code unit set7 copied from itm00
66. ctor 1 0 7 30 7 11 15 Message 15 No units present 7 30 7 11 16 Message 16 base unit physical quantity lt description gt not known conversion factor 1 0 7 31 7 11 17 Message 17 domain lt domain name gt has no enumerated values 7 31 7 11 18 Message 18 Error lt error code gt in qss search lt search mode gt lt search argument gt lt table gt definition lt number gt 7 31 7 11 19 Message 19 Error lt error code gt in qss sort table definition lt number gt 7 31 7 11 20 Message 20 END OF CONVERSION lt number conflicts gt CONFLICTS FOUND 7 31 7 11 21 Message 21 END OF CONVERSION NO CONFLICTS 7 31 BAAN BAAN Conversion TRITON 3 to BAAN IV About this document This document explains how to convert TRITON 3 to BAAN IV Two scenarios are possible one in which the BAAN IV and TRITON 3 environment exist next to each other for a period of time two environments scenario and one in which the TRITON 3 environment is updated to BAAN IV single environment scenario Chapter describes a number of general issues regarding the conversion from TRITON 3 to BAAN IV These issues include the scope of the document its target group the two scenarios and a number of remarks and recommendation that you must take into account before running the actual conversion After reading this chapter and studying the flowcharts you can decide which scenario to apply You will also have an understandin
67. dpur036 has a physical database problem for example it is corrupted The purpose of this conversion is to fill the unit field in pur036 Error Use the key value printed in the error message to check the table manually Message 26 Conversion error pur037 cplp lt pur037 cplp gt pur037 item lt pur037 item gt pur037 cntr lt pur037 cntr gt pur037 dile lt pur037 dile gt This message informs you that the table tdpur037 has a physical database problem for example it is corrupted The purpose of this conversion is to fill the unit field in pur037 Error Use the key value printed in the error message to check the table manually Message 27 Conversion error inv300 orno lt tdinv300 orno gt This message informs you that the table tdinv300 has a physical database problem for example it is corrupted The purpose of this conversion is to fill the planner field in inv300 Error Use the key value printed in the error message to check the table manually Conversion TRITON 3 to BAAN IV 7 8 Type of message Possible actions Type of message Possible actions Type of message Possible actions Type of message Possible actions Type of message Possible actions 7 2 28 7 2 29 7 2 30 7 2 31 7 2 32 7 Appendix B Troubleshooting Message 28 Conversion error inv310 orno lt tdinv310 orno gt This message informs you that the table tdinv310 has
68. ecorded if it has been converted Information No action required Message 4 Selection expression lt tdsmi070 cnsc gt converted This message informs you that selection expressions in tdsmi070 are converted For each selection expression in tdsmi070 is recorded if it has been converted Information No action required Message 5 Recommended Purchase Order lt tdinv310 orno gt converted This message informs you that the company number in tdinv310 is filled with supplier s company For each recommended Purchase Order in tdinv310 it is recorded if it has been converted Information No action required Conversion TRITON 3 to BAAN IV BddN n 7 Appendix B Troubleshooting m Type of message Possible actions Type of message Possible actions Type of message Possible actions Type of message Possible actions Message 6 Outgoing Message lt tcedi700 mess gt converted This message informs you that the parent relation field in tcedi700 is filled For each outgoing message in tcedi700 it is recorded if it has been converted Information No action required Message 7 Batch Number lt tcedi720 bano gt converted This message informs you that tcedi720 is filled with values from tcedi701 For each batch number in tcedi720 it is recorded if it has been converted Information No action required Message 8 Company Purchase Order lt tdpur045 orno gt
69. ed The technical area which consists of the directories on a system used by the programs The conversion of all company data to a new format The conversion and upgrade of general or in house customized software components to a new version The Version Release Control VRC module in BAAN Tools is used to manage different versions and releases of a package There are 4 types of VRCs L localizations B line of business specific software C general customizations O in house customizations For more information on the tools and utilities that can be used in the conversion procedure of customized software see the following documents BAAN New Functions in BAAN IV 5972 US New Functions in BAAN IVb P3000C US BAAN Utilities User Manual 5569 US Component Merge Tool CMT module Module Description 7195 US Installation Guide for BAAN IV on Unix U7016A US ORACLE Installation Guide for BAAN IV U7028B US INFORMIX Installation Guide for BAAN IV U7029A US DB2 6000 Installation Guide for BAAN IV U7030A US BAAN Tools User Manual 5564 US Conversion TRITON 3 to BAAN IV 1 5 1 Introduction m Conversion TRITON 3 to BAAN IV lt BAAN 2 Preparing TRITON 3 for conversion the two environments scenario This chapter describes the steps needed to prepare TRITON 3 for the conversion to BAAN IV 2 1 Steps in the procedure The following steps can be distinguished to prepare software components for conversion 1 General
70. ed The following tables are converted tdpst010 PURCHASE Statistics Master File Turnover tdpst015 PURCHASE Statistics Master File Order Intake tdpst018 PURCHASE Statistics Master File Cancellations tdpst020 PURCHASE Statistics Compression Turnover tdpst025 PURCHASE Statistics Compression Order Intake tdpst028 PURCHASE Statistics Compression Cancellations tdpst030 PURCHASE Statistics Sort File Key File tdpst050 PURCHASE Budgets tdsst010 SALES Statistics Master File Turnover tdsst015 SALES Statistics Master File Order Intake tdsst018 SALES Statistics Master File Cancellations tdsst020 SALES Statistics Compression Turnover tdsst025 SALES Statistics Compression Order Intake tdsst028 SALES Statistics Compression Cancellations tdsst030 SALES Statistics Sort File Key File tdsst050 SALES Budgets Conversion TRITON 3 to BAAN IV 5 7 5 Correction program and checking the conversion both scenarios BAAN Manufacturing Conversion of Manufacturing 3 1A gt BAAN IV tccov3001m000 By using this session a number of fields and tables are modified namely Note 5 2 2 The surcharge history is created based on the following tables Cost Price Surcharges by Item and Cost Price Component ticpr220 Cost Price Surcharge Bases by Item and Cost Price Component ticpr230 Cost Price Surcharges by Item and Effective Date ti
71. ed in with tiitm001 cupp If tiitm001 cupp is empty then tdsls037 cuni will be filled in with tiitm001 cuni The tdslsO37 kogr must be equal to tckogr quantity otherwise the field will not be converted Sales Deliveries The Currency Rate Sales and the Rate Factor are copied from the Order Header The field tdsls045 ratf will be filled in with tdsls040 ratf tdsls045 rats with tdsls040 rats and tdsls045 pmsk will be 20 positions instead the 15 positions in the source field the 5 new positions will be nnnnn Sales Order Line History The Currency Rate Sales and the Rate Factor are copied from the Order Header The field 451505 1 will be filled in with tdsls050 ratf tdsls051 rats with tdsls050 rats Inventory Control Planned INV Production Orders Planned INV Purchase Orders The Planner is copied from the item table tiim001 for the order s item The fields tdinv300 cplb and tdinv310 cplb will be filled in with the tiitm001 cplb Replenishment Order Control Replenishment Order Types The Order Procedure is filled in with the Replenishment Order Procedure from the TOC Parameters trtoc000 The field tdrpl004 cpro will be filled in with trtoc000 cprr The Order Series are filled in with the Order Series from the linked Order Procedure trtoc030 The field tdrpl004 orse will be filled in with trtoc030 orse The link is done via tdrpl004 cpro Conversion TRITON 3 to BAAN IV 5 6 BAAN 5 Correction program and c
72. egration to TRITON Distribution and unit of project subcontracting in tppdm635 is NOT found in the already generated unit set Error Add unit of project subcontracting to a unit set and run this program again Conversion TRITON 3 to BAAN IV 7 22 BAAN Type of message Possible actions Type of message Possible actions Type of message Possible actions Type of message Possible actions Type of message Possible actions 7 10 19 7 10 20 7 10 21 7 10 22 7 10 23 7 Appendix B Troubleshooting Message 19 tppdm635 lt project gt lt subcontracting code gt lt unit set gt lt units gt Message will be logged for each project subcontracting in tppdm635 when there is NO integration to TRITON Distribution and unit is not found in an already existing unit set Information No action required Message 20 tppdm605 lt project gt lt project item gt Error item not in pdm625 Error message will be logged when equipment of a project item in tppdm605 is not found in tppdm625 Error Add equipment with the currect unit to tppdm625 and run this program again Message 21 tppdm605 lt project gt lt project item gt Error item not in pdm635 Error message will be logged when subcontracting of a project item in tppdm605 is not found in tppdm635 Error Add subcontracting with the currect unit to tppdm635 and run this program again Message 22 tppdm605 lt project gt lt
73. ences Preparing TRITON 3 for conversion the two environments scenario Steps in the procedure General 2 2 1 Checking the consistency of the TRITON 3 data 2 2 2 Create a backup of the TRITON software and data 2 2 8 Export Users Authorizations Devices Currencies Logical Tables ottcon6lexport Software export 2 3 1 Export Data Dictionary ttiex1280m000 Data export 2 4 1 General data export 2 4 2 Database specific data transfer Converting to BAAN IV two environments scenario Steps in the procedure General 3 2 1 Import Users Authorizations Devices Currencies Logical Tables ttcon61import Software conversion 3 3 1 Import Data Dictionary ttiex1285m000 3 3 2 Maintain Packages by Package Combination ttaad1121m000 Data conversion 3 4 1 Copy Package Combination ttaad1220m000 3 4 2 Copy data definition files 3 4 3 Maintain Companies ttaad1100m000 3 4 4 Assign Tables to Databases ttaad4111m000 3 4 5 Maintain Table Directories BAAN Base TP ttaad4115m000 3 4 6 Maintain Logical Tables ttaad4120m000 3 4 7 Maintain User Data ttaad2100m000 3 4 8 Data import 3 4 9 Check Tables ttaad4232m000 3 4 10 Convert 3 0 3 1 Tables to BAAN IV ttaad1102m000 3 4 11 Check Tables ttaad4232m000 3 4 12 Change Package Combination for Users ttaad2200m000 1 1 1 1 1 1 1 1 1 1 1 3 1 3 1 3 1 4 1 4 1 4 1 5 1 5 2 1 2 1 2 3 2 3 2 3 2 4 2 5 2 5 2 5 2 6 2 6 3 1 3 1 3 6 Conversion TRITON 3 t
74. enerated Conversion from BAAN IVa to BAAN IVb tccovl999m000 5 7 Removing the 3 x software after the conversion 6 6 1 6 2 6 3 6 4 7 7 1 7 2 BddN Appendix A Upgrading customizations Recommendations Print differences between two PVRCs Upgrade of in house customizations Upgrading customized software and in house customizations Appendix B Troubleshooting Conversion of Distribution 3 1 to BAAN IV tccov1001m000 7 1 1 Message 1 START OF CONVERSION 1001 000 by user lt logon name gt 5 15 5 16 5 16 5 16 5 17 5 17 5 17 5 18 5 18 5 18 5 18 5 18 5 19 5 19 5 19 5 19 6 1 6 1 6 1 6 1 6 3 7 1 7 1 7 1 7 1 2 Message 2 END OF CONVERSION 1001 000 by user logon name gt 7 1 7 1 3 Message 3 Letter layout tdsmil150 clet converted 7 1 4 Message 4 Selection expression lt tdsmi070 cnsc gt converted 7 1 5 Message 5 Recommended Purchase Order lt tdinv310 orno gt converted 7 1 6 Message 6 Outgoing Message lt tcedi700 mess gt converted 7 1 7 Message 7 Batch Number lt tcedi720 bano gt converted 7 1 8 Message 8 Company Purchase Order lt tdpur045 orno gt lt tdpur045 pono gt lt tdpur045 srnb gt converted 7 1 9 Message 9 Financial Customer Group Sales Order lt tdsls040 orno gt converted Conversion of Distribution 3 1 to BAAN IV tccov1002m000 7 2 1 Message 1 START OF CONVERSION tccov1002m000 by use
75. er Data ttaad2100m000 This session is used to link the logon name of the user who executes the conversion to the 001 temporary package combination Any changes that were made in this session must be converted to run time prior to exiting the session In addition the bshell must be restarted Data import There are two ways in which the company data can be imported in or transferred to the new BAAN IV environment namely by means of a general data import or by means of a database specific data transfer General data import The Create Table from Sequential Dump ttaad4227m000 session can be used independently of any database to import the TRITON 3 tables from the old environment into the BAAN IV environment This import must be executed in the 001 temporary package combination For this type of import set the All Parameters field to No and set the Ignore Referential Integrity Constraints field to Yes On the second form of this session the file name for the error log file must be specified Database specific data transfer A database specific data transfer is a faster conversion method than the general export option There are different types of database specific data transfers depending on the database type TBASE or TBASE TP The database tables for TBASE and TBASE TP must be copied to the BAAN IV environment and registered in BAAN IV For TRITON 3 0 and TRITON 3 1 different steps are necessary TRITON 3 1
76. ere was one system parameter in which the order step was defined at which sales orders must be blocked In BAAN IV the blocking step is not defined at system level but at order type level The blocking step must be an existing step in the order procedure Due to the fact that in Triton3 it was a system parameter it is very well possible that the blocking step is not an existing step in the concerning order procedure of the order type In this case the blocking step at order type level is left empty Error No action required during conversion During conversion no action After conversion you must manually check and fill the blocking step of the order types mentioned in the error report Message 39 Conversion error tcemcs042 pmsk tcmcs042 cotp lt tcmcs042 pmsk gt This message informs you that the table table tcemcs042 has a physical database problem for example it is corrupted The purpose of this conversion is to fill procedure mask in mcs042 Error Use the key value printed in the error message to check the table manually Message 40 Conversion error tdrpl004 pmsk lt tdrpl004 cotp gt lt tdrpl004 pmsk gt This message informs you that the table table tdrpl004 has a physical database problem for example it is corrupted The purpose of this conversion is to extend the procedure mask field in rpl004 Error Use the key value printed in the error message to check the table manually Message 41 Conversio
77. ex1280m000 alphanum single occ 4 Export Data Dictionary Package TRITON Common VRC S die a cv02 Challenge 3 0 Update Compared with VRC Export Based on Sessions Only components of package itself Session from to IAIA Languages H 2 32 Deliver Session from Status Developing Create Components List Yes Errors to Printer 5 wes Path Dumps usrl triton6 bse export tc hostes 2 4 Data export There are two ways in which the company data can be exported or transferred to the new BAAN IV environment namely by means of a general data export or by means of a database specific data transfer Conversion TRITON 3 to BAAN IV BddN s 2 Preparing TRITON for conversion the two environments scenario 2 4 1 General data export The Create Sequential Dump of Table ttaad4226m000 session can be used independently of any database to create a sequential dump of the database tables ttaad4226m000 single occ 4 Create Sequential Dump of Table Company Package Table Suppress Error Messages Recover Isam File Drop Table after Dump Create Backup before Dropping Specify Database Driver Create Fixed Length Records Specify Field Separators Directory for Table Files Basic Name for Dump File s tmp dump Name of the Error File 100 error Name of the dumpfile s will be tmp dump lt company gt The advantage of this approach is that the company data remain operational The d
78. f you do not do so the conversion will fail Define the proper parameters for Common by using the session temcs0100m000 Define the proper parameters for ITM by using the session tiitm0100m000 Now turn to the next chapter for performing the final step running the correction program for the test company companies Conversion TRITON 3 to BAAN IV BddN id 4 Converting to BAAN IV the single environment scenario Conversion TRITON 3 to BAAN IV us BAAN Note 5 1 Correction program and checking the conversion both scenarios This chapter describes the conversion process of TRITON version 3 to BAAN IV It also supplies a conversion matrix in which the different conversion programs used for the TRITON BAAN IV packages are listed The second section of this chapter describes the correction program that has to be run for both scenarios for the test companies Note that the Conversion of TRITON 3 x gt BAAN IV tccov0000m000 session has to be adapted to the possibly customized data model of BAAN IV in case this is not standard see section 1 3 2 The third section describes the sessions needed by package to perform a general and a specific data check after the conversion has taken place The procedure described in section 5 5 4 Data conversion from BAAN IVa to BAAN IVb must always be followed even if you are converting a TRITON 3 x version to BAAN IVb Conversion matrix release 3 release 4 This section
79. forms and menus ttadv5214m000 Use this session to convert the forms and menus associated with the migrated own work if available to run time 13 Application Development 15 Run time Data Dictionary 4 Create Run time Data Dictionary forms and menus Set the Dump field to 1 default Conversion TRITON 3 to BAAN IV Important note 4 3 15 4 3 16 4 Converting to BAAN IV the single environment scenario Step 15 Own Compile reports ttadv3240m000 Use this session to compile the reports associated with the migrated own work if available 13 Application Development 10 Reports 2 Compile Reports Set the Compile field to 1 default During compilation an error report is generated Check this report All warnings can be ignored If there are any errors the normal procedure is to check if they also occurred in the old version by compiling the old own work via the old package combination using the same session If the errors are identical in both versions there is a problem with the original functionality However this is not possible now because the TRITON 3 environment s tools are now of the version B40 release Step 16 Validate the system Get a printout of the commercial tools functions the customer has bought Validation of the toolset can only take place when logging on to the customer system as root or using the su command Do not forget to set the environment vari
80. found in the already generated unit set Error Add unit of equipment to a unit set and run this program again Message 10 tppdm025 lt equipment code gt lt unit set gt lt units gt Message will be logged for each equipment in tppdm025 when there is NO integration to TRITON Distribution and unit is not found in an already existing unit set Information No action required Message 11 tppdm035 lt subcontracting code gt lt unit set gt copied from itm001 lt unit gt Message will be logged when unit of subcontracting tppdm035 is found in the already generated unit set Information No action required Message 12 tppdm035 lt subcontracting code gt lt unit set gt copied from itm001 lt unit gt Error message will be logged when there is an integration to TRITON Distribution and unit of subcontracting in tppdm035 is NOT found in the already generated unit set Error Add unit of subcontracting to a unit set and run this program again Message 13 tppdm035 lt subcontracting code gt lt unit set gt lt units gt Message will be logged for each subcontracting in tppdm035 when there is NO integration to TRITON Distribution and unit is not found in an already existing unit set Information No action required Conversion TRITON 3 to BAAN IV BddN 5 7 Appendix B Troubleshooting m Type of message Possible actions Type of message Possible actions Type of message Possible actions
81. g of the tasks which have to be performed and their consequences Chapter 2 describes the steps needed to prepare TRITON 3 for the conversion to BAAN IV according to the two environments scenario Chapter 3 describes the steps needed to convert the prepared software components and data from TRITON 3 to BAAN IV according to the two environments scenario Chapter 4 describes the steps needed to update the TRITON 3 environment to BAAN IV and to perform the data conversion according to the single environment scenario Chapter 5 describes the last step of the conversion for both the two and the single environment scenarios and the sessions needed to perform a data check after the conversion Appendix A describes the steps needed to upgrade both external and in house customizations Appendix B supplies a list of error messages Conversion TRITON 3 to BAAN IV xiii Conversion TRITON 3 to BAAN IV BAAN Note 1 Note 2 1 1 1 2 1 3 1 3 1 Introduction This chapter describes a number of general issues regarding the conversion from TRITON 3 to BAAN IV Scope This document explains how you can convert TRITON 3 to BAAN IV It does not explain the concept of VRC structures and does not provide extensive help information on how to upgrade general or in house customizations C VRCs and O VRCs respectively Target group This document can be used both by Baan conversion teams and by Baan customers For a fla
82. g the in house customization OPER 001 DSGN 001 tdB40_b2 tdB40C_b2_cu01 itdB400_b2_cu01 dB40O b2 cu02 Figure 6 9 Released software Prior to converting the data the data model in BAAN IV must be assessed as being the correct data model and the correction program tecov0000m000 has to be adapted to this Conversion TRITON 3 to BAAN IV di BAAN Type of message Possible actions Type of message Possible actions Type of message Possible actions Type of message Possible actions Type of message Possible actions 7 1 Appendix B Troubleshooting This appendix contains a listing of messages and errors you may encounter during the conversion of TRITON 3 to BAAN IV Conversion of Distribution 3 1 to BAAN IV tccov1001m000 This section lists the messages that can be displayed during the conversion of Distribution 3 1 to BAAN IV tccov1001m000 Message 1 START OF CONVERSION tccov1001m000 by user lt ogon name gt This message informs you about the start date and time of the session by the specified user Information No action required Message 2 END OF CONVERSION tccov1001m000 by user lt ogon name gt This message informs you about the end date and time of the session Information No action required Message 3 Letter layout lt tdsmi150 clet gt converted This message informs you that letter layouts in tdsmi150 are converted For each letter layout in tdsmi150 is r
83. ge will appear several times Conversion TRITON 3 to BAAN IV Hind BAAN 4 Converting to BAAN IV the single environment scenario This chapter describes the steps needed to convert the prepared software components and data from TRITON 3 to BAAN IV 4 1 Steps in the procedure The following steps can be distinguished in converting the TRITON 3 data and software to BAAN IV 1 Preparation 2 Installation procedure Each of these main steps may consist of a number of additional steps The following flowcharts outline the conversion Conversion TRITON 3 to BAAN IV BAAN zm 4 Converting to BAAN IV the single environment scenario create full backup plan to adjust correc tionprogram to O DM have correctionprogram adjusted to DataModel Yes set tbase_tp to tbase Oracle AND during the conversion set driver Level 1 in BSE lib defaults read out the tape s check tabl 000 testc ttaad4225m000 Y run rc stop and rc start run installation script check installation log s Figure 4 1 of 3 Converting to BAAN IV the single environment scenario Conversion TRITON 3 to BAAN IV idi BAAN import B C VRC s ttiex1285m000 create new VRC s ttadv1111m000 create directories ttadv1115m000 copy O VRC s ttadv6265m000 create test PC ttaad1120m000 fill PC with VRC s ttaad1121m000 migrate test company ttaad1101m000 Y check tables testc ttaad4232m000 migr
84. ger that TRITON cannot be used during the update Check at least the tables for company 000 and also the test company companies before you start the conversion You can do this by using the Reorganize tables ttaad4225m000 session Use is made of the path data in BSE lib install install data It is advisable to check them before installation First run the rc stop script and then the rc start script to remove any hanging processes and database locks If rc stop fails shut down the environment manually Log in as root do not use the su command Check your TERM variable echo TERM The vt220 emulation cannot be used use vt100 instead Before you start the install6 1 script you must check if the object oiex1288 resides in the directory line 000 tttiex If not you must create this directory and copy oiex1288 from the install directory into it Go to the installation directory and start the install6 1 script via install6 1 The script only prompts you for the BSE directory enter the BSE directory of the TRITON 3 environment to be updated Upon reading the question Full update enter Yes mandatory The installation script first calls ottiex1287 then calls reconfiguring the tools tables and then calls ottiex1288 Under bisam it takes about 30 minutes to reach this point Once the installation script reaches ottiex1288 the rest of the installation will probably run smoothly Conversion TRITON 3 to BAAN IV BddN
85. hecking the conversion both scenarios TRITON Common Order Types The Series are filled in with the Order Series from the linked Order Types trtoc030 The field temcs042 cpro will be filled in with trtoc000 cprs on condition that temcs042 modc is equal to tcemodc sls Else temcs042 cpro will be filled in with trtoc000 cprp Next the Order Procedure is filled in with Purchase or Sales Order Procedure dependent of the value for Purchase Sales from the TOC Parameters trtoc000 The field tcmcs042 orse will be filled in with trtoc030 orse The link is done via tcmcs042 cpro COM Parameters Table tccom999 will be filled in with the corresponding fields from the Parameters temcs095 The following fields will be converted tccom990 crtf tccom999 bnch tccom990 trtr tccom990 rttr tccom990 aust 7 tccom990 ecvr 7 tccom990 sitm 7 tccom990 sci 7 Order Types The blocking Order Step is copied from the Parameters temcs095 The blocking order step from tcmcs095 will be copied to all records in tcmcs042 blcs Procedure Masks The Procedure Mask for each Order Type Purchase Sales Replenishment Purchase Delivery and Replenishment Order Line is extended from 15 positions to 20 with nnnnn The field temcs042 pmsk will be filled in with 15 times n Purchase and Sales Statistics BddN The Primary Key Field is changed The domain length of the fields which compose the primary key field is chang
86. hich is converted the user who performed the conversion and the number of times the conversion has been started is displayed Log files are created in the directory BSE log containing the output of the conversion sessions These log files must be checked For an explanation of the output of the conversion sessions refer to Appendix B For the different packages the following sessions are executed to correct or convert the tables to BAAN IV if applicable BAAN Distribution tccov1001m000 conversion of distribution 3 X gt 3 1B By using this session the following tables are converted TRITON Distribution Sales and Marketing Info Selections The Expressions from table Selection Lines are copied to Selection Expression of Selections for the corresponding Selections The field tdsmi070 expr will be filled in with tdsmi071 snse for all corresponding selection lines Letters The Layouts from table Layouts by Letters are copied to Layout of Letters for the corresponding Letter The field tdsmi150 text will be filled in with tdsmi151 layo for all corresponding layout lines Planned INV Purchase Orders The Company from Planned INV Purchase Orders is filled in with the default Company for the supplier For single financial companies this field is filled in with the default financial company for the logistic company The field tdinv310 comp will be filled in with the default company number from the supplier Purchase Order
87. ifferences between Service version 3 0b and version 3 1a For this conversion the Exchange package must be used This section contains the following topics Converting TRITON Service 3 0b to BAAN IV Checking the conversion Conversion TRITON 3 to BAAN IV BddN did 5 Correction program and checking the conversion both scenarios Converting TRITON Service 3 0b to BAAN IV Take the steps described below to convert TRITON Service 3 0a to BAAN IV 1 10 11 12 13 Execute bdbpre6 0 for the Services tables of TRITON version 3 0 You must use a shell script that does the following Uses A as seperator Converts the tppmmmxxxccc S syntax to ppmmmxxx Where pp stands for the package code mmm for the module code and xxx for the table number Create two company numbers in BAAN IV one of which will be used for Exchange only These Companies must be linked to the same dedicated Packet Combination Note that this Packet Combination must not be the operational Packet Combination Use the session ttadv5217m000 to remove the reference integrity from the Package Combination Install the Exchange Scheme S30b 31a by using the session Create Tables from Sequential Dump ttaad4227m000 in one of the Companies created in step 2 If there are customizations run the Copy Exchange Scheme session tuxch0201m000 to copy the entire Exchange Scheme Use the Maintain Exchange Scheme tuxch0101m000 session to define the pathn
88. in TRITON 3 known as OPER 001 The environment must be set up for testing this implies that you should not at this stage migrate all existing package combinations and associated company numbers to BAAN IV When the test conversion is satisfactory later on only those BAAN IV equivalents of the package combinations have to be created that have companies attached to them but do not create an equivalent of the standard 31Sa or 31Sb package combination Conversion TRITON 3 to BAAN IV BddN Ts 4 Converting to BAAN IV the single environment scenario 4 2 6 4 2 7 Customizations Make sure that for the conversion of own software all that software is included in the process Take other customizations into account as well C VRCs and B VRCs If there is customized software in TRITON 3 the customization supplier must migrate this to BAAN IV The upgrade cannot take place before that migrated software has been delivered The correction program otccov0000m000 has to be adapted if there are changes to the data model in these customizations that is O VRCs C VRCs B VRCs and possibly L VRCs before it can be run for the test company and the test company can be used See Chapter 1 section 1 3 2 Customizations One single test company and a number of users are migrated to the new test package combination for testing purposes and possibly for changes in own software by the customer In this phase the correction program tec
89. ion B40L b nl10 is available then for tf and tp derive the U VRC from the L VRC instead of from the standard Do not include the ti Business Organizer BA0L b localization in the derived from structure In the Business Organizer items for instance are renamed as business objects Therefore do not incorporate them in an operational design testing package combination For those who want to use this localization a separate package combination can be created Create customer specific O VRCs for all packages exept tt Basically copy the existing structure of own VRCs to BAAN IV Retain the existing customer extension s as much as possible Conversion TRITON 3 to BAAN IV BAAN 4 3 8 4 3 9 4 3 10 4 Converting to BAAN IV the single environment scenario OPER 001 contains 3 70 a 01 derived from 3 1 af DSGN 001 contains 3 70 0597 derived from 3 70 a 01 Now create two new series of own VRCs 400 b 01 derived from B40U_b_stnd as no customization is involved and B40O b 091 derived from B40O b Step 8 Create directories for new VRCs ttadv1115m000 Create directories for all new that is U and O VRCs 13 Application Development 3 Packages and Modules 4 Maintain Software Component Directories Press S and enter the name of the VRC press I to enter the six software component types Do this for all VRCs If the components are en
90. ions 7 2 6 Message 6 Conversion error sst020 sstr lt sst020 str gt This message informs you that the table tdsst020 has a physical database problem for example it is corrupted Type of Error message Use key value printed in the error message to check the table manually actions 7 2 7 Message 7 Conversion error sst025 sstr lt sst025 str gt This message informs you that the table tdsst025 has a physical database problem for example it is corrupted Type of Error message ee Use the key value printed in the error message to check the table manually actions 7 2 8 Message 8 Conversion error sst028 sstr lt sst028 str gt This message informs you that the table tdsst028 has a physical database problem for example it is corrupted Type of Error message brand Use the key value printed in the error message to check the table manually actions Conversion TRITON 3 to BAAN IV ms BAAN Type of message Possible actions Type of message Possible actions Type of message Possible actions Type of message Possible actions Type of message Possible actions 7 2 9 7 2 10 7 2 11 7 2 12 7 2 13 7 Appendix B Troubleshooting Message 9 Conversion error sst050 sstr lt sst050 str gt This message informs you that the table tdsst050 has a physical database problem for example it is corrupted Error Use the key v
91. is filled in The field tdsls034 cuni will be filled in with temcs024 cpru if the tdsls034 cpgp is filled in The tdsls034 kogr must be equal to tckogr quantity otherwise the field will not be converted BddN Conversion TRITON 3 to BAAN IV 5 5 5 Correction program and checking the conversion both scenarios Note Note Note Sales Discount Parameters by Price List and Price Group For Grade by Quantity Amount equal to Quantity the Unit is filled in with the Price Unit from the Price List when the Sales Price List is filled in The field tdsls035 cuni will be filled in with temcs024 cpru for the corresponding price list on condition that the price list is not empty The tdsls035 kogr must be equal to tckogr quantity otherwise the field will not be converted Sales Price Parameters by Customer per Item The Unit when empty is filled in with the Sales Price Unit from the Item table tiitm001 or when this field is empty the Inventory Unit If tdsls036 cuni is empty then it will be filled in with tiitm001 cupp If tiitm001 cupp is emty then tdsls036 cuni will be filled in with tiitm001 cuni The tdsls036 kogr must be equal to tckogr quantity otherwise the field will not be converted Sales Price Parameters by Price List and Item The Unit when empty is filled in with the Sales Price Unit from the Item table tiitm001 or when this field is empty the Inventory Unit If tdsls037 cuni is empty then it will be fill
92. isadvantages are the amount of disk space which is needed for the export file and the new database as well as the amount of time needed to export and import the company data 2 4 2 Database specific data transfer A database specific data transfer is a faster conversion method than the general export option There are different types of database specific data transfers depending on the database type TBASE or TBASE_TP For this method the database tables for TBASE and TBASE_TP must be copied to the BAAN IV environment and registered in BAAN IV this second part is described in the import section of the next chapter For TRITON 3 0 an additional step is necessary in the import conversion of the tables Make sure that nobody is using the companies when you are copying them The advantage of this approach is that there is a faster conversion which mainly results from the fact that two procedure steps are omitted namely the Create Sequential Dump of Table ttaad4226m000 session and the Create Table from Sequential Dump ttaad4227m000 session see Chapter 3 Converting to BAAN IV two environments scenario Informix or Oracle The approach for these RDBMS highly depends on the customer s specific situation and is therefore too complex to be discussed in the context of this document For more information contact the local BAAN supplier who can in turn contact the ISC for assistance Partners and dealers in the EMEA area can contact the de
93. itemcode gt lt unit set gt lt units gt Message will be logged when units of standard project item in tppdm605 is found in an existing unit set Information No action required Message 23 tppdm605 lt project gt lt itemcode gt Error unit not in unit set of pcs021 Error message will be logged when when there is an integration to TRITON Distribution and unit s of a standard project item in tppdm605 is not found in existing unitsets Error Add unit s of standard project item to a unit set and run this program again Conversion TRITON 3 to BAAN IV BddN 7 Appendix B Troubleshooting m Type of message Possible actions Type of message Possible actions Type of message Possible actions Type of message Possible actions Type of message Possible actions 7 10 24 7 10 25 7 10 26 7 10 27 7 10 28 Message 24 tppdm605 lt project gt lt itemcode gt lt unit set gt copied from pdm625 Message will be logged when unit s of project equipment item in tppdm605 is found in the already generated unit set Information No action required Message 25 tppdm605 lt project gt lt itemcode gt Error unit not in unit set of pdm625 Error message will be logged when unit s of a project equipment titem in tppdm605 is not found in existing unitsets Error Add unit s of project equipment item to a unit set and run this program again Message 26 tppdm605 lt project gt
94. le actions Message 2 END OF CONVERSION This message informs you about the end date and time of the session Information No action required Message 3 CONFLICT item gt lt item code gt gt lt item unit gt gt lt alternate unit gt gt lt conversion factor gt gt conflict general conversion A message will be logged when a conversion factor is found for an item whose item unit has the same physical quantity not pieces as the physical quantity of an alternate unit Warning Change conversion factors afterwards optional Message 4 CONFLICT proj item gt lt project gt gt lt item code gt gt lt unit gt gt lt purchase unit gt gt lt conversion factor gt gt conflict general conversion A message will be logged when a conversion factor is found for an project item whose item unit has the same physical quantity not pieces as the physical quantity of the purchase unit of that project item Warning Change conversion factors afterwards optional Message 5 CONFLICT proj item gt lt project gt gt lt item code gt gt lt unit gt gt lt purchase price unit gt gt lt conversion factor gt gt conflict general conversion A message will be logged when a conversion factor is found for an project item whose item unit has the same physical quantity not pieces as the physical quantity of the purchase price unit of that project item Warning Change conversion factors afterwards optional Conversion TRI
95. lt itemcode gt lt unit set gt copied from pdm635 Message will be logged when unit s of project subcontracting item in tppdm605 is found in the already generated unit set Information No action required Message 27 tppdm605 lt project gt lt itemcode gt Error unit not in unit set of pdm635 Error message will be logged when unit s of a project subcontracting titem in tppdm605 is not found in existing unitsets Error Add unit s of project subcontracting item to a unit set and run this program again Message 28 tppdm604 lt project gt lt itemcode gt lt unitset gt copied from tppdm605 Message will be logged when alternate unit of a project item in tppdm604 is found in the already generated unit set Information No action required Conversion TRITON 3 to BAAN IV 7 24 BAAN E Type of message Possible actions Type of message Possible actions Type of message Possible actions Type of message Possible actions Type of message Possible actions 7 10 29 7 10 30 7 10 31 7 10 32 7 10 33 7 Appendix B Troubleshooting Message 29 tppdm604 lt project gt lt itemcode gt lt unitset gt Error unit not in unit set of pdm605 Error message will be logged when alternate unit of a project item in tppdm604 is not found in the already generated unit set Error Add unit to a unit set and run this program again Message 30 Base Weight Unit not filled Error
96. lues to enum domain Message 40 Error lt error code gt in qss search lt search mode gt lt search argument gt lt table gt lt definition gt lt number gt This will be a program error The program will abort Fatal error Ask for support from software vendor Message 41 Error lt error code gt in qss sort lt table gt lt definition gt lt number gt This will be a program error The program will abort Fatal error Ask for support from software vendor tccov3003m000 Conversion Unit Conversion Factors This section lists the messages that can be displayed during the execution of tccov3003m000 The messages are stored in the log file BSE og log cov3003 The messages are stored as follows Type of output Only process information will be logged into this file Full description Start and end of process will be logged Format of output MM DD YY mm ss s MM Month DD Day YY Year mm Minutes 55 Seconds bs Message Message 1 START OF CONVERSION tccov3003m000 by user lt name gt This message informs you about the start date and time of the session by the specified user Information No action required Conversion TRITON 3 to BAAN IV BddN did 7 Appendix B Troubleshooting 7 11 2 Type of message Possible actions 7 11 3 Type of message Possible actions 7 11 4 Type of message Possible actions 7 11 5 Type of message Possib
97. m tdpur036 item 2 Define and export the following environment variables from the UNIX command line BSE BSE TMP PATH 3 Check that the user carrying out the query is linked to the same package combination to which the company to be checked is linked 4 Execute the query by entering the following command qptool6 1 f check db C100 5 If the query generates output there are items in tdpur036 that are not present in the item file tiitm001 You must either remove these items from tdpur036 or add them in tiitm001 by using session tiitm0101m000 6 Repeat the steps 1 to 4 for the query printed below Note that you must take another name for the second query select tdsls037 cpls tdsls037 item from 10515037 where not exists Select tiitm001 item from tiitm001 where tiitm001 item tdsls037 item 7 the query generates output there are items in tdsls037 that are not present in the item file tiitm001 You must either remove these items from tdsls037 or add them in tiitm001 by using session tiitm0101m000 2 2 2 Create a backup of the TRITON software and data A backup must be created of the operational TRITON software and data Conversion TRITON 3 to BAAN IV BddN 2 Preparing TRITON for conversion the two environments scenario m 2 2 3 Export Users Authorizations Devices Currencies Logical Tables ottcon61export At this point the data regarding the current users authorizations currencies
98. ment It is advisable to determine beforehand which of these two conversion methods is the best for the specific situation and to study the steps of the corresponding flowchart s The charts are not entirely self explanatory so turn to the corresponding texts in this document for more detail It is important to understand the impact of all the choices presented in the flowchart s especially those concerning customized table definitions in case of a non standard data model DM see also section Customizations The data correction program is suitable for converting data from the following TRITON versions to BAAN IV 3 0b 3 0b1 3 1a 3 1al 3 1b and 31b2 BAAN IVa is a restricted release only the conversion to BAAN IVb has been tested on application level Apart from these conversion and correction programs BAAN IVb requires you to run some small correction programs Conversion TRITON 3 to BAAN IV 1 2 BAAN Note 1 3 2 1 3 3 1 3 4 1 Introduction Customizations To convert a standard TRITON 3 version to a standard BAAN IV version you can use the standard conversion program If the TRITON 3 version includes customized table definitions and therefore the BAAN IV environment is assumed to these as well the standard conversion program must be modified to fit the customer s specific configuration In the case of a nonstandard data model the test conversion can only be carried out after
99. n error tdpur045 pmsk lt tdpur045 orno gt lt tdpur045 pono gt lt tdpur045 srnb gt lt tdpur045 pmsk gt This message informs you that the table table tdrpl004 has a physical database problem for example it is corrupted The purpose of this conversion is to extend the procedure mask field in pur045 Error Use the key value printed in the error message to check the table manually Conversion TRITON 3 to BAAN IV BddN HE 7 Appendix B Troubleshooting m 7 2 42 Message 42 Conversion error tdrpl100 pmsk lt tdrpl100 orno gt lt tdrpl100 pono gt lt tdrpl100 srnb gt lt tdrpl100 pmsk gt This message informs you that the table table tdrpl100 has a physical database problem for example it is corrupted The purpose of this conversion is to fill the procedure mask in rpl100 Type of Error message Use the key value printed the error message to check the table manually actions 7 3 Changing a sign in open item table tccov2001m000 This section lists the messages that can be displayed during the execution of tccov2001m000 The messages are stored in the log file BSE og log cov2001 The messages are stored as follows Type of output Only process information will be logged into this file Full Description Start and end of process will be logged Format of output MM DD YY mm ss s MM Month DD Day YY Year mm Minutes SS Seconds bs Message 7 3 1 Message 1 START OF CONV
100. nic Data Interchange Parameters TRITON Common EDI Messages The fields Session Incoming Message and the Session Outgoing Message are converted to Library Incoming and Library Outgoing The field tcedi005 sesi will be filled in with the first five positions of the contents of the source field dll the last four positions of the contents of the source field The field tcedi005 seso will be filled in with the first five positions of the contents of the source field dll last four positions of the contents of the source field The target field will be empty if the source field was empty Purchase Control Purchase Inquiry Lines Purchase Inquiry Line History The Item Category is filled in with Customized for Inquiry Lines for a project and with Standard for the others The field tdpur002 opol and tdpur011 opol will be filled in with tcittb customized if tdpur002 cprj tdpur011 cprj is filled in Purchase Discount Parameters by Supplier and Price Group For Grade by Quantity Amount equal to Quantity the Unit is filled in with the Price Unit from the Price Group when the Price Group is filled in The field tdpur034 cuni will be filled in with tcmcs024 cpru if the field tdpur034 cpgp is filled in The tdpur034 kogr must be equal to tckogr quantity otherwise the field will not be converted Conversion TRITON 3 to BAAN IV 5 4 BAAN Note Note Note Note 5 Correction program and checking the conver
101. ns 7 6 6 Message 6 END OF CONVERSION This message informs you about the end date and time of session Type of Information message Possible No action required actions 7 7 tccov2005m000 Changing enumerated field tfemg108 This section lists the messages that can be displayed during the execution of tccov2005m000 The messages are stored in the log file BSE log log cov2005 The messages are stored as follows Type of output Only process information will be logged into this file Full description Start and end of process will be logged Format of output MM DD YY mm ss s MM Month DD Day YY Year mm Minutes SS Seconds Ps lt Message gt Conversion TRITON 3 to BAAN IV di BAAN E Type of message Possible actions Type of message Possible actions Type of message Possible actions Type of message Possible actions 7 7 1 7 7 2 7 7 3 7 8 7 8 1 7 Appendix B Troubleshooting Message 1 START OF CONVERSION tccov2005m000 by user lt ogin name gt This message informs you about the start date and time of the session by the specified user Information No action required Message 2 tfcmg108 payment batch original company payment type lt supplier gt lt order gt For each changed transaction in tfcmg108 information is logged Information No action required Message 3 END OF CONVERSION This message informs you about
102. nversion software into the newest standard VRC for example tcB40 b2 Note The name of the VRC containing the conversion software is printed in the letter attached with the delivery tape Supply the following information Path Sequential Dumps delivery directory of conversion software Path Runtime Dictionary BSE application Overwrite Yes Write software components in other Package VRC Yes Package VRC newest standard VRC 2 Use the Create Runtime Data Dictionary session ttadv5210m000 to dump all Package Combination containing the newest standard VRC 4 3 6 Step 6 B C Import customization ttiex1285m000 From here on user must be bsp If available import the customization dumps B VRCs and or C VRCs with this session do not rename them by importing them into another VRC because of maintenance reasons Import the B VRCS first 1f available 4 3 7 Step 7 Create new VRCs ttadv1111m000 The user must be bsp For general rules on the derived from structure see document 1034US page 7 Create the O VRCs and U VRCs using the session 13 Application Development 3 Packages and Modules 3 Maintain Package VRCs At least create U VRCs derived from the standard B40 for all packages in the format package code B40U release stnd Updates package name release example tc B40U b stnd Updates Common 40 b Use the OPER 001 derived from structure as a model for TMP 001 For instace if the localizat
103. nverted BddN tssma000 Service Parameters Within this table a lot of new parameters are added for planning purposes These parameters will get all default values during the conversion The session Maintain Service Parameters tssma3100m000 especially form 4 can be used to verify the conversion tssmal10 Locations The major changes is that for the locations the address data is removed from the table There are two types of addresses introduced for the location Postal and Work site Addresses Only for the work site there is a conversion possible The session Maintain Locations tssmal110m000 can be used to verify the conversion tssmal21 Items by Servicing For the required items by servicing also the warehouse have to be filled in case of inventory items The session Maintain Items by Servicing tssmall21m000 can be used to verify the conversion tssmal23 Servicings The location of the installation must be filled during the conversion The field is not used on a form but is used in the background while generating a maintenance plan The table maintenance session ttaad4100 can be used to verify the conversion tssmal24 Periodc Maintenace Planning To plan the maintenace by location and to plan more precise within the maintenace period the location and planned execution date will be filled during the conversion The sessions Maintain Periodic Maintenance Planning tssmal 12411000 and Maintain Periodic Maintenance Planning
104. nvironment scenario m 4 3 11 Step 11 Fill Package Combination s with VRCs ttaad1221m000 Start the session 13 Application Development 3 Packages and modules 6 Maintain Packages by Package Combination Fill the new TMP 001 package combination with the right O VRCSs corresponding with the VRCs in OPER 001 in the TRITON 3 environment Again keep to the original structure but leave out ge General and tb TRITON Support if available End by pressing Y to dump the package combination In BAAN IV runtime Help is created automatically when you use this session to dump a package combination Therefore it may take up to an hour before the session is finished 4 3 12 Step 12 Migrate company companies ttaad1101m000 Convert at least one test company to the new package combination via 2 Application Configuration Press twice to reach the Miscellaneous menu 2 Change Package Combination by Company This session may result in a list of warnings of the type Warning No DD for tcedi472 found They relate to new tables and can be ignored Run the Check Tables ttaad4232m000 session now for the test company companies to make sure that all tables are in the correct format 4 3 13 Step 13 Migrate user s ttaad2200m000 Migrate at least one user to the test package combination via 3 User Management General User Data 2 Change Package Combination by User 4 3 14 Step 14 Own Dump
105. o BAAN IV v Conversion TRITON 3 to BAAN IV 3 4 13 Convert User Data to Runtime Data Dictionary ttaad4200m000 3 11 3 4 14 Maintain Package Combinations ttaad1120m000 3 12 3 4 15 Create Tables ttaad4230m000 3 12 3 4 16 Reorganize Tables ttaad4225m000 3 12 4 Converting to BAAN IV the single environment scenario 4 1 4 Steps in the procedure 4 1 4 2 Preparation 4 5 4 2 1 Backup 4 5 4 2 2 TRITON 4 5 4 2 35 Time frame 4 5 4 2 4 Prerequisites 4 5 4 2 5 Test 4 5 4 2 6 Customizations 4 6 4 2 7 Notes 4 6 4 3 Installation procedure 4 7 4 3 1 Step 1 Reading out tapes 4 7 4 3 2 Step 2 Start installation script 4 7 4 3 3 Step 3 Running preinst during or right after the installation of BAANIV 4 8 4 3 4 Step 4 Check installation logs 4 9 4 3 5 Step 5 Import the VRC containing the software components for conversion 4 10 4 3 6 Step 6 B C Import customization ttiex1285m000 4 10 4 3 7 Step 7 Create new VRCs ttadv1111m000 4 10 4 3 8 Step 8 Create directories for new VRCs ttadv1115m000 4 11 4 3 9 Step 9 Own Copying own work to new own VRCs ttadv6265m000 4 11 4 3 10 Step 10 Create New Package Combination s ttaad1120m000 4 11 4 3 11 Step 11 Fill Package Combination s with ttaad1221m000 4 12 4 3 12 Step 12 Migrate company companies ttaad1101m000 4 12 4 3 13 Step 13 Migrate user s ttaad2200m000 4 12 4 3 14 Step 14 Own Dump forms and menus ttadv5214m000 4 12 4 3 15 Step 15 Own Compile reports ttadv3240m0
106. ory MEMORY CURRENT etc sysdef 2 gt dev null grep physical memory is awk 4 OPERATOR CONDITION Number of Triton users USERS CURRENT ksh c if f brand brand6 1 o 1 f BSE bin licmon6 1 then echo 2 else licmon6 1 b grep users awk TOT 4 END print TOT fi OPERATOR CONDITION nproc NPROC CURRENT etc sysdef 2 gt dev null grep i nproc cut d f 2 OPERATOR ge CONDITION 64 USERS maxuproc MAXUPROC CURRENT etc sysdef 2 gt dev null grep i maxuprc cut d f 2 OPERATOR ge CONDITION 64 4 3 4 Step 4 Check installation logs After installation the installation directory should be empty When a regular tape is used the directory extra remains The log files are in directory BSE log Check the most recent ones type Is Itr BSE log to find them Create a file called setbse in BSE that sets the BSE BSE TMP PATH and TERM vt100 variables if it does not exist already If the installation has been completed successfully the customer can start using TRITON again Conversion TRITON 3 to BAAN IV BddN 4 Converting to BAAN IV the single environment scenario m 4 3 5 Step 5 Import the VRC containing the software components for conversion To import the VRC containing the software components for conversion take the following steps 1 Use the import Data Dictionary session ttiex1285m000 to import the VRC containing the co
107. oth the unallocated and anticipated document The total difference of these documents will be 0 Note the following points Also tfgld102 and tfgld106 will be updated In tfacp200 both tfacp200 typa and tfacp200 doca are emptied for unallocated and advance The same applies in tfacr200 for typa and doca 014102 both 102 ctyp and 102 codc are emptied for documents of category cash which are also present in tfcmg110 The same happens in tfgld106 for the fields ctyp and cinv Change Enumerated Field tfcmg108 tecov2005m000 By means of this session the number of enum values of a field in the One Time Supplier Addresses table is extended from 2 to 8 Conversion TRITON 3 to BAAN IV 5 10 BAAN m 5 Correction program and checking the conversion both scenarios Update Payment Differences from Anticipated Payment tecov2006m000 In tfcmg111 the invoices purchase invoices and the sales invoices are read When an invoice has payment method tfemg003 repa payment or when it is a purchae invoice the document from tfcmg111 will be looked up in tfacp200 When it is an anticpated document tfacp200 padi pada and padh are updated tfacp200 padi If tfcmg111 amnt is greater than O and less than tfacp200 amnt tfacp200 padi will be set equal to the negative value of tfcmgl111 pdif If tfcmg111 amnt is less than 0 or greater than tfacp200 amnt tfacp200 padi will be set equal to tfcmg111 pdif tfacp200 pada and tfacp2
108. ov0000m000 has to be adapted to the customizations if necessary so that the operational conversion can be run without problems After testing and acceptance and possibly adaptation and a second test conversion the operational companies can be converted to BAAN IV Discuss everything with the customer the backup TRITON downtime time frame the need to adapt tccov0000m000 to changes in the Data Model and the configuration after the update test package combination user s and test company companies to be migrated Notes During installation a new porting set is installed This implies that all adjustments in directory BSE bin in their current versions will be lost after the update The old scripts will still be available in BSE bin under their original name followed by a hyphen Make sure that after the update nonstandard scripts or scripts subject to change are properly restored or adjusted Because the entire environment TRITON 3 and BAAN IV is upgraded to Tools version B40 release there will be the following restrictions for the TRITON 3 environment after update When using a graphical user interface bx or bw you can not use the zoom lt Ctrl gt Z options in an application session to a tools subsession tis not possible to dump run time TRITON forms with BAAN IV tools or to compile TRITON 3 program report scripts with BAAN IV tools This implies that after the software conversion the operational T
109. owing Pros and cons of the two scenarios Conversion Scenario Advantages not too much extra diskspace required Single environment more simple conversion few manual actions required both the old software version and the new software version can be used simultaneously in one environment containing different data less strain on the server one server one environ ment Two environments operational environment remains operational during installation test conversion all actions are possible in the 3 0 3 1 operational environment during the whole procedure operational environment remains unchanged reliable during instal lation test conversion Disadvantages users have to leave the environment during update software some development actions are not possible anymore in the 3 0 3 1 package combinations after update considerable more space is required since two complete environments coexist for a period of time the conversion has more steps which are also more complex the conversion takes a considerable amount of time and requires a lot of manual actions in case of a one server two environments situation more strain is put on the server The two conversion scenarios are referred to as the single environment scenario and the two environments scenario Both scenarios are outlined in a set of flowcharts which are included in this docu
110. partment of Technical Services of BAAN Netherlands Conversion TRITON 3 to BAAN IV dii BAAN 3 Converting to BAAN IV two environments scenario This chapter describes the steps needed to convert the prepared software components and data from TRITON 3 to BAAN IV 3 1 Steps in the procedure The following steps can be distinguished in converting the TRITON 3 data and software to BAAN IV 1 General 2 Software conversion 3 Data conversion Each of these main steps may consist of a number of additional steps Next some flowcharts display the conversion in a schematic form Conversion TRITON 3 to BAAN IV BAAN ih 3 Converting to BAAN IV two environments scenario This chapter describes the steps needed to convert the prepared software components and data from TRITON 3 to BAAN IV 3 1 Steps in the procedure The following steps can be distinguished in converting the TRITON 3 data and software to BAAN IV 1 General 2 Software conversion 3 Data conversion Each of these main steps may consist of a number of additional steps Next some flowcharts display the conversion in a schematic form Conversion TRITON 3 to BAAN IV BAAN ih 3 Converting to BAAN IV two environments scenario m create full backup export 000 ottcon61 export export O VRC s ttiex1280m000 export data comp ttaad4226m000 tbase _tp Yes copy comp di export data comp rectories UNIX database specific set tbase
111. r The Item Category is filled in with Customized for Sales Quotation Lines for a Budget The field tds1s002 fact will be filled in with the tdsls001 fact The field tdsls002 opol will be filled in with tcittc customized if the tdsls002 cbdg is not empty Sales Quotation Line History The Item Category is filled in with Customized for Sales Quotation Lines for a Budget The Success Percentage is copied from the Sales Quotation History For Sales Quotation Lines in History with Record Type 1 4 equal to 3 the Status is filled in with Canceled For Sales Quotation Lines in History with Record Type 1 4 equal to 4 the Status is filled in with Processed and Reason for Blocking and Competitor are copied from the corresponding Sales Quotation History Header The field tdsls011 opol will be filled in with tcittc customized if the fielde tdsls011 cbdg is not empty If the field tdsls011 ckor is equal to 3 then 1451501 1 15 will be filled in with tdsls Ista abandoned If the field tdslsO11 ckor is equal to 4 then tdsls011 Ista will be filled in with tdsls Ista processed tdslsO11 crea will be filled in with tdsls010 crea and tdsls011 ccom will be filled in with tdsls010 ccom The field tdsls011 fact will be filled in with the tdsls010 fact Sales Discount Parameters by Customer and Price Group For Grade by Quantity Amount equal to Quantity the Unit is filled in with the Price Unit from the Price Group when the Price Group
112. r logon name 7 1 7 1 7 1 7 2 7 2 7 2 4 2 7 3 7 3 7 2 2 Message 2 END OF CONVERSION tccov1002m000 by user logon name gt 7 3 7 2 8 Message 3 Conversion error sst010 sstr lt sst010 sstr gt 7 2 4 Message 4 Conversion error sst015 sstr sst015 sstr 7 2 5 Message 5 Conversion error sst018 sstr sst018 sstr 7 2 6 Message 6 Conversion error sst020 sstr sst020 str 7 2 7 Message 7 Conversion error sst025 sstr sst025 str 7 2 8 Message 8 Conversion error sst028 sstr sst028 str 7 2 9 Message 9 Conversion error sst050 sstr sst050 str 7 2 10 Message 10 Conversion error sst030 sstr sst030 str 7 2 11 Message 11 Conversion error pst0O10 sstr pst010 sstr 7 3 7 4 7 4 7 4 7 4 7 4 7 5 7 5 7 5 Conversion TRITON 3 to BAAN IV vii Conversion TRITON 3 to BAAN IV 7 3 Conversion TRITON 3 to BAAN IV viii 7 2 12 Message 12 7 2 13 Message 13 7 2 14 Message 14 7 2 15 Message 15 7 2 16 Message 16 7 2 17 Message 17 Conversion error pst015 sstr pst015 sstr Conversion error pstO18 sstr pst018 sstr Conversion error pst020 sstr pst020 sstr Conversion error 7 pst025 sstr pst025 sstr Conversion error pst028 sstr pst028 sstr Conversion error pst050 sstr pst050 sstr 7 2 18 Message 18 Conversion error pst030 sstr pst050 sstr 7 2 19 Message
113. rise Modeler data by means of the Export Version Dump tgbrg1235m000 session All table definitions are also exported In BAAN IVb use the Import Version Dump tgbrg1245m000 session to import the created dump file BAAN Enterprise Performance Manager Create a file in TRITON 3 or BAAN IVa which contains all enterprise data by means of the Export Enterprise Data tgeis 1235m000 session In BAAN IVb use the Import Enterprise Data tgeis1245m000 session to import the created dump file Data conversion from BAAN IVa to BAAN IVb After installing BAAN IVb and after a possible conversion to BAAN IVa follow the next procedure 1 Maintain Logical Tables ttaad4120m000 If required the next purchase tables tdpur040 tdpur041 tdpur045 and tdpur046 can be defined as logical tables and stored in a different company 2 Fillthe new Logistic Companies by Financial Company tfgld000 table by means of the Maintain Logistic Companies by Financial Company tfgld0100m000 3 Execute the Fill Logistic Company in Open Purchase Items tfcor0300m000 correction session Check the Only Test Run option to look for any possible problems This session fills the new field called Logistic Company loco in the Open Items Purchase Invoices amp Payments tfacp200 The field is the logistic company number of the order that is linked to the open entry This session checks if an order is linked to an open entry and copied into the new field 4 Maintain
114. rted project item in tipcs021 the unit set with its units will be logged Type of Information message Possible No action required actions 7 10 6 Message 6 tipcs002 lt budget code gt lt calculation part gt lt unit set gt lt units gt For each converted calculation part in tipcs002 the unit set with its units will be logged Type of Information message Possible No action required actions 7 10 7 Message 7 tiedm010 lt enginering item gt lt unit set gt lt units gt For each enginering item in tiedm010 the unit set with its units will be logged Type of Information message Possible No action required actions 7 10 8 Message 8 tppdm025 lt equipment code gt lt unit set gt copied from itm001 lt unit gt Message will be logged when unit of equipment in tppdm025 is found in the already generated unit set Type of Information message Possible No action required actions Conversion TRITON 3 to BAAN IV BAAN Type of message Possible actions Type of message Possible actions Type of message Possible actions Type of message Possible actions Type of message Possible actions 7 10 9 7 10 10 7 10 11 7 10 12 7 10 13 7 Appendix B Troubleshooting Message 9 tppdm025 lt equipment code gt Error unit not in unit set of itm001 Error message will be logged when there is an integration to TRITON Distribution and unit of equipment in tppdm025 is NOT
115. s logged Type of Information message Possible No action required actions 7 8 4 Message 1 END OF CONVERSION This message informs you about the end date and time of the session Type of Information message Possible No action required actions 7 9 tccov3001m000 Converting Manufacturing 3 1 to BAAN IV This section lists the messages that can be displayed during the execution of tccov3001m000 The messages are stored in the log file BSE log log cov3001 The messages are stored as follows Type of output Only process information will be logged into this file Full Description Start and end of process will be logged Format of output MM DD YY mm ss s MM Month DD Day YY Year mm Minutes Ss Seconds bs Message Conversion TRITON 3 to BAAN IV dic BAAN E Type of message Possible actions Type of message Possible actions Type of message Possible actions Type of message Possible actions 7 9 1 7 9 2 7 10 7 10 1 7 10 2 7 Appendix B Troubleshooting Message 1 START OF CONVERSION tccov3001m000 by user lt ogin name gt This message informs you about the start date and time of the session by the specified user Information No action required Message 2 END OF CONVERSION This message informs you about the end date and time of the session Information No action required tccov3002m000 Conversion Units to Units by Unit Sets
116. se Order History by Supplier and Item tdsls1403m000 Print Quotations by Item tdsls4404m000 Print Sales Invoices tdsls4410m000 Print Sales Orders by Order Number 195154431 000 Print Sales Order Deliveries tdsis6401m000_ tdsis6403m000_ tdssto4o1mo00 Conversion TRITON 3 to BAAN IV 5 14 BAAN 5 3 3 5 Correction program and checking the conversion both scenarios TRITON Manufacturing TRITON 3 1b tibom1214m000 tibom1411m000 ticpr0410m000 ticpr2410m000 ticpr2410m000 ticst0401m000 ticst2401m000 tiedm1470m000 tigrt0441m000 tihra1401m000 tihra8460m000 tiitm0401m000 tipcf0450m000 tipcf2401m000 tipcf3411m000 tipcf4401m000 tipcf6410m000 tipcs1460m000 tipcs1462m000 tipcs2451m000 tipcs3460m000 tipcs3462m000 tipcs8410m000 tipcs8450m000 tisfc0401m000 tisfc0450m000 tisfc2401m000 BddN BAAN IV tibom1214m000 tibom1411m000 Description Detect Loops in Production BOMs Print Production Bills of Material Multi Level Print Cost Price Components Print Surcharges by Item Group ticpr2410m000 Print Cost Price Calculation by Item Print Actual Costs by Production Order Print Costing History by Order Print EBOM and PBOM Consistency Print Classified Items by Family tiedm1470m000 Print Hours Accounting by Employee Print Hours History by Employee Print Item Data tipcf0450m000 Print Product Features Print Constraint IDs by Generic Item Print Generic Bill of Material Multi Level Print Generic
117. sion both scenarios Purchase Discount Parameters by Price List and Price Group For Grade by Quantity Amount equal to Quantity the Unit will be filled in with the Price Unit from the Price List when the Purchase Price List is filled in The field tdpur035 cuni will be filled in with tcmcs024 cpru for the corresponding price list provided that the price list is not empty The tdpur035 kogr must be equal to tckogr quantity otherwise the field will not be converted Purchase Price Parameters by Supplier and Item The Unit when empty is filled in with the Purchase Price Unit from the Item table tiitm001 or when this field is empty the Inventory Unit If tdpur036 cuni is empty then it will be filled in with tiitm001 cupp If tiitm001 cupp is emty then tdpur036 cuni will be filled in with tiitm001 cuni The tdpur036 kogr must be equal to tckogr quantity otherwise the field will not be converted Purchase Price parameters by Price List and Item The Unit when empty is filled in with the Purchase Price Unit from the Item table tiitm001 or when this field is empty the Inventory Unit If tdpur037 cuni is empty then it will be filled in with tiitm001 cupp If tiitm001 cupp is empty then tdpur037 cuni will be filled in with tiitm001 cuni The tdpur037 kogr must be equal to tckogr quantity otherwise the field will not be converted Sales Control Sales Quotation Lines The Success Percentage is copied from the Sales Quotation Heade
118. ss sort lt table gt lt definition gt lt number gt This will be a program error The program will abort Fatal error Ask for support from software vendor Message 20 END OF CONVERSION lt number conflicts gt CONFLICTS FOUND This message will be logged when conflicts have been registrated Information No actions required Message 21 END OF CONVERSION NO CONFLICTS This message will be logged when no conflicts have been registrated Information No actions required Conversion TRITON 3 to BAAN IV BddN Me 7 Appendix B Troubleshooting m Conversion TRITON 3 to BAAN IV es BAAN
119. sting the new version OPER_001 DSGN_001 143 10 01 143 10 b cu02 TEST 002 tdB40_b2 400 62 01 Figure 6 3 Testing the in house customization TEST_002 DSGN_001 tdB40_b2 dB400_b2_cu01 tdB400_b2_cu02 Figure 6 4 Released update Conversion TRITON 3 to BAAN IV diu BAAN 6 Appendix A Upgrading customizations 6 4 Upgrading customized software and in house customizations To upgrade both customized software and in house customizations the same procedure can be followed as for in house customizations only The only difference is that this procedure is extended with a step in which the external customizations are tested An update of the standard involves an update of the customization which is derived from that standard This is shown in Figures 6 5 through 6 9 OPER_001 DSGN_001 td3 1C_b_cu01 143 10 01 143 10 b cu02 Figure 6 5 Start position OPER 001 DSGN 001 id3 1C b cuO1 td3 10_b_cu01 143 10 b cu02 B40Sb idB40 b Figure 6 6 Testing the standard installation of BAAN IV Conversion TRITON 3 to BAAN IV 6 3 6 Appendix A Upgrading customizations m OPER 001 DSGN 001 id3 1C b cuO1 td3 10_b_cu01 td3 10_b_cu02 TEST_002 tdB40_a tdB40_b tdB40_b1 tdB40C_b2_cu01 Figure 6 7 Testing the external customization OPER_001 DSGN_001 td3 1C_b_cu01 td3 10_b_cu01 143 10 b cu02 TEST 002 tdB40_b2 tdB40C_b2_cu01 itdB400_b2_cu01 dB40O b2 cu02 Figure 6 8 Testin
120. tered in the order of the enum press the spacebar you can use the TRITON copying facility Enter the six components for the first VRC Press lt Esc gt to go to the choice field press lt Ctrl gt W Y B Y enter the name of the next VRC press Y and repeat these steps from lt Ctrl gt W on for all VRCs Step 9 Own Copying own work to new own VRCs ttadv6265m000 This session has only to be run if there are own developments mostly menus forms or reports Start the copying session 13 Application Development 16 Utilities 1 Copy Software Components to New Package VRC For all own VRCs copy everything from the old to the proper new O VRCs Also run this session for VRCs that are empty at UNIX level There may be domains attached to these or recent developments that are already present in tools may not have been converted to run time After this session the new O VRCs at UNIX level are still largely empty copying is currently only done at tools level Step 10 Create New Package Combination s ttaad1120m000 Check the derived from structure via the session ttadv1411m000 before using this session Call the following session 2 Application Configuration 8 Maintain Package Combinations Create at least one new package combination with the name TMP 001 for testing purposes do not put this in shared memory Conversion TRITON 3 to BAAN IV BddN 4 Converting to BAAN IV the single e
121. tfcor0260 otfcor0261 tccov1002 tccov5001 tccov2006 tfcor0300 tccov3005 otfcor0260 otfcor0261 tccov1001 tccov1002 tccov1002 tccov3005 otfcor0260 otfcor0261 Conversion TRITON 3 to BAAN IV 5 2 tuxch9211 tccov3002 tuxch9211 tccov3002 T tuxch9211 tccov3002 T tuxch9211 tccov3002 T tuxch9211 tccov3002 tuxch9211 tccov3002 tccovi999 optional BAAN Note 5 2 5 2 1 5 Correction program and checking the conversion both scenarios Conversion of TRITON 3 x gt BAAN IV tccov0000m000 Basically this session is a shell around a number of correction and conversion sessions which are used to convert the data of an older TRITON 3 x version to BAAN IVa First the right TRITON version must be selected as the original version Next the packages which must be converted to BAAN IVa must be selected since this session will only convert and correct the data of selected packages On the second form of this session the current status of each correction or conversion part is displayed Next the Real Conversion field which is the most important parameter in this session must be set to No Now you can run a test conversion which reports all changes that will occur as a result of a conversion Run test conversions until the conversion is executed correctly This is done to ensure that the real conversion will be successful At the bottom of the form you can find information regarding the version w
122. that the database field must be filled with the AUDIT database The Table Selection field enables you to specify individual tables all tables within certain modules and all other tables You can insert the mandatory tables by choosing the Load Mandatory Tables for Audit option from the Application menu 11 Select the Convert to Runtime option from the Application menu and close and restart the bshell Step 18 Create tables ttaad4230m000 For all test company numbers migrated to BAAN IV create new empty tables using the session 6 Database Management Press twice to reach the Miscellaneous menu 3 Create Tables Step 19 Parameters tcmcs0295m000 Run this session for all test company numbers that were migrated to BAAN IV Step 20 Maintain Company Parameters tfgld0103m000 Run this session to insert the appropriate Group Company number Step 21 Maintain ITM Parameters tiitm0100m000 Run this session to insert the appropriate Prefix for Item Code Container Items Step 22 Maintain Base Units tcmcs0100m000 Run this session to insert the appropriate base units Step 23 Checking and finalizing Perform the following checks and actions Make sure the scripts in BSE bin are restored to their old state Select the Software Installation menu from the main menu and start the Modify Codes of Alignment session in the Miscellaneous menu Make sure to align the articles the same as in the old installation I
123. the customizations have been redefined under BAAN IV and the conversion program has been adjusted to the BAAN IV table definitions Check the derived from structure for all possible types of non standard software That is all types of localizations L VRCs line of business specific software B VRCs general customizations C VRCs and in house customizations O VRCs If any of these are present check whether these contain customized table definitions and make sure the correction program is adjusted to these if necessary Do not attempt a data conversion before this issue is resolved For more information on the tables which must be converted see the online help information of the Conversion to BAAN IV tccov0000m000 session Localizations For the conversion of global localizations version 3 1b is required which means that TRITON 3 1a users must first be converted to 3 1b For the conversion of other localizations see the previous section Disk space Two environments scenario After BAAN IV has been installed two different environments exist the operational TRITON 3 environment and the new BAAN IV environment The data in the old environment must be copied to the new environment TRITON 3 1b BAAN IVa Vf Temporary File Figure 1 1 Conversion to BAAN IV During the conversion to BAAN IV temporary files are used to store the conversion data of each separate table Conversion TRITON 3 to BAA
124. the end date and time of the session Information No action required tccov2006m000 Updating payment difference for anticipated document This section lists the messages that can be displayed during the execution of tccov2006m000 The messages are stored in the log file BSE og log cov2006 The messages are stored as follows Type of output Only process information will be logged into this file Full description Start and end of process will be logged Format of output MM DD YY mm ss s MM Month DD Day YY Year mm Minutes ss Seconds bs Message Message 1 START OF CONVERSION tccov2006m000 by user login name gt This message informs you about the start date and time of the session by the specified user Information No action required BddN Conversion TRITON 3 to BAAN IV 7 17 7 Appendix B Troubleshooting m 7 8 2 Message 2 tfacp200 lt supplier gt lt transactiontype gt lt document gt lt linenumbers gt lt transactiontype gt lt document gt lt linenumber gt lt payment difference gt For each filled step in tfacp200 the key information is logged Type of Information message Possible No action required actions 7 8 3 Message 3 tfacr200 lt customer gt lt transactiontype gt lt document gt lt linenumber gt lt transactiontype gt lt document gt lt linenumber gt lt payment difference gt For each filled step in tfacr200 the key information i
125. ting system before you restart the installation of BAAN IV 2 Continue the installation of the BAAN IV software and tune the UNIX operating system after completing the installation of BAAN IV You do not have to write down the warnings generated by preinst because those messages are written into the BSE log log preinst file During the execution of preinst you are asked if you want to check all BAAN IV tables including those of the runtime environment or only those of the data dictionary Conversion TRITON 3 to BAAN IV 4 8 BAAN 4 Converting to BAAN IV the single environment scenario The BSE lib kernel cfg file will be set up as shown below The name of each parameter is followed by a formula to extract its current value an operator and a condition Kernel configuration file Version 6 1 rklip 23 09 1996 Updated for HPUX10 0 and IBM AIX4 1 Entries that must exist Machine id OS release Kernel 1 USERS MAXFSIZE output in Mb s CMD df lt device name gt lt size in Mb s gt lt filesystem gt don t use in the df command definition awk with printf CMD ping should give percentage packet loss if not don t define the command Machine id HP9000_PA_RISC OS release HPUX9 0 Kernel hp ux Configuration files in order of checking first Kernel configuration files etc conf gen S800 etc master Kernel type 1 static 2 static patch 3 dynamic Kernel type 1 Internal mem
126. utput MM DD YY mm ss s MM Month DD Day YY Year mm Minutes SS Seconds bs Message Message 1 START OF CONVERSION tccov1002m000 by user ogon name gt This message informs you about the start date and time of the session by the specified user Information No action required Message 2 END OF CONVERSION tccov1002m000 by user ogon name gt This message informs you about the end date and time of the session by the specified user Information No action required Message 3 Conversion error sst010 sstr lt sst010 sstr gt This message informs you that the table tdsst010 has a physical database problem for example it is corrupted Error Use the key value printed in the error message to check the table manually Conversion TRITON 3 to BAAN IV BddN ies 7 Appendix B Troubleshooting m 7 2 4 Message 4 Conversion error sst015 sstr lt sst015 sstr gt This message informs you that the table tdsst015 has a physical database problem for example it is corrupted Type of Error message Aesan Use the key value printed in the error message to check the table manually actions 7 2 5 Message 5 Conversion error sst018 sstr lt sst018 sstr gt This message informs you that the table tdsst018 has a physical database problem for example it is corrupted Type of Error message ne Use the key value printed in the error message to check the table manually act
127. wless conversion from TRITON 3 to BAAN IV extensive knowledge of both TRITON and BAAN is required Remarks and recommendations Prior to the actual conversion a number of considerations must be taken into account The conversion does not take multisite or multicompany conversion in consideration Before going through a conversion scenario check which tables are affected in your multicompany or multisite environment Conversion to BAAN IV two possible scenarios There are two options single environment or two environments 1 Single The new version is installed by using one environment In other words all programs are updated with the new version and all data is converted to BAAN IV 2 Two An upgrade is done using two different environments an old one with the old version and anew one with a fresh installed version An upgrade or update is possible for New Version BAAN IVa BAAN IVb Two Single Two Single Old version TRITON 3 0 TRITON 3 1 BAAN IVa Before you can update a file from a TRITON 3 1 environment single environment you must define the UNIX variable NO_PREINST as follows NO_PREINST 1 export NO_PREINST You can temporarely use the TRITON 3 x environment under BAAN IV Tools Note that this time must be as short as possible Conversion TRITON 3 to BAAN IV BddN 1 Introduction Note Both scenarios have their advantages and disadvantages The most important are the foll

Research and Development BAAN IV Conversion TRITON 3 to

Contents

Download Pdf Manuals

Related Search

Related Contents