Install error 25624

[mike.yates]

This occurred near the end of the install, with the detailed options
all selected to be "entered later". The MsSQL server is accepted
earlier, but is this the first actual SQL command or is it faulty? It
looks feasible, eh?

Product: Microsoft Office Project Server 2003 -- Error 25624. Failed to
execute SQL string. (-2147217900 /* Query #10011 */
CREATE PROCEDURE dbo.MSP_WEB_SP_QRY_GetTasksIDs
@p0 INT
AS

select
WA.WASSN_ID,
WA.WRES_ID_MGR,
WA.WPROJ_ID,
WP.PROJ_NAME,
WP.WPROJ_TYPE,
WA.WASSN_ACTUALS_PENDING,
WA.WASSN_RESOURCE_UPDATE,
WA.WASSN_SEND_UPDATE_NEEDED,
WA.WASSN_REQUEST_UPDATE,
WA.WASSN_SEND_UPDATE_DATE
from
(
select WASSN_ID from MSP_WEB_ASSIGNMENTS where WRES_ID=@p0 and
WRES_ID_TEAM_LEAD is null
union
select WASSN_ID from MSP_WEB_ASSIGNMENTS WAT2
(index=I_ASSIGN_WRESID_TEAM_LEAD) where WAT2.WRES_ID_TEAM_LEAD=@p0
) as WAT
inner join MSP_WEB_ASSIGNMENTS WA on WAT.WASSN_ID=WA.WASSN_ID
inner join MSP_WEB_PROJECTS WP on WA.WPROJ_ID=WP.WPROJ_ID
where WP.WPROJ_IS_NONWORKING=0
and WA.WASSN_SEND_UPDATE_NEEDED<>0
and WA.WASSN_IS_CONFIRMED<>0
and WA.WASSN_CREATED_BY_RES<>3
and WA.WASSN_CREATED_BY_RES<>1
and WA.WASSN_REMOVED_BY_RESOURCE=0
order by WA.WPROJ_ID, WA.WRES_ID_MGR

RETURN )

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

 

[mike.yates]

Sorry, folks, hadn't found the workaround posted by Marc Soester on
Wed, Mar 29 2006
It beggars belief that the "latest" Project Server is incompatible with
latest MsSQL, let alone with ANSI SQL.
Couldn't someone "on campus in Redmond" put this information in the
error 25624 error-link webpage?
I followed the instructions relayed by Marc, but I wonder if it
wouldn't be easier to copy the whole CD to HDD, make the three sytax
corrections, then install from there?
Do post back here if you have occasion to try it!
Now they have WPA and WGA, why are Ms frightened of that? You still
need a valid licence.

 

[Gary L. Chefetz [MVP]]

Mike:

SQL2005 released well after P11.