Project Server 2003 Service Pack 2a installation error.

H

happy

We are currently trying to upgrade a virtualised environment hosting
Projects Server 2003 SP1 to the latest service pack SP2A. The database
part of the installation is completed successfully but the main section
of the upgrade fails almost immediately. We would appreciate any help
in diagnosing the problem. Outlined below is the environment, process,
error details and log files.

Any help would be greatly appreciated.


Scenario
--------

Host Machine
------------
Server: Windows Server 2000 SP4, VMWare GSX Server


Virtual Machines (guests)
-------------------------
Web Server: Windows Server 2003 SP1, IIS, Project Server 2003 SP1
(11.1.2004.1707.15)

View Server: Windows Server 2000 SP4, IIS, SQL Reporting Services,
PS2003 View Notification Service, PS2003 Session Management Service

SQL Server: Windows Server 2000 SP4, SQL Server SP2 (8.0.760)


Installation Procedure
----------------------
Step 1: Run SQL script to upgrade the Project Server 2003 database on
the SQL Server. SUCCESSFUL

Step 2: Run the SP2a executable on the Web Server. FAILURE


Error Report
------------
The Executable extracts the PROJECTSVRSP2.msp file and progresses to
deploy the contained files. Before the deployment can be attempted the
process fails and displays a message box containing "The update cannot
be applied."

We have done the usual battery of tests, checked patch levels, deployed
on to a single server environment (with success), ensured there is
communication before the servers in the environment. The installation
failure produces three event log entries shown below and an installer
log file (attached).


Event Log Entry 1
-----------------
Failed to connect to server. Error: 0x800401F0


Event Log Entry 2
-----------------
Product: Microsoft Office Project Server 2003 - Update 'Project Server
2003 Service Pack 2a (SP2a): PROJECTSVRSP2' could not be installed.
Error code 1603. Additional information is available in the log file
C:\DOCUME~1\PRANOT~1.MEN\LOCALS~1\Temp\5\OHotfix\OHotfix(00014)_Msi.log.


Event Log Entry 3
-----------------
Product: Microsoft Office Project Server 2003 -- Configuration failed.

MSI Log Files
-------------------
MSI (s) (BC:0C) [12:39:30:366]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI17.tmp, Entrypoint: PopulateWebList
Action start 12:39:30: CA_PopulateWebList.
PopulateWebList: ...Beginning PopulateWebList...
PopulateWebList: .........Default already set: 427052
MSI (s) (BC!54) [12:39:30:507]: Note: 1: 2262 2: ListBox 3: -2147287038

PopulateWebList: ......1250510206 - Reports_D1_DEV
PopulateWebList: .........Successfully added.
PopulateWebList: ......1250510207 - SharePoint Central Administration
PopulateWebList: .........Successfully added.
PopulateWebList: ......425834410 - Site1_Dev
PopulateWebList: .........Successfully added.
PopulateWebList: ......445369705 - Site2_Sandbox2
PopulateWebList: .........Successfully added.
PopulateWebList: ...Ending PopulateWebList...
MSI (s) (BC:88) [12:39:30:538]: Doing action: CA_PS_GetUserAccounts
Action ended 12:39:30: CA_PopulateWebList. Return value 1.
MSI (s) (BC:88) [12:39:30:538]: Transforming table CustomAction.

MSI (s) (BC:88) [12:39:30:538]: Transforming table CustomAction.

MSI (s) (BC:88) [12:39:30:538]: Note: 1: 2262 2: CustomAction 3:
-2147287038
MSI (s) (BC:88) [12:39:30:538]: Transforming table Binary.

MSI (s) (BC:88) [12:39:30:538]: Transforming table Binary.

MSI (s) (BC:88) [12:39:30:538]: Note: 1: 2262 2: Binary 3: -2147287038
MSI (s) (BC:34) [12:39:30:554]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI18.tmp, Entrypoint: GetUserAccounts
Action start 12:39:30: CA_PS_GetUserAccounts.
GetUserAccounts: ...Using SQL authentication.
GetUserAccounts: ....coinit
GetUserAccounts: ....getting webvroot
GetUserAccounts: ....got webvroot
GetUserAccounts: ....multibytetowidechar
GetUserAccounts: ....opening the key
GetUserAccounts: ....failed openkey
GetUserAccounts: Error: Failed to OpenKey.
MSI (s) (BC:88) [12:39:30:648]: Transforming table
InstallExecuteSequence.

MSI (s) (BC:88) [12:39:30:648]: Transforming table
InstallExecuteSequence.

Action ended 12:39:30: CA_PS_GetUserAccounts. Return value 3.
Action ended 12:39:30: INSTALL. Return value 3.





Many thanks,
 
G

Gary L. Chefetz [MVP]

Happy:

It's difficult to say given the virtual environment and it has been a while
since I used VM ware, but I can't help but notice that you specify SP2 for
SQL in your post. I hope you meant that you have at least SP3a.




happy said:
We are currently trying to upgrade a virtualised environment hosting
Projects Server 2003 SP1 to the latest service pack SP2A. The database
part of the installation is completed successfully but the main section
of the upgrade fails almost immediately. We would appreciate any help
in diagnosing the problem. Outlined below is the environment, process,
error details and log files.

Any help would be greatly appreciated.


Scenario
--------

Host Machine
------------
Server: Windows Server 2000 SP4, VMWare GSX Server


Virtual Machines (guests)
-------------------------
Web Server: Windows Server 2003 SP1, IIS, Project Server 2003 SP1
(11.1.2004.1707.15)

View Server: Windows Server 2000 SP4, IIS, SQL Reporting Services,
PS2003 View Notification Service, PS2003 Session Management Service

SQL Server: Windows Server 2000 SP4, SQL Server SP2 (8.0.760)


Installation Procedure
----------------------
Step 1: Run SQL script to upgrade the Project Server 2003 database on
the SQL Server. SUCCESSFUL

Step 2: Run the SP2a executable on the Web Server. FAILURE


Error Report
------------
The Executable extracts the PROJECTSVRSP2.msp file and progresses to
deploy the contained files. Before the deployment can be attempted the
process fails and displays a message box containing "The update cannot
be applied."

We have done the usual battery of tests, checked patch levels, deployed
on to a single server environment (with success), ensured there is
communication before the servers in the environment. The installation
failure produces three event log entries shown below and an installer
log file (attached).


Event Log Entry 1
-----------------
Failed to connect to server. Error: 0x800401F0


Event Log Entry 2
-----------------
Product: Microsoft Office Project Server 2003 - Update 'Project Server
2003 Service Pack 2a (SP2a): PROJECTSVRSP2' could not be installed.
Error code 1603. Additional information is available in the log file
C:\DOCUME~1\PRANOT~1.MEN\LOCALS~1\Temp\5\OHotfix\OHotfix(00014)_Msi.log.


Event Log Entry 3
-----------------
Product: Microsoft Office Project Server 2003 -- Configuration failed.

MSI Log Files
-------------------
MSI (s) (BC:0C) [12:39:30:366]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI17.tmp, Entrypoint: PopulateWebList
Action start 12:39:30: CA_PopulateWebList.
PopulateWebList: ...Beginning PopulateWebList...
PopulateWebList: .........Default already set: 427052
MSI (s) (BC!54) [12:39:30:507]: Note: 1: 2262 2: ListBox 3: -2147287038

PopulateWebList: ......1250510206 - Reports_D1_DEV
PopulateWebList: .........Successfully added.
PopulateWebList: ......1250510207 - SharePoint Central Administration
PopulateWebList: .........Successfully added.
PopulateWebList: ......425834410 - Site1_Dev
PopulateWebList: .........Successfully added.
PopulateWebList: ......445369705 - Site2_Sandbox2
PopulateWebList: .........Successfully added.
PopulateWebList: ...Ending PopulateWebList...
MSI (s) (BC:88) [12:39:30:538]: Doing action: CA_PS_GetUserAccounts
Action ended 12:39:30: CA_PopulateWebList. Return value 1.
MSI (s) (BC:88) [12:39:30:538]: Transforming table CustomAction.

MSI (s) (BC:88) [12:39:30:538]: Transforming table CustomAction.

MSI (s) (BC:88) [12:39:30:538]: Note: 1: 2262 2: CustomAction 3:
-2147287038
MSI (s) (BC:88) [12:39:30:538]: Transforming table Binary.

MSI (s) (BC:88) [12:39:30:538]: Transforming table Binary.

MSI (s) (BC:88) [12:39:30:538]: Note: 1: 2262 2: Binary 3: -2147287038
MSI (s) (BC:34) [12:39:30:554]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSI18.tmp, Entrypoint: GetUserAccounts
Action start 12:39:30: CA_PS_GetUserAccounts.
GetUserAccounts: ...Using SQL authentication.
GetUserAccounts: ....coinit
GetUserAccounts: ....getting webvroot
GetUserAccounts: ....got webvroot
GetUserAccounts: ....multibytetowidechar
GetUserAccounts: ....opening the key
GetUserAccounts: ....failed openkey
GetUserAccounts: Error: Failed to OpenKey.
MSI (s) (BC:88) [12:39:30:648]: Transforming table
InstallExecuteSequence.

MSI (s) (BC:88) [12:39:30:648]: Transforming table
InstallExecuteSequence.

Action ended 12:39:30: CA_PS_GetUserAccounts. Return value 3.
Action ended 12:39:30: INSTALL. Return value 3.





Many thanks,
 
H

happy

FIXED

Install and run Microsoft Installer CleanUp Utility to remove the
Project Server 2003 instance from the MSI database. Install Project
Server 2003 and attach to existing database. Apply SP2a Service Pack.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top