Posts

Showing posts from May, 2011

HOW TO RESOLVE PRINTER Incorrect (Error Sending Data)

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

SPAD > enter you printer nameCheck output

You will see Incorrect (Error Sending Data)

This case, you click EDIT and Clear Cache

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

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




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

Update mail host to a valid address. Then save.

Now you can start sending message

SOST > Identify which email has to be sent

Highlight that message and click sent

Ok to this message

Message sent

HOW TO RESOLVE TRANSPORT HANGING ISSUE

Image
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 Admin2.Go to Server --> services --> Security Provider3.Go to Runtime --> Policy Configurations --> Security Roles4.Select administrators, assign the ZSAP_J2EE_ADMIN_* to it.

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

Image
Excel inplace show empty because its due to "Macro" settings.1.1. Click theMicrosoft Office Button, and then clickExcel Options,.2.2. ClickPopular, and then select theShow 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

Image
Tcode Dbacockpit

SQL statement



HOW TO SAP - Apply Snote

Image
Tcode SNOTE
Click Download SAP note (Ctrl-F8)



Enter note number and click execute



Note finish download



Search for your note



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



Finally you excute. Done

HOW TO SAP - Disable SAP GUI sound or notification

Image
Open SAPGUIClick Customized Local Layout (ALT+F12)
Options > Interaction Design > Sound Settings

Uncheck activate audioApply OK



HOW TO SAP - SMT2 - Display Trusted system

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

HOW TO SAP - Search Host Printer via Table TSP03D

Image
Go to SE16 and chose TSP03D

Make sure you select 99999 entries

Execute

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

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

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


Find your products


Choose your Start SP Stack and Target SP Stack

Click Next Step

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

Look for your OS type and DB

Next Step

Select those you need


Add to download basket.

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

Image
At times transport will hang with status Truck icon



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

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

Choose option "normal"


This will schedule a background job RDDIMPDP in sm37


If Job was already schedule, you may reschedule again.


Check on RDDIMPDP Finished job and go Job > repeat scheduling


You may start immediate or just save to reschedule.

HOW TO SAP - Java Export OutofMemoryError: Java heap Space

Image
During Java export using sapinst, you encounter error.

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(OfflineToolSta…

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\a…

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…

HOW TO SAP - How to Launch configtool

Image
Go to usr\sap\SID\DVEBMGS00\j2ee\configtool

Launch configtool.bat


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

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

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

HOW TO SAP - Check Total Spool Request

Image
SPAD > Admin Tab > Print request overview


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

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

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


To clear the spool there are 2 ways.


Check if background job SAP_REORG_SPOOL already ran successful from SM37


This means it spool deletion job runs everyday.

You can still manually run it via SA34 with program RSPO0041



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.
Rename the sapcar.exe to sapcar1.exeNow try again