星期日, 十月 30, 2011

configuration SAPGUI Java

Technical Background - Connection Strings
Connection String is a technical term used within SAPGUI for the Java Environment configuration. A connection string describes a connection address for a destination, e.g. an SAP system's application server, rather like an Internet URL describes a location for a web page.

Simple Connection Strings
In its simplest form, a connection string contains an IP address and a port number. These informations are sufficient for SAPGUI for the Java Environmant to open a direct TCP connection to a destination, e.g. an application server. IP address and port number are marked with the prefixes '/H/' (for host) and '/S/' (for service). Note that the portnumber for an SAP application server is by convention 3200 plus the two-digit SAP system number.

Example for a simple connection string with an application server's IP address (172.16.64.17) and portnumber (3200): 

/H/172.16.64.17/S/3200

If your network environment supports DNS (Domain Name Services), a hostname can be used instead of the IP address in all kinds of connection strings. (This requires a correct DNS configuration at the frontend computer, e.g. via the /etc/hosts file).

Example with an application server's hostname (iwdf8997.wdf.sap-ag.de) and portnumber (3200):

/H/iwdf8997.wdf.sap-ag.de/S/3200

If your network environment supports symbolic service names for well-known ports, the symbolic service name can be used instead of the port number in all kinds of connection strings. (This requires a correct service configuration at the frontend computer, e.g. in the /etc/services file). Note that SAP application server ports are by convention named 'sapdp<SID>', where <SID> is the SAP system id.

Example with host name (iwdf8997.wdf.sap-ag.de) and symbolic service name (sapdpIWD):

/H/iwdf8997.wdf.sap-ag.de/S/sapdpIWD

Simple connection strings need not be resolved by the GUI application. Resolution of host names and symbolic service names is done by the operating system's network layer.

SAP Routers
In a WAN (Wide Area Network) environment, SAP routers are used to make connections to remote SAP systems that cannot be reached with a direct TCP connection. Passwords may be used for each SAP router to control access.

In order to make a connection, the frontend computer is responsible for providing the complete route to the destination, possibly including a chain of several SAP routers. Path information is not provided by the routers. (Strictly speaking, a SAP router is actually better described as an application level proxy with password capabilities and strict source routing).

The address for each router is specified by a simple connection string (with the router's host name and port number), optionally followed by '/P/' and the router password. The path from the current location to the destination is described by appending all router addresses together, followed by the address of the destination SAP system. Thus, a connection string with SAP routers generally has the form <router 1><router 2>...<router n><destination>.

Example with two routers (gate.acme.com, port 3299, and gate.sap.com, port 3298), the first using a password (secret), for a connection to the application server iwdf8997.sap.com, port 3200):

/H/gate.acme.com/S/3299/P/secret/H/gate.sap.com/S/3298/H/iwdf8997.sap.com/S/3200
<-------- 1st router ----------><---- 2nd router ----><------ app_server ------>
Connection strings including SAP routers are passed to the GUI's communication layer and resolved step by step by the routers on the path. If host names and symbolic service names are used, each router must have access to correct network configuration information to resolve them.

Message Servers and Logon Groups
For load balancing purposes, application servers from one SAP system are usually configured in logon groups, where each group serves a particular kind of user. The application servers in each group are assigned to users by a least-heavily-loaded strategy. This load balancing is done by message servers. Each SAP system has exactly one message server, which can be reached via TCP on a specific message server port.

Care should be taken that the application server's port number is not confused with the message server's port number. Although the message server's host name may in small installations often be identical to the hostname of an application server, the port number is always different. Symbolic service names for message servers by convention have the form 'sapms<SID>', where <SID> is the SAP system id.

Message server and group information can be used to address a SAP system in a connection string. The address of the message server is specified as a combination of message server host name, message server port and group name. These informations are marked with the prefixes '/M/' (message server host name), '/S/' (message server port) and '/G/' (logon group).

Example with message server (hostname alrmain, port number 4253) and logon group (SPACE):

/M/alrmain.wdf.sap-ag.de/S/4253/G/SPACE

Connection strings with message servers are resolved by SAPGUI for the Java environment by contacting the message server and retrieving the (simple) connection string of an application server for the specified group. This requires network access to the message server at the time the address is resolved.

SAP router connection strings may be used in combination with message server connection strings simply by specifying the router address before the message server address. The router is then used for contacting the message server as well as for contacting the resolved application server.

Symbolic System Names
The most user-friendly form of connection string addresses an SAP system only by its symbolic name (per convention, the system id) and the logon group name. These informations are marked with the prefixes '/R/' (for the symbolic SAP system name) and '/G/' (for the logon group name).

Example with SAP system (ALR) and logon group (SPACE):

/R/ALR/G/SPACE

Connection strings with symbolic system names are resolved by SAPGUI for the Java Environment by looking up the symbolic SAP system name in the Message Server List (a text file containing a mapping between symbolic system names and message server addresses) and replacing the /R/ part of the connection string with the resulting message server address. The result is a complete message server connection string which is then further resolved as explained above.

Formal syntax
For the technically interested reader, the following BNF grammar formally describes the syntax of connection strings:

<connection string> := [<router prefix>]<local>
<local>             := <simple>|<message server>|<symbolic>
<simple>            := "/H/"<host>"/S/"<service>
  <host>            := <hostname>|<ipaddr>
    <hostname>      := (any DNS hostname)
    <ipaddr>        := (any IP address, in dotted decimal form)
  <service>         := <servicename>|<port number>
    <servicename>   := (any IP service name)
    <port number>   := (any decimal number)
<messageserver>     := "/M/"<host>"/S/"<service>"/G/"<group>
  <group>           := (any ASCII string not containing '/')
<symbolic>          := "/R/"<system>"/G/"<group>
  <system>          := (any ASCII string not containing '/')
<router prefix>     := <router>*
  <router>          := "/H/"<host>"/S/"<service>["/P/"<password>]
    <password>      := (any ASCII string not containing '/')

星期三, 十月 26, 2011

Automatic Updates options are greyed out?

Automatic Updates options are greyed out?

Published : April 10, 2005
Send your feedback

Symptom

When you open the Automatic Updates tab in My Computer Property sheet, or from Control Panel, all of the Automatic Updates configuration options may be grayed out. This happens due to any of the following reasons:

  1. You're not logged on as Administrator (or equivalent)

  2. Automatic Updates Policy is enabled

  3. Automatic Updates (and Windows Update) access is blocked via Group Policy

Resolution

To make the Automatic Updates options configurable by the user (only for stand-alone systems), remove the restrictions 2 & 3 above.

  • Click Start, Run and type REGEDIT.EXE

  • Navigate to this location:

HKEY_LOCAL_MACHINE SOFTWARE Policies Microsoft Windows WindowsUpdate AU

  • In the right-pane, delete the two values AUOptions and NoAutoUpdate

  • Navigate to this location:

HKEY_CURRENT_USER SOFTWARE Microsoft Windows CurrentVersion Policies WindowsUpdate

  • In the right-pane, delete the value DisableWindowsUpdateAccess

Using the Group Policy Editor - for Windows XP Professional

  • Click Start, Run and type gpedit.msc

  • Navigate to the following location:

=> Computer Configuration
==> Administrative Templates
===> Windows Components
====> Windows Update

  • In the right-pane, double-click Configure Automatic Updates and set it to Not Configured

  • Then, navigate to this location:

=> User Configuration
==> Administrative Templates
===> Windows Components
====> Windows Update

  • In the right-pane, set Remove access to all Windows Update features to Not Configured

 查看全文

星期三, 十月 19, 2011

批量查找替换excel单元格中的软回车(alt + enter)

一、查找excel单元格中的换行符(alt + enter)
在excel中要批量查找软回车(alt + enter)可以通过在查找框内(通过按ctrl + f调出)输入:按住alt键不放,然后依次通过数字键盘输入1和0两个数字,放开数字键后再放开alt键。
注意:1、输入以上按键时查找框内看不到变化,但没关系,不要多输,也不要输少了;
2、如果是用笔记本电脑,也不要用数字键输入10,必须调用字母按键上的数字小键盘才行。
二、批量删除或替换换行符(alt + enter)
知道怎么查找后,这个就容易了。
调出“查找和替换”框(可直接按ctrl + h调出),在查找内容框内按以上方法输入,在替换内容框中输入你要替换成的内容,如果不输入内容则为删除查找的内容。

星期二, 十月 18, 2011

SHH.exe: Application help cannot be called

25.12.2007 Page 1 of 2
Note 1031774 - SHH.exe: Application help cannot be called
Note Language: English Version: 2 Validity: Valid from 06.03.2007
Summary
Symptom
You use SAP GUI 7.10 on Windows Vista, and your SAP system is set in such a
way that the application help is displayed in CHM format (help type
HtmlHelpFile in transaction SR13) using the Microsoft HTML Help Tool
(hh.exe). Each time when you call the help information by choosing Ctrl +
F8 or the relevant button, the system issues the following error message:
"Error in SAP-HTMLHelp (SHH.EXE)
Please install/update Microsoft HTML-Help. Using unsupported
versions may cause problems in help display. For details please
check the entries in the file SAPDOCCD.LOG in the windows
directory."
The system does not display the help information that you require. The
specified log file does not contain any additional information.
More Terms
HTMLHelp, SHH.EXE, application help, Vista, SAP GUI, extend help
Cause and Prerequisites
As of Windows Vista, the registry sometimes uses the system variables to
display the saved path descriptions (for example, "C:Windows" may be
displayed as "%SystemRoot%"). The option to replace path elements with
system constants was previously not available in the SAP HTML Help Tool
(SHH.EXE).
Prerequisite: You use SAP GUI 710 patch level 0 on Windows Vista.
Solution
To solve the problem that is described above, apply patch level 1 for SAP
GUI 710.
Header Data
Release Status: Released for Customer
Released on: 23.03.2007 12:48:54
Priority: Correction with high priority
Category: Program error
Main Component BC-DOC-IWB-DIS HTML Help
Additional Components:
25.12.2007 Page 2 of 2
Note 1031774 - SHH.exe: Application help cannot be called
KM-KW SAP Knowledge Warehouse
The note is not release-dependent.
Attributes
Attribute Value
weitere Komponenten 0000031285

星期二, 十月 11, 2011

Transport req. release hangs, only for a specific user and request.

I've found out what the problem was.
There were some warning message in SLOG0305.DEV file...
When a transport request is being released, a "semaphore" file (userid.LOS) is written in /usr/sap/trans/tmp, and deleted when the tp command is executed.
For some reason it wasn't deleted some time ago, so the user couldn't release nothing else. OSS note 12746 helped me.

星期一, 七月 25, 2011

Internal Error with background job scheduling XXXXXXXXXXXXX.

When run transaction MMPV with background, got error message " Internal Error with background job scheduling XXXXXXXXXXXXX.", Then check with transaction ST22, not found, and the SM21, got info. like this: When checking the job data for background processing, the system determined that a free server could not be found to execute a job dependent on start time:

Start time = 'immediately':
There is either no server configured for background processing or al available servers (for the required job class) are already busy.
Start time = 'date/time of day' or 'for operation mode':
Either no servers are defined for the required start time for background processing or no server is available for the required job class.
Start time = ' after event' or ' after predecessor job '
There is no server defined for background processing (for the requir job class).
Solution: run RZ04 Configure 3 BTC processes in daily operate mode temporarily and switch manually with RZ03.

星期二, 三月 01, 2011

How can I prevent users from connecting to a USB storage device?

http://support.microsoft.com/default.aspx?scid=kb;en-us;823732
If a USB storage device is already installed on the computer, set the Start value in the following registry key to 4:
HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesUsbStor
When you do this, the USB storage device does not work when the user connects the device to the computer. To set the Start value, follow these steps:
1. Click Start, and then click Run.
2. In the Open box, type regedit, and then click OK.
3. Locate and then click the following registry key:
HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesUsbStor
4. In the details pane, double-click Start.
5. In the Value data box, type 4, click Hexadecimal (if it is not already selected), and then click OK.
6. Exit Registry Editor.

sap router license

sap router license
1. Go to /usr/sap/saprouter

execute following command :

sapgenpse get_pse -v -r certreq -p local.pse "CN=SAProuter, OU=0000178802, OU=SAProuter, O=SAP, C=DE"

==> we will get new file named certreq
2. Go To https://service.sap.com/saprouter-sncadd
==> choose apply now
==> choose saprouter
==> copy and paste certreq into the text area
==> we will get new certicate

3. create new file srcert on /usr/sap/saprouter then copy & paste the new certificate
4. Go to /usr/sap/saprouter

execute following command :

sapgenpse import_own_cert -c srcert -p local.pse

sapgenpse seclogin -p local.pse -O exdadm

sapgenpse get_my_name -v -n Issuer


Here are the other steps to renew SAP Router license :
1) make a new folder in your saprouter directory like <drive>:usrsapsaprouterbackup
Cut/Paste certreq, cred_v2, getcert.cer, local.pse, srcert in backup directory
2) Run the below command to generate new certificate request
D:usrsapsaprouter>sapgenpse get_pse -v -r certreq1 -p local.pse
it will ask for certain parameters you can get your Distinguished name from http://service.sap.com/saprouter-sncadd
3) After This
Open http://service.sap.com/saprouter-sncadd site
4) Logon using your service.sap.com ID and Password
Press Apply now-->Press Continue
5) Open the file: <drive>:usrsapsaproutercertreq1 with notepad
Copy text from this file and paste the text to the request certificate page
Press the Request Certificate
6) Select the generated certificate text and copy and make a text file
srcert.txt in D:usrsapsaprouter directory
Rename the srcert.txt to srcert only
7) Install the certificate in our saprouter by running
<drive>:usrsapsaprouter>sapgenpse.exe import_own_cert -c srcert -p local.pse
8) Now we have to create the credentials for the SAProuter with command
<drive>:usrsapsaprouter>sapgenpse seclogin -p local.pse -O <saprouter user>
This will create a file called cred_v2 in the same directory.
Check if the certificate has been imported correctly
<drive>:usrsapsaprouter>Sapgenpse get_my_name -v -n Issuer
That's all Done!

星期四, 二月 17, 2011

Blackberry 8707 intellisync error

黑莓 8707 在桌面管理器中同步配置中碰到了问题,其他的例如安装软件,备份,恢复等等都可以正常的操作,但是我在按下配置同步按钮时,系统告诉我”正在确定主系统的根配置名称。。。。”然后就报了“INTELLISYNC,已报告未知错误”。Solution: delete intellisync folder. 查看全文

星期五, 一月 14, 2011

Remote desktop远程重启

Remote desktop远程控制远程关机用:C:WindowsSystem32shutdown.exe -s -t 000远程重启用:C:WindowsSystem32shutdown.exe -r -t 000

星期二, 十一月 02, 2010

ST06 did not show full application name.

Q: Its not showing the full server name to check. as i said os06->detailed analysis->compare all servers.

A: all server names are upto 8 charecters.


星期一, 十月 18, 2010

SE38 source code ?? 乱码

SE38 中文在activate后变成问号。

菜单栏右侧有个customize Local layout-->character set--->Simplified Chinese(或UTF-8)


星期五, 十月 08, 2010

Various Important SAP Basis T-Code

Various Important SAP Basis T-Code

1) SU01 User Maintainence
2) SCC4 Client Overview ( Create , Quick Delete , Modify )
3) SCC5 Deletes a client completely with tables & other factors
4) SCCL Local Client Copy
5) SCC9 Remote Client Copy
6) SCC3 Client Copy log Analysis
7) DB02 Storage Management & Database Performance
8) DB12 SAP Backup Logs
9) DB14 Database Monitor
10) SM12 Lock Entries
11) SM21 System Logs
12) SM36 Background Job Scheduling
13) SM37 Background Job Monitoring
14) SM31 Table Maintenance
15) SM50 Process Overview
16) ST22 ABAP Dumps
17) ST02 Buffer Analysis
18) ST03 Workflow Analysis
19) RZ04 Operation Mode
20) SE09 Transport Organizer
21) SCC1 Copy as per Transport Request
22) STMS Transport Management System

Copy from SAP Basis Components, Application Modules, Certification, ABAP/4 Programming Books


星期四, 九月 02, 2010

Understanding Startup Process Logs

Understanding Startup Process Logs

Start Process Logs are handy during the troubleshooting the start process of the SAP system. These files are stored in the home directory of user <sid>adm.

The following list contains the log files which are created during the start process of the SAP service:

  • STDERR1: Information about the start process of the database system.
  • STDERR2: Information about the start process of the message server.
  • STDERR3: Information about the start process of the dispatcher.

The logged information can be set in 4 levels using the profile parameter rdisp/TRACE having values for this parameter:

  1. Errors only
  2. Error messages and warnings (Default)
  3. Error messages and a short trace
  4. Error messages and a complete trace

The four trace level has the highest amount information stored in the files so the file will be of large size. The trace level can be set separately for individual work processes in the process overview (SM50)

startproc-logs


How to Shrink/Reset File stderr* on a SAP System?

How to Shrink/Reset File stderr* on a SAP System?
You can delete, rename, backup, etc stderr1.. when the system is offline.

Starting & Stopping SAP

Starting & Stopping SAP



During startup of the operating system Windows NT, the NT Service Control Manager starts all the services in the service list that are configured for automatic startup.
The information relevant to these services is stored in the registry and is read by the Service Control Manager during startup.
 Several services of type “SAP_(the SAP service) and “Oracle Service”,but only one SAPOsCOL service, can be run on one computer.
 The SAP service, SAPOsCOL, and OracleService should be configured for automatic startup.


To start the Oracle database and the R/3 System, the administrator performs the following steps:
 Log on to the operating system Windows NT as user adm.
 To start the R/3 System, open the Microsoft Management Console (MMC) using the SAP R/3 Systems Snap-in. Right-click on the system icon and select Start. The sapstartsrv.exe executable sends a message using a named pipe to the SAP Service, SAP_.
 The SAP service starts the database by executing an NT script that calls the Oracle Server Manager.
The Oracle Server Manager executes an SQL script that starts the database if it is currently not running. Once the database is up and running, the SAP service starts the Message Server (msg_server.exe) and the Central Instance dispatcher (disp+work.exe).
 The R/3 System has been started successfully when the icon for the central instance changes color to green. The colors displayed in the MMC have the following meanings: red - the process terminated abnormally; yellow - the process is being started; green - the R/3 System has been successfully started; gray - the process is not running, status unknown.
 You can also start the R/3 System with the NT scheduler called “at”. For this kind of start, SAP provides the executables startsap and stopsap which are executed locally. Use
- startsap name= nr= SAPDIAHOST= to start an R/3 instance and
- stopsap name= nr= SAPDIAHOST= to stop an R/3 instance (the executables sapstart.exe, sapsrvkill.exe and sapntwaitforhalt.exe must be in the same directory)




To provide a stable startup procedure, a parameter read sequence (also known as the parameter replace sequence) is defined during startup as follows:
 R/3 processes read the appropriate parameters from the R/3 kernel, from the NT system environment variables, and from the NT Registry environment variables.
 The default profile
sapmntSYSprofiledefault.pfl” is read. Profile values already defined in the R/3 kernel are replaced with the values in the default profile.
 The instance profile
sapmntSYSprofile__ is read.
Profile values already defined in the default profile or in the R/3 kernel are replaced with the values defined in the instance profile.
 This procedure ensures that system parameter values reflect not only the instance profile but also the values in the default profile and the R/3 kernel.
The SAP service reads only the start profile and the default profile. The R/3 kernel(disp+work.exe)reads only the default profile and the instance profile. If you change the default profile, you must restart the SAP service (including the R/3 instance). If you only change the instance profile, you only need to restart R/3 using the MMC.



R/3 work directories contain trace files and error files for messages relating to the startup of work processes. Each R/3 instance has a separate work directory containing information that may not be found in the R/3 System log.
 The work directory files are initialized in chronological order. During startup, the SAP service executable SAPSTARTSRV.EXE writes:
 Database logs to the file STDERR1
 Message server logs to the file STDERR2
 Dispatcher logs to the file STDERR3
 To define the level of information written to the developer trace files, set the profile parameter “rdisp/TRACE” in the instance profile. The possible values for this parameter are:
0: Write only errors (no traces)
1: Write error messages and warnings (default)
2: Write error messages and a short trace
3: Write error messages and the complete trace

星期三, 七月 21, 2010

RFC_CONVERSION_FIELD

Run transaction SSAA failed;
RFC_CONVERSION_FIELD
Conversion error between two character sets.
Conversion error "ab_rfccon" from character set 4103 to character set " "Solution:SM59;Change the FRC address's character conversion:"

星期四, 五月 27, 2010

GUI quick cut and paste failed

GUI version:720

There is software conflict problem, like as Lingos, Kingsoft etc, have the clipboard select work function.


Solution: disable the function.

 查看全文

星期五, 四月 16, 2010

unknown objects in abap dictionary:VBAK~Z02

Monthly check DB, there is unknown objects in abap dictionary:VBAK~Z02 in the results of consistency check.

When check the runtime and database objects in SE11,

SE11 (Utilities > Database Object > Check) said the object VBAK is inConsistent,

But the runtime check is Consistent.

Note, I remenbered the index was delete on last month. It seams the SE14 databack check have some problem.

Solution:

Re-create the index, Database object check is Consistent;

Re-delete the index, Database object check is Consistent.


星期五, 四月 02, 2010

How to display all pages in a large spool request?

Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONE

How to display all pages in a large spool request?

For example, 150 pages;

By default, SAP only displayed page 1 to page 10;

Click the setting botton;

You could found the default setting is 1 to 10;

Tune 10 to 150,

Warning,

Double click the line of the end, SAP will tell you the tunning was effect;


星期二, 一月 19, 2010

view the favorites table.

use table 'smen_buffc' to view the favorites table.

星期三, 一月 13, 2010

How do you find that an operation mode switch occurred?

How do you find that an operation mode switch occurred? There are many ways

1) Go to sm50. If the no of dialog work processes or background work processes changes then a operation mode switch took place.

2) Go to transaction sm63. Here you can see the time when the operation mode is set. You can guess when the operation mode switch occurs.

3) Go to transaction RZ04, here you can see the list of operation modes and their time. You can guess that from here

4) Go to transaction rz03 , here you can see the current operation mode in which the server is running.


5)
Call transaction Code sm62. Then view system events. If there is an event called SAP_OPMODE_SWITCH then operation mode switch occurred at that time. If you click on activity log you can see the time and date when the event was triggered. It is time and date of operation mode switch


星期二, 一月 12, 2010

Maintain profile parameter dynamic with function.

Here is the steps. I really do not recommend to use it especial on a cluster or production environment.

=====================================================================


You can change the parameter using the function module TH_CHANGE_PARAMETER
(transaction SE37 -> Single Test). Set the following parameters here:

Uppercase/Lowercase: X
PARAMETER_NAME: XXXXXXXXXXXX
PARAMETER_VALUE: <the required value>
CHECK_PARAMETER: 0


星期四, 十二月 31, 2009

SAP editing function is activated to modiy table content.

T_code: SE16N

Input "&sap_edit" in the command dialog box, the SAP editing function is activated, so we could edit the table content.


星期一, 十二月 28, 2009

Configure RFCCOM procedure

Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONE MicrosoftInternetExplorer4

Configure RFCCOM procedure

1. Create the RFC destination with Transaction SM59

2. Register server programoption

Run by <sid>adm.

rfcexec –g<program id> -a<gateway host name> -x<gateway service>

rfcexec -g RFCCOM.172.23.134.129 -a SAP-rix3600 -x sapgw00

rfcexec -D RFCCOM_SAPSRV01

rfcexec -g RFCCOM.172.23.134.20 -a SAP-rix3600 -x sapgw00

rfcexec -D RFCSERVER

rfcexec -g RFCCOM.172.23.134.20 -a SAP-rix6600-1 -x sapgw00

rfcexec –D RFCSERVER

3. Configure RFCCOM.cfg file with rfccom.exe, set RFCCOM.cfg file read-only;

Run rfccom.exe and keep it running.

4. Transaction SMGW, goto logon the clients, verify the program running.

5. Test the Connection RFCCOM_SAPSRV01 successful with transaction SM59,


星期四, 十二月 24, 2009

Hide the User Menu

Hide the User Menu

Is there a way of masking or hiding the User Menus as we are using SAP Standard Menu instead of User Based Menus?

To put it simple, when the user logs on to the system he should have only the SAP Standard Menu.

You have two ways to control this :

1. Default hide for all the SAP users.

Goto SM30 and edit the table SSM_CUST and set ALL_USER_MENUS_OFF = YES and transport the same in production server.

or

2. Hide based on individual SAP users.

you can also try SM30 and maintain table USERS_SSM for individual users.

http://www.sap-img.com/basis/hide-the-user-menu.htm


How to modify multiple items in the SAP menu

Yogi Gunawan
09.16.2003
Rating: -3.84- (out of 5) Hall of fame tip of the month winner



How do you add/remove/modify several items in the SAP menu for particular/all users? Login to the development client; make sure that changes to repository or cross-client customizing are permitted. Use t-code SE43N and you will see the Area Menu Maintenance screen. The default area menu in SAP is S000, so if you want to change the items in SAP Menu, it is better that you copy the S000 menu, for example copy it to Y000 (Ctrl-F5). SAP screen will ask you which language the copy will be created, choose English; for the development class fill it with one of the default sap development class, exp. ZDEV; and click save. It will prompt you to make a transportable Workbench request. You have to create this because we will need to transport the new SAP menu to the destination client. Click "create request" (F8) and fill in the short description. It will create new request number. Click to continue. To modify your new SAP menu, please click the change area menu button (F6). In the Edit Area-menu you can select one of the node/sub-node and make your changes by clicking one of the buttons on the screen: Add entry as sub-node (Shift-F7), add entry at the same level (Shift-F8), change nodes (Shift-F9), .etc. After you have finished your changes, click the save button. Now that you have done the changes, the next thing is that you have to transport your area menu to the destination client (the client that you want to show the new SAP menu to your users). You can do this by using t-code SE10 to release your change request, and use t-code STMS to import your change request number that you have been released (as usual transport). To apply your new SAP menu to the user, all you have to do is login to the destination client. Use t-code SU01, fill in the username and then click the change button (Shift-F6). Click the default-tab and fill in your new SAP menu name in the start menu textbox. Click save. If you want to set your new SAP menu to several/all users at the same time, use t-code SU10 (user maintenance: mass changes).

星期一, 十二月 21, 2009

To download SAP menu

PRGN_PRINT_AGR_MENU
EASYACCESS_PRINT_MENU

星期三, 十二月 16, 2009

有关SAP time的虚惊一场

Transaction: CSADMIN

Content server administration时,发现Sever time和Start time都是在午夜时分,心想:难道有内贼乱搞服务器,由于Date是在数月之前,还不好追溯历史操作记录...但Basis只有我一个,不会啊?

后查SAP help,上面明明写着All times are specified in UTC.

忘了加上8小时,是咱干的活,虚惊一场。


星期四, 十一月 26, 2009

How to Enable DLink 624M VPN pass through.

个人电脑通过ADSL拨号上网,可以连接公司VPN,但后经WIFI后(DLink 624M),无法连接VPN.解决方案如下:

Preparing a D-Link DI-624 router for your SBS network - Part 3

http://www.smallbizserver.net/Articles/tabid/266/articleType/ArticleView/articleId/210/Preparing-a-D-Link-DI-624-router-for-your-SBS-network--Part-3.aspx

  • Click on the Tools tab, then click on the Misc button.
  • By the VPN Pass Through Settings, click the radio button/s for enabled.
  • Then click the green tick to Apply your setting.
  • After the router restarts, click the 'Continue' button.
  • VPN Pass Through is now enabled.
 查看全文

星期四, 十一月 19, 2009

Create index with open on-line index creation

DB02>Configuration>On-line Index Creation

在生产库上不开这个开关就创建索引是不可能的,大批用户会因此而被锁,现在SQL 2005支持在线索引的创建,这真是一个好功能.

SAP默认是关闭,当然建完后再关上就是,动态开关.


SAP help library could not display.

SR13

Set the path.

If SAP help library still could not display,

Save the following script as reg file, and then import to regedit.

REGEDIT4
[HKEY_LOCAL_MACHINESOFTWAREMicrosoftHTMLHelp]
[HKEY_LOCAL_MACHINESOFTWAREMicrosoftHTMLHelp1.xItssRestrictions]
"MaxAllowedZone"=dword:00000001

星期一, 十一月 16, 2009

Delete indexes to free database.

Transaction: SE11, DB02

用DB02根据Index Usage(DB02>Performance>Indexes>Index Usage),筛选出一些User seeks为0的用户自定义的Index,用SE11一一删除,节省出50GB空间.

下一步骤是挑一个空闲日,shrink database 或 shrink datafiles.

等来年空间紧张时,再来得筛选没人用的SAP的Index.


星期五, 十一月 06, 2009

Trouble!!!

8月份,弟弟在大连出车祸.

一切都乱了.

...

今天又飞上去看他...

早日康复,小子.


星期二, 八月 18, 2009

To avoid to restart your pc after lotus notes crashed.

Kill nlnotes.exe

Kill ntaskldr.exe

 查看全文

星期三, 八月 12, 2009

Note 1095032 - ST02: History data not available for server

Summary

Symptom

In transaction ST02, the history data for some servers is not available.

Other terms

History, SAPWLSERV, SY-HOST

Reason and Prerequisites

This problem is caused by a program error.

Solution

Import the relevant Support Package.

Header Data

Release Status:Released for Customer
Released on:2008/04/18 06:43:47
Master Language:German
Priority:Correction with low priority
Category:Program error
Primary Component:BC-CCM-MON-TUN Performance Monitors (TCC)

Affected Releases

Software
Component
Release
From
Release
To
Release
And
subsequent
SAP_BASIS
46
46C
46C
SAP_BASIS
60
620
640
SAP_BASIS
70
700
700
SAP_BASIS
71
710
710

Correction delivered in Support Package

Support
Packages
Release
Package
Name
SAP_BASIS
46C
SAP_BASIS
620
SAP_BASIS
640
SAP_BASIS
700
SAP_BASIS
700
SAP_BASIS
710
SAP_BASIS
710

Related Notes

1135491 - RSSTAT98 - Inconsistent host name when setting up SAPWLSERV
 查看全文

星期二, 八月 11, 2009

Business Document Navigator

To store document / image in SAP, we can use Business Document Navigator.
To go to the Business Document Navigator, choose Office -> Business Documents -> Documents -> Find (transaction code : OAOR).

SPRO:

SAP Customizing Implementation Guide -> SAP Netweaver -> Application Server -> Basis Services -> Business Document Service

When you are using transaction OAOR to store document manually, first you have to maintain table class in tcode SBDSV1


星期五, 八月 07, 2009

Portal Response time is taking high...

CAF:GP:MailConnector:run():insideCycle from J2ee_Guest user causes more CPU and Resources utilization is happening.

Followed procedure for stopping specified request:
Go to Visual Admin > Global Config > Services > caf/eu/gp/model
Set mailconnector.start_thread = false.
Needs a restart.

https://forums.sdn.sap.com/thread.jspa?threadID=1157363&tstart=0

https://forums.sdn.sap.com/thread.jspa?messageID=6622200&tstart=0


SAP® standard / special users

SAP® standard / special users

With the installation of a SAP® system, some standard users are created in the individual clients or system environments. Some of these users have already high authorizations from the beginning, and of course most of them have standard passwords assigned that are generally known.
These special users need special treatment and special protection.

1. SAP*
The user SAP* exists right after the installation in all clients. He has the composite profile SAP_ALL assigned and with that all relevant authorizations for the system set up.

SAP® has implemented a backdoor [coding] for this user.
If someone deletes the user SAP*, a login is possible with the standard password PASS including the corresponding SAP_ALL authorizations.

To prevent a login of the SAP* after a deletion, the parameter login/no_automatic_user_sapstar can be utilized.

With a parameter setting to 0 the login is possible.
Any value higher than 0, prevents a login after the deletion.

The standard password for this user directly after the installation is 06071992.
The standard password after deletion is PASS.

The preferable method to protect this user is the deactivation of SAP* :

- Remove all authorizations from this user.
- Lock the user account.
- Set the parameter login/no_automatic_user_sapstar
to 1.
- Activate the audit log for this user.

You can also consider to assign this user to a user administration group that is protected by a dual control principle.

This report RSDELSAP deletes the user SAP*in the client 066. The corresponding source code is not active but available.

2. DDIC
The user DDIC is established in the client 000 and 001 with the installation
[and copies of these].
This standard user is uitilized to cover installation and release updates including changes to the data dictionary. The use of the transport management system is restricted to Display only.
This is the protection against direct developments.
As the technical steps related to this process are initiated in the client 000, the DDIC only needs to be a dialog user in this client.
In all other clients he can be set to the user type “system”.
The standard password for this user directly after the installation is 19920706.

The report RDDPWCHK allows to check the password that is assigned to the user DDIC. In case the password matches, the dialog window will be closed. For mismatches the message False is displayed.
The counter for false login does not count these password detection attempts.

3. TMSADM
The user TMSADM is automatically created at the set up the change and transport management system in the client 000.
His user type is “Communication”, and he is utilized for transports by the CTS.
He has the profile S_A.TMSADM assigned that authorizes the use of RFC with display of the development environment e.g. as well as writing to the file system.
The standard password for this user directly after the installation is PASSWORD.

4. SAPCPIC
The user SAPCPIC is created as a “communication” user at the installation and is utilized especially for EDI. The standard profile S_A.CPIC restricts the access to the use of RFC.
This user is coded into the function module INIT_START_OF_EXTERNAL_PROGRAM together with his standard password. This needs to be considered in case of password changes for this user.
The standard password for this user directly after the installation is ADMIN.

5. EARLYWATCH
The user EARLYWATCH is created in the client 066 at the installtion. He can be utilized for remote control by SAP® and is only set up with some standard authorizations S_TOOLS_EX_A for performance monitoring. The user is to be locked in general, and can be unlocked upon request.

Evaluation
For the evaluation of the passwords you may use the report RSUSR003.

6. SAP* in J2EE
The user is established with full authorizations for the administration.
With regard to security, the user has no standard password assigned.
To utilize this user as emergency user the properties in the UME need to be maintained.
Setting the ume.superadmin.activated property to true will activate the use of this user for emergency cases.
Setting a password in ume.superadmin.password will then activate the user finally after the restart of the engine.
While the user SAP* is in use, all other users will be inactivated during this time.
When the system is fixed, the deactivation can be achieved by setting the ume.superadmin.activated property to false.

7. J2EE_ADMIN_
This user is the Java standard user with full administration authorization in this environment. The password is to be assigned during the set up.
High complexity is recommended for this password.

8. J2EE_GUEST
This user is a Java standard user who can be utilized for anonymous access.
The user is locked per default. The password is assigned during the installation.

9. SAPJSF_
This user is a standard communication user for LDAP [Lightweight Directory Access Protocol] data sources.

10. ADSuser
This standard user is utilized for the communication between Java and ADS
[Adobe Document Service].

11. caf_mp_scvuser
This standard user is utilized in the context of the Composite Application Framework (CAF) core transport system and communication with other Java services.


星期五, 七月 17, 2009

SAPSYS perform rollback

In APP server, SM21 check the system log, found a lot of "SAPSYS R6 8 Perform rollback"

https://forums.sdn.sap.com/thread.jspa?threadID=478722

This is normal and you will see it done by sapsys (internal) in your System Log SM21.

An SAP rollback is performed when a user backs out of a transaction losing previously entered data, therefore to maintain transactional consistency SAP does not partly save the data, it performs a rollback.


How to change SAP portal favicon?

You can search the folder structure of portal installation under /usr folder. You should find the occurance's. Anyways here are the locations where I found the favicon.
./JCxx/j2ee/cluster/server0/apps/sap.com/com.sap.engine.docs.examples/servlet_jsp/_default/root/favicon.ico

./JCxx/j2ee/cluster/server0/apps/sap.com/com.sap.lcr/servlet_jsp/sld/root/favicon.ico

./JCxx/j2ee/cluster/server0/apps/sap.com/com.sap.lcr/servlet_jsp/sld/root/img/favicon.ico

./JCxx/j2ee/cluster/server0/apps/sap.com/com.sap.rprof.remoteProfile/servlet_jsp/exchangeProfile/root/img/favicon.ico

星期日, 六月 28, 2009

PC散热

前一阵子玩三国无双时,发现一进入或玩没多久,电脑自动重启,但其它操作如上网,Office,QQ小游戏都没事,以为是游戏crack得不好,装其它大的游戏,一玩一样死直直。。。猜想可能是夏天到了,PC散热问题就显示出来。为不影响个人心情,足足数周没得玩啊,遂采取下列方法: 1,折机箱档板,整一PC就象没了壳的乌龟,无效; 2,由于是3D游戏,怀疑是显卡出问题,清理,无效; 3,发现显卡有电容爆浆,去宏远电脑城换电容,10元,无效; 4, 重装显卡驱动,无效; 5,装上N个降温软件,监测到有个TEMP2温度极高,开机就55了,摸摸CPU风扇,有点热,怀疑是CPU作怪,但降温软件,都是老东东,无效 6,清洗CPU,无效; 7,上电脑城买导热硅胶一瓶,生人5元,熟人就3元啦,将CPU就辅上一导,无效; 8,无意之中,烤机过程中摸摸主板这里哪里的,发现有一块散热片特热,估计降温软件TEMP2指得就是这里,看样子是北桥,查一下北桥的作用: 从视觉上看靠近CPU的那个芯片就是北桥芯片,而北桥芯片就是为了控制处理器与内存和显卡之间数据交流的处理芯片。 而南桥芯片就是离处理器较远的那一颗芯片,是为了控制和协调外存储设置和输入输出设备以及其他外设之间的数据交流的。 由于北桥芯片的工作量较大,所以一般上方会有一块散热片或是散热风扇。 由于北桥芯片在主板上承接着重要且决定性的作用,所以一般主板芯片组的型号一般是以北桥来命名的,比如你看到的某款主板的型号为 P45 G31 等等。 9,明白了,折开散热片一看,装机时的硅胶早就溶一芯片四周了,清洗后,辅上导热硅胶,装上散热片,开机,手摸上去感觉温度不高,再进游戏。。。嘿嘿

星期四, 六月 25, 2009

How to disable mass transports?

Copy form sap help.

http://help.sap.com/saphelp_nw04/helpdata/en/3f/d6f463e05611d3b4c1006094b9ea64/frameset.htm

Transport Control Parameters Locate the document in its SAP Library structure

The following parameters for the transport control program and the Change and Transport System (CTS) are set according to the chosen transport strategy:

Parameter

Value for Mass Transports

Value for Single Transports

Value for Workflow-Controlled Transports

IMPORT_SINGLE_ONLY

0

1

1

NO_IMPORT_ALL

0

1

1

IMPORT_SINGLE_STRATEGY

0

1

0

WORKFLOW_STRATEGY

0

0

1

REPEATONERROR

9

8

8

STOPONERROR

9

9

9

You can display these parameters in the TMS system overview. To do this, position the cursor on the appropriate system and choose SAP System ® Display. The tab Transport tool contains all the profile parameters.

Note

Do not manually change the parameters that are relevant to the transport strategy. TMS generates these parameters each time the transport route configuration is changed.


星期二, 六月 23, 2009

report RPUMKG00

Please advise your system administrator that all features must be regenerated.
Please note that this generation must take place in client 000 first, and then in all other clients (report RPUMKG00)

星期五, 六月 19, 2009

SAP Security Audit log size

SM19有两种audit方式: 静态和动态

SM19

,第一页是静态设置profile,filter...active, 最后提示重设instance.

静态audit还要在启动profile里设置rsau/enable=1(默认是0,不启用audit)

第二页是动态设置,设置filter后acitve即可启用AUDIT,不用设置rsau/enable=1.

用SM20或SM20N查看记录, SM18可以按日期删除记录.


星期四, 六月 18, 2009

How to configure a firewall for domains and trusts

Windows Server 2003 and Windows 2000 Server

For a mixed-mode domain that uses either Windows NT domain controllers or legacy clients, trust relationships between Windows Server 2003-based domain controllers and Windows 2000 Server-based domain controllers may necessitate that all the ports for Windows NT that are listed in the previous table be opened in addition to the following ports.

Note The two domain controllers are both in the same forest, or the two domain controllers are both in a separate forest. Also, the trusts in the forest are Windows Server 2003 trusts or later version trusts.
Collapse this tableExpand this table
Client Port(s)Server PortService
1024-65535/TCP135/TCPRPC
1024-65535/TCP1024-65535/TCPLSA RPC Services (*)
1024-65535/TCP/UDP389/TCP/UDPLDAP
1024-65535/TCP636/TCPLDAP SSL
1024-65535/TCP3268/TCPLDAP GC
1024-65535/TCP3269/TCPLDAP GC SSL
53,1024-65535/TCP/UDP53/TCP/UDPDNS
1024-65535/TCP/UDP88/TCP/UDPKerberos
1024-65535/TCP445/TCPSMB
(*) To define RPC server ports that are used by the LSA RPC services, see the "Domain controllers and Active Directory" section in the following Microsoft Knowledge Base article:
832017 (http://support.microsoft.com/kb/832017/ ) Service overview and network port requirements for the Windows Server system
http://support.microsoft.com/kb/179442/en-us
 查看全文

星期五, 五月 15, 2009

WORD及EXCEL行列转换实现方法收藏(转)

WORD及EXCEL行列转换实现方法收藏 【IT168 实用技巧】在WORD操作中,我们有时需要将Word表格的行与列进行交换(也称为表格转换),但Word本身并没有提供现成的功能可供使用,传统的办法是手工转换。不过这样一来,操作效率低,同时,还容易出错。最根本的原因是不符合我们现代办公的轻松、方便的理念。(相关文章:修复变成乱码的Word文档) 今天,为大家介绍两种方法,可以轻松实现WORD行列转换。以下两表为行列转换前的表一及转换后的表二。通过下列所讲方法,可将表一转换为表二的形式。 表一 表二   一、借助EXCEL法   1. 首先要在Word中右击表格左上角的十字标全选整个表格,然后执行右键菜单中的“复制”命令。(如图1所示) 图1   2. 接下来打开Excel,在任意单元格处点击鼠标右键,选择“选择性粘贴→文本”命令,将Word表格粘贴到Excel中。(如图2所示) 图2   3. 选中并右击复制图2中这些带有数据的单元格。   4. 然后切换到另一空白工作表中,右击并执行“选择性粘贴”命令。最后在弹出的对话框中勾选“转置”复选框后点击确定即可。(如图3所示) 图3   5. 此时,我们便会发现Excel表格中的行列已经按照我们的要求互换了,而且各个单元格的数据也分毫不差,这时再将转置好的表格拷贝回Word就行了。对于转换成功的表格,我们要重新设置一下新表格的边框,因为转换成功后的表格默认是没有边框的。 方法二、替换法   1. 首先选中表一的一列数据并复制,在一打开的空白Word文档中使用“编辑”菜单下的“选择性粘贴”命令,选择“无格式文本”进行选择性粘贴,然后打开“查找和替换”对话框。   2. 在“查找内容”框中输入“^p”(回车符),在“替换为”框中输入“^t”(制表符),点击“全部替换”,现在你会发现一列数据变成了一行数据,再将全部数据选择性粘贴回所需表格中即可。(如图4所示)  图4   3. 用同样的方法,将其它列中的数据转换到表格的相应位置中。   注:若将行变为列需在“查找内容”框中输入“^t”,在“替换为”框中输入“^p”。

星期二, 五月 05, 2009

How to customize the Login Screen in SAP Enterprise Portal

具体可参考:

http://syswebs.info/index.php?hl=f5&q=uggc%3A%2F%2Fwfov.oybtfcbg.pbz%2F2006%2F09%2Fubj-gb-phfgbzvmr-ybtva-fperra-va-fnc.ugzy

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/371e9d90-0201-0010-c39c-fd2956154ab3

这里要指出的是,可直接找到该文件,修改后重启portal即可

另外,如文件中的四位编码是unicode,非英文(比如中文)将文字转换成unicode再按格式拷贝就行.

例如,欢迎

xtit_WELCOME=u6B22u8FCE


星期五, 四月 24, 2009

Create a New Parameter ID

Create a Parameter Id

SE80 ==> Edit Object==> More==> New Parameter id==>New.

 查看全文

星期三, 四月 08, 2009

Data protector command: locked device.

omnidbutil -show_locked_devs

If this shows something and you are absolutely certain that the device is not is use you can free it up with:

omnidbutil -free_locked_devs

 查看全文

星期一, 三月 09, 2009

SAP Conter Server

Transaction: OAC0, CSADMIN,

http://help.sap.com/saphelp_nw70/helpdata/EN/c4/cefa3882cd8229e10000000a11402f/frameset.htm


SAPDB problem

We can not upload image to SAPDB, when one session upload holding, all the other session can not access image in SAPDB, but when we restart SAPDB, we could read the image,...Finally, we found the cause is the data area full used to 99%, so add new datafile to add free space, but found something interested.

1, datafiles, or call data volume cannot delete;(From google search, SAPDB 7.6 should be support possible),

2, there are parameters to limit the datafile number and all size, if you want to add datafile, it should tune first.

 查看全文

星期四, 二月 19, 2009

DOS命令+Excel=批量文件重命名

在《电脑爱好者》2005年第9期的《DOS快餐店》中介绍了使用DOS命令为文件快速重命名,如果要对文件进行批量重命名,是否就必须使用带有循环语句的批处理?其实可以用Excel和DOS命令结合,实现简单高效的批量文件重命名。
任务:在C:mypictures目录中包含以下文件:002.jpg、003.jpg、004.jpg、005.jpg。要将它们分别改名为泰山风景1.jpg、泰山风景2.jpg、泰山风景3.jpg、泰山风景4.jpg。
第一步:运行CMD打开“命令提示符”窗口,用cd命令进入文件所在目录(cd c:mypictures),然后用“dir *.jpg /b>temp.bat”命令将当前目录中的JPG文件名输出到临时文件temp.bat中。
第二步:用“记事本”打开C:mypictures中的temp.bat,全选并复制该文件中的内容,然后打开Excel,定位到A1单元格,右击选择“选择性粘贴→确定”(见图),在B1单元格中输入第一个文件的目标文件名(如“泰山风景1”),通过拖拽B1单元格右下角的填充柄在B列生成文件名序列,即“泰山风景1”、“泰山风景2”、“泰山风景3”……
第三步:在C1单元格输入公式“="ren "&A1&" "&B1&RIGHTB(A1,4)”(不含外侧中文引号),然后通过填充柄在C列生成序列。选中C列中所有生成的序列,复制到temp.bat文件中,覆盖原来的内容,保存退出。最后双击Temp.bat运行之,批量文件改名即告完成。


星期五, 二月 13, 2009

SMTP port

无意中的发现,发INT的邮件出不去了...

1, SMICM, goto services

原来SMTP服务不知为何被删除了,重新添加;但发现一个bug,无论为SMTP指定任何一个端口,如0,SMTP服务激活无误,对转发邮件无不良作用;

2,SCOT

只要在SCOT的SMTP设置中端口设置无误,port=25;

 查看全文

星期四, 二月 12, 2009

An error occurred while the wizard was checking the current Windows product license. Error Code: 8: 0x8007007f

I found there was an error on SAPDL580 server, the message from event log display "An error occurred while the wizard was checking the current Windows product license. Error Code: 8: 0x8007007f".

When I tried to login the server four times this morning, it refused me login and hung black screen, I had to hard boot the server.

And I checked the Microsoft help, it seams that the error was caused by install the windows SP2 with RDP by you last night. Some suggestion said it should be right after reboot, other said it should be uninstall the SP2.

SAPconnect Administration (Transaction SCOT)

SAPconnect Administration (Transaction SCOT)

You have to configure SAPconnect settings for every client that is used for send processes.

· Default Domain

Under Settings ® Default Domain, define the domain of the SAP system client. This allows for the following to take place:

· The SMTP plug-in logs on to the mail server using the domain as ID.

· The message ID of the outbound e-mails is assembled with this domain.

· If an SAP user who does not have an Internet mail address sends an e-mail, a sender address consisting of the SAP user name and this domain is generated.

· Nodes

Each client has an SMTP node. This node is created by the SAP system and cannot be deleted. The following steps need to be carried out to configure the node so that sending Internet mail is possible:

i. Make sure you are in the Node view.

ii. Double-click the node name.

iii. Choose Node in use.

iv. In the Mail Host and Mail Port fields, specify the mail server to which the outbound mails are to be sent.

v. Next to Internet, choose Settings.

vi. Enter the address area of the recipient addresses that are to be reached using this node. In general, * is used if all e-mails are to be sent using SMTP.

vii. Enter the output format for SAP documents. We recommend that you use the following settings:

SAPscript/Smart Forms

PDF

ABAP list

HTM

Business Object / Link

HTM

RAW Text

TXT

viii. Confirm your selection.

If you also want to configure the node for sending faxes:

i. Next to Fax, choose Settings.

ii. Enter the address area of the recipient addresses that are to be reached using this node. In general, * is used if all faxes are to be sent using SMTP.

iii. Enter the output format for SAP documents. We recommend that you use the following settings:

SAPscript/Smart Forms

PDF

ABAP list

PDF

Business Object / Link

TXT

RAW Text

TXT

iv. Enter the domain of the fax server or fax provider under Conversion into Internet Address. The system generates the local part of the Internet address automatically. The address therefore takes this format: FAX=+RecipientNumber@Domain.

v. Confirm your selection.

If you also want to configure the node for sending text messages (pager/SMS):

i. Next to Pager (SMS), choose Settings.

ii. Enter the address area of the recipient addresses that are to be reached using this node. In general, * is used if all text messages (pager/SMS) are to be sent using SMTP.

iii. Enter the domain of the text message (pager/SMS) server or provider under Conversion into Internet Address. The system generates the local part of the Internet address automatically. The address therefore takes this format: SMS=+RecipientNumber@Domain.

iv. Confirm your selection.

· Send Job

E-mails sent from an SAP application are first stored in a queue. A periodical background process, the SAPconnect send job, gets the e-mails from this queue and sends them over the Internet. To schedule this job in SAPconnect: Administration, proceed as follows:

i. Choose View ® Jobs.

ii. If no other job has been scheduled, choose Job ® Create.

iii. Enter a job name and confirm it.

iv. Select the variant SAP&CONNECTALL by positioning the cursor on it.

v. Choose Schedule Job.

vi. Choose Schedule periodically.

vii. Select the interval you require, such as 10 minutes.

viii. Choose Create.

· Inbound

If you want incoming e-mails that have a particular address or particular content to automatically start a program that processes these mails, you can configure this under Settings ® Inbound Processing.

If you want incoming e-mails that have a particular address or come from a particular sender to be automatically forwarded to another recipient or another distribution list, you can configure this under Settings ® Inbound Processing.


星期二, 一月 20, 2009

UPService Error

Describes:

The description for Event ID ( 4 ) in Source ( UPService ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: UPService: PDH FAILED

Solution:

This error can rack up considerable events in the Application Log. On my R&D system I get 7 per 5 minutes when it occurs, then it maybe 6 weeks prior to getting more.

Currently the best workaround for this event is to stop and "disable" the following 2 services under Service Control Manager.

"HP UtilProvider Data Collector"
"HP UtilProvider WMI Provider"

These two services are only used by HP Virtual Machine for Windows Guests (unlikely you'll be using) and HP Capacity Advisor (again unlikely you'll be using).

We are working on a fix for this issue which will be in a future version of the SmartSetup Media (SSM).

 查看全文

Registering a program on the Gateway

Many times I have come across error in SM59 transaction saying the program is not registered on the gateway

RFC connection test in SM59 might give error similar to this

———————————————————————————————————

Logon Connection Error

Error Details Error when opening an RFC connection

Error Details ERROR: program <program id> not registered

Error Details LOCATION: SAP-Gateway on host <hostname> / sapgw<instance no>

Error Details DETAIL: TP <program id> not registered

Error Details COMPONENT: SAP-Gateway

Error Details COUNTER: 16793

Error Details MODULE: gwr3cpic.c

Error Details LINE: 1694

Error Details RETURN CODE: 679

Error Details SUBRC: 0

Error Details RELEASE: 700

Error Details TIME: Mon Sep 17 13:08:02 2007

Error Details VERSION: 2

———————————————————————————————————

The program in the above error should be registered in the gateway for this connection test to complete successfully. The server program rfcexec is responsible for its registration on the gateway.

To register the program login into the OS level as sudo su - <sid>adm and execute the following command.

rfcexec –g<program id> -a<gateway host name> -x<gateway service>

rfcexec is the server program name, the <program id> can be obtained from SM59, it is case sensitive and should match with the entry in SM59. The <gateway host name> and <gateway service> can be obtained from the transaction SMGW. When this command is executed it goes to a hanging loop.

The connection will fail once this command is terminated or the user executing this command logs off

To avoid this, instead of using the above mentioned command an entry should be made in the file saprfc.ini

To do this, execute the following command

sudo su - <sid>adm

rfcexec –D<destination name>

<destination name> is the RFC destination name in SM59

So now we are done with registering the server program, but how do we check it is registered, once a server program is registered it is displayed in the Logged on clients in SMGW.

In transaction SMGW choose GOTO-> Logged on clients. There should be an entry for the server program in the screen that is displayed with system type Registered_TP (which indicates that the program is registered)

There can be many reasons due to which we might get this error saying server program is not registered, once such instance which I faced was where in the TREX server, a new RFC destination was defined, the TREX server creates a new program id each time this RFC destination is defined. This program id was not changed in TCP/IP connection is SM59 which was the reason why the destination was failing

Copyright belongs to

Madhu’s Weblog

http://qsneak.info/index.php?hl=f5&q=uggc%3A%2F%2Fznquhgrxhe.jbeqcerff.pbz%2F2008%2F08%2F10%2Fertvfgrevat-n-cebtenz-ba-gur-tngrjnl%2F


星期一, 一月 19, 2009

Change domain time

If yYou're using a recent Windows version, you can also use the ntp client that is built into the system. Just execute:

net time /setsntp:pool.ntp.org

With some versions of Windows you can also specify more than one server

net time /setsntp:"0.pool.ntp.org 1.pool.ntp.org 2.pool.ntp.org"
Then Synchronous on the other server immediately when you run,
net time /set /yes
If not, the other servers will be synchronous time per 15 minutes.
 查看全文

星期二, 一月 06, 2009

微软认证:远程开启远程计算机的远程桌面

下面介绍仅仅使用windows的一些命令来实现这个过程。仅供参考了。
  一。我们可以直接通过在客户端输入wmic命令,来远程开启服务器的远程桌面,命令如下:
   Wmic /node:"[full machine name]" /USER:"[domain][username]" PATH win32_terminalservicesetting WHERE (__Class!="") CALL SetAllowTSConnections 1
  这里的"full machine name“也可以是IP,"domainusername”也可以是本机的帐号。
  就这样轻松的开启了。。
  二。可是,如果管理员是空密码,那就开启不了远程桌面了,windows默认是不能使用空密的远程桌面的。
  如果使用wmic命令,会报错的。
  这时候可以使用telnet来更改密码,telnet默认是不开启的,我们可以通过ipc$连接来开启,
  整个过程如下,不多介绍了,都是很简单的命令:
  1.建立IPC连接
  net use IP password /user:administrator
  2.把Telnet服务改成“自动”
  sc IP config tlntsvr start= auto
  注意:auto前面有一个空格
  3.启动Telnet服务
  sc IP start tlntsvr
  4.Telnet到服务器
  telnet IP
  5.更改管理员密码
  net user administrator password
  6.使用wmic命令开启远程计算机的远程桌面
  7.别忘了远程登录计算机后停用并禁用telnet服务!
  一:开启远程计算机telnet服务。
  二:telnet到远程计算机后,更改管理员密码。
  三:回到本机命令行,运行命令打开远程计算机远程桌面

星期二, 十二月 23, 2008

StorageWorks Command View EVA can not connected

Check the Services "HP Command View EVA" start normally or not.

星期三, 十二月 17, 2008

Connection to partner timed out after 60s

500 Connection timed out

Error: -5
Version: 7000
Component: ICM
Date/Time: Thu Dec 18 09:36:37 2008
Module: icxxthr.c
Line: 2698
Server: SAP-SDFS_01
Error Tag: {-}
Detail: Connection to partner timed out after 60s

1, https://service.sap.com/sap/support/notes/885580

Timeout settings: There are several timeout values that are involved when using the internal ITS:

rdisp/gui_auto_logout: This parameter applies to all kind of user sessions in the R/3 (SAPGui and ITS services). This profile parameter should be set larger or equal to the session timeout of the ITS service (see below).

Session timeout of an ITS service: For each ITS service a dedicated timeout can be set. Call transaction SICF => /sap/bc/gui/sap/its/ => <Service> => Service options => Session-Timeout: <hh:mm:ss>.

Timeout values of the Internet Communication Manager (ICM): There are two kind of timeout values that can be set in the ICM: PROCTIMEOUT and TIMEOUT.

Syntax: icm/server_port_ = PROT=HTTP, PORT=<Port>,
TIMEOUT=<keep alive timeout>,
PROCTIMEOUT=-1

- PROCTIMEOUT: The PROCTIMEOUT argument of the ICM parameter icm_server_port_?? Defines the maximum processing time of a request in the kernel (the default value for processing time is 60 seconds). You should choose a value that fits to the runtime requirements of the ITS services you are using.

- TIMEOUT: The TIMEOUT argument of the ICM parameter icm_server_port_?? defines how long the connection between the browser and ICM should remain open (the default value is defined with the parameter icm/keep_alive_timeout and has the value 60). The parameter has no effect on the session/connection timeout but is used to optimize the performance of the HTTP connection (HTTP/1.1).

For further details, please refer to note #705013.

2, To do this, start Tcode SMICM.
Then Menu: Goto->Services->Menu->Go To->Service->Define. Specify a new port number, and a large “keep alive” time. When testing, just change the port number in the URL to use the newly defined one.

or RZ10.

Parameter : icm/keep_alive_timeout


Short description : keep alive timeout for inactive connections


Parameter description :

If no communication takes place over an existing connection for more
than a certain length of time, the connection is closed by ICM. The
standard value for the timeout is set with this parameter, but can
overridden for each service (see below).

A value of -1 deactivates the timeout. The connection is then never
closed by the ICM.
Caution:
Note that the user context in the work process is not closed after
this period of time. That timeout is defined using the profile
parameter %%rdisp/plugin_auto_logout%%.

Unit : Seconds

Application area: Internet Communication Manager

Default value : 60

Recommend Notes:

Note 705013 - Timeout for ICF services based on ITS

Note 737625 - Parameter recommendations for the ICM

Note 824554 - ICM and SAP Web Dispatcher Timeout Parameter


星期五, 十二月 12, 2008

SAP Enterprise Portal 7 - Modify Default Ports

An SAP portal installation, by default, selects a port for http and https access based on your system number. For example, if your system number is ##, then the default port for portal access would be

* 5##00 for http access
* 5##01 for https access ( aka SSL )

Many Project teams wish to shorten this long url (http://yourserver.yourdomain.com:5##00irjportal). Fortunately, there is an easy way to modify the portal http and https ports and keep it to 80 and 81 ( or anything you wish).

Follow the below given steps to achieve this.
1. Start the j2ee visual administrator tool
2. navigate to cluster -> dispatcher -> HTTP Provider
3. Choose Ports
4. Change the port number to 80 for http and 81 for https
5. Thats it - You’re done!!!!

ports01.jpg

One extra step that’s required if you’re also running IIS (for example, if you’re using an ITS to communicate with an older R3 system or running TREX), you need to make sure that your J2EE ports do not conflict with any of the IIS ports (including the default web server). The best way of doing that is to ensure that the IIS default web server is pointing at different ports AND is stopped.

ports02.jpg

Howto avoid irj/portal in the portal URL

Actually, its a bit of a cheat. What happens is that you’re telling the J2EE WAS that if there is no page specified (such as …/index.html), then open the page …/irj/portal.

1. Go to j2ee visual administrator
2. For each Server, Navigate to Cluster-> Server -> Services -> HTTP Provider
3. Enter /irj/portal in the Start Page Text Field
4. Click on Save Properties
5. Restart this service from visual administrator

va_start_page.jpg

Access http://yourserver.yourdomain.com and your portal login page should come up.

This means that your SAP J2EE Engine Start Page will still show up if you http://yourserver.yourdomain.com/index.html


星期四, 十一月 13, 2008

Check the SAP(oracle) database version

C:Documents and SettingsAdministrator>set ORACLE_SID=C11

C:Documents and SettingsAdministrator>sqlplus /nolog

SQL*Plus: Release 9.2.0.4.0 - Production on ??? 11? 13 16:53:18 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> connect / as sysdba
Connected.

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------

Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production
TNS for 32-bit Windows: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production

SQL> 查看全文

星期二, 十一月 04, 2008

ECC 6.0 install error on sap_add_dbccjob step

I am installing ECC 6.0 as ABAP with System Copy method on Windows Server 2003 Standard Edition with MS-SQL Server 2005 as Database Server. I am facing error at the phase "Create SAP stored Procedures" in the step 025 of 220 (sap_add_dbccjob).

Search sdn.sap.com, found a related thread,

Help with CRM 2007 Installation!

https://www.sdn.sap.com/irj/sdn/thread?threadID=800961&tstart=0&messageID=5158006

Try to disable Symantec Endpoint Protection, Worked!


LOAD_TYPE_VERSION_MISMATCH

When we imported a customize structure Z* which append for table RESB to QAS system, it worked; but imported to PRD system, so many users complained they could not run standard SAP programs, like CO13, CO14, CO15 etc.

Check with ST22, found a lot of ABAP runtime errors, LOAD_TYPE_VERSION_MISMATCH.

Search in service.sap.com, found 2 related notes,

Note 713492 - Additional time stamp check in structure administration

Note 1010590 - Structure components with width of more than 65535 bytes

It seams that this causes an memory overflow, and then leads to an error. Based on Note 1010590, the solution was import Support Package SAPKB70012 or higher, or implement the correction instructions. But the copy of PRD, QAS system was not happen the error. So we decided to restart the PRD to try to solve this.

Worked!


星期四, 十月 30, 2008

codepage 1100 is not released

上周六参加一个SAP培训的讨论会,看见培训用的服务器在英文(EN)登录时报错:codepage 1100 is not release,今天也有群里的朋友问到这个

在SAP找到这个note, Note 144680 - Character set (code page 1100) is not released


哪位朋友相信是手动搞定了这个问题,不知是不是用这个snote?


Why did SAP GUI for Windows 6.40 support end before SAP GUI for Windows 6.20 and 7.10 support does? The Microsoft

As of release 6.40 SAP usually ties the support duration for SAP GUI for Windows releases to the support duration for the development environment used. The reason for this is that we may require corrections from Microsoft for solving an issue in SAP GUI, but Microsoft does not provide us with corrections once support for a development environment is stopped.

  • SAP GUI for Windows 6.40 was developed with Visual Studio 2003 which was de-supported by Microsoft on 14th of October 2008. Consequently SAP GUI for Windows 6.40 was also supported until this very day.
  • SAP GUI for Windows 7.10 was developed with Visual Studio 2005 which will be de-supported by Microsoft on 31st of March 2011.
    Consequently SAP GUI for Windows 7.10 is supported until this very day.
  • SAP GUI for Windows 6.20 is an exception to this rule. It was developed with Visual Studio 98 which is out of maintenance since September 2005. Since we had already announced support for this release to be "longterm" in order to allow customers to reduce their Frontend upgrades SAP GUI for Windows 6.20 is supported until 2010 even though we had to restrict the support (see note 929300).

If you want to know the details, pls check note 147519.


星期三, 十月 29, 2008

Pidgin 2.5.2 problem

1, If you are a chinese who use QQ, pls reinstall 2.5.1 to recover when you found that the pidgin always crashed when you start QQ;

2, After install 2.5.1, you should downgrade the gta to gtk-runtime-2.12.1-rev-b to repair the QQ display problem.

3, Pidgin support MSN, YAHOO, QQ, SKYPE, GTALK for me.


Pop a Message to specific SAP users

*
* Pop a Message to specific SAP users
*
* How to get a list of all the currently logged on users?
* How to popup an instant message on a user's monitor?
* How to get a specific user's details?
* Usage of 'POPUP_GET_VALUES' function module to get data from user
* without having to write GUI code
*
* Submitted by : SAP Basis, ABAP Programming and Other IMG Stuff
* http://www.sap-img.com
*
REPORT ZPOPUP NO STANDARD PAGE HEADING.
INCLUDE <ICON>.

DATA: BEGIN OF USR_TABL OCCURS 0.
INCLUDE STRUCTURE UINFO.
DATA: END OF USR_TABL.

DATA: L_LENGTH TYPE I,
T_ABAPLIST LIKE ABAPLIST OCCURS 0 WITH HEADER LINE,
BEGIN OF T_USER OCCURS 0,
COUNTER TYPE I,
SELECTION TYPE C,
MANDT LIKE SY-MANDT,
BNAME LIKE SY-UNAME,
NAME_FIRST LIKE V_ADRP_CP-NAME_FIRST,
NAME_LAST LIKE V_ADRP_CP-NAME_LAST,
DEPARTMENT LIKE V_ADRP_CP-DEPARTMENT,
TEL_NUMBER LIKE V_ADRP_CP-TEL_NUMBER,
END OF T_USER,
L_CLIENT LIKE SY-MANDT,
L_USERID LIKE UINFO-BNAME,
L_OPCODE TYPE X,
L_FUNCT_CODE(1) TYPE C,
L_TEST(200) TYPE C.

L_OPCODE = 2.
CALL 'ThUsrInfo' ID 'OPCODE' FIELD L_OPCODE
ID 'TAB' FIELD USR_TABL-*SYS*.

CLEAR T_USER. REFRESH T_USER.
LOOP AT USR_TABL.
T_USER-MANDT = USR_TABL-MANDT.
T_USER-BNAME = USR_TABL-BNAME.
APPEND T_USER.
ENDLOOP.

SORT T_USER.
DELETE ADJACENT DUPLICATES FROM T_USER.
LOOP AT T_USER.
T_USER-COUNTER = SY-TABIX.
SELECT V~NAME_FIRST

V~NAME_LAST
V~DEPARTMENT
V~TEL_NUMBER
INTO (T_USER-NAME_FIRST,
T_USER-NAME_LAST,
T_USER-DEPARTMENT,
T_USER-TEL_NUMBER)
FROM USR21 AS U
JOIN V_ADRP_CP AS V
ON U~PERSNUMBER = V~PERSNUMBER AND
U~ADDRNUMBER = V~ADDRNUMBER
WHERE U~BNAME = T_USER-BNAME.
ENDSELECT.
MODIFY T_USER.
ENDLOOP.
SORT T_USER BY NAME_LAST NAME_FIRST.
PERFORM DISPLAY_LIST.

TOP-OF-PAGE.
PERFORM DISPLAY_MENU.
* End of top-of-page

TOP-OF-PAGE DURING LINE-SELECTION.
PERFORM DISPLAY_MENU.
* End of top-of-page during line-selection


AT LINE-SELECTION.
IF SY-CUROW = 2.
IF SY-CUCOL < 19.
T_USER-SELECTION = 'X'.
MODIFY T_USER TRANSPORTING SELECTION WHERE SELECTION = ''.
PERFORM DISPLAY_LIST.
ELSEIF SY-CUCOL < 36.
CLEAR T_USER-SELECTION.
MODIFY T_USER TRANSPORTING SELECTION WHERE SELECTION = 'X'.
PERFORM DISPLAY_LIST.
ELSEIF SY-CUCOL < 50.
PERFORM TRANSFER_SELECTION.
PERFORM POPUP_MSG.
ELSEIF SY-CUCOL < 67.
PERFORM TRANSFER_SELECTION.
SORT T_USER BY NAME_LAST.
PERFORM DISPLAY_LIST.
ELSEIF SY-CUCOL < 81.
PERFORM TRANSFER_SELECTION.
SORT T_USER BY NAME_FIRST.
PERFORM DISPLAY_LIST.
ELSEIF SY-CUCOL < 93.
PERFORM TRANSFER_SELECTION.
SORT T_USER BY MANDT.
PERFORM DISPLAY_LIST.
ENDIF.
ENDIF.
* End of line-selection

*&---------------------------------------------------------------------*
*& Form DISPLAY_LIST
*&---------------------------------------------------------------------*
FORM DISPLAY_LIST.
SY-LSIND = 0.
FORMAT COLOR COL_NORMAL INTENSIFIED OFF.
LOOP AT T_USER.
WRITE: / SY-VLINE, T_USER-SELECTION AS CHECKBOX,
SY-VLINE, T_USER-MANDT,
SY-VLINE, T_USER-BNAME,
SY-VLINE, T_USER-NAME_FIRST(15),
SY-VLINE, T_USER-NAME_LAST(15),
SY-VLINE, T_USER-DEPARTMENT(20),
SY-VLINE, T_USER-TEL_NUMBER(20), SY-VLINE.
HIDE: T_USER-COUNTER, T_USER-SELECTION.
ENDLOOP.
FORMAT COLOR OFF.
WRITE: /(108) SY-ULINE.
ENDFORM. " DISPLAY_LIST

*&---------------------------------------------------------------------*
*& Form DISPLAY_MENU
*&---------------------------------------------------------------------*
FORM DISPLAY_MENU.
FORMAT COLOR COL_HEADING HOTSPOT.
WRITE: (91) SY-ULINE,
/ SY-VLINE NO-GAP, (4) ICON_SELECT_ALL NO-GAP, 'Select All',
SY-VLINE NO-GAP, (4) ICON_DESELECT_ALL NO-GAP, 'Deselect All',
SY-VLINE NO-GAP, (4) ICON_SHORT_MESSAGE NO-GAP, 'Send Popup',
SY-VLINE NO-GAP, (4) ICON_SORT_UP NO-GAP, 'Last Name' NO-GAP,
SY-VLINE NO-GAP, (4) ICON_SORT_UP NO-GAP, 'First Name' NO-GAP,
SY-VLINE NO-GAP, (4) ICON_SORT_UP NO-GAP, 'Client' NO-GAP,
SY-VLINE,
/(91) SY-ULINE,
/(108) SY-ULINE.
FORMAT HOTSPOT OFF.

WRITE: / SY-VLINE, ' ',
SY-VLINE, 'Cli',
SY-VLINE, 'User ',
SY-VLINE, 'First Name ',
SY-VLINE, 'Last Name ',
SY-VLINE, 'Department ',
SY-VLINE, 'Telephone ',
SY-VLINE,
/(108) SY-ULINE.
FORMAT COLOR OFF.
ENDFORM. " DISPLAY_MENU

*&---------------------------------------------------------------------*
*& Form TRANSFER_SELECTION
*&---------------------------------------------------------------------*
FORM TRANSFER_SELECTION.
DO.
READ LINE SY-INDEX FIELD VALUE T_USER-SELECTION.
IF SY-SUBRC <> 0.
EXIT.
ENDIF.
MODIFY T_USER TRANSPORTING SELECTION
WHERE COUNTER = T_USER-COUNTER.
ENDDO.
CLEAR T_USER.
ENDFORM. " TRANSFER_SELECTION

*&---------------------------------------------------------------------*
*& Form POPUP_MSG
*&---------------------------------------------------------------------*
FORM POPUP_MSG.
DATA: L_MSG LIKE SM04DIC-POPUPMSG VALUE 'Experimental Message',
L_LEN TYPE I,
L_RET TYPE C.

LOOP AT T_USER WHERE SELECTION = 'X'.
PERFORM GET_MESSAGE CHANGING L_MSG L_RET.
EXIT.
ENDLOOP.
IF L_RET = 'A'. "User cancelled the message
EXIT.
ENDIF.
* Get the message text
L_LEN = STRLEN( L_MSG ).
LOOP AT T_USER WHERE SELECTION = 'X'.
CALL FUNCTION 'TH_POPUP'
EXPORTING
CLIENT = T_USER-MANDT
USER = T_USER-BNAME
MESSAGE = L_MSG
MESSAGE_LEN = L_LENGTH
* CUT_BLANKS = ' '
EXCEPTIONS
USER_NOT_FOUND = 1
OTHERS = 2.
IF SY-SUBRC <> 0.
WRITE: 'User ', T_USER-BNAME, 'not found.'.
ENDIF.
ENDLOOP.
IF SY-SUBRC <> 0.
* Big error! No user has been selected.
MESSAGE ID 'AT' TYPE 'E' NUMBER '315' WITH
'No user selected!'.
EXIT.
ENDIF.
ENDFORM. " POPUP_MSG

*&---------------------------------------------------------------------*
*& Form GET_MESSAGE
*&---------------------------------------------------------------------*
FORM GET_MESSAGE CHANGING P_L_MSG LIKE SM04DIC-POPUPMSG
P_RETURNCODE TYPE C.
DATA: BEGIN OF FIELDS OCCURS 1.
INCLUDE STRUCTURE SVAL.
DATA: END OF FIELDS,
RETURNCODE TYPE C.

FIELDS-TABNAME = 'SM04DIC'.
FIELDS-FIELDNAME = 'POPUPMSG'.
FIELDS-FIELDTEXT = 'Message :'.
CONCATENATE ' - Msg from' SY-UNAME '.' INTO FIELDS-VALUE SEPARATED
BY ' '.
APPEND FIELDS.

CALL FUNCTION 'POPUP_GET_VALUES'
EXPORTING POPUP_TITLE = 'Supply the popup message'

IMPORTING RETURNCODE = P_RETURNCODE
TABLES FIELDS = FIELDS.

IF P_RETURNCODE = 'A'.
EXIT.
ELSE.
READ TABLE FIELDS INDEX 1.
P_L_MSG = FIELDS-VALUE.
ENDIF.
ENDFORM. " GET_MESSAGE

*-- End of Program

SAP Tutor Personal Player

here is a link to download

SAP Tutor Personal Player

https://websmp102.sap-ag.de/~sapidp/011000358700001572552002E 查看全文

星期一, 十月 27, 2008

Remove developer key from DEVACCESS table.

*&---------------------------------------------------------------------*
*& Report zdeldevkey.
*&
*&---------------------------------------------------------------------*
*& Remove developer key from DEVACCESS table.
*&
*&---------------------------------------------------------------------*

REPORT zdeldevkey.
TABLES: devaccess.

DATA: BEGIN OF i_dev OCCURS 0.
INCLUDE STRUCTURE devaccess.
DATA: END OF i_dev.

DATA: i_sel LIKE devaccess OCCURS 0 WITH HEADER LINE.

DATA: vg_check TYPE c,
vg_lsind LIKE sy-lsind,
vl_index TYPE i,
do_num TYPE i,
vg_num TYPE i.

SELECT-OPTIONS: s_uname FOR devaccess-uname.

If sy-uname <> 'KENLEE'.
exit.
Endif.


START-OF-SELECTION.
SELECT * INTO TABLE i_dev FROM devaccess WHERE uname IN s_uname.

LOOP AT i_dev.
WRITE: / vg_check AS CHECKBOX,
i_dev-uname,
i_dev-accesskey.
do_num = do_num + 1.
ENDLOOP.

SET PF-STATUS 'T001'.
*

AT USER-COMMAND.
CASE sy-ucomm.
WHEN 'DELE'.
PERFORM fm_delete_uname.
ENDCASE.
COMMIT WORK.
*&---------------------------------------------------------------------*
*& Form fm_delete_uname
*&---------------------------------------------------------------------*
* text
*----------------------------------------------------------------------*
* --> p1 text
* <-- p2 text
*----------------------------------------------------------------------*
FORM fm_delete_uname .
DATA: vl_tabix LIKE sy-tabix,
vl_read_line LIKE sy-tabix,
vl_ret TYPE c,
vl_page TYPE i.
DATA: vl_check TYPE c.
vl_read_line = 2.
vl_page = 1.

LOOP AT i_dev.
vl_tabix = sy-tabix.
vl_read_line = vl_read_line + 1.

CLEAR vl_check.
READ LINE vl_read_line OF PAGE vl_page
FIELD VALUE vg_check INTO vl_check.

IF vl_check = 'X'.
READ TABLE i_dev INDEX vl_tabix.
MOVE-CORRESPONDING i_dev TO i_sel.
APPEND i_sel.
ENDIF.
ENDLOOP.

CALL FUNCTION 'POPUP_TO_CONFIRM'
EXPORTING
titlebar = '确认'
text_question = '是否确认删除'
IMPORTING
answer = vl_ret
EXCEPTIONS
text_not_found = 1
OTHERS = 2.
IF sy-subrc <> 0.
MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
ENDIF.

IF vl_ret EQ '1'.
delete DEVACCESS from table i_dev.
commit work.
LOOP AT i_sel.
WRITE: /
i_sel-uname,
i_sel-accesskey.
ENDLOOP.
ELSEIF vl_ret EQ 'A'.
RETURN.
ELSE.
stop.
ENDIF.
ENDFORM. " fm_delete_uname

PS, so many thanks my ABAP workmates Owen Zeng.

 查看全文

Migrate EVA Command View to other machine.

Try to reinstall EVA command view on new machine instead of source machine.

It must to install EVA Command View on new machine(Server A) with local group method, with Domain group method will failled with login error "insufficient privilege", and then add the user to HP Storage Admins as member manually.

Login with the user, and the initial screen with pop the following message, select 'OK' to continue,

"Storage System Managed by Another Agent

Another management agent on server XXXXX at IP address 123.123.134.123 may be actively managing storage system sap_eva.

Only one agent is allowed to manage a storage system at a time.

To disable other management agents, simply click the OK button and management will be redirected to this agent.

Click the Cancel button to leave this page without changing the management agent for this system. "

星期四, 十月 16, 2008

Migrate log file to new disk

Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONE MicrosoftInternetExplorer4

1, Shrink log file and backup database;

2, Create new disk for migrate log file;

3, Stop LXQ instance;

4, detach LXQ database;

5, Copy log file to new disk;

6, Attach LXQ database with new log file;

7, Startup LXQ instance and test;

8, Repeat 4-7, resume LXQ log file to original path;

Finished in 30 minutes.


星期五, 十月 10, 2008

SAP help files (.chm) not displayed correctly

Note 857216

http://support.microsoft.com/kb/896054

REGEDIT4
[HKEY_LOCAL_MACHINESOFTWAREMicrosoftHTMLHelp]
[HKEY_LOCAL_MACHINESOFTWAREMicrosoftHTMLHelp1.xItssRestrictions]
"MaxAllowedZone"=dword:00000001

星期二, 十月 07, 2008

Method to start SAP Portal Server When MMC System Nodes Are Missing

自己也写过这个情况的记录,现在因为有朋友也出现这情况,一时找不到自己的文档,还是SDN上找一遍凑个数吧

Added by Swathi Rao Padma , last edited by Craig Cmehil on Sep 26, 2008 (view change)
Labels:

Add Labels
Wait Image
Enter labels to add to this page:
Tip: Looking for a label? Just start typing.
Add this page to your favorites list Watch this page

Have you ever ended up with amusement that your portal server is no more displayed in SAP Management Console on expanding.

In such scenarios how can we start the server and work .Before proceeding towards solution ,lets know about the various reasons for occurrence of such scenarios.

Mostly the cause is shutdown of the PC without stopping the server.This usually happens as in major MMC automatic updates ,security patches run weekly which restart your system timely.In such times ,if the Portal server was up ,then due to dirty closure the SAP Instances get flushed out from MMC and the interface between the instance and DCOM will be lost.

Solution :

Initially check the services in PC ,run services.msc where you can observe that the SAP Portal components will be missing.

For a proper server the services running in your PC are as follows:

Example:
SAPDB: .M760018 f:sapdbn06dbpgmkernel.exe localsystem allow service....
SAPDB: .M760018 (omststknl.exe) f:sapdbn06dbpgmomststknl.exe
SAPDB: .M760018 (quick) f:sapdbn06dbpgmquickknl.exe
SAPDB: .M760018 (slow) f:sapdbn06dbpgmslowknl.exe

SAPN06_00 F:usrsapN06SCS00exesapstartsrv.exe pf=F:usrsapN06SYSprofileSTART_SCS00_H1A-2F143-81Z

SAPN06_01 F:usrsapN06JC01exesapstartsrv.exe pf=F:usrsapN06SYSprofileSTART_JC01_H1A-2F143-81Z

To start the missing services ,the first thing we can have to do is to add up the instances to MMC ,

The procedure to be followed is:

Goto

1.usrsap<SID>SCS00exesapstartsrv.exe ,start and give in details

SystemID - <SID> (for example example N06)

Nr - Central Instance Number ( example 00)

Profile - Go to usrsapN06SYSprofile , check for the existence of file name starting with START_SCS, and mention full path of this file name here. Last characters signify your host name.

for example : F:usrsapN06SYSprofileSTART_SCS00_H1A-2F143-81Z

User - .SAPService<SID> for example: .SAPServiceN06
Password - <>

- The instance gets installed successfully message is prompted.

2. Now Go to usrsap<SID>JC01exesapstartsrv.exe ,start and give the details the details as explained above..

SystemID - N06
Nr - 01
Profile - F:usrsapN06SYSprofileSTART_JC01_H1A-2F143-81Z
User - .SAPServiceN06
Password - <>

- The instance gets installed again successfully message is prompted.

Now reopen the SAP MMC,expand the SAP Systems node .Now the instances are added back to console.


星期一, 九月 08, 2008

Igswd.exe is not working

网上很多都说SAP note 824281有solution, 哪只是说有可能是profile的参数太长了,要改成短的。

其实运行IGS的实际命令是:

IGSP = -mode=all -sysname=<SID> -sysno=<XX>

只要将这SID和NO填好即可。


星期五, 八月 29, 2008

sapcar.exe

C:TEMPsp46c>sapcar
usage:

create a new archive:
SAPCAR -c[vir][f archive] [-P] [-C directory]
[-A filename] [-T filename] [-X filename]
[-p value] [-V] file1 file2 ...

list the contents of an archive:
SAPCAR -t[vs][f archive] [file1 file2....]

extract files from an archive:
SAPCAR -x[v][f archive] [-R directory] [-A filename]
[-V] [file1 file2....]

verify the archive:
SAPCAR -d[v][f archive] [-V] [file1 file2....]

append files to an archive:
SAPCAR -a[v][f archive] file1 [file2....]

merge two archives:
SAPCAR -m[v]f "source target"

check availability of files to be processed:
SAPCAR -l [-A filename][-X filename] [file1 file2...]

other options:
-a : append files to an archive
-A FILE : get names to include from file FILE
-C DIR : change to directory DIR
-e : redirect output from stdout to file sapcar_output
-f FILE : use archive file FILE (default DEFAULT.SAR)
-g : ignore case of of archive names while extracting,
testing or listing archives
-h : do not change permissions of existing directories
during extraction
-i : ignore inaccessible files while creating an archive
-l : check availabilty of files to be processed
-lower : convert filenames to lowercase while extracting
-m : merge two archives
-n : print statistical information
-p octalvalue : set permissions of all files in archive to value
-P : use absolute path-names (use carefully)
-r : do not resolve symbolic links/shortcuts while creating
an archive
-R dir : use dir instead of current directory
-s : do free space check
-T FILE : rename files to be included in FILE
-v : verbosely list files processed
-V : compute or verify checksum (obsolete, always set,
for backward compatibility)
-X FILE : get names to exclude from FILE

examples:
create archive with all files and directories in the current directory
including point files:
SAPCAR -cvf MY.SAR .

create archive with all files and directories in the current directory
without point files:
SAPCAR -cvf MY.SAR *
Note that SAPCAR treats "*" and "?" as wildcard characters. The former
matches any character string, while the latter matches any single
character.

create archive with a complete directory and directory rights:
SAPCAR -cvf MY.SAR dir

create archive with all files of a directory without the directory
itself:
SAPCAR -cvf MY.SAR dir/*
if during extraction with SAPCAR -xvf MY.SAR the directory dir does not
exist it will be created with rights 755

create archive with only the files of a directory
SAPCAR -cvf MY.SAR -C dir .
or better
(cd dir; SAPCAR -cvf ../MY.SAR .)

merge two archives:
SAPCAR -mvf "a source-archive.sar target archive from 27.5.1999.sar"

append files to an archive:
SAPCAR -avf archive.sar file1 file2 file3

extracting/verifying files:
If you try to extract files from an archive that is not a valid SAPCAR
archive according to the version 2 specification SAPCAR assumes an archive
of the old format and automatically invokes the appropriate extraction
routine. If it still cannot handle the archive it will stop execution.
Notice that extracting out of old archives only works with the command
options known to the old CAR application.

using absolute pathnames:
If you create an archive with absolute pathnames the files will be
extracted with exactly these pathnames! SAPCAR does not cut the first
slash like the UNIX tool tar.

specifying a list of archives for extracting/verifying/listing:
You may call SAPCAR with the following command line:
SAPCAR -xvf "ARCHIVE1.SAR ARCHIVE2.SAR"
thereby specifying a list of archives you want to extract. Note
that you have to delimit archive names with "," if at least one
of the archive names you call SAPCAR with contains at least one
whitespace character; e.g.
SAPCAR -xvf "ARCHIVE WITH BLANK.SAR, ARCHIVE.SAR, ARCHIVE2.SAR"

using A, T and X option:
All entries in the specified files are treated relative to the current
working directory unless the entry is an absolute pathname (in this case
the relevant file will be archived with an absolute pathname).
If you want to specify a directory path in these files use the slash ("/")
as path delimiter.

Use the pipe sign ("|") to separate old and new names in a T file when
these names contain whitespaces. If neither the old file name nor the new
one contains any whitespaces you may use whitespaces as delimiter between
old and new name (that means a valid CAR rename file is also a valid SAPCAR
rename file and hence may be given with the -T option).
Note that pattern matching is not supported for entries in -A, -T and -X
files (i.e. "*.cpp" will not result in processing all cpp-files
in the current directory).

Lines starting with "#" as the first non whitespace character will be
ignored by SAPCAR (this also holds true of lines containing only
whitespaces).

If you insert a directory name in the specified file the complete
directory with the directory rights will be included in the archive.

If you specify dir/filename only this file will be included in
the archive. During extraction the directory dir will be created if
it does not exist.

using -C option:
All relative filenames in the command line are treated as relative
to the specified directory.

SAPCAR 2.0, build 410504

C:TEMPsp46c>

If you have a lot of .car files in the folder,which you want to upgrade the kernel, you can run the following command:

C:TEMPsp46c>sapcar.exe -xvf "*.car"


SPAM: QUEUE_NOT_EMPTY ... HELP URGENT

System: 46C/NT4/Ora817

I am trying to import the SPAM update KD40. The import aborts at CHECK_REQUIREMENTS with cause of error QUEUE_NOT_EMPTY. I seard OSS but nothing.

Solution:

delete or remove content of the buffer file in usrsaptransbuffer folder.


星期三, 八月 27, 2008

Upgrade Procedure / Support Packages

Upgrade Procedure / Support Packages

Upgrade Procedure / Support Packages

During an upgrade or the import of an Support Package, existing objects of the SAP standard are overwritten with the objects redelivered. To help the customer retain the objects modified in a previous release, SAP provides all modified objects which are redelivered (in an upgrade or Support Package) in the upgrade adjustment of transactions SPAU and SPDD. These transactions allow customers to enter their modifications into the corresponding new objects being delivered at upgrade. The Modification Assistant supports this process of adopting customer modifications.

In the past, all objects modified by a customer and delivered again by SAP, an IBU or an SAP partner, had to be manually re-modified during an upgrade. Now, modifications are either automatically adopted or the system provides you with an assistant for adjusting your modifications to the newly upgraded configuration.

In general, objects altered using the Modification Assistant can now be automatically accepted into the upgraded system if the modifications undertaken in the original version do not directly overlap those made in the customer version. If collisions occur between the two versions at upgrade (naming collisions, or if SAP has deleted an object modified by a customer), the system offers support during the upgrade, which means that a semi-automatic adjustment is made. In some cases, however, you may still have to manually adjust objects using ABAP Workbench tools.

Objects modified according to the old system used prior to the advent of the Modification Assistant must be manually maintained after an upgrade has been run.

Use transactions SPDD and SPAU during an upgrade to select these objects and modify them manually.

  • Transaction SPDD allows you to adjust modifications to ABAP Dictionary objects during an upgrade.

For more information, refer to:

Adjusting ABAP Dictionary Objects

Prerequisites

Procedure

Preparing to Run Transaction SPDD

Transaction SPDD

  • Transaction SPAU allows you to adjust programs, function modules, screens, interfaces, documentation, and text elements after an upgrade.

Additional information about the modification adjustment procedure using transaction SPAU can be found in Adjusting Repository Objects.

Additional information about the upgrade procedure can be found in:

Upgrading from Release 4.5A or Less

Modifications Made by Several Different People

Adjusting Other SAP Systems

Upgrading the Development System

Upgrading the Production System

Handling Change Requests During Modification Adjustment

Choosing a Change Request for Modifications

Local and Transportable Change Requests

Releasing Tasks at the End of Modification Adjustment

Choosing a Change Request to Transfer Modification Adjustments to Other SAP Systems

Notes (Troubleshooting)

一直对打SP后运行SPDD和SPAU知其然,昨天面试被问到这个问题,汗!完败!这部份HELP出自Changing the SAP Standard(BC),在SPDD或SPAU的界面按F1即可.


星期二, 八月 26, 2008

Set color to system

1. Alt+F12 -> New Visual Design
Select the General tab. In the Active Theme (top left) window, make sure select System ENJOY. Click on Apply.

From sdn forum, maybe you can find a post said select system dependent, but i test should be select enjoy.

2. Click on the color setting tab or Alt+F12 -> Set Color to System
That will let you choose the color.


星期一, 八月 25, 2008

ITS WEBGUI in ECC6.0

Copy from: https://www.sdn.sap.com/irj/sdn/thread?threadID=303806

Check if you have activated:
1) With transaction SICF and locate the services by path
/sap/public/bc/its/mimes
/sap/bc/gui/sap/its/webgui

2)With Transaction SE80 locate from the menu, Utilities --> Settings-->Internet Transaction Server (Tab)-->Publish (Tab) and set “On Selected
Site” = INTERNAL.
This restricts the publication in the next step to the integrated (internal) ITS.

3)In SE80 only, Locate the Internet Services: SYSTEM and WEBGUI.
Publish these services with the Context Menu -> Publish -> Complete Service

4)Now Browse to http://<server>:<icmport>/sap/bc/gui/sap/its/webgui/! and login to the webgui.

星期五, 八月 22, 2008

How to disable the User menu?

use sm30 tcode and change the table ssm_cust and change the parameter:

ALL_USER_MENUS_OFF

NO (default), YES or 'X' - Do not Display User Menu on Easy Access Screen (Note 380029)


CUSTOMER_MENU_OFF NO (default), YES or 'X' - Do Not Display Customer Menu on Easy Access Screen (Note 380029)


SAP_MENU_OFF NO (default), YES or 'X' - Do not Display the SAP Menu on the Easy Access Screen (Note 380029)

The other method is use sm30 tcode and change the table users_ssm to determine whether or notusers are allowed to switch between the SAP menu and their user menus.

Apply:

If a user ask you based on the role menus, you can not find any key.

If a user has several roles assigned, then some functions can be repeated in different parts of the role-based user menu.


星期三, 八月 20, 2008

Types of SAP Support Packages

Get from sap website.

Types of Support Packages

SAP delivers various types of program corrections with Support Packages as part of the software maintenance. Support Packages automatically correct a whole range of errors by downloading corrections into the SAP System. Two categories of Support Packages are available: ABAP Support Packages and Java Support Packages.

ABAP Support Packages

ABAP Support Packages contain corrections and updates for the ABAP components of the SAP system that were performed up to a certain point in time. Each Support Package is based on the previous one. If you want to import Support Package 10, for example, you must also import all previous Support Packages (1-9). To import ABAP Support Packages, you use the Support Package Manager.

All SAP R/3 Releases up to 4.5 are supported by corrections in the form of SAP R/3 Support Packages (formerly Hot Packages) or SAP R/3 HR Support Packages (formerly Legal Change Patches HR) until the end of their maintenance period.

SAP HR Support Packages contain corrections or adjustments due to legal changes for HR functions in SAP R/3. Up to SAP R/3 3.1I (and SAP R/3 4.0B up to LCP HR 53), SAP R/3 HR Support Packages contain corrections for SAP HR as well as the same set of corrections as SAP R/3 Support Packages. As of SAP R/3 4.5B (and SAP R/3 4.0B as of LCP HR 54), the content of the SAP R/3 Support Packages is no longer included in SAP HR Support Packages.

Component Support Packages

ABAP Support Packages are available for all components of mySAP.com, such as SAP Basis, SAP BW, or SAP Advanced Planner and Optimizer (SAP Basis, SAP BW, SAP APO Support Packages).

Add-On Support Packages

Corrections for add-ons, such as industry solutions, strategic development projects or SAP R/3 Plug-Ins, are provided in Add-On Support Packages. For more information on Add-On Support Packages, refer to SAP Note 160168 .

Conflict Resolution Transports (CRT)

CRTs adapt Component Support Packages to add-ons, such as industry solutions (IS components). If an add-on modifies objects in the SAP R/3 Core components, conflicts with SAP R/3 Core Support Packages may arise. A CRT resolves these conflicts. For more information on CRTs, refer to SAP Note 53902.

SPAM/SAINT Updates

SPAM/SAINT Updates extend the functions of the Support Package Manager (Transaction SPAM) and the SAP Add-On Installation Tool (Transaction SAINT).

Java Support Packages

Java Support Packages contain corrections and updates to Java components. They are delivered in the form of Software Component Archives (SCA). Unlike ABAP Support Packages, Java Support Packages always contain the complete version of the Development Components for the application. You therefore need to apply the latest Support Package only. If there are dependencies with other Java Support Packages, these are specified in an SAP Note.

As of SAP NetWeaver 2004s, you can apply Java Support Packages using the Java Support Package Manager (JSPM). For more information on JSPM, refer to the quick link /JSPM.

Java Support Packages are available as of SAP Web Application Server 6.20. For SAP Web Application Server 6.20 and 6.40, you apply Java Support Packages using the Software Deployment Manager (SDM). The SDM is contained in the SAP Web AS installation as of 6.20. For more information on SDM, refer to SAP Note 544244.

Support Package Stacks

A Support Package Stack is a set of Support Packages and patches for a specific product version that must be used in the specific combination.

For more information on Support Package Stacks, refer to the quick link /sp-stacks.

All corrective software packages, for SAP NetWeaver 2004s and SAP Business Suite 2005 and beyond that are delivered after April 2nd, 2007 will ONLY be available via SAP Solution Manager's Maintenance Optimizer.


星期五, 八月 15, 2008

login/password_expiration_time

4月份因为内部Audit的原因,加强了Security,新增(更改)了部份login parameter
login/password_expiration_time 60
login/no_automatic_user_sapstar 0
login/failed_user_auto_unlock 1

特别要指出没有login/password_expiration_time在profile时SAP取的defaul value是0,当添加后从0改成60然后重启生效,哪么所有Dialog用户被要求改密码;这个参数第一次的从0到60的更改的副作用有点象reset "almost" users'password;而这里为什么说almost user,是因为第一次是0到60,估计绝对大部分用户的password都不符合SAP password policy,所以这里他们都要更改密码,而更改过后,如果你再次改login/password_expiration_time,用户就不要再次更改了,直到password_expiration_time到期。所以有Admin异想天开用它来更新password policy(象密码长度、字符变动),的确是好注意!我试过从profile再次删掉login/password_expiration_time,让SAP取默认值0,重启生效,同一用户不必更改密码;下一测试添加login/password_expiration_time=60重启生效,同一用户同样不必更改密码;下一测试更改login/password_expiration_time=120,同一用户同样不必更改密码;具体测试过程如下

Profile Active value Change password
N/A 0
login/password_expiration_time 60 YES
login/password_expiration_time 120 NO
delete the parameter from profile 0 NO
login/password_expiration_time 20 NO
login/password_expiration_time 60 NO
login/password_expiration_time 120 NO



但如果要避免更改密码,似乎没什么好办法,但也不没有方法,只是不是针对所有用户:
1,前面有提到更改密码只涉及Dialog用户,所以可以将有需要的用户(如大BOSS)变成Service用户;
2,in the table USR02, just set a date far in the future for the field BCDA1 (password last change). For example, if you want to set it so user SMITH does not have to change his password until 2010, you can use the following SQL script : update USR02 set BCDA1 = '20101231' where BNAME='SMITH' Just replace the values for BCDA1 and BNAME with your own values ! This script is for MS SQL Server + R/3 46B and 46C, but the syntax should not be very different for other database systems and R/3 versions.

但从国内的企业应用来看,60天似乎太短了,下一阶段要设成120天;在ECC6 IDES测试过,从60到120,用户不需要更改密码。

相关的表:USR02

另外要说明的是login/failed_user_auto_unlock,明显的是一鸡肋,用户一但发现因密码错误不能登录,他就会不停的试不确定的密码直至被锁,而被锁后,根本不会等第二天自动解锁,他们会直接找Admin.

星期四, 八月 14, 2008

金山词霸企业版VS谷歌版

不在企业做的朋友多不知道金山词霸居然还有企业版,公司现在一直在用,本着短小精干的精神,想试用一下才20MB大小的谷歌版,结果问题来了!

在PDF文档里居然无法取词,而企业版怎么试也没问题。是跟企业版有冲实呢?还是卖给谷歌一个半残品呢?这是一个謎啊!如果是后者,哪金山太雷人了


星期三, 八月 13, 2008

slove ‘Lock table overflow' process

出错情况:

用户报称修改QT时出错:‘Lock table overflow';

...

检查日志SM21,

Internal lock administration error
> EqSetCluster(); rtc=16 enxxmenq1905
Lock table overflow
Internal lock administration error
> EqSetCluster(); rtc=16 enxxmenq1905
Lock table overflow
Internal lock administration error
> EqSetCluster(); rtc=16 enxxmenq1905
Lock table overflow
Internal lock administration error

详细日志,

An overflow of the lock table occurred when you were setting the loc
The lock table consists of several individual tables each of which
can overflow individually. The subsequent line indicates which of th
tables has overflowed.
The lock table is contained in the memory of the lock server
(-> enqueue server). Only the total size can be set. This is set
with the profile parameter "enque/table_size" in the instance
profile of the central locking server. Its value is entered in KB.
The setting only becomes effective when the system is restarted.
The default size of the lock table is 4096 KB.
Please note that when increasing the size of the lock table, a disk
requirement of approx. 1.5 x the size of the lock table is necessary
in each case in the global directory for the reporting file and in
the log directory for the backup file.
Before you increase the lock table after an overflow, you should
always check whether the overflow resulted from a program error
or an operating error.

检查profile parameter "enque/table_size" with RZ10,

Short description: Size of lock table

by this parameter:

Parameter description :

This parameter defines the size of the lock table that is held in
main memory by the enqueue server. The lock table contains all of
the information about which locks are currently held, and by whom.

The size of the lock table limits the maximum number of lock
entries, the maximum number of elementary lock names, and the
maximum number of lock owners.
In the case of an overflow of the lock table, you should check
whether the update server is working correctly, since the lock table
can grow in size very quickly if updates stop. If the cause is not
update problems, you can use this parameter to increase the size of
the lock table.
The Computing Center Management System (CCMS) constantly monitors
the status of the lock table, and issues warnings if the free space
runs short.

The Computing Center Management System (CCMS) constantly monitors
the status of the lock table, and issues warnings if the free space
runs short.
You can view the fill level of the lock tables using the statistics
functions of lock management (transaction SM12 -> Extras ->
Statistics).

实施时考虑过公司的运行情况,将实际大小设成10MB,

enque/table_size = 10000

check LOCK status with SM12,

发现total locks居然达到8K有余,Nr_of_Locks: 8701,有异于平时系统正常运行状态,而绝大部分是一个用户锁定的;

查看用户进程SM50,确认用户在运行CORUAFFW,询问用户运行Tcode:COGI,确认用户在做物料替换时中断了会话,从而导致系统锁定的大批物料而没有释放。


解决方案:end session in SM50.


星期五, 八月 08, 2008

How to search sofeware which not belong to u?

Sometimes, we want to download the other software which not My Company's Application Components

like as other database of IDES, old version support package.

SAP Software Distribution Center

Search in SAP Software Distribution Center

Advanced Search

Change Search Method to All terms, default Context is restriction, change to no restriction, Max Search Result to 1000, select all the search object object, You will find you want to search. Good luck!

CD/DVD Products Components
Non-ABAP Support Packages Product Versions Component Versions
ABAP Support Packages

星期四, 八月 07, 2008

SAP最新的“挤奶”行动

Tcode: USMM

背景资料:

1、业内人士称SAP北亚区高管曾辱骂中国客户

...

太多了,选一则贴上,这里要注意的是:

为了达成这一战略目标,纪秉盟将10亿元任务分解到四个季度,即第一季度的“绝对值指标”是12%、第二季度23%、第三季度是20%,第四季度是45%。

现在是第三季,也有会计说法是第二季,从朋友,顾问,自身得到的体验是,SAP开始大范围的“挤奶”了,而且重点之一是从老客户哪里挤奶,还不能是纸质包装奶,必须是新鲜奶,有得忙了!


SQL error 2812: Could not find stored procedure.doc

起因:是在一台测试服务器上,安装了多个测试Instance,一次在安装Solution Manager时,将其覆盖在ERP上;

现象:一是登录时显示SAP菜单出错,报错START_CALL_SICK,Database inconsistency: Start Transaction SICK.但运行SICK还是出错,注意到"Can't execute sap_check_if_sick".但运行一些模块Tcode似乎没问题;

二是在激活DDIC object时出错,报错SQL error 2812 occured: Could not find stored procedure 'sap_get_object_type'.

设想:可能是错误的安装删除了SQL procedure

在现象二的帮助里,有The stored procedure must be created in the database. To do this, follow the instructions in SAP Note 460268.

Note Language: English Version: 1 Validity: Valid from 14.12.2001
Summary
Symptom
The following error message is displayed in the status bar or written to a
log file when executing a DDIC function:
SQL error 2812: Could not find stored procedure ...
More Terms
MSSPROCS
Cause and Prerequisites
As of Release 6.20, the access to the database for the return of system
catalog data is executed with stored procedures. These are called in
function modules of the SFMSS_SYSCAT group.
If such a stored procedure is missing, the above SQL Server error message
is issued. It is then transferred to the status bar or the log via the
functions modules.
Solution
Solution
Proceed as follows:
o Execute the MSSPROCS report in SE38.
o Choose the version of your SQL Server as the Database Release value
and confirm with Enter.
o Select the missing stored procedure in the table control.
o Choose "Start". A log must be displayed notifying you that the
procedure was successfully executed.

解决:按照Note上的指引,执行MSSPROCS,选择SQL版本9.0(SQL2000是8.0,SQL2005是9.0),程序已自动选择应安装的组件,点开始运行,很快就运行完提示一系列的脚本已执行。

问题解决。


星期六, 七月 26, 2008

About SAP installation problem

看过很多同学在述说自己在安装IDES有多辛苦,过程有多复杂,时间之长,机器之慢,说起来臭婆娘的哪块布要长之

装过数十次,总结一下:

1,内存,要高;

 见过好多同学用1GB内存在哪折腾。没错,我还用过512MB装成功过,哪是4.6B的sql版本;但要知道必先利其器这话,SAP说到底就是个数据库的应用软件,没个大内存你好意思出手!SAP官方安装文档一出口就是标准配置2GB,这话跟微软说的没两样,看看就算了,千万别信!4GB吧,越多越好越快越没问题,还会帮你省点钱

2,硬盘,要大;

 光源文件就10几个GB,放在网络盘你还装不上,不在本地盘不行,ECC6装完就80GB了,你不搞个250GB都不好出去见人!有条件搞个RAID1,IDES容易坏硬盘,尤其是内存少的机器,我都坏三还是四块了

3,网卡,

 杨生哪写着虚拟网卡,哪是因为人家哪时候穷,买不起网卡,新来的就别照本全搬了

4,JAVA,

 千万别想着最新版本,SAP让你用哪个老不死的就是因为它就是传说中的稳定版

5,版本,

 个人感觉4.6D的ORACLE版好点,一来是ORACLE8,让你学点数据库的知识,不是贬低MSSQL,其实SQL2005比ORACLE10或11G性能上不差,可以说有过之而无不及,当然是Windows IA的平台上,Unix就不要比了,SQL没这版本啊,只是MSSQL都是图形界面,让你无从下手之余人变懒了;二是容量少,60GB拿下;三者,SAP什么版本其实根子还是R/3,你就是最新搞到ECC6R3对basis还是没什么新意,不就多JAVA,不就更容易安装,切,硬件需求之高,一点不利普及

 查看全文

星期四, 七月 17, 2008

About login/failed_user_auto_unlock work or not

记录在这里不是简单的说将login/failed_user_auto_unlock=1后,再reboot SAP这种问题,而是说到底这个para.生效了没有,有没有在midnight自动解锁用户?

整个persidure是:

1,用户因为输错密码太多(login/fails_to_user_lock)被封锁;

   这里算第一天,按SAP OSS说明,这天的Midnight,这个用户应该被解锁

2,Midnight,用户解锁;

3,用户用正确的密码登录or错密码;

哪为什么会有这篇废话?而且网上还有哪么多人对这个wonder and puzzle?

究根道底就是虽然用户解锁了,只要用户还没用正确的密码再次尝试登录前,作为管理员的你在SU01之类的程序看这个用户时,你会发现这个用户的状态居然是Password logon not allowed(too many failed logons),其实只需要用户的一次正确登录,这个状态就会清零(这就是cause of puzzle);如果用户再次用了错密码,要么找你,要么等一天再试,你说用户会选什么?


星期四, 六月 26, 2008

How do you pronounce IT?

The following pronunciations are based on an approximation of U.S. English. An understanding of U.S. English may be needed to understand how to interpret a particular pronunciation rendering. If you know of a term in information technology that people often stumble over or mispronounce, please send us an e-mail and let us know!

Note: In writing, many style editors prefer that the spelled-out version of a term should be used in the first written occurrence of a term in an article (for example, "wireless local area network (WLAN)" instead of just "WLAN" or even "wireless LAN"). Thereafter, the abbreviated form can be used.

In pronouncing an abbreviation or reading it aloud, the pronouncer may want to convert the abbreviation into the long form for the understanding of a listener (for example, reading "wireless LAN" for "WLAN").



TERMPRONUNCIATION
802.11eight-oh-two-dot-eleven
ABAPah-bop
ACLaye-cee-el or aye-kull
APARAY-pahr
ASCIIASK-ee
BAPIBAH- pee
Beowulfbay-ah-woolf
cachecash
canonicalizationKA-nahn-nihk-uhl-ih-ZAY-shun
CICSkicks or cee-eye-cee-ess
CLECcleck or cee-leck
COMMAREACOM -area
daemonDEE-mon or DAY-mon
dataDAY-tuh
DOSdoss
EBCDICEHB-suh-dik
FAQfack or eff-ay-q
Freethem.Kfree-thum-KAY (do not pronounce the dot)
FUDfud
gibibyteGIH-bee-bite
GIFgiff (with a hard "g" as in goat) or jiff (as in the peanut butter)
GNOMEGUH-nome or nome (rhymes with home)
grokgrahk
GUIGOO-ee
GNUGUH-new or new
heterogeneoushet-ter-o-GENE-ee-us
HIPAAHIP-puh
IDSeye-dee-ess
IPsecEYE-pee-sec
iSCSIEYE-scuzzy
ITEYE-TEE
J2EEjay-TWO-ee-ee or, by some, jah-TOO-ee
keitaik-tie
KerberosKERR-berr-ross
KLOCKAY-lock
LANlan (rhymes with man)
LPAREL-par
LEClehk
LinuxLIH-nux
LOBell-oh-bee
LU-LUloo-loo
mebibyteMEH-bee-byte
MIPSmihps
MySQLmy-ess-q-el
NetBEUINET-boo-ee
OLE (in Windows)OH-EHL-EE
OS XOH-ESS-ten
parityPAIR-i-tee
PC-cillinPEE-CEE SIHL-uhn (rhymes with penicillin)
PEBCAKPEEB-kak
POSIXPAH-zihcks
PostgreSQLpost-gree-es-q-el
QAMkew-ay-ehm
queueQ
QWERTYKWEHR-tee
RACFrack-EFF
RijndaelRAIN-dahl
routerrowt-ter (US) or root-ter (UK)
SAMLsah-muhl
SAPess-ay-pee
SAPScriptsap-script
schemaSKI-muh
SFAess-eff-ay
SiebelSEE bull
SophosSO-fohs
SQLess-q-el or SEE-kwehl (both are used)
SuSEsu-zee
sysopSISS-op
UDDIU-die or ewe-dee-dee-eye
URLyew-are-el
VARvahr
vivee-aye
VoIPvee-oh-eye-pee
WANwan (rhymes with man)
wav fileWAVE-file
WebDAVWEB-daav
Wi-FiWY-FY (rhymes with sky)
Windows MeWIHN-dohs EHM-EE
WLANdouble-you-lan
WSCIwiz-key
WSDLwiz-dull
WYSIWYGWIZ-ee-wig
XanaduZAN-ah-doo

星期四, 六月 05, 2008

To update the SAP kernel

1. create a folder to store the kernel SAR file

2. copy the SAR file to the new folder

3. run sapcar -xvf SAPEXEDB* (database dependent)

4. run sapcar -xvf SAPEXE_* (database independent)

Step 3 and 4 are to extract the kernel

5. stop SAP console

6. stop SAP service

7. stop SAPoscol service

8. remove the SAPEXEDB___.SAR and SAPEXE__.SAR from the new kernel folder

9. copy everything from the new kernel folder to E:usrsap<SID>DVEBMGS00exe

10. copy everything from the new kernel folder to E:usrsapE05SYSexeucIA64

11. start SAPOSCOL and SAP SERvice

12. start SAP console

Note, Don't forget the backup before upgrade.


SAP server hung by "ERROR => New Process with the same PID".

I noticed the server was hung by unkown reason on 08:40AM today morning, so I decided to restart sap to solve this case ASAP. After that, I looked back the database log, system log and the other related files to find what happen, and found the clew in the dispatcher's trace files, "ERROR => New Process with the same PID". This error happened on almost dispatchers, so there was no dispatcher to handle user's session, then we got the server was hung at that time.

I Thu Jun 05 08:56:01 2008
I *** ERROR => New Process with the same PID (2732, Aktion: 1
[semnt.c 1920]
I *** ERROR => New Process with the same PID (7076, Aktion: 1
[semnt.c 1920]
I *** ERROR => New Process with the same PID (6056, Aktion: 1
[semnt.c 1920]
I *** ERROR => New Process with the same PID (7076, Aktion: 1
[semnt.c 1920]
I *** ERROR => New Process with the same PID (4112, Aktion: 1
[semnt.c 1920]
I
I Thu Jun 05 08:56:02 2008
I *** ERROR => New Process with the same PID (948, Aktion: 1
[semnt.c 1920]
I *** ERROR => New Process with the same PID (3900, Aktion: 1
[semnt.c 1920]
I *** ERROR => New Process with the same PID (6032, Aktion: 1
[semnt.c 1920]
I *** ERROR => New Process with the same PID (3900, Aktion: 1
[semnt.c 1920]
I *** ERROR => New Process with the same PID (3900, Aktion: 1
[semnt.c 1920]

I checked SAP's note with the key word, and found a note named "Note 920530 - Error Message in Trace: New Process with the same PID ", this note is valid since 07.08.2007, and maybe we should consider to apply the last kernel patch on the server.


Error 1053: The service did not respond to the start or control request in timely fashion

BW测试机在更新Symantec后重启,发现SAP<SID>_00和SAP<SID>_01出错不能启动,

Error 1053: The service did not respond to the start or control request in timely fashion

尝试手动在command命令行里启动相应的sapstartsrv.exe文件,报错Couldn't found mfc71u.dll,对这个文件有点眼熟,在SAP/note查找,发现一篇NOTE提到这个文件, Note 684106 - Microsoft runtime DLLs

打上DLL补丁,重启后,问题解决。

但这个CASE知其然,不知其所以然,这个DLL本应在安装时自成动打上去的,但为何丢失?查看symantec的LOG也找不到相应的DLL被删的记录。

Update on 2008/08/05

今天在一部测试机子装了数个IDES,由于有一个版本问题没装上,后来发现SAPOSCOL服务不能正常启动了,报错:

Error 1053: The service did not respond to the start or control request in timely fashion

初以为按以前的方面可解决,但不奏效。

尝试手动时,发现服务的命令行居然是:

G:usrsapC11sysexerunSAPSTARTSRV.EXE pf=G:usrsapC11sysprofileSAPOSCOL.EXE service

直接在注册表中regedit中改成:

G:usrsapC11sysexerunSAPOSCOL.EXE service

即可。

其实解决此类错误,手动运行,得知其出错原因就是踏上通往成功的大道。


星期四, 五月 29, 2008

TMS request queue restore

公司SAP架构以前是二层,DEV->PRD;现在增加了QAS,但有一个小小的困扰就是request queue在QAS和PRD之间是不一样的,QAS只保存了只建立后的request import list,实质上QAS是PRD的system copy版,所以有必要在QAS恢复完整的request import list,有利于版本比较。

实质上,request import list就是OS上的一个<SID>文件,保存在usrsapmnttransbuffer。

将PRD的request list文件拷贝过来QAS,即可。在QAS系统上STMS刷新QUEUE就会发现所有已导入的request都已列表出来了。

BTW,有朋友倾向于为美观计定期清除request queue,说是一打开就是成千request,SAP默认是按号码大小顺序排序,找最新的request要按PAGEDOWN都要好久,或者按反序排序,但无论如何,OS备份还是要做的!

备份,有备无患!


星期一, 五月 26, 2008

Finding SAP table names and descriptions

To get a list of SAP table names and descriptions, browse table DD02T in SE16 or run the following SQL in sqlplus:

Code

Select tabname, ddtext from sapr3.dd02t where ddlanguage = 'E'

SAPGUI for Java Connect setting

conn=/H/(hostname)/S/32(S.No.)

星期三, 五月 21, 2008

Daily Cleaning background Jobs

Login Client: 000

Login ID: DDIC

if you have a SAP release 4.7 or higher then use transaction sm36 ->

standard jobs button -> default scheduling.
This will create all the needed housekeeping jobs you need.


Or, with transaction ssaa, Overall vien, Execute,

Installation Follow-Up Work, Basis Settings, Scheduling Necessary Background Jobs

Most consultants just schedule the STANDARD jobs with SM37 (or SSAA), without checking any related SAPnotes.

See below latest overview.

Best regards,
Stefan

### R/3 JOB OVERVIEW

Job name : SAP_REORG_JOBS
Program : RSBTCDEL2
Variant : Yes
Parameters variant : 7 days (good value, but check in company)
Frequency : Daily
Description : Delete batch job logs
WARNING: Do not schedule job with program RSBTCDEL; much more jobs are deleted; see note 837691.

Job name : SAP_REORG_SPOOL
Program : RSPO1041
Variant : Yes
Parameters variant : 7 days (good value, but check in company)
Frequency : Daily
Description : Delete old spool requests.

Job name : SAP_SPOOL_CONSISTENCY_CHECK
Program : RSPO1043
Variant : Yes
Parameters variant : 7 days (good value, but check in company)
Frequency : Daily
Description : Spool data (TemSe) consistency check.
NOTE: Job must be scheduled an hour after SAP_REORG_SPOOL.

Job name : SAP_REORG_BATCHINPUT_<CLIENT>
Program : RSBDCREO
Variant : Yes
Parameters variant : 5 days (good value, but check in company)
Frequency : Daily
Description : Delete successfully processed BIM sessions and their logs from the TEMSE table.
WARNING: Job must be scheduled when no other jobs are running.
NOTE: Job must be scheduled for all customer clients (meaning each individual client).

Job name : SAP_REORG_ABAPDUMPS
Program : RSSNAPDL
Variant : Yes
Parameters variant : 30000 / 500
Frequency : Daily
Description : Delete short dumps from SNAP table.

Job name : SAP_REORG_JOBSTATISTIC
Program : RSBPSTDE
Variant : Yes
Parameters variant : 30 days
Frequency : Monthly
Description : Delete runtime statistics.

Job name : SAP_COLLECTOR_FOR JOBSTATISTIC
Program : RSBPCOLL
Variant : No
Parameters variant :
Frequency : Daily
Description : CCMS: Collector for Background Job Run-time Statistics

Job name : SAP_REORG_PRIPARAMS
Program : RSBTCPRIDEL
Variant : No
Parameters variant :
Frequency : Monthly
Description : Reorganization of Print Parameters for Background Jobs (see note 307970).

Job name : SAP_REORG_XMILOG
Program : RSXMILOGREORG
Variant : Yes
Parameters variant : 7 days
Frequency : Weekly
Description : Reorganization of XMI interface loggings.

Job name : SAP_CCMS_MONI_BATCH_DP
Program : RSAL_BATCH_TOOL_DISPATCHING
Variant : No
Parameters variant :
Frequency : Hourly
Description : Starts CCMS Method Dispatching in the background.

Job name : SAP_UPDATE_RECORDS
Program : RSM13002
Variant :
Parameters variant :
Frequency :
Description :
WARNING: Do not schedule this job !!!
Following parameter is set: rdisp/vb_delete_after_execution=1

Or Notes 16083


星期二, 五月 20, 2008

Generate SolutionManager key report

*&---------------------------------------------------------------------*
*& Report ZSLMKEY
*&
*&---------------------------------------------------------------------*
*&
*&
*&---------------------------------------------------------------------*

REPORT ZSLMKEY.

types: begin of dswpclientkey,
INSTNO type num10,
DBID(3),
BUNDLE_ID(8),
SERVICE_KEY(40),
end of dswpclientkey.
*data: dswpclientkey_w type standard table of dswpclientkey.
DATA: P_VALUE(10),
P_INSTNO(10).

PARAMETERS: P_SID(3),
P_SYSNO(2),
P_SERVER(15).

START-OF-SELECTION.
PERFORM GET_SP_VALUE USING P_SID
P_SYSNO
P_SERVER
P_INSTNO
CHANGING P_VALUE.

END-OF-SELECTION.
WRITE P_VALUE.
*&---------------------------------------------------------------------*
*& Form get_sp_value
*&---------------------------------------------------------------------*
* text
*----------------------------------------------------------------------*
* -->P_PF_SID text
* -->P_PF_SYSNO text
* -->P_PF_SERVER text
* <--P_PF_VALUE text
*----------------------------------------------------------------------*
FORM get_sp_value USING P_PF_SID
P_PF_SYSNO
P_PF_SERVER
P_PF_INSTNO
CHANGING P_PF_VALUE.

CONSTANTS: lc_part_len TYPE i VALUE 5,
lc_pw_len TYPE i VALUE 10,
lc_allowed_chars(38) TYPE c VALUE
'-0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ_'.

data: lf_string(20) type c,
lf_key type i,
ls_key type dswpclientkey,
lf_part(lc_part_len) type c,
lf_finalf(lc_pw_len) type c,
lf_finalx type xstring,
lf_xbuffer type xstring,
lf_opf(10) type c,
lf_langu like sy-langu,
lf_subrc like sy-subrc,
lf_len type i,
lo_conv_to_x TYPE REF TO cl_abap_conv_out_ce.

clear: lf_string, lf_finalx, lf_opf.

concatenate p_pf_sid p_pf_sysno p_pf_server into lf_string.

* Large letters only
translate lf_string to upper case.

lf_langu = sy-langu.
SET LOCALE LANGUAGE 'E'.
lo_conv_to_x = cl_abap_conv_out_ce=>create( encoding = '1100' ).
lf_len = STRLEN( lf_string ).

IF lf_string(lf_len) CN lc_allowed_chars.
else.

* Fold the input string to a lc_part_len long string
WHILE lf_len > 0.
lf_part = lf_string(lc_part_len).
SHIFT lf_string BY lc_part_len PLACES.
lf_len = STRLEN( lf_string ).
CALL METHOD lo_conv_to_x->reset.
CALL METHOD lo_conv_to_x->write( data = lf_part n = -1 ).
lf_xbuffer = lo_conv_to_x->get_buffer( ).
lf_finalx = lf_finalx BIT-XOR lf_xbuffer.
ENDWHILE.

lf_key = 12.

PERFORM scramble USING lf_finalx
lf_key
lc_part_len
CHANGING lf_finalf
lf_subrc.

if not lf_finalf is initial.
p_pf_value = lf_finalf.
ls_key-dbid = p_pf_sid.
ls_key-instno = p_pf_instno.
ls_key-bundle_id = 'SM_KEY'.
ls_key-service_key = lf_finalf.
if not p_pf_instno is initial.
* insert dswpclientkey_w from ls_key.
if sy-subrc <> 0.
* update dswpclientkey_w from ls_key.
endif.
endif.
else.
clear p_pf_value.
endif.
endif.
ENDFORM. " get_sp_value
*&---------------------------------------------------------------------*
*& Form scramble
*&---------------------------------------------------------------------*
* text
*----------------------------------------------------------------------*
* -->P_LF_FINALX text
* -->P_LF_KEY text
* -->P_LC_PART_LEN text
* <--P_LF_finalf text
* <--P_LF_SUBRC text
*----------------------------------------------------------------------*
FORM scramble USING iv_xstring TYPE xstring
iv_key TYPE i
iv_src_len TYPE i
CHANGING lf_finalf
lf_subrc LIKE sy-subrc.

CONSTANTS: lc_max_len TYPE i VALUE 20,
lc_mask(4) TYPE x VALUE '0000003F',
lc_random(64) TYPE x VALUE
'F0ED53B83244F1F876C67959FD4F13A2' &
'C15195EC5483C234774943A27DE26596' &
'5E5398789A17A33CD383A8B829FBDCA5' &
'55D702778413ACDDF9B83116610E6DFA'.

DATA: lv_key_index(4) TYPE x,
lv_rand_index(4) TYPE x,
lv_xkey(4) TYPE x,
lv_xkey_shl_1(4) TYPE x,
lv_xkey_shr_5(4) TYPE x,
lv_scramble_byte TYPE x,
lv_dest(lc_max_len) TYPE x,
lv_index TYPE i,
lv_len TYPE i.

CLEAR lf_subrc.

IF iv_src_len EQ 0. EXIT. ENDIF.
lv_len = XSTRLEN( iv_xstring ).
IF iv_src_len GT lc_max_len OR
iv_src_len GT lv_len.
lf_subrc = 2.
EXIT.
ENDIF.

lv_xkey = iv_key.
lv_xkey_shl_1 = iv_key * 2.
lv_xkey_shr_5 = iv_key DIV 32.
lv_rand_index = lv_xkey BIT-XOR lv_xkey_shr_5 BIT-XOR lv_xkey_shl_1.
lv_rand_index = lv_rand_index BIT-AND lc_mask.

lv_index = 0.
DO iv_src_len TIMES.
CATCH SYSTEM-EXCEPTIONS compute_int_times_overflow = 1.
lv_key_index = ( iv_key * lv_index * lv_index ) - lv_index.
ENDCATCH.
IF sy-subrc <> 0.
lf_subrc = 1.
EXIT.
ENDIF.
lv_scramble_byte = lc_random+lv_rand_index(1) BIT-XOR
lv_key_index+3(1).
lv_dest+lv_index(1) = iv_xstring+lv_index(1) BIT-XOR
lv_scramble_byte.
lv_index = lv_index + 1.
lv_rand_index = lv_rand_index + 1.
lv_rand_index = lv_rand_index BIT-AND lc_mask.
ENDDO.
IF lf_subrc <> 0.
EXIT.
ENDIF.

WRITE lv_dest(iv_src_len) TO lf_finalf.

ENDFORM. " scramble

星期二, 四月 29, 2008

The client is currently locked against logon.

During the remote client copy with profile SAP_USER, just saw the copy files was 90 of 90, so i considered the copy finished and tried to restart the instance caused by profile modified. But When I restarted and tried to logon, the system responding message with "The client is currently locked against logon" .

Logon client 000 with DDIC, run SCC4, the system remind the clinet 004 have lock due to copy failed.

Delete the lock and then logon client 004 and continue the remont client copy, wait the statistics said successful.

 查看全文

星期一, 四月 28, 2008

SAPOSS connection

Tcode: SM59

SAPOSS connecttion failled by conection password wrong.

give user ”OSS_RFC” password CPIC“.

 查看全文

Install SAP patch and support package

SAP EarlyWatch Alert报告出来了,说是要打补丁云云。

Before we can deliver any services, the latest version of the SAP Service tools must be available in your system.
The last run of report RTCCTOOL was 11.04.2008. During the check, the tool detected SAP Notes that were rated RED or YELLOW.

Recommendation:
Run report RTCCTOOL (review SAP Note 69455) and implement the recommendations.

1. [Note 69455 ] Addon ST-A/PI 01K_ECC600
Description "Servicetools for Applications Plug-In" for ERP 2005 / ECC 6.00
Implementation From http://service.sap.com/supporttools download the addon file
ST-A/PI 01K_ECC600. Upload the file to transaction SAINT 'Installation
package > Load packages > From Frontend' and install as per note 69455 .
Then restart report RTCCTOOL and choose 'List->Refresh from SAPNet'.

2. Note 539977
Description Addon supportpackage level 6 for ST-PI 2005_1_700 for 7.00
[patches up to level 6 for Basis tools for services]
Implementation Open http://service.sap.com/supporttools-> ST-PI 2005_1_700 ->Supportpk.
Add patch SAPKITLQI6 (and predecessors if not yet implemented) to
download basket. Release basket via Maintenance optimizer. Upload from
frontend into transaction SPAM, define a queue and import the queue.

第一个patch可以在service.sap.com下载,但第二个supoort pachage就需要Solution manager下载了,只能靠朋友发过来了

要用的Tcode:

SE38-> RTCCTOOL

SAINST

SPAM


星期三, 四月 16, 2008

Migrate SAP to ne disk group

Step Task
1 Move the 10k rpm hard disks
2 Plug the 15k rpm hard disks, then create a new group
3 Create 4 partitions like as Partition sheet with new DG
4 backup database
5 Detach database
6 Uninstall SAP with sapinst
7 Mount new partitions as new drive lettter, then reboot
8 Copy database files
9 Copy the usr and datatmp
10 attach database
11 System copy with sapinst
12 SE06 and STMS setting
13 Shutdown SAP
14 Restart SAP and test
 查看全文

星期二, 四月 08, 2008

Moving the tempdb database(SQL server)

Moving the tempdb database

You can move tempdb files by using the ALTER DATABASE statement.
1.Determine the logical file names for the tempdb database by using sp_helpfile as follows:
use tempdb
go
sp_helpfile
go
The logical name for each file is contained in the name column. This example uses the default file names of tempdev and templog.
2.Use the ALTER DATABASE statement, specifying the logical file name as follows:
use master
go
Alter database tempdb modify file (name = tempdev, filename = 'E:Sqldatatempdb.mdf')
go
Alter database tempdb modify file (name = templog, filename = 'E:Sqldatatemplog.ldf')
go
You should receive the following messages that confirm the change:
Message 1
File 'tempdev' modified in sysaltfiles. Delete old file after restarting SQL Server.
Message 2
File 'templog' modified in sysaltfiles. Delete old file after restarting SQL Server.
3.Using sp_helpfile in tempdb will not confirm these changes until you restart SQL Server.
4.Stop and then restart SQL Server.
 查看全文

星期一, 四月 07, 2008

Why the SAP* password is not PASS?

please check if the SAP parameter "login/no_automatic_user_sapstar"is set to 0

Parameter : login/no_automatic_user_sapstar



Short description: Control of the automatic login user SAP*



Parameter description :

If the user master record belonging to user SAP* is deleted,
it is possible to re-log on with SAP* and initial password PASS.
SAP* then has the following attributes:

- The user has all authorization, as authorization checks
cannot be executed.

- You cannot change the standard password PASS.

Using profile parameter login/no_automatic_user_sapstar,
you can deactivate the special attributes of SAP*.



Work area: Logon

Unit :



Default value: 1



Who is permitted to make changes: The customer



Limitations for operating systems: None



Limitations for database systems: None



Other Parameters Affected or Dependent:

The profile parameter login/no_automatic_user_sap* supported in
SAP Releases 3.0 and 3.1 no longer have any effect.

is still only supported in Release 3.1.

Valid entries, formats, areas : 0, 1

0: Automatic user SAP* is permitted
1: Automatic user SAP* is deactivated


1: Automatic user SAP* is deactivated



星期四, 四月 03, 2008

Who is the Last Change?

事情的由来,是同事要将传输Z*表,自然要将local object改成transport package,但在SE80中自己名下死活找不到这张表,但在SE11中Attributes中的Last changed on/by的确是同事的名字...


后来发现,在SE11的Technical Setting中Last Change另有其人...看来这里其实指的是Owener。


Copy client schedule

Step Task
1 Test delete client
1.1 log into the client to delete
1.2 go to SCC5 and delete client with test mode option
1.3 estimate the run time
2 Detele client
2.1 log into the client to delete
2.2 go into SCC5 and delete client
2.3 log into another client and delete entry with SCC4
2.4 reorg database to recover database space.
3 Test copy client
3.1 create a new client for copy target with SCC4
3.2 log into the newly created client with sap*/pass
3.3 Copy client with SCCL/SCC9 with test option and SAP_ALL profile
4 Copy client
4.1 log into the newly created client with sap*/pass
4.2 Copy client with SCCL/SCC9 with profile SAP_ALL
 查看全文

You want to use parallel processes for a client copy.

Summary

Symptom

You want to use parallel processes for a client copy.

Other terms SCCL, SCC5, SCC9

Reason and Prerequisites
    1. How do I use parallel processes?
    2. How many parallel processes should I use?
    3. Several clients must be copied into a system.Is it possible to run two copies in parallel?How do I get the shortest runtimes?
    4. Why are no parallel processes used or why are less parallel processes used than required?
    5. How can I terminate a copy with parallel processes?
    6. Why are some processes in the process overview (transaction SM50) or in the Systemwide Work Process Overview (transaction SM66) not active or not displayed?
    7. How many processes are used on the servers and which process has copied which table?
    8. The copy was scheduled in the background.Why does the client copy use dialog processes?
    9. The copy was scheduled on a specific server.Why are also processes active on other servers?
    10. Why does a change of the RFC server group not affect a current copy?
    11. Which data throughput can I can expect?
    12. Do the settings for the parallel processes of the client copy also apply to the client transport?
Solution
    1. You can select an existing RFC server group and the maximum number of processes (not counting the main process) via the "Parameter for parallel processes" button or the "Go to -> Parallel processes" menu option.

From there, you can also go to the RFC server group maintenance (transaction:Create an entry with the same name for each application server to be used.For more information, refer to the documentation (SAP Library) of the SAP Web Application Server under:

Computing Center Management System (BC-CCM) -> Background processing -> Parallel processing of jobs with asynchronous RFC -> Define RFC groups for parallel processing jobs

    2. Two processes per available database CPU is a good guide value.

For a remote copy, we even recommend that you use three processes per target database CPU.Parallel processes are especially useful with remote copies as you can use more different resources (source/target database, source/target application server and network) simultaneously.This applies in particular if a conversion is required due to different character sets (code pages) or system formats (Little or Big Endian) where CPU consumption on the application server increases considerably.

    3. You cannot use two copies from the same source client simultaneously. This may cause problems in the address management.

You can use two copies from different source clients simultaneously. However, we do not recommend this as the processes may lock each other.

Instead of executing several copies simultaneously, you should preferably schedule the copies one after the other and use parallel processes.

To avoid disorganization in the database, you should, if necessary, delete all target clients in advance.You should then reorganize the database and update the statistics.The clients are then structured with ascending client number.

We recommend that you proceed, for example, as follows:

1. Schedule the first copy in the clients with the smallest client number with a start of 10 minutes.

2. Determine the name of the background job via the SM37 transaction.

3. Schedule the second copy as successor of the first job and so on.

    4. There are several possible causes:
  • Parallel processes are only used during the actual copying phase.They are not used, however, during the analysis and postprocessing phases.
  • The resource management only assigns a limited number of processes to the client copy.For more information, refer to the documentation (SAP Library) of the SAP Web Application Server in the "Automatic protection against capacity overload of resources" section of the following document:

Computing Center Management System (BC-CCM) -> Background processing -> Parallel processing of jobs with asynchronous RFC

  • Towards the end of the copying phase, the number the processes is reduced as the worklist is divided but individual processes are still copying very large tables.

To avoid this scenario, a "SINGLECOPY" copy function was introduced as of WAS 6.10. Refer to note 446485 for more information.

    5. The processes monitor each other and restart terminated processes. You can, therefore, not simply terminate the client copy by terminating the processes. You must inform the client copy in advance that you want to terminate the copy.

To terminate the copy, use the 'Cancel copy' button in the SCC3 transaction of the system log display.The processes auto-terminate once they have finished the current task or the copying of the current table.After issuing the Cancel command via the log display, you can also terminate the processes manually (for example, via the process overview (transaction:

    6. The relevant processes try to set a lock entry for a common resource (for example, for the log header in the CCCFLOW table or for the "CCLOG" file log).

If the first attempt fails because the resource is already used by another process, the system will repeat the action in intervals of one second until the relevant resource is released.While the system is waiting for the resources, the processes are not displayed.You can display the relevant lock entries via the lock management (transaction:

    7. you can display it, for example, with the SE16 transaction. The PROCESS field contains the application server and the number of the process. The same information is also displayed in the file log of the copy at the beginning of the copying phase.

The information which table was copied by which process (STATUS = 'P') or which tables are contained in the worklist of the process (STATUS = 'A') is listed in the CCSELTAB table.

To monitor all current actions, you should preferably use the global work process overview (transaction:

    8. Only the main process of the client copy can use a background process.The parallel processes are controlled via a RFC server group.RFC processes, however, are always dialog processes.
    9. The servers specified in the RFC server group are only used for the additional parallel processes.They are not affected by the scheduling of the main process on a specific server.
    10. The RFC server group is only analyzed once at the beginning of the copying phase.Changes, therefore, are only activated in a new copy or after a RESTART. You must, therefore, terminate the current copy after step 5 and execute a RESTART if you want to change the distribution of the processes.
    11. If the target client is empty and the source database in good shape (updated statistics, little disorganization), you can expect a throughput of approximately 500MB to 1GB per hour and process on a modern database.That is, approximately 4GB to 8GB with 4 CPUs and 8 processes.
    12. No. The client export (transaction:SCC8) only creates a transport request which then is exported by the tools of the tp/R3trans transport programs.The settings for the parallel processes of the client copy do not affect this process nor the postprocessing in the target client (transaction:

Header Data

Release Status:Released for Customer
Released on:18.12.2002 14:39:11
Priority:Recommendations/additional info
Category:Consulting
Primary Component:BC-CTS-CCO Client Copy

Affected Releases

Software
Component
Release
From
Release
To
Release
And
subsequent
SAP_BASIS
60
610
640
X

星期二, 三月 18, 2008

SAPOSCOL not running (Shared memory not available)

Run ST06,

SAPOSCOL not running (Shared memory not available)

Check what happen, because during I uninstall the other instance D01, but the SAPOSCOL service was deleted unguarded. So try to reinstall the service.

The “ntscmgr.exe” program located in the Exe -> Run directory can be used to reinstall the SAPOSCOL as a service.

Execute the following command:

ntscmgr.exe install SAPOsCol -b saposcol.exe –p


It is OK now.


星期四, 三月 06, 2008

The SQL Server (MSSQLSERVER) service terminated with service-specific error 1814 (0x716).

卸载SAP时将TEMPDB文件夹也给删除了,结果SQL server service启动失败,报错The SQL Server (MSSQLSERVER) service terminated with service-specific error 1814 (0x716).

SQL server每资重启都会重建TEMPDB,所以只要在原来的路径上重建TEMPDB文件夹即可。


星期一, 三月 03, 2008

修改SAP登录界面

T-code: se61,
data_element: ZLOGIN_SCREEN_INFO
document class: General Text
then choose "create", you can input whatever you want. 查看全文

星期四, 二月 28, 2008

Hotfix for IA64

性能方面的原因,要在RX3600/6600上打IA64 hotfix, 但是这两个hotfix是还没公开发行的版本,所以用了点笨方法来打;

1,系统config还是要保存的,用的是HP的DP,虽然这样就可以打hotfix了,但万一失败的话,还要重新安装系统和SAP,再加上恢复系统config才恢复到原来镜像,所以只能用下面的笨方法;

2,因为Windows 2003是装在RAID1的阵列中,打hotfix之前,将其中一个硬盘拔了出来,打完hotfix并测试没问题后,再插回去同步;这里原想着要是失败了,就用拔出来的硬盘启动也可以,结果用不着,一次成功!


下面还有两台服务器6600,先测试一周再进行

 查看全文

星期六, 二月 23, 2008

农村包围城市?

2008年2月19日,微软公司宣布将向全球大学 生免费赠送SQL Server 2005,Visual Studio 2005 and 2008, Windows Server Standard Edition, XNA Game Studio 2.0及其Expression的套装产品,此次赠送还将惠及到高中生 。

我有点好奇,DBA,尤其是中国的DBA,是在什么时候接触到数据库的?大学里学本数据库原理的哪种不算啊

象我就是半路出家,先做SA,再做DBA,在学校别说数据库,连电脑都。。。这说的有点过了,当年游戏还是玩过滴,五笔诗还是背过滴

但要说Microsoft这样做能在数据库市场上起到攻城略地,我有点怀疑,SQL server落后Oracle不是一两点啊,何况还有MySQL,DB2。。。这里特别是大一点点数据库,这一招不会是MySQL被收购的反应措施吧?Sun向来是免费惯了的

 查看全文

星期二, 二月 19, 2008

HP command view login "Insufficient privileges" problem

HP command view only login sucessfully on one manage server, the "Insufficient privileges" happened on the second server. 查看全文

星期一, 二月 18, 2008

数据库虚拟化——这样做值吗?

今天在INFOQ上看到一篇<<数据库虚拟化——这样做值吗?>>(英文版),想起二年前做过的类似测试...

当时公司被美国大头收购,总部测试Lab连接美国的服务器正是用一台IBM服务器虚拟了FS,DNS,DHCP,IA数台,整个IT部门兴起了虚拟化的测试浪潮,美国也派人过来详加介绍美国本土是如何在每个节点用两台IBM服务器(鬼佬真是有钱,在国内我们都是买DELL)建起cluster架构,测试到数据库时,卡壳了!买了台DELL PE6800来测试,当时SAP还没升级,ORACLE7.3.4+WINNT4+SAP31H,ESX对NT4的支持差的要命,磁带机认不到,每台服务器只能用一个CPU,问题一堆堆

后来SAP升级选型,顾问过来摸底,来前说也有些公司实施过数据库虚拟化,来后发现我们的数据库如此之大,足足600GB,强烈建议用实体机,现在用了两台HP RIX6600做cluster,何故?还是性能问题。

结论,哪是一篇好文章,值得参考。

 查看全文

ICNV- Append old change log into LXP database(PRD)

1, Backup LXP;
2, ICNV;
3, During the append period, consultant found the G drive had no free space for log file to extend, because bulk insert data would cause the log file size increase quickly, you can see the log file size was 197GB on 2008/02/16, so I decided to add more space(100GB) from SAN to keep the append procedure to finished after discuss with consultant. That means the server use the SAN sapce is 1.4TB now, we should consider this status highly if we want to do some action on SAN environment on future like as snapclone, VOL extend, SAN schema change, etc.
4, The change document records have been transferred to the production system on 0:20AM 17-Feb-08;
5, Backup LXP,
6, Shrink log file.

BTW, User complained SAP can not save and update, lick QT update and Material create during the icnv period. That's OK.

User complained SAP can not save and update, lick QT update and Material create.

Where is Telnet in Vista/Longhorn beta builds?

Where is Telnet in Vista/Longhorn beta builds?

Telnet is now made an optional component in Vista and Longhorn Servers. This means if you type telnet in command shell, you will be out of luck.

Why have we done it so?

As time has passed, fewer users use telnet. Thus, to decrease the foot print as well as the attack surface, we decided to make it an optional component.

Great, now how do I get telnet client/server working again?

Vista -

Use software explorer or Click Start, Control Panel, Programs, and then Turn Windows Features on or off. In the list, scroll down and select Telnet Client. Click OK to start the installation.


星期一, 一月 07, 2008

How to change the password for win2003 via remote desktop

Start

Setting

windows security


星期六, 一月 05, 2008

Maximum No. Of SAP Session Per User

Maximum No. Of SAP Session Per User

September 11th, 2005

You set this Parameter : rdisp/max_alt_modes in transaction RZ10.

Add in the above parameter in the Instance Profile – Options Extended Maintenance.

Restart the R/3 instance.

The default maximum no. of sessions in 4.6x is set as 6 session per user.

Most company will reduced the number of session per user but not increase it.


星期五, 十二月 28, 2007

安装服务器准备SAP升级的小问之IE6安装

因为要AntiVirus需要IE6的环境,而在安装IE 6时,出现下面的错误提示:
“以前的安装有尚未完成的操作,需要重新启动。建议在运行 Internet Explorer 安装程序之前重新启动计算机。现在安装程序将关闭。”
重启计算机后,还是出现的问题。

解决方法:
运行ie6setup.exe /q

星期三, 十二月 26, 2007

SAP Uninstall 之误删测试数据库

事情的起由,是昨晚要删掉另一台测试服务器上的SAP数据库,然后删除所占的SAN空间,腾出空间来给生产库迁移至SAN环境。

假设有A、B服务器,A机有a数据库,B机有b数据库,而b数据库是由a数据库的盘直接snapclone出来的,包含了数据库文件和SAP配置文件!!!帮凶啊!而B机上的SAP是用System copy方法做出来的,usr里面包含了a和b的配置文件,我这里就是LXD和LXT,一字之差啊!

现在要删掉B机上的b数据库。

出错过程:要知道SAP Uninstall是根据profiles来确认要删除SAP和数据库的机器和位置,事后检讨,当时应该是一不小心,点了B机上a数数据库配置文件。

结果,删LXT变成LXD严重啊,LXD正在恢复中...

Update,1.1TB size 的LXD数据库用了将近16个小时才恢复到前一小时的镜像,但不能startup disk+work.exe,还得用system copy的方法,才恢复正常。


经验教训:

1,用system copy的方法装SAP,尤其是用snap clone来做的盘,记得将原SAP的配置文件删除掉;断绝错误之源;

2,SAP Uninstall时,最好是不选择drop database,事后手动在SQL EM下手动drop;就算点错了profiles,数据库文件还在,system copy就回来了

3, 安装SAP,最好采用不同的SID,如果使用相当的SID安装SAP,则采用Localhost的安装方式;其实最好全部用Localhost的安装;


星期二, 十二月 25, 2007

PDB文件的用途

在SAP FTP上下载GUI710的PATCH,发现有一个PDB的文件,查了一下用途:

The SAP Service Marketplace contains, in addition to the actual Support Package file for the SAP GUI (for example, GUI610.EXE), another file with a "pdb" extension (for example, 610_PDB.EXE).
The PDB file is ONLY required when requested by SAP Support (it contains important debugging information for SAP GUI "crashes"). The OSS message issued with each problem contains more information on how to handle the PDB file.



执行程序为什么老是显示Compiling...

经理问,为什么开发的同事反映执行报表时老是显示Comiling...

开发同事仔细检查,发现许多程序执行时都显示Comiling...

问题找到我Basis这边,原因是这是一个刚升级的系统,还没有transport all the requests,所以没有执行SGEN而已

至于SGEN是做什么的?因为SAP启动后,系统会将没有用过的程序和对象都做compile,这是正常的ABAP系统的行为,而SGEN可以强行generate ABAP程序,详细看下面的帮助,当然我们可以先做一次SGEN,到所有的程序都传输过来了,再做一次

 查看全文

恢复数据库

今天尝试恢复一个大小为650GB的SQL 7数据库,到一台DELL PE6400的服务器上,恢复速度慢的令我不敢相信,到现在花了22小时才完成了589GB;


因为上一个星期同样的恢复到台HP DL380上,才用了8小时,不过哪次用硬盘是在SAN上面,而且是Gigabytes的网速,而今天用的PE6400的网卡是100MB的,本机上的RAID的;

一句话,没有可比性!列出来只是好奇的心理,似乎网速是瓶颈?

Update: 2007/12/26 17:19 恢复完成

651733 MB 1422 min (27512 Mb/h)


今晚加通宵,SAP迁移到SAN环境

各位SAP系统用户,SAP系统将于2007-12-26 0:00AM2007-12-26 10:00AM期间进行迁移项目,届时IT部将会对此作出特别安排;

1. SAP生产系统将会在2007-12-26 0:00AM2007-12-26 08:00AM停止服务用于迁移项目;

220007-12-25 23:00PMMPS后台作业将会取消,IT将会提前安排在2007-12-25 18:00运行MPS请销售部门的同事注意,2007-12-25的截单时间是18:00PM !!!