OLAP errors in the eventviewer but the PWA shows success

I

I-Ali

Hi All:

We use Project Server 2002 SP1. When the OLAP finished it showed teh message
that it has successfully finished. However in the Event viewer, I can see
these 2 warnings and 2 errors when the OLAP finished. I have cut pasted them
sequentially below. Can you please point me to the source of the error? OLAP
used to finish in 2 hours but now it is taking 9 hours to finish. No major
data addition. Infact, we removed projects and added more memory to our SQL
server. Any help to the cause of error and what measures to take to avoide
these errors would be appreciated.

Also, I have cleaned up all teh enterprise resources for special characters.
Do all local resources on individual plans also need to be special characters
free?

Please advise.

Warning
--------

The description for Event ID ( 1 ) in Source ( Microsoft Project Server
Tracing Eventlog Provider ) cannot be found. The local computer may not have
the necessary registry information or message DLL files to display messages
from a remote computer. The following information is part of the event:
Component: Views Notification Service
File: C:\Proj10\pcportal\source\viewsnotify\ViewNotify.cpp
Line: 127
Error Number: 0x800a0005
Description: The views processor failed to process the following document:


<ViewsDropData>
<ProjectData>
<EntProjectName><![CDATA[resglobal] ]></EntProjectName>
<EntResourceIDList>*</EntResourceIDList>
<EntResourceStartDate>2001-11-13T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2008-12-20T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20011113</CubeStart><CubeFinish>20081219</CubeFinish><Connection>Provider=SQLOLEDB;
Persist Security Info=False;Initial Catalog=ABCprojectserver;Data
Source=SQLBOX0110</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ABCprojectserver;Data
Source=SQLBOX0110;Connect
Timeout=15</DSOConnection><Server>SQLBOX0110</Server><CubeDB>ABCProjectCube</CubeDB><CubeDesc>ABCProjectCube</CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>06150F2B-B302-4B0E-B6E5-003EC3073606</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>ProjectServer</OrgGuid>
<BasePath>ProjectServer</BasePath>
<TimeStamp>2005-03-02T01:52:59</TimeStamp>
</ViewsDropData>

..



---------------------------------------------------------------------------------------------

Error
-----

The description for Event ID ( 2 ) in Source ( Microsoft Project Server
Tracing Eventlog Provider ) cannot be found. The local computer may not have
the necessary registry information or message DLL files to display messages
from a remote computer. The following information is part of the event:
Component: PCSViews
File: ViewsDrop.cls
Line: -1
Description: Error Information:
Additional Information: An error occured calling
CallViewGenerator(ProjectServer, ProjectServer, -1, <ProjectData>
<EntProjectName><![CDATA[resglobal] ]></EntProjectName>
<EntResourceIDList>*</EntResourceIDList>
<EntResourceStartDate>2001-11-13T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2008-12-20T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20011113</CubeStart><CubeFinish>20081219</CubeFinish><Connection>Provider=SQLOLEDB;
Persist Security Info=False;Initial Catalog=ABCprojectserver;Data
Source=SQLBOX0110</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ABCprojectserver;Data
Source=SQLBOX0110;Connect
Timeout=15</DSOConnection><Server>SQLBOX0110</Server><CubeDB>ABCProjectCube</CubeDB><CubeDesc>ABCProjectCube</CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>06150F2B-B302-4B0E-B6E5-003EC3073606</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>)

..


---------------------------------------------------------------------------------------------

Warning
-------

The description for Event ID ( 1 ) in Source ( Microsoft Project Server
Tracing Eventlog Provider ) cannot be found. The local computer may not have
the necessary registry information or message DLL files to display messages
from a remote computer. The following information is part of the event:
Component: Views Notification Service
File: C:\Proj10\pcportal\source\viewsnotify\ViewNotify.cpp
Line: 122
Error Number: 0x800a0005
Description: View schedular received error while scheduling views
___________________________________

Component: PCSViews
File: ViewsDrop.cls
Line: -1
Error Number: 0x5
Description: Error Information: Invalid procedure call or argument
Additional Information: An error occured processing the following view :-

<ViewsDropData>
<ProjectData>
<EntProjectName><![CDATA[resglobal] ]></EntProjectName>
<EntResourceIDList>*</EntResourceIDList>
<EntResourceStartDate>2001-11-13T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2008-12-20T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20011113</CubeStart><CubeFinish>20081219</CubeFinish><Connection>Provider=SQLOLEDB;
Persist Security Info=False;Initial Catalog=ABCprojectserver;Data
Source=SQLBOX0110</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ABCprojectserver;Data
Source=SQLBOX0110;Connect
Timeout=15</DSOConnection><Server>SQLBOX0110</Server><CubeDB>ABCProjectCube</CubeDB><CubeDesc>ABCProjectCube</CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>06150F2B-B302-4B0E-B6E5-003EC3073606</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>ProjectServer</OrgGuid>
<BasePath>ProjectServer</BasePath>
<TimeStamp>2005-03-02T01:52:59</TimeStamp>
</ViewsDropData>


..
---------------------------------------------------------------------------------------------
Error
-----


The description for Event ID ( 2 ) in Source ( Microsoft Project Server
Tracing Eventlog Provider ) cannot be found. The local computer may not have
the necessary registry information or message DLL files to display messages
from a remote computer. The following information is part of the event:
Component: PCSViews
File: ViewsDrop.cls
Line: -1
Error Number: 0x5
Description: Error Information: Invalid procedure call or argument
Additional Information: An error occured processing the following view :-

<ViewsDropData>
<ProjectData>
<EntProjectName><![CDATA[resglobal] ]></EntProjectName>
<EntResourceIDList>*</EntResourceIDList>
<EntResourceStartDate>2001-11-13T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2008-12-20T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20011113</CubeStart><CubeFinish>20081219</CubeFinish><Connection>Provider=SQLOLEDB;
Persist Security Info=False;Initial Catalog=ABCprojectserver;Data
Source=SQLBOX0110</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ABCprojectserver;Data
Source=SQLBOX0110;Connect
Timeout=15</DSOConnection><Server>SQLBOX0110</Server><CubeDB>ABCProjectCube</CubeDB><CubeDesc>ABCProjectCube</CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>06150F2B-B302-4B0E-B6E5-003EC3073606</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>ProjectServer</OrgGuid>
<BasePath>ProjectServer</BasePath>
<TimeStamp>2005-03-02T01:52:59</TimeStamp>
</ViewsDropData>

..
 
E

Ed Morrison

Whenever I have an error using OLAP I check two things:
1. Can I manually process the cube from the Analysis Manager? If not, are
the olap roles defined properly? Is the connection correct?
2. Is the user id/password for the OLAP com object still valid?


Let us know if this helps.
--
Ed Morrison
msProjectExperts
"We wrote the books on Project Server"
http://www.msprojectexperts.com
FAQ - http://www.projectserverexperts.com



I-Ali said:
Hi All:

We use Project Server 2002 SP1. When the OLAP finished it showed teh message
that it has successfully finished. However in the Event viewer, I can see
these 2 warnings and 2 errors when the OLAP finished. I have cut pasted them
sequentially below. Can you please point me to the source of the error? OLAP
used to finish in 2 hours but now it is taking 9 hours to finish. No major
data addition. Infact, we removed projects and added more memory to our SQL
server. Any help to the cause of error and what measures to take to avoide
these errors would be appreciated.

Also, I have cleaned up all teh enterprise resources for special characters.
Do all local resources on individual plans also need to be special characters
free?

Please advise.

Warning
--------

The description for Event ID ( 1 ) in Source ( Microsoft Project Server
Tracing Eventlog Provider ) cannot be found. The local computer may not have
the necessary registry information or message DLL files to display messages
from a remote computer. The following information is part of the event:
Component: Views Notification Service
File: C:\Proj10\pcportal\source\viewsnotify\ViewNotify.cpp
Line: 127
Error Number: 0x800a0005
Description: The views processor failed to process the following document:


<ViewsDropData>
<ProjectData>
<EntProjectName><![CDATA[resglobal] ]></EntProjectName>
<EntResourceIDList>*</EntResourceIDList>
<EntResourceStartDate>2001-11-13T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2008-12-20T00:00:00</EntResourceFinishDate>
Click to expand...
Persist Security Info=False;Initial Catalog=ABCprojectserver;Data
Click to expand...
Source=SQLBOX0110 said:
Security Info=False;Initial Catalog=ABCprojectserver;Data
Source=SQLBOX0110;Connect
Timeout=15 said:
<CubeGUID>06150F2B-B302-4B0E-B6E5-003EC3073606</CubeGUID></CubeUpdate></Bui ldCubeRequest>
</ProjectData>
<OrgGuid>ProjectServer</OrgGuid>
<BasePath>ProjectServer</BasePath>
<TimeStamp>2005-03-02T01:52:59</TimeStamp>
</ViewsDropData>

.



--------------------------------------------------------------------------
Click to expand...
-------------------

Error
-----

The description for Event ID ( 2 ) in Source ( Microsoft Project Server
Tracing Eventlog Provider ) cannot be found. The local computer may not have
the necessary registry information or message DLL files to display messages
from a remote computer. The following information is part of the event:
Component: PCSViews
File: ViewsDrop.cls
Line: -1
Description: Error Information:
Additional Information: An error occured calling
CallViewGenerator(ProjectServer, ProjectServer, -1, <ProjectData>
<EntProjectName><![CDATA[resglobal] ]></EntProjectName>
<EntResourceIDList>*</EntResourceIDList>
<EntResourceStartDate>2001-11-13T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2008-12-20T00:00:00</EntResourceFinishDate>
Click to expand...
Persist Security Info=False;Initial Catalog=ABCprojectserver;Data
Click to expand...
Source=SQLBOX0110 said:
Security Info=False;Initial Catalog=ABCprojectserver;Data
Source=SQLBOX0110;Connect
Timeout=15 said:
<CubeGUID>06150F2B-B302-4B0E-B6E5-003EC3073606</CubeGUID></CubeUpdate></Bui ldCubeRequest>
</ProjectData>)

.


--------------------------------------------------------------------------
Click to expand...
-------------------

Warning
-------

The description for Event ID ( 1 ) in Source ( Microsoft Project Server
Tracing Eventlog Provider ) cannot be found. The local computer may not have
the necessary registry information or message DLL files to display messages
from a remote computer. The following information is part of the event:
Component: Views Notification Service
File: C:\Proj10\pcportal\source\viewsnotify\ViewNotify.cpp
Line: 122
Error Number: 0x800a0005
Description: View schedular received error while scheduling views
___________________________________

Component: PCSViews
File: ViewsDrop.cls
Line: -1
Error Number: 0x5
Description: Error Information: Invalid procedure call or argument
Additional Information: An error occured processing the following view :-

<ViewsDropData>
<ProjectData>
<EntProjectName><![CDATA[resglobal] ]></EntProjectName>
<EntResourceIDList>*</EntResourceIDList>
<EntResourceStartDate>2001-11-13T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2008-12-20T00:00:00</EntResourceFinishDate>
Click to expand...
Persist Security Info=False;Initial Catalog=ABCprojectserver;Data
Click to expand...
Source=SQLBOX0110 said:
Security Info=False;Initial Catalog=ABCprojectserver;Data
Source=SQLBOX0110;Connect
Timeout=15 said:
<CubeGUID>06150F2B-B302-4B0E-B6E5-003EC3073606</CubeGUID></CubeUpdate></Bui ldCubeRequest>
</ProjectData>
<OrgGuid>ProjectServer</OrgGuid>
<BasePath>ProjectServer</BasePath>
<TimeStamp>2005-03-02T01:52:59</TimeStamp>
</ViewsDropData>


.
--------------------------------------------------------------------------
Click to expand...
-------------------
Error
-----


The description for Event ID ( 2 ) in Source ( Microsoft Project Server
Tracing Eventlog Provider ) cannot be found. The local computer may not have
the necessary registry information or message DLL files to display messages
from a remote computer. The following information is part of the event:
Component: PCSViews
File: ViewsDrop.cls
Line: -1
Error Number: 0x5
Description: Error Information: Invalid procedure call or argument
Additional Information: An error occured processing the following view :-

<ViewsDropData>
<ProjectData>
<EntProjectName><![CDATA[resglobal] ]></EntProjectName>
<EntResourceIDList>*</EntResourceIDList>
<EntResourceStartDate>2001-11-13T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2008-12-20T00:00:00</EntResourceFinishDate>
Click to expand...
 
I

I-Ali

Thanks for your suggestions, Ed. I will give them a try.

-iali

Ed Morrison said:
Whenever I have an error using OLAP I check two things:
1. Can I manually process the cube from the Analysis Manager? If not, are
the olap roles defined properly? Is the connection correct?
2. Is the user id/password for the OLAP com object still valid?


Let us know if this helps.
--
Ed Morrison
msProjectExperts
"We wrote the books on Project Server"
http://www.msprojectexperts.com
FAQ - http://www.projectserverexperts.com



I-Ali said:
Hi All:

We use Project Server 2002 SP1. When the OLAP finished it showed teh message
that it has successfully finished. However in the Event viewer, I can see
these 2 warnings and 2 errors when the OLAP finished. I have cut pasted them
sequentially below. Can you please point me to the source of the error? OLAP
used to finish in 2 hours but now it is taking 9 hours to finish. No major
data addition. Infact, we removed projects and added more memory to our SQL
server. Any help to the cause of error and what measures to take to avoide
these errors would be appreciated.

Also, I have cleaned up all teh enterprise resources for special characters.
Do all local resources on individual plans also need to be special characters
free?

Please advise.

Warning
--------

The description for Event ID ( 1 ) in Source ( Microsoft Project Server
Tracing Eventlog Provider ) cannot be found. The local computer may not have
the necessary registry information or message DLL files to display messages
from a remote computer. The following information is part of the event:
Component: Views Notification Service
File: C:\Proj10\pcportal\source\viewsnotify\ViewNotify.cpp
Line: 127
Error Number: 0x800a0005
Description: The views processor failed to process the following document:


<ViewsDropData>
<ProjectData>
<EntProjectName><![CDATA[resglobal] ]></EntProjectName>
<EntResourceIDList>*</EntResourceIDList>
<EntResourceStartDate>2001-11-13T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2008-12-20T00:00:00</EntResourceFinishDate>
Click to expand...
Persist Security Info=False;Initial Catalog=ABCprojectserver;Data
Click to expand...
Source=SQLBOX0110 said:
Security Info=False;Initial Catalog=ABCprojectserver;Data
Source=SQLBOX0110;Connect
Timeout=15 said:
<CubeGUID>06150F2B-B302-4B0E-B6E5-003EC3073606</CubeGUID></CubeUpdate></Bui ldCubeRequest>
</ProjectData>
<OrgGuid>ProjectServer</OrgGuid>
<BasePath>ProjectServer</BasePath>
<TimeStamp>2005-03-02T01:52:59</TimeStamp>
</ViewsDropData>

.



--------------------------------------------------------------------------
Click to expand...
-------------------

Error
-----

The description for Event ID ( 2 ) in Source ( Microsoft Project Server
Tracing Eventlog Provider ) cannot be found. The local computer may not have
the necessary registry information or message DLL files to display messages
from a remote computer. The following information is part of the event:
Component: PCSViews
File: ViewsDrop.cls
Line: -1
Description: Error Information:
Additional Information: An error occured calling
CallViewGenerator(ProjectServer, ProjectServer, -1, <ProjectData>
<EntProjectName><![CDATA[resglobal] ]></EntProjectName>
<EntResourceIDList>*</EntResourceIDList>
<EntResourceStartDate>2001-11-13T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2008-12-20T00:00:00</EntResourceFinishDate>
Click to expand...
Persist Security Info=False;Initial Catalog=ABCprojectserver;Data
Click to expand...
Source=SQLBOX0110 said:
Security Info=False;Initial Catalog=ABCprojectserver;Data
Source=SQLBOX0110;Connect
Timeout=15 said:
<CubeGUID>06150F2B-B302-4B0E-B6E5-003EC3073606</CubeGUID></CubeUpdate></Bui ldCubeRequest>
</ProjectData>)

.


--------------------------------------------------------------------------
Click to expand...
-------------------

Warning
-------

The description for Event ID ( 1 ) in Source ( Microsoft Project Server
Tracing Eventlog Provider ) cannot be found. The local computer may not have
the necessary registry information or message DLL files to display messages
from a remote computer. The following information is part of the event:
Component: Views Notification Service
File: C:\Proj10\pcportal\source\viewsnotify\ViewNotify.cpp
Line: 122
Error Number: 0x800a0005
Description: View schedular received error while scheduling views
___________________________________

Component: PCSViews
File: ViewsDrop.cls
Line: -1
Error Number: 0x5
Description: Error Information: Invalid procedure call or argument
Additional Information: An error occured processing the following view :-

<ViewsDropData>
<ProjectData>
<EntProjectName><![CDATA[resglobal] ]></EntProjectName>
<EntResourceIDList>*</EntResourceIDList>
<EntResourceStartDate>2001-11-13T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2008-12-20T00:00:00</EntResourceFinishDate>
Click to expand...
Persist Security Info=False;Initial Catalog=ABCprojectserver;Data
Click to expand...
Source=SQLBOX0110 said:
Security Info=False;Initial Catalog=ABCprojectserver;Data
Source=SQLBOX0110;Connect
Timeout=15 said:
<CubeGUID>06150F2B-B302-4B0E-B6E5-003EC3073606</CubeGUID></CubeUpdate></Bui ldCubeRequest>
</ProjectData>
<OrgGuid>ProjectServer</OrgGuid>
<BasePath>ProjectServer</BasePath>
<TimeStamp>2005-03-02T01:52:59</TimeStamp>
</ViewsDropData>


.
--------------------------------------------------------------------------
Click to expand...
-------------------
Error
-----


The description for Event ID ( 2 ) in Source ( Microsoft Project Server
Tracing Eventlog Provider ) cannot be found. The local computer may not have
the necessary registry information or message DLL files to display messages
from a remote computer. The following information is part of the event:
Component: PCSViews
File: ViewsDrop.cls
Line: -1
Error Number: 0x5
Description: Error Information: Invalid procedure call or argument
Additional Information: An error occured processing the following view :-

<ViewsDropData>
<ProjectData>
<EntProjectName><![CDATA[resglobal] ]></EntProjectName>
<EntResourceIDList>*</EntResourceIDList>
<EntResourceStartDate>2001-11-13T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2008-12-20T00:00:00</EntResourceFinishDate>
Click to expand...
Persist Security Info=False;Initial Catalog=ABCprojectserver;Data
Click to expand...
Source=SQLBOX0110 said:
Security Info=False;Initial Catalog=ABCprojectserver;Data
Source=SQLBOX0110;Connect

ldCubeRequest>
</ProjectData>
<OrgGuid>ProjectServer</OrgGuid>
<BasePath>ProjectServer</BasePath>
<TimeStamp>2005-03-02T01:52:59</TimeStamp>
</ViewsDropData>

.
----------------------------------------------------------------------

Thanks for your help.

I-Ali
Click to expand...
Click to expand...
 

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

Similar Threads

Cube building doesn't update PS database? HELP! 2
Cube building problem!! 11
Cube build fails, security check failure 11
OLAP CUBE ERROR in Project Server 2003 environment..Need help!!!!! 1
Having trouble building OLAP cube 2
Cube failed - (-2147221492) Unable to save object. 1
OLAP Cube creation errors 4
OLAP Cube Creation Error 3

Top