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.
| Setting | Description |
|---|---|
| Username | The username for the remote database to connect to for state handling |
| Password | The password for the remote database to connect to for state handling |
| Host | The IP address of the SAP System. |
| Database | Select the relevant database profile to connect to a remote database for state handling |
| Enable Load Balancing | Select this check box to enable load balancing for SAP Jco. |
| System ID | The 3 character code for the SAP System |
| Message Server Host | The hostname/IP of the SAP Message Server |
| Message Server Port | The port of the SAP Message Server |
| Group Name | The group name associated with the SAP System |
| SAP System Number | The SAP System number |
| SAP Client Number | The SAP Client number |
| Table Parameter Name | The name of the table in the SAP System to which the records are to be uploaded |
| Two Phase Commit | Select 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 Size | The number of records to be inserted for each commit |
| Enable Connection Pool | Select this check box to use a connection pool to communicate with the SAP JCo Uploader. |
| Max Idle Connections | The 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 Connection | The maximum number of active connections that can be created for a destination simultaneously. The default value is 10. |
| Thread Count | The number of threads simultaneously uploading into the SAP System. The minimum value is 1. The default value is 2. |
| Max Queue Size | This 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.
- Records are committed in sub batches. For further information, see the Commit Size setting in the table described under Connection Tab.
- For every successful commit, an entry is inserted into the database, consisting of the
WF_NAME,FILENAME,START_POSITIONandEND_POSITIONof the sub batches. - 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[hide]3.0[/hide].
Emits
This agent does not emit anything.
Retrieves
Command | Description |
|---|---|
| Consume | As this agents's action depends on the data of the Processing begins when the This initial consume instance is only when the agent receives the When every |
| Commit | Removes 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:
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.
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.
0 Comments