Ms Project Server 2 slow

B

bidzis

Hi,

performing single update using Ms Project takes almost an hour in our
organization. Server machine has 4 processors (which are boring most of
time), 1 GB RAM and SQL Server 2k database. Also 100 Mb NIC is used not more
than 1%.

Does anybody know how to speed up the server ? Or this is normal (1 hour
necessary for update ?)

bidzis
 
M

Marc Soester [MVP]

Hi bidzis,

I assume that you have project server 2003 installed?
That is an unuasual long time even for a single server and the specification
you mention means that it is a crunchy machine.
Can you please check if you have any event logs and we will take it from there
Let me know
thanks
 
B

bidzis

Hi Marc,

Win 2003 Stand, Proj Server 2003
(+ SP2a) + SQL Server 2k Enterprise (8.00.760 - SP3) + Sharepoint Servies
2.0 (+ SP2). Users connect using M$ Proj Prof.

See some log entries below (C:\Office... are most frequent):

Applic log:

Component: AD Connector
File: AutoADProcess
Line: -1
Error Number: 0x80010105
Description: <Description><![CDATA[An error occured within AD Connector for
ProjectServer]]></Description>

Component: PjsvcADC
File: AutoADProcess
Line: -1
Error Number: 0x80010105
Description: <Description><![CDATA[Automation error
The server threw an exception. ]]></Description>


Component: PjMsgHlr
File: C:\Office\devsp\project\WebClient\source\server\pjmsghlr\updatedb.cpp
Line: 2391
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

Component: PjQuery
File:
C:\Office\devsp\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 752
Error Number: 0x80004003
Description: <Description><![CDATA[Assert Detected. . The error code was
also included.]]></Description>

Component: PjSvrNPE
File:
C:\Office\devsp\project\WebClient\source\server\pjnpe\emailformatter.cpp
Line: 348
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

Component: PjSvrNPE
File: C:\Office\devsp\project\WebClient\source\server\pjnpe\PjNPEUtil.cpp
Line: 50
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

File: C:\Office\devsp\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 317
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
___________________________________

Component: Microsoft Cursor Engine
Description: <Description><![CDATA[Data provider or other service returned
an E_FAIL status.]]></Description>

Component: PjQuery
File: C:\Office\devsp\project\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 1061
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServer'. The error code was also included.]]></Description>

omponent: PDS
Line: 0
Error Number: 0x238e
Description:
<Description><![CDATA[CSecurity.PopulateProjectViewTables3; -2147467259 :
Method '~' of object '~' failed]]></Description>

Component: PjMsgHlr
File:
C:\Office\devsp\project\WebClient\source\server\pjmsghlr\MsgHandler.cpp
Line: 241
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>


Master merge has completed on e:\data files\microsoft sql
server\mssql\ftdata\sql0000800005\build\indexer\c

omponent: PjSvrNPE
File: C:\Office\devsp\project\WebClient\source\server\pjnpe\CPjSvrNPE.cpp
Line: 48
Error Number: 0x80010105
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>


File: C:\Office\devsp\project\WebClient\source\utility\baserootformat.cpp
Line: 22
Error Number: 0x80070057
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

Master merge has completed on e:\data files\microsoft sql
server\mssql\ftdata\sql0000800005\build\indexer\cifiles.

Reporting queued error: faulting application PJSCHSVC.EXE, version
11.0.2003.816, faulting module oleaut32.dll, version 5.2.3790.1830, fault
address 0x00004363.

Master merge has completed on c:\inetpub\catalog.wci.

One or more documents stored in image columns with extension '' did not get
full-text indexed because loading the filter failed with error '0x1'.

Note: These documents will not be passed to MSSearch for indexing, and
therefore this failure will not be reflected in the end of crawl summary
statistics.

Reporting queued error: faulting application PJSCHSVC.EXE, version
11.0.2003.816, faulting module oleaut32.dll, version 5.2.3790.1830, fault
address 0x00004363.

Component: PjSvrSecurity
File:
C:\Office\devsp\project\WebClient\source\server\pjsvrsecurity\CPjSvrSecurity.cpp
Line: 2291
Error Number: 0x8c04003a
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

System log:

The Project Server Scheduled Process Service service terminated
unexpectedly. It has done this 1 time(s). The following corrective action
will be taken in 60000 milliseconds: Restart the service.

The application-specific permission settings do not grant Local Activation
permission for the COM Server application with CLSID
{0C0A3666-30C9-11D0-8F20-00805F2CD064}
to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security
permission can be modified using the Component Services administrative tool.



What do you think about it ? We have really problem with the performance of
this machine (some days is better, but updates usually take from 20 mins to
an hour, which make users nervous), so I really appreciate your willingness
to help, I'm rather beginner with M$ Project

best regards,

bidzis

U¿ytkownik "Marc Soester [MVP]" <[email protected]>
napisa³ w wiadomo¶ci
 
M

Marc Soester [MVP]

Hi bidzis,

Sorry for the delayed reply, but I had to have a look what this could mean.
Do you also get spooler errors when you publish a project?

Does the publish ( which takes one hour) actually work?

Can you please check on the drop view folder wihtin the Project Server
folder ( on your server) if there are any files within this folder ( xml
probably)?

somehow it seems that you may have an access problem but I am not sure.

Lets see if we cant speed this up a little :)

--
Marc Soester [MVP]
State Manager: EPM
http://marcsoester.blogspot.com


bidzis said:
Hi Marc,

Win 2003 Stand, Proj Server 2003
(+ SP2a) + SQL Server 2k Enterprise (8.00.760 - SP3) + Sharepoint Servies
2.0 (+ SP2). Users connect using M$ Proj Prof.

See some log entries below (C:\Office... are most frequent):

Applic log:

Component: AD Connector
File: AutoADProcess
Line: -1
Error Number: 0x80010105
Description: <Description><![CDATA[An error occured within AD Connector for
ProjectServer]]></Description>

Component: PjsvcADC
File: AutoADProcess
Line: -1
Error Number: 0x80010105
Description: <Description><![CDATA[Automation error
The server threw an exception. ]]></Description>


Component: PjMsgHlr
File: C:\Office\devsp\project\WebClient\source\server\pjmsghlr\updatedb.cpp
Line: 2391
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

Component: PjQuery
File:
C:\Office\devsp\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 752
Error Number: 0x80004003
Description: <Description><![CDATA[Assert Detected. . The error code was
also included.]]></Description>

Component: PjSvrNPE
File:
C:\Office\devsp\project\WebClient\source\server\pjnpe\emailformatter.cpp
Line: 348
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

Component: PjSvrNPE
File: C:\Office\devsp\project\WebClient\source\server\pjnpe\PjNPEUtil.cpp
Line: 50
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

File: C:\Office\devsp\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 317
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
___________________________________

Component: Microsoft Cursor Engine
Description: <Description><![CDATA[Data provider or other service returned
an E_FAIL status.]]></Description>

Component: PjQuery
File: C:\Office\devsp\project\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 1061
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServer'. The error code was also included.]]></Description>

omponent: PDS
Line: 0
Error Number: 0x238e
Description:
<Description><![CDATA[CSecurity.PopulateProjectViewTables3; -2147467259 :
Method '~' of object '~' failed]]></Description>

Component: PjMsgHlr
File:
C:\Office\devsp\project\WebClient\source\server\pjmsghlr\MsgHandler.cpp
Line: 241
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>


Master merge has completed on e:\data files\microsoft sql
server\mssql\ftdata\sql0000800005\build\indexer\c

omponent: PjSvrNPE
File: C:\Office\devsp\project\WebClient\source\server\pjnpe\CPjSvrNPE.cpp
Line: 48
Error Number: 0x80010105
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>


File: C:\Office\devsp\project\WebClient\source\utility\baserootformat.cpp
Line: 22
Error Number: 0x80070057
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

Master merge has completed on e:\data files\microsoft sql
server\mssql\ftdata\sql0000800005\build\indexer\cifiles.

Reporting queued error: faulting application PJSCHSVC.EXE, version
11.0.2003.816, faulting module oleaut32.dll, version 5.2.3790.1830, fault
address 0x00004363.

Master merge has completed on c:\inetpub\catalog.wci.

One or more documents stored in image columns with extension '' did not get
full-text indexed because loading the filter failed with error '0x1'.

Note: These documents will not be passed to MSSearch for indexing, and
therefore this failure will not be reflected in the end of crawl summary
statistics.

Reporting queued error: faulting application PJSCHSVC.EXE, version
11.0.2003.816, faulting module oleaut32.dll, version 5.2.3790.1830, fault
address 0x00004363.

Component: PjSvrSecurity
File:
C:\Office\devsp\project\WebClient\source\server\pjsvrsecurity\CPjSvrSecurity.cpp
Line: 2291
Error Number: 0x8c04003a
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>

System log:

The Project Server Scheduled Process Service service terminated
unexpectedly. It has done this 1 time(s). The following corrective action
will be taken in 60000 milliseconds: Restart the service.

The application-specific permission settings do not grant Local Activation
permission for the COM Server application with CLSID
{0C0A3666-30C9-11D0-8F20-00805F2CD064}
to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security
permission can be modified using the Component Services administrative tool.



What do you think about it ? We have really problem with the performance of
this machine (some days is better, but updates usually take from 20 mins to
an hour, which make users nervous), so I really appreciate your willingness
to help, I'm rather beginner with M$ Project

best regards,

bidzis

U¿ytkownik "Marc Soester [MVP]" <[email protected]>
napisa³ w wiadomo¶ci
Hi bidzis,

I assume that you have project server 2003 installed?
That is an unuasual long time even for a single server and the
specification
you mention means that it is a crunchy machine.
Can you please check if you have any event logs and we will take it from
there
Let me know
thanks
 
G

GirlGeek

Hi bidzis,

Sorry for the delayed reply, but I had to have a look what this could mean.
Do you also get spooler errors when you publish a project?

Does the publish ( which takes one hour) actually work?

Can you please check on the drop view folder wihtin the Project Server
folder ( on your server) if there are any files within this folder ( xml
probably)?

somehow it seems that you may have an access problem but I am not sure.

Lets see if we cant speed this up a little :)

--
Marc Soester [MVP]
State Manager: EPMhttp://marcsoester.blogspot.com



bidzis said:
Win 2003 Stand, Proj Server 2003
(+ SP2a) + SQL Server 2k Enterprise (8.00.760 - SP3) + Sharepoint Servies
2.0 (+ SP2). Users connect using M$ Proj Prof.
See some log entries below (C:\Office... are most frequent):
Applic log:
Component: AD Connector
File: AutoADProcess
Line: -1
Error Number: 0x80010105
Description: <Description><![CDATA[An error occured within AD Connectorfor
ProjectServer]]></Description>
Component: PjsvcADC
File: AutoADProcess
Line: -1
Error Number: 0x80010105
Description: <Description><![CDATA[Automation error
The server threw an exception. ]]></Description>
Component: PjMsgHlr
File: C:\Office\devsp\project\WebClient\source\server\pjmsghlr\updatedb..cpp
Line: 2391
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
Component: PjQuery
File:
C:\Office\devsp\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 752
Error Number: 0x80004003
Description: <Description><![CDATA[Assert Detected. . The error code was
also included.]]></Description>
Component: PjSvrNPE
File:
C:\Office\devsp\project\WebClient\source\server\pjnpe\emailformatter.cpp
Line: 348
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
Component: PjSvrNPE
File: C:\Office\devsp\project\WebClient\source\server\pjnpe\PjNPEUtil.cpp
Line: 50
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
File: C:\Office\devsp\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 317
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
___________________________________
Component: Microsoft Cursor Engine
Description: <Description><![CDATA[Data provider or other service returned
an E_FAIL status.]]></Description>
Component: PjQuery
File: C:\Office\devsp\project\WebClient\source\server\pjquery\CnxCookie..cpp
Line: 1061
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServer'. The error code was also included.]]></Description>
omponent: PDS
Line: 0
Error Number: 0x238e
Description:
<Description><![CDATA[CSecurity.PopulateProjectViewTables3; -2147467259:
Method '~' of object '~' failed]]></Description>
Component: PjMsgHlr
File:
C:\Office\devsp\project\WebClient\source\server\pjmsghlr\MsgHandler.cpp
Line: 241
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
Master merge has completed on e:\data files\microsoft sql
server\mssql\ftdata\sql0000800005\build\indexer\c
omponent: PjSvrNPE
File: C:\Office\devsp\project\WebClient\source\server\pjnpe\CPjSvrNPE.cpp
Line: 48
Error Number: 0x80010105
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
File: C:\Office\devsp\project\WebClient\source\utility\baserootformat.cpp
Line: 22
Error Number: 0x80070057
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
Master merge has completed on e:\data files\microsoft sql
server\mssql\ftdata\sql0000800005\build\indexer\cifiles.
Reporting queued error: faulting application PJSCHSVC.EXE, version
11.0.2003.816, faulting module oleaut32.dll, version 5.2.3790.1830, fault
address 0x00004363.
Master merge has completed on c:\inetpub\catalog.wci.
One or more documents stored in image columns with extension '' did notget
full-text indexed because loading the filter failed with error '0x1'.
Note: These documents will not be passed to MSSearch for indexing, and
therefore this failure will not be reflected in the end of crawl summary
statistics.
Reporting queued error: faulting application PJSCHSVC.EXE, version
11.0.2003.816, faulting module oleaut32.dll, version 5.2.3790.1830, fault
address 0x00004363.
Component: PjSvrSecurity
File:
C:\Office\devsp\project\WebClient\source\server\pjsvrsecurity\CPjSvrSecurit­y.cpp
Line: 2291
Error Number: 0x8c04003a
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
System log:
The Project Server Scheduled Process Service service terminated
unexpectedly. It has done this 1 time(s). The following corrective action
will be taken in 60000 milliseconds: Restart the service.
The application-specific permission settings do not grant Local Activation
permission for the COM Server application with CLSID
{0C0A3666-30C9-11D0-8F20-00805F2CD064}
to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security
permission can be modified using the Component Services administrative tool.
What do you think about it ? We have really problem with the performance of
this machine (some days is better, but updates usually take from 20 mins to
an hour, which make users nervous), so I really appreciate your willingness
to help, I'm rather beginner with M$ Project
best regards,

U¿ytkownik "Marc Soester [MVP]" <[email protected]>
napisa³ w wiadomo¶ci

- Show quoted text -

Just curious - How many lines in the project that takes an hour? Does
it have lots of external links to other projects? How many resources?
Are the resources on lots of other projects? Did you try unchecking
'Load Summary Resource Assignments' when you launch Project Pro and
does that make any difference? And we're assuming the server is in the
same location as the users, right?
 
B

bidzis

Hi, see the answers at the bottom of the email (most answers are from one
most active user). I will answer some not responded here questions in next
email soon.

bidzis


Uzytkownik "GirlGeek" <[email protected]> napisal w wiadomosci
Hi bidzis,

Sorry for the delayed reply, but I had to have a look what this could
mean.
Do you also get spooler errors when you publish a project?

Does the publish ( which takes one hour) actually work?

Can you please check on the drop view folder wihtin the Project Server
folder ( on your server) if there are any files within this folder ( xml
probably)?

somehow it seems that you may have an access problem but I am not sure.

Lets see if we cant speed this up a little :)

--
Marc Soester [MVP]
State Manager: EPMhttp://marcsoester.blogspot.com



bidzis said:
Win 2003 Stand, Proj Server 2003
(+ SP2a) + SQL Server 2k Enterprise (8.00.760 - SP3) + Sharepoint
Servies
2.0 (+ SP2). Users connect using M$ Proj Prof.
See some log entries below (C:\Office... are most frequent):
Applic log:
Component: AD Connector
File: AutoADProcess
Line: -1
Error Number: 0x80010105
Description: <Description><![CDATA[An error occured within AD Connector
for
ProjectServer]]></Description>
Component: PjsvcADC
File: AutoADProcess
Line: -1
Error Number: 0x80010105
Description: <Description><![CDATA[Automation error
The server threw an exception. ]]></Description>
Component: PjMsgHlr
File:
C:\Office\devsp\project\WebClient\source\server\pjmsghlr\updatedb.cpp
Line: 2391
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>
Component: PjQuery
File:
C:\Office\devsp\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 752
Error Number: 0x80004003
Description: <Description><![CDATA[Assert Detected. . The error code was
also included.]]></Description>
Component: PjSvrNPE
File:
C:\Office\devsp\project\WebClient\source\server\pjnpe\emailformatter.cpp
Line: 348
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>
Component: PjSvrNPE
File:
C:\Office\devsp\project\WebClient\source\server\pjnpe\PjNPEUtil.cpp
Line: 50
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>
File: C:\Office\devsp\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 317
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>
___________________________________
Component: Microsoft Cursor Engine
Description: <Description><![CDATA[Data provider or other service
returned
an E_FAIL status.]]></Description>
Component: PjQuery
File:
C:\Office\devsp\project\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 1061
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServer'. The error code was also included.]]></Description>
omponent: PDS
Line: 0
Error Number: 0x238e
Description:
<Description><![CDATA[CSecurity.PopulateProjectViewTables3; -2147467259
:
Method '~' of object '~' failed]]></Description>
Component: PjMsgHlr
File:
C:\Office\devsp\project\WebClient\source\server\pjmsghlr\MsgHandler.cpp
Line: 241
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>
Master merge has completed on e:\data files\microsoft sql
server\mssql\ftdata\sql0000800005\build\indexer\c
omponent: PjSvrNPE
File:
C:\Office\devsp\project\WebClient\source\server\pjnpe\CPjSvrNPE.cpp
Line: 48
Error Number: 0x80010105
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>
File:
C:\Office\devsp\project\WebClient\source\utility\baserootformat.cpp
Line: 22
Error Number: 0x80070057
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>
Master merge has completed on e:\data files\microsoft sql
server\mssql\ftdata\sql0000800005\build\indexer\cifiles.
Reporting queued error: faulting application PJSCHSVC.EXE, version
11.0.2003.816, faulting module oleaut32.dll, version 5.2.3790.1830,
fault
address 0x00004363.
Master merge has completed on c:\inetpub\catalog.wci.
One or more documents stored in image columns with extension '' did not
get
full-text indexed because loading the filter failed with error '0x1'.
Note: These documents will not be passed to MSSearch for indexing, and
therefore this failure will not be reflected in the end of crawl
summary
statistics.
Reporting queued error: faulting application PJSCHSVC.EXE, version
11.0.2003.816, faulting module oleaut32.dll, version 5.2.3790.1830,
fault
address 0x00004363.
Component: PjSvrSecurity
File:
C:\Office\devsp\project\WebClient\source\server\pjsvrsecurity\CPjSvrSecurit­y.cpp
Line: 2291
Error Number: 0x8c04003a
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>
System log:
The Project Server Scheduled Process Service service terminated
unexpectedly. It has done this 1 time(s). The following corrective
action
will be taken in 60000 milliseconds: Restart the service.
The application-specific permission settings do not grant Local
Activation
permission for the COM Server application with CLSID
{0C0A3666-30C9-11D0-8F20-00805F2CD064}
to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security
permission can be modified using the Component Services administrative
tool.
What do you think about it ? We have really problem with the performance
of
this machine (some days is better, but updates usually take from 20 mins
to
an hour, which make users nervous), so I really appreciate your
willingness
to help, I'm rather beginner with M$ Project
best regards,

U¿ytkownik "Marc Soester [MVP]"
<[email protected]>
napisa³ w wiadomo¶ci

- Show quoted text -

Just curious - How many lines in the project that takes an hour?
[bidzis] 450 lines

Does it have lots of external links to other projects?
[bidzis] No external links

How many resources?
[bidzis] About 15 resources

Are the resources on lots of other projects?
[bidzis] Resources are only declared in this project, but present in the
schedules for previus releases (also on the server) Did you try unchecking

'Load Summary Resource Assignments' when you launch Project Pro and

does that make any difference?
[bidzis] No I did not try that so far will check it soon.

And we're assuming the server is in thesame location as the users, right?
[bidzis] No the users are located in 3 locations (US, Europe, Asia).
 
B

bidzis

Hi Marc,

see my answers below (most are from most active user)

bidzis


U¿ytkownik "Marc Soester [MVP]" <[email protected]>
napisa³ w wiadomo¶ci
Do you also get spooler errors when you publish a project?
[bidzis] Yes there was a spooler error (i.e. on user workstation).
Does the publish ( which takes one hour) actually work?
[bidzis] No, the data was saved but not published probably, because I could
not see it under PWA.
Can you please check on the drop view folder wihtin the Project Server
folder ( on your server) if there are any files within this folder ( xml
probably)?
[bidzis] Will check it soon (sorry for delay with this, I didn't make it
today)
somehow it seems that you may have an access problem but I am not sure.
Lets see if we cant speed this up a little :)
Marc Soester [MVP]
State Manager: EPM
http://marcsoester.blogspot.com


bidzis said:
Hi Marc,

Win 2003 Stand, Proj Server 2003
(+ SP2a) + SQL Server 2k Enterprise (8.00.760 - SP3) + Sharepoint Servies
2.0 (+ SP2). Users connect using M$ Proj Prof.

See some log entries below (C:\Office... are most frequent):

Applic log:

Component: AD Connector
File: AutoADProcess
Line: -1
Error Number: 0x80010105
Description: <Description><![CDATA[An error occured within AD Connector
for
ProjectServer]]></Description>

Component: PjsvcADC
File: AutoADProcess
Line: -1
Error Number: 0x80010105
Description: <Description><![CDATA[Automation error
The server threw an exception. ]]></Description>


Component: PjMsgHlr
File:
C:\Office\devsp\project\WebClient\source\server\pjmsghlr\updatedb.cpp
Line: 2391
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>

Component: PjQuery
File:
C:\Office\devsp\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 752
Error Number: 0x80004003
Description: <Description><![CDATA[Assert Detected. . The error code was
also included.]]></Description>

Component: PjSvrNPE
File:
C:\Office\devsp\project\WebClient\source\server\pjnpe\emailformatter.cpp
Line: 348
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>

Component: PjSvrNPE
File: C:\Office\devsp\project\WebClient\source\server\pjnpe\PjNPEUtil.cpp
Line: 50
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>

File: C:\Office\devsp\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 317
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>
___________________________________

Component: Microsoft Cursor Engine
Description: <Description><![CDATA[Data provider or other service
returned
an E_FAIL status.]]></Description>

Component: PjQuery
File:
C:\Office\devsp\project\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 1061
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServer'. The error code was also included.]]></Description>

omponent: PDS
Line: 0
Error Number: 0x238e
Description:
<Description><![CDATA[CSecurity.PopulateProjectViewTables3; -2147467259 :
Method '~' of object '~' failed]]></Description>

Component: PjMsgHlr
File:
C:\Office\devsp\project\WebClient\source\server\pjmsghlr\MsgHandler.cpp
Line: 241
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>


Master merge has completed on e:\data files\microsoft sql
server\mssql\ftdata\sql0000800005\build\indexer\c

omponent: PjSvrNPE
File: C:\Office\devsp\project\WebClient\source\server\pjnpe\CPjSvrNPE.cpp
Line: 48
Error Number: 0x80010105
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>


File: C:\Office\devsp\project\WebClient\source\utility\baserootformat.cpp
Line: 22
Error Number: 0x80070057
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>

Master merge has completed on e:\data files\microsoft sql
server\mssql\ftdata\sql0000800005\build\indexer\cifiles.

Reporting queued error: faulting application PJSCHSVC.EXE, version
11.0.2003.816, faulting module oleaut32.dll, version 5.2.3790.1830, fault
address 0x00004363.

Master merge has completed on c:\inetpub\catalog.wci.

One or more documents stored in image columns with extension '' did not
get
full-text indexed because loading the filter failed with error '0x1'.

Note: These documents will not be passed to MSSearch for indexing, and
therefore this failure will not be reflected in the end of crawl summary
statistics.

Reporting queued error: faulting application PJSCHSVC.EXE, version
11.0.2003.816, faulting module oleaut32.dll, version 5.2.3790.1830, fault
address 0x00004363.

Component: PjSvrSecurity
File:
C:\Office\devsp\project\WebClient\source\server\pjsvrsecurity\CPjSvrSecurity.cpp
Line: 2291
Error Number: 0x8c04003a
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>

System log:

The Project Server Scheduled Process Service service terminated
unexpectedly. It has done this 1 time(s). The following corrective
action
will be taken in 60000 milliseconds: Restart the service.

The application-specific permission settings do not grant Local
Activation
permission for the COM Server application with CLSID
{0C0A3666-30C9-11D0-8F20-00805F2CD064}
to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security
permission can be modified using the Component Services administrative
tool.



What do you think about it ? We have really problem with the performance
of
this machine (some days is better, but updates usually take from 20 mins
to
an hour, which make users nervous), so I really appreciate your
willingness
to help, I'm rather beginner with M$ Project

best regards,

bidzis

U?ytkownik "Marc Soester [MVP]"
<[email protected]>
napisa3 w wiadomo?ci
Hi bidzis,

I assume that you have project server 2003 installed?
That is an unuasual long time even for a single server and the
specification
you mention means that it is a crunchy machine.
Can you please check if you have any event logs and we will take it
from
there
Let me know
thanks
--
Marc Soester [MVP]
State Manager: EPM
http://marcsoester.blogspot.com


:

Hi,

performing single update using Ms Project takes almost an hour in our
organization. Server machine has 4 processors (which are boring most
of
time), 1 GB RAM and SQL Server 2k database. Also 100 Mb NIC is used
not
more
than 1%.

Does anybody know how to speed up the server ? Or this is normal (1
hour
necessary for update ?)

bidzis
 
B

bidzis

Marc

ViewDrop folder on Project Server is empty..

bidzis

U¿ytkownik "Marc Soester [MVP]" <[email protected]>
napisa³ w wiadomo¶ci
Hi bidzis,

Sorry for the delayed reply, but I had to have a look what this could
mean.
Do you also get spooler errors when you publish a project?

Does the publish ( which takes one hour) actually work?

Can you please check on the drop view folder wihtin the Project Server
folder ( on your server) if there are any files within this folder ( xml
probably)?

somehow it seems that you may have an access problem but I am not sure.

Lets see if we cant speed this up a little :)

--
Marc Soester [MVP]
State Manager: EPM
http://marcsoester.blogspot.com


bidzis said:
Hi Marc,

Win 2003 Stand, Proj Server 2003
(+ SP2a) + SQL Server 2k Enterprise (8.00.760 - SP3) + Sharepoint Servies
2.0 (+ SP2). Users connect using M$ Proj Prof.

See some log entries below (C:\Office... are most frequent):

Applic log:

Component: AD Connector
File: AutoADProcess
Line: -1
Error Number: 0x80010105
Description: <Description><![CDATA[An error occured within AD Connector
for
ProjectServer]]></Description>

Component: PjsvcADC
File: AutoADProcess
Line: -1
Error Number: 0x80010105
Description: <Description><![CDATA[Automation error
The server threw an exception. ]]></Description>


Component: PjMsgHlr
File:
C:\Office\devsp\project\WebClient\source\server\pjmsghlr\updatedb.cpp
Line: 2391
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>

Component: PjQuery
File:
C:\Office\devsp\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 752
Error Number: 0x80004003
Description: <Description><![CDATA[Assert Detected. . The error code was
also included.]]></Description>

Component: PjSvrNPE
File:
C:\Office\devsp\project\WebClient\source\server\pjnpe\emailformatter.cpp
Line: 348
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>

Component: PjSvrNPE
File: C:\Office\devsp\project\WebClient\source\server\pjnpe\PjNPEUtil.cpp
Line: 50
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>

File: C:\Office\devsp\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 317
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>
___________________________________

Component: Microsoft Cursor Engine
Description: <Description><![CDATA[Data provider or other service
returned
an E_FAIL status.]]></Description>

Component: PjQuery
File:
C:\Office\devsp\project\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 1061
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected for Virtual Root
'ProjectServer'. The error code was also included.]]></Description>

omponent: PDS
Line: 0
Error Number: 0x238e
Description:
<Description><![CDATA[CSecurity.PopulateProjectViewTables3; -2147467259 :
Method '~' of object '~' failed]]></Description>

Component: PjMsgHlr
File:
C:\Office\devsp\project\WebClient\source\server\pjmsghlr\MsgHandler.cpp
Line: 241
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>


Master merge has completed on e:\data files\microsoft sql
server\mssql\ftdata\sql0000800005\build\indexer\c

omponent: PjSvrNPE
File: C:\Office\devsp\project\WebClient\source\server\pjnpe\CPjSvrNPE.cpp
Line: 48
Error Number: 0x80010105
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>


File: C:\Office\devsp\project\WebClient\source\utility\baserootformat.cpp
Line: 22
Error Number: 0x80070057
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>

Master merge has completed on e:\data files\microsoft sql
server\mssql\ftdata\sql0000800005\build\indexer\cifiles.

Reporting queued error: faulting application PJSCHSVC.EXE, version
11.0.2003.816, faulting module oleaut32.dll, version 5.2.3790.1830, fault
address 0x00004363.

Master merge has completed on c:\inetpub\catalog.wci.

One or more documents stored in image columns with extension '' did not
get
full-text indexed because loading the filter failed with error '0x1'.

Note: These documents will not be passed to MSSearch for indexing, and
therefore this failure will not be reflected in the end of crawl summary
statistics.

Reporting queued error: faulting application PJSCHSVC.EXE, version
11.0.2003.816, faulting module oleaut32.dll, version 5.2.3790.1830, fault
address 0x00004363.

Component: PjSvrSecurity
File:
C:\Office\devsp\project\WebClient\source\server\pjsvrsecurity\CPjSvrSecurity.cpp
Line: 2291
Error Number: 0x8c04003a
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>

System log:

The Project Server Scheduled Process Service service terminated
unexpectedly. It has done this 1 time(s). The following corrective
action
will be taken in 60000 milliseconds: Restart the service.

The application-specific permission settings do not grant Local
Activation
permission for the COM Server application with CLSID
{0C0A3666-30C9-11D0-8F20-00805F2CD064}
to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security
permission can be modified using the Component Services administrative
tool.



What do you think about it ? We have really problem with the performance
of
this machine (some days is better, but updates usually take from 20 mins
to
an hour, which make users nervous), so I really appreciate your
willingness
to help, I'm rather beginner with M$ Project

best regards,

bidzis

U?ytkownik "Marc Soester [MVP]"
<[email protected]>
napisa3 w wiadomo?ci
Hi bidzis,

I assume that you have project server 2003 installed?
That is an unuasual long time even for a single server and the
specification
you mention means that it is a crunchy machine.
Can you please check if you have any event logs and we will take it
from
there
Let me know
thanks
--
Marc Soester [MVP]
State Manager: EPM
http://marcsoester.blogspot.com


:

Hi,

performing single update using Ms Project takes almost an hour in our
organization. Server machine has 4 processors (which are boring most
of
time), 1 GB RAM and SQL Server 2k database. Also 100 Mb NIC is used
not
more
than 1%.

Does anybody know how to speed up the server ? Or this is normal (1
hour
necessary for update ?)

bidzis
 

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