Load Without Dumping (bcrun0103m000)

Use this session to load the data on the target server. This session can be used in the following two situations:

  • If the source and the target environments are present on two separate servers without a ERP client-server connection and the data files after copying them manually to the target environment server, needs to be loaded into the target database tables.
  • If you need to reload all or some of the data from the data files into the target database tables.

When the session starts, all the fields are filled with the values provided in the Conversion Parameters (bcgct0100m000) session, except for the following fields:

Process logic

  1. After entering the details, click OK to start the loading process. The user authentication dialog box appears. Enter your personal conversion username and password for the authentication.
  2. Once you enter the correct user name and password, a dialog box appears to confirm the starting of the process . Click Yes to start the load data only process, or click No to terminate the load data only process.
  3. After you start the load data only process, the Filling bccnv400/401/402 tables dialog box appears. Click Stop to stop the load data only process.
  4. You have the flexibility to load tables in a particular range, or a particular table. Make the selection by package, by module, or by a table using Select Table Range for Load Only without Dumping (bccnv0205m000) session.
  5. After the selection is complete, the system scans for the tables that can be loaded in the range specified.
  6. After that, the data loading process starts and the Loading data into the target environment session appears with the progress bar.
Note: 

The progress bar does not represent the progress of the loading process in terms of volume of data loaded but indicates the progress based on the number of tables loaded so far.

After the loading process is finished, Loading Complete message box appears.

The control files (.ctl) are required to provide the input to the native Database Loader in case of Oracle database, about the format of the .dat file from which the data needs to be picked up and loaded into the specific target tables.

Type of files generated by the Load Without Dumping (bcrun0103m000) session:

  • Log files : The log files (.log) are created by the native Database Loader for every non empty data file in case of the Oracle database, indicating the result of data loading process from the data files (.dat). The log files (.log) are created in the same directory where the data files are located. After executing the Load Without Dumping (bcrun0103m000) session, log files (.log) must be checked to analyze the reason behind failure to load the data if the bad files (.bad) exist. Using the log file, you can determine the number of rows successfully loaded for a particular table, number of rows not loaded due to data errors and so on. In case there are any rows not loaded due to data errors then the reason behind the failure is also present in the log file and the rejected row(s) data is present in the bad file.
  • Bad files : The bad files (.bad) are created by the Oracle and MSSQL Server native Data Loader in the same directory where the data files are located to specify the records that were rejected due to data errors. These files are created with the name <Target tablename>.bad.
  • Reject Files : These files are created by the Informix Database Loader utility in the same directory where the data files are located to specify which records were rejected due to data errors. This file contains the records that were rejected due to data errors. These files are created with the name <Target tablename>.rej.
Company Number

The target company into which the data must be loaded.

Use Database Independent Loaders?

Please refer to Use Database Independent Loaders? in Conversion Parameters (bcgct0100m000) session.

DBMS

Please refer to RDBMS in Conversion Parameters (bcgct0100m000) session.

Data Base Home & SID

Please refer to Data Base Home & SID in Conversion Parameters (bcgct0100m000) session.

Database

Please refer to Database in Conversion Parameters (bcgct0100m000) session.

Server

Please refer to Server in Conversion Parameters (bcgct0100m000) session.

Log File Path

Please refer to Log File Path in Conversion Parameters (bcgct0100m000) session.

User Name of Loader

Please refer to Username for Loader in Conversion Parameters (bcgct0100m000) session.

Max Rejections

The value entered here is used during loading. While loading a table, if the errors encountered are equal to the value entered here then the loading of the table will be terminated. The process of loading continues with the next table available.

Pass Word of Loader

Please refer to Password for Loader in Conversion Parameters (bcgct0100m000) session.

Path of Data Files

Enter the path where the data files are located.

Date Format

This field is applicable only if the target ERP database is Oracle. While creating the data files in Source ERP Environment, a file 'dateformat' is created, which stores the date format in which data is written to the data files. In the absence of that file, the format specified in the field is considered for generating Oracle Control files for loading.

Company of ManmanHP Data

Current company at the source environment side.

Company in which EMM data is stored

The Enterprise Modelling data for all the companies can be present in a single company at the target side. The company in which this data is stored must be specified in this field. While migrating the source data, the EMM data is loaded into the tables of that company.

same

Batch Code

The batch code for which you selected Load Without Dumping option in Maintain Batch Codes (bcgct8188m000) session is displayed.

Only the table information maintained using Tables by Batches (bcgct8189m000) session for the selected batch code will be considered while performing the loading activity.

Store Conversion Run details?

If this check box is selected, the conversion run details such as number of records at every conversion phase, time taken for dumping and loading process are stored.

Run Number

Select the run number from Conversion Run Numbers (bcgct1550m000) zoom-in session where the conversion run details are to be maintained.

Dump&Load Time

Select this check box if you want to maintain time taken for dumping and loading process.

Count records after conversion?

Please refer to Count records after conversion? in Conversion Parameters (bcgct0100m000) session.