unable to delete project

J

james.warren2

When trying to delete a project in MS Project Server 2002
(via PWA as Admin), it whirs around for 10 min then
displays error msg:
VB Script: MS Project Web Access
An error occurred while completing the operation.

There were no locked projects being deleted.

Thanks.
 
G

Gary L. Chefetz [MVP]

James:

VB Script errors typically relate to configuration or software issues on the
client side. Upgrading MDAC on the client and applying the latest service
packs is always a good first approach when attempting to resolve these
issues. You should also review your browser security settings. Does this
happen on other machines? In what state is the project now?
 
J

James Warren

All Administrators have the same problem. It gets a
bunch of errors on the web server's event log though most
are due to the timeout issue. The projects "to be
deleted" cannot be pulled up via PWA nor MSProjPro
anymore but they are still listed. Some "to be deleted
projects" are published, some are not.
 
G

Gary L. Chefetz [MVP]

James:

It would certainly be helpful to have the errors in your post, nonetheless.
You may be facing some database corruption at this point.
 
J

James Warren

Here is a list of error in the Application log (in reverse order) at the time of the problem:

12/16/2003 12:53:54 PM Microsoft Project Server Tracing Eventlog Provider Error None 2 NT AUTHORITY\SYSTEM HOUWAPP300 Component: PjQuery
File: C:\Proj10\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 1178
Error Number: 0x80040e31
Description: Assert Detected. The error code was also included.


12/16/2003 12:53:54 PM Microsoft Project Server Tracing Eventlog Provider Error None 2 NT AUTHORITY\SYSTEM HOUWAPP300 Component: PjSvrSecurity
File: C:\Proj10\WebClient\source\server\pjsvrsecurity\CPjSvrSecurity.cpp
Line: 3913
Error Number: 0x80040e31
Description: Assert Detected. The error code was also included.


12/16/2003 12:53:54 PM Microsoft Project Server Tracing Eventlog Provider Error None 2 NT AUTHORITY\SYSTEM HOUWAPP300 Component: PjSvrUtl
File: C:\Proj10\WebClient\source\server\pjsvrutl\ResUtil.cpp
Line: 2581
Error Number: 0x80040e31
Description: Assert Detected. The error code was also included.


12/16/2003 12:53:54 PM Microsoft Project Server Tracing Eventlog Provider Error None 2 NT AUTHORITY\SYSTEM HOUWAPP300 Component: PjSvrUtl
File: C:\Proj10\WebClient\source\server\pjsvrutl\ResUtil.cpp
Line: 313
Error Number: 0x80040e31
Description: Assert Detected. The error code was also included.


12/16/2003 12:53:54 PM Microsoft Project Server Tracing Eventlog Provider Error None 2 NT AUTHORITY\SYSTEM HOUWAPP300 Component: PjQuery
File: C:\Proj10\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 1172
Error Number: 0x80040e31
Description: Assert Detected. The error code was also included.


12/16/2003 12:53:54 PM Microsoft Project Server Tracing Eventlog Provider Error None 2 NT AUTHORITY\SYSTEM HOUWAPP300 Component: PjSvrUtl
File: C:\Proj10\WebClient\source\utility\queryutil.cpp
Line: 54
Error Number: 0x80040e31
Description: Assert Detected. The error code was also included.


12/16/2003 12:53:54 PM Microsoft Project Server Tracing Eventlog Provider Error None 2 NT AUTHORITY\SYSTEM HOUWAPP300 Component: PjQuery
File: C:\Proj10\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 1053
Error Number: 0x80040e31
Description: Assert Detected. The error code was also included.
___________________________________

Component: Microsoft OLE DB Provider for SQL Server
Description: Timeout expired
 
J

James Warren

If I am facing database corruption, then is my choice to be find an older non-corrupted version of the DB to recover from. Then either:
1) New projects since the old copy might get exported/imported but changes to existing projects would be systematically lost (manual reinput time).
O
2) Export/import all projects that it can be done on that were updated after the old backup. Then whack and reimport those. Any new ones exportable can also be reimported. Those unchanged stay as they are
Thanks.
 
T

TS

Which account that published the plans originally
What are the SQL permissions that are attemptin to delete

It looks like permission errors..

~TS
 
Top