Change the RFC | Sap Interviews Questions

Q-: How change the RFC's as they are system generated and there is no change option?. 

Ans-: You have need to check the Transport Tool from TMS? STMS->system overview->select the system XXX-->R3System->check->Transport Tool for errors from 000. Also does your user TMSADM have the correct authorizations and for that, does your ID have it? Check the TP logfile, ST22 and SM21 to see if it highlights any errors. 


Q-: How can I test my backup. Whether, I have taken the backup correctly or
not . After checking in DB12. 

ans-:

0005 is related to your 3rd party backup program. May this be the case?  You have need to check out  BRBACKUP logs to know more about this error

Q-: When You installed Solution Manager 7.0EHP1.and wanted to do a Kernel upgrade, backed up the Kernel files and performed a Kernel upgrade.why properly stopped the MMC and the services. 

Ans-: Restart your SAP and Database and make sure to stop/ start the service SAP<SID>_<SYSNO> under services as well. 

Q-: TMS is not working, and while testing the RFC's and getting Incorrect Username & Password.

ans-: 
1. plan of resetting the password of user TMSADM in 000 in all systems and update all RFC's in all systems manually.

But there is  you are not able to change the RFC's as they are system generated and there is no change option.
2.change the TMS RFCs in SM59, because they are automatically generated by the system when configuring the transport system.
If you need to change the TMS RFCs, you should do it by doing the changes in the TMS config and distribute the new RFCs. This is done in tcode STMS.  

Sap Database And Jdbc Exception Details

Exception Details:   com.sap.ip.bi.sdk.exception.BIConnectionFailedException: Cannot open the connection at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcConnectionFactor y.getConnectionEx(JdbcConnectionFactory.java:238) at com.sap.ip.bi.sdk.trialarea.connector.servlet.model.JDBCM odel.getConnection(JDBCModel.java:796) at com.sap.ip.bi.sdk.trialarea.connector.servlet.model.JDBCM odel.getTables(JDBCModel.java:132) at com.sap.ip.bi.sdk.trialarea.connector.servlet.controller. Control2.doPost(Control2.java:25) at javax.servlet.http.HttpServlet.service(HttpServlet .java:760) at javax.servlet.http.HttpServlet.service(HttpServlet .java:853) at com.sap.engine.services.servlets_jsp.server.HttpHa ndlerImpl.runServlet(HttpHandlerImpl.java:401) at com.sap.engine.services.servlets_jsp.server.HttpHa ndlerImpl.handleRequest(HttpHandlerImpl.java:266) at com.sap.engine.services.httpserver.server.RequestA nalizer.startServlet(RequestAnalizer.java:386) at com.sap.engine.services.httpserver.server.RequestA nalizer.startServlet(RequestAnalizer.java:364) at com.sap.engine.services.httpserver.server.RequestA nalizer.invokeWebContainer(RequestAnalizer.java:1039) at com.sap.engine.services.httpserver.server.RequestA nalizer.handle(RequestAnalizer.java:265) at com.sap.engine.services.httpserver.server.Client.h andle(Client.java:95) at com.sap.engine.services.httpserver.server.Processo r.request(Processor.java:175) at com.sap.engine.core.service630.context.cluster.ses sion.ApplicationSessionMessageListener.process(Applica tionSessionMessageListener.java:33) at com.sap.engine.core.cluster.impl6.session.MessageR unner.run(MessageRunner.java:41) at com.sap.engine.core.thread.impl3.ActionObject.run( ActionObject.java:37) at java.security.AccessController.doPrivileged(Access Controller.java:219) at com.sap.engine.core.thread.impl3.SingleThread.exec ute(SingleThread.java:104) at com.sap.engine.core.thread.impl3.SingleThread.run( SingleThread.java:176) Caused by: com.sap.ip.bi.sdk.exception.BIResourceException: Cannot open the connection at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcManagedConnectio n.(JdbcManagedConnection.java:123) at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcManagedConnectio nFactory.createManagedConnection(JdbcManagedConnectionFact ory.java:112) at com.sap.engine.services.connector.jca.ConnectionHa shSet.match(ConnectionHashSet.java:338) at com.sap.engine.services.connector.jca.ConnectionMa nagerImpl.allocateConnection(ConnectionManagerImpl.java:262 ) at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcConnectionFactor y.getConnectionEx(JdbcConnectionFactory.java:233) ... 19 more Caused by: com.sap.ip.bi.sdk.exception.BIResourceException: Cannot connect to JDBC data source at com.sap.ip.bi.sdk.dac.connector.jdbc.impl.Connection.conn ectDB(Connection.java:336) at com.sap.ip.bi.sdk.dac.connector.jdbc.impl.Connection.conn ect(Connection.java:99) at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcManagedConnectio n.(JdbcManagedConnection.java:118) ... 23 more Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset at com.microsoft.sqlserver.jdbc.SQLServerConnection.t erminate(Unknown Source) at com.microsoft.sqlserver.jdbc.TDSChannel.read(Unkno wn Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.P relogin(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.c onnectHelper(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.l oginWithoutFailover(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.c onnect(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerDriver.conne ct(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager .java:559) at java.sql.DriverManager.getConnection(DriverManager .java:158) at com.sap.ip.bi.sdk.dac.connector.jdbc.impl.Connection.conn ectDB(Connection.java:320)  Read more about sap servers

EHP upgrade from NW 700 to EHP2 sp6 level

 Q-:
Why SAP Ehpi broke during phase FREECHK in module PREP_SPACECHECKS / Space checks in check level

Error Message-:Missing file '/usr/sap/BWS/EHPI/abap/exe/rsecssfx

Ans-: Check r u using the correct version of the EhPI tool
 
Q 
 How can  FTP a file from an AL11 directory to an FTP server? 

Ans-: A local FTP server (same  datacentre as the SAP servers) and a remote FTP server (on the internet or placed on some other place)
 but  if it uses the SAPFTP RFC then it's a 'frontend' (ie. desktop) source/target and if it uses SAPFTPA then its from the DIA instance (not the desktop). 


Important Point-: New driver version that allowed to install ODBC connection on W2008. old version  W2003 was 10.2.0.2, to the new version 10.2.0.4.

 First download from oracle
After installation complete u able to create the ODBC connection using the 32-bit version of the ODBC-admin program from windows (location: C:\Windows\SysWOW64\odbcad32.exe).
The only issue I have now is that after setting the environment variables TNS_ADMIN and PATH to the new Instant-client and ODBC driver files, the Oracle DB is not starting up because it cannot find the <sid>init.ora file anymore. have to do some digging to fix that (starts up fine when using the SPFILE). 



Q-: 
1. How to check the level on the present QA, then copy it to the new QA

2. Then install it on the new box 


Ans-:
copy the kernel from current QA system.

You will have use the solution manager to download the necessary patch files.

Ehp Upgrade In Sap,Installation Error

Q-:
Doing EHP upgrade from NW 700 to EHP2 sp6 level ..

Error
SAPehpi broke during phase FREECHK in module PREP_SPACECHECKS / Space checks
Error Message: Missing file '/usr/sap/BWS/EHPI/abap/exe/rsecssfx'

but unfortunately i dont get that file with the kernelgiven by SAP .. 


Ans-: 
Are you sure you are using the correct version of the EhPI tool ?

There is a SAP note indicating that this file is not required yet. See SAP note 1561615

If this is correct open a message with SAP 


Q-:2


What Is Problem When We installed SAP BI 7.0 on suse Linux 10 with oracle 10.2.0.2, installation is finished successfully but when  restart the system,suppose i login as oraSID,
When i stated lisner it is started successfully, next i run the startdb command, i got fallowing ERROR.
LOGFILE FOR STARTING ORACLE
Trying to start BIW database ...  

Ans-:  checking required environment variables
ORACLE_HOME is >/oracle/BIW/102_32<
ORACLE_SID is >BIW<

2. Check Initora
checking V2 connect

TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 25-MAR-201104:24:25
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/oracle/BIW/102_32/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY =SAP.WORLD) (PROTOCOL = TCP) (HOST = biw7) (PORT = 1527))) (CONNECT_DATA = (SID= BIW) (GLOBAL_NAME = BIW.WORLD)))
OK (10 msec)
tnsping: V2 connect to BIW 

then,
Shutdown database
First trying to shutdown the database - May be,
the database is in the nomount or mount state 

starting database

SQL*Plus: Release 10.2.0.2.0 - Production on Fri Mar 25 04:24:31 2011
Copyright (c) 1982, 2005, Oracle. AllRights Reserved.
Connected to an idle instance.
ORACLE instance started.
Total System Global Area 457179136bytes
Fixed Size 1261404 bytes
Variable Size 239075492 bytes
Database Buffers 213909504 bytes
Redo Buffers 2932736 bytes
Database mounted.
Database opened.
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 -Production  

Presentation, Application ,Database Servers In SAP R/3

Application Server-: 

The application layer of an R/3 System is made up of the 

Application servers and the message server. Application 

Server is placed between the presentation server and database server. 

Application programs in an R/3 System are run on application servers. 

The application servers communicate with the presentation Components, 

the database using the message server. All the data are stored in a 

Centralized server. This server is called database server. The message 

server is used to communicate between different servers.

Presentation server in sap-:

Presentation server is system with GUI means all the output you can seen 

their and all the input is inserted by the presentation server. it collect 

the requirements from end users and dispatcher dispatch it to the data base 

layer for the response of that, where data base server is the main server 

which consist all the data information and tables, application server  placed 

between both, presentation and Database server and it provides interfacing 

between the database & presentation server. But now a new concept is introduced 

that is netweaver concept, in which a new layer is introduced that is internet 

layer. it consist every server different so it is called R/3 system earlier single

 System consist all the servers that is called R/1.

Sap Application Server - Sap Interviews Question

Sap Servers 
R/3 programs run on application servers. They are an important component of the R/3 System. 
There are different components in the appication servers

 work process


An application server contains several work processes,that can run an application. Each work process is linked to a memory area containing the settings of the application being run. The setting contains the current data for the application program. This needs to be available in each dialog step.

Each application server contains a dispatcher. The dispatcher is the attach between the work processes and the users logged onto the application server. Its work is to receive requests for dialog steps from the SAP Graphical user interface(presentation server) and direct them to a free work process.
Gateway

 Application server contains a gateway. This is the interface for the R/3 communication protocols (RFC, CPI/C). It can communicate with other application servers in the same R/3 System
 The fact that the individual work processes work independently makes them suitable for a multi-procecssor architecuture. The methods used in the dispatcher to distribute tasks to work processes
 you can read more about  dispatcher in next section


Application server Architecture

1.Presentation layer -:

In the presentation layer, the user interface can be developed with java server pages(JSP), or with web dynpro technology. Web Dynpro is used to design user interfaces for Java and ABAP applications. 

2.Business layer -:

Buisness layer is also  known as domain layer.It differentiate the buisness logic from other modules, such as the data access layer and user interface such as presentation layer

3.Connectivity layer-:

The Internet Communication Manager (ICM) dispatch the query to the presentation layes by using the internet protocols. some protocols used such as Http,Smtp,SSL

4. Persistence layer

Sap Interview Questions - ERP

Q-: What is ERP
Ans-:
ERP is a package with the techniques and concepts for the merged management of business as a whole, for effective use of  resources, for better the efficiency of an enterprise. In begining ERP was targeted for manufacturing industry mainly for planning and managing  business such as  production and financial market, human resources,accounts etc. Sap is itself ERP.


Q-: Different types of ERP ?
Ans-

1.  SAP, BAAN, JD Edwards, Oracle financial, Siebel, PeopleSoft. mostly companies try to implement the sap in their organization because of number of advantages aver other ERP packages.

Q-: Why do you usually choose to implement SAP? 

Ans- There are number of technical reasons numbers of companies are planning to implement SAP. It’s help organize and command all the data, and functions from main server and provides  highly secure data handling, min data redundancy, max data consistency. so it is adopted by mostly companies such as honda, oil mills, and many more.

Q-:What do you mean by IDES?

Ans - International Demonstration and Education System. Application provided for faster learning and implementation.

Q-: Define SAP R/3?

Ans - A third generation set of highly integrated software modules that performs common business function based on multinational leading practice. it is three tier, includes presentation server, application server, database server seprately.