(SP31) Writer Maintenance

Application Logs

When the Writer loads and deletes requests in InfoCubes, the information is recorded into the application log. The application log can be accessed with the transaction SLG1.

Fill in the following fields to access the Writer logs in SLG1:
Object - /DVD/NLS_W2
Subobject - /DVD/NLS_W2_CUBE
External ID are specified according to the following Writer operations:

• DTP* – by DTP loads
• IPAK* – by InfoPackage loads
• CDEL* – by deletion of requests from InfoCube

The first example of an application log created by a load into an InfoCube through an InfoPackage:

_{Filter for application log for request 34040 loaded into the InfoCube ZPKWC01 via InfoPackage}

_{Application log for a request loaded into an InfoCube via InfoPackage}

The second example of an application log created by a load into an InfoCube through a DTP:

_{Filter for application log for the request 34042 loaded into the InfoCube ZPKWC01 via DTP}

_{Application log for a request loaded into an InfoCube via DTP}

_{Filter for application log by a request deletion from the InfoCube ZPKWC01}

_{Application log for a request deleted from an InfoCube}

Tables (SE16)
/DVD/NLS_W2_STAT

This table stores information about the loading of data into the NLS archive. This information tells us which requests were loaded or activated, e.g. the number of records that were updated, inserted, or deleted.
A – Activation
D – Deletion
I – Insertion
L – Loading

/DVD/NLS_W2_LOAD

This table serves as a white list for DTP full loads. By default, the support of DTP full loads by the Writer is disabled (the parameter WRITER_CHECK_FULL_LOAD is by default set to X). In the case you want to enable the full loads, you can disable the parameter WRITER_CHECK_FULL_LOAD by setting it to an empty value (WRITER_CHECK_FULL_LOAD = ""). When you want to enable the full load only for some DTPs or InfoPackages you must insert them into this table.
Reports (SE38)

_{Report /DVD/NLS_W2_DISPLAY_MSG}

/DVD/NLS_W2_DISPLAY_MSG 

Displays messages that inform us about the time when the NLS Writer processes InfoCubes data loads.

/DVD/NLS_W2_CHECK_DSO 

Based on the selected DataStore objects this report searches in the active table for locked data. If Repair affected DSOs is selected and locked records are found a background process starts that moves the locked records into an archive. It is possible to set the number of used background processes in the settings of the Writer.

_{Report /DVD/NLS_W2_CHECK_DSO}

/DVD/NLS_W2_CONSISTENCY_REPAIR 

In the case whole packages are deleted by the Writer, there may occur discrepancies in SAP archiving tables. In this case, this report repairs the standard SAP archiving tables. A dialog job searches for missing packages and fills them in SAP tables. When you select Synchronize archived records a background job will reload all packages of selected requests, count the rows, and update tables with the correct numbers.

_{Report /DVD/NLS_W2_CONSISTENCY_REPAIR}

List of affected tables:

• RSDAREQDPAK – added records for packages which were completely deleted
• RSDANLREQDPAKSEG – added records for packages which were completely deleted
• RSDAREQ – modified number of displayed packages for fields data_packages, copied_dpak, verified_dpaks

/DVD/NLS_W2_EXP_DEL_GEN_REPS 

This report deletes generated reports for selected InfoCubes. Reports are generated for every transfer rule where the Writer was used.

_{Report /DVD/NLS_W2_EXP_DEL_GEN_REPS}

/DVD/NLS_W2_REQ_STATE_REP 

This report repairs the status of an inactive request, which may stay inactive if the Writer dumps. It will check the state of an NLS request in standard SAP tables and update this state in the table /DVD/NLS_REQ.

_{Report /DVD/NLS_W2_REQ_STATE_REP}

/DVD/NLS_W2_XPRA_ACTIVATE_ENHO 

This report must be executed after the import of the NLS Writer. The main functionality is to reactivate all methods and function modules in which Writer enhancements are created. It also defines templates for generating transfer rules used during the loading of data into InfoCubes.

/DVD/NLS_W2_XPRA_ADD_SETTINGS

This report must be executed after the import of the NLS Writer. It adds missing Writes settings, which were developed for the new Writer version. By selecting Set to defaults this report can also reset the settings for the NLS Writer to default.

_{Report /DVD/NLS_W2_XPRA_ADD_SETTINGS}