Problem during building OLAP cube

J

Jakub Dudek

Hello,
Our OLAP cube was running well from several months.
Suddenly it stopped.
There are following entries found in Event Viewer:

1. Error
There was a fatal error during transaction commit in the database Project.
Server will be restarted to preserve the data consistency.

2. Error
Component: MSP Resource Availablity Refresh and OLAP Cube Creation Component
(ProjOLAP)
File: PROJOLAPProcess
Line: 14
Description: <Description><![CDATA[Unexpected error in FireOffBuildProcess.
Error: 'Network error [Internal error] '' '. Error code
= -2147221387]]></Description>

3. Error
Component: PCSViews
File: ViewsDrop.cls
Line: -1
Error Number: 0x80004005
Description: <Description><![CDATA[Failed to generate OLAP Cube for the
following Request :
<BuildCubeRequest><CubeUpdate><CubeStart>20031028</CubeStart><CubeFinish>20180227</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=offsrv4805</DSOConnection><Server>offsrv4805</Server><CubeDB>Project</CubeDB><CubeDesc></CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>F723E105-1B42-4914-A61E-EB45E5644D6D</CubeGUID></CubeUpdate></BuildCubeRequest>]]></Description>

4. Error
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>2003-10-28T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2018-02-27T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20031028</CubeStart><CubeFinish>20180227</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=offsrv4805</DSOConnection><Server>offsrv4805</Server><CubeDB>Project</CubeDB><CubeDesc></CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>F723E105-1B42-4914-A61E-EB45E5644D6D</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>)]]></Description>

5. Error
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>2003-10-28T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2018-02-27T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20031028</CubeStart><CubeFinish>20180227</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=offsrv4805</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=offsrv4805</DSOConnection><Server>offsrv4805</Server><CubeDB>Project</CubeDB><CubeDesc></CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>F723E105-1B42-4914-A61E-EB45E5644D6D</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>ProjectServer</OrgGuid>
<BasePath>ProjectServer</BasePath>
<TimeStamp>2005-07-06T13:13:59</TimeStamp>
</ViewsDropData>]]></Description>

6. Warning
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>2003-10-28T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2018-02-27T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20031028</CubeStart><CubeFinish>20180227</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=offsrv4805</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=offsrv4805</DSOConnection><Server>offsrv4805</Server><CubeDB>Project</CubeDB><CubeDesc></CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>F723E105-1B42-4914-A61E-EB45E5644D6D</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>ProjectServer</OrgGuid>
<BasePath>ProjectServer</BasePath>
<TimeStamp>2005-07-06T13:13:59</TimeStamp>
</ViewsDropData>]]></Description>

7. Warning
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>2003-10-28T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2018-02-27T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20031028</CubeStart><CubeFinish>20180227</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=offsrv4805</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=offsrv4805</DSOConnection><Server>offsrv4805</Server><CubeDB>Project</CubeDB><CubeDesc></CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>F723E105-1B42-4914-A61E-EB45E5644D6D</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>ProjectServer</OrgGuid>
<BasePath>ProjectServer</BasePath>
<TimeStamp>2005-07-06T13:13:59</TimeStamp>
</ViewsDropData>]]></Description>

8. Information
The Analysis server started successfully

Probably the first is problem. Does anyone know why it happens now all the
time?
Or where to look now?
Thanks.

Jakub
 
G

Guest

Check permissions on the ViewDrop folder. Use the Project Server Health
Monitor (download from MS website) to montior this. Actually sounds like #7
is the source of problems.

John Willard
VA Dept of Transportation


Hello,
Our OLAP cube was running well from several months.
Suddenly it stopped.
There are following entries found in Event Viewer:

1. Error
There was a fatal error during transaction commit in the database Project.
Server will be restarted to preserve the data consistency.

2. Error
Component: MSP Resource Availablity Refresh and OLAP Cube Creation
Component (ProjOLAP)
File: PROJOLAPProcess
Line: 14
Description: <Description><![CDATA[Unexpected error in
FireOffBuildProcess. Error: 'Network error [Internal error] '' '. Error
code = -2147221387]]></Description>

3. Error
Component: PCSViews
File: ViewsDrop.cls
Line: -1
Error Number: 0x80004005
Description: <Description><![CDATA[Failed to generate OLAP Cube for the
following Request :
<BuildCubeRequest><CubeUpdate><CubeStart>20031028</CubeStart><CubeFinish>20180227</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=offsrv4805</DSOConnection><Server>offsrv4805</Server><CubeDB>Project</CubeDB><CubeDesc></CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>F723E105-1B42-4914-A61E-EB45E5644D6D</CubeGUID></CubeUpdate></BuildCubeRequest>]]></Description>

4. Error
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>2003-10-28T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2018-02-27T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20031028</CubeStart><CubeFinish>20180227</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=offsrv4805</DSOConnection><Server>offsrv4805</Server><CubeDB>Project</CubeDB><CubeDesc></CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>F723E105-1B42-4914-A61E-EB45E5644D6D</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>)]]></Description>

5. Error
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>2003-10-28T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2018-02-27T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20031028</CubeStart><CubeFinish>20180227</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=offsrv4805</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=offsrv4805</DSOConnection><Server>offsrv4805</Server><CubeDB>Project</CubeDB><CubeDesc></CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>F723E105-1B42-4914-A61E-EB45E5644D6D</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>ProjectServer</OrgGuid>
<BasePath>ProjectServer</BasePath>
<TimeStamp>2005-07-06T13:13:59</TimeStamp>
</ViewsDropData>]]></Description>

6. Warning
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>2003-10-28T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2018-02-27T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20031028</CubeStart><CubeFinish>20180227</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=offsrv4805</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=offsrv4805</DSOConnection><Server>offsrv4805</Server><CubeDB>Project</CubeDB><CubeDesc></CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>F723E105-1B42-4914-A61E-EB45E5644D6D</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>ProjectServer</OrgGuid>
<BasePath>ProjectServer</BasePath>
<TimeStamp>2005-07-06T13:13:59</TimeStamp>
</ViewsDropData>]]></Description>

7. Warning
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>2003-10-28T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2018-02-27T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20031028</CubeStart><CubeFinish>20180227</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=offsrv4805</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=offsrv4805</DSOConnection><Server>offsrv4805</Server><CubeDB>Project</CubeDB><CubeDesc></CubeDesc><BasePath>ProjectServer</BasePath><CubeGUID>F723E105-1B42-4914-A61E-EB45E5644D6D</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>ProjectServer</OrgGuid>
<BasePath>ProjectServer</BasePath>
<TimeStamp>2005-07-06T13:13:59</TimeStamp>
</ViewsDropData>]]></Description>

8. Information
The Analysis server started successfully

Probably the first is problem. Does anyone know why it happens now all the
time?
Or where to look now?
Thanks.

Jakub
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
OLAP CUBE ERROR in Project Server 2003 environment..Need help!!!!! 1
Having trouble building OLAP cube 2
Cube failed - (-2147221492) Unable to save object. 1
OLAP Cube creation errors 4
Cube building doesn't update PS database? HELP! 2
OLAP Cube Creation Error 3

Top