Unable to build OLAP cube with Project Server 2003

Hi
I am using Project Server 2003 SP2a with SQL and Analysis 2005 with 9.0.3282 version.
I have Application, wss and Analysis on box1 and SQL database on box2.
I have installed hotfix921115\921116 to build OLAP cube with Analysis 2005 and followed steps in KB921116. When I initate cube building process, status shows as initiated and it never changes. I could see .xml file is generated and moves very quickly from view drop folder.
I have tried deleting and creating COM+ objects for OLAP and feel all permissions are accurate.
I could see following errors in application log.

Appreciate your help.

Warining #1 ............................................
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>2008-09-01T00:00:00</EntResourceStartDate>
            <EntResourceFinishDate>2008-09-28T00:00:00</EntResourceFinishDate>
            <BuildCubeRequest><CubeUpdate><CubeStart>20080901</CubeStart><CubeFinish>20080928</CubeFinish><Connection>Provider=SQLOLEDB; Initial Catalog=projectserver3664;Data Source=rcosvr20836</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist Security Info=False;Initial Catalog=projectserver3664;Data Source=rcosvr20836</DSOConnection><Server>rcosvr20836</Server><CubeDB>anilolaptest</CubeDB><CubeDesc></CubeDesc><BasePath>projectserver</BasePath><CubeGUID>94F3BB3F-7047-4DB1-BD29-E2D8DBB43265</CubeGUID></CubeUpdate></BuildCubeRequest>
      </ProjectData>
      <OrgGuid>projectserver</OrgGuid>
      <BasePath>projectserver</BasePath>
      <TimeStamp>2008-11-19T08:12:46</TimeStamp>
</ViewsDropData>]]></Description>

Warning # 2............................
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>2008-09-01T00:00:00</EntResourceStartDate>
            <EntResourceFinishDate>2008-09-28T00:00:00</EntResourceFinishDate>
            <BuildCubeRequest><CubeUpdate><CubeStart>20080901</CubeStart><CubeFinish>20080928</CubeFinish><Connection>Provider=SQLOLEDB; Initial Catalog=projectserver3664;Data Source=rcosvr20836</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist Security Info=False;Initial Catalog=projectserver3664;Data Source=rcosvr20836</DSOConnection><Server>rcosvr20836</Server><CubeDB>anilolaptest</CubeDB><CubeDesc></CubeDesc><BasePath>projectserver</BasePath><CubeGUID>94F3BB3F-7047-4DB1-BD29-E2D8DBB43265</CubeGUID></CubeUpdate></BuildCubeRequest>
      </ProjectData>
      <OrgGuid>projectserver</OrgGuid>
      <BasePath>projectserver</BasePath>
      <TimeStamp>2008-11-19T08:12:46</TimeStamp>
</ViewsDropData>]]></Description>

Error # 1............................................................
 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>2008-09-01T00:00:00</EntResourceStartDate>
            <EntResourceFinishDate>2008-09-28T00:00:00</EntResourceFinishDate>
            <BuildCubeRequest><CubeUpdate><CubeStart>20080901</CubeStart><CubeFinish>20080928</CubeFinish><Connection>Provider=SQLOLEDB; Initial Catalog=projectserver3664;Data Source=rcosvr20836</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist Security Info=False;Initial Catalog=projectserver3664;Data Source=rcosvr20836</DSOConnection><Server>rcosvr20836</Server><CubeDB>anilolaptest</CubeDB><CubeDesc></CubeDesc><BasePath>projectserver</BasePath><CubeGUID>94F3BB3F-7047-4DB1-BD29-E2D8DBB43265</CubeGUID></CubeUpdate></BuildCubeRequest>
      </ProjectData>
      <OrgGuid>projectserver</OrgGuid>
      <BasePath>projectserver</BasePath>
      <TimeStamp>2008-11-19T08:12:46</TimeStamp>
</ViewsDropData>]]></Description>

Error # 2...............................................
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>2008-09-01T00:00:00</EntResourceStartDate>
      <EntResourceFinishDate>2008-09-28T00:00:00</EntResourceFinishDate>
      <BuildCubeRequest><CubeUpdate><CubeStart>20080901</CubeStart><CubeFinish>20080928</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist Security Info=False;Initial Catalog=projectserver3664;Data Source=rcosvr20836</DSOConnection><Server>rcosvr20836</Server><CubeDB>anilolaptest</CubeDB><CubeDesc></CubeDesc><BasePath>projectserver</BasePath><CubeGUID>94F3BB3F-7047-4DB1-BD29-E2D8DBB43265</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>)]]></Description>

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


anidadaAsked:
Who is Participating?
 
anidadaConnect With a Mentor Author Commented:
Hi

It has been 5 days and I haven't received any response. Thanks for your help Experts-exchange!!!
0
 
anidadaAuthor Commented:
Hi

It has been 24hrs and I haven't received any response. Is there any SLA?

Can you please consider this as high priority.

Appreciate your help.
0
 
anidadaAuthor Commented:
Hi

I still haven't received any response.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.