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.

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.