I am setting up a demo server with P6 R8.3 EPPM. The process I have followed so far is:
Install Windows Server 2008 R2 SP1 on the box (2 x Quad Core Xeon, 16GB RAM, 2 x 300GB drives)
Install SQL Server 2005 and copy across our current demo R8.2 EPPM database
Install JDK 1.6.0_41 64 bit
Upgrade the database to R8.3
Create a new Middleware Repository for BIP
Do a "simple install" of 64bit BIP from the "generic" distro to create an instance of WebLogic 10.3 and BIP 188.8.131.52.0 within it
Install P6 R8.3 and configure it to deploy into the existing WebLogic instance
Copy the P6 Reports into BIP and set up BIP as per the docs
I had to use the db configuration tool to create (?overwrite) the old P6 Configuration data in the database as when using the web P6 Administrator it was telling me that no database was configured for administration, and I have then gone in to adjust the URL for the database and the link to BI Publisher.
The supported configurations document also says that a patch needs to be applied to WebLogic 11g and I have tried applying it but it seems to be ignoring it - an earlier build attempt using a 32 bit version of WebLogic installed separately from BIP did take the patch, so maybe there is a later version of WebLogic bundled with BIP?... In any case, I am not seeing the error the patch was released to fix.
As of now, I have a working P6 environment with all data carried over from the 8.2 environment. There are 2 odd things happening though, and I can't see any reason for them:
First, any user trying to access Team Member Web Services gets an error message at login saying they are configured to use Progress Reporter to update progress. This happens regardless of the Module Access settings for that user, it just doesn't seem to work any more. Is there more I have to do here?
Second, I can't get the reports tab in EPPM to work, and always get the error message saying that the user is not configured in BI Publisher. Just to be clear what I have done:
I followed the procedure in the docs for setting up P6 reports in BIP and have checked it numerous times.
BIP is using the BIP Security model with a local superuser
The JDBC connection to the P6 database works, and I can login as any of the users in BIP that I set up to match the P6 users, and execute reports within BIP and see results returned
Those P6 users have got Enterprise Reporting module access
I have bounced both P6 and BIP several times within WebLogic, and WebLogic is showing all the various subsystems are running OK (as is Enterprise Manager)
I have compared the setup of this version of BI and P6 to those in our working R8.2 system, and the only 2 differences I can see are
BI is 184.108.40.206.0 for R8.2 and 220.127.116.11.0 for R8.3
When I assigned the data model to the reports in R8.3, the icon for the report disappeared and now just displays as a black box with an x in - but it only did this for some reports (eg the Activity ones)
One thing I am not clear on is the format of the URL for the BI web services - some docs say it should end in ?WSDL, others don't (for the combination of BIP 11g and SQl Server). I have tried both forms without seeing any change in behaviour (Typing either form into a browser results in a response so the web services system is definitely alive).. I have also tried changing the path to the reports from "/P6Reports" (which it actually is) to "/P6REPORTS" (which works in our R8.2 system, even though that's not what the folder is named - its also /P6Reports), but again that doesn't make any difference. Finally, I have tried logging into BIP directly using the credentials saved in the configuration and they work fine.
I am completely stumped - can anyone offer any further things to try out?