PROJOLAPProcess

[Gegga]

Hi,
We experience problems when the OLAP cube is beeing build. See the error log
below.

Anyone have a suggestion for where to start tracing for the ASSN_UID that
probably causes this error?
--
Gegga

Component: MSP Resource Availablity Refresh and OLAP Cube Creation Component
(ProjOLAP)
File: PROJOLAPProcess
Line: 1083
Description: <Description><![CDATA[Error #: -2147217900 Desc. :Invalid
column name 'ASSN_UID'.]]></Description>


Component: MSP Resource Availablity Refresh and OLAP Cube Creation Component
(ProjOLAP)
File: PROJOLAPProcess
Line: -2147217900
Description: <Description><![CDATA[Error populating the staging tables.
Error: 'Invalid column name 'ASSN_UID'.']]></Description>

 

[David Gage \(Project MVP\)]

Try restarting the Project Server Views Processing service on the Project
Server machine.

Also check that the ViewDrop folder on the Project Server machine has the
appropriate permission. Try Everyone with Full Control just to test. If
that works then you may be able to remove Everyone group and add the IUSR_
account associated with IIS as Project Server uses ISAPI to copy files to
the ViewDrop folder.

 

[Gegga]

I found the solution. We installed a 3rd party software to get tasks in the
portfolio analyser. After unistalling this software I managed to build the
cube.
--
Gegga


David Gage (Project MVP) skrev:

Try restarting the Project Server Views Processing service on the Project
Server machine.

Also check that the ViewDrop folder on the Project Server machine has the
appropriate permission. Try Everyone with Full Control just to test. If
that works then you may be able to remove Everyone group and add the IUSR_
account associated with IIS as Project Server uses ISAPI to copy files to
the ViewDrop folder.

--
David Gage
Microsoft Project MVP

Hi,
We experience problems when the OLAP cube is beeing build. See the error
log
below.

Anyone have a suggestion for where to start tracing for the ASSN_UID that
probably causes this error?
--
Gegga

Component: MSP Resource Availablity Refresh and OLAP Cube Creation
Component
(ProjOLAP)
File: PROJOLAPProcess
Line: 1083
Description: <Description><![CDATA[Error #: -2147217900 Desc. :Invalid
column name 'ASSN_UID'.]]></Description>


Component: MSP Resource Availablity Refresh and OLAP Cube Creation
Component
(ProjOLAP)
File: PROJOLAPProcess
Line: -2147217900
Description: <Description><![CDATA[Error populating the staging tables.
Error: 'Invalid column name 'ASSN_UID'.']]></Description>