tag:blogger.com,1999:blog-20317266276696183472024-02-19T16:19:02.174-08:00SAP Basis FAQsNitin Nayyarhttp://www.blogger.com/profile/16414537983607513424noreply@blogger.comBlogger31125tag:blogger.com,1999:blog-2031726627669618347.post-60690357122557543252012-06-27T03:58:00.003-07:002012-06-27T04:15:46.107-07:00Connecting SAP BI to Microsoft SQL Server Database<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
This document reflects couple of steps that we used to connect our SAP BI on DB2/Windows x64 bit based Server with MS SQL Server Database.<br />
<br />
The Purpose of our connection was to read one table from SQL Server DB.<br />
<br />
<br />
<br />
<div class="MsoNormal">
<b><span style="font-family: 'Adobe Kaiti Std R', serif;">Requirement:<o:p></o:p></span></b></div>
<div class="MsoNormal">
<b><span style="font-family: 'Adobe Kaiti Std R', serif;"><br /></span></b></div>
<div class="MsoNormal">
<span style="font-family: 'Adobe Kaiti Std R', serif;">To
connect the existing SAP BI NW 7.02 on DB2 and Windows x64 bit based system with
MS SQL Server Database.<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="font-family: 'Adobe Kaiti Std R', serif;">Procedure:
<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l3 level1 lfo1; text-indent: -.25in;">
<span style="font-family: 'Adobe Kaiti Std R', serif;">1.<span style="font-family: 'Times New Roman'; font-size: 7pt;">
</span></span><span style="font-family: 'Adobe Kaiti Std R', serif;">Create
a Logical System for this connection. We created SQLSERVER<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpLast" style="mso-list: l3 level1 lfo1; text-indent: -.25in;">
<span style="font-family: 'Adobe Kaiti Std R', serif;">2.<span style="font-family: 'Times New Roman'; font-size: 7pt;">
</span></span><span style="font-family: 'Adobe Kaiti Std R', serif;">Download
the DBSL for the external RDBMS in your kernel directory - for SQL Server it is
called dbmssslib.dll<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpLast" style="mso-list: l3 level1 lfo1; text-indent: -.25in;">
<span style="font-family: 'Adobe Kaiti Std R', serif;"><br /></span></div>
<div class="MsoNormal" style="margin-left: .5in;">
<span style="font-family: 'Adobe Kaiti Std R', serif;">Go
to market place path: <b>SAP NetWeaver and
complementary products > " SAP NetWeaver" > SAP EHP2 FOR SAP
NETWEAVER 7.0 > " Entry by Component" > Application Server ABAP
> SAP KERNEL 7.20 64-BIT UNICODE > Windows on x64 64bit > MS SQL
SERVER ></b> and check for the Data Base Library file
"lib_dbsl_218-10007271.sar"<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal" style="text-indent: .5in;">
<span style="font-family: 'Adobe Kaiti Std R', serif;">The
following 2 files are uncared from the file
"lib_dbsl_218-10007271.sar": <o:p></o:p></span></div>
<div class="MsoListParagraphCxSpFirst" style="margin-left: .75in; mso-add-space: auto; mso-list: l1 level1 lfo3; text-indent: -.25in;">
<span style="font-family: 'Adobe Kaiti Std R', serif;">a.<span style="font-family: 'Times New Roman'; font-size: 7pt;">
</span></span><span style="font-family: 'Adobe Kaiti Std R', serif;">dbmssslib.dll<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpLast" style="margin-left: .75in; mso-add-space: auto; mso-list: l1 level1 lfo3; text-indent: -.25in;">
<span style="font-family: 'Adobe Kaiti Std R', serif;">b.<span style="font-family: 'Times New Roman'; font-size: 7pt;">
</span></span><span style="font-family: 'Adobe Kaiti Std R', serif;">dbmssslib.pdb<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpLast" style="margin-left: .75in; mso-add-space: auto; mso-list: l1 level1 lfo3; text-indent: -.25in;">
<span style="font-family: 'Adobe Kaiti Std R', serif;"><br /></span></div>
<div class="MsoNormal" style="text-indent: .5in;">
<span style="font-family: 'Adobe Kaiti Std R', serif;">Put
both these files in the following locations<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpFirst" style="margin-left: .75in; mso-add-space: auto; mso-list: l0 level1 lfo2; text-indent: -.25in;">
<span style="font-family: 'Adobe Kaiti Std R', serif;">a.<span style="font-family: 'Times New Roman'; font-size: 7pt;">
</span></span><span style="font-family: 'Adobe Kaiti Std R', serif;">D:\usr\sap\<sid>\SYS\exe\uc\NTAMD64<o:p></o:p></sid></span></div>
<div class="MsoListParagraphCxSpLast" style="margin-left: .75in; mso-add-space: auto; mso-list: l0 level1 lfo2; text-indent: -.25in;">
<span style="font-family: 'Adobe Kaiti Std R', serif;">b.<span style="font-family: 'Times New Roman'; font-size: 7pt;">
</span></span><span style="font-family: 'Adobe Kaiti Std R', serif;">D:\usr\sap\<sid>\DVEBMGS<nn>\exe<o:p></o:p></nn></sid></span></div>
<div class="MsoNormal">
<br /></div>
<span style="font-family: 'Adobe Kaiti Std R', serif; font-size: 11pt; line-height: 115%;"><br clear="all" style="mso-special-character: line-break; page-break-before: always;" />
</span>
<br />
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal" style="margin-left: .5in;">
<span style="font-family: 'Adobe Kaiti Std R', serif;">Go
to transaction DBCO and enter the following new entries<o:p></o:p></span></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVpbJCsEepjMAEVPturuHzOEBLk8j3B1z6Lmp9Ql6GcGfphaQ8Hk_yT97-cCwqXQ78MonTFt5FIO7KX41O-cYD45Xm-_70KNb8W7GW4PGVLpaR89XzOMApBZ7D5FuXDbeBX5MnCTPcAJQ/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="183" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVpbJCsEepjMAEVPturuHzOEBLk8j3B1z6Lmp9Ql6GcGfphaQ8Hk_yT97-cCwqXQ78MonTFt5FIO7KX41O-cYD45Xm-_70KNb8W7GW4PGVLpaR89XzOMApBZ7D5FuXDbeBX5MnCTPcAJQ/s400/1.png" width="400" /></a></div>
<div class="MsoNormal" style="margin-left: .5in;">
<br /></div>
<div class="MsoNormal" style="margin-left: .5in;">
<span style="font-family: 'Adobe Kaiti Std R', serif;"><br /></span></div>
<div class="MsoNormal" style="margin-left: .5in;">
<span style="font-family: 'Adobe Kaiti Std R', serif;">The
Parameters to be entered are as follows:<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: .5in;">
<span style="font-family: 'Adobe Kaiti Std R', serif;"><br /></span></div>
<div class="MsoNormal" style="margin-left: .5in;">
<b><span style="font-family: 'Adobe Kaiti Std R', serif;">DB Connection:</span></b><span style="font-family: 'Adobe Kaiti Std R', serif;"> A name for the connection to
SQL Server<br />
<b>DBMS:</b> Data base type<br />
<b>User Name:</b><br />
<b>DB Password:</b><br />
<b>Permanent:</b> Uncheck<br />
<b>Connection Limit:</b> 0<br />
<b>Optimum Conns:</b> 0<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal" style="margin-left: .5in;">
<b><span style="font-family: 'Adobe Kaiti Std R', serif;">For SQL:-<o:p></o:p></span></b></div>
<div class="MsoNormal" style="margin-left: .5in;">
<b><span style="font-family: 'Adobe Kaiti Std R', serif; font-size: 10pt; line-height: 115%;">Conn Info:</span></b><span style="font-family: 'Adobe Kaiti Std R', serif; font-size: 10pt; line-height: 115%;"> MSSQL_SERVER=<server>
MSSQL_DBNAME=<db_name> OBJECT_SOURCE=dbo<o:p></o:p></db_name></server></span></div>
<div class="MsoNormal" style="margin-left: .5in;">
<b><span style="font-family: 'Adobe Kaiti Std R', serif; font-size: 10pt; line-height: 115%;">SERVER =</span></b><span style="font-family: 'Adobe Kaiti Std R', serif; font-size: 10pt; line-height: 115%;"> Hostname or IP of Sever hosting SQL Server DB<br />
<b>DB_NAME =</b> Data base that you need to
connect to<br />
<b>Schema =</b> dbo<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: .5in;">
<br /></div>
<div class="MsoNormal" style="margin-left: .5in;">
<b><span style="font-family: 'Adobe Kaiti Std R', serif;">For Oracle:-<o:p></o:p></span></b></div>
<div class="MsoNormal" style="margin-left: .5in;">
<b><span style="font-family: 'Adobe Kaiti Std R', serif; font-size: 10pt; line-height: 115%;">Conn Info:</span></b><span style="font-family: 'Adobe Kaiti Std R', serif; font-size: 10pt; line-height: 115%;"> SSID=<ssid database="" of="" source="">;SAPDBHOST=<name database="" host="" is="" of="" on="" running="" the="" which=""><o:p></o:p></name></ssid></span></div>
<div class="MsoNormal" style="margin-left: .5in;">
<span style="font-family: 'Adobe Kaiti Std R', serif; font-size: 10pt; line-height: 115%;"><br /></span></div>
<div class="MsoNormal" style="margin-left: .5in;">
<span style="font-family: 'Adobe Kaiti Std R', serif;">Once
you save it, the entries will be created in Table: DBCON<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: .5in;">
<br /></div>
<div class="MsoNormal" style="margin-left: .5in;">
<b><span style="font-family: 'Adobe Kaiti Std R', serif;">Go to RSA1<o:p></o:p></span></b></div>
<div class="MsoNormal" style="margin-left: .5in;">
<span style="font-family: 'Adobe Kaiti Std R', serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8wOaSSYA1Vvchzb5dH43vV1dofhXPKOhZuG4k0xVxN5HB4RL5ji_rZTCYnmefmg4yLdkCcHEkatJMlbmnqhjxqvP2_fbCBkdV-Fyb7ZWpR1s7JUE1L0DbXAdRiSXfyx42IhZsxkIXVQg/s1600/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="250" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8wOaSSYA1Vvchzb5dH43vV1dofhXPKOhZuG4k0xVxN5HB4RL5ji_rZTCYnmefmg4yLdkCcHEkatJMlbmnqhjxqvP2_fbCBkdV-Fyb7ZWpR1s7JUE1L0DbXAdRiSXfyx42IhZsxkIXVQg/s400/2.png" width="400" /></a></div>
<div class="MsoNormal" style="margin-left: .5in;">
<span style="font-family: 'Adobe Kaiti Std R', serif;"><br /></span></div>
<div class="MsoNormal" style="margin-left: .5in;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidQDbqFjr8zqDMr7C9hWHE-UMqFawPgA8NBznv77ae94S0TzZA3dVFM0Nd7MJRLK3QVS_raEPV_oJ9q_4YxSpL49OTO4PO5B3KwbAy_T14dyTnTV_7gJPRGh32DRWi5Qq3bl6hW2zRyrE/s1600/3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="106" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidQDbqFjr8zqDMr7C9hWHE-UMqFawPgA8NBznv77ae94S0TzZA3dVFM0Nd7MJRLK3QVS_raEPV_oJ9q_4YxSpL49OTO4PO5B3KwbAy_T14dyTnTV_7gJPRGh32DRWi5Qq3bl6hW2zRyrE/s400/3.png" width="400" /></a></div>
<div class="MsoNormal" style="margin-left: .5in;">
<span style="font-family: 'Adobe Kaiti Std R', serif;"><br /></span></div>
<div class="MsoNormal" style="margin-left: .5in;">
<br /></div>
<div class="MsoNormal" style="margin-left: .5in;">
<span style="font-family: 'Adobe Kaiti Std R', serif;">Press
enter and then enter/select the desired DB connection parameters as explained
above.<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-left: .5in;">
<br /></div>
<div class="MsoNormal" style="margin-left: .5in;">
<span style="font-family: 'Adobe Kaiti Std R', serif;">Reference
Links:</span><br />
<span style="font-family: 'Adobe Kaiti Std R', serif;"><br /></span><br />
<span style="font-family: 'Adobe Kaiti Std R', serif;"></span><br />
<span style="font-family: 'Adobe Kaiti Std R', serif;"># http://help.sap.com/saphelp_smehp1/helpdata/en/f3/914f3445194d468f652d45494230b1/content.htm</span><br />
<span style="font-family: 'Adobe Kaiti Std R', serif;"><br /></span><br />
<span style="font-family: 'Adobe Kaiti Std R', serif;"># http://sap.ittoolbox.com/groups/technical-functional/sap-basis/i-am-unable-to-connect-external-mssql-db-to-bw-oracle-10g-server-2294184</span><br />
<span style="font-family: 'Adobe Kaiti Std R', serif;"><br /></span><br />
<span style="font-family: 'Adobe Kaiti Std R', serif;"># http://scn.sap.com/thread/307556</span><br />
<span style="font-family: 'Adobe Kaiti Std R', serif;"><br /></span><br />
<span style="font-family: 'Adobe Kaiti Std R', serif;"># http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/503c4394-cfb6-2e10-349e-85052e8e957d?QuickLink=index&overridelayout=true&52046414000223</span><br />
<span style="font-family: 'Adobe Kaiti Std R', serif;"><br /></span><br />
<span style="font-family: 'Adobe Kaiti Std R', serif;"># http://scn.sap.com/thread/3185151</span><br />
</div>
<div class="MsoListParagraphCxSpFirst" style="margin-left: .75in; mso-add-space: auto; mso-list: l2 level1 lfo4; text-indent: -.25in;">
</div>
</div>Nitin Nayyarhttp://www.blogger.com/profile/16414537983607513424noreply@blogger.com0tag:blogger.com,1999:blog-2031726627669618347.post-64884956461805166932012-06-11T11:07:00.000-07:002012-06-21T09:01:45.607-07:00SAP BI Netweaver 7.3 and SAP BPC 10.0 NW - Step by Step Installation Guide<div dir="ltr" style="text-align: left;" trbidi="on">
Recently setup a Training Box for SAP BI Netweaver 7.3 and SAP BPC 10.0 NW. If you need a step - by - step guide with screen shots on how to setup the SAP System, then please click here<br />
<br />
<a href="https://rapidshare.com/files/3900967825/SAP_BI_Netweaver_7.3_and_SAP_BPC_10.0_NW_-_Step_by_Step_Installation_Guide_.rar" target="_blank">SAP BI Netweaver 7.3 and SAP BPC 10.0 NW - Step by Step Installation Guide</a><br />
<br />
I would really appreciate if you can post your reviews, good or bad.....<br />
<br />
Cheers,<br />
Nitin<br />
<br />
<br /></div>Nitin Nayyarhttp://www.blogger.com/profile/16414537983607513424noreply@blogger.com0tag:blogger.com,1999:blog-2031726627669618347.post-7199337374716386382010-02-25T10:13:00.000-08:002010-02-25T11:52:50.338-08:00Sender email id is invalid or initial, Message Number 813 in SOSTYou have configured RML in SOST. Your user in SU01 has an email ID mentioned and communication type is mentioned as Remote Mail.<div><br /></div><div>But in SOST you get the error message like " Sender email id is invalid or initial." and the Long Text has Message Number 813.</div><div><br /></div><div><b>Solution</b>: There could be other reasons as well, but in my case it was solved as the Remote Mail was not setup for the particular User ID.</div><div><br /></div><div>Go to SU01 and go into change mode of that user. Go to "Other Communication" and select RML and click the tick.</div><div><br /></div><div>There were no entries in the next screen, hence give the System SID, Client, and User ID under Remote Mail, and Click Ok and save the user.</div><div><br /></div><div>Try re-sending the mail in SOST.</div><div><br /></div><div><br /></div>Nitin Nayyarhttp://www.blogger.com/profile/16414537983607513424noreply@blogger.com0tag:blogger.com,1999:blog-2031726627669618347.post-25492233100950187572009-09-07T07:29:00.000-07:002009-09-07T09:08:38.053-07:00. PSAPSR3 is already in backup statusThis error usually occurs when you are running an Online Backup and because of some previous failed backups the table spaces are still under back up status.<br /><br />You need to go to SQL and run the command "alter tablespace PSAPSR3 end backup" for every tablespace that is in backup status.<br /><br />Once done re-run the Online Backup.<br /><br /><em>Please refer to the links & Note below for reference: </em><br /><br /><strong><em>Note:</em></strong> 7490<br /><strong><em>Link:</em> </strong><a href="https://forums.sdn.sap.com/message.jspa?messageID=5583428">https://forums.sdn.sap.com/message.jspa?messageID=5583428</a><br /><strong><em>Link:</em> </strong><a href="https://forums.sdn.sap.com/thread.jspa?messageID=7841400#7841400">https://forums.sdn.sap.com/thread.jspa?messageID=7841400#7841400</a><br /><br /><span style="color:#999900;"># Please spare some time to put a comment, if this post was relevant for you or not. It helps me post better content.</span>Nitin Nayyarhttp://www.blogger.com/profile/16414537983607513424noreply@blogger.com1tag:blogger.com,1999:blog-2031726627669618347.post-91411461568878814002009-07-17T06:46:00.000-07:002009-07-18T08:01:53.352-07:00. Debug timeout parameter<span style=";font-family:georgia;font-size:100%;" >The parameter for this is " rdisp/max_debug_lazy_time " the default value for which is 600 seconds.<br /><br />You can change it dynamically i.e. it shall take effect without a re-start. It should be set as dynamically switchable via RZ11 -> just enter the parameter press change value -> enter new value and save.<br /><br />Please do remember that changes done via RZ11 are temporary and they will be gone when the system is restarted.<br /><br />You can also refer to the SAP Note : 321488 - Handling debugging sessions<br /><br /><span style="color: rgb(153, 153, 0);"># Please spare some time to put a comment, if this post was relevant for you or not. It helps me post better content.</span><br /></span><span style=";font-family:georgia;font-size:100%;" ><span><span><a href="http://help.sap.com/saphelp_nw04/helpdata/en/2b/d925bf4b8a11d1894c0000e8323c4f/frameset.htm" target="_parent"><span style="color: rgb(153, 153, 0);"><br /></span></a></span></span></span>Nitin Nayyarhttp://www.blogger.com/profile/16414537983607513424noreply@blogger.com2tag:blogger.com,1999:blog-2031726627669618347.post-32003432928562648032009-07-16T04:43:00.000-07:002009-07-18T08:02:50.272-07:00. Creating BC Sets / Creating Business Configuration Sets<span style=";font-family:georgia;font-size:100%;" >Customizing settings can be collected by processes into Business Configuration Sets (BC Sets). BC Sets make Customizing more transparent by documenting and analyzing the Customizing settings. They can also be used for a group rollout, where the customizing settings are bundled by the group headquarters and passed on in a structured way to its subsidiaries.<br /><br />BC Sets are provided by SAP for selected industry sectors, and customers can also create their own.<br /><br />When a BC Set is created, values and combinations of values are copied from the original Customizing tables into the BC Set and can be copied into in the tables, views and view clusters in the customer system. The BC Sets are always transported into the customer system in which Customizing is performed.<br /><br />Please refer to the link for complete details on setting up BC Sets :<br /><br /><span style="font-size:85%;"><a href="http://help.sap.com/saphelp_nw04/Helpdata/EN/cd/a22237406d183fe10000009b38f889/content.htm">http://help.sap.com/saphelp_nw04/Helpdata/EN/cd/a22237406d183fe10000009b38f889/content.htm</a></span></span><span><span><br /><br /></span></span><span style=";font-family:georgia;font-size:100%;" ><span style="color: rgb(153, 153, 0);"># Please spare some time to put a comment, if this post was relevant for you or not. It helps me post better content</span></span>Nitin Nayyarhttp://www.blogger.com/profile/16414537983607513424noreply@blogger.com0tag:blogger.com,1999:blog-2031726627669618347.post-56971879978889877132009-07-15T04:01:00.000-07:002009-07-18T08:03:06.934-07:00. Item does not match schedule line ( program error ) message no . V1427You will find may notes that can be applied up till version 4.6c . But for versions after that you can refer to the SDN forum link where I had a similar Query discussed.<br /><br />Notes for versions 4.6c and before are also mentioned under the link.<br /><a href="https://forums.sdn.sap.com/thread.jspa?messageID=7852907&#7852907"><br />https://forums.sdn.sap.com/thread.jspa?messageID=7852907&#7852907</a><br /><br /><span style=";font-family:georgia;font-size:100%;" ><span style="color: rgb(153, 153, 0);"># Please spare some time to put a comment, if this post was relevant for you or not. It helps me post better content</span></span>Nitin Nayyarhttp://www.blogger.com/profile/16414537983607513424noreply@blogger.com0tag:blogger.com,1999:blog-2031726627669618347.post-43979281662536699792009-06-21T11:38:00.000-07:002009-07-18T08:03:24.468-07:00. Error: Status of email is "In transit"Please refer to the following links. They helped me clear out the errors.<br /><br />1. <a href="https://www.sdn.sap.com/irj/scn/thread?threadID=1369013">https://www.sdn.sap.com/irj/scn/thread?threadID=1369013</a><br /><br />2. <a href="http://sap.ittoolbox.com/groups/technical-functional/sap-basis/email-status-in-transit-2043554">http://sap.ittoolbox.com/groups/technical-functional/sap-basis/email-status-in-transit-2043554</a><span><br /><br /></span><span style=";font-family:georgia;font-size:100%;" ><span style="color: rgb(153, 153, 0);"># Please spare some time to put a comment, if this post was relevant for you or not. It helps me post better content</span></span>Nitin Nayyarhttp://www.blogger.com/profile/16414537983607513424noreply@blogger.com0tag:blogger.com,1999:blog-2031726627669618347.post-13608236401296668152009-06-21T11:26:00.000-07:002009-07-18T08:04:41.744-07:00. How to Configure email in SAP<span style=";font-family:georgia;font-size:100%;" ><span style="font-weight: bold;">Use:</span><br /><br />If you want to distribute business intelligence content using e-mail, you have to set up the mail server in the SAP Web Application Server.<br /><br /><span style="font-weight: bold;">Procedure:</span><br /><br />1. In the BW system, choose the transaction SAPconnect: Administration (system status) (transaction SCOT).<br /><br />2. Check the status of the node SMTP (Simple Mail Transfer Protocol):<br /><br />3. The node SMTP does not exist:<br /><br />4. To create the node, in the menu, choose Node ® Create. Specify a node ID and a description.<br /><br />5. The node SMTP is not active:<br /><br />6. To activate the node, in the menu, choose Node ® Change. Select the field Node in Operation.<br /><br />7. In the menu, choose Node ® Change. The screen SAPconnect: General Node Data opens. Ensure that the following values are defined:<br /><br />8. Mail Host: for example, mailto.wdf.sap.corp (localhost is generally not a valid mail host because both a mail server and SAP Application Server are generally not installed on a PC at the same time)<br /><br /><span style="font-weight: bold;">a.</span> Mail Port: Standard value for SMTP is 25<br /><br /><span style="font-weight: bold;">b.</span> Code page: Standard values are 1100 or 1140<br /><br /><span style="font-weight: bold;">c. </span>Supported address types<br /><br />9. Select the Internet field and choose Setup. The screen SAPconnect: Address Type for Node opens. Enter * in the address area.<br /><br />10. To maintain the standard domain, in the menu, choose Settings ® Default Domain and enter the appropriate value (for example, sap.com for e-mail addresses, such as @sap.com).<br /><br /><span style="font-weight: bold;">See also:</span></span><br /><p style="font-weight: bold;font-family:georgia;" class="MsoNormal"><span style="font-size:100%;"><span style=""><a href="http://help.sap.com/saphelp_nw04/helpdata/en/2b/d925bf4b8a11d1894c0000e8323c4f/frameset.htm" target="_parent">SAPconnect (BC-SRV-COM)</a></span></span></p><h2 face="georgia" style="font-weight: bold;"><a href="http://help.sap.com/saphelp_nw04/helpdata/en/44/5b2341144ba52fe10000000a155106/content.htm"><span style=""><span style="font-size:100%;"><span style="font-weight: normal;">Monitoring the Sending of E-mails</span></span></span></a></h2><h2><a href="http://basisfaqs.blogspot.com/2009/06/error-status-of-email-is-in-transit.html"><span style="font-weight: bold;font-family:georgia;" ><span style="font-weight: normal;font-size:100%;" >Error: Status of the messages is showing as "In transit"</span></span></a><br /><span style="text-decoration: underline;"></span></h2><span style=";font-family:georgia;font-size:100%;" ><span style="color: rgb(153, 153, 0);"># Please spare some time to put a comment, if this post was relevant for you or not. It helps me post better content</span></span>Nitin Nayyarhttp://www.blogger.com/profile/16414537983607513424noreply@blogger.com0tag:blogger.com,1999:blog-2031726627669618347.post-77966340918049557772009-06-17T00:44:00.000-07:002009-06-17T00:51:12.613-07:00-104: DBM command impossible at this time<span style="font-weight: bold;">Reason for error:<br /><br /></span>You have attempted to execute a database management statement. You cannot execute this statement if another database statement is already running.<span style="font-weight: bold;"><br /><br />Solution:<br /></span><br />Execute the statement later.<br /><br /><br /><span style="color: rgb(153, 153, 0);"># Please spare some time to put a comment, if this post was relevant for you or not. It helps me post better content.</span>Nitin Nayyarhttp://www.blogger.com/profile/16414537983607513424noreply@blogger.com0tag:blogger.com,1999:blog-2031726627669618347.post-46828212299421547652009-06-12T06:23:00.000-07:002009-06-17T00:40:52.223-07:00. Configuring the Sender RFC Adapter / How to Register Server Program ID<div style="text-align: left;">So here we go, basically we have to configure 2 things:<br /></div><span style=";font-family:georgia;font-size:100%;" >a) RFC destination</span><br /><span style=";font-family:georgia;font-size:100%;" >b) RFC channel in the XI directory<br /></span><br /><span style=";font-family:georgia;font-size:100%;" ><span style="font-weight: bold;">RFC destination:</span><br />1. To create the RFC go to TCODE: SM59<br />2. Create new destination of type T (TCP/IP)<br />3. Select <b>Registered Server Program</b> option before writing your program ID<br />4. Write you program ID (remember it's case-sensitive)<br />5. In the <b>gateway host</b> and <b>gateway service</b> write the values of your "Application system" - business system <b>(not the XI server)<br /></b><br /><img src="https://weblogs.sdn.sap.com/weblogs/images/34500/RFC_T_connection.JPG" alt="image" width="540" border="0" height="309" /><br />6. No configuration in the J2EE administrator nessecary<br /><br />Now we can proceed to RFC channel configuration:<br />1. Enter your Application Server<br />2. Your Application Server Service<br />3. Enter your Program ID from the RFC destination<br /><br /><img src="https://weblogs.sdn.sap.com/weblogs/images/34500/connection_t_type.JPG" alt="image" width="451" border="0" height="325" /><br /><br />Now you can test the RFC destination in SM59 to see if it works.<br /><br />Also check notes : 353597 & 63930<br />Further Reading:<br />1. <a href="http://help.sap.com/saphelp_nw04/helpdata/en/25/76cd3bae738826e10000000a11402f/content.htm" target="_top">RFC Processing with the RFC Adapter - help.sap.com</a><br />2. <a href="http://help.sap.com/saphelp_nw04/helpdata/en/67/6d0540ba5ee569e10000000a155106/content.htm" target="_top">Configuring the Sender RFC Adapter - help.sap.com</a><br /><br /></span><span style="color: rgb(153, 153, 0);"># Please spare some time to put a comment, if this post was relevant for you or not. It helps me post better content.</span>Nitin Nayyarhttp://www.blogger.com/profile/16414537983607513424noreply@blogger.com0tag:blogger.com,1999:blog-2031726627669618347.post-77557270704811698982009-06-07T09:28:00.000-07:002009-06-17T00:40:23.412-07:00. How to Raise an Event from Unix / How to trigger an Event in SAP<span style="font-style: italic;">An SAP event is a "flag" that is created in SAP (SM62). This event (or flag) can be triggered (from a Unix job to an incoming file), causing a job to execute in the background. This event (or flag) can be triggered within R/3 or can be done at the Unix level.</span><br /><br />* First, create an event in SM62. It’s easy - just create it under "user event names" and "maintain". You’ll find the create option from there.<br /><br />* Once created go to SM36 and create the job. Put in the job name you want to call it - fill in the ABAP/4 program you’ll want executed, but under "START DATE" select option AFTER EVENT. Then plug in your SAP event name you created. Fill in the remaining information on this screen and save.<br /><br />* Once saved, an entry is put in table BTCEVTJOB. The entry is the name of the event you raised. This is the system’s way of keeping track of which jobs are in the queue waiting for an event to occur.<br /><br />* Now, once the event is triggered this newly created job will execute. The event can be triggered via sap (SM64) or at the Unix level.<br /><br /><br /><span style="font-style: italic;">SM64 is pretty self-explanatory. To get the event triggered from Unix:</span><br /><br />* Log into the adm user id at the Unix level and go to directory /usr/sap/SYS/exe/run (there is an alias called 'cdexe' that will get you there)<br /><br />* From there look for an executable called sapevt. Open another Unix window cause now you are going to need to cut and paste.<br /><br />* At the other sap window switch user to the adm user and go to the /usr/sap/SYS/profile directory ('cdpro' is the alias)<br /><br />* Do an "ll | more" and look for the instance profile name (the sapevt executable will want this!) Example: _DVEBMGS00_<br /><br />* Go back to the sapevt window and enter this command to get the event to raise:<br />sapevt -t pf= nr=<br /><br /><span style="font-weight: bold;">* Example:</span> sapevt roberts_test -t pf=/usr/sap/SYS/profile/<br />_DVEBMGS00_ nr=00<br /><br />* This will raise the event, and cause the job scheduled within SAP to execute.<br /><br />* Once the job has executed the SAP event that was in the table BTCEVTJOB will disappear.<br /><br />*Another table, TABTCO, will now have an entry in it with the SAP job that was executed. Once you’ve found that job name in this table you can double click on its entry and see that it was executed via an event.<br /><br /><span style="color: rgb(153, 153, 0);"># Please spare some time to put a comment, if this post was relevant for you or not. It helps me post better content.</span>Nitin Nayyarhttp://www.blogger.com/profile/16414537983607513424noreply@blogger.com2tag:blogger.com,1999:blog-2031726627669618347.post-31031768369062250432009-06-07T08:31:00.000-07:002009-06-07T09:06:03.284-07:00. What is an Index / Creating an Index in SAP<span style=";font-family:Arial;font-size:100%;" >You can search a table for data records that satisfy certain search criteria faster using an index.</span><p style="font-family:georgia;"><span style="font-size:100%;">An index can be considered a copy of a database table that has been reduced to certain fields. This copy is always in sorted form. Sorting provides faster access to the data records of the table, for example using a binary search. The index also contains a pointer to the corresponding record of the actual table so that the fields not contained in the index can also be read.</span></p><p style="font-family:georgia;"><span style="font-size:100%;">The primary index is distinguished from the secondary indexes of a table. The <b>primary index</b> contains the key fields of the table and a pointer to the non-key fields of the table. The primary index is created automatically when the table is created in the database.</span></p><p style="font-family:georgia;"><span style="font-size:100%;">Table SCOUNTER in the </span><span style="font-size:100%;"><a href="http://help.sap.com/saphelp_nw04/helpdata/en/cf/21f304446011d189700000e8322d00/frameset.htm" target="_parent"> flight model</a></span><span style="font-size:100%;"> contains the assignment of the carrier counters to airports. The primary index on this table therefore consists of the key fields of the table and a pointer to the original data records.</span></p><p><br /></p><p><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVylwGJwgaYOwoYnNNaQWi3E8P24nZ7Luc_iruqJdPJQeLuGfovQVIzdOyrE1RsCQvEwo87g_osJLIbgg0YFYLm7vb-h3WBfI_hWqmsOkMOBWHPJGTld6JOiKMTii3qWjHmEAc9GqsmoM/s1600-h/Index_1.jpg"><img style="cursor: pointer; width: 400px; height: 264px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVylwGJwgaYOwoYnNNaQWi3E8P24nZ7Luc_iruqJdPJQeLuGfovQVIzdOyrE1RsCQvEwo87g_osJLIbgg0YFYLm7vb-h3WBfI_hWqmsOkMOBWHPJGTld6JOiKMTii3qWjHmEAc9GqsmoM/s400/Index_1.jpg" alt="" id="BLOGGER_PHOTO_ID_5344612776338723010" border="0" /></a></p><p><br /></p><p style="font-family:georgia;"><span style="font-size:100%;">You can also create further indexes on a table in the ABAP Dictionary. These are called <b>secondary indexes</b>. This is necessary if the table is frequently accessed in a way that does not take advantage of the sorting of the primary index for the access. Different indexes on the same table are distinguished with a three-place </span> <span style="font-size:100%;"><a href="http://help.sap.com/saphelp_nw04/helpdata/en/2a/3ff553cdfe11d1951100a0c929b3c3/content.htm"> <span style="">index identifier</span></a></span><span style="font-size:100%;">.</span></p><p style="font-family:georgia;"><span style="font-size:100%;">All the counters of carriers at a certain airport are often searched for flight bookings. The airport ID is used to search for counters for such an access. Sorting the primary index is of no use in speeding up this access. Since table SCOUNTER has a large number of entries, a secondary index on the field AIRPORT (ID of the airport) must be created to support access using the airport ID.</span></p><p><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYS78yHXz17qLgw4_sg7gbTd27EkIlNChHAvwwEkfmVbG8PowomMdF8GUXu5o94ovPAm68J7Be_dT3Ez1Tzrv8vYJtq7q8ua7BhGG9Ec9jYk6tXml_LWZ8lVE4clt4Molbapi2C-9aBU8/s1600-h/Index_2.jpg"><img style="cursor: pointer; width: 400px; height: 242px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYS78yHXz17qLgw4_sg7gbTd27EkIlNChHAvwwEkfmVbG8PowomMdF8GUXu5o94ovPAm68J7Be_dT3Ez1Tzrv8vYJtq7q8ua7BhGG9Ec9jYk6tXml_LWZ8lVE4clt4Molbapi2C-9aBU8/s400/Index_2.jpg" alt="" id="BLOGGER_PHOTO_ID_5344613300959553922" border="0" /></a></p><p style="font-family:georgia;"><span style="font-size:100%;">The optimizer of the database system decides whether an index should be used for a concrete table access (see </span> <span style="font-size:100%;"><a href="http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eb3a446011d189700000e8322d00/content.htm"> <span style="">How to Check if an Index is Used?</span></a></span><span style="font-size:100%;">). This means that an index might only result in a gain in performance for certain database systems. You can therefore define the database systems on which an index should be created when you define the index in the ABAP Dictionary (see </span> <span style="font-size:100%;"><a href="http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eb47446011d189700000e8322d00/content.htm"> <span style="">Creating Secondary Indexes</span></a></span><span style="font-size:100%;">.)</span></p><p style="font-family:georgia;"><span style="font-size:100%;">All the indexes existing in the ABAP Dictionary for a table are normally created in the database when the table is created if this was not excluded in the index definition for this database system.</span></p><p style="font-family:georgia;"><span style="font-size:100%;">If the index fields have key function, that is if they already uniquely identify each record of the table, an index can be defined as a </span> <span style="font-size:100%;"><a href="http://help.sap.com/saphelp_nw04/helpdata/en/9b/c743f5b40711d194f900a0c929b3c3/content.htm"> <span style="">unique index</span></a></span><span style="font-size:100%;">.</span></p> <p style="font-family:georgia;"><span style="font-size:100%;"><b><span style="color: rgb(0, 0, 128);">See also:</span></b></span> <span style="font-size:100%;"><a href="http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eb2d446011d189700000e8322d00/content.htm"> <span style="">What to Keep in Mind when Creating Secondary Indexes</span></a><br /></span></p><p style="font-family:georgia;"><br /></p><p style="font-family:georgia;"><span style="font-size:100%;"><span style="font-weight: bold;">Other Reference Links:</span></span><br /></p><p face="georgia">http://www.sap-img.com/business/what-is-meant-by-primary-index-and-secondary-index.htm</p><p style="font-family: georgia;">http://sap.ittoolbox.com/groups/technical-functional/sap-basis/how-to-create-index-in-abap-dictionary-in-sap-1089196</p><p style="font-family: georgia;"><span style="color: rgb(153, 153, 0);"><br /></span></p><p style="font-family: georgia;"><span style="color: rgb(153, 153, 0);"># Please spare some time to put a comment, if this post was relevant for you or not. It helps me post better content.</span></p> <span style=";font-family:Arial;font-size:100%;" > </span><p face="georgia"><br /><span style="font-size:100%;"><a href="http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eb2d446011d189700000e8322d00/content.htm"><span style=""></span></a></span></p>Nitin Nayyarhttp://www.blogger.com/profile/16414537983607513424noreply@blogger.com0tag:blogger.com,1999:blog-2031726627669618347.post-28924540029434280042009-06-02T04:35:00.000-07:002009-06-07T09:20:17.293-07:00. SAP events transaction code<span style="font-family: georgia;font-size:100%;" >All the SAP events are mentioned in the transaction Code SM64.<br /><br /></span><span style="color: rgb(153, 153, 0); font-family: georgia;font-size:100%;" ># Please spare some time to put a comment, if this post was relevant for you or not. It helps me post better content.</span>Nitin Nayyarhttp://www.blogger.com/profile/16414537983607513424noreply@blogger.com0tag:blogger.com,1999:blog-2031726627669618347.post-54043974905309831602009-05-18T02:28:00.000-07:002009-05-19T00:06:47.348-07:00. Short Dump STRING_OFFSET_TOO_LARGE<span style=";font-family:georgia;font-size:100%;" ><span style="font-weight: bold;">ABAP Short Dump:</span><br /><br />Runtime Errors: STRING_OFFSET_TOO_LARGE<br />Exception: CX_SY_RANGE_OUT_OF_BOUNDS<br />Program: SAPLSBSP_URL_GENERATION<br /><br /><span style="font-weight: bold;">Keywords: </span><br /><br />"STRING_OFFSET_TOO_LARGE" "CX_SY_RANGE_OUT_OF_BOUNDS"<br />"SAPLSBSP_URL_GENERATION" or "LSBSP_URL_GENERATIONU01"<br />"BSP_URL_GENERATION"<br /><br /><span style="font-weight: bold;">What happened?</span><br /><br />"Error in the ABAP Application Program<br /><br />The current ABAP program "SAPLSBSP_URL_GENERATION" had to be terminated because<br />it has come across a statement that unfortunately cannot be executed."<br /><br /><span style="font-weight: bold;">Solution: </span>I think this error is situational. For me this error came at a time when I was also facing the below error on the url.<br /><br /><br /></span><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOGUPunFAvOWj49HR7diCnh_3JATOWa26VShceA_8ws7wwBJda8xOqiR4CwL_WKPNphzgDvS2yAeQiXdcRrCyT6AF1iGlmeOkvf3oYZsb7yS7XjlO2VvOiz6C6DomPoYK6O4r2a3ydVHk/s1600-h/temp.jpg"><img style="cursor: pointer; width: 347px; height: 279px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOGUPunFAvOWj49HR7diCnh_3JATOWa26VShceA_8ws7wwBJda8xOqiR4CwL_WKPNphzgDvS2yAeQiXdcRrCyT6AF1iGlmeOkvf3oYZsb7yS7XjlO2VvOiz6C6DomPoYK6O4r2a3ydVHk/s400/temp.jpg" alt="" id="BLOGGER_PHOTO_ID_5337095862651946690" border="0" /></a><br /><br />Check the status of ICM under tcode : SMICM<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjAF6Z-0y1PPzyUN65psECrQZQmSOZMq4zHVrHXI0tsKVjF8f5UlC6hkvkMVXNiiu_yXsrqa2-CNXm-bYxZkMnJUTFQqfUQg3tru1qWxG0exYcDTWu_dLns7mOrV-wXuKU2HgPA9_onQH8/s1600-h/temp2.jpg"><img style="cursor: pointer; width: 400px; height: 243px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjAF6Z-0y1PPzyUN65psECrQZQmSOZMq4zHVrHXI0tsKVjF8f5UlC6hkvkMVXNiiu_yXsrqa2-CNXm-bYxZkMnJUTFQqfUQg3tru1qWxG0exYcDTWu_dLns7mOrV-wXuKU2HgPA9_onQH8/s400/temp2.jpg" alt="" id="BLOGGER_PHOTO_ID_5337096342374027506" border="0" /></a><br /><br />If this is under maintenance mode as in the screen shot. Then you need to change it back to Running. But before changing it please make sure from the relevant stake holders that might be involved why this was done and if you can change it back to Running.<br /><span style=";font-family:georgia;font-size:100%;" ><br /></span><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuVojdFPhVEC-QCcHWNMvQul6fwNPkAZT6mpu6L19JfbAfV_BEV9iyzTylCXKEBPwND7TpHaXQNp1m3-Utk4mOuzcEjS_I0ePlbeXc1LTEUfwzLqeVJWZMzrN6hpeJT1_GiARSK3QfCmk/s1600-h/temp3.jpg"><img style="cursor: pointer; width: 400px; height: 116px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuVojdFPhVEC-QCcHWNMvQul6fwNPkAZT6mpu6L19JfbAfV_BEV9iyzTylCXKEBPwND7TpHaXQNp1m3-Utk4mOuzcEjS_I0ePlbeXc1LTEUfwzLqeVJWZMzrN6hpeJT1_GiARSK3QfCmk/s400/temp3.jpg" alt="" id="BLOGGER_PHOTO_ID_5337097390566418514" border="0" /></a><br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEijVoP4fePQ1dK8bm29nJSjShK-aTFQDFavTnNH8hDy5_gJEk6jkHfYRWEmAjXiuUtCFAAfm4TB-eACR6eAUIWfgHEN7D6lMUs-e-Pan7l82HhLngTmbHOd1xI54Vnrjap3amJzyRKqUxM/s1600-h/temp4.jpg"><img style="cursor: pointer; width: 400px; height: 239px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEijVoP4fePQ1dK8bm29nJSjShK-aTFQDFavTnNH8hDy5_gJEk6jkHfYRWEmAjXiuUtCFAAfm4TB-eACR6eAUIWfgHEN7D6lMUs-e-Pan7l82HhLngTmbHOd1xI54Vnrjap3amJzyRKqUxM/s400/temp4.jpg" alt="" id="BLOGGER_PHOTO_ID_5337102321659496770" border="0" /></a><br /><br /><span style="color: rgb(153, 153, 0);"># Please spare some time to put a comment, if this post was relevant for you or not. It helps me post better content.<br /></span>Nitin Nayyarhttp://www.blogger.com/profile/16414537983607513424noreply@blogger.com0tag:blogger.com,1999:blog-2031726627669618347.post-36676890819328882642009-05-15T06:03:00.000-07:002009-05-18T02:55:33.650-07:00. Processing multiple Blocked Queues togetherYou can use these programs with help from Basis.<br /><br />RSQOWKEX for Outbound<br />RSQIWKEX for Inbound<br /><br /><span style="color: rgb(153, 153, 0);"># Please spare some time to put a comment, if this post was relevant for you or you still need help. We shall reply to your queries.</span>Nitin Nayyarhttp://www.blogger.com/profile/16414537983607513424noreply@blogger.com0tag:blogger.com,1999:blog-2031726627669618347.post-83906838723443100792009-05-06T03:39:00.000-07:002009-05-06T03:50:47.819-07:00. Error Message : Process cancelled by user<span style="font-weight: bold;">Message Number : 0K415</span><br /><br />Some times you have problems printing some reports. You might get the message "Process cancelled by user", just after you click to print.<br /><br />Follow the below steps to solve the problem.<br />Please note that this solution is at specific user level. It won't solve the problem for all the users. Any user who is having this problem shall have to follow this solution specifically.<br /><br />1. Generate the report.<br />2. Go to Menu- List -> Print<br />3. Select the Output Device.<br />4. Select the Number of Copies & Pages.<br />5. Go to Properties -> Specifications<br />6. You shall see that " Field Default Value" has the printer that you selected.<br />7. Click on Copy Settings.<br />8. Once you click Copy, the Printer is added in the fields below.<br />9. Click ok to everything.<br />10. This time when you click ok, you shall receive the same message again. Print again and the error won't come again.<br /><br /><span style="color: rgb(153, 153, 0);"># Please spare some time to put a comment, if this post was relevant for you or you still need help. We shall reply to your queries.</span>Nitin Nayyarhttp://www.blogger.com/profile/16414537983607513424noreply@blogger.com6tag:blogger.com,1999:blog-2031726627669618347.post-16854732035544019322009-05-03T01:56:00.002-07:002009-05-03T02:18:46.745-07:00. Short Dump SNAP_NO_NEW_ENTRY<span style="font-family:georgia;">What to do when you get ABAP runtime error SNAP_NO_NEW_ENTRY </span><br /><span style="font-family:georgia;"><br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgA54Rg-URyhbi2lVFoHK4TAcUlYXx0CJdpv9nbFwXU1uSFzF0wZSmmUp-FFHcfIj0j7jXgOmE3cUEtOPvC64CwSfHE-lu7fsLDmJVwACd-aGgSkzsx5Aw4XepmLM3bK4GlsO0enXaEpZA/s1600-h/1.jpg"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_F6Xr6gNLBw9_LNXyjqg9A4hs-c97z5eO8X1EP_7jOAU9n-qNmfvKfCFk5fJJ4mcc_EOV0HvL4tsd6nWNOWjsnzjY8z9GbipQ4-ytO1UwuHKHktBmshXb5QZdC2GaP5oW1B6XGH8Tveg/s1600-h/1.jpg"><img id="BLOGGER_PHOTO_ID_5331522389340225810" style="WIDTH: 400px; CURSOR: hand; HEIGHT: 314px" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_F6Xr6gNLBw9_LNXyjqg9A4hs-c97z5eO8X1EP_7jOAU9n-qNmfvKfCFk5fJJ4mcc_EOV0HvL4tsd6nWNOWjsnzjY8z9GbipQ4-ytO1UwuHKHktBmshXb5QZdC2GaP5oW1B6XGH8Tveg/s400/1.jpg" border="0" /></a><br /><br />This dump arises when the SNAP table that loads all the records of short dumps reaches a bottleneck..<br /><br /><strong>Solution:</strong><br />Go to transaction: ST22.<br />Goto ->Reorganise</span><br /></span><br /><span style="font-family:georgia;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgo7xwp_kDhwVpVXZrnhuX60tndVGkrPME_4vmy7uxZwxXizAAscby704z2170rQzmnbPNVMWneZIyS6VWzvZOFoIeFyZz8w9eJSMOCkwSQH2he90cs289mLskLIkMQ2OG7uvPH2k-2SYo/s1600-h/2.jpg"><img id="BLOGGER_PHOTO_ID_5331521385760678594" style="WIDTH: 400px; CURSOR: hand; HEIGHT: 268px" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgo7xwp_kDhwVpVXZrnhuX60tndVGkrPME_4vmy7uxZwxXizAAscby704z2170rQzmnbPNVMWneZIyS6VWzvZOFoIeFyZz8w9eJSMOCkwSQH2he90cs289mLskLIkMQ2OG7uvPH2k-2SYo/s400/2.jpg" border="0" /></a></span><br /><br /><span style="font-family:georgia;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjw1rRAek1to52-7YOegqSd4c_xjMQUl1Rn5I4rtYsW2rqFmtcRlKBbO4wWNCn2ob1jGNkJ-MVCWRtaipIROS7M4DZfa_QS6u-iNtl3oQZkpeEqvxrX4bzJ4YHRKNK7nwuqBE2nywbCOl4/s1600-h/3.jpg"><img id="BLOGGER_PHOTO_ID_5331521383660887490" style="WIDTH: 324px; CURSOR: hand; HEIGHT: 171px" alt="" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjw1rRAek1to52-7YOegqSd4c_xjMQUl1Rn5I4rtYsW2rqFmtcRlKBbO4wWNCn2ob1jGNkJ-MVCWRtaipIROS7M4DZfa_QS6u-iNtl3oQZkpeEqvxrX4bzJ4YHRKNK7nwuqBE2nywbCOl4/s400/3.jpg" border="0" /></a></span><br /><br /><span style="color:#999900;"># Please spare some time to put a comment, if this post was relevant for you or you still need help. We shall reply to your queries.</span>Nitin Nayyarhttp://www.blogger.com/profile/16414537983607513424noreply@blogger.com2tag:blogger.com,1999:blog-2031726627669618347.post-88189050967686707642009-04-23T23:22:00.000-07:002009-04-24T00:09:18.294-07:00. Different BRRESTORE Commands<span style=";font-family:georgia;font-size:100%;" >Different Options in BRRESTORE<br /><br />1.<span style="font-weight: bold;"> brrestore -b last -m all</span><br />Restore all tablespaces without the control file and online redo log files, starting from the last successful backup.<br /><br />2. <span style="font-weight: bold;">brrestore -b bcnmhluz.aft -m full</span><br />Restore all the files from backup bcnmhluz.aft , including the control file and the online redo log files. Restore the mirror copies of the control file and the online redo log files.<br /><br />3. <span style="font-weight: bold;">brrestore -m /usr/sap/C11/SYS/profile</span><br />Restore the SAP profiles.<br /><br />4. <span style="font-weight: bold;">brrestore -m /usr/sap/C11/SYS/exe/run:sapdba</span><br />Restore the SAPDBA executable.<br /><br />5. <span style="font-weight: bold;">brrestore -m /oracle/C11/sapdata1=/oracle/C11/sapdata5</span><br />Restore all the database data files that were originally stored in the subdirectories of /oracle/C11/sapdata1 in directory /oracle/C11/sapdata5 .<br /><br />6. <span style="font-weight: bold;">brrestore -b last -m 1-10,01-04,0</span><br />Restore all the database data files with ORACLE file IDs from 1 through 10, the four online redo log files, and the control file starting from the last successful backup. Restore the mirror copies of the control file and the online redo log files.<br /><br />7. <span style="font-weight: bold;">brrestore -m 0</span><br />Restore the control file. Restore the mirror copies of the control file.<br /><br />8. <span style="font-weight: bold;">brrestore -b last -m /oracle/C11/sapdata2/ddicd_5/ddicd.data5</span><br />Restore a database data file starting from the last successful backup.<br /><br />9. <span style="font-weight: bold;">brrestore -a 200-220</span><br />Restore the archived redo log files with the log sequence numbers from 200 through 220 into the archiving directory.<br /><br />10. <span style="font-weight: bold;">brrestore -a 40-70=/oracle/C11/sapbackup, 71-90=/oracle/C11/sapreorg</span><br />Restore the archived redo log files with the log sequence numbers from 40 through 70 in directory sapbackup and those with the log sequence numbers from 71 through 90 in directory /oracle/C11/sapreorg .<br /><br />11. <span style="font-weight: bold;">brrestore -a 40-69,70-100=/oracle/C11/sapbackup</span><br />Restore the archived redo log files with the log sequence numbers from 40 through 69 in the archiving directory, and those with the log sequence numbers from 70 through 100 in directory sapbackup .<br /><br />12. <span style="font-weight: bold;">brrestore -n det_log</span><br />Restore a detail log to the local working directory.<br /><br /><br /><span style="color: rgb(153, 153, 0);"># Please spare some time to put a comment, if this post was relevant for you or you still need help. We shall reply to your queries.</span><br /></span>Nitin Nayyarhttp://www.blogger.com/profile/16414537983607513424noreply@blogger.com2tag:blogger.com,1999:blog-2031726627669618347.post-61716417681396032452009-04-08T11:59:00.000-07:002009-04-18T09:28:57.554-07:00. Visitors<span id="fullpost"><span class="newspaper">G</span></span>reetings,<br /><br />It shows that my efforts to promote this blog is not going a waste. I have seen a good inflow of <span style="font-weight: bold; color: rgb(0, 0, 0);">Visitors</span>, some new some returning. Check out from where am I getting my Visitors.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi8FRyH0els_XX9TB-NEia4rFjRj4HjzAPqV2FQrn6QGN-J8PO-PBeJztjhzI0DWF2dDHp-Q83a3hS_khYjGuVoRDS6GiM8SGzJcxm5FuLUNHv9Y81cklMmQ0LyNE9twhCkIFa3j8yERo0/s1600-h/Map.jpg"><img style="cursor: pointer; width: 400px; height: 216px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi8FRyH0els_XX9TB-NEia4rFjRj4HjzAPqV2FQrn6QGN-J8PO-PBeJztjhzI0DWF2dDHp-Q83a3hS_khYjGuVoRDS6GiM8SGzJcxm5FuLUNHv9Y81cklMmQ0LyNE9twhCkIFa3j8yERo0/s400/Map.jpg" alt="" id="BLOGGER_PHOTO_ID_5322402677028806898" border="0" /></a><br />(source- Google Analytics)<br /><br />The posts in my blog are generally issues that I might have faced or some times those which I've found from various sources and found them useful enough.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPoFkvaH_VQffmR4FKj0LjYan4omsBKeLCm5hWKYaiYtaJ4xUFDKtEIqzF2dDlVYBOCEop9gxPGDjZ7G_buKoacnFdUhEm7mCnLbJZ5MhBpVEtYzT_v2woE3M7CRzQmecoQpwV-zhS1Oo/s1600-h/Map2.jpg"><img style="cursor: pointer; width: 400px; height: 220px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPoFkvaH_VQffmR4FKj0LjYan4omsBKeLCm5hWKYaiYtaJ4xUFDKtEIqzF2dDlVYBOCEop9gxPGDjZ7G_buKoacnFdUhEm7mCnLbJZ5MhBpVEtYzT_v2woE3M7CRzQmecoQpwV-zhS1Oo/s400/Map2.jpg" alt="" id="BLOGGER_PHOTO_ID_5322437828289372962" border="0" /></a><br />(source- Google Analytics)<br /><br />I am open to suggestions from all visitors regarding not only the content, but also the layout of my blog. I recently started with an effort to provide <span style="font-weight: bold;"><span style="color: rgb(0, 0, 0);">"Live Support"</span> </span>using <span style="font-weight: bold;">'Gmail'</span><span style="font-weight: bold; color: rgb(0, 0, 0);"> </span>messenger, which is very common amongst you guys. So if you catch me online then <span style="font-weight: bold; color: rgb(0, 0, 0);">"Just Ask"</span> or even e-mail me.<br /><br />If you have something useful to share then do let me know.<br /><br />Thanks again, keep visiting & posting. :)Nitin Nayyarhttp://www.blogger.com/profile/16414537983607513424noreply@blogger.com1tag:blogger.com,1999:blog-2031726627669618347.post-29256871797350043632009-04-08T05:42:00.000-07:002009-04-08T11:59:48.027-07:00. Clearing inbound queue stuck in XI server<span style=";font-family:georgia;font-size:100%;" >1. Go to transaction SMQ2 in XI server for checking inbound queue.<br /><br /></span><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjw2m5SHa_RBgJaWbRKhFf4SZBQuXrHAgzHN-PpwRvpkTb0NyonSqFKxCXDcZPYLfZ32zdJMoKYwopjneBBh7sbNuZaJmAhdtzTbn7dX5uM51FJMTv6JHeUFzcDFjIga_Ej8VF53KzmFbQ/s1600-h/1.jpg"><img style="cursor: pointer; width: 200px; height: 136px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjw2m5SHa_RBgJaWbRKhFf4SZBQuXrHAgzHN-PpwRvpkTb0NyonSqFKxCXDcZPYLfZ32zdJMoKYwopjneBBh7sbNuZaJmAhdtzTbn7dX5uM51FJMTv6JHeUFzcDFjIga_Ej8VF53KzmFbQ/s200/1.jpg" alt="" id="BLOGGER_PHOTO_ID_5322318061696244306" border="0" /></a><br /><span style=";font-family:georgia;font-size:100%;" ><br />2. Click on execute button than you get display the queue.<br /><br /></span><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOMlZgGWDEqFtYOYthXbYwhXozAKxUWIRfkBpbmcao6PgAEFt_GseMwzv_pOmoHTKPHu63thSg9x8aI1HMXhPPUgRZSN8MJGZMi-Hpm7_vxOR-qLW433cYXI-CY7uE3q-JMrrOW5Zx0nA/s1600-h/2.jpg"><img style="cursor: pointer; width: 200px; height: 135px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOMlZgGWDEqFtYOYthXbYwhXozAKxUWIRfkBpbmcao6PgAEFt_GseMwzv_pOmoHTKPHu63thSg9x8aI1HMXhPPUgRZSN8MJGZMi-Hpm7_vxOR-qLW433cYXI-CY7uE3q-JMrrOW5Zx0nA/s200/2.jpg" alt="" id="BLOGGER_PHOTO_ID_5322318176508036130" border="0" /></a><br /><br /><span style=";font-family:georgia;font-size:100%;" >Double click it …select and Click unlock queue button and referesh…<br /><br /></span><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiiBn4iioXkiSeltjayg5k4Yj_WsZULl4Ty5gRDNpCuDcuLQ3sfzZNd0daZ5yAPwCElCNWwVgv-_WxYRjr_xzflKHZ3s8Pg5jmm-YR43KPQ9vDzEGD9hnU66HBJvLNLkTBlmNbUIK8WVKI/s1600-h/3.jpg"><img style="cursor: pointer; width: 200px; height: 135px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiiBn4iioXkiSeltjayg5k4Yj_WsZULl4Ty5gRDNpCuDcuLQ3sfzZNd0daZ5yAPwCElCNWwVgv-_WxYRjr_xzflKHZ3s8Pg5jmm-YR43KPQ9vDzEGD9hnU66HBJvLNLkTBlmNbUIK8WVKI/s200/3.jpg" alt="" id="BLOGGER_PHOTO_ID_5322318289807483890" border="0" /></a><br /><span style=";font-family:georgia;font-size:100%;" ><br />3. after referesh it will be cleared, if not than GO to transaction SXMB_MONI<br /><br /></span><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuuDWcwN3fE85kSjkVhCcoi_BCfJ435FSwLwUdwJTek4Biha2SicxmVOi7tXcbRD8RBACWaKqDKAzLFmFCz9zAQxcDRfCPoNn2gN32fq1ThdeD5gR6bBJB7fR5qc7yWoV3VoB1jSCCAHg/s1600-h/4.jpg"><img style="cursor: pointer; width: 200px; height: 136px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuuDWcwN3fE85kSjkVhCcoi_BCfJ435FSwLwUdwJTek4Biha2SicxmVOi7tXcbRD8RBACWaKqDKAzLFmFCz9zAQxcDRfCPoNn2gN32fq1ThdeD5gR6bBJB7fR5qc7yWoV3VoB1jSCCAHg/s200/4.jpg" alt="" id="BLOGGER_PHOTO_ID_5322318394834657874" border="0" /></a><br /><span style=";font-family:georgia;font-size:100%;" ><br />4. Execute monitoring for processed XML messages.<br /><br />5. Then select ERRORS options from drag box from STATUS GROUP and execute.<br /><br /></span><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhHc6oVTy7BaQb3M5w35ppMr2EDP4_WGFNDqy4AGRJO5_nKQoHXynBKoeJZ8i9NBO-cZCeNAQXaiUdxMxLNQAk4J4JlPHJEBiQldbMA-zRpoFgapHUgn48zyUvPskTTzLx2BBfBYoSxLpE/s1600-h/5.jpg"><img style="cursor: pointer; width: 200px; height: 135px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhHc6oVTy7BaQb3M5w35ppMr2EDP4_WGFNDqy4AGRJO5_nKQoHXynBKoeJZ8i9NBO-cZCeNAQXaiUdxMxLNQAk4J4JlPHJEBiQldbMA-zRpoFgapHUgn48zyUvPskTTzLx2BBfBYoSxLpE/s200/5.jpg" alt="" id="BLOGGER_PHOTO_ID_5322318524081300466" border="0" /></a><br /><br /><span style=";font-family:georgia;font-size:100%;" >6. Select error message and Click on restart button<br /><br /></span><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgyn6DYHudRRPPvR3nhkIx2sADxgI242-ghD_CiI-lyn-5qODRFScdi-9BQ_uDBngy7EUezmoeCO14-LuNUUDK6I79YB2KnGaO0grNMWSDUWCZy-GqG35-HuG_aP5VBGvPbVNcC2JFpvNM/s1600-h/6.jpg"><img style="cursor: pointer; width: 200px; height: 134px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgyn6DYHudRRPPvR3nhkIx2sADxgI242-ghD_CiI-lyn-5qODRFScdi-9BQ_uDBngy7EUezmoeCO14-LuNUUDK6I79YB2KnGaO0grNMWSDUWCZy-GqG35-HuG_aP5VBGvPbVNcC2JFpvNM/s200/6.jpg" alt="" id="BLOGGER_PHOTO_ID_5322318644050939586" border="0" /></a><br /><br /><span style=";font-family:georgia;font-size:100%;" >Click on RETAIN button.<br /><br /></span><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgCJPNsA-aGpnJqsM5TZ9A4J0rSZAzARPbVA3CcdbO-SsVkTSDdpTd-jAImiNDEyVasxvaPjKmC-ux7EeSNQVoMUplU4TBZVvC5C5ej57u-1ONeEl9GdVJLFy9Vabv9x-1x6ppK4qlPYuY/s1600-h/7.jpg"><img style="cursor: pointer; width: 200px; height: 66px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgCJPNsA-aGpnJqsM5TZ9A4J0rSZAzARPbVA3CcdbO-SsVkTSDdpTd-jAImiNDEyVasxvaPjKmC-ux7EeSNQVoMUplU4TBZVvC5C5ej57u-1ONeEl9GdVJLFy9Vabv9x-1x6ppK4qlPYuY/s200/7.jpg" alt="" id="BLOGGER_PHOTO_ID_5322318805537309810" border="0" /></a><br /><span style=";font-family:georgia;font-size:100%;" ><br />7. Error message rescheduled.<br /><br />8. You can check SMQ2 Transaction that inbound queue is clearing in XI Production server.<br /><br /></span><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEij4caZhguhM95FmHv48ZjBW-PZCPOZGbxPVXX0A27FIaCbyWCZ1H-5UjSDx5kyBasR5NaKgSq-Tk4mwcmqi6fcOtNqU0E5TwwrcynLAPoeddzyhqrKNZq-9nUfRnxi4ZgwFDlljKL9_kA/s1600-h/8.jpg"><img style="cursor: pointer; width: 200px; height: 134px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEij4caZhguhM95FmHv48ZjBW-PZCPOZGbxPVXX0A27FIaCbyWCZ1H-5UjSDx5kyBasR5NaKgSq-Tk4mwcmqi6fcOtNqU0E5TwwrcynLAPoeddzyhqrKNZq-9nUfRnxi4ZgwFDlljKL9_kA/s200/8.jpg" alt="" id="BLOGGER_PHOTO_ID_5322319025550258514" border="0" /></a><br /><span style=";font-family:georgia;font-size:100%;" ><br /></span>Nitin Nayyarhttp://www.blogger.com/profile/16414537983607513424noreply@blogger.com0tag:blogger.com,1999:blog-2031726627669618347.post-15605002035969092102009-04-06T01:20:00.000-07:002009-04-08T11:59:02.743-07:00. Using jcmon tool<span style=";font-family:georgia;font-size:100%;" >We are familiar with the dpmon tool which is used for monitoring and administering work processes in an ABAP environment.<br /><br />Similarly we have another tool names Jcmon for the monitoring and administering Java systems from OS level.<br /><br />1. Login to the SAP server using <sid>adm.<br /><br />2. Open the command prompt and launch Jcmon.<br /></sid></span><span style=";font-family:georgia;font-size:100%;" ><sid><br />The command for jcmon in > jcmon pf=<full>"full path of the instance profile file"</full></sid></span><br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhS6pDsyYRDVOXuKhi8JqnTbRQwatS7GaasMY5RzBprlcAXTTVDNNN_YsOBcPuGYVRd6tSgjqszjMd5JxlpUG4foxklj_gQm9nh7UzqY-2tIloiMpNvcQpxHmIYW9pPkDE7BQ6SPwd4OJY/s1600-h/1.jpg"><img style="cursor: pointer; width: 200px; height: 80px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhS6pDsyYRDVOXuKhi8JqnTbRQwatS7GaasMY5RzBprlcAXTTVDNNN_YsOBcPuGYVRd6tSgjqszjMd5JxlpUG4foxklj_gQm9nh7UzqY-2tIloiMpNvcQpxHmIYW9pPkDE7BQ6SPwd4OJY/s200/1.jpg" alt="" id="BLOGGER_PHOTO_ID_5321494123492349634" border="0" /></a><br /><br /><br />3. From the cluster administration you can perform the administering the whole Java system. Similarly from Local Administration you can perform administration of the node in which you are currently connected.<br /><br />4. Go for Cluster Administration (10).<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSzCui0FQjDKq9vARKFK2aZwxNqg5bOe2rt0hY9fn1bPp1Rabyun1DdyEOrT0qtfX0yAzMUUSo5ekbnv7aWHg5BVmZE8qvnFVD2P8DkaSV-k7oSqaaDN9SBcjbKCIoaW0vthZudkO6bhA/s1600-h/2.jpg"><img style="cursor: pointer; width: 200px; height: 168px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSzCui0FQjDKq9vARKFK2aZwxNqg5bOe2rt0hY9fn1bPp1Rabyun1DdyEOrT0qtfX0yAzMUUSo5ekbnv7aWHg5BVmZE8qvnFVD2P8DkaSV-k7oSqaaDN9SBcjbKCIoaW0vthZudkO6bhA/s200/2.jpg" alt="" id="BLOGGER_PHOTO_ID_5321494441428107474" border="0" /></a><br /><br />5. From here you can perform all operation which you can perform from SMICM in a dual stack environment.<br /><br />6. Similarly using Shared Memory Menu you can perform refreshing shared memory etc.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj_aO8lOqYoGoKeySeJ2ITPK1GBWYcX4vkR7xe6GsBFuH43RMgOigqIDupqvjEQLTOMjdYbHfaDWeAwVLlqKCGywTZ1bxk_aw1B_svw0TztxjAGzOzGl-DULXdw_xcOjhcLwtycmB4FzaQ/s1600-h/3.jpg"><img style="cursor: pointer; width: 200px; height: 106px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj_aO8lOqYoGoKeySeJ2ITPK1GBWYcX4vkR7xe6GsBFuH43RMgOigqIDupqvjEQLTOMjdYbHfaDWeAwVLlqKCGywTZ1bxk_aw1B_svw0TztxjAGzOzGl-DULXdw_xcOjhcLwtycmB4FzaQ/s200/3.jpg" alt="" id="BLOGGER_PHOTO_ID_5321494616650947490" border="0" /></a>Nitin Nayyarhttp://www.blogger.com/profile/16414537983607513424noreply@blogger.com0tag:blogger.com,1999:blog-2031726627669618347.post-31876929610405937312009-03-13T04:59:00.000-07:002009-05-02T04:38:41.119-07:00. EarlyWatch - Unformatted VB Run-time error '6068'<span style="font-weight: bold;font-family:georgia;font-size:100%;" >Problem:</span><span style="font-size:100%;"><span style="font-family:georgia;"> "Run-time error '6068” : Programmatic Access to Visual Basic Project is not trusted" while downloading Earlywatch Report from Solman.</span></span><br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEE_JEQ71LQd4C6fA4_OvTPVyCBPOOGVD6-AQwclNo3dVg3cQifTq1lee617MrAwJQhDSrpA-hYA-gqHlxrb_vEwb2diRyYaE6x4Rap4WQtl7Pf4irAQDacZ95FZmPfA5FiwXKcQmvX24/s1600-h/VB+Runtime+error+6068.jpg"><img style="cursor: pointer; width: 400px; height: 234px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEE_JEQ71LQd4C6fA4_OvTPVyCBPOOGVD6-AQwclNo3dVg3cQifTq1lee617MrAwJQhDSrpA-hYA-gqHlxrb_vEwb2diRyYaE6x4Rap4WQtl7Pf4irAQDacZ95FZmPfA5FiwXKcQmvX24/s400/VB+Runtime+error+6068.jpg" alt="" id="BLOGGER_PHOTO_ID_5312641562284157810" border="0" /></a><br /><br /><span style="font-weight: bold;font-size:100%;" >Solution: </span><span style="font-size:100%;"><br />1. Open the Office 2003 or Office XP application in question. On the Tools menu, click Macro, and then click Security to open the Macro Security dialog box.<br />2. On the Trusted Sources tab, click to select the Trust access to Visual Basic Project check box to turn on access.<br />3. Click OK to apply the setting. You may need to restart the application for the code to run properly<br /><br />Refererences: http://support.microsoft.com/kb/282830<br /><br /></span><span style="font-family: georgia; font-size: 100%;"><span style="color: rgb(153, 153, 0);"># Please spare some time to put a comment, if this post was relevant for you or you still need help. We shall reply to your queries.</span></span>Nitin Nayyarhttp://www.blogger.com/profile/16414537983607513424noreply@blogger.com0tag:blogger.com,1999:blog-2031726627669618347.post-17287646361927174422009-03-13T03:58:00.000-07:002009-04-18T07:49:06.266-07:00. Configuring Email Alerts for Backup Jobs<span id="fullpost"><span class="newspaper">F</span></span><span style=";font-family:georgia;font-size:100%;" >or configuring email alerts for Backup Jobs first you need to configure either <span style="font-style: italic;">SQL Mail or Database Mail</span> in SQL Server 2005.<br /><br />Database mail is newly introduced concept in SQL Server 2005 and it is replacement of SQLMail of SQL Server earlier version. Database Mail has many enhancements over SQLMail. We are configuring database mail.<br /><br /><span style="font-style: italic; font-weight: bold;">Configuring Database Mail</span><br /><br />1. Login to SQL Server Management Studio.<br />2. Expand the tree named ‘Management’.<br /></span><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiRWo8thhwLPbJFP7QNIju3v0IvuofGd-2FQKHPfdviKKV5atCnjiqj5lfX5_bSa3lJNTSh9D0egt64yhntcCNFw7u1-2wUMxuJsavfxV9jUmmse5szsSCsmL1aMW7XmWIC3Cif04nEJ7Q/s1600-h/Tree.bmp"><img style="cursor: pointer; width: 257px; height: 127px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiRWo8thhwLPbJFP7QNIju3v0IvuofGd-2FQKHPfdviKKV5atCnjiqj5lfX5_bSa3lJNTSh9D0egt64yhntcCNFw7u1-2wUMxuJsavfxV9jUmmse5szsSCsmL1aMW7XmWIC3Cif04nEJ7Q/s400/Tree.bmp" alt="" id="BLOGGER_PHOTO_ID_5312630301287238610" border="0" /></a><br /><span style=";font-family:georgia;font-size:100%;" ><br />3. Double click on Database mail.<br />4. Select the first option for configuring Mail profile and accounts.<br /></span><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7GmmLoG-BmmCDU2EM-YAfmTBwoR8nd5KNqUV-omtadF07XacLftnzQIK6GJFF77xM_ESi1dZZY4XD1xR7tVTkAMj5UVQ5MJ3fZgVQJfZlBqub4MT8jPBgT6da_JGAW2hEaZ556O9yFrU/s1600-h/1.bmp"><img style="cursor: pointer; width: 400px; height: 347px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7GmmLoG-BmmCDU2EM-YAfmTBwoR8nd5KNqUV-omtadF07XacLftnzQIK6GJFF77xM_ESi1dZZY4XD1xR7tVTkAMj5UVQ5MJ3fZgVQJfZlBqub4MT8jPBgT6da_JGAW2hEaZ556O9yFrU/s400/1.bmp" alt="" id="BLOGGER_PHOTO_ID_5312630734290430738" border="0" /></a><br /><span style=";font-family:georgia;font-size:100%;" ><br />5. Write down Profile Name and Description and click on the Add button for creating new account.<br />6. Fill up the details as seen in the screenshot.<br /></span><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtKNsFy5S2dFCRKi33CdmiDTAK4EKRFNx-APcSHw73F0BsTyZcLtBo_qAcO76dy_PClyBd979LKIYxjlzJeLVqyxn8fjNWwM1zbn1u294gfc-cMmtRZ-OUne5VQ7xArrGDmamKrMa7gyo/s1600-h/2.jpg"><img style="cursor: pointer; width: 400px; height: 349px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtKNsFy5S2dFCRKi33CdmiDTAK4EKRFNx-APcSHw73F0BsTyZcLtBo_qAcO76dy_PClyBd979LKIYxjlzJeLVqyxn8fjNWwM1zbn1u294gfc-cMmtRZ-OUne5VQ7xArrGDmamKrMa7gyo/s400/2.jpg" alt="" id="BLOGGER_PHOTO_ID_5312630908353134834" border="0" /></a><br /><span style=";font-family:georgia;font-size:100%;" ><br />7. Click Next and Finish.<br /><br />Now Database mail has been configured.<br /><br /><span style="font-weight: bold; font-style: italic;">Activation of Database Mail<br /></span>For activation of database mail open a New Query window. Run the following queries.<br /><br /></span><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOHfyE0LhzS75o7IjMkAQQMh-kwdM0cmcIUjzZ3Oug8LTB3pJ9vTlontNrBPhJGsD4OjB_rhkcC5NWOMtIL2ZzLVo2PzDhkpbwoekwKxAKgFmESdUZRDXc5tncwaSkZMO4j7ClUs3AxaA/s1600-h/3.jpg"><img style="cursor: pointer; width: 400px; height: 219px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOHfyE0LhzS75o7IjMkAQQMh-kwdM0cmcIUjzZ3Oug8LTB3pJ9vTlontNrBPhJGsD4OjB_rhkcC5NWOMtIL2ZzLVo2PzDhkpbwoekwKxAKgFmESdUZRDXc5tncwaSkZMO4j7ClUs3AxaA/s400/3.jpg" alt="" id="BLOGGER_PHOTO_ID_5312631461351272434" border="0" /></a><br /><span style=";font-family:georgia;font-size:100%;" ><br /><span style="font-weight: bold; font-style: italic;">Send Test Mail</span><br />For sending Test Mail open a New Query Window. Run the following script.<br /><br /></span><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimvokmRNeeHPnhG0oePo9V1NGVtvB77P0SS7ZG-wtCRmP1qXiDz9cYCwzee-7QiPCwYmEh8dPTJoadTUGeTKJeZz47khkEuAc_YRmMZPwIYtrBsTLxACxM8DDnh4us4lVtbY4cMh4vzRk/s1600-h/4.jpg"><img style="cursor: pointer; width: 400px; height: 208px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimvokmRNeeHPnhG0oePo9V1NGVtvB77P0SS7ZG-wtCRmP1qXiDz9cYCwzee-7QiPCwYmEh8dPTJoadTUGeTKJeZz47khkEuAc_YRmMZPwIYtrBsTLxACxM8DDnh4us4lVtbY4cMh4vzRk/s400/4.jpg" alt="" id="BLOGGER_PHOTO_ID_5312631671451341074" border="0" /></a><br /><span style=";font-family:georgia;font-size:100%;" ><br /><span style="font-weight: bold; font-style: italic;">Check the status of the sent mails</span><br />To check the status of the sent mails run the following queries.<br /><br /><span style="font-style: italic;font-size:85%;" >SELECT *<br />FROM sysmail_mailitems<br />GO<br />SELECT *<br />FROM sysmail_log<br />GO</span><br /><br /><span style="font-weight: bold; font-style: italic;">Configuring Backup Jobs</span><br />Right click to the existing job for which you want to configure the mail alerts and go to the properties.<br /><br />In the Notification tab there is a concept called Email. Don’t get confused, it is only be activated when we configure SQL Mail. As we are using Database mail we have to configure the job in a different way.<br /><br />1. Go to the Step, Click on the New Button.<br /></span><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2jLvc1WRUdwC_NmBeAov12WXBXO8IVWJAU_iNV8_Tv9tO-r-Q7btbAQ5tv-49jhI4ohwcFngIom94Hlg9BK5RHuYybXXB3MZSQ2LhsOpQKJ89-ZDscp0qkno76eghR9sQUjLqd8ZKbOA/s1600-h/5.jpg"><img style="cursor: pointer; width: 400px; height: 359px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2jLvc1WRUdwC_NmBeAov12WXBXO8IVWJAU_iNV8_Tv9tO-r-Q7btbAQ5tv-49jhI4ohwcFngIom94Hlg9BK5RHuYybXXB3MZSQ2LhsOpQKJ89-ZDscp0qkno76eghR9sQUjLqd8ZKbOA/s400/5.jpg" alt="" id="BLOGGER_PHOTO_ID_5312631881823267986" border="0" /></a><br /><br /><span style=";font-family:georgia;font-size:100%;" >2. Add the New step as described below. (Change the system Name and Description accordingly.)<br /></span><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiEnu4eg9_cSQ4BtWTFgi5zvycBAszv5-HMhRGwDvCAaegZmB-Vk1OMsipYnAy1EfovYpDzaXXkM3pAKDMOEmH-s35iLiVRsWU0O0OQkFllYVo7S98w529mX_eQQ20tWKmt967x2NIsdjg/s1600-h/6.jpg"><img style="cursor: pointer; width: 400px; height: 358px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiEnu4eg9_cSQ4BtWTFgi5zvycBAszv5-HMhRGwDvCAaegZmB-Vk1OMsipYnAy1EfovYpDzaXXkM3pAKDMOEmH-s35iLiVRsWU0O0OQkFllYVo7S98w529mX_eQQ20tWKmt967x2NIsdjg/s400/6.jpg" alt="" id="BLOGGER_PHOTO_ID_5312632059348677746" border="0" /></a><br /><br /><span style=";font-family:georgia;font-size:100%;" >3. Now go back to the original Job step and open it in the edit mode.<br /></span><span style=";font-family:georgia;font-size:100%;" >4. Go to the advanced tab.<br /></span><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLykdFB11Z__KaOCLSe1Z4sspQVqfMdDkffBIXQVjF6LbF8SpYCeGgAxOUM9mxswJoPfVeyGpnLYjWnqaFsR2Bxda24WVUUAvPFunnMBzO1tKxiRlFLNPWHGRujUNfr1PkynLrFrP9wgQ/s1600-h/7.jpg"><img style="cursor: pointer; width: 400px; height: 362px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLykdFB11Z__KaOCLSe1Z4sspQVqfMdDkffBIXQVjF6LbF8SpYCeGgAxOUM9mxswJoPfVeyGpnLYjWnqaFsR2Bxda24WVUUAvPFunnMBzO1tKxiRlFLNPWHGRujUNfr1PkynLrFrP9wgQ/s400/7.jpg" alt="" id="BLOGGER_PHOTO_ID_5312632193434817874" border="0" /></a><br /><br /><span style=";font-family:georgia;font-size:100%;" >5. Change the action on failure. Change it to the Go to Next Step. (Don’t change it to ‘Go to Step n….)<br /></span><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEghdiAyKWpWrOWIxiel4Z9S83bvkcJzx690PWWLtemG5KdrSmxAxgI057mxSbjnWi3XM2II7YT7Ds0D8qngwRpHHZlhwwU72nx27HS3QB0gZ3TvEvwF9vVUrIJQs5JWaTwf3seArvQk9rc/s1600-h/8.jpg"><img style="cursor: pointer; width: 400px; height: 358px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEghdiAyKWpWrOWIxiel4Z9S83bvkcJzx690PWWLtemG5KdrSmxAxgI057mxSbjnWi3XM2II7YT7Ds0D8qngwRpHHZlhwwU72nx27HS3QB0gZ3TvEvwF9vVUrIJQs5JWaTwf3seArvQk9rc/s400/8.jpg" alt="" id="BLOGGER_PHOTO_ID_5312632422378886322" border="0" /></a><br /><br /><span style=";font-family:georgia;font-size:100%;" >6. Click Ok -> Ok for confirmation.<br />7. Job Alerts has been scheduled.</span>Nitin Nayyarhttp://www.blogger.com/profile/16414537983607513424noreply@blogger.com0tag:blogger.com,1999:blog-2031726627669618347.post-65693660575254826602009-02-28T06:41:00.000-08:002009-02-28T07:17:08.572-08:00. Administration BooksSome of the books which I feel are helpful if you are starting with Basis Administration :<br /><br /><ul><li><span style="font-style: italic;">SAP R/3 System Administration<br />German title: SAP R/3 Systemadministration</span></li></ul><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1MjNDpwl_VRPcPKoLfyRHqPX816itO-6X853GxmkloDZncqaUIEEySeSDuGJhaJ2dc4_SjKPxGJ71cW3JXM8xLIPax5AT_DaWaovpvIP2VdrJL5NWxludLdLeTxCVttWi6ytsygGpndU/s1600-h/SAP+R3+Administrator%27s+Handbook.jpg"> <img style="cursor: pointer; width: 156px; height: 200px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1MjNDpwl_VRPcPKoLfyRHqPX816itO-6X853GxmkloDZncqaUIEEySeSDuGJhaJ2dc4_SjKPxGJ71cW3JXM8xLIPax5AT_DaWaovpvIP2VdrJL5NWxludLdLeTxCVttWi6ytsygGpndU/s400/SAP+R3+Administrator%27s+Handbook.jpg" alt="" id="BLOGGER_PHOTO_ID_5307864917813182610" border="0" /></a><ul><li>SAP Performance Optimization Guide<br />German title: SAP Performanceoptimierung</li></ul><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgvuBepBx98jiMLrj9Hh4ttK8G8btJxfO89tCdX_qFeaHgyjjqYhikxaBv0mLw-1Aima0qx8h9uUxgsQI3ZE_AavKZtYW-tT1hrqMpYyl19eP-6t-JF5aPTRYsIwSaPqEGsVS2qkw5RVow/s1600-h/Perf.jpg"><img style="cursor: pointer; width: 240px; height: 240px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgvuBepBx98jiMLrj9Hh4ttK8G8btJxfO89tCdX_qFeaHgyjjqYhikxaBv0mLw-1Aima0qx8h9uUxgsQI3ZE_AavKZtYW-tT1hrqMpYyl19eP-6t-JF5aPTRYsIwSaPqEGsVS2qkw5RVow/s400/Perf.jpg" alt="" id="BLOGGER_PHOTO_ID_5307865335245558818" border="0" /></a><ul><li>SAP Change and Transport Management<br />German title: SAP Änderungs- und Transportmanagement<br /></li></ul><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgy1ducHNjsqtFzITFImPj8QXib06W7YMXhQ4IP3rxP9tcxuuCsYlQ0AeCkF12rmmYa-ri3oS5moncg6XIvHX_3cG_UiAokd6i3POCqseZOP4Wb9KCgwr1u9P-uDqoFbALNHFiVzpXnaP4/s1600-h/Transport+Mgmt.jpg"><img style="cursor: pointer; width: 142px; height: 200px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgy1ducHNjsqtFzITFImPj8QXib06W7YMXhQ4IP3rxP9tcxuuCsYlQ0AeCkF12rmmYa-ri3oS5moncg6XIvHX_3cG_UiAokd6i3POCqseZOP4Wb9KCgwr1u9P-uDqoFbALNHFiVzpXnaP4/s400/Transport+Mgmt.jpg" alt="" id="BLOGGER_PHOTO_ID_5307865454239639762" border="0" /></a><ul><li><span style="font-style: italic;">SAP Security and Authorizations<br /></span><span style="font-style: italic;">German title: Sicherheit und Berechtigungen in SAP-Systemen</span></li></ul><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEif7zIITEWGrGHFpaa7hyRZYsqdNebb2EZ4XmQLMI6hPuwCc4v8WnHFc6OQ3a-tdSiA9QIh5pfdGzSD2TeHsW7AYnYxJYJk1jBvSAgbh-fd4a64YGTLWjXooj2TuiYVm5OOd8Ao0kByfEg/s1600-h/Security.JPG"> <img style="cursor: pointer; width: 150px; height: 143px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEif7zIITEWGrGHFpaa7hyRZYsqdNebb2EZ4XmQLMI6hPuwCc4v8WnHFc6OQ3a-tdSiA9QIh5pfdGzSD2TeHsW7AYnYxJYJk1jBvSAgbh-fd4a64YGTLWjXooj2TuiYVm5OOd8Ao0kByfEg/s400/Security.JPG" alt="" id="BLOGGER_PHOTO_ID_5307865564640080706" border="0" /></a>Nitin Nayyarhttp://www.blogger.com/profile/16414537983607513424noreply@blogger.com0