Olap Cube

[Doug Lutz]

I have a Project 2003 server and am unable to generate an OLAP cube. When I define the parameters for the cube and select Update Now it saves the settings and refreshes the page as normal. The Current Cube Status indicates that the cube building process has been initiated but it never completes, even after days. The cube doesw not appear in the Analysis Manager and I can't find any errors
There was a cube generated initially but it failed to complete an update so I tried to create a new one and now can't generate one at all
Any suggestions?

 

[Peter Jakab]

I have the same problem, in the application log in the event viewer I can
see error messages like this:

Component: Views Notification Service
File: C:\Office\dev\project\pcportal\source\viewsnotify\ViewNotify.cpp
Line: 238
Error Number: 0x800a005b
Description: <Description><![CDATA[Failed to create instance of views
scheduling component]]></Description>
___________________________________

Component: Views Notification Service
File: C:\Office\dev\project\pcportal\source\viewsnotify\ViewNotify.cpp
Line: 70
Error Number: 0x800a005b
Description: <Description><![CDATA[Failed to create instance of views
processing object (PCSViews.ViewsDrop). The service cannot continue to run,
shutting down.]]></Description>
___________________________________

Component: PCSViews
Description: <Description><![CDATA[Object variable or With block variable
not set]]></Description>


The status of cube generatiing is initiated, but never processing.




The PCSViews.ViewsDrop class is correctly registered (pcsviews.dll), but
even from a script I cannot instantiate a PCSViews.ViewsDrop object, I get
an Object variable or with block variable not set message with the
createobject. command.

So I have no idea, what can couse this.

Peter

You need to make sure the OLAP administrator has been created with the

correct permissions and the COM+ settings have been configured correctly. I
found all this information in the Microsoft Office Project Server 2003
Installation Guide, which you can download from Microsoft.

----- Doug Lutz wrote: -----

I have a Project 2003 server and am unable to generate an OLAP cube.

When I define the parameters for the cube and select Update Now it saves the
settings and refreshes the page as normal. The Current Cube Status
indicates that the cube building process has been initiated but it never
completes, even after days. The cube doesw not appear in the Analysis
Manager and I can't find any errors.

There was a cube generated initially but it failed to complete an

update so I tried to create a new one and now can't generate one at all.

 

[Peter Jakab]

My problem is solved.

Removed and reinstalled project server into another folder, connecting to
the existing database.
Now everything works fine.

Peter

I have the same problem, in the application log in the event viewer I can
see error messages like this:

Component: Views Notification Service
File: C:\Office\dev\project\pcportal\source\viewsnotify\ViewNotify.cpp
Line: 238
Error Number: 0x800a005b
Description: <Description><![CDATA[Failed to create instance of views
scheduling component]]></Description>
___________________________________

Component: Views Notification Service
File: C:\Office\dev\project\pcportal\source\viewsnotify\ViewNotify.cpp
Line: 70
Error Number: 0x800a005b
Description: <Description><![CDATA[Failed to create instance of views
processing object (PCSViews.ViewsDrop). The service cannot continue to run,
shutting down.]]></Description>
___________________________________

Component: PCSViews
Description: <Description><![CDATA[Object variable or With block variable
not set]]></Description>


The status of cube generatiing is initiated, but never processing.




The PCSViews.ViewsDrop class is correctly registered (pcsviews.dll), but
even from a script I cannot instantiate a PCSViews.ViewsDrop object, I get
an Object variable or with block variable not set message with the
createobject. command.

So I have no idea, what can couse this.

Peter

You need to make sure the OLAP administrator has been created with the

correct permissions and the COM+ settings have been configured correctly. I
found all this information in the Microsoft Office Project Server 2003
Installation Guide, which you can download from Microsoft.

----- Doug Lutz wrote: -----

I have a Project 2003 server and am unable to generate an OLAP

cube.
When I define the parameters for the cube and select Update Now it saves the
settings and refreshes the page as normal. The Current Cube Status
indicates that the cube building process has been initiated but it never
completes, even after days. The cube doesw not appear in the Analysis
Manager and I can't find any errors.

There was a cube generated initially but it failed to complete an

update so I tried to create a new one and now can't generate one at all.

Any suggestions?

 

[Jack Kohn]

Similar problems here.

At first, I saw permissions errors in the Event Log. Trying to debug
those, I added my own user ID to the OLAP Administrators group on both
the SQL Server and the Project Server. I still saw errors (but
different ones) in the Event Logs and the cube wouldn't build.

(One of the strange errors I got was:

Component: MSP Resource Availablity Refresh and OLAP Cube Creation Component (ProjOLAP)
File: PROJOLAPProcess
Line: 1
Description: <Description><![CDATA[DSO.Server.Connect failed with error message 'Cannot connect to the repository.
Analysis server: OUR_SQL_SERVER
Error:
Could not use ''; file already in use.' Error Number : '-2147221453]]></Description>

I finally got the cube to build by adding my user ID to the local
Admins groups on both the SQL server AND the Project Server.

This seems overkill. Although I use my day-to-day ID for Project
Server admin, I don't want that ID to be an admin on our SQL servers.

Is there something I missed? What ID can/should I use so a Project
Server admin (like me) can rebuild the OLAP cube without being a
superuser?

TIA.

-jmk
Jack Kohn
Chicago, IL

I have the same problem, in the application log in the event viewer I can
see error messages like this:

Component: Views Notification Service
File: C:\Office\dev\project\pcportal\source\viewsnotify\ViewNotify.cpp
Line: 238
Error Number: 0x800a005b
Description: <Description><![CDATA[Failed to create instance of views
scheduling component]]></Description>
___________________________________

Component: Views Notification Service
File: C:\Office\dev\project\pcportal\source\viewsnotify\ViewNotify.cpp
Line: 70
Error Number: 0x800a005b
Description: <Description><![CDATA[Failed to create instance of views
processing object (PCSViews.ViewsDrop). The service cannot continue to run,
shutting down.]]></Description>
___________________________________

Component: PCSViews
Description: <Description><![CDATA[Object variable or With block variable
not set]]></Description>


The status of cube generatiing is initiated, but never processing.




The PCSViews.ViewsDrop class is correctly registered (pcsviews.dll), but
even from a script I cannot instantiate a PCSViews.ViewsDrop object, I get
an Object variable or with block variable not set message with the
createobject. command.

So I have no idea, what can couse this.

Peter

You need to make sure the OLAP administrator has been created with the

correct permissions and the COM+ settings have been configured correctly. I
found all this information in the Microsoft Office Project Server 2003
Installation Guide, which you can download from Microsoft.

----- Doug Lutz wrote: -----

I have a Project 2003 server and am unable to generate an OLAP cube.

When I define the parameters for the cube and select Update Now it saves the
settings and refreshes the page as normal. The Current Cube Status
indicates that the cube building process has been initiated but it never
completes, even after days. The cube doesw not appear in the Analysis
Manager and I can't find any errors.

There was a cube generated initially but it failed to complete an

update so I tried to create a new one and now can't generate one at all.

Any suggestions?