cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Activity Reporting

Go to solution
Murali_Shanmu
Active Contributor

on ‎04-14-2006 12:05 PM

0 Kudos

Hi

How do i setup an activity reporting Iview on my portal to view all the current looged on users and their present tasks. Could anyone please give me a step by step guide to implement the same.

Thanks,

Murali.

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
‎04-14-2006 12:33 PM
0 Kudos

Hi Murali,

You can find step by step guide for actvity report iview by following this URL

http://help.sap.com/saphelp_nw2004s/helpdata/en/58/728ea01cf64fff996b827f2a06f9b1/frameset.htm

Also What is your Portal version?

Because activity report iview is working properly from SP13 onwards.

With regards,

Amol.

(Plz reward points)

Show replies
Show replies
Murali_Shanmu
Active Contributor
‎04-14-2006 12:55 PM
0 Kudos

Hi

I will go thru the link u have mentioned. The version is SP14. Thanks.

Murali_Shanmu
Active Contributor
‎04-14-2006 3:11 PM
0 Kudos

Hi

I went thru the URL

I have done the step as follows.When i preview it i get the following message in a Table View control - "No content available for the specified period."

What could be the problem. Do i need to start some service or a database that keeps track of all the users who log into the portal ?

Please suggest me where i could have gone wrong.

Regards,

Murali.

Murali_Shanmu
Active Contributor
‎04-14-2006 4:16 PM
0 Kudos

Hi

i checked out my DB_Connection.Properties file. It was not maintained.

USER=SAPXYZDB

#The password field below is not mandatory

#If it is left empty, you will be prompted to enter the password later

PASSWORD=

#MSSQL Properties:

URL=jdbc:sap:sqlserver://hostname:port;DatabaseName=XYZ

DRIVER_CLASSNAME=com.sap.portals.jdbc.sqlserver.SQLServerDriver

#Oracle Properties:

#URL=jdbc:oracle:thin:@hostname:port:SID

#DRIVER_CLASSNAME=oracle.jdbc.OracleDriver

#DB2 Properties:

#URL=jdbc:sap:db2://hostname:port;databaseName=XYZ

#DRIVER_CLASSNAME=com.sap.portals.jdbc.db2.DB2Driver

#MaxDB Properties:

#URL=jdbc:sapdb://hostname/XYZ

#DRIVER_CLASSNAME=com.sap.dbtech.jdbc.DriverSapDB

Since i was not the person who did the installation, how do i go about giving values for <SID>, Port, HOSTNAME ?

Your suggestions would be really helpfull.

Murali_Shanmu
Active Contributor
‎04-14-2006 5:04 PM
0 Kudos

Also it would be very helpful, if anyone can say me how to test aggregator.Bat and DB_connection.properties settings.

Murali_Shanmu
Active Contributor
‎04-15-2006 4:50 AM
0 Kudos

When i run the aggregator BAT file from Command prompt, it say - "E:\usr\sap\NWD\JC00\j2ee\cluster\server0\apps\sap.com\irj\servlet_jsp\irj\root\WEB-INF\portal\portalapps\com.sap.portal.activityreport.core\lib>aggregator help

Exception in thread "main" java.lang.NoClassDefFoundError:

com/sap/portal/webreport/tools/Aggregator

Below is source of Aggregator file:

@echo off

set J2EE_HOME=C:\usr\sap\NWD\JC00\j2ee

set WCR_PATH=%J2EE_HOME%\cluster\server0\apps\sap.com\irj\servlet_jsp\irj\root\WEB-INF\portal\portalapps\com.sap.portal.activityreport.core

set classpath=%J2EE_HOME%\admin\lib\opensqlsta.jar;%J2EE_HOME%\admin\lib\exception.jar;%J2EE_HOME%\admin\lib\admin.jar;%J2EE_HOME%\admin\lib\logging.jar;%J2EE_HOME%\cluster\server0\bin\core_lib\tc_sec_secstorefs.jar;%J2EE_HOME%\cluster\server0\bin\ext\com.sap.portal.jdbcdrivers\P9sqlserver.jar;%J2EE_HOME%\jdbc\sqlserver.jar;%J2EE_HOME%\cluster\server0\bin\ext\com.sap.portal.jdbcdrivers\P9db2.jar;%J2EE_HOME%\jdbc\base.jar;%J2EE_HOME%\jdbc\util.jar;%J2EE_HOME%\cluster\server0\bin\ext\com.sap.portal.jdbcdrivers\P9base.jar;%J2EE_HOME%\cluster\server0\bin\ext\com.sap.portal.jdbcdrivers\P9util.jar;%J2EE_HOME%\cluster\server0\bin\ext\antlr\antlr.jar;%J2EE_HOME%\cluster\server0\bin\ext\jdbdictionary\jddi.jar;%WCR_PATH%\lib\com.sap.portal.activityreport.core_api.jar;%classpath%

SET p1=%1

SET p2=%2

shift/0

shift/0

"%JAVA_HOME%\bin\java" -classpath %classpath% com.sap.portal.webreport.tools.Aggregator %p1% %p2% %1 %2 %3 %4 %5 %6 %7 %8 %9

Any suggestions !!!!

Murali_Shanmu
Active Contributor
‎04-15-2006 4:55 AM
0 Kudos

When i check out my current PATH variables it is a follows:

E:\usr\sap\NWD\JC00\j2ee\cluster\server0\apps\sap.com\irj\servlet_jsp\irj\root\

WEB-INF\portal\portalapps\com.sap.portal.activityreport.core\lib>path

PATH=E:\usr\sap\Python\.;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem

;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;C:\j2sdk1.4.2_08\bin;C:\j2s

dk1.4.2_08\bin;E:\usr\sap\NWD\JC00\exe;E:\usr\sap\NWD\SYS\exe\run

Murali_Shanmu
Active Contributor
‎04-15-2006 5:30 AM
0 Kudos

There was a Typo error in my aggregator BAT file. I changed the location to

set J2EE_HOME=C:\usr\sap\NWD\JC00\j2ee

Now my aggregator BAT file is running. It is asking for the DB Password. Since i am not the person who installed it, i am not aware of it. How do i reset the DB password.

Below is the error Message:

E:\usr\sap\NWD\JC00\j2ee\cluster\server0\apps\sap.com\irj\servlet_jsp\irj\root\W

EB-INF\portal\portalapps\com.sap.portal.activityreport.core\lib>aggregator

Aggregator Started...

Loading DB_Connection.properties

Enter database password:

Testing connection...Error while trying to connect to database.

java.sql.SQLException: [SAP_Portals][SQLServer JDBC Driver]A problem occurred wh

en attempting to contact the server (Server returned: Connection reset). Please

ensure that the server parameters passed to the driver are correct and that the

server is running. Also ensure that the maximum number of connections have not b

een exceeded for this server.

at com.sap.portals.jdbc.base.BaseExceptions.createException(Unknown Sour

ce)

at com.sap.portals.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.sap.portals.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.sap.portals.jdbc.sqlserver.tds.TDSLoginRequest.submitRequest(Unkn

own Source)

at com.sap.portals.jdbc.sqlserver.SQLServerImplConnection.open(Unknown S

ource)

at com.sap.portals.jdbc.base.BaseConnection.connect(Unknown Source)

at com.sap.portals.jdbc.base.BaseConnection.setupImplConnection(Unknown

Source)

at com.sap.portals.jdbc.base.BaseConnection.open(Unknown Source)

at com.sap.portals.jdbc.base.BaseDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:512)

at java.sql.DriverManager.getConnection(DriverManager.java:171)

at com.sap.portal.webreport.tools.util.DBWriter.connect(DBWriter.java:16

9)

at com.sap.portal.webreport.tools.util.DBWriter.<init>(DBWriter.java:86)

at com.sap.portal.webreport.tools.Aggregator.<init>(Aggregator.java:37)

at com.sap.portal.webreport.tools.Aggregator.main(Aggregator.java:393)

java.sql.SQLException: [SAP_Portals][SQLServer JDBC Driver]A problem occurred wh

en attempting to contact the server (Server returned: Connection reset). Please

ensure that the server parameters passed to the driver are correct and that the

server is running. Also ensure that the maximum number of connections have not b

een exceeded for this server.

at com.sap.portals.jdbc.base.BaseExceptions.createException(Unknown Sour

ce)

at com.sap.portals.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.sap.portals.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.sap.portals.jdbc.sqlserver.tds.TDSLoginRequest.submitRequest(Unkn

own Source)

at com.sap.portals.jdbc.sqlserver.SQLServerImplConnection.open(Unknown S

ource)

at com.sap.portals.jdbc.base.BaseConnection.connect(Unknown Source)

at com.sap.portals.jdbc.base.BaseConnection.setupImplConnection(Unknown

Source)

at com.sap.portals.jdbc.base.BaseConnection.open(Unknown Source)

at com.sap.portals.jdbc.base.BaseDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:512)

at java.sql.DriverManager.getConnection(DriverManager.java:171)

at com.sap.portal.webreport.tools.util.DBWriter.connect(DBWriter.java:16

9)

at com.sap.portal.webreport.tools.util.DBWriter.getDbDate(DBWriter.java:

124)

at com.sap.portal.webreport.tools.Aggregator.go(Aggregator.java:439)

at com.sap.portal.webreport.tools.Aggregator.main(Aggregator.java:398)

Fatal error occured:

com.sap.portal.webreport.tools.AggregatorException

at com.sap.portal.webreport.tools.util.DBWriter.getDbDate(DBWriter.java:

146)

at com.sap.portal.webreport.tools.Aggregator.go(Aggregator.java:439)

at com.sap.portal.webreport.tools.Aggregator.main(Aggregator.java:398)

caused by:

java.sql.SQLException: [SAP_Portals][SQLServer JDBC Driver]A problem occurred wh

en attempting to contact the server (Server returned: Connection reset). Please

ensure that the server parameters passed to the driver are correct and that the

server is running. Also ensure that the maximum number of connections have not b

een exceeded for this server.

at com.sap.portals.jdbc.base.BaseExceptions.createException(Unknown Sour

ce)

at com.sap.portals.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.sap.portals.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.sap.portals.jdbc.sqlserver.tds.TDSLoginRequest.submitRequest(Unkn

own Source)

at com.sap.portals.jdbc.sqlserver.SQLServerImplConnection.open(Unknown S

ource)

at com.sap.portals.jdbc.base.BaseConnection.connect(Unknown Source)

at com.sap.portals.jdbc.base.BaseConnection.setupImplConnection(Unknown

Source)

at com.sap.portals.jdbc.base.BaseConnection.open(Unknown Source)

at com.sap.portals.jdbc.base.BaseDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(DriverManager.java:512)

at java.sql.DriverManager.getConnection(DriverManager.java:171)

at com.sap.portal.webreport.tools.util.DBWriter.connect(DBWriter.java:16

9)

at com.sap.portal.webreport.tools.util.DBWriter.getDbDate(DBWriter.java:

124)

at com.sap.portal.webreport.tools.Aggregator.go(Aggregator.java:439)

at com.sap.portal.webreport.tools.Aggregator.main(Aggregator.java:398)

Murali_Shanmu
Active Contributor
‎04-17-2006 12:30 PM
0 Kudos

What should be the port that i need to provide while using the SQL Server DB

#MSSQL Properties:

URL=jdbc:sap:sqlserver://hostname:port;DatabaseName=XYZ

DRIVER_CLASSNAME=com.sap.portals.jdbc.sqlserver.SQLServerDriver

Former Member
‎04-18-2006 7:54 AM
0 Kudos

Hi,

This should be the port used to connect to the MSSQL database instance. By default this is 1433, but may be some other port.

Suggest you try 1433 and if that does not work, you will need to find out which port the MSSQL was installed with.

Cheers,

Phil G.

Murali_Shanmu
Active Contributor
‎04-18-2006 12:27 PM
0 Kudos

Thanks Phil. The port was the problem.

Former Member
‎10-31-2006 3:48 PM
0 Kudos

Hello Murali,

Iam running on EP6 SP14 , I did everthing but Iam unable to run the report. Is there any properties that Iam missign to set.

Your suggestion is valuable...

Thanks,

Master.

Former Member
‎10-31-2006 4:40 PM
0 Kudos

Hello Murali

Now Iam able to run the aggregator. Its asking me for the Database password ..can you tell me the way u reset the password.

Thanks,

Master.

Former Member
‎10-31-2006 8:06 PM
0 Kudos

Hey Murali if u remenber the solution for this issue let me know..

Thanks,

Master

Answers (0)

Ask a Question