Posts

Job Scheduling Software

Enterprises using multiple ERP systems look for a a job schedulers that can work with SAP and other ERP or DW vendors alike. Third party tools are not advisable if the Enterprise runs purely on SAP ERP. They increase the TCO, increase delays in problem correction, create high dependencies among technologies, and increase chances of miscommunication. If varied technologies are being used, investing in a third party scheduler is useful to have a centralized scheduler. Here are some popular schedulers: Control-M by BMC Cronacle by Redwood ORSYP by Dollar Universe Tidal Enterprise Scheduler by Cisco Tivoli Workload Scheduler (Maestro) by IBM  UC4 Global by UC4
Post a Comment
Read more

"Textpad" in Browser

Image
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>
Post a Comment
Read more

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 > delet...
Post a Comment
Read more

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.la...
Post a Comment
Read more

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 ora error 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;
Post a Comment
Read more

SAP Note Shortcut on Chrome

Image
We have seen how one can define a search engine for searching SAP notes from Firefox . It can be done on Chrome also. 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
Post a Comment
Read more

Mass Changes to Step User of Background Jobs

The users define hundreds of jobs to meet their business needs. When they leave the company their user IDs will be deleted/locked/expired, requiring changes to the jobs on SAP system. Manually changing the step user ID of hundreds of jobs for a specific user ID is a tiring and error prone exercise. If you find yourself in such a situation, implement sap note 1532884 to import BTC_MASS_JOB_CHANGE report, which can help make the task relatively simple.
Post a Comment
Read more