D
Doug Schurman
We are planning to upgrade to 2007 in a few month but I need to limp along a
while longer in 2003. The cube has been working for over a year without a
problem. Recently it won't refrsh. The following error was coming up on the
cube refresh screen:
Component: MSP Resource Availablity Refresh and OLAP Cube Creation Component
(ProjOLAP)
File: PROJOLAPProcess
Line: 2001
Description: <Description><![CDATA[Error #: 5 Desc.
:System.Net.WebException: The request failed with HTTP status 401:
Unauthorized.
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at
MSPOLAPBREAKOUT.CubeExtensionsWeb.CubeExtenstions.BuildFullExtension(String
encryptedOleDbConnectionString)
at MSPOLAPBREAKOUT.UserOptionalCode.UserStagingTablesUpdate(Connection
o_dbConnection, Int64 l_DBType, Int64& l_errnum, String&
s_errdesc)]]></Description>
I asked if anything had changed. Our Sys admin had done some windows updates
on the server for security patches and .Net framework. I asked that those be
rolled back and now we have the following error in the application event logs:
Component: MSP Resource Availablity Refresh and OLAP Cube Creation Component
(ProjOLAP)
File: PROJOLAPProcess
Line: 3033
Description: <Description><![CDATA[Error #: -2147221425 Desc. :The source
for a level or member property in the virtual dimension was not found. This
level or member property has a MemberKeyColumn and/or MemberNameColumn that
is different from any level or member property in the source dimension, or
the SourceColumn of one of its member properties, which is not part of the
source dimension, or the levels in the source dimension are in a different
order. The levels in the source dimension and the virtual dimension must
appear in the same order.]]></Description>
Any ideas here on what we need to do to get the cube refreshing again?
Thanks
while longer in 2003. The cube has been working for over a year without a
problem. Recently it won't refrsh. The following error was coming up on the
cube refresh screen:
Component: MSP Resource Availablity Refresh and OLAP Cube Creation Component
(ProjOLAP)
File: PROJOLAPProcess
Line: 2001
Description: <Description><![CDATA[Error #: 5 Desc.
:System.Net.WebException: The request failed with HTTP status 401:
Unauthorized.
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at
MSPOLAPBREAKOUT.CubeExtensionsWeb.CubeExtenstions.BuildFullExtension(String
encryptedOleDbConnectionString)
at MSPOLAPBREAKOUT.UserOptionalCode.UserStagingTablesUpdate(Connection
o_dbConnection, Int64 l_DBType, Int64& l_errnum, String&
s_errdesc)]]></Description>
I asked if anything had changed. Our Sys admin had done some windows updates
on the server for security patches and .Net framework. I asked that those be
rolled back and now we have the following error in the application event logs:
Component: MSP Resource Availablity Refresh and OLAP Cube Creation Component
(ProjOLAP)
File: PROJOLAPProcess
Line: 3033
Description: <Description><![CDATA[Error #: -2147221425 Desc. :The source
for a level or member property in the virtual dimension was not found. This
level or member property has a MemberKeyColumn and/or MemberNameColumn that
is different from any level or member property in the source dimension, or
the SourceColumn of one of its member properties, which is not part of the
source dimension, or the levels in the source dimension are in a different
order. The levels in the source dimension and the virtual dimension must
appear in the same order.]]></Description>
Any ideas here on what we need to do to get the cube refreshing again?
Thanks