Cube building doesn't update PS database? HELP!

N

numen

hi All,

i have some problem with my ProServer 2003
when i want to build cube manualy the proces start and i get two errors and
two warnings in event viewer (when i start processing from analysis menager i
don't have any errors but after build i don't see NEWest result in portfolio
analyzer):


1.
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>1997-02-21T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2022-01-14T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>19970221</CubeStart><CubeFinish>20220114</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=10.48.0.11</DSOConnection><Server>offsrv4805</Server><CubeDB>Project</CubeDB><CubeDesc></CubeDesc><BasePath>projectserver</BasePath><CubeGUID>17F9D030-3B5F-4A7C-A746-6728279DADF6</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>)]]></Description>


2.
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>1997-02-21T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2022-01-14T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>19970221</CubeStart><CubeFinish>20220114</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=10.48.0.11</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=10.48.0.11</DSOConnection><Server>offsrv4805</Server><CubeDB>Project</CubeDB><CubeDesc></CubeDesc><BasePath>projectserver</BasePath><CubeGUID>17F9D030-3B5F-4A7C-A746-6728279DADF6</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2010-04-20T14:30:12</TimeStamp>
</ViewsDropData>]]></Description>




3 (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>1997-02-21T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2022-01-14T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>19970221</CubeStart><CubeFinish>20220114</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=10.48.0.11</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=10.48.0.11</DSOConnection><Server>offsrv4805</Server><CubeDB>Project</CubeDB><CubeDesc></CubeDesc><BasePath>projectserver</BasePath><CubeGUID>17F9D030-3B5F-4A7C-A746-6728279DADF6</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2010-04-20T14:30:12</TimeStamp>
</ViewsDropData>]]></Description>




4.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>1997-02-21T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2022-01-14T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>19970221</CubeStart><CubeFinish>20220114</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=10.48.0.11</Connection><DBType>0</DBType><DSOConnection>Provider=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=10.48.0.11</DSOConnection><Server>offsrv4805</Server><CubeDB>Project</CubeDB><CubeDesc></CubeDesc><BasePath>projectserver</BasePath><CubeGUID>17F9D030-3B5F-4A7C-A746-6728279DADF6</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2010-04-20T14:30:12</TimeStamp>
</ViewsDropData>]]></Description>


what is going on???
 
A

Andrew Lavinsky

You'd be better off posting to the Project Server newsgroup. This is for
the desktop product.

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm
hi All,

i have some problem with my ProServer 2003 when i want to build cube
manualy the proces start and i get two errors and two warnings in
event viewer (when i start processing from analysis menager i don't
have any errors but after build i don't see NEWest result in portfolio
analyzer):

1.
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>1997-02-21T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2022-01-14T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>19970221</CubeStart><CubeFin
ish>20220114</CubeFinish><DBType>0</DBType><DSOConnection>Provider=SQL
OLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=10.48.0.11</DSOConnection><Server>offsrv4805</Server><CubeDB>Pr
oject</CubeDB><CubeDesc></CubeDesc><BasePath>projectserver</BasePath><
CubeGUID>17F9D030-3B5F-4A7C-A746-6728279DADF6</CubeGUID></CubeUpdate><
/BuildCubeRequest>

</ProjectData>)]]></Description>

2.
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>1997-02-21T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2022-01-14T00:00:00</EntResourceFinishDate>

<BuildCubeRequest><CubeUpdate><CubeStart>19970221</CubeStart><CubeFini
sh>20220114</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=10.48.0.11</Connection><DBType>0</DBType><DSOConnection>Provide
r=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=10.48.0.11</DSOConnection><Server>offsrv4805</Server><CubeDB>Pr
oject</CubeDB><CubeDesc></CubeDesc><BasePath>projectserver</BasePath><
CubeGUID>17F9D030-3B5F-4A7C-A746-6728279DADF6</CubeGUID></CubeUpdate><
/BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2010-04-20T14:30:12</TimeStamp>
</ViewsDropData>]]></Description>
3 (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>1997-02-21T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2022-01-14T00:00:00</EntResourceFinishDate>

<BuildCubeRequest><CubeUpdate><CubeStart>19970221</CubeStart><CubeFini
sh>20220114</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=10.48.0.11</Connection><DBType>0</DBType><DSOConnection>Provide
r=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=10.48.0.11</DSOConnection><Server>offsrv4805</Server><CubeDB>Pr
oject</CubeDB><CubeDesc></CubeDesc><BasePath>projectserver</BasePath><
CubeGUID>17F9D030-3B5F-4A7C-A746-6728279DADF6</CubeGUID></CubeUpdate><
/BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2010-04-20T14:30:12</TimeStamp>
</ViewsDropData>]]></Description>
4.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>1997-02-21T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2022-01-14T00:00:00</EntResourceFinishDate>

<BuildCubeRequest><CubeUpdate><CubeStart>19970221</CubeStart><CubeFini
sh>20220114</CubeFinish><Connection>Provider=SQLOLEDB;
Initial Catalog=ProjectServer;Data
Source=10.48.0.11</Connection><DBType>0</DBType><DSOConnection>Provide
r=SQLOLEDB.1;Persist
Security Info=False;Initial Catalog=ProjectServer;Data
Source=10.48.0.11</DSOConnection><Server>offsrv4805</Server><CubeDB>Pr
oject</CubeDB><CubeDesc></CubeDesc><BasePath>projectserver</BasePath><
CubeGUID>17F9D030-3B5F-4A7C-A746-6728279DADF6</CubeGUID></CubeUpdate><
/BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2010-04-20T14:30:12</TimeStamp>
</ViewsDropData>]]></Description>
what is going on???
Click to expand...
 
N

numen

when i publish some project plan i have empty VIEWDROP folder + one 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[Support DCK
2008.Published]
]></EntProjectName><EntProjectID>485</EntProjectID></ProjectData><OrgGuid>projectserver</OrgGuid><ProjectID>737</ProjectID><BasePath>projectserver</BasePath><TimeStamp>2010-04-20T15:34:39</TimeStamp></ViewsDropData>
]]></Description>
 

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
OLAP Cube Creation Error 3
The cube scheduled to be built on xxx at xxx failed. (-2147221411) 0

Top