Subscribe:

Ads 468x60px

Pages

HOW TO RESOLVE PRINTER Incorrect (Error Sending Data)

Sometimes in SAP, you get Incorrect (Error Sending Data) even though printer settings are ok.

  1. SPAD > enter you printer name
  2. Check output

  3. You will see Incorrect (Error Sending Data)

  4. This case, you click EDIT and Clear Cache

HOW TO send specific email in non production system via sost and scot


In non production environment, user will need to test sent messages. To do so:




  1. Now before you sent them, you have to configure your mail host to a valid address.
  2. Go SCOT > Double click om STMP

  3. Update mail host to a valid address. Then save.

  4. Now you can start sending message

  5. SOST > Identify which email has to be sent

  6. Highlight that message and click sent

  7. Ok to this message

  8. Message sent

HOW TO RESOLVE TRANSPORT HANGING ISSUE

At time when you perform transport, the truck will be hanging there. This is due to many reason. To resolve, try one of these:

1.       SA38 > Reschedule Job RDDIMPDP via program RDDNEWPP or RDDPUTPP

2.       SM59 > Test connection and authorization for RFC TMSADM@SID. Give sap_all profile to user  TMSADM

3.       Go to OS level and Kill tp.exe process
4.       SA30  > Clear table TRJOB and TRBAT

5.       Or enter this parameter in STMS > System Over view > Select System > Transport Tool >

6.       Then add SYSTEM_PF with value \\<host>\sapmnt\<sid>\SYS\profile\default.pfl

7.       Back and update configuration (CTRL-F2)


HOW TO BASIS - ADD administrator role in portal

Cannot launch Configuration in Portal NWA (NetWeaver Admin) to see the trusted system as below:

 

This problem is caused by the insufficient authorization of the ZSAP_J2EE_ADMIN_* which is copied from SAP_J2EE_ADMIN. To solve this, we need to assign the ZSAP_J2EE_ADMIN_* group to administrators security role in the Security Provider through the Visual Admin. We need this task to be carried out in the HR, BI and CRM Portal (Java Stack – Dev, QA, Regression and Prod) in order for us to maintain the trusted system in respective portal and also to complete the FPN (Federated Portal Network) setup.

 

Steps for resolution.

1.       Launch Visual Admin

2.       Go to Server --> services --> Security Provider

3.       Go to Runtime --> Policy Configurations --> Security Roles

4.       Select administrators, assign the ZSAP_J2EE_ADMIN_* to it.

 

HOW TO SAP - Excel inplace show empty because its due to “Macro” settings.

Excel inplace show empty because its due to "Macro" settings.

 

 

1.     1. Click the Microsoft Office ButtonButton image, and then click Excel Options,.

2.     2. Click Popular, and then select the Show Developer tab in the Ribbon check box.


3.     3. Now you are able to edit macro settings. Go to Developer tab


4.     4.Check Enable all macros & Trust access to VBA project.

5.    

 


 

 

 

 


HOW TO SAP - Find Top Most Expensive SQL

  1. Tcode Dbacockpit

  2. SQL statement



HOW TO SAP - Apply Snote




  1. Tcode SNOTE
  2. Click Download SAP note (Ctrl-F8)



  3. Enter note number and click execute



  4. Note finish download



  5. Search for your note



  6. From SAP Note > Display SAP note > this is to check if it can be implemented



  7. Finally you excute. Done

HOW TO SAP - Disable SAP GUI sound or notification

  1. Open SAPGUI
  2. Click Customized Local Layout (ALT+F12)
  3. Options > Interaction Design > Sound Settings

  4. Uncheck activate audio
  5. Apply OK




HOW TO SAP - SMT2 - Display Trusted system

  1. There is an easy way to check all trusted system status.
  2. Just execute SMT2

HOW TO SAP - Search Host Printer via Table TSP03D

  1. Go to SE16 and chose TSP03D

  2. Make sure you select 99999 entries

  3. Execute

  4. The field name for Host Printer is PAPROSNAME

HOW TO SAP - List R/3 User Types

List R/3 User Types
Dialog users are used for individual user. Check for expired/initial passwords.  Possible to change your own password. Check for multiple dialog logon 
A Service user - Only user administrators can change the password.  No check for expired/initial passwords. Multiple logon permitted 
System users are not capable of interaction and are used to perform certain system activities, such as background processing, ALE, Workflow, and so on. 
A Reference user is, like a System user, a general, non-personally related, user. Additional authorizations can be assigned within the system using a reference user. A reference user for additional rights can be assigned for every user in the Roles tab.  

HOW TO SAP - Download support pack

  1. Open http://service.sap.com/sp-stacks

  2. Click Software Downloads > Support Packages and Patches > SAP support Package Stacks


  3. Find your products


  4. Choose your Start SP Stack and Target SP Stack

  5. Click Next Step

  6. Select your current SAP Kernel version Eg: SAP KERNEL 7.10 64-BIT UNICODE (No instantiation selected)

  7. Look for your OS type and DB

  8. Next Step

  9. Select those you need


  10. Add to download basket.

  11. Now you may approve your download in Solman and use download manager to down the files.

HOW TO SAP - STMS transport hang with truck icon

  1. At times transport will hang with status Truck icon



  2. Check https://forums.sdn.sap.com/thread.jspa?threadID=972797&tstart=100

  3. Login into 000 and other clients with user ddic execute se38 run the report RDDNEWPP

  4. Choose option "normal"


  5. This will schedule a background job RDDIMPDP in sm37


  6. If Job was already schedule, you may reschedule again.


  7. Check on RDDIMPDP Finished job and go Job > repeat scheduling


  8. You may start immediate or just save to reschedule.

HOW TO SAP - Java Export OutofMemoryError: Java heap Space


  1. During Java export using sapinst, you encounter error.

  2. View C:/Program Files/sapinst_instdir/PI71/LM/MSS/COPY/EXP/AS-JAVA/EXP/jload.java.log

    SEVERE: java.lang.OutOfMemoryError: Java heap space (failed to allocate 256268168 bytes)
    at com.microsoft.sqlserver.jdbc.SQLServerBlob.getBytes(Unknown Source)
    at com.sap.sql.jdbc.common.CommonWrappedBlob.getBytes(CommonWrappedBlob.java:59)
    at com.sap.inst.jload.db.BlobHandler.writeValue(BitHandler.java:174)
    at com.sap.inst.jload.db.DBTable.unload(DBTable.java:245)
    at com.sap.inst.jload.Jload.dbExport(Jload.java:250)
    at com.sap.inst.jload.Jload.executeJob(Jload.java:503)
    at com.sap.inst.jload.Jload.main(Jload.java:743)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:161)
  1. Go to C:\Program Files\sapinst_instdir\PI71\LM\MSS\COPY\EXP\AS-JAVA\EXP

  2. Edit control.xml in a notepad


  3. Search and replace the following

  • jloadHeap from Xmx1024 to Xmx2048m


  • jdkArgs to Xmx512


  • jdkArgs to Xmx2048


  • jdkArgs to Xmx2048

HOW TO SAP - To Reset Administrator Password through Config Tool

1) Go to the Server Installed path i.e. usr\sap\\\J2EE\configtool\
2) Choose configtool.bat and start it.
3) Under Global Server Configuration, choose Services.
4) Find com.sap.security.core.ume.service, click it.
5) Under Global Properties, find ume.superadmin.activated
6) Set the Custom value to TRUE. Click on SET to apply the new value
7) Apart from that, you have to set another property i.e.
8) ume.superadmin.password, define some password.The password that you are defining is for SAP*. save the changes.
9) Restart the cluster / server. Issue the command stopsap to do so.
10) Log on to Portal with SAP* as user and the defined password.
11) Create a User with Super Administrator role.
12) Go back to Config Tool and set the Custom Value as default value i.e. FALSE. save the changes.
13) Restart the Server.



f you are able to logon to Visual Admin , You can create a new user and assign him administrator group or Reset password .
1) Go to the Server Installed path i.e. \usr\sap\\\j2ee\admin\go.bat Or in UNIX /usr/sap///j2ee/admin/go .
2) Choose go.bat / go and start it.
3) Under Cluster ->Server, choose Security Provider .
4) Select Tab 'Runtime' and Inner Tab 'User Management' , Click Create User .
5) And then assign to group Administrators .
6) No Need to restart J2EE engine , Open http://:/irj/portal .
7) Now you can User Administration Identity Management , Search for Administrator user and Unlock it . etc ....

HOW TO SAP - jload export fails with java.lang.OutOfMemoryError

Note 1276704 - jload export fails with java.lang.OutOfMemoryError



Symptom
A jload export of a MSSQL datasource fails with java.lang.OutOfMemory error.
Other terms
system copy, export, jload
Reason and Prerequisites
The used JDBC driver is Microsoft SQL Server 2005 Driver for JDBC (com.microsoft.sqlserver.jdbc.SQLServerDriver).
The table the jload fails to export contains LOB fields.

Solution
For the duration of the export we recommend to extend the URL of the export datasource by the property
responseBuffering=adaptive
Use configtool to do so.
This should avoid the memory problems.
After the export is done switch back to the original URL again.

Example:
original URL:
jdbc:sqlserver://PWDF6636:1433;databasename=BIG
changed URL: jdbc:sqlserver://PWDF6636:1433;databasename=BIG;responseBuffering=adaptive

Usage of configtool:
The configtool is normally located on $(DIR_INSTANCE)\j2ee\configtool
(for example: c:\usr\sap\\J\j2ee\configtool).
To start it, execute configtool.bat.
In the emerging popup, after the connect, click on "secure store".
The URL to change can be either directly modified in the "Secure Store Data" tab or the "Connection Pools" tab.
Edit this entry by double-clicking the URL-line and changing the value in the "Value:" line. Save by hitting "Add".
Save the setting by File->Apply Changes or hitting the floppy icon.


Header Data
Release Status:Released for Customer
Released on:03.03.2010 08:30:40
Master Language:English
Priority:Recommendations/additional info
Category:Workaround for missing functionality
Primary Component:BC-DB-MSS Microsoft SQL Server

HOW TO SAP - How to Launch configtool


  1. Go to usr\sap\SID\DVEBMGS00\j2ee\configtool

  2. Launch configtool.bat


  3. Configtool launched.

HOW TO SAP - Restart Java start

Proceed as follows to restart the Java stack of your SAP NetWeaver add-in installation (ABAP + Java):
...
1. Log on to the ABAP stack of SAP NetWeaver.
2. Open the list of SAP servers by calling transaction SM51.
3. Double-click the instance for which you want to restart the Java stack.
You are now connected to the selected instance.
4. Start the ICM Monitor (transaction SMICM) by entering /nSMICM in the command field.
5. In transaction SMICM, choose Administration ® J2EE Server ® Send Soft Shutdown ® With Restart.
6. The corresponding SAP NetWeaver Java stack for your instance is stopped and restarted.

HOW TO SAP - Download Support Pack

  1. https://websmp106.sap-ag.de/sp-stacks

  2. Sap Support Package Stacks > Choose your component and new window will popup

HOW TO SAP - Check Total Spool Request

  1. SPAD > Admin Tab > Print request overview


  2. There are 128,962 of total spool request. Its consider a lot.

HOW TO SAP - Delete Old Spool with RSPO0041 (JOB SAP_REORG_SPOOL)

  1. From RZ20 > CCMS monitoring template > Spool > Spool System > Spool Servers > R3Ssyslog > Spool is full


  2. To clear the spool there are 2 ways.


  3. Check if background job SAP_REORG_SPOOL already ran successful from SM37


  4. This means it spool deletion job runs everyday.

  5. You can still manually run it via SA34 with program RSPO0041



  6. Cleared

HOW TO SAP - SAPCAR could not open for writing sapcar.exe Error 28

"SAPCAR could not open for writing sapcar.exe .
The process cannot access the file because it is being used by another process.


To resolve the issue.

  1. Rename the sapcar.exe to sapcar1.exe
  2. Now try again
Related Posts Plugin for WordPress, Blogger...