Contents x
    Merging Two Extracts
    • 1 Minute to read
    • Print
    • Dark
      Light
    • PDF
    Contents

    Merging Two Extracts

    • 1 Minute to read
    • Print
    • Dark
      Light
    • PDF
    Article Summary

    If you run the Concurrent Manager on a different server than the Oracle Application server, a separate extraction must be done from each server. To validate the extractions were completed successfully from each server, check the ETL log that one extraction came from the Oracle Applications Server and one from the Concurrent Manager Server.
     
    A Merge tool is available to combine the two extracts into a single file to upload to Panaya’s servers.
    • Run the Panaya extractor both on the Oracle Applications server and on one of the Concurrent Manager servers, as described in the section: EXTRACTING THE CUSTOM CODE AND USAGE STATISTICS.

    Using your Oracle Apps OS user, execute the following command in order to merge the two files into one:

    java -cp panaya-extractor.jar MergeFiles appsETL=<oa_etl> concETL=<cm_etl> [<new_etl>]

    Parameters explanation

    • <oa_etl> – is the full path of the extracted filename from the Oracle Application server
    • <cm_etl> – is the full path of the extracted filename from the Concurrent Manager server
    • <new_etl> – is the full path of the merged extracted filename. This is an optional parameter; the default value, if not specified, is "ETL_MERGE_ + timestamp.zip"

    The merged file will be built as follows:

    • reports.zip/bin.zip/sql.zip – will be copied from the cm_etl file
    • framework.zip – will be copied from the cm_etl file, unless it is found in the oa_etl.zip file
    • Appl_tops.properties, etl.log – will be copied from the cm_etl and renamed to conc_appl_tops.properties, conc_etl.log
    • All other files will be copied from the oa_etl file

    Upload the merged file to Panaya Code Box

    What's Next