To use the file activity report in SAP ESP Cockpit, create a database user and table in the database into which the SAP IQ Output adapter is loading data.
The script adds a user called RAP_USER, and a table owned by this user called RAP_WORK_FILE. It also grants the RAP_USER permission to perform client-side loads. RAP_USER can be used as the user through which the SAP IQ Output adapter connects to the SAP IQ database. If another user connects the adapter to SAP IQ, that user must have read and write permissions on the RAP_WORK_FILE table owned by RAP_USER. See the SAP IQ documentation for further details on these permissions.
While the adapter is running, RAP_WORK_FILE collects information about every file that is created and loaded by the adapter. This allows the file activity report to function as an archive for adapter activity.
If you remove rows that represent files in the process of being written or loaded, an error is written in the Event Stream Processor server logs on the next start-up of the adapter, and that file is not tracked in the file activity report. SAP recommends that you only delete rows that represent files that were completed or in error (columns for which the LOAD_STATUS is C or E respectively).