Banner 468 x 60px

Monday, July 22, 2013

SOST Change Recipient Mail Address

0 comments
Error :

 

Change E-Mail address of a transmitted / sent E-Mail message in SAP

 

Resolution:

 

Go to SOST > Utilities > General Parameters > Maintain SOST_REC_CHANGE = X in this table.

 

OR

 

SM30 > Input table/view  SXPARAMS > Add new entry 'SOST_REC_CHANGE' and put parameter value as 'X'.

 

After  this you can see change recipient mail id popup box when you do repeat sending.

 

 

Reference :

 

SAP Note 685164 - Resending with recipient change

 


Read more...

Friday, July 19, 2013

Integration and Publishing BO reports to Sharepoint

0 comments
Integration and Publishing BO reports to Sharepoint

 

Environment

Windows Server 2008 R2, BOBJ 4.0 SP04 and Sharepoint 2010

 

Downloads Required

 

·         SharePoint integration kit can be downloaded from SAP Service Market Place https://service.sap.com/swdc > Installations and Upgrades > A - Z Index > B > SBOP BI platform (former SBOP Enterprise) > SBOP BI PLATFORM 4.0 > Select you operating system > Depending on your architecture select component CD. In my case im going with 51043405_1 - SBOP BI PLAT 4.0 SP04 (w/ FP03) INTG FOR MS SHAREPOINT WIN.

·         Windows SharePoint Services 3.0 x64 with Service Pack 2. This can be downloaded from http://www.microsoft.com/en-in/download/details.aspx?id=5719

 

Pre Requisites

 

·         On BusinessObjects server and start the web client service. This service is needed to access and modify internet based files (SharePoint doc library). Enable and start the service Webclient.  If you are using Windows Server 2008, Please note Webclient Service is not enabled by default. You need to follow the below steps.

Open Server Manager and click the Features node > If "Desktop Experience" in not already listed under Features, >  click "Add Features" > Select the "Desktop Experience" item and then click next followed by Install > Reboot the PC as instructed.

·         Enable the services Webclient  and Windows sharepoint admin from services.msc

·         Your SharePoint can access UNC paths like folder structure with backslash address.

 

Installation

Proceed with  CD Number  51043405_1  - SBOP BI PLAT 4.0 SP04 (w/ FP03) INTG FOR MS SHAREPOINT WIN . Start the installation with setup.exe.

 

After selection of language pre requisite check will be performed.

 

Proceed with wizard and after sometime it will prompt you for package deployment option.

 

Input existing CMS administrator credentials.

 

 

 

This setup completes your installation of integration kit for SharePoint.  In next section you need to publish reports to sharepoint portal.

 

 

 

 

 

 

 

 

References

 

http://scn.sap.com/community/bi-platform/blog/2013/02/12/publishing-businessobjects-reports-to-sharepoint

               


Read more...

Tuesday, July 2, 2013

Apply SAP Java Stack License Key

0 comments
SAP License for Java system can be applied through Visual Admin

 

Navigate to /usr/sap/SID/J2ee/admin and execute go.bat

 

 

Select default admin and Click on Continue will prompt you for credentials

 

 

Click on Cluster > Services > Licensing Adapter

 

 

 

 

Click on Install License from File will as you path for license. Browse through path to license key which you have received from SAP.

Read more...

Monday, July 1, 2013

Logon balancing error 88: Cannot connect to message server (rc=9)

0 comments
Error :          

 

While performing SSO test from Java portal you receive error "Logon balancing error 88: Cannot connect to message server (rc=9)"

Additional error information:  Error: service '?' unknown

 

Resolution:

 

As the error is related to message server we need to look in services file for entry sapmsSID  3600/tcp. If this entry is there we need to investigate logs further.

 

In my case following resolution worked and could able to perform SSO configuration.

 

Login into portal and navigate to tab > System Administration > System Configuration > Brose portal content > System Landscape > Open Object SAP_BW > Under Display Object Change PORT to 3600. By default entry was SAPmsSID  by which it could not resolute the port address. After changing this to port number 3600 SSO worked well.

 


Read more...

Wednesday, June 26, 2013

Can not download reports through SAPGUI

0 comments
Error:

 

While downloading SAP reports to desktop or local disk , user gets message not able to copy and GUI Security popup appears.

 

 

​​
Resolution :

 

This error persists due to security configuration in SAP GUI. To resolve this goto SAPGUI Options > Security > Security Settings and "Disable" Security mode.

 

 


Read more...

Oracle Listener Can not Start - TNS-12541: TNS:no listener

0 comments
Error :

Oracle listener cannot start and gives error return code1.


Environment:

OS : Windows Server 2008, DB : Oracle 11g, SAP ECC 6 .0 EHP6

Investigations :

Look into logs

C:\Program Files\sapinst_instdir\ERPEhP6\AS-ABAP\ORA\CENTRAL\lsnrctl.log

LSNRCTL for 64-bit Windows: Version 11.2.0.3.0 - Production on 24-JUN-2013 18:33:56

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   64-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SIDHOST.local)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   64-bit Windows Error: 61: Unknown error
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=GDI.WORLD)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   64-bit Windows Error: 2: No such file or directory


Resolution:

Look into the usage of port . i.e Other application may using the same port. To know port usage at windows command prompt execute

netstat -ano | findstr 1521 > This command gives if the port is free or its been using by any other application.  If output is ESTABLISHED it means this port is used by some application and command gives process id using this port.

C:\Users\Administrator>netstat -ano | findstr 1521

  TCP    192.168.8.115:1521     192.168.8.115:56157    ESTABLISHED     9682
  TCP    192.168.8.115:1521     192.168.8.115:56158    ESTABLISHED     9682

tasklist /SVC /FI "PID eq 9682" > This command will give you application name holding this process id. Alternatively you can see in windows task manager.

C:\Users\Administrator>tasklist /SVC /FI "PID eq 9682"

Image Name                     PID Services
========================= ======== ====================
java.exe                      9892 N/A

Now we have two options left. Either change port for listener or change other applications port which is using this port 1521.

In my scenario I have gone for changing port for oracle listener in file listener.ora at path C:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora.  Changed default port 1521 to free port 1527.


Start oracle listener from services.msc or command prompt. This solved my issue and installation moved further.


​​Keywords:


TNS-12541: TNS:no listener,  TNS-12560: TNS:protocol adapter error ,   TNS-00511: No listener


Read more...