OLAP Error / Cube continuously builds

J

Jillian

Component: MSP Resource Availablity Refresh and OLAP Cube Creation Component
(ProjOLAP)
File: PROJOLAPProcess
Line: 14
Description: <Description><![CDATA[Unexpected error in FireOffBuildProcess.
Error: 'Connection to the server is lost'. Error code =
-2147221387]]></Description>
 
J

Jillian

I get 4 errors and 2 warnings:

Component: MSP Resource Availablity Refresh and OLAP Cube Creation Component
(ProjOLAP)
File: PROJOLAPProcess
Line: 14
Description: <Description><![CDATA[Unexpected error in FireOffBuildProcess.
Error: 'Connection to the server is lost'. Error code =
-2147221387]]></Description>

Component: PCSViews
File: ViewsDrop.cls
Line: -1
Error Number: 0x80004005
Description: <Description><![CDATA[Failed to generate OLAP Cube for the
following Request :

<BuildCubeRequest><CubeUpdate><CubeStart>20070319</CubeStart><CubeFinish>20111214</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServerProdDB;Data
Source=swssql1</DSOConnection><Server>swssql1</Server><CubeDB>MSP2003ProdCube</CubeDB><CubeDesc>Project
Server 2003
Cube</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>A7CDCAFD-D2AD-4646-B710-64B74F55091C</CubeGUID></CubeUpdate></BuildCubeRequest>]]></Description>


Component: PCSViews
File: ViewsDrop.cls
Line: -1
Description: <Description><![CDATA[Error Information:
Additional Information: An error occured calling
CallViewGenerator(projectserver, -1, <ProjectData>
<EntProjectName><![CDATA[resglobal] ]></EntProjectName>
<EntResourceIDList>*</EntResourceIDList>

<EntResourceStartDate>2007-03-19T00:00:00</EntResourceStartDate>

<EntResourceFinishDate>2011-12-14T00:00:00</EntResourceFinishDate>

<BuildCubeRequest><CubeUpdate><CubeStart>20070319</CubeStart><CubeFinish>20111214</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServerProdDB;Data
Source=swssql1</DSOConnection><Server>swssql1</Server><CubeDB>MSP2003ProdCube</CubeDB><CubeDesc>Project
Server 2003
Cube</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>A7CDCAFD-D2AD-4646-B710-64B74F55091C</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>)]]></Description>


Component: PCSViews
File: ViewsDrop.cls
Line: -1
Error Number: 0x5
Description: <Description><![CDATA[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>2007-03-19T00:00:00</EntResourceStartDate>

<EntResourceFinishDate>2011-12-14T00:00:00</EntResourceFinishDate>

<BuildCubeRequest><CubeUpdate><CubeStart>20070319</CubeStart><CubeFinish>20111214</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServerProdDB;Data
Source=swssql1</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServerProdDB;Data
Source=swssql1</DSOConnection><Server>swssql1</Server><CubeDB>MSP2003ProdCube</CubeDB><CubeDesc>Project
Server 2003
Cube</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>A7CDCAFD-D2AD-4646-B710-64B74F55091C</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2009-05-21T11:26:29</TimeStamp>
</ViewsDropData>]]></Description>



Component: Views Notification Service
File: C:\Office\devsp\project\pcportal\source\viewsnotify\ViewNotify.cpp
Line: 132
Error Number: 0x800a0005
Description: <Description><![CDATA[The views processor failed to process the
following document:


<ViewsDropData>
<ProjectData>
<EntProjectName><![CDATA[resglobal]
]></EntProjectName>
<EntResourceIDList>*</EntResourceIDList>

<EntResourceStartDate>2007-03-19T00:00:00</EntResourceStartDate>

<EntResourceFinishDate>2011-12-14T00:00:00</EntResourceFinishDate>

<BuildCubeRequest><CubeUpdate><CubeStart>20070319</CubeStart><CubeFinish>20111214</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServerProdDB;Data
Source=swssql1</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServerProdDB;Data
Source=swssql1</DSOConnection><Server>swssql1</Server><CubeDB>MSP2003ProdCube</CubeDB><CubeDesc>Project
Server 2003
Cube</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>A7CDCAFD-D2AD-4646-B710-64B74F55091C</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2009-05-21T11:26:29</TimeStamp>
</ViewsDropData>]]></Description>



Component: Views Notification Service
File: C:\Office\devsp\project\pcportal\source\viewsnotify\ViewNotify.cpp
Line: 127
Error Number: 0x800a0005
Description: <Description><![CDATA[View scheduler received error while
scheduling views]]></Description>
___________________________________

Component: PCSViews
File: ViewsDrop.cls
Line: -1
Error Number: 0x5
Description: <Description><![CDATA[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>2007-03-19T00:00:00</EntResourceStartDate>

<EntResourceFinishDate>2011-12-14T00:00:00</EntResourceFinishDate>

<BuildCubeRequest><CubeUpdate><CubeStart>20070319</CubeStart><CubeFinish>20111214</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServerProdDB;Data
Source=swssql1</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServerProdDB;Data
Source=swssql1</DSOConnection><Server>swssql1</Server><CubeDB>MSP2003ProdCube</CubeDB><CubeDesc>Project
Server 2003
Cube</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>A7CDCAFD-D2AD-4646-B710-64B74F55091C</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2009-05-21T11:26:29</TimeStamp>
</ViewsDropData>]]></Description>
 
G

Gary L. Chefetz

Jillian:

It's apparent that you're using 2003, but be sure to state that in future
posts. It would appear that the account that you're using for the OLAP
Administrator in DCOM may have become disabled because you are failing right
up front on the connection to SQL server. Check to make sure that the
account is working and you can connect to SQL server using the credentials.
Also, you may need to rerun the COM+ tool to re-establish identity for the
COM object.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com


Jillian said:
I get 4 errors and 2 warnings:

Component: MSP Resource Availablity Refresh and OLAP Cube Creation
Component
(ProjOLAP)
File: PROJOLAPProcess
Line: 14
Description: <Description><![CDATA[Unexpected error in
FireOffBuildProcess.
Error: 'Connection to the server is lost'. Error code =
-2147221387]]></Description>

Component: PCSViews
File: ViewsDrop.cls
Line: -1
Error Number: 0x80004005
Description: <Description><![CDATA[Failed to generate OLAP Cube for the
following Request :

<BuildCubeRequest><CubeUpdate><CubeStart>20070319</CubeStart><CubeFinish>20111214</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServerProdDB;Data
Source=swssql1</DSOConnection><Server>swssql1</Server><CubeDB>MSP2003ProdCube</CubeDB><CubeDesc>Project
Server 2003
Cube</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>A7CDCAFD-D2AD-4646-B710-64B74F55091C</CubeGUID></CubeUpdate></BuildCubeRequest>]]></Description>


Component: PCSViews
File: ViewsDrop.cls
Line: -1
Description: <Description><![CDATA[Error Information:
Additional Information: An error occured calling
CallViewGenerator(projectserver, -1, <ProjectData>
<EntProjectName><![CDATA[resglobal] ]></EntProjectName>
<EntResourceIDList>*</EntResourceIDList>

<EntResourceStartDate>2007-03-19T00:00:00</EntResourceStartDate>

<EntResourceFinishDate>2011-12-14T00:00:00</EntResourceFinishDate>

<BuildCubeRequest><CubeUpdate><CubeStart>20070319</CubeStart><CubeFinish>20111214</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServerProdDB;Data
Source=swssql1</DSOConnection><Server>swssql1</Server><CubeDB>MSP2003ProdCube</CubeDB><CubeDesc>Project
Server 2003
Cube</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>A7CDCAFD-D2AD-4646-B710-64B74F55091C</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>)]]></Description>


Component: PCSViews
File: ViewsDrop.cls
Line: -1
Error Number: 0x5
Description: <Description><![CDATA[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>2007-03-19T00:00:00</EntResourceStartDate>

<EntResourceFinishDate>2011-12-14T00:00:00</EntResourceFinishDate>

<BuildCubeRequest><CubeUpdate><CubeStart>20070319</CubeStart><CubeFinish>20111214</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServerProdDB;Data
Source=swssql1</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServerProdDB;Data
Source=swssql1</DSOConnection><Server>swssql1</Server><CubeDB>MSP2003ProdCube</CubeDB><CubeDesc>Project
Server 2003
Cube</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>A7CDCAFD-D2AD-4646-B710-64B74F55091C</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2009-05-21T11:26:29</TimeStamp>
</ViewsDropData>]]></Description>



Component: Views Notification Service
File: C:\Office\devsp\project\pcportal\source\viewsnotify\ViewNotify.cpp
Line: 132
Error Number: 0x800a0005
Description: <Description><![CDATA[The views processor failed to process
the
following document:


<ViewsDropData>
<ProjectData>
<EntProjectName><![CDATA[resglobal]
]></EntProjectName>
<EntResourceIDList>*</EntResourceIDList>

<EntResourceStartDate>2007-03-19T00:00:00</EntResourceStartDate>

<EntResourceFinishDate>2011-12-14T00:00:00</EntResourceFinishDate>

<BuildCubeRequest><CubeUpdate><CubeStart>20070319</CubeStart><CubeFinish>20111214</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServerProdDB;Data
Source=swssql1</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServerProdDB;Data
Source=swssql1</DSOConnection><Server>swssql1</Server><CubeDB>MSP2003ProdCube</CubeDB><CubeDesc>Project
Server 2003
Cube</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>A7CDCAFD-D2AD-4646-B710-64B74F55091C</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2009-05-21T11:26:29</TimeStamp>
</ViewsDropData>]]></Description>



Component: Views Notification Service
File: C:\Office\devsp\project\pcportal\source\viewsnotify\ViewNotify.cpp
Line: 127
Error Number: 0x800a0005
Description: <Description><![CDATA[View scheduler received error while
scheduling views]]></Description>
___________________________________

Component: PCSViews
File: ViewsDrop.cls
Line: -1
Error Number: 0x5
Description: <Description><![CDATA[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>2007-03-19T00:00:00</EntResourceStartDate>

<EntResourceFinishDate>2011-12-14T00:00:00</EntResourceFinishDate>

<BuildCubeRequest><CubeUpdate><CubeStart>20070319</CubeStart><CubeFinish>20111214</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServerProdDB;Data
Source=swssql1</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServerProdDB;Data
Source=swssql1</DSOConnection><Server>swssql1</Server><CubeDB>MSP2003ProdCube</CubeDB><CubeDesc>Project
Server 2003
Cube</CubeDesc><BasePath>projectserver</BasePath><CubeGUID>A7CDCAFD-D2AD-4646-B710-64B74F55091C</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2009-05-21T11:26:29</TimeStamp>
</ViewsDropData>]]></Description>
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

2003 Cube Refresh Error 0
Cube build fails, security check failure 11
OLAP Problem 2
Cannot build OLAP Cubes MSPS 2003 SP3 SQL Server 2005 SP2 1
OLAP Connection 5
Project Server errors (Microsoft Project Server Tracing Eventlog Provider_2_E) 3
Cube Build Problem 0
Could not connect to OLAP cube 2

Top