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之
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 exam
To update the SAP kernel
1. create a folder to store the kernel SAR file2. 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&
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,说
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:CodeSelect tabname, ddtext from sapr3.dd02t where ddlanguage = 'E'[@more@]
SAPGUI for Java Connect setting
conn=/H/(hostname)/S/32(S.No.)[@more@]
Daily Cleaning background Jobs
Login Client: 000Login ID: DDICif 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 JobsMost consultants just schedule the STANDARD jobs with SM37 (or SSAA), without checking any related SAPnotes. See below latest overview. Best regards, S
Generate SolutionManager key report
SPAN { font-family: "Courier New"; font-size: 10pt; color: #000000; background: #FFFFFF; } .L1S31 { font-style: italic; color: #808080; } .L1S32 { color: #3399FF; } .L1S33 { color: #4DA619; } .L1S52 { color: #0000FF; } *&---------------------------------------------------------------------* *& Report ZSLMKEY *& *&---------------------------------------------------------------------* *& *& *&------------------------------------------------
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,
SAPOSS connection
Tcode: SM59SAPOSS connecttion failled by conection password wrong.give user ”OSS_RFC” password “CPIC“.[@more@]SAP
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
Moving the tempdb database(SQL server)
Moving the tempdb database loadTOCNode(2, 'moreinformation'); 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 tempdbgosp_helpfilego 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 mastergoAlter database tempd
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 pa
Who is the Last Change?
事情的由来,是同事要将传输Z*表,自然要将local object改成transport package,但在SE80中自己名下死活找不到这张表,但在SE11中Attributes中的Last changed on/by的确是同事的名字...后来发现,在SE11的Technical Setting中Last Change另有其人...看来这里其实指的是Owener。[@more@]
You want to use parallel processes for a client copy.
SummarySymptom 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
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 –pIt is OK now.[@more@]
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文件夹即可。[@more@]
修改SAP登录界面
T-code: se61, data_element: ZLOGIN_SCREEN_INFO document class: General Text then choose "create", you can input whatever you want.[@more@]SummarySymptom You want to display a customer-specific text on the SAPGui logon screen. Other terms SAPMSYST, screen 0020, logon, login, signon, sign on screen, logon screen Reason and Prerequisites Before Release 4.6 the logon screen, program SAPMSYST screen 0020, was modified for this. As of Release 4.6, modification is no long
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, Co
How to change the password for win2003 via remote desktop
StartSettingwindows security[@more@]