data from one project does not get into the OLAP cube

[Cinfindave]

I have an issue with the data from our largest project not getting into our
OLAP cube runs. Everything seems to go correctly in project when I save,
theXML is put into the ViewDrop folder but drops out very quickly. The
application log gets the following errors around the same time the XML drops
out:

Component: PjQuery
File: C:\Office\dev\project\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 308
Error Number: 0x80040e31
Description: <Description><![CDATA[Assert Detected for Virtual Root
'projectserver'. The error code was also included.]]></Description>
___________________________________

Component: Microsoft OLE DB Provider for SQL Server
Description: <Description><![CDATA[Timeout expired]]></Description>
------------------------------------------------------------------------------------------------
Component: PjViewMgr
File: C:\Office\dev\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1123
Description: <Description><![CDATA[Failed to release PC db
connection]]></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[Level 1 - Operational -
2006.Published]
]></EntProjectName><EntProjectID>508</EntProjectID></ProjectData><OrgGuid>projectserver</OrgGuid><ProjectID>2311</ProjectID><BasePath>projectserver</BasePath><TimeStamp>2006-09-21T07:41:11</TimeStamp></ViewsDropData>
]]></Description>


These are all related to this one publish. I have also tried to publish this
project using the view populator but it still does not work. I have read
something about this being a sql timeout error, is that correct?? Also
noticed it does not update the "last published date" in the project center,
and I do not get any spooler errors on this.

Thanks

 

[Gary L. Chefetz [MVP]]

Dave:

Part of the problem you're experiencing may be related to the use of dashes
in your project name. Sometimes these cause fatal problems like you're
having. We certainly need to eliminate that as a possibility by renaming the
project using the renaming tool that you can download from Microsoft, or by
simply saving it as an mpp file and then deleting it from the server and
importing the file back in under a corrected name.

If the problem persists, we should look at other possibilities such as known
bugs and data corruption. It's very important to include a description of
your setup and a rundown of the service packs you've installed on SQL and
Project Server when posting problems like this otherwise we can't explore
known issue possibilities.

I have an issue with the data from our largest project not getting into
our
OLAP cube runs. Everything seems to go correctly in project when I save,
theXML is put into the ViewDrop folder but drops out very quickly. The
application log gets the following errors around the same time the XML
drops
out:

Component: PjQuery
File: C:\Office\dev\project\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 308
Error Number: 0x80040e31
Description: <Description><![CDATA[Assert Detected for Virtual Root
'projectserver'. The error code was also included.]]></Description>
___________________________________

Component: Microsoft OLE DB Provider for SQL Server
Description: <Description><![CDATA[Timeout expired]]></Description>
------------------------------------------------------------------------------------------------
Component: PjViewMgr
File:
C:\Office\dev\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1123
Description: <Description><![CDATA[Failed to release PC db
connection]]></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[Level 1 -
Operational -
2006.Published]
]></EntProjectName><EntProjectID>508</EntProjectID></ProjectData><OrgGuid>projectserver</OrgGuid><ProjectID>2311</ProjectID><BasePath>projectserver</BasePath><TimeStamp>2006-09-21T07:41:11</TimeStamp></ViewsDropData>
]]></Description>


These are all related to this one publish. I have also tried to publish
this
project using the view populator but it still does not work. I have read
something about this being a sql timeout error, is that correct?? Also
noticed it does not update the "last published date" in the project
center,
and I do not get any spooler errors on this.

Thanks