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