Saturday, June 23, 2012

Oracle 10g Abnormal Program Termination On Windows 2008 R2

Q-: Oracle 10g Abnormal Program Termination On Windows 2008 R2
SAP ECC 6.0 DEV and PROD servers on Windows 2003 with Oracle 10.2 database.
My client purchased windows 2008 R2 with new hardware Itanium processor, i have to migrate windows 2003 OS to Windows 2008.
On new server, I plan to perform system copy.
I installed Windows 2008 R2 on new server and j2sdk. Then I tried to install Oracle 10.2 from Oracle dump -> C:\TEMP\NT\IA64
I am getting error after entering drive letter and SID,
Abnormal program termination. An internal error has occurred. Please provide the following files to Oracle support: " unknown"
Sol-: download the IA64 media? Look for SAP Note 986578 - Oracle support in Itanium 2 systems (Montecito & following), I do not know if this applies to Windows but at least in Linux depending on the architecture you need whether to use IBM JDK (x86_64 or x64) or Sun JDK (IA64).
Another thing-:
Your client's management is seemingly not aware that IA64 is dying off? Are they good to go for another platform switch, 2 years from now?
http://scn.sap.com/thread/1920954
http://blogs.technet.com/b/windowsserver/archive/2 010/04/02/windows-server-2008-r2-to-phase-out-itanium.aspx.

Oracle 10g Abnormal Program Termination On Windows 2008 R2

Q-: Oracle 10g Abnormal Program Termination On Windows 2008 R2
SAP ECC 6.0 DEV and PROD servers on Windows 2003 with Oracle 10.2 database.
My client purchased windows 2008 R2 with new hardware Itanium processor, i have to migrate windows 2003 OS to Windows 2008.
On new server, I plan to perform system copy.
I installed Windows 2008 R2 on new server and j2sdk. Then I tried to install Oracle 10.2 from Oracle dump -> C:\TEMP\NT\IA64
I am getting error after entering drive letter and SID,
Abnormal program termination. An internal error has occurred. Please provide the following files to Oracle support: " unknown"
Sol-: download the IA64 media? Look for SAP Note 986578 - Oracle support in Itanium 2 systems (Montecito & following), I do not know if this applies to Windows but at least in Linux depending on the architecture you need whether to use IBM JDK (x86_64 or x64) or Sun JDK (IA64).
Another thing-:
Your client's management is seemingly not aware that IA64 is dying off? Are they good to go for another platform switch, 2 years from now?
http://scn.sap.com/thread/1920954
http://blogs.technet.com/b/windowsserver/archive/2 010/04/02/windows-server-2008-r2-to-phase-out-itanium.aspx.

Error when installing Solman7.1 with AIX+oracle

Q-: Why this error accur when we installing solman7.1 with AIX
New error: sapinst.log
INFO 2012-06-22 23:25:47.614
Execute step fillContextProduct of component |NW_Onehost|ind|ind|ind|ind|0|0
ERROR 2012-06-22 23:26:01.270
FJS-00003 invalid return (in script NW_Onehost|ind|ind|ind|ind, line 200469: return ( NW_Onehost_ind_ind_ind_ind( functionName , isValidator ) ); )
ERROR 2012-06-22 23:26:01.302
FJS-00011 Error compiling script.
ERROR 2012-06-22 23:26:04.190
FCO-00011 The step fillContextProduct with step key |NW_Onehost|ind|ind|ind|ind|0|0|fillContextProduct was executed with status ERROR ( Last error reported by the step
: invalid return (in script NW_Onehost|ind|ind|ind|ind, line 200469: return ( NW_Onehost_ind_ind_ind_ind( functionName , isValidator ) ); )).
INFO 2012-06-22 23:26:04.968
Creating file /oracle/sapinst_instdir/SOLMAN71SR1/SYSTEM/ORA/CENT RAL/AS/__instana_tmp.xml.
Sol-: You have to set the recommended OS kernel parameter (check your OS procedure) also set java environment parameters and test with java -version command if java is working under the user used to install oracle...basic prerequisite for OS administration part.
If you done these steps-:
temporarily shifted sapinst_dir under the oracle as default directory tmp got full. I ran pre-requisite checker and got two error as follow but I assumed its not relevant to this particular issue.
1. Environment variable (CPIC_MAX_CONV) =condition not met <
2. JAVA_HOME = Could not check <
You have need to remember this step when using java that what version and use parameter accordingly
you use the right java, in this case is JDK 1.4.2 downloaded from IBM, as far as I know. Also need to read the OS related notes as asep818 said in order to set the correct kernel parameters.

Tuesday, June 12, 2012

Solman7.1, AIX 6.1, Oracle 11g Installation

I'm working on Solman7.1, AIX 6.1, Oracle 11g installation, Upon adding parameters in Default profile, I activated it. (I checked the Consistency in Profiles) When try to restart the system, it comes with Database needs to be started first. Then I looked into the Default Profile, its shows the logs and doesn't hold any parameters.. (all are commented out).
Need your thoughts on this. Sample of the default profile as follows: #Created during Solman install -Vj 08062012 #parameter created by: RZP60K 06/08/2012 15:04:30 rdisp/gui_auto_logout = 1800 #Created during Solman install -Vj 08062012 #parameter created by: RZP60K 06/08/2012 14:56:16 rdisp/buffermode = sendoff,exeauto #Created during Solman install -Vj 08062012 #parameter created by: RZP60K 06/08/2012 11:51:16 #parameter deactivated by: RZP60K 06/08/2012 12:03:42

Incorrect time zone In Sap System


System was set in a incorrect time zone. How can I change it back?
Use T-code STZAC.
How can we delete the entries from DBTABLOG using RSTBPDEL report, it is not delete any records, even i tried we Dialog mode and background mode also. But it is not deleting any record from dbtablog table.
1. Check you have the right authority to delete the records 2. Make sure you have the variant specifications correct as regards date fields, try using a dynamic variant by date or specify a specific table.
3. Try RSTBCOUNT to check the content and discover which tables contribute the highest change logs
Query-: I want to do the settings in SR13 as per the language I have logged in: eg: If I have logged in through Eng language, online manual should open with eng If I have logged in through dutch language, online manual should open with dutch. Current settings are for Eng lang, I tried to maintain setting for dutch language. But its giving me following error :
E:H2:718 WIN32 How can it be done?
Ans-: just add an entry in SR13, but put the Lagnauge Field to DE and adapt the URL/link accordingly. Q-: Why this error accur
Cannot find PDL type for output device '(Printer name)'
Ans-: Its depend on Host Access type? 'F' or 'G' if you are using G then change it with F or if using F then change it with G
Q-: We are using SAP ECC6 with EHP 4 with SAP GUI 7.2. we have a strange problem with many users (Not All).
Session of few users auto logout after few minutes if remain idle. However this is not happening with many other users. We have checked with our basis and network team and they have not set any auto logout policy. This is happening with only few users and most of the users remain logged in even after being idle for hours. We are on windows 7.
Ans-: Asking different affected users, is the length of the 'idle time' consistent before the disconnect message (i.e. always 5 minutes) or does it vary (sometimes 5 minutes, sometimes 15 minutes, sometimes 30 minutes,
2-: check logs in work directory
If you want to find ping or tracert to IP address of sap server. If there is a loss in packet it will show you RTO.

Friday, March 9, 2012

Abap BI 7.0 with the EP 7.3,IDES SAP ERP 6 EH5 for Windows / Oracle

Q
Abap BI 7.0 with the EP 7.3, It will be compatible for the web bex scenario?

Please refer the below SAP if Data Access gave some components or cross system functionality can't work then you should
upgrade the releavant systems

1388258 - Version Interoperability within the SAP Business Suite
1468349 - SAP Business Suite 7 for SAP NetWeaver 7.3 hub systems

With the below link, we can say that BI 7.0 and EP 7.3 will be incompatible for the web bex scenario

Q upgrade EHP5, can i upgrade EHP5 without EHP4 ??

Ans-:Yes, you can upgrade an existing ERP system to EHP5 directly without EHP4.
More details can be found in master guide and upgrade guide of EHP5 in marketplace.

Q-: Why NWBC 3.0 PL10 or 3.5: Security Warning
I just installed in my pc NWBC 3.0 PL10 and in another PC NWBC 3.5.
When I log on in the system ECC6 Release 702 SP07, I have a popup with the title:
Security Warning.
Content:
SAP NWBC has identified a potential security concern.
This location is not explicitly marked as safe:
http://www.sap.com
As a result navigation is blocked. If you think it is necessary that the location is marked as safe, please contact your local administrator.
(For details, see chapter '7.8 Whitelist' in the documentation).

But, I do not found any doc with the point 7.8 Whitelist present.
Ans-:
This Location is not explicitly marked as safe/whitlisted:
see http://goo.gl/uIrZb

For further info refer Note 1378659 - NWBC 3.0: known issues & what to check when opening a ticket


Q when we downloaded IDES SAP ERP 6 EH5 for Windows / Oracle. When I launched sapinst.exe why we didn't find SAP Application Server ABAP and sub tree Oracle Central System.
Ans-:
it may be, your DVD is wrong.
I have download the same DVD number and launched sapinst.exe, here I found SAP Application Server ABAP and dialogue Instance



So, please, download an other DVD:


Software Download -->IInstallations and Upgrades -->nstaSearch for Installations and Upgrades
give the DVD number and download it

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.