?
Solved

Unable to build OLAP cube with Project Server 2003

Posted on 2008-11-20
3
Medium Priority
?
803 Views
Last Modified: 2013-11-16
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>

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


0
Comment
Question by:anidada
  • 3
3 Comments
 

Author Comment

by:anidada
ID: 23011974
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
 

Author Comment

by:anidada
ID: 23018917
Hi

I still haven't received any response.
0
 

Accepted Solution

by:
anidada earned 0 total points
ID: 23033345
Hi

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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question