Access Data Provisioning Agent logs directly from DataSphere

Hi,

Here is the problem statement:

In order to troubleshoot issues with the data provisioning agent you want to have a look at the agent logs and traces (framework_alert.trc and framework.trc) but you do not have access to the DP agent server.

Solution:

This small configuration will help you access the agent logs directly from Datasphere environment. Follow the steps below:

Step 1: Pre-requisite

Ask your DPAgent administrator to perform the following steps

1. Log in to agent server and navigate to <DPAgent_root>/bin
2. Start the agent configuration CLI  tool with argument ‘– setSecureProperty‘ | * On Windows: agentcli.bat –setSecureProperty   * On Linux, ./agentcli.sh –setSecureProperty
3. Choose ‘Set FileAdapter Access Token‘ and specify the token
4. Confirm and make note of the token, exit CLI.

Example below with windows cmd run as administrator

Set the ‘token’ like a password with minimum 6 characters and complex enough.

Save the token and exit CLI.

Step 2: DS procedure

Log in to the DataSphere environment and navigate to Configuration  -> Data Integration

On the agent tile click edit –

In the Agent Settings dialog, set Enable Log Access to true.

In the File Adapter Password field that appears, enter the File adapter access token that was setup in Step 1.

save the settings.

Step 3: Last step, View the logs

Log in to the DataSphere environment and navigate to Configuration  -> Data Integration

On the agent tile click ‘Review logs’

Choose filters and apply, view or export logs as csv.

The framework_alert.trc and framework.trc logs are written to the database of SAP Datasphere. You can now review the current and archived log files from the agent’s tile itself.

Reference: SAP note 2554427 – How to set a new access token for SDI FileAdapter via command line tool

Regards,

Shoeb