Cube building problem!!

N

numen

hi All,

i have some problem with my ProServer 2003
ProServer 2003 Sp2
SQL 2000 SP4
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>




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>



what is going on???
 
N

numen

now i want to accept project plan couples of errors:

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%PROJECTNAME%.Published]
]></EntProjectName><EntProjectID>995</EntProjectID></ProjectData><OrgGuid>projectserver</OrgGuid><ProjectID>905</ProjectID><BasePath>projectserver</BasePath><TimeStamp>2010-04-20T16:36:57</TimeStamp></ViewsDropData>
]]></Description>
 
G

Gerard Wojcik

Numen - Have you tried adjusting the date range? Try reducing the date range
and see what happens. It just might be too much data. The error information
looks like you are building from 1997 - 2022. Try 30 days and build.

Let us know what happens.
 
N

numen

doesn't help this same issue

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 4/22/2010
Time: 10:14:28 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: OFFSRV4805
Description:
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>2010-02-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2010-09-01T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20100315</CubeStart><CubeFinish>20100422</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>8B26FE51-6524-4E35-B4CF-21841DED1B51</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>)]]></Description>


Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 4/22/2010
Time: 10:14:28 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: OFFSRV4805
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>2010-02-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2010-09-01T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20100315</CubeStart><CubeFinish>20100422</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>8B26FE51-6524-4E35-B4CF-21841DED1B51</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2010-04-22T10:14:28</TimeStamp>
</ViewsDropData>]]></Description>
 
G

Gerard Wojcik

Numen - What has changed since the last successful build? Are you able to
publish? The "Views Notification Service" may not be configured correctly.
From the error messages, it looks like the service identity is "NT
AUTHORITY\LOCAL SERVICE". Make sure the "Views Notification Service"
identity has the correct file permissions to the C:\Program Files\Microsoft
Office Project Server 2003\BIN\VIEWDROP\ folder.
I hope that this helps

numen said:
doesn't help this same issue

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 4/22/2010
Time: 10:14:28 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: OFFSRV4805
Description:
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>2010-02-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2010-09-01T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20100315</CubeStart><CubeFinish>20100422</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>8B26FE51-6524-4E35-B4CF-21841DED1B51</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>)]]></Description>


Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 4/22/2010
Time: 10:14:28 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: OFFSRV4805
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>2010-02-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2010-09-01T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20100315</CubeStart><CubeFinish>20100422</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>8B26FE51-6524-4E35-B4CF-21841DED1B51</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2010-04-22T10:14:28</TimeStamp>
</ViewsDropData>]]></Description>
Click to expand...
 
N

numen

yes i'm able to publish but i have one error msg after publishing
i don't know why but my viewdrop folder is always empty??!!.

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 4/23/2010
Time: 8:42:39 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: compname
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[PROJECTNAME.Published]
]></EntProjectName><EntProjectID>485</EntProjectID></ProjectData><OrgGuid>projectserver</OrgGuid><ProjectID>737</ProjectID><BasePath>projectserver</BasePath><TimeStamp>2010-04-23T08:42:39</TimeStamp></ViewsDropData>
]]></Description>






Gerard Wojcik said:
Numen - What has changed since the last successful build? Are you able to
publish? The "Views Notification Service" may not be configured correctly.
From the error messages, it looks like the service identity is "NT
AUTHORITY\LOCAL SERVICE". Make sure the "Views Notification Service"
identity has the correct file permissions to the C:\Program Files\Microsoft
Office Project Server 2003\BIN\VIEWDROP\ folder.
I hope that this helps

numen said:
doesn't help this same issue

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 4/22/2010
Time: 10:14:28 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: OFFSRV4805
Description:
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>2010-02-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2010-09-01T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20100315</CubeStart><CubeFinish>20100422</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>8B26FE51-6524-4E35-B4CF-21841DED1B51</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>)]]></Description>


Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 4/22/2010
Time: 10:14:28 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: OFFSRV4805
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>2010-02-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2010-09-01T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20100315</CubeStart><CubeFinish>20100422</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>8B26FE51-6524-4E35-B4CF-21841DED1B51</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2010-04-22T10:14:28</TimeStamp>
</ViewsDropData>]]></Description>
Click to expand...
Click to expand...
 
G

Gary L. Chefetz

Numen:

What is the name of Project with the ID#485? Does the project name perhaps
contain non alphanumeric characters such as a dash (-) or ampersand (&) or
some other characters like that?

--
Gary L. Chefetz, MVP, MCT, MCTIP
Business: http://www.msprojectexperts.com
FAQs: http://www.projectserverexperts.com
BLOG: http://www.projectserverhelp.com

yes i'm able to publish but i have one error msg after publishing
i don't know why but my viewdrop folder is always empty??!!.

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 4/23/2010
Time: 8:42:39 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: compname
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[PROJECTNAME.Published]
]></EntProjectName><EntProjectID>485</EntProjectID></ProjectData><OrgGuid>projectserver</OrgGuid><ProjectID>737</ProjectID><BasePath>projectserver</BasePath><TimeStamp>2010-04-23T08:42:39</TimeStamp></ViewsDropData>
]]></Description>






Gerard Wojcik said:
Numen - What has changed since the last successful build? Are you able
to
publish? The "Views Notification Service" may not be configured
correctly.
From the error messages, it looks like the service identity is "NT
AUTHORITY\LOCAL SERVICE". Make sure the "Views Notification Service"
identity has the correct file permissions to the C:\Program
Files\Microsoft
Office Project Server 2003\BIN\VIEWDROP\ folder.
I hope that this helps

numen said:
doesn't help this same issue

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 4/22/2010
Time: 10:14:28 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: OFFSRV4805
Description:
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>2010-02-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2010-09-01T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20100315</CubeStart><CubeFinish>20100422</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>8B26FE51-6524-4E35-B4CF-21841DED1B51</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>)]]></Description>


Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 4/22/2010
Time: 10:14:28 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: OFFSRV4805
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>2010-02-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2010-09-01T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20100315</CubeStart><CubeFinish>20100422</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>8B26FE51-6524-4E35-B4CF-21841DED1B51</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2010-04-22T10:14:28</TimeStamp>
</ViewsDropData>]]></Description>
Click to expand...
Click to expand...
Click to expand...
 
N

numen

no - project name is Support 2008

Gary L. Chefetz said:
Numen:

What is the name of Project with the ID#485? Does the project name perhaps
contain non alphanumeric characters such as a dash (-) or ampersand (&) or
some other characters like that?

--
Gary L. Chefetz, MVP, MCT, MCTIP
Business: http://www.msprojectexperts.com
FAQs: http://www.projectserverexperts.com
BLOG: http://www.projectserverhelp.com

yes i'm able to publish but i have one error msg after publishing
i don't know why but my viewdrop folder is always empty??!!.

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 4/23/2010
Time: 8:42:39 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: compname
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[PROJECTNAME.Published]
]></EntProjectName><EntProjectID>485</EntProjectID></ProjectData><OrgGuid>projectserver</OrgGuid><ProjectID>737</ProjectID><BasePath>projectserver</BasePath><TimeStamp>2010-04-23T08:42:39</TimeStamp></ViewsDropData>
]]></Description>






Gerard Wojcik said:
Numen - What has changed since the last successful build? Are you able
to
publish? The "Views Notification Service" may not be configured
correctly.
From the error messages, it looks like the service identity is "NT
AUTHORITY\LOCAL SERVICE". Make sure the "Views Notification Service"
identity has the correct file permissions to the C:\Program
Files\Microsoft
Office Project Server 2003\BIN\VIEWDROP\ folder.
I hope that this helps

:

doesn't help this same issue

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 4/22/2010
Time: 10:14:28 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: OFFSRV4805
Description:
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>2010-02-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2010-09-01T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20100315</CubeStart><CubeFinish>20100422</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>8B26FE51-6524-4E35-B4CF-21841DED1B51</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>)]]></Description>


Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 4/22/2010
Time: 10:14:28 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: OFFSRV4805
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>2010-02-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2010-09-01T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20100315</CubeStart><CubeFinish>20100422</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>8B26FE51-6524-4E35-B4CF-21841DED1B51</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2010-04-22T10:14:28</TimeStamp>
</ViewsDropData>]]></Description>
Click to expand...
Click to expand...
Click to expand...
 
N

numen

Gary - any others suggestion ???




Gary L. Chefetz said:
Numen:

What is the name of Project with the ID#485? Does the project name perhaps
contain non alphanumeric characters such as a dash (-) or ampersand (&) or
some other characters like that?

--
Gary L. Chefetz, MVP, MCT, MCTIP
Business: http://www.msprojectexperts.com
FAQs: http://www.projectserverexperts.com
BLOG: http://www.projectserverhelp.com

yes i'm able to publish but i have one error msg after publishing
i don't know why but my viewdrop folder is always empty??!!.

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 4/23/2010
Time: 8:42:39 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: compname
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[PROJECTNAME.Published]
]></EntProjectName><EntProjectID>485</EntProjectID></ProjectData><OrgGuid>projectserver</OrgGuid><ProjectID>737</ProjectID><BasePath>projectserver</BasePath><TimeStamp>2010-04-23T08:42:39</TimeStamp></ViewsDropData>
]]></Description>






Gerard Wojcik said:
Numen - What has changed since the last successful build? Are you able
to
publish? The "Views Notification Service" may not be configured
correctly.
From the error messages, it looks like the service identity is "NT
AUTHORITY\LOCAL SERVICE". Make sure the "Views Notification Service"
identity has the correct file permissions to the C:\Program
Files\Microsoft
Office Project Server 2003\BIN\VIEWDROP\ folder.
I hope that this helps

:

doesn't help this same issue

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 4/22/2010
Time: 10:14:28 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: OFFSRV4805
Description:
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>2010-02-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2010-09-01T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20100315</CubeStart><CubeFinish>20100422</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>8B26FE51-6524-4E35-B4CF-21841DED1B51</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>)]]></Description>


Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 4/22/2010
Time: 10:14:28 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: OFFSRV4805
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>2010-02-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2010-09-01T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20100315</CubeStart><CubeFinish>20100422</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>8B26FE51-6524-4E35-B4CF-21841DED1B51</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2010-04-22T10:14:28</TimeStamp>
</ViewsDropData>]]></Description>
Click to expand...
Click to expand...
Click to expand...
 
G

Gary L. Chefetz

Sometimes those errors indicated bad data. There's no real good way to tell
without a deep dive into SQL Profiler. Sometimes it's caused by bad
character data like special characters, sometimes with binary record
corruption. You can try this therapy as well:

http://www.projectserverexperts.com/ProjectServerFAQKnowledgeBase/BinaryRebuild.aspx

--
Gary L. Chefetz, MVP, MCT, MCTIP
Business: http://www.msprojectexperts.com
FAQs: http://www.projectserverexperts.com
BLOG: http://www.projectserverhelp.com

Gary - any others suggestion ???




Gary L. Chefetz said:
Numen:

What is the name of Project with the ID#485? Does the project name
perhaps
contain non alphanumeric characters such as a dash (-) or ampersand (&)
or
some other characters like that?

--
Gary L. Chefetz, MVP, MCT, MCTIP
Business: http://www.msprojectexperts.com
FAQs: http://www.projectserverexperts.com
BLOG: http://www.projectserverhelp.com

yes i'm able to publish but i have one error msg after publishing
i don't know why but my viewdrop folder is always empty??!!.

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 4/23/2010
Time: 8:42:39 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: compname
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[PROJECTNAME.Published]
]></EntProjectName><EntProjectID>485</EntProjectID></ProjectData><OrgGuid>projectserver</OrgGuid><ProjectID>737</ProjectID><BasePath>projectserver</BasePath><TimeStamp>2010-04-23T08:42:39</TimeStamp></ViewsDropData>
]]></Description>






:

Numen - What has changed since the last successful build? Are you
able
to
publish? The "Views Notification Service" may not be configured
correctly.
From the error messages, it looks like the service identity is "NT
AUTHORITY\LOCAL SERVICE". Make sure the "Views Notification Service"
identity has the correct file permissions to the C:\Program
Files\Microsoft
Office Project Server 2003\BIN\VIEWDROP\ folder.
I hope that this helps

:

doesn't help this same issue

Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 4/22/2010
Time: 10:14:28 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: OFFSRV4805
Description:
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>2010-02-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2010-09-01T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20100315</CubeStart><CubeFinish>20100422</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>8B26FE51-6524-4E35-B4CF-21841DED1B51</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>)]]></Description>


Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 4/22/2010
Time: 10:14:28 AM
User: NT AUTHORITY\LOCAL SERVICE
Computer: OFFSRV4805
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>2010-02-01T00:00:00</EntResourceStartDate>
<EntResourceFinishDate>2010-09-01T00:00:00</EntResourceFinishDate>
<BuildCubeRequest><CubeUpdate><CubeStart>20100315</CubeStart><CubeFinish>20100422</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>8B26FE51-6524-4E35-B4CF-21841DED1B51</CubeGUID></CubeUpdate></BuildCubeRequest>
</ProjectData>
<OrgGuid>projectserver</OrgGuid>
<BasePath>projectserver</BasePath>
<TimeStamp>2010-04-22T10:14:28</TimeStamp>
</ViewsDropData>]]></Description>
Click to expand...
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 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
Cube building doesn't update PS database? HELP! 2
OLAP Cube creation errors 4
OLAP Cube Creation Error 3
The cube scheduled to be built on xxx at xxx failed. (-2147221411) 0

Top