Wednesday, March 7, 2012

Can EhP4 to EhP5 be Cnsidered an Upgrade

Can EhP4 to EhP5 be Cnsidered an Upgrade?


If you only apply EhP5 without any support packages, it's not considered an upgrade. The EhP5 pack does not touch any of the existing objects in your system, it will only add new functionality. However, it's highly recommended (and often mandatory) to include the latest support package stack whilst applying EhP5, and when you apply support package stacks, you must always perform a full regression test in your system.
Another concept-:SAP's marketing strategy is to say that Enhancement package Stacks is not an upgrade, but in reality it is the same amount of work as an upgrade.
You really need to use the Solution Manager Maintenance Optimizer to extract the full Stack packages and apply to the DEV system then you project team need to perform full Regression Testing.
Q why exception 'CX_RSR_X_MESSAGE' was raised
Since exceptions represent error situations and this error was not
adequately responded to, the running ABAP program 'SAPLRRMS' has to be
terminated.
Ans-:
Q when I'm trying to use the SNC Web UI, the Internet Explorer is unable to display the page.
ans-: This looks like it is the log of an installation; is that correct ? Either way, I would look at:

* the system prerequisites,
* the amount of SWAP space (or paging file on Windows),
* and the Java parameters.

it's the log of an installation.

(1)system info:
PC : IBM xSystem 3650 M3 ( 2 Intel cpu *4 Core /16G/500G )
SAP:NW 7.3

(2)SWAP sapce: 32G

(3)Java parameters:
JDK: SAPJVM( along with NW7.3 ) or IBMJava2-AMD64-142-SDK-1.4.2-13.11.x86_64


Q Why DB13 Failed with BR0252E Function fopen() failed
error-: Job started
Step 001 started (program RSDBAJOB, variant &xxxxxxxxxxxx, user ID xxxxxxxx )
No application server found on database host - rsh/Gateway will be used
Execute logical command BRCONNECT On host xxxxxxxxxxxxx
Parameters: -u / -jid CHECK20120116050000 -c -f check
BR0801I BRCONNECT 7.00 (52)
BR0477I Oracle pfile /oracle/xxx/102_64/dbs/initxxx.ora created from spfile /oracle/xxx/102_64/dbs/spfilexxx.ora
BR0805I Start of BRCONNECT processing: xxxxxxxxxxxxx.chk 2012-02-13 05.00.46
BR0252E Function fopen() failed for '/oracle/xxx/sapcheck/cesadsaasy.chk' at location main-11
BR0253E errno 13: Permission denied
BR0121E Processing of log file /oracle/xxx/sapcheck/casdacacsy.chk failed
BR0806I End of BRCONNECT processing: cehwmmpy.chk2012-02-13 05.00.48
BR0280I BRCONNECT time stamp: 2012-02-13 05.00.48
BR0804I BRCONNECT terminated with errors
External program terminated with exit code 3
BRCONNECT returned error status E
Job finishedv

Tuesday, March 6, 2012

Latest version of SAP BI and PI Systems,Kernal Upgrade in Dual Stack

Q-:What are latest version of SAP BI and PI systems
can I install BI system using the dump 'ehp1 for NW 7.3'?
can I install PI system using the dump 'ehp1 for NW 7.3'?

Ans-: you use the same DVDs for BI and PI on NW 7.3 EhP1. SAPinst will give you a list of available options to install and PI is one of them. This is new for NW 7.3. With NW 7.0 and 7.1, there was a separate DVD kit for PI
As per my understanding, It is
BI- EhP1 for NW 7.3
PI - PI 7.3

Q
How to start SAP Installation master in AIX. I have moved to current directory and ./sapinst. But it's giving following error.

iaextract.c :440: error opening archive file /oracle/ZIM/IM_AIX_PPC64/ ./sapinst

Ans-:There are three cases what you try to solve this problem
1-:Have you uncar the Installation master DVD
2-: Check permission and ownership of the directory. Make sure that directory has execute permission.
3-:uploaded zip file to server and unzipped it on machine and started sapinst.

Q-:Kernel upgrade on Dual Stack system, do we need to perform it using JSPM or 'usual' kernel upgrade process will suffice?

and if it is from JSPM then why we require to do it using JSPM, any specific reason behind it?

Ans-: You can perform the kernel upgrade using JSPM or using the standard file copy method.

No difference
Do this through JSPM as this takes care of shutting down both stacks.

Q-: Transaction MB51 runs for a long time on mkfb table
ans-: Check your indices on MKPF.

If possible rebuilt them. In our case suddenly MB51 start to
underperform... very badly, from 15 min to 2 hours.
Our basis rebuilt the indices (don't know if all of them or one in
particular) and that made the difference.
BTW, we just have a year and 2 months of data so the reconstruction of
indices did the job in our case.

However be aware that if your data is large, index reconstruction might not
solve your problem int that case check SAP Notes 1598760, 1550000, 1516684,
that in short, pass create some fields of MKPF to MSEG so there is no need
for a join between these two tables by only using MSEG.
That is harder to implement but is seems to the way to go if really have
lots of data.

Q-:tcode st02 shows red entry for SWAP PROGRAM, SWAP SCREEN & SWAP GENERIC KEY.

Ans-:
Important measurement is the HitRatio. If the HitRatio is greater than 96% you do not really have a problem
Look for the memory related parameters post the values for
ztta/roll_area
ztta/roll_first
ztta/short_area
rdisp/ROLL_SHM
rdisp/PG_SHM
rdisp/PG_LOCAL
em/initial_size_MB
em/blocksize_KB
em/address_space_MB
ztta/roll_extension
abap/heap_area_dia
abap/heap_area_nondia
abap/heap_area_total
abap/heaplimit

Friday, February 10, 2012

Solution Manager Sap

Solution manager is best tool for monitoring the complete sap system and all activities
Q
Is it possible to do system copy between 2 different SID'S?
Ans
Yes, that's pretty much what's done in 99,9% of the copies.
Just follow the system copy guide. It's located at http://service.sap.com/instguides


Q
In the implementation of WebChannel can put it on the same server as CRM or ECC? What are the impacts?
Q
What monitoring tool for big landscape containing all types of systems

Ans
Solution Manager is best tool for all monitoring and You can also check SAP's End-user Experience Monitoring (EEM) to complement Solution Manager.


Q-:During this Runtime error Assertion_Failed why?

The ASSERT condition was violated.
Error analysis
The following checkpoint group was used: "No checkpoint group specified"

If in the ASSERT statement the addition FIELDS was used, you can find
the content of the first 8 specified fields in the following overview:
" (not used) "
" (not used) "
" (not used) "
" (not used) "
" (not used) "
" (not used) "
" (not used) "
" (not used) "
ow to correct the error
Probably the only way to eliminate the error is to correct the program.
-

If the error occures in a non-modified SAP program, you may be able to
find an interim solution in an SAP Note.
If you have access to SAP Notes, carry out a search with the following
keywords:

"ASSERTION_FAILED" " "
"CL_FP_WB_HELPER===============CP" or "CL_FP_WB_HELPER===============CM013"
"FORM_GET_FORMTECH"

If you cannot solve the problem yourself and want to send an error
notification to SAP, include the following information:

1. The description of the current problem (short dump)

To save the description, choose "System->List->Save->Local File
(Unconverted)".

2. Corresponding system log

Display the system log by calling transaction SM21.
Restrict the time interval to 10 minutes before and five minutes
after the short dump. Then choose "System->List->Save->Local File
(Unconverted)".

3. If the problem occurs in a problem of your own or a modified SAP
program: The source code of the program
In the editor, choose "Utilities->More
Utilities->Upload/Download->Download".

4. Details about the conditions under which the error occurred or which
actions and input led to the error.



Q Why {ERROR IN LICENSE CHECK(LOGIN NOT POSSIBLE)}
Ans
It's not allowed to attach any files in this forum, so you'll have to paste the relevant lines from the logs into your message.so this error accured

Tuesday, January 31, 2012

ECC 6.0. Installation System

Question
Why this error accur while we install the ecc 6.0 on windows xp proffessional 64bit

ERROR 2012-01-23 00:43:43
CJS-30149 ABAP processes of instance ER1/DVEBMGS00 [ABAP: UNKNOWN] did not start after 10:00 minutes. Giving up.

ERROR 2012-01-23 00:43:43
FCO-00011 The step start with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|i nd|ind|ind|ind|1|0|NW_CI_Instance|ind|ind|ind|ind|11 |0|NW_CI_Instance_Start|ind|ind|ind|ind|1|0|start was executed with status ERROR .

ERROR 2012-01-22 03:19:11
MUT-03025 Caught ESyException in Modulecall: ESAPinstException: error text undefined.
ERROR 2012-01-22 03:19:11
FSL-00001 System call failed. Error 87 (The parameter is incorrect. ) in execution of system call 'GetVolumeNameForVolumeMountPoint' with parameter (L:\), line (276) in file (synxcfsmnt.cpp).

ERROR 2012-01-22 03:19:11
FCO-00011 The step getMounts with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|i nd|ind|ind|ind|1|0|NW_GetSidNoProfiles|ind|ind|ind|i nd|2|0|NW_getMounts|ind|ind|ind|ind|0|0|getMounts was executed with status ERROR .

sol-: If you using mount points in Windows XP 64-bit ? Suggest you remove ":\" from the name of disk name of the mount points.

other condition-: If you are installing ABAP+JAVA wait till the instance starts then click Retry, faced this error before and fixed by this way.

3-:USB connected hard disk is not supported.
4-:Need license for the ECC6 installation on your notebook
Windows XP is NOT a supported OS for SAP installations.

Q
Working on a project which has a 4 different production systems sitting on 4 different release levels of SAP i.e. ECC5, 4.6C, 4.7 and ECC6.

A financial statement version was created on the development system of 4.6c and would need to be applied to the other 3 remaining systems. Is it possible to apply/import the same transport or will the FSV need to be configured in each dev system of the 3 remaining?

Ans-: You cannot apply Transport Request that was generated on different version.
2-: Need to be developed in each version


Q-: Email configuration
case 1-: it is possible to receive in our SAP message queue (in SOST) a warning/alert message, when, for instance, we send a message from a SAP to an email address which it has the mailbox full... it is possible to receive an information with a “mailbox full” message?
case2-: It´s possible, somehow, to configure an automatic reprocessing of all messages that failed, for instance, I send a message from a SAP system to an email address but for some reason it fails, is there any way to sent again this message automatically in SOST?

Ans-:It's been years since I was looking at connections between SAP and MS-Exchange and email send errors.
Which SAP version? Is it MS-Exchange as the SMTP server or something else? If something else, is that ESMTP compliant?
case 1 solution
In SCOT, use menu option: "Settings" > "Confirmation of Receipt". It's a fairly self-explanatory screen.
Search SAP documentation for "DSN" (delivery status notification), that's the industry standard term for this functionality. The more popular definition of DSN is data source name (a logical DB identifier), that's not the one you want.
case 2 solution
Question for the OP: Have you looked at all the send failures (for 1 day as an example) and assessed how many of those would benefit from being resent, as is? What I remember is, almost all email send failures I checked occurred because of a malformed target email address (I've checked 1000s of email/fax send failures in SOST, back in the day). Resending the same malformed item again & again is not going to resolve anything, even if you had an ABAPer code a program that would resubmit failures for you. I'm sure an ABAPer could create such a program, but I'm not aware of any standard functionality that would do the same automatically (of course, you can resend failures manually from within SOST).

Friday, January 20, 2012

Online Sap Training

Here you can browse list of companies and institutes who offers sap training and provides sap services to various companies. They provide the sap erp software to companies. These companies offers the course of financial (fico), hr and payroll, sales distribution module training, production planning, material management module training,business warehouse, sap crm software training.you can contact with any of these companies regarding course in sap erp or fees details about these comapanies.
Sapphire Consulting Limited
G Block, Sahakanagara, Bangalore 560092
+91 (0) 9343331617 / (0) 9035416837.
mail: queries@sapphireconsulting.co.in

Miracle Infocom
Miracle Infocom
#37/10, Lekkad House(3rd Floor)
Cunningham Road
Landmark:Opp to Fortis Hospital
Bangalore-560062

IT Solutions India.
I.T. Solutions India Private Limited
D-88/5, Okhla Industrial Area, Phase I,
New Delhi -110020. India
Phone : +91-11-47695000

H. R. : hrd@itsipl.com
Technical Support : techsupport@itsipl.com
Sales : sales@itsipl.com

BRANCH OFFICES :
Chandigarh : itsolutions-chd@itsipl.com
Jaipur : itsolutions-jai@itsipl.com

IIHT Bangalore
Siemens
For all inquiries you may contact our Telephone Support:

International (English):

+49 (69) 797 6660

Germany (German):

+49 (800) 225 53 36

Mo. – Fr. 8:00 – 17:00 (CET)

Texas Techologies:
Vare House
Aprax Consulting
Cranium Information Technology.
Nirvana Infocom
Artech Systems:
Zupiter Technologies
Marven Consultancy
iBorderless india (p) Ltd
Pratian Techologies
Kauf Solutions India Private Limited
Net Business Solutionsv

Friday, January 6, 2012

Trusting RFC, RFC Authorization Error

Q
RFC Authorization Error
runner to run Winshuttle.why we get error - "user had no RFC authorization" - authorization problem data not found.
You SAP user inside your RFC connection is missing S_RFC and similar security profiles.

Ans-: If you have mixed upper/lowercase characters in your password, please check out sap note 1023437 - ABAP syst: Downwardly incompatible passwords (since NW2004s)
Mostly when we submit the password which is wrong it displays the message such like that
actually rfc authorization is When a remote call of a function module is made, an automatic authorization check is performed, provided that the profile parameter auth/rfc_authority_check is set to 1. The authorization check uses the authorization object S_RFC to check whether the user defined in the destination has RFC authorization for the function group of the called function module.


Q
Why dump CALL_FUNCTION_SIGNON_REJECTED in our production system at regular interval (every 30 mins). This dump is generated only from all of the application servers, but not from the central instance. SAPSYS user is generating this dump.

An external system, is trying to login into your PRD system every 30 minutes. Check your other system to find failed jobs (SM37) or short dumps (ST22).
Ans-:
CALL_FUNCTION_REMOTE_ERROR shows when there is some issue on REMOTE server. Try to check the logs on that remote server where you want to execute this function.

You can also search for a function/program name on internet.
Another way
Note 171805 - Determining RFC client when sign-on problems occur
Note 313971 - Monitoring: RFC error messages for SAPSYS users

SAP Note 13347 - CALL_FUNCTION_SIGNON_REJECTED

The RFC using to connect to your system can have the wrong password or problem with the user id.
it may be issue-:
This is due to authorisation issues . This seems to be issues in RFC connections. Check all your connections



Q
Have offline backup of db. but need to restore it , so that we can restore to my previous state. how it can be done
Ans-: we can do it by using BRTOOLS (OR) BRRESTORE.
If you have brtools 7.00 and above then have a look at note 1003028 which talks about enhanced database copy in brtools.
Using brrecover is a good option
you can recover using the commance brrecover -c force -t complete -b last (This will do a complete recovery )
or do a point of time recovery using
brrecover -c force -t dbpit -b last -seq last
This will not only restore but also recover your database.

Another way to solve the problem
Just restore datafiles from the backup like sapdata1 to sapdata1 ,sapdata2
to sapdata2 ,sapdata3 to sapdata3 ,sapdata4 to sapdata4 and so on.

As it is offline backup so it does not requires redologs.





Q
What is Trusting RFC.After setting trust connection between ECC & SolMan one TRUSTING_SYSTEM@ rfc is generated by system automatically in system both side.

What is use of it and does it effect trust connection if it is deleted?
Ans
Solman is reading/writing data from other systems through this RFC
etc monitoring, transport management, key distributions, project management, ... whatever you use solman for

If this rfc is not working properly then the solman functions will not work either.

Q
Will the Trace File be Lost if the System is Restarted? will you loose the trace file, or can you see?

ans-:In SAP the st11 dev trace files are created anew for every system
restart...dev_w0 dev_w1 etc.. in /usr/sap/SID/DV*/work directory.
SAP only keeps one .old version.
If you want to keep more, rename it something other than .old.

Thursday, December 29, 2011

Installing Solution Manager 4.0,

Disp+Work.Exe Stops after System Restart
check listener controls

CMD--->lsnrctl---->start
Check the R3trans -dv

Q installing solution manager 4.0, why error "InitFastLoad fail"

Q
How to get the below details in solution manager system?

1. Choose from the menu “System” “Status…”. Then click the button.
3. Check the software component “ST” and let me know the release and level.
4. Check the software component “ST-SER” and let me know the release and level.

ans the menu path system -> status (arrow) will lead you to the overview of the different components in any ABAP AS based system.


Query-: test message for the SAP go live procedure for my SOLUTION MANAGER 7.1 on Windows 64/Oracle.

In service desk => create support message: I can manage to create the message but it doesn't seem to be sent to SAP.
What is the procedure once the message is created to send it to SAP? Cause when I select: "send message to SAP" I have the following error: The system could not find your SAP customer message system user"
solution:
SAP Note 1165980 is not applicable as such, but did you maintain the S-Users

maintained the Super Users, I have 4 in the system: SIDADM, DDIC, SAP* and Myuser.

I use the COSADM account to create the message, and in the test message to SAP, the reporter is "myaccount" and the sold-to-party is "sap support".

Q-: trying to perform a client copy form 100 --> 200 with sap_all profile. This copy fails with error:

Database error 8102 at DEL access to table COBRB
> ORA-08102: index key not found, obj# 15818, file 16, block

We've got this error for several indexes; but those indexes EXISTS! (I've checked on db02, se14, )

Also, I've checked at Oracle level with sqllplus, and also exists on database (with the same object_id 15818)

Wednesday, December 28, 2011

How SAP Table Reorganized | Create Background Job Tivoli or Sap server

Q-:
How is SAP Table Reorganized ? Should all the table included !
should it be online/offline?

Ans-: You can do table Reorg either online or offline.Please take note that the online reorganization will impact on system performance, therefore you need to run this when the system load is low.

If you are using Oracle, reorg can be done using BRTools or db13 too.Please have a look at SAP Note 646681(for oracle) .Below am giving the method to run this if it is oracle DB;
the procedure to perform reorganization using BR*Tools::
1. Run BRTOOLS. Choose Segement Management or run from
the command prompt brspace –f tbreorg.
2. Enter table name in Table names (table).
3. Choose Reorganize Tables.
4. Set the required option like new destination tablespace or set he parallel thread which will be used to perform reorganization. The more you set the thread, the faster your process will be. But his limited to the CPU specification in OS level.
5. Choose continue to start processing.
6. Check the detail log in s.tbr.

You can perform the following types of reorganization:

* Reorganize tables online and check tables for reorganisation
* Clean up tables after aborted reorganization
* Convert LONG and LONG RAW fields to CLOB or BLOB online
* Stop reorganization (command-line mode only)
* Suspend reorganization (command-line mode only)
* Resume reorganization (command-line mode only)

Q-:
How void a range of checks and reprint them at the same time. What is the T-code I would use? Is it FCH8?
Ans-: No, FCH8 is used for reverse check payment
You need to check with your FI consultants or ask this message in the SAP-ACCT group.

Q-: ECC 6.0 ABAP server. Enabled user defined CCMS monitoring for file system, job failures, etc,,. But Spool alerts not getting generated in Tivoli.

Ans-: You can use Tcode SM36 to create background job and SM37 to check it on
SAP server.

2-: ans
For Tivoli to alert you on Filesystem, Table space or jobs etc your Tivoli
team will need to configure the tivoli situations on Tivoli. You as a
BASIS administrator will need to assist in the initial installation. You
will be required to run a standard script provided by tivoli which creates
the tablespaces,user assign the requisite roles to the tivoli user in your
SAP database and then import a transport into your instances.
Once done there are certain config details which will be needed to be
provided to the tivoli team by the help of which tivoli will start
monitoring your instance and depending on the situation configured generate
the alert.

assume that Tivoli does read all the open alerts which are reported
in the monitor "rz20 -> Tivoli monitoring -> New Pok sap"

Please first check if this is done for RED and YELLOW alerts and
secondly please check if only spool alerts are missing because as you
can see in the attached screen shot this monitor is reporting alerts
for many other type of monitoring nodes. It is better I think only to
create a monitor for the background job and spool monitoring nodes and
use this monitor for Tivoli.

Q-:How to create background job ? it should be created in Tivoli server or SAP server?
Ans-: You can use Tcode SM36 to create background job and SM37

Friday, December 16, 2011

Dialogue WP cannot be Killed,License for DR test in sap

Q-:
Dialogue WP cannot be Killed
dp mon , sm50 -> cancel with core , cancel without core , kill from OS with pid.
OS : Linux
SAP : SAP ECC 6.0
Ans-:
user associated with the work process you want to kill (in sm50). If so try sm04 - select the user - user drop down menu - log off user.
get the PID and kill it from OS level .

check the ps -ef |greap PID. is it there

Go to SM50, select the DIA process you want to kill and in menu line select "Administration -> Process -> Restart After Error -> No"
Then kill the PID from OS.
If it works, you can switch the process back to "Restart After Error -> Yes".

Q-:
When Error License Check problem accur? how to solve this problem it could happen we use temperarily licence key.

Break the mirrored disks and mount them to another AIX Unix server for a DR test
Ans-:
You should get a permanent license key. Then you will not have additional things to remember in a DR situation
yes you can also use the temporarily license key for DR but in future you need permanent


Q-:
When this type of error occur
Database error -55555 at OPC
> dsql_db6_open: Unable to find initial entry as expected
SAP system with backend DB2, operating system AIX IBM

ans-:
it just happened in one application server (happens to be the CI), so I performed a buffer reset with "/$SYNC" transaction.

Additionally, it might be worthy to check if the logs always points to the same work processes, in which case is advisable to kill them.


Q-: question regarding BDLS. I did a db refresh last month on a BW system and when I run the BDLS it took nearly 20k seconds to complete the conversion. This is normal. However recently I did a db refresh on the same system, and the bdls only run for 800 seconds. I checked the log slg1 and compare it to the previous month it is the same. So my question is, why the significant time decrease? The only change that I know was it used to be no application server, but now there are additional two. Although I dont think this can solve as bdls run using only one dialog process from the central instance and during the bdls running the application servers were down.
sol-:
you 100% that you chose the exact same source and destination logical system names?

You know that you have to at least convert ECC and BW logical systems names? so, this means running this twice on your BW system?

Are you sure that you have not forgotten to uncheck option "TEST run"?
Also read http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/4796 for a very godd strategy to make BDLS run much faster.

Wednesday, December 7, 2011

Sap Installation Problems Linux, Windows

How to Turn job active in this situation
background process scheduled in SM36 is in released state and held up there continuously. It's not getting active. Background process is almost empty with only two recursive process occupying the queue.

After finish the schedule it's would be comes automatically in FINISH mode.
sequence of background job:
Scheduled --> released --> Active ---> Finish

Q
AIX 5.2 / SAP R/3 Enterprise 4.70 EE 200 with 6.20 64-bit kernel/Oracle 9i

Device type is - HP LaserJet driver PCL4/PC.
Host spool access method- X:sapcomm.

When we give a print, the printer is printing an extra page at the end.

ans-: Go to the printer setting then networking then on LPD banner page option select disable.

Problem Installing Sap ecc 6.0 sr2 and Oracle 10.2.0.2 on Laptop running Windows 7-64bit Ultimate.
ans-:
Windows 7-64bit Ultimate is not supported for SAP server install. But your error is related to the Oracle software. The Oracle 10g version is not supported on Windows 7.


Sooo, as David and others stated, you must install this on a Windows server version, such as Windows 2003 or Windows 2008.

Read SAP'S PAM at http://service.sap.com/PAM

Also, read the installation guide at http://service.sap.com/INSTGUIDES .

If you don't have access to these websites, then, you are not a SAP customer and you must PAY to get this software and these accesses.

Finally, EC 6.0 SR2 is old software, try to install ECC 6.0 EHP5.


Q
Start Instance Service of Instance Leo/DVBE
install (SAP EHP 5.0 +oracle 11.2 ) on Linux 64bit.

I have came to the step -- start instance, then happened with the below error:

An error occurred while processing option Enhancement Package 5 for SAP ERP 6.0 > SAP Application Server ABAP > Oracle > Central System > Central System( Last error reported by the step: Instance LEO/DVEBMGS00 reached state SHUTDOWN after having state STARTING. Giving up.).

You can now:
Choose Retry to repeat the current step.
Choose Log Files to get more information about the error.
Stop the option and continue with it later.

Log files are written to /tmp/sapinst_instdir/ERPEhP5/AS-ABAP/ORA/CENTRAL/.
change the host file, where i remark the record *127.0.0.1 ....", and add one record: IP address hostname...

Then happened with a new error: Could not start instance service of instance Leo/DVBE.

Sol- you can try all these things regarding your problem
1
My recollection of this stage is that if SAP is running it will skip the start.
So, with SAP started, press retry or skip.
2
Try to manually start SAP? Do this first, if it starts you can continue the installation. If it fails post the startup logs here.
3
change /etc/hosts to this:

# Do not remove the following line, or various programs
# That require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
192.168.1.103 prcsgisap02

Saturday, November 26, 2011

SAP Business One without a license key

In production system job SAP_COLLECTOR_FOR_PERFMONITOR is failing twice in day with Dump
ITAB_DUPLICATE_KEY.
Otherwise it is finished successfully. Frequency is 1 hour.
Same error in 2 production system (sid )ABC & PQR.
No overlapping jobs.
Errors what occur
In sid - > ABC : at 06:34:00 & 21:34:00
in sid -> PQR : at 06:40:00 & 21:40:00

Job Log :
Job started
Step 001 started (program RSCOLL00, variant , user ID XXX )
Clean_Plan:Cleanup of DB13 Plannings
Clean_Plan:started by *** on server xxxxx
Clean_Plan:Cleaning up jobs of system SID
Clean_Plan:finished



Sol-:
SAP Notes 1303289 and esp. 1567182 (collection job terminate with short dump?) have been recommended
install the NWBC in the EHP4 server. following steps
1. Downloaded the sap cryptograpic file from service market palce. and uncared the file.
2. copied the files in niintel in the path d:/usr/sap/sys/sid/uc/nt64
3. assigned the system variable secudir
4. in rz10 i have given the parameters( FQDN, icm/server_name_xx, SSO congiration paramerters, snc parameters)
5. i have restarted the system.
Here when i have logged into the sap application system, it is showing login not possible(error in license). But i am able to login with sap*.

So the next step i have done is reverted the system. (Removed the copied file, removed the enviroment variable, removed the parameters in rz10). Now the system is fine.

Can anyone suggest me what the error i have done?

Our system is installed in the vmware server. with windows server 2003 64bit. it is oracle database.
Q-:
Kindly get the permanent license and if you are able to login only via SAP* means your license is expired

How long after the installation can I continue to use SAP Business One without a license key?
For new installations, the system can be used for a period of 31 days after the first posting without a license key. This 31-day period cannot be extended. After the end of this period, you will no longer be able to access the system. You should request a permanent license key as soon as possible. For more information on the requesting process, see SAP Note 578256.

Which authorization do I need to request a license key for my customer?
If you are an SAP partner and would like to request a license key for one of your customers, you will need an S-user with the authorization "license key request for SAP partner". For further information, see SAP Notes 124703 and 103926.

When do I have to request a new license key for my Business One system?
• If your hardware key has changed
• If the number of users has changed
• If the license expiration date has changed
• If components (add-ons) have changed
• If you upgraded your system from release 6.x to release 2004

How can I request a Business One license key?
Request your license key using SAP Service Marketplace from service.sap.com/licensekey, choose SAP Solutions for SMB, choose request license key. You can find more information on requesting license keys in SAP Note 578256.

Who should request license keys?
License keys should be requested by the SAP partner. Prerequisite for requesting a license key is a S-user and the authorization for the partner "License key request for SAP partner" for the corresponding installation number. Only in exceptional cases if an end-customer should not have an SAP partner the license key can be requested by the customer itself. For further information, see SAP Notes 124703 and 103926.

What should I do if I have mistakenly requested a license key for a new system instead of a license key for an existing system?
Delete the systems that were requested repeatedly as described in SAP Note 614911. Afterwards you can request the new license key for the existing system using SAP Service Marketplace from service.sap.com/licensekey, choose SAP Solutions for SMB , choose request license key. You can find more information on requesting a license key in SAP Note 578256.
Source-:http://www.sdn.sap.com/irj/scn/go/portal/prtroot/d ocs/library/uuid/194f5ee0-0301-0010-d693-a097c165527f?QuickLink=index&overridelayout=tr ue#q-1

What should I do if I requested a license key using an incorrect installation number?
The system ordered using the incorrect installation number should be deleted and re-requested using the correct installation number on the SAP Service Marketplace. The deletion process is described in SAP Note 614911.

Wednesday, November 23, 2011

How to install SAP-FICO

Question-:
Can I remove below message when I logon:

Continue with this logon and any other logon in this system when ending any existing logon to system,unsaved data is lost.


Solution with ECC 5.0 on AIX 5.3. When logon in DEV server with same user once
again it shows three options . These options are as under:-



1. Continue this logon & end any other logon in the system

When ending any existing logons to system, unsaved data is lost.



2. If you continue with this logon without ending any existing logons

system, this will be logged in the system. SAP reserves the right t

view this information.



3. Terminate this logon



But When logon in PRD server with same user once again it shows two
options only. These options are as under:-



1. Continue this logon & end any other logon in the system

When ending any existing logons to system, unsaved data is lost.



2. Terminate this logon

How to install SAP-FICO, but not aware of the latest version of ECC.

install Sap ECC 6.0 with EHP5 ides in your laptop because you have not sufficient harddisk size but
Sap ECC 6.0 with EHP4 ides can install in your laptop. If you want install sap ides.
it takes nearly 300 GB hard disk and 15 hrs.


Query-:
How do I convert this escape sequence to Hexadecimal; (4B(s1p42.0v0s0b102T? Would anyone be able to convert it



Q
Problem in BPC conection Wizard Issue
Mostly we use default 8000 port number. Do we need to change the default port number? if so how can we specify the port number in BPC Admin Client?

sol-: connect via BPC Admin Client specify the IP address and port number e.g. 192.1XX.1.212:8000

Q-:
How can decipher the field fausa in table t077d? what the notations meet ( required/ optional etc) and how can I map the "+" to a specific field?

Sol-: use SM31, view V_t077D, click the button customizing, then in the pop-up "continue w/o specifying Project". That will show you the section of the IMG where the settings need to be maintained. Choose "Accounts Receivable and Accounts Payable" and go from there.

Monday, October 10, 2011

SAP Netweaver 7.3 installation

Q-: What software we can install with sap netweaver 7.3
Ans -: Using the SAP Netweaver 7.3 installation DVDs we can install the following software:

- Process integration
- Enterprise Portal
- Netweaver Mobile.
- SAP Master Data Management (MDM)
- SAP BI

Q-:
how to check the user login log including date ,userid,terminal?

Run the "last" command to find out all previous logins.

Ans-:
Activate user audit in sm19 and display user audit log in sm20.
In this log you find all things you want related user login.


Configure the Fiscal printer in SAP. Is this configuration the same as the normal printer configuration or is there something different for this?

Problem-: Problem That can you face in your work
Best Method to Create Index For Large Tables
System information: SunOS 5.9; R/3 4.7; Oracle 10.2.0.4;
Question: What is the best method to create indexes for very large tables?
Such as BSIS, 100 GB.
For example: Create an index named Z09 with fields: MANDT, BUKRS, HKONT

I know the normal answer is to use SE11 (create index, Z09) and then SE14 (build index, Z09). But this is where the problem lies. SE14 will LOCK the table until the index is created. Since the BSIS table is heavily used 24/7 in the system, this is not desirable. With little downtime available (2 hours a week maximum), this process will not work.

In SQL*Plus using the 'create index' command. But once this index is created, how is this index then linked to the table in the SAP database?

My attempt at this process shows:
- SE11 the index is listed and status is Active
- SQL*Plus created index using command of:
create index SAPR3.BSIS______Z09 on SAPR3.BSIS (MANDT, BUKRS, HKONT) nologging tablespace PSAPLARGEI parallel (degree 2) online;
- DB02 the index is listed with correct ownership and locations

But here is the issue:
- SE14 listed the index name, shows status as Active/Saved, BUT states "Does not exist in the database" and the DB Index Name shows as: "Not defined as DB index in the ABAP Dictionary". (Side note: All the Create/Delete/Activate buttons are greyed out). The Storage Parameters button shows no entry for the Z09 index.

Is there a missing step after the index is manually created to make it seen in the SAP system?
Is there a general steps procedure to use if creating index outside of the SAP transaction SE14?
Try to sort it such procedure-:
Two hours is more than enough to create that Z index.

Test this in a non-prod system and you will see that this should take less than 30 minutes.

Saturday, September 10, 2011

Sap interview practical problems

This summary is not available. Please click here to view the post.

Friday, August 5, 2011

Value for PHYS_MEMSIZE ,Create RFC,Tcode in Quality server

Q-:Made a ZSM01 Tcode in quality server
Sol-:
Steps
1) SM30
2)Program=SAPMTSTC
3)Authorization object=S_ADMI_FCD and its Value=TLCK
4)You can use local object
5)Select (radio bott) Transaction classification & SAVE



Q-:Create rfc with user oss_rfc and the paswd is update
Sol-:Use TX OSS1 ->Technical settings -> Save


Q-: What is the value for PHYS_MEMSIZE ?
Ans-: The value of PHYS_MEMSIZE is 10000.

Q-: How to find out who (admin ID) locked a t-code through SM01.
Sol-: Used STAD or STAT
2-:Update table TSTC for the transaction SM01 and field CINFO from A or 2 to 0
or 8.



Query-:
strengthen our Production XI system by adding one application server (with load balancing) to take care of the additional load. Right now, XI system (Netweaver 7.0, PI 7.0 ) is running on HP-Ux 11.31/Oracle 10g and configured as High Availability.

http://sapinterviewshelp.blogspot.com/2011/04/user-creation-in-sap-administrator.html
http://sapinterviewshelp.blogspot.com/2011/05/sap-related-queries-and-problems-which.html
http://sapinterviewshelp.blogspot.com/2011/05/sap-latest-interview-questions-and.html
http://sapinterviewshelp.blogspot.com/2011/06/sap-ecc-5-on-ms-sql-database-server-to.html
http://sapinterviewshelp.blogspot.com/2011/06/upgrade-ecc60-ehp1-ready-to-ecc60-ehp4.html
http://sapinterviewshelp.blogspot.com/2011/06/sap-ecc-5-on-ms-sql-database-server-to.html


Sol-:
SAP web dispatcher to balance the load on your Java instances, then map everything to go through this web dispatcher instead of going directly to your Central instance.

Thursday, June 23, 2011

upgrade ECC6.0 EHP1 Ready to ECC6.0 EHP4 | SAP GUI 7.1 to 7.2

Q-: Need to upgrade ECC6.0 EHP1 Ready to ECC6.0 EHP4. Did I use EHPInstaller or SAPUp?

Ans-: Use EHPinstaller tool to upgrade to EHP4.

Query-: Web Gui take more memory then not gui client

Both network allow me, but my question is like a sap router string we use to connect sap server. Like this I want connect and my current string of web gui is:

http://sapdevail:8000/sap/bc/gui/sap/its/test/webg ui_tj?sap-client
0

Now where I give router string or my static ip.


Solution-: 1- Your router string looks like it is missing something like a /h/dns-name
or /hIP-ADDRESS
2-: You can access from another network as long as the network firewall allows SAP traffic.


Q-: Explain what is the look of router id and how can you use the web string
Ans-: /H/124.247.208.216/s/3299/H/



Q-: if you installed WEBSAPGUI 7.10 patch 9 on a Windows 2008 R2 64-bit machine using a IIS 7 web service and strictly followed the manual on how to install it.

After tried to access the Web Console using http:///isapi_sapcnsl.dll. The browser prompts me to download the isapi_sapcnsl.dll file which of course shouldn't.


Q-:
My users cannot print in SAP after upgrade from SAP GUI 7.1 to 7.2. There is no error.?

You should have a look at method "G" or "C" instead to print

More info about method G at http://help.sap.com/saphelp_nw70/helpdata/en/42/dd 174f02302cede10000000a1553f7/content.htm

Q-: I have to refresh the QAS with a copy of PRD SAP Enterprise Portal. The O/S is Windows. Can I execute the brrestore in Windows to restore a PRD backup? How can I execute the restore?

sol-: Find the homogeneous system copy guide for your particular version and follow the procedure there. I don't believe that you can perform a restore as this is a Java instance. You will need to export the PRD system by following the procedure in the guide and then perform an installation suing the export .

If your system is a dual stack version then you can use the ABAP portions' backup and restore for the ABAP side only but will still have to do the export of the Java side.

2-: You can refresh a JAVA stack using a backup/restore... but the only supported way is through a SAP export and import. As stated by Al Fournier, the homogeneous system copy guide explains it all.

If you don't care about SAP's support, try to get a document called "An expert guide to successfully managing & executing Java system copy processes" by Sanjeev Gholap from BearingPoint.


Q-:
sap system has became slow. Now i am getting TIME_OUT error in ST22. The program 'SAPLSETRAN' has exceed MAXIMUM permitted runtime without interruption

How to analysis the issue.

Q-: SAP BI Reports and need to get the URL of them can we use crome browser?

Ans-: no, Chrome is not a supported browser for SAP products, yet.

SAP ECC 5 on MS SQL Database server to SAP ECC 5 on Oracle database server



Query-:
Moving our SAP ECC 5 on MS SQL Database server to SAP ECC 5 on Oracle database server is good.


Performance-wise, you should get a bout the same throughput.clients want to migration from Oracle to MS-SQL... not the other way around. All new clients I know go with MS-SQL or DB2. I don't see companies going to Oracle for new installations.

in this case, company has good Oracle knowledge. Check how much it will cost your more using ORacle versus training your ORacle team to use Ms-SQL.

Q-:Backup/restore method from PRD to QAS. because our QAS doesn't have new data to test. Current src & trg syst is
source = ECC6 PRD [SP level 19 & kernal level 185] + win2003 sp2 + mssql2005 sp2
target = ECC6 PRD [SP level 19 & kernal level 185] + win2003 sp1 + mssql2005 sp1

what we can for this problem



1-:can i take backup frm src & restore directly to trg OR i have to apply the SP's of win & mssql to trg & then restore?
2.my backup of mssql is going to be night backup, so no user would be logged and am gonna take simple recovery mode with full, so two files will get backup; .MDF & .LDF, other than this any other files necessary to restore
3.if restore is success, what is the next step,i mean how to log into ECC6 syst and other steps.
Sol-: Follow the steps in the System copy Guide and in SAP Notes 151603 and maybe you also need 551915.
You should patch the SQL Server before performing the copy.

Another Option-: However if you stop SAP and perform a backup, you have an offline backup.

Do not change the system to simple mode and you can restore the transaction logs to a point-in-time.

Thursday, June 9, 2011

Transport Requests Between Different Transport Systems|Sap Router

Query-:We installed the SAP Router and have started it as a NT Service. However when I go to SM59 and test for remote connections, I get an error message: ERPSOLMAN:Route permission denied.ERS to 194.39.131.34.sapdp99).

At my OSS1 Tx when i test for my Lo on i get an error message:
erpsolman:ROUTE PERMISSION DENIED:(ERS TO 194.39./131.34.SAPDP99)


Sol-:
The SAPROUTTAB is not configured correctly.

However you should get the error with Tx OSS1.

Note 169924 - OSS_Connection trouble shooting. Hopefully this should resolve the problem.



Query-:DIR_TRANS must be shared between all system.
and you must give the access right to all {SID}adm user to all content to this dir.
For all the systems that are in one Group you shuld have a single Transport directory so your DIR_TRANS should be pointing to that shared transport directory.


Sol-: You can configure TMS to transfer transport requests between Different transport systems.

Our production systems do not share the Transport Directory. In the import Queue is a green arrow indicating that the data and cofiles need to be copied.


When I am trying to maintain a "zxxx" table through SM30 in Quality I am getting "Client 200 has status 'not modifiable'" and getting the "Message no. TK430"

It's not recommended to make changes on quality, otherwise your systems will no longer lined up. You have to apply changes on DC1 and transport them to QAS and after that to prod.

another solution
Problem can be solved by following snote#301665.
In the live system, set the "Current settings" (CURSETTING) indicator in the OBJH table for the detailed screen of the overhead rates, the V_KONX view. Depending on your release, proceed as follows:

As of Release 4.6
As of Release 4.6, you can set the "Current settings" indicator for the V_KONX view directly. To do this, call transaction SOBJ and select the V_KONX object. Select "Details" (magnifying glass, F2) for the V_KONX object. Select the "Current settings" indicator on the detail screen in the "Derived attributes" group box and save this setting. Transfer this change to the OBJH table in the live system.
Reset the 'Current settings' indicator in a client that is not flagged as live, since the indicator prevents the inclusion of the add-ons in a transfer order (if the corrections from Notes 709504, 733777 and 820955 have been implemented in the system).






Query-:

one of the Ecc6.0 server has been infected by virus.After removing the viruses,Sap instance is not starting.In mmc it theres error showing:
sapcpe couldnot start
strdbs.cmd could not be started.
Below is the log of sapstart.log

AP-R/3-Startup Program
Starting at 2011/06/07 16:45:51
Startup Profile: "c:\usr\sap\qas\sys\profile\START_DVEBMGS00_ECC6QAS "
Starting Programs
(4748) CreateProcess(\\ECC6QAS\sapmnt\QAS\SYS\exe\nuc\NTI 386\sapcpe.EXE pf=\\ECC6QAS\sapmnt\QAS\SYS\profile\QAS_DVEBMGS00_ ECC6QAS) failed(67). ERROR_BAD_NET_NAME: The network name cannot be found.
(4748) CreateProcess(\\ECC6QAS\sapmnt\QAS\SYS\exe\nuc\NTI 386\strdbs.cmd QAS) failed(67). ERROR_BAD_NET_NAME: The network name cannot be found.
(5476) CreateProcess: C:\usr\sap\QAS\DVEBMGS00\exe\msg_server.EXE pf=\\ECC6QAS\sapmnt\QAS\SYS\profile\QAS_DVEBMGS00_ ECC6QAS
(5160) CreateProcess: C:\usr\sap\QAS\DVEBMGS00\exe\disp+work.EXE pf=\\ECC6QAS\sapmnt\QAS\SYS\profile\QAS_DVEBMGS00_ ECC6QAS
(1580) CreateProcess: C:\usr\sap\QAS\DVEBMGS00\exe\igswd.EXE -mode=profile pf=\\ECC6QAS\sapmnt\QAS\SYS\profile\QAS_DVEBMGS00_ ECC6QAS

sap folder is having share name saploc and i can access through network.Whereas in the errorlog it shows CreateProcess(\\ECC6QAS\sapmnt\QAS\SYS\exe\nuc\NTI 386\sapcpe.EXE .
under exe i have the folder named UC then why its looking for nuc...no idea.
O.S= WIN2000
DB= ORACLE 10g

solution-:
you have to restore all passwords (OS and Oracle) with your old defined password.
From the error message i must be the principal reason for this error.

also check if users are locked and check their permissions.

Monday, May 23, 2011

Sap Latest Interview Questions and practical problem solutions

Q-:How can we check the relevant developer trace as there will be so many
dev_w#.

Ans-:
1. Check the database for logs full
2. Check file systems - available disk space
3. Check relevant developer trace files for clues dev_w#

Q-:If you search for relevant SAP notes the ABAP Short Dump "SAPSQL ARRAY INSERT DUPREC" is also produced with Program bugs.

Ans-:

SAPSQL ARRAY INSERT DUPREC
This error means that a transaction / program was attempting to commit
information to the database that would result in a duplicate entry in a
table with primary key. Depending on when and where you are getting it it
can be caused by some SAP bugs in Physical Inventory Document Clearing,
number ranges being out of synchronization after a client copy etc.

Q-:
how to unlock client 000?

Ans-:

Set the parameter login/no_automatic_user_sapstar = 0 (Zero) in the instance profile and restart the system.
when you locked yourself. You can try using DDIC or
sap* with the master password that should give you access to client 000 and
you can unlock the locked user.
Just go to the Profile <\usr\sap\SID\SYS\profile> add parameter
login/no_automatic_user_sapstar and restart sap mmc once, after this you
can login with default password


Queries-:

I'm planning to do the installation for SAP ECC 6.0 on Windows Server 2008 R2 Standard with Database DB2 9.1.

Do I need to download the DB2 v9.5 or 9.7 from the service market place and start the Installation, which DB2 version is compatible with Windows Server 2008 R2 Standard (DB2 9.5 or DB2 9.7).




SPDD transport we got from development will not suit in Quality system as there will be many delta objects. In our Quality system many urgent corrections happened, so we are planning to import SPDD transport manually and then check delta objects and proceed further.


in this case you should by-pass the SPDD and SPAU steps and process them after the Patching is complete.

However as you have imported the request and are getting R/C=8 errors you really need to contact SAP
In case of delta objects as well you can use the procedure mentioned by me
as that will include the SPDD of the development system and then give you
the option during preprocessing phase to do the delta adjustments.

Please open a customer message with SAP support to resolve the issue as you
had already imported the SPDD tr.

Wednesday, May 4, 2011

Sap Related Queries And Problems Which You Face

- Is there any possibility to allow create queries in production environment by using transaction SQ01 when system is non-modifiable



-if you taken client export of production client from scc8 with sap all & and import this on QA client, after successfully import of STMS. when iexecute tcode scc7 "Post-Client Import Methods" and check scc3 after some time it got stuck on following error message . kindly advice what's wrong



- looking for SAP System copy tools instead of manual system copy . what is it?



Qus-:




indeed was simpler to copy the transport files in some temporary location and then remove them from the buffer.





sol- You need to release all the transport requests. Then you can continue applying the support packages.

point2-

If you do not need the requests delete the transport Requests from the import buffer of the QAS/PRD systems



Qus-:

I'm not able to install the SAPKH60301 into the system as well. Getting the error "No valid queue for SAP_APPL rel. 603"



Sol-: Use Tx SPAM and view the packages and see what Prerequisite packages are necessary.

qus-

After the offline backup weather I can take the incremental backup. For
offline backup I have shutdown the database and copied the datafiles, log
files, temp file and control file and started the target system database.
I have no catalog while taking the backup.Now, I need to take the
incremental backup from the point where i have taken the full online backup.




- weather in increment backup only control files and redolog file are enough too take backup or weather we have to take changed data files also

-

After offline backup weather I can take incremental backup by RMAN.

Sol-:

If you restore the full offline backup you can restore the subsequent redo log backups only as long as you have not started the database on the Target system.

point2-

If you have started the database it is no too late to to apply to apply log backups. You should have restored the database using the offline backup and performed a point-in-time recovery using the redo log backups before starting the database. Once you start the database it it too late to apply additional logs.