SAP NW Newbie: Blog on SAP, Oracle, Ubuntu, UNIX and Windows

"Textpad" in Browser

If you wish to take notes, you can do it on your browser itself.
Type the following line in the address bar and you have temporary text document
data:text/html, <html contenteditable>

How to Automate SLD Log Cleanup

Changes to SAP SLD are logged into the table BC_SLD_CHANGELOG. To prevent the growth of this log table, you can schedule a job from SLD UI

Navigate to http://<host>:<port>/sld > Administration > Changes > Cleanup Task Configuration
Select the "Schedule Task" button to trigger a Configuration Wizard

Enter a value for Repeat Interval (frequency of the job in hours)
Enter a value for Retention Period (entries older than this date will be deleted)

A job with name Changelog Cleanup Task will be created. This job can be monitored from Java Scheduler UI in NWA.

Note: If you have configured SLD synchronization in a circular fashion DEV > QA > PRD > DEV, the changes made on one system will cause BC_SLD_CHANGELOG to grow very fast. Break the circular SLD update and cleanup the entries from http://<host>:<port>/sld > Administration > Change log > Reduce Size of Change Log > delete "obsolete" entries.

Migrating SLD Server on SAP XI

Migrating SLD Server

If you have been using a single SLD server for DEV, QA & Prod and are now considering to have separate ones here are the changes you require on SAP XI system to point to a new SLD server.

Export SLD content from the current SLD server

Call http://<sourcehost>:<sourceport>/sld --> Adminstration --> Export
Choose the option ALL and Full Export
Download the exported file

Start the new SLD server http://<targethost>:<targetport>/sld --> Adminstration --> Start Server
Check Technical Systems and Business Systems to ensure that the SLD on the new server is empty (and clear the data from any previous SLD import effort)
Import the downloaded SLD content in the new SLD server

Call http://<taregthost>:<targetport>/sld --> Adminstration --> Import
Choose the path to the exported file

Open Exchange profile and update the following entries to reflect the new SLD server details

com.sap.aii.connect.landscape.name
com.sap.aii.connect.landscape.httpport
com.sap.aii.connect.cr.name
com.sap.aii.connect.cr.port

Change the SLD server details in SLD Data Supplier service --> Runtime --> HTTP Properties
Change the SLD server details using ABAP transaction SLDAPICUST
Start the SLD bridge from http://<targethost>:<targetport>/sld --> Adminstration --> Data Supplier Bridge Adminstration (maintain the gateway details of new server)
Change the SLD bridge gateway details using ABAP transaction RZ70

Check the transaction SLDCHECK to ensure the changes are correct

ORA-00059 maximum number of DB_FILES exceeded

Fixing ORA-00059 maximum number of DB_FILES exceeded

The number of datafiles per database is limited by the parameter DB_FILES.

You can check the current limit using the following SQL command:
show parameter db_files;

You can check the curent number of datafiles the following SQL command:
select count(*), max(file#) from v$datafile;

When the curent number of datafiles equals DB_FILES, the next attempt to add a datafile will error out with code ORA-00059.

The limit can be increased (for example to 300) using the following SQL command. The changed requires a restart of database.
alter system set db_files=300 scope=spfile;

SAP Note Shortcut on Chrome

We have seen how one can define a search engine for searching SAP notes from Firefox. It can be done on Chrome as well.

Right click on the address bar and choose Edit search engines...

Fill out the fields as follows
Name: sapnote
Keyword: s
URL: https://service.sap.com/sap/support/notes/%s

When trying to open a note type s followed by the note number