OLAP CUBE ERROR in Project Server 2003 environment..Need help!!!!!

E

EPM Consultant

Hi,

The OLAP cube is getting failed from last 2 days and giving the following
error in PWA. I have also attached Application log events for your reviews.
Please help me to sort out this problem.

(-2147221492) Unable to save object. The object has been modified by another
application.

Note:

Last week it was working absolutely fine and cube was building in just 2
hours. But from last 3-4 days, initially it was taking a lot of time to build
cube (around 8 hours) and now this error. The cube is scheduled at 12:00 am
daily.

-MS EPM Consultant



===========Application Log events===================
Component: MSP Resource Availablity Refresh and OLAP Cube Creation Component
(ProjOLAP)
File: PROJOLAPProcess
Line: 3008
Description: <Description><![CDATA[Error #: -2147221492 Desc. :Unable to
save object. The object has been modified by another
application.]]></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-01-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2009-12-31T00:00:00</EntResourceFinishDate>


<BuildCubeRequest><CubeUpdate><CubeStart>20070101</CubeStart><CubeFinish>20091231</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist

Security Info=False;Initial Catalog=ProjectServer;Data
Source=MHCCPROJSQL01;Connect

Timeout=15</DSOConnection><Server>MHCCPROJSQL01</Server><CubeDB>ProjectServer</CubeDB><CubeDesc></CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>03B37D

CA-EFE0-48D1-897D-F76996FA097C</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>)]]></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>20070101</CubeStart><CubeFinish>20091231</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist

Security Info=False;Initial Catalog=ProjectServer;Data
Source=MHCCPROJSQL01;Connect

Timeout=15</DSOConnection><Server>MHCCPROJSQL01</Server><CubeDB>ProjectServer</CubeDB><CubeDesc></CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>03B37D

CA-EFE0-48D1-897D-F76996FA097C</CubeGUID></CubeUpdate></BuildCubeRequest>]]></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-01-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2009-12-31T00:00:00</EntResourceFinishDate
<BuildCubeRequest><CubeUpdate><CubeStart>20070101</CubeStart><CubeFinish>20091231</CubeFinish><Connection>Provider=SQLOLEDB; Initial

Catalog=ProjectServer;Data
Source=MHCCPROJSQL01</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist Security Info=False;Initial

Catalog=ProjectServer;Data Source=MHCCPROJSQL01;Connect

Timeout=15</DSOConnection><Server>MHCCPROJSQL01</Server><CubeDB>ProjectServer</CubeDB><CubeDesc></CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>03B37D

CA-EFE0-48D1-897D-F76996FA097C</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>ProjectServer</OrgGuid>
<BasePath>ProjectServer</BasePath>
<TimeStamp>2008-08-21T00:54:09</TimeStamp>
</ViewsDropData>]]></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-01-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2009-12-31T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20070101</CubeStart><CubeFinish>20091231</CubeFinish><Connection>Provider=SQLOLEDB; Initial

Catalog=ProjectServer;Data
Source=MHCCPROJSQL01</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist Security Info=False;Initial

Catalog=ProjectServer;Data Source=MHCCPROJSQL01;Connect

Timeout=15</DSOConnection><Server>MHCCPROJSQL01</Server><CubeDB>ProjectServer</CubeDB><CubeDesc></CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>03B37D

CA-EFE0-48D1-897D-F76996FA097C</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>ProjectServer</OrgGuid>
<BasePath>ProjectServer</BasePath>
<TimeStamp>2008-08-21T00:54:09</TimeStamp>
</ViewsDropData>]]></Description>
 
G

Gary L. Chefetz [MVP]

EMPC:

This error is a general "access denied" coming from SQL. I suggest you run
the SQL profiler to diagnose further.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com


EPM Consultant said:
Hi,

The OLAP cube is getting failed from last 2 days and giving the following
error in PWA. I have also attached Application log events for your
reviews.
Please help me to sort out this problem.

(-2147221492) Unable to save object. The object has been modified by
another
application.

Note:

Last week it was working absolutely fine and cube was building in just 2
hours. But from last 3-4 days, initially it was taking a lot of time to
build
cube (around 8 hours) and now this error. The cube is scheduled at 12:00
am
daily.

-MS EPM Consultant



===========Application Log events===================
Component: MSP Resource Availablity Refresh and OLAP Cube Creation
Component
(ProjOLAP)
File: PROJOLAPProcess
Line: 3008
Description: <Description><![CDATA[Error #: -2147221492 Desc. :Unable to
save object. The object has been modified by another
application.]]></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-01-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2009-12-31T00:00:00</EntResourceFinishDate>


<BuildCubeRequest><CubeUpdate><CubeStart>20070101</CubeStart><CubeFinish>20091231</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist

Security Info=False;Initial Catalog=ProjectServer;Data
Source=MHCCPROJSQL01;Connect

Timeout=15</DSOConnection><Server>MHCCPROJSQL01</Server><CubeDB>ProjectServer</CubeDB><CubeDesc></CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>03B37D

CA-EFE0-48D1-897D-F76996FA097C</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>)]]></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>20070101</CubeStart><CubeFinish>20091231</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist

Security Info=False;Initial Catalog=ProjectServer;Data
Source=MHCCPROJSQL01;Connect

Timeout=15</DSOConnection><Server>MHCCPROJSQL01</Server><CubeDB>ProjectServer</CubeDB><CubeDesc></CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>03B37D

CA-EFE0-48D1-897D-F76996FA097C</CubeGUID></CubeUpdate></BuildCubeRequest>]]></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-01-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2009-12-31T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20070101</CubeStart><CubeFinish>20091231</CubeFinish><Connection>Provider=SQLOLEDB;
Initial

Catalog=ProjectServer;Data
Source=MHCCPROJSQL01</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial

Catalog=ProjectServer;Data Source=MHCCPROJSQL01;Connect

Timeout=15</DSOConnection><Server>MHCCPROJSQL01</Server><CubeDB>ProjectServer</CubeDB><CubeDesc></CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>03B37D

CA-EFE0-48D1-897D-F76996FA097C</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>ProjectServer</OrgGuid>
<BasePath>ProjectServer</BasePath>
<TimeStamp>2008-08-21T00:54:09</TimeStamp>
</ViewsDropData>]]></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-01-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2009-12-31T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20070101</CubeStart><CubeFinish>20091231</CubeFinish><Connection>Provider=SQLOLEDB;
Initial

Catalog=ProjectServer;Data
Source=MHCCPROJSQL01</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial

Catalog=ProjectServer;Data Source=MHCCPROJSQL01;Connect

Timeout=15</DSOConnection><Server>MHCCPROJSQL01</Server><CubeDB>ProjectServer</CubeDB><CubeDesc></CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>03B37D

CA-EFE0-48D1-897D-F76996FA097C</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>ProjectServer</OrgGuid>
<BasePath>ProjectServer</BasePath>
<TimeStamp>2008-08-21T00:54:09</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

Cube building problem!! 11
Cube build fails, security check failure 11
Cube failed - (-2147221492) Unable to save object. 1
Having trouble building OLAP cube 2
OLAP Cube creation errors 4
OLAP Cube Creation Error 3
Cube building doesn't update PS database? HELP! 2
CANNOT GENERATE OLAP CUBE 12

Top