OLAP cube build fails with error number -2147221411

M

mblagen

Our OLAP cube build is scheduled to be rebuilt every night at 12:30 AM.. It
often fails with error number -2147221411.
Once it fails, it continues to fail until the projservcube is restored from
a backup, some ProjectServer database tables are truncated and the cube is
rebuilt again. I am a novice with this product and don't know where to look.

Please help. I'm not sure what information would help.

Thank you in advance.

We have the following configuration. MS Project Server 2003 and SQL Server
2000 Standard Edition SP1 are installed on one 2 CPU server with OS Windows
2003. Analysis Services is installed on another 2 CPU server with OS Windows
2003 SP1. The servers are rarely bounced. They are backed up by the HP
Openview Storage Data Protector.

The IIS Connection Timeout is set to 120 seconds.

The first day of failure there are four messages in the Event Viewer marked
Error followed by two marked Warning.
The first message begins
Component: MSP Resource Availablity Refresh and OLAP Cube Creation Component
(ProjOLAP)
File: PROJOLAPProcess
Line: 3061
Description: <Description><![CDATA[Error #: -2147221411 Desc.
:]]></Description>

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

The third message begins
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>

The fourth message begins
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>

The first warning begins
omponent: 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:

The second warning begins
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>
 
P

Paul Conroy

I would start with installing the latest SQL Service Pack. Also apply the
latest service pack to the DSO components on your Front-End Project Server .
Make sure the account under which the views processor is running is in the
OLAP admin group.

mblagen said:
Our OLAP cube build is scheduled to be rebuilt every night at 12:30 AM.. It
often fails with error number -2147221411.
Once it fails, it continues to fail until the projservcube is restored from
a backup, some ProjectServer database tables are truncated and the cube is
rebuilt again. I am a novice with this product and don't know where to look.

Please help. I'm not sure what information would help.

Thank you in advance.

We have the following configuration. MS Project Server 2003 and SQL Server
2000 Standard Edition SP1 are installed on one 2 CPU server with OS Windows
2003. Analysis Services is installed on another 2 CPU server with OS Windows
2003 SP1. The servers are rarely bounced. They are backed up by the HP
Openview Storage Data Protector.

The IIS Connection Timeout is set to 120 seconds.

The first day of failure there are four messages in the Event Viewer marked
Error followed by two marked Warning.
The first message begins
Component: MSP Resource Availablity Refresh and OLAP Cube Creation Component
(ProjOLAP)
File: PROJOLAPProcess
Line: 3061
Description: <Description><![CDATA[Error #: -2147221411 Desc.
:]]></Description>

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

The third message begins
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>

The fourth message begins
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>

The first warning begins
omponent: 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:

The second warning begins
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>
Click to expand...
 
M

mblagen

Thank you, Paul.

I have found that we are on SQL Server SP3a rather than SP1 as I reported.

I understand that there is now a SP4 which I will download and apply.

I will report if the upgrade solves the problem.

Paul Conroy said:
I would start with installing the latest SQL Service Pack. Also apply the
latest service pack to the DSO components on your Front-End Project Server .
Make sure the account under which the views processor is running is in the
OLAP admin group.

mblagen said:
Our OLAP cube build is scheduled to be rebuilt every night at 12:30 AM.. It
often fails with error number -2147221411.
Once it fails, it continues to fail until the projservcube is restored from
a backup, some ProjectServer database tables are truncated and the cube is
rebuilt again. I am a novice with this product and don't know where to look.

Please help. I'm not sure what information would help.

Thank you in advance.

We have the following configuration. MS Project Server 2003 and SQL Server
2000 Standard Edition SP1 are installed on one 2 CPU server with OS Windows
2003. Analysis Services is installed on another 2 CPU server with OS Windows
2003 SP1. The servers are rarely bounced. They are backed up by the HP
Openview Storage Data Protector.

The IIS Connection Timeout is set to 120 seconds.

The first day of failure there are four messages in the Event Viewer marked
Error followed by two marked Warning.
The first message begins
Component: MSP Resource Availablity Refresh and OLAP Cube Creation Component
(ProjOLAP)
File: PROJOLAPProcess
Line: 3061
Description: <Description><![CDATA[Error #: -2147221411 Desc.
:]]></Description>

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

The third message begins
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>

The fourth message begins
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>

The first warning begins
omponent: 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:

The second warning begins
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>
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 problem!! 11
Cube build fails, security check failure 11
Having trouble building OLAP cube 2
OLAP Cube Problems...The cube building process was initiated ... 1
Cube failed - (-2147221492) Unable to save object. 1
OLAP CUBE ERROR in Project Server 2003 environment..Need help!!!!! 1
OLAP Cube creation errors 4
PWA 2003's view cannot be updated & Can't build a OLAP cube. 5

Top