Before you begin
Manual
data loading, or initial one-time data loading is, as its name suggests,
a one-time process that loads all the necessary configuration data.
This task must be performed for each node separately.
Perform
the following steps to carry out one-time data loading:
Procedure
- Run the integration server or servers associated
with the Sterling Warehouse Management System data
upload services.
- Set the values for the following
environment variables
as specified in this list:
- YFS_RT must point to
the installation directory of the Sterling Warehouse Management System.
- ANT_HOME must point to the ANT installation directory.
- JAVA_HOME
must point to the Java™ installation
directory.
- Run the following ant
script from the <INSTALL_DIR>/bin
directory:
ant -f ynw_entity_uploader.xml -Dnode=Node
Here,
Node refers to the ship node.
Notes:
- For each entity that is uploaded,
the entity uploader utility
creates a restart file. The restart file has the key of the last entity
record processed. This key is used for subsequent data uploads when
the records that are already uploaded have to be ignored. The restart
files are created in the <INSTALL_DIR>/bin folder.
- Install
the following third party jars for the Websphere application
server:
- j2ee.jar
- com.ibm.ws.sib.client.thin.jms_7.0.0.jar
-
com.ibm.ws.ejb.thinclient_7.0.0.jar
- com.ibm.ws.orb_7.0.0.jar
-
com.ibm.ws.wccm.jar
After the installation is complete, the
AGENTDynamicclasspath.cfg file will be updated.
- Run the readSterlingDataLoadFiles.bat file from
the <Voxware
Install Folder>/vlp_core/voxconnect_build/bin/ directory. This file
invokes the following VLP Data Import events:
- VLP_WAREHOUSE_LOAD
- VLP_ZONE_LOAD
- VLP_LOCATION_LOAD
- VLP_EQUIPMENT_LOAD
- VLP_REASON_LOAD
- VLP_WORKTYPE_LOAD
- VLP_PRODUCT_LOAD
Notes:
- Sterling Warehouse Management System provides
only one batch file for all the events. However, it is recommended
that the user create separate batch files for individual events.
- The user must manually verify the log files to keep track of data
load failures, if any.