Friday, September 16, 2016

No data load into BW system for this metrics since (UTC)

Home


While working on technical monitoring in SOLMAN 7.1 SP 14, i faced multiple issues.

After configuration i am receiving emails in my mailbox but when i open the mail. i got the below error.

No data load into BW system for this metrics since (UTC).

or overcome this issue SAP suggest to import below note & reactivate the manage objects again in technical monitoring.

SAP note – 2288036

Correction has been delivered with SOLMAN 7.1 SP15

To delete already released transport/task

Home


To delete the task from a particular transport. Task is in already released status.

1. Use transaction SE38 or SA38 and run program: RDDIT076
2. Set your request number and run the program
3. After request is shown double click on it
4. You should be able to change status from R to D

once you change the status to “D”, now go to SE01 and find the task. task again change to “Modifiable mode”.

Then delete it.

SAP Sybase ASE Start & Stop Server

Home

While working on Installation of SAP Netweaver 7.40 on SYBASE DB ASE 16 PL5 on Linux OS, i have faced multiple errors. i thought it should be worth sharing to you all.
Mount Point requirement.
/sybase/(SID)
/sybase/(SID)/sapdata_1
/sybase/(SID)/sapdata_2
/sybase/(SID)/saplog_1
Sybase store all the database related binaries on /sybase/(SID) mount point. This mount point should be big enough to handle all the temp DB device, log data, log device, sybtemp, saptemp & other log files. Minimum – 20 GB, during installation it will ask you multiple inputs.
sapdata_1 & sapdata_2 – depends on your DB size. minimum – 150 GB each
saplog_1 – depends on log size. minimum – 100 GB
During installation, i stuck on database configuration & other steps, where i need to stop & start the SYBASE DB, there are 2 ways to perform the same (may be more) as i aware.
1. SYBASE Control Center
2. isql
I was working on isql to start stop my DB. (Please note once SAP installed successfully, “sa” user will lock automatically & only “sapsa” user will login. if you want to use “sa” user you need to unlock the same from isql command.
it’s recommended to start / stop DB from sap command only. (startsap DB / stopsap DB)
But if you have only installed Sybase DB so here is the way to start & stop through isql. here “sa” user will work because we have not installed SAP yet.
Stopping the SYBASE DB in Linux.
isql -Usa -Ppassword -S DBSID
2> shutdown
3> go
the above command will stop the SYBASE server & show the below output. now you cannot login into isql as server is down.
Msg 2812, Level 16, State 5:
Server ‘SID’, Line 1:
Stored procedure ‘help’ not found. Specify owner.objectname or use sp_help to
check whether the object exists (sp_help may produce lots of output).
Server SHUTDOWN by request.
ASE is terminating this process.
CT-LIBRARY error:
ct_results(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect
Starting the SYBASE DB in Linux
for starting you need to go install folder, that install folder is in your SYBASE_HOME. usually at below location.
/sybase/SID/ASE-16_0(Version)/install/RUN_SID
once you trigger the above command, SYBASE DB will start successfully & you can verify the process.
In Windows you can stop/start SYBASE DB by Windows Services.

Spool issues & solutions

Home

Q1) In SP01 what is the difference between print directly & print with changed parameters?

1)     The setting that uses spool with “Print directly to the printer.” You might choose this setting if you have a lot of jobs waiting in the spool and want to print something else in a hurry, and is defined for the user-id
For Print a Spool Request with changing its Parameters.
To change the request before printing it, for example, to send the request to a different printer or change the number of copies to print, choose Print with changed parameters. You can change the following settings before printing:
a) Output Device: If possible, only send the output to an output device that uses the same device type as the output device for which the request was originally created. The device type indicates the printer type used, such as PCL.
b) Start Time: To set a later time for printing, choose this button


Q2) If a spool request is in waiting status for a long time, what does it mean?

2)     Status Waiting may also indicate that there is a problem with the spool work process that is assigned to a printer. Check the following:

a) Find out which printer an output request has been sent to. To do this, select the relevant spool request in the Output Controller and choose. You can find the printer name in the Output device field.

b) Find out which spool work process is responsible for the printer. Enter the name of the printer to which the output request was sent in the Output Device field on the Devices/serverstab and choose enter. Display the definition and note the SAP application server name that appears in the Print server field. If you have only a single spool server in your SAP system, then you can omit this step.

c) Use the CCMS System Monitor or in transaction SM51 to display the application servers in your SAP system. Check that the application server that you noted from the Print server field is running and that the server offers the service Spool. If the server is not running or if the Spool service is not active, then you have found the source of the problem.

d) If the print server is running and the spool service is active, then check the activity in the spool work process.

In transaction SM51, mark the print server in question and click on Processes. In the process display, look for the spool work process and note the name of the active user. If User SAPSYS is active, this indicates that the spool work process is busy with internal spool activities or is requesting the status of a print request from a host spool system. Choose CPU repeatedly to check the CPU time that the spool work process requires. If the same CPU time is always displayed, then it is likely that the spool work process is waiting for a status query to time out. It is likely that you have to then find the reason for the delay in output request processing.



Q3): If a user wants to reprint his document again what should to do ?

3)  The user needs to give the spool request number in sp01 and then print it or Users should have Tx SP02 for their own spool requests (not SP01 which is a BASIS Tx). User can browse & reissue an output request for a particular spool (unless they deleted it, or it time expired and got reorg’d).


Q4): What I have done to use users OS level printer as SAP printer. I mean if a user has given a print if SAP couldn’t able to find printer it will be in error status. In this case I want to reprint that document from users OS level default printer.

4) There are two things for this:
a) You have to define the local printer same as for your OS in SAP and maintain that as local in spad.
b) The user needs to give the spool request number in sp01 and then print it going forward.

or

You could configure a front-end printer (host spool method G) in SPAD. Printer name is generally LOCL. Understand now that you will have more problems by introducing front-end printing, and not fewer. Users will become accustomed to using it and will insist you fix it when some desktop patch or network change breaks it. I know it SEEMs like a good idea; remember I tried to warn you. Host spool method M is a more easily supported alternative (print-to-email and they can use the resulting attachment as they like).


Q5): What are the regular spool problems and resolutions?

5) Many and varied. Users do not typically distinguish between ‘spool problems’ and ‘printing problems’. Make sure the housekeeping j
obs run: https://service.sap.com/sap/support/notes/1411877

When you schedule standard jobs using transaction SM36 and choosing "Standard jobs", some jobs that are recommended in SAP Note 16083 are missing.

The following jobs are involved:

1. Job name: SAP_CHECK_ACTIVE_JOBS
              Report:  BTCAUX07

              Description: Check Status of Active Jobs

              SAP Note:  1169524

2. Job name: SAP_DELETE_ORPHANED_IVARIS
              Report:  BTC_DELETE_ORPHANED_IVARIS

              Description: Delete "Orphaned" Temporary Variants

              SAP Note:  1021775

3. Job name: SAP_REORG_ORPHANED_TEMSE_FILES
              Report:  RSTS0043

              Description:  Consistency Check: File System-TemSe, Table TST01 (with Deletion)

              SAP Note:  936049

4. Job name: SAP_REORG_PRIPARAMS
              Report: RSBTCPRIDEL

              Description: Delete obsolete print parameters

              SAP Note: 999951

5. Job name: SAP_SPOOL_CONSISTENCY_CHECK
              Report: RSPO1043

              Description: Consistency check spool/TemSe

              SAP Note: 98065



Q6): In my project I had faced a prob in SOLMAN. The system was giving short dump “SPOOL_INTERNAL_ERROR” and while checking it, system was issuing message “SPOOL OVERFLOW”.

6) As the solution I applied resolution provided in SNote no. 48284, which asked me to raise the upper limit for spool requests using TC=SNRO. The complete procedure is:

1. Log on to the system in client 000 and call transaction SNRO.

2. Select the object SPO_NUM and choose the button: Number ranges.

3. On the next screen, choose: Change Intervals.

4. In the “To number” column, change the upper limit of interval 01 to 999,999, for example.


Q7): Sometime printing is working perfectly & then suddenly all printing get stop. We have seen in SAP spool error log is:

“Unable to open file /usr/sap/<SID>/DVEBMGS40/data/009v1WwD.<SID> for writing (error 28)

Errors occurred processing this print request

There may be no printout”.

 After restarting it works fine for some time but again printing got stuck.

7) There are 2 things for this:

a) Do TemSe reorganization; remove inconsistencies & Restart SPO processes in SM50.

b) Error in UNIX Index Nodes (Inode stores basic information about a regular file, directory, or other file system object.)

We were facing out of index nodes issue. The directory where all the batch logs were getting accumulated had run out of number of files it could accommodate even though space was available. When we moved the batch logs to another directory issue was resolved.

Brief description of kernel executable files

Home


Brief description of kernel executable files

Kenel Files
 Description
R3check
The tool will check Cluster-Tables for errors
R3ldctl
The tool for exporting all table structures to the file system during an OS/DB-Migration.
R3load
The table import & export tool of SAP during Installation, Upgrade and Migration.
R3szchk
The tool for determine the sizes of the different tables in the target database during the import in an OS/DB-Migration.
R3ta
Split large tables for export and import
R3trans
his is the tool, that does the real work for tp. tp controls the import and export of changes and r3trans does them using scripts, that were generated from tp.
R3tran_XXXX.SAR
It is a compressed archive with the latest version of R3trans from the SAP Service Marketplace, used when we patched the kernel.
SAPCAR
To uncar compression files
SAPEXEDB_XXXX.SAR
Compressed file containing DB Dependent executables
SAPEXE_XXXXXXX.SAR    
Compressed file containing the Database Independent executables
cfw
GUI Control Framework for Abap Objects
cleanipc
Cleans Inter-Process Communications Memory
db2jcllib.o
Rsdb/db2jcl_library parameter
db2radm
Used to configure DB2Connect
dbadaslib.o
Part of lib_dbsl – database dependent SQL handler
dbdb2pwd
Create an encrypted DB2 Password File
dbdb2slib.o
Part of lib_dbsl – database dependent SQL handler – DB2
dbsdbslib.o
Part of lib_dbsl – database dependent SQL handler
dev_sapstart
Log file for starting sap
dipgntab
Activation and adjustment of the nametabs with the ABAP Dictionary.
disp+work
Dispatcher & Workprocess – “The complete Kernel” – Here the complete ABAP is processed
Dpj2ee
Dispatcher for Java
dpmon
Used to get the process overview of an instance in text mode.
dsrlib.o
Distributed Statistics Records
Dw_gui.o
Dependent module for Disp+work
Dw_mdm.o
Dependent module for Disp+work
Dw_stl.o
Dependent module for Disp+work
Dw_xml.o
Dependent module for Disp+work
Dw_xtc.o
Dependent module for Disp+work
Eg2mon
Monitor program for Extended Global Memory Segments (only for support)
Em2mon
Monitor program for Extended Memory management (only for support)
emmon
Test program for Extended Memory
enqt
Check and Monitor the Enqueue Lock Table
enrepserver
SAP Enqueue Replication Server
enserver
SAP Enqueue Server
ensmon
Enqueue Server Monitor Programs to monitor the enqueue server and the enqueue replication servers.
Es2mon
Programs to monitor the enqueue server and the enqueue replication servers.
esmon
Program to monitor the enqueue server and the enqueue replication servers.
estst
Test program for the Extended Memory Segments (only for support)
evtd
This program is able to trigger events within the SAP system. The tp tool uses this feature. It can be used as trigger for self-written interfaces as well.
exe_db2.lst
The ‘*.lst’ files are text files used by sapcpe to determine which files to compare/copy on instance startup.
gateway.lst
The ‘*.lst’ files are text files used by sapcpe to determine which files to compare/copy on instance startup.
gw.properties
Gateway processes
gwmon  
Program gwmon (at operating system level) or SAP transaction SMGW monitors the SAP Gateway.
gwrd
Program gwmon (at operating system level) or SAP transaction SMGW monitors the SAP Gateway.
icm.properties
Tool to monitor and manage the Internet Communication Manager (ICM) from the SAP System (transaction SMICM).
icmadmin.SAR
Tool to monitor and manage the Internet Communication Manager (ICM) from the SAP System (transaction SMICM).
icman
Tool to monitor and manage the Internet Communication Manager (ICM) from the SAP System (transaction SMICM).
icmbnd
Program to bind ports with numbers from 0 to 1023
icmon
Internet Communication Manager (ICM) used for HTTP(S), SMTP based communication used to monitor and manage the Internet Communication Manager (ICM) from the SAP System (transaction SMICM).
instance.lst
List of database-independent executables. These executables are valid for all database systems used by the SAP system.
instancedb.lst
List of database-dependent executables. These executables can only be used with a particular database system.
ipclimits
Reports IPC memory available to SAP at the OS level
j2eeinst.lst
The ‘*.lst’ files are text files used by sapcpe to determine which files to compare/copy on instance startup.
jcmon
Program to monitor and manage Java processes
jcontrol
Program to control Java processes
jenqulib.jar
Java Enqueue Library
jlaunch
Program starts the Java processes
jlogunzip.jar
Java Classes used to unzip archives (used from the sapstartsrv)
jperflib.jar
J2EE client Jar file
jstartup.jar
Java Startup Frame Work jar file
jstartupapi.jar
J2EE Engine Monitoring API
jstartupimpl.jar
J2EE Monitoring
ldap_rfc
LDAP Connector
ldappasswd
Store LDAP directory user and password
ldapreg
LDAP Registration Service
lgtst
Program to test the message server
libicudata30.a
ICU Common Library – Part of the RFC SDK and are used for RFC connections.
libicui18n30.a
ICU Common Library – Part of the RFC SDK and are used for RFC connections.
libicuuc30.a
ICU Common Library – Part of the RFC SDK and are used for RFC connections.
libjenqulib.o
Part of the RFC SDK and are used for RFC connections.
libjmon.so
JMON Shared Library – Part of the RFC SDK and are used for RFC connections.
libjperflib.so
Part of the RFC SDK and are used for RFC connections.
libregex.o
Part of the RFC SDK and are used for RFC connections
librfcum.o
Dynamic Load Library – Part of the RFC SDK and are used for RFC connections.
libsapcsa.o
CSA Shared Library – Part of the RFC SDK and are used for RFC connections
libsapsecu.o
SECU Shared Library – SAP seculib library used for default encryption. It’s referenced in the j2ee startup logs in the work directory.
libsapu16.so
Part of the RFC SDK and are used for RFC connections
libsapu16_mt.so
Part of the RFC SDK and are used for RFC connections.
mdxsvr
MDX Parser for RFC
memlimits
he program memlimits lets you determine how much swap space is currently available in the host system.
msclients
Shows running instances registered in the Message Server
msg_server
Main Message Server executable
msmon
Message Server Monitor Utility
msprot
Monitor Message Server at the OS level
niping
Program to test the SAP network layer and the SAProuter
rfcexec
The tool to start other programs from within SAP (ABAP) on the OS level via the gateway on any other (or the same) server.
rfcexec.sec
The tool to start other programs from within SAP (ABAP) on the OS level via the gateway on any other (or the same) server.
rfcping
Ping the RFC layer
rscparulib.o
 Dynamic shared library with code page converter
rscpf2f
Check installed locales for given list of languages.  (Created for installation tools. Possibly unused.)
rscpf3f
Find possible system code pages for given list of languages.                (Created for installation tools. Possibly unused.)
rscpf_ars
Test program for code page conversion, language handling and locales in combination with ‘rscparulib.o’.  (only for support)
rscpf_db
est program for code page conversion, language handling and locales. This program will connect to database and  also attached to shared memory of an instance if possible.  (only for support)
rslgcoll
Central System Logging Collector
rslglscs
Show the Syslog specific parts of the shared memory  segment ‘SCSA’. (mainly for support)
rslgsend
Central System Logging Sender
rslgview
View SAP Log at the OS level
rstrcscs
Program creates a common memory segment for the SCSA, locates the trace switches block within it and initializes the trace switches block.
rstrfile
R/3 system trace file tool
rstrlscs
The command “rstrcscs r” removes that common memory segment again.
rstrsscs
The command “rstrsscs” allows change to the switch settings in the trace switches block within the SCSA.
rsyn.bin
For each kernel version of the R/3 System, there exists an appropriate file rsyn.bin which contains the ABAP/4 syntax description.  It describes what to do when compiling an ABAP statement
sapccm4x
 CCMS Agent for Abap
sapccmsr
CCMS Agent for Java
sapcontrol
sapcontrol’ is used to stop/start/monitor the sap instances (for example, from the sapmc).
sapcpe
This checks that the local executables are up to date each time an SAP instance that uses local executables is started.
sapcpeft
Parameter file used by sapcpe
sapcpp46.o
Virus Scan Adapter files (Note 964305)
sapdbmrfc
RFC for SAPDB connections
sapevt
This program is able to trigger events within the SAP system. The tp tool uses this feature. It can be used as trigger for self-written interfaces as well.
sapexec
Call SAP Function Modules
sapftp
FTP Client, that can be used from within the SAP system (from ABAP) to communicate with other FTP servers.
saphttp
HTTP Client, that can be used from within the SAP system (from ABAP) to communicate with other HTTP servers – e.g. for interfaces.
sapiconv
Program for the conversion of text files
sapkprotp
Relocate a Content Server Repository
saplicense
The Tool for the installation of a new SAP License. This is needed when the license expires e.g. because of a hardware change.
sapmanifest.mf
Text file that contains the kernel patch level and is read by the JSPM (Java Support Package Manager).
sapmanifestdb.mf
Text file that contains the database kernel patch level and is read by the JSPM (Java Support Package Manager).
sapmscsa
SCSA Administration
saposcol
The SAP Interface to the Operating System for Performance Data. The Operating System Collector collects CPU Usage, Disk Performance, Paging etc.
sapparar
Reads the SAP Profile
sappfpar
This tool can be used for checking the profiles after changes and before restarting the SAP system.
saproot.sh
Script to set Root permissions necessary for some kernel programs
saprouter
The program for the Router Connection from customers to SAP and vice versa.
sapsecin
Generation of the PSE (Personal Security Environment)
sapstart
Starts SAP processes
sapstartsrv
Starts SAP processes
sapuxuserchk
The program xuser is a tool from maxdb which stores the logon information to the DB.  This utility program called by sapcontrol which is a program that uses the web service APIs of the ABAP and Java startup framework to control an instance from the command line.
sapwebdisp
The SAP Web dispatcher is used for load balancing for a setting up an SAP Internet scenario. It is the only application that needs to be located in the DMZ. Everything “behind” this can (and should) be located in your intranet. So, only one port on one IP address needs to be opened to internet and the SAP Web dispatcher can handle the traffic with the different SAP instances.
sapxpg
Program that starts programs on an external host. The tool for starting OS commands from within SAP Systems.
scs.lst
The ‘*.lst’ files are text files used by sapcpe to determine which files to compare/copy on instance startup.
scsclient.lst
The ‘*.lst’ files are text files used by sapcpe to determine which files to compare/copy on instance startup.
semd
A Test Tool used to verify semaphore operations.
servicehttp
The port number where the server should listen for HTTP requests.
shmd
Related to Shared Memory
showipc
Checks shared memory segments
sldreg
SLD registration program
sldreglib.o
SLD registration program
ssfrfc
Secure Store and Forward (SSF)
startdb
Program to start the database
startj2eedb
Program to start the database (Java)
startrfc
The tool is a very easy SAP command line interface to start all of the implemented function modules of SAP systems.
startsap
Program to start SAP
stopdb
Program to stop the database
stopj2eedb
Program to stop the database (Java)
stopsap
Program to stop SAP
tp
The Transport Tool. This program coordinates the complete import and export of program and table changes made within the SAP system in order to transport them through the complete System Landscape.
vscan_rfc
Virus Scan Adapter files (Note 964305)
wdispadmin.SAR
Web Dispatcher Administration Interface archive program
wdispmon
Web Dispatcher Monitor program
webdispinst.lst
Web Dispatcher Administration Interface list
xml63d.o
Virus Scan Adapter files (Note 964305)