Skip to Content
0
Former Member
Dec 01, 2004 at 10:00 AM

Problems with Installation of EP 5.0 Portal Usage Reporting

38 Views

Hi Portal folks!

We have downloaded the EP 5.0 Portal Usage Reporting Tool form SDN and now face installation problems. Is there any (in)official support from SAP site or from any other site?

Thanx for any hint!

Regards,

Volker

The Portal Administrator who tried to install the tool in EP50 SP5, reported the following to me:

We have some issues with the Reporting software for the Enterprise Portal. To simplify the symptoms:

It doesn't work.

To make Troubleshooting as easy and fast as possible, I will provide you with all the facts from beginning:

System info:

Developement Portal

SID:EP5

OS: Windows 2000 Enterprise Edition

SP 4

CPU: Dual PIII 1,2GHZ

RAM: 4GB

Storage: A lot!

All components are installed on the same server (except T-Rex and ITS, but I don't think this has anything to do with the problem)

EP:

5.5.1.10

CM:

5.5.2.0

SAP J2EE:

6.20 72511.20

MS SQL Server 8.0 (is this 2000?)

Novel E-Directory 8.6.1

What did we do? (Installation Check on page 9 of the main installation guide):

1.) Create database. ok!

2.) Create login account. ok! see portalappsuser.jpg

3.) Grant access to portal database. ok! see portalappsuserprop.jpg

4.) Run database.sql..... ok! see portalappstables.jpg, portalappsviews.jpg and portalappsstored.jpg

5.) Grant access from portal user to extension kit database?? Isn't this done in point 3? If this is something different, than I didn't do it and it's not mentioned in the guide.

6.) Make changes in portal ASP pages. ok, maybe.. see myPage.asp and default.asp. In your guide you say that I should implement only the part between the comments.

But in some cases there are <% and %> before and after comments. I've added these, too. For instance:

<%

'2. Portal Tracking -


> start

Function ConnectToDB( Connection, ConnectionString )

On Error Resume Next

...

bla bla bla

...

DbConn.Close

Set DbConn = nothing

Set DbComm = nothing

end if

'2. -


>end

%>

and not only:

'2. Portal Tracking -


> start

Function ConnectToDB( Connection, ConnectionString )

On Error Resume Next

...

bla bla bla

...

DbConn.Close

Set DbConn = nothing

Set DbComm = nothing

end if

'2. -


>end

Is this right?

7.)Login to the portal and check that data is stored in the raw data tables.Nothing stored in portal_reports_login_tracking. although there were lots of logins 😔 . JDBC seems to be the troublmaker.

8.)Install PortalTracking. Ok!. Installed, modified and executetd. NO Log is being written whatsoever. I get following in the dosbox:

C:\Documents and Settings\chehnen.000>"D:\Program Files\PortalTracking\PortalTracking.exe" -nowin -d

Application Startup - 11/19/2004 9:28:46 AM

Begin ProcessData

Open connections

Executing - PORTAL_REPORTS_PROCESS_LOGINS

Executing sql - find maxdate

reading raw data - executing PORTAL_REPORTS_GET_PAGESANDIVUS

Start Transaction

Inserted 0 pages and 0 iViews tracking records

Delete Pages and iView raw data, executing PORTAL_REPORTS_DELETE_PAGESIVUS_RAWDATA

Commited changes to the database

End ProcessData

Application finishing - 11/19/2004 9:28:48 AM

C:\Documents and Settings\chehnen.000>

I've installed .NET Framework 1.1 . I did not install Microsoft DAC 2.7 (isn't mentioned in your guide, but is mentioned on microsoft.com)

9.)Install PCDScanner.exe. ok!. Get log. looks good

10.)Run PCD Scanner at least once. ok.

11.)Setup Task scheduler entries...no need for now. Don't work

12.)Upload Portalreports.ear. ok. See ear1.jpg

13.)We created the iView like it is shown in the documentation word-for-word

(See Screenshot pic18467.pcx and pic06334.pcx). But the iView opens with error code 404: "The

page cannot be found". Have we to call the URL like our URL-Adress for the

Portal (ranffm03.ranffm.de/SAPPortal)? Or have we to set the

parameters in another way?

14. Run PortalTracking at least once. ok