SAP JCo Uploader Agent Configuration(3.1)

Owned by Jenni Wallin
May 10, 2023
3 min read

Configuration

The following describes the configuration fields for the SAP JCo Uploader Agent.

Connection Tab

The connection tab allows you to set the credentials required to connect to the SAP server as well as customize the way your session behaves when connected.

SettingDescription
UsernameThe username for the remote database to connect to for state handling
PasswordThe password for the remote database to connect to for state handling
HostThe IP address of the SAP System.
DatabaseSelect the relevant database profile to connect to a remote database for state handling
Enable Load BalancingSelect this check box to enable load balancing for SAP Jco.
System IDThe 3 character code for the SAP System
Message Server HostThe hostname/IP of the SAP Message Server
Message Server PortThe port of the SAP Message Server
Group NameThe group name associated with the SAP System
SAP System NumberThe SAP System number
SAP Client NumberThe SAP Client number
Table Parameter NameThe name of the table in the SAP System to which the records are to be uploaded
Two Phase CommitSelect this check box if you want records to be committed in two phases.
Session Timeout (minutes)This field determines the session timeout in minutes. This option is only available if you 
select the Two Phase Commit option. The default value is 10.
Commit SizeThe number of records to be inserted for each commit
Enable Connection PoolSelect this check box to use a connection pool to communicate with the SAP JCo Uploader.
Max Idle ConnectionsThe maximum number of idle connections kept open by the destination. A value of 0 means there is no connection pooling. The default value is 2.
Max Active ConnectionThe maximum number of active connections that can be created for a destination simultaneously. The default value is 10.
Thread CountThe number of threads simultaneously uploading into the SAP System. The minimum value is 1. The default value is 2.
Max Queue SizeThis field limits the maximum number of records waiting to be processed in the queue. This prevents an out of memory error from occurring if the SAP System is too slow to consume the records. The default value is 6000.

Agent Transaction Behaviour

The SAP JCo Uploader agent performs some extra maneuvers to ensure that records, for a particular file, that are already committed to the SAP System are skipped if the workflow aborts before the batch is completed successfully.

  1. Records are committed in sub batches. For further information, see the Commit Size setting in the table described under Connection Tab.

  2. For every successful commit, an entry is inserted into the database, consisting of the WF_NAME, FILENAME, START_POSITION and END_POSITION of the sub batches.

  3. If the file is successfully processed, at workflow commit, the agent removes all entries inserted into the database for the current file.

If the workflow aborts before the file is successfully processed, on the next re-run, the agent performs a database lookup, and gets the list of records that are already processed. Record numbers that are found in the database are skipped.


For information about the general  transaction behavior, see Workflow Monitor (3.0).

Emits

This agent does not emit anything.

Retrieves

Command

Description

Consume

As this agents's action depends on the data of the HeaderUDR, nothing is done in BeginBatch.

Processing begins when the HeaderUDR is received.

This initial consume instance is only when the agent receives the HeaderUDR. The agent gets the RemoteFunction from the SAP System based on the name in the HeaderUDR. This RemoteFunction is used to insert records into the SAP System.

When every RemoteFunction is committed, an entry of stateInfo is inserted into the database.

CommitRemoves all stateInfo data for the file from the database.

Input/Output

Input/Output defined here represents the type of data an agent expects and delivers.

Input

The SAP JCo Uploader agent consumes the following UDRs of the SAP_JCO type:

HeaderUDR

RecordUDR

Output

This agent does not have any outputs.

Meta Information Model

For information about the  MIM and a list of the general MIM parameters, see Administration and Management(3.0). 

Publishes

MIM Parameter

Description

Average Response Time (long)

The average response time (in milliseconds) for each execution and commit.
No of Executions (long)The total number of executions towards the SAP System.

Accesses

The SAP JCo Uploader agent does not access any MIM resources.

Agent Message Events

An agent message is an information message sent from the agent, stated according to the configurations made in the Event Notification Editor.

The SAP JCo Uploader agent does not publish any Message Events.

Debug Events

Debug messages are dispatched in debug mode. During execution, the messages are displayed in the Workflow Monitor.

The agent produces the following debug events: 

  • Discard record no <record number> as it has been processed
    Reported when a record is found to have already been processed.