Error when processing cube in Analysis Manager

B

BTOjohn

Dear All,

I have been receiving errors of the 0x80004005 type, which seemed to reduce
in frequency when we reset the DNS settings. The errors would typically be a
series of five error messages, and then two warnings in the event viewer. The
iisues that we saw seemed to mean that when PMs changed something in a
project and published, this info would go to the resources' tasksheets, and
be seen in the PWA, but somehow didn't actually turn up in the project itself.

Yesterday, one of the PMs changed the baselline manually! and then
republished, causing one of these 0x80004005 errors. I cannot identify
why...for a time I thought it might be an enterprise resource pool issue, but
I cannot find anything wrong. Last night the cube then failed to build. I
deleted the cube and then rebuilt one successfully with the same parameters.
I then "processed" the cube in Analysis manager, and received a number of
errors ("A member with key '2247' was found in the fact table but was not
found in the set of leaf members of dimension 'Tasks'. time etc." ) under the
title "Partition 'MSP_ASSN_FACT' Execute : SELECT
"MSP_CUBE_PROJECTS"."PROJ_NAME", "MSP_CUBE_PROJ_VERSIONS"."PROJ_VERSION",
"MSP_CUBE_PROJECTS"."PROJ_NAME", "MSP_CUBE_RESOURCES"."RESOURCENAME",
"MSP_CUBE_RESOURCES"."RES_IS_ACTIVE",...etc."

Whether its related or not, shortly afterwards I also received a load of
messages in the event viewer as follows:

"Failed auto update retrieval of third-party root list sequence number from:
<http://www.download.windowsupdate.com/msdownload/update/v3/static/trustedr/en/authrootseq.txt> with error: The server name or address could not be resolved


For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp."

Alas there is no further information when I follow the link.

Does any of this make sense to someone out there, please...

Cheers,

John
 
G

Gary L. Chefetz [MVP]

John:

Please post the error messages rather than vaguely describing them. This
would help us help you.
 
B

BTOjohn

Gary,

Thanks for taking an interest, the standard set of error messages and
warnings in the event viewer are as follows:

1.
File: C:\Office\dev\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 1691
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
___________________________________

Description: <Description><![CDATA[Cannot open project '<PC11DSN>\MLF01
Nigeria.Published']]></Description>


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


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


4.
Component: PjViewMgr
File: C:\Office\dev\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1083
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>


5.
Component: PjViewMgr
File: C:\Office\dev\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1164
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>


6.
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[MLF01
Nigeria.Published]
]></EntProjectName><EntProjectID>87</EntProjectID></ProjectData><OrgGuid>projectserver</OrgGuid><ProjectID>172</ProjectID><BasePath>projectserver</BasePath><TimeStamp>2005-10-03T14:06:57</TimeStamp></ViewsDropData>
]]></Description>

And as I mentioned I did in fact get a further error message shortly
afterwards as follows:

"Failed auto update retrieval of third-party root list sequence number from:
<http://www.download.windowsupdate.com/msdownload/update/v3/static/trustedr/en/authrootseq.txt>
with error: The server name or address could not be resolved

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp."

Looking forward to hearing what you make of it. If it would helpful to also
have the messages for when the cube failed to build, then just let me know,
but there's quite a few here already, and I don't want to overdo it!

Cheers very much,

John
 
G

Gary L. Chefetz [MVP]

John:

If you've checked the Knowledge Base for the short list of common causes for
the 0X80004005 error, such as permissions on the View Drop folder, then
there may be something amiss with the MLF01Nigeria plan. I don't see a
cube-specific error here as the timestamp in one error is showing afternoon.
If the Nigeria file is corrupt it could explain the errors you present and
possibly explain the cube failure. Try removing the plan from Project Server
by saving it as an mpp file, then importing it back to the server and use
the trick explained at the link below to force a binary rebuild.

http://www.projectserverexperts.com/Shared Documents/BinaryRebuild.htm




Gary,

Thanks for taking an interest, the standard set of error messages and
warnings in the event viewer are as follows:

1.
File: C:\Office\dev\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 1691
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>
___________________________________

Description: <Description><![CDATA[Cannot open project '<PC11DSN>\MLF01
Nigeria.Published']]></Description>


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


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


4.
Component: PjViewMgr
File:
C:\Office\dev\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1083
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>


5.
Component: PjViewMgr
File:
C:\Office\dev\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1164
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>


6.
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[MLF01
Nigeria.Published]
]></EntProjectName><EntProjectID>87</EntProjectID></ProjectData><OrgGuid>projectserver</OrgGuid><ProjectID>172</ProjectID><BasePath>projectserver</BasePath><TimeStamp>2005-10-03T14:06:57</TimeStamp></ViewsDropData>
]]></Description>

And as I mentioned I did in fact get a further error message shortly
afterwards as follows:

"Failed auto update retrieval of third-party root list sequence number
from:
<http://www.download.windowsupdate.com/msdownload/update/v3/static/trustedr/en/authrootseq.txt>
with error: The server name or address could not be resolved

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp."

Looking forward to hearing what you make of it. If it would helpful to
also
have the messages for when the cube failed to build, then just let me
know,
but there's quite a few here already, and I don't want to overdo it!

Cheers very much,

John

Gary L. Chefetz said:
John:

Please post the error messages rather than vaguely describing them. This
would help us help you.
 
B

BTOjohn

Hi Gary,

Thanks for the advice - I have done as you suggested, and I can only wait
and hope that error messages reduce in number. I've ordered your book on
administering a PMO as it came highly recommended =)

Cheers again,

John

Gary L. Chefetz said:
John:

If you've checked the Knowledge Base for the short list of common causes for
the 0X80004005 error, such as permissions on the View Drop folder, then
there may be something amiss with the MLF01Nigeria plan. I don't see a
cube-specific error here as the timestamp in one error is showing afternoon.
If the Nigeria file is corrupt it could explain the errors you present and
possibly explain the cube failure. Try removing the plan from Project Server
by saving it as an mpp file, then importing it back to the server and use
the trick explained at the link below to force a binary rebuild.

http://www.projectserverexperts.com/Shared Documents/BinaryRebuild.htm




Gary,

Thanks for taking an interest, the standard set of error messages and
warnings in the event viewer are as follows:

1.
File: C:\Office\dev\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 1691
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>
___________________________________

Description: <Description><![CDATA[Cannot open project '<PC11DSN>\MLF01
Nigeria.Published']]></Description>


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


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


4.
Component: PjViewMgr
File:
C:\Office\dev\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1083
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>


5.
Component: PjViewMgr
File:
C:\Office\dev\project\WebClient\source\server\pjviewmgr\ViewCreator.cpp
Line: 1164
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was
also
included.]]></Description>


6.
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[MLF01
Nigeria.Published]
]></EntProjectName><EntProjectID>87</EntProjectID></ProjectData><OrgGuid>projectserver</OrgGuid><ProjectID>172</ProjectID><BasePath>projectserver</BasePath><TimeStamp>2005-10-03T14:06:57</TimeStamp></ViewsDropData>
]]></Description>

And as I mentioned I did in fact get a further error message shortly
afterwards as follows:

"Failed auto update retrieval of third-party root list sequence number
from:
<http://www.download.windowsupdate.com/msdownload/update/v3/static/trustedr/en/authrootseq.txt>
with error: The server name or address could not be resolved

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp."

Looking forward to hearing what you make of it. If it would helpful to
also
have the messages for when the cube failed to build, then just let me
know,
but there's quite a few here already, and I don't want to overdo it!

Cheers very much,

John

Gary L. Chefetz said:
John:

Please post the error messages rather than vaguely describing them. This
would help us help you.




Dear All,

I have been receiving errors of the 0x80004005 type, which seemed to
reduce
in frequency when we reset the DNS settings. The errors would typically
be
a
series of five error messages, and then two warnings in the event
viewer.
The
iisues that we saw seemed to mean that when PMs changed something in a
project and published, this info would go to the resources' tasksheets,
and
be seen in the PWA, but somehow didn't actually turn up in the project
itself.

Yesterday, one of the PMs changed the baselline manually! and then
republished, causing one of these 0x80004005 errors. I cannot identify
why...for a time I thought it might be an enterprise resource pool
issue,
but
I cannot find anything wrong. Last night the cube then failed to build.
I
deleted the cube and then rebuilt one successfully with the same
parameters.
I then "processed" the cube in Analysis manager, and received a number
of
errors ("A member with key '2247' was found in the fact table but was
not
found in the set of leaf members of dimension 'Tasks'. time etc." )
under
the
title "Partition 'MSP_ASSN_FACT' Execute : SELECT
"MSP_CUBE_PROJECTS"."PROJ_NAME",
"MSP_CUBE_PROJ_VERSIONS"."PROJ_VERSION",
"MSP_CUBE_PROJECTS"."PROJ_NAME", "MSP_CUBE_RESOURCES"."RESOURCENAME",
"MSP_CUBE_RESOURCES"."RES_IS_ACTIVE",...etc."

Whether its related or not, shortly afterwards I also received a load
of
messages in the event viewer as follows:

"Failed auto update retrieval of third-party root list sequence number
from:
<http://www.download.windowsupdate.com/msdownload/update/v3/static/trustedr/en/authrootseq.txt>
with error: The server name or address could not be resolved


For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp."

Alas there is no further information when I follow the link.

Does any of this make sense to someone out there, please...

Cheers,

John
 

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

Top