Agent support tools¶

Introduction¶

The Agent Support Tools described on this page are a set of diagnostic and reporting commands.

Use them to see how your agent is performing, or when requested by Jitterbit support.

To access the tools, run the following commands:

LinuxWindows

$ cd /opt/jitterbit/AgentSupportTools
$ ./run.sh

$ cd C:\Program Files\Jitterbit Agent\AgentSupportTools
$ .\run.bat

The tools are ready when you see the JB Agent Tools> prompt. From here you can enter any of the commands listed below.

Tip

Enter the first few characters of a command then press the Tab key to see those that match.

`help`¶

Description¶

Show all available commands.

Usage¶

help [COMMAND]

Options¶

COMMAND: Show help for a command.

`apache-stat`¶

Description¶

Show the status of the Apache service.

Usage¶

apache-stat [-j]

Options¶

-j: Write the output in JSON format.

Examples¶

JB Agent Tools>apache-stat
Busy Workers | Idle Workers | Total Workers | Free Capacity
-----------------------------------------------------------
           1 |          255 |           256 |           99%

JB Agent Tools>apache-stat -j
{
  "busy_workers": 1,
  "idle_workers": 255,
  "total_workers": 256,
  "capacity_percent":99
}

`clear`¶

Description¶

Clear the console.

Usage¶

clear

Options¶

None

`connection-check`¶

Description¶

Check the connections from the private agent to the Harmony gateway, and the private agent's Apache and Tomcat servers.

Usage¶

connection-check [-t]

Options¶

-t: If traceroute is installed, include its output for the Harmony gateway host address.

Examples¶

JB Agent Tools>connection-check
connection-check
***** Harmony *****

Ping: na-east.jitterbit.com
Harmony gateway is reachable

***** Apache *****
Apache Is reachable on port 46908

***** Tomcat *****
Tomcat is reachable on port 46912.

`exit`¶

Description¶

Exit the program.

Usage¶

exit

Options¶

None

`generate-report`¶

Description¶

Create the following files:

report.html: A report showing the agent's operations, pending operations, Apache statistics, PostgreSQL server connections, system log files, and services.
jitterbit-logs.zip: A zip file containing private agent log files.

Usage¶

generate-report [-p OUTPUT_DIRECTORY]

Options¶

-p OUTPUT_DIRECTORY: Save the files in the specified directory.

`list-connectors`¶

Description¶

Show downloaded and loaded connectors.

Usage¶

list-connectors [-p AGENT_PORT]

Options¶

-p: Port the agent runs on.

Examples¶

JB Agent Tools>list-connectors
list-connectors
---------------------------
Downloaded connectors
---------------------------
SAP - 1.0.0
Smart Recruiters - 1.0.0
Jira - 1.0.1
AI - 1.0.0
SalesforceEvents - 1.0.0

---------------------------
Loaded connectors
---------------------------
SAP - 1.0.0
SalesforceEvents - 1.0.0
CLARIZEN - 1.0.0
FOUR51 - 1.0.0
FOUR51 - 1.0.0
Smart Recruiters - 1.0.0
Jira - 1.0.1
CLARIZEN - 1.0.0
AI - 1.0.0

`list-ops`¶

Description¶

Show operations.

Usage¶

list-ops [-d] [OPERATION_NAME_FILTER]

Options¶

OPERATION_NAME_FILTER: Show operations starting with this text. Default: jb-agent-tools-.
-d: Show more details.

`log-sync`¶

Description¶

Show the number of items in the private agent log queue for each of the states processed, unprocessed, and error.

Usage¶

log-sync

Options¶

None

`pending-ops`¶

Description¶

Show the number of scheduled and child requests in a running or waiting state.

Usage¶

pending-ops [-j]

Options¶

-j: Write the output in JSON format.

`pg-connection`¶

Description¶

Show the status of open PostgreSQL connections.

Usage¶

pg-connection [ -m MODE] [-j]

Options¶

-m MODE: Choose how to make the connection, where MODE is one of the following:
- conf: Use the information in the jitterbit.conf file.
- postgres: Connect to the PostgreSQL server.
- pgbouncer: Connect to the pgbouncer service.
-j: Format the output as JSON.

Examples¶

JB Agent Tools>pg-connection
pg-connection
count | state
---------------
    5 | null
    1 | active
   12 | idle

JB Agent Tools>pg-connection -j
pg-connection -j
[{"count":5,"state":null},{"count":1,"state":"active"},{"count":13,"state":"idle"}]

`pg-status`¶

Description¶

Show the database size, and list tables with the highest number of table scans and affected rows.

Usage¶

pg-status

Options¶

None

Examples¶

JB Agent Tools>pg-status
pg-status
                     Table |       Scans (Sequential-Index) | Affected rows (Inserted-Updated-Deleted)
-----------------------------------------------------------------------------------------------------
            incomingmsgtab |              317439 (7-317432) |                  44 (15-14-15)
       verboseloguploadtab |                21450 (3-21447) |                      0 (0-0-0)
                key_values |              18797 (18177-620) |               1081 (11-1069-1)
                logsynctab |             16194 (13318-2876) |              330 (110-110-110)
              deploylogtab |                   312 (21-291) |              674 (230-229-215)
   operationdataelementtab |                     32 (20-12) |                752 (376-0-376)
   document_definitionstab |                        5 (5-0) |                592 (296-0-296)
    filestorepropertiestab |                        9 (7-2) |                408 (204-0-204)
 transformationdefinitionstab |                      17 (17-0) |                400 (200-0-200)
    operationpropertiestab |                      34 (34-0) |                344 (180-0-164)
-----------------------------------------------------------------------------------------------------

Database size: 16 MB

`resync-deploylogs`¶

Note

Added in private agent version 11.29.

Description¶

Download the deploy logs from Harmony to re-synchronize them for a given environment ID.

Usage¶

resync-deploylogs -e ENVIRONMENT_ID [-p AGENT_PORT]

Options¶

-e: Environment ID.
-p: Agent port number.

`run-op`¶

Description¶

Run an operation specified by its ID, then show the status.

Usage¶

run-op [-l OPERATION_ID LOOP_COUNT] [-r OPERATION_ID DELAY] [-s OPERATION_ID]

Options¶

-l: For LOOP_COUNT number of times, run operation OPERATION_ID.
-r: Run operation OPERATION_ID in an infinite loop with a delay between runs.
-s: Stop infinite loop operation OPERATION_ID.

`service-status`¶

Description¶

Show the status of the Apache, Tomcat, Postgres, Pgbouncer, and VerboseLogShipper agent services.

Usage¶

service-status

Options¶

None

`zip-logs`¶

Description¶

Create a zip file containing all agent logs.

Usage¶

zip-logs [OUTPUT_DIRECTORY]

Options¶

OUTPUT_DIRECTORY: Save the .zip file in the specified directory.

Examples¶

JB Agent Tools>zip-logs
zip-logs
Zip filed created in: /opt/jitterbit/AgentSupportTools/jitterbit-logs.zip

JB Agent Tools>zip-logs /var
zip-logs /var
Zip filed created in: /var/jitterbit-logs.zip

Agent support tools¶

Introduction¶

help¶

Description¶

Usage¶

Options¶

apache-stat¶

Description¶

Usage¶

Options¶

Examples¶

clear¶

Description¶

Usage¶

Options¶

connection-check¶

Description¶

Usage¶

Options¶

Examples¶

exit¶

Description¶

Usage¶

Options¶

generate-report¶

Description¶

Usage¶

Options¶

list-connectors¶

Description¶

Usage¶

Options¶

Examples¶

list-ops¶

Description¶

Usage¶

Options¶

log-sync¶

Description¶

Usage¶

Options¶

pending-ops¶

Description¶

Usage¶

Options¶

pg-connection¶

Description¶

Usage¶

Options¶

Examples¶

pg-status¶

Description¶

Usage¶

Options¶

Examples¶

resync-deploylogs¶

Description¶

Usage¶

Options¶

run-op¶

Description¶

Usage¶

Options¶

service-status¶

Description¶

Usage¶

Options¶

zip-logs¶

Description¶

Usage¶

Options¶

Examples¶

`help`¶

`apache-stat`¶

`clear`¶

`connection-check`¶

`exit`¶

`generate-report`¶

`list-connectors`¶

`list-ops`¶

`log-sync`¶

`pending-ops`¶

`pg-connection`¶

`pg-status`¶

`resync-deploylogs`¶

`run-op`¶

`service-status`¶

`zip-logs`¶