SAPBC.RU - Troubleshooting SAP Sofware Problems And Errors

FTP Script For Upload SAP Transport Request

If the transport landscape, each system uses its own transport directory, it may be necessary to transfer files of transport requests between servers. In case Unix simple solution is FTP Script For Upload SAP Transport Request #!/bin/bash HOST=hostname #This is the FTP servers host or IP address. USER=username PASS=password ftp -inv $HOST <<EOF user $USER $PASS bin cd /usr/sap/trans/cofiles/ lcd /usr/sap/trans/cofiles/ get KXXXXXX.YYY cd /usr/sap/trans/data/ lcd /usr/sap/trans/data/ mget *XXXXXX.YYY quit EOF Where YYYKXXXXXX – name of transport request KXXXXXX.YYY – cofile of transport request RXXXXXX.YYY and DXXXXXX.YYY – data files of transport request

Posted in UNIX | Tagged | No Comments

Пошаговая инструкция по созданию SAP MDM System в контенте SAP Enterprise Portal и настройки соответствия учетных записей пользователей SAP EP и SAP MDM

Определение системы (MDM) На верхнем уровне навигации перейдите на закладку Системное администрирование › Конфигурация системы › Системная среда. В дереве под закладкой Просмотр, щелкните правой кнопкой мыши на папку, в которой будет сохранена запись о создаваемой системе и выберите  Новое › Система (из образца). В правом окне появится окно выбора образца. Выберите MDM-система. Нажмите кнопку Дальше В поля Имя системы и Идентиф. Системы введите значение одинаковые англоязычные значения. В нашем случае это mdmd-01. Нажмите кнопку Дальше. В поле MDM-сервер ввести имя сервера. В нашем случае mdm-server-01. Нажмите кнопку Дальше. Выберите репозитарий MDM из списка. Нажмите кнопку Дальше. Выберите язык Russian(RU) … Continue Reading

Posted in SAP EP, SAP MDM | Tagged | No Comments

Registering JAVA system in CEN rz21 error

Symptom When We register java system to monitoring from RZ21 Choose Technical Infrastructure → Configure Central System → Create Remote Monitoring Entry we must define HTTP Port of the Message Server. When We try set HTTP Port of the Message Server 50000, or 3901, We have error No valid XML document received. ( http://hostname:50000/msgserver/xml/logon ) Solution Set HTTP Port of the Message Server to 81XX  

Posted in SAP Basis, SAP Solution Manager | Tagged | No Comments

Таблицы с информацией о ролях в системах SAP

Таблицы с информацией о ролях в системах SAP. Крайне полезная штука. AGR_DEFINE – имя роли и присвоение функциональной роли типовой AGR_PROF – профили полномочий для ролей и их имена AGR_TCODES – транзакции включенные в роли AGR_1251 – объекты и значения полномочий к роли AGR_1252 – значения организационных уровней в функциональных ролях

Posted in SAP Basis | Tagged , | No Comments

Oracle dictionary statistics and system statistics | Create new statistics for all tables without a necessity check

We have Note 838725 – Oracle dictionary statistics and system statistics Creating Oracle dictionary statistics using BRCONNECT BRCONNECT command to create Oracle dictionary statistics: OS> brconnect -u / -c -f stats -t oradict_stats Creating Oracle system statistics using BRCONNECT Creating Oracle system statistics (NOWORKLOAD) using brconnect $ brconnect -u / -c -f stats -t system_stats Create new statistics for all tables without a necessity check brconnect -u / -c -f stats -t all -f collect

Posted in SAP Basis | Tagged , | No Comments

Saposcol: data collection not up to date

Symptom We have an alert from our solution manager regarding the os collector where the Alert text shows the above message “Saposcol: data collection not up to date” Solution On AIX, this usually means the saposcol program has crashed, but the shared memory has not been released. Most of the time this can be corrected by running saposcol -f (force option). Another way to release shared memory I describe in post Problem with stop/start saposcol

Posted in SAP Basis | Tagged | No Comments

Error: Remote access to the NetWeaver Administrator is forbidden. See SAP Note 1451753 for details.

Symptom We have error Remote access to the NetWeaver Administrator is forbidden. See SAP Note 1451753 for details. Solution The URLs for NWA have a unique prefix and can be filtered out in the ICM on a rule basis. In the profile file (we recommend the default profile DEFAULT.PFL), configure the following modification handler: icm/HTTP/mod_0 = PREFIX=/,FILE=$(DIR_GLOBAL)/security/data/icm_filter_rules.txt If you do not want to restrict access to the administration requests to certain clients, remove the lines from the file or turn the lines into a comment: #if %{REMOTE_ADDR} !stricmp 127.0.0.1 [AND] #if %{REMOTE_ADDR} !stricmp ::1 #RegIRedirectUrl ^/webdynpro/resources/sap. com/tc~lm~itsam~ui~mainframe~wd/(.)*$ /nwa/remote_access_error [QSA] Then restart … Continue Reading

Posted in SAP Basis | Tagged | 4 Comments

Brtools permissions

For set correct permission and owners for brtools execute: chmod 4774 brarchive brbackup brconnect chown <orasid>:sapsys brarchive brbackup brconnect Note 113747 – Owners and authorizations for BR*Tools Solution The following settings are required to call the BR*Tools correctly, especially when using transaction DB13 or DBACOCKPIT: (1) ora<sid> and <sid>adm on DB server have a search path on /sapmnt/<SID>/exe. (All br* are contained in this directory.) ora<sid> belongs to the dba group, <sid>adm belongs to the sapsys group, (2) <sid>adm on the database server has the rhosts entry: “+ <sid>adm”. (3) The ops$<sid>adm Oracle user must be created in the DB and must … Continue Reading

Posted in SAP Basis | Tagged | 2 Comments

Example ALTER DATABASE DATAFILE AUTOEXTEND ON MAXSIZE UNLIMITED

ALTER DATABASE DATAFILE ‘/oracle/SID/sapdata4/sr3731_4/sr3731.data4’ AUTOEXTEND ON MAXSIZE UNLIMITED;

Posted in SAP Basis | Tagged | No Comments

How to delete entires from TPSTAT table

Symptom You want delete inconsistent entires  from TPSTAT table (for example in case error message “Import for system SID target client already running”), Solution 1. Go to transaction stms. 2. Then push on truck icon->go into system queue 3. Menu GoTo->Import Monitor 4. Click on  inconsistent entire right mouse button, in context menu select delete entry.

Posted in SAP Basis | Tagged | No Comments