Blog Stats

  • 498,087 hits

Paid SAP Basis Consulting Services


Hi guys,

I am offering Remote SAP Basis Support and Service to your company. No matter your company have dedicated SAP Basis or not, we can help you. Your company could hire me as Remote SAP Basis.

You can check here for futher information.

Paid Support : Cheap SAP Print Management using Linux Client


My deepest regret that I have to do this in order to support me maintaining this blog since I have to maintain my internet connection. I need to charge to you if you want to get this simple information.

I am offering paid support to Basis who want to implement Linux Migration on workstation so that by using SAPGUI for Java on Linux can print smoothly as well as Windows-based SAPGUI client. On SAPGUI for Windows, you can easily print SAP documents. But you can’t do that when you’re using SAPGUI for Java on Linux.

Sign up for PayPal and start accepting credit card payments instantly.

If you are interested in this solution, please call me on YM : devratt.

Print SAP documents using Linux


A lot of people keep asking me how to print SAP R/3 documents using printer attached on Linux PC.

SAPGUI for Java is already installed on my Linux PC but I was unable to print any SAP documents ? We can’t use Frontend Printing (F acces method) since there was no SAPLPD program on it. Tell me how ??

(more…)

Installation and Configuration of SAPGUI for Java on Linux


Based on many questions in my email inbox, asking how to install and configure SAPGUI for Java on Linux, here I’ll explain it briefly.

Prepare these stuffs before you can proceed to installation :

  1. You have to make sure that your Linux system has been installed with JRE (Java Runtime Environment) from SUN Microsystem (http://java.sun.com). If you don;t have it, just download it from here. Some of linux distros such as Fedora, Ubuntu, OpenSuSE etc using JRE from GNU called GIJ (GNU for Java). We can’t use this JRE. We need to replaced it. I’ll show you how to changed it later.
  2. (more…)

Exsort_not_enough_memory / Exsort_setvbuf_failed / System_no_task_storage shortdump on SAP ERP 6


Exsort not enough memory, exsort setvbuf failed, and system no task storage shortdump is happening on my production SAP ERP 6 server after we migrated my ERP to my new hardware. After searching on SAP service marketplace and observing my new server settings, I have found out the problem.


(more…)

Different methods to Lock or unlock SAP users


I want to lock all the users in SAP during MTP.  I know using SU10 we can do it. Any other alternative ways to lock the users.

Is there a way in SAP to unlock a locked user for a limited time, then automatically after x time set the user back to lock status? 

You can fill in “valid from” and “valid until”, but you cannot say from Monday to Friday from 8 – 12:00 for part time workers. 

Can we schedule to lock all users?

If users get locked, from SU01 you can unlock them. 

Use SU10 to mass lock/unlock the users.

Use address data or authorisation data to get a list of users – select the ones you want and 

click transfer. 

Once this is done click on lock or unlock. 

You can also use transaction code EWZ5 to mass lock/unlock the users

or 

Execute program EWULKUSR in SE38

or 

Set a profile parameter (login/failed_user_auto_unlock) to unlock at midnight the locked users. 

or 

Here’s an ABAP code, short and simple, isn’t it? 

REPORT zreusrlock. 

DATA: time_limit TYPE sy-datum. 
DATA: days TYPE i VALUE 40. 

time_limit = sy-datum – days. 
UPDATE usr02 SET uflag = 64 WHERE trdat < time_limit.

If you don’t want to specify the time in the program, you can use SE38 to schedule it as a daily background job with the date and time.

or

Probably the easiest way would be to write a sqlplus SQL script that sets all the UFLAG fields in table USR02 to 64 EXCEPT for the BNAMEs you don’t want locked. When you are done, you can do the same again but change the UFLAG field to 0. 

The SQL statement would look like: 

update SAPR3.USR02 set UFLAG = 64 where MANDT = <client number> and BNAME != <don’t lock user 1> 
AND BNAME != <don’t lock user 2>; 

You can replace != with <> if you want. To run this from an OS command line, you would type: 

Unix/Oracle 8—> sqlplus internal @<SQLpath+SQLname> 
NT/Oracle 8.0—> plus80 internal @<SQLpath+SQLname> 
NT/Oracle 8.1—> sqlplus internal @s<SQLpath+SQLname> 
Unix/Oracle 9:–> sqlplus /nolog @<SQLpath+SQLname> 
NT/Oracle 9—–> sqlplus /nolog @<SQLpath+SQLname> 

In UNIX you can cron the script to schedule it. In NT you can schedule it as a task.

or

This is another method to UNLOCK ALL users. 

Start Oracle Server manager (I assume you are on Oracle) 
connect internal 
update sapr3.usr02 set uflag=’0′ where mandt=’399′; 

When users are locked, the uflag is set to 64. 

Finish, just query to check. 

select bname, uflag from sapr3.usr02 where mandt=’399′; 

Please note that unlocking users from low level (like Oracle sqlplus) should be used as last resort. Frequent use of low level access may tempt you to use on other things. Highly dangerous and your IS auditors will not be too happy. 

Is there a way to set a list of users that cannot be locked, even if we try to lock them manually, and even if they fail connection ( wrong password )?

Increase this parameter in SAP Instance profile: 

login/fails_to_user_lock = 6 (max is 99 wrong attempts, i.e, value 99). Currently you have a value of 3. 

login/failed_user_auto_unlock (for your midnight unlocking). 

Ask users to remember passwords!! If someone is deliberately login-in with different username/password (thereby blocking legitimate access of that user), check hostname from SM21. 

This is considered as DoS (Denial of Service). 

Howto mirror an AIX rootvg


The following steps will guide you trough the mirroring of an AIX rootvg.
This info is valid for AIX 4.3.3, AIX 5.1, AIX 5.2 and AIX 5.3.

  • Make sure you have an empty disk, in this example its hdisk1
  • Add the disk to the vg via “extendvg rootvg hdisk1
  • Mirror the vg via: “mirrorvg rootvg”
  • Adapt the bootlist to add the current disk, the system will then fail to hdisk1 is hdisk0 fails during startup
    • do bootlist -o -m normal
    • this will list currently 1 disk, in this exmaple hdisk0
    • do bootlist -m normal hdisk0 hdisk1
  • Run a bosboot on both new disks, this will install all software needed for boot on the disk
    • bosboot -ad hdisk0
    • bosboot -ad hdisk1

Oracle 11g Extended Statistics for SAP Tables


Extended Statistics is an attempt to fix one of the flaws in CBO–values of different columns are not correlated.

Let us take an example of two columns in a table. One of the column contain department code and the other contains employee name. Let us assume that there are 10 departments and 3000 employees in our example. In a real life scenario, all the employees do not belong to all the departments, but CBO assumes that is the case and hence it assumes that there are 3000*10 = 30000 combinations of employee name and department code that exist. In reality, it can be between 3000 and 30000 (assuming employee belongs to at least one department and can clock for multiple departments).
(more…)

Brief Description of SAP Executable


Here is a list of SAP executables that you may find on your SAP systems. If you know of SAP exe files missing in from list, please leave a comment:

R3check                     This is a tool that can check Cluster-Tables for errors.
R3ldctl                        The tool for exporting all table structures to the file system during an OS/DB-Migration.
R3load                        The table import & export tool of SAP during Installation, Upgrade and Migration.
R3szchk                     The tool for determine the sizes of the different tables in the target database during the import in an OS/DB-Migration.
R3ta                             Split large tables for export and import
R3trans                      This is the tool, that does the real work for tp. tp controls the import and export of changes and r3trans does them using scripts, that were generated from tp.
R3trans_164-20000978.SAR     R3trans_164-20000978.SAR’ is a compressed archive with the latest version of R3trans from the SAP Service Marketplace, used when we patched the kernel.
SAPCAR                         SAP Compression and Archiving program (more…)

Blink 182’s song lyric on SAP standard report


Check this on your SAP system (use SE38).

If you’re interested in the lyrics of Blink 182’s song “Obvious” (I am not), have a look at the SAP report RDDPUTJZ_REQUEST_COMP_CHECK3 and scroll down to the bottom :

comm1 = ‘DO NOT CHECK!’.

loop at screen.
if screen-group1 eq ‘CH0′.
screen-input = ‘0’.
endif.

modify screen.
endloop.

* Blink 182
* Obvious (more…)

Categories

October 2014
M T W T F S S
« Aug    
 12345
6789101112
13141516171819
20212223242526
2728293031  

Top Rated

Follow

Get every new post delivered to your Inbox.

Join 701 other followers