Re: Error Processing Cube or Dimension in Analysis Manager

#1

Completely uninstalled sql and analysis server.
Reinstalled them both up to sp3. Rebuilt the cube. Same
Error. It looks like some kind of security issue...

Robin

Quote:

-----Original Message-----
Try SQL Server & AS SP3

Check this
http://support.microsoft.com/default.aspx?scid=kb;en-
us;317059

--

Jose Mariano Alvarez
Comunidad de base de datos
Grupo de Usuarios Microsoft
www.mug.org.ar

"Robin Zwirtz" <robinz (AT) edge-usa (DOT) com> wrote in message
news:0d4001c35cfd$24889d00$a501280a (AT) phx (DOT) gbl...
I have an instance of SQL Server running sp3 and am
getting the following error when I try to Process:
"Analysis Server Error: COM(OLE) error [Initialization
error]'The specified module could not be found.'

I have tried reinstalling MDAC(2.6sp2) and uninstalling
and reinstalling Analysis Services and SQL Server with
no
luck. We where having problems with an application
that
used SQL as well, but fixed that by going back to MDAC
2.6sp2 from 2.7sp1.

Any ideas would be appreciated.

Robin

.

#2

Hi Robin,

I think this issue is quite complex. If it is urgent, I would suggest that
you open an incident with Microsoft Product Support Services via
http://support.microsoft.com/default...EN-US;CNTACTMS, so that
we can have dedicated engineer to assist you.

I would collect the following information.
1. What is the operating system?
2. If you create a new OLAP cube in a new OLAP database and process it,
will the error occur?
3. Could you try installing latest MDAC component?
http://www.microsoft.com/downloads/d...rosoft.com/dow
nloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&DisplayLan
g=en
4. You may use Filemon or Regmon from sysinternals to monitor which module
is missing.

Bill Cheng
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
--------------------

Quote:

Content-Class: urn:content-classes:message
From: "Robin Zwirtz" <robinz (AT) edge-usa (DOT) com
Sender: "Robin Zwirtz" <robinz (AT) edge-usa (DOT) com
References: <0d4001c35cfd$24889d00$a501280a (AT) phx (DOT) gbl
Oe1EyxWXDHA.1004 (AT) TK2MSFTNGP12 (DOT) phx.gbl
Subject: Re: Error Processing Cube or Dimension in Analysis Manager
Date: Tue, 12 Aug 2003 20:21:14 -0700
Lines: 42
Message-ID: <08ae01c36149$f3d33d40$a401280a (AT) phx (DOT) gbl
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Thread-Index: AcNhSfPQswHj6ufnQIyJXEu0Hcbz/w==
Newsgroups: microsoft.public.sqlserver.olap
Path: cpmsftngxa06.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.olap:41689
NNTP-Posting-Host: TK2MSFTNGXA12 10.40.1.164
X-Tomcat-NG: microsoft.public.sqlserver.olap

Completely uninstalled sql and analysis server.
Reinstalled them both up to sp3. Rebuilt the cube. Same
Error. It looks like some kind of security issue...

Robin
-----Original Message-----
Try SQL Server & AS SP3

Check this
http://support.microsoft.com/default.aspx?scid=kb;en-
us;317059

--

Jose Mariano Alvarez
Comunidad de base de datos
Grupo de Usuarios Microsoft
www.mug.org.ar

"Robin Zwirtz" <robinz (AT) edge-usa (DOT) com> wrote in message
news:0d4001c35cfd$24889d00$a501280a (AT) phx (DOT) gbl...
I have an instance of SQL Server running sp3 and am
getting the following error when I try to Process:
"Analysis Server Error: COM(OLE) error [Initialization
error]'The specified module could not be found.'

I have tried reinstalling MDAC(2.6sp2) and uninstalling
and reinstalling Analysis Services and SQL Server with
no
luck. We where having problems with an application
that
used SQL as well, but fixed that by going back to MDAC
2.6sp2 from 2.7sp1.

Any ideas would be appreciated.

Robin

.

#3

Certainly I would agree with Bill, but here are a couple of points. When you
are creating a data source / dimension / cube object, you are doing this in
the context of the interactive NT account that Analysis Manager is running
under. So if, for example, you have an OLEDB provider that is available on
the machine where AM is running, then it appears in the dropdown list of
available data sources.. you can browse it, setup dimensions, cubes, etc.
under it.

BUT, when you go to process an object, the actual processing is not done by
Analysis Manager under your interactive account, but the Analysis service
(msmdsrv) -- which could be a totally different machine.

Normally what this error is telling you is that when the Analysis service
(msmdsrv) goes to process a dimension/cube/partition it cannot find the
OLEDB provider that was specified in the data source. Might this be what is
happening??
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

""Bill Cheng [MSFT]"" <billchng (AT) online (DOT) microsoft.com> wrote

Quote:

Hi Robin,

I think this issue is quite complex. If it is urgent, I would suggest that
you open an incident with Microsoft Product Support Services via
http://support.microsoft.com/default...EN-US;CNTACTMS, so that
we can have dedicated engineer to assist you.

I would collect the following information.
1. What is the operating system?
2. If you create a new OLAP cube in a new OLAP database and process it,
will the error occur?
3. Could you try installing latest MDAC component?

http://www.microsoft.com/downloads/d...rosoft.com/dow

nloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&DisplayLan
g=en
4. You may use Filemon or Regmon from sysinternals to monitor which module
is missing.

Bill Cheng
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
--------------------
| Content-Class: urn:content-classes:message
| From: "Robin Zwirtz" <robinz (AT) edge-usa (DOT) com
| Sender: "Robin Zwirtz" <robinz (AT) edge-usa (DOT) com
| References: <0d4001c35cfd$24889d00$a501280a (AT) phx (DOT) gbl
Oe1EyxWXDHA.1004 (AT) TK2MSFTNGP12 (DOT) phx.gbl
| Subject: Re: Error Processing Cube or Dimension in Analysis Manager
| Date: Tue, 12 Aug 2003 20:21:14 -0700
| Lines: 42
| Message-ID: <08ae01c36149$f3d33d40$a401280a (AT) phx (DOT) gbl
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcNhSfPQswHj6ufnQIyJXEu0Hcbz/w==
| Newsgroups: microsoft.public.sqlserver.olap
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.olap:41689
| NNTP-Posting-Host: TK2MSFTNGXA12 10.40.1.164
| X-Tomcat-NG: microsoft.public.sqlserver.olap
|
| Completely uninstalled sql and analysis server.
| Reinstalled them both up to sp3. Rebuilt the cube. Same
| Error. It looks like some kind of security issue...
|
| Robin
| >-----Original Message-----
| >Try SQL Server & AS SP3
|
| >Check this
| >http://support.microsoft.com/default.aspx?scid=kb;en-
| us;317059
|
| >--
|
| >Jose Mariano Alvarez
| >Comunidad de base de datos
| >Grupo de Usuarios Microsoft
| >www.mug.org.ar
|
|
| >"Robin Zwirtz" <robinz (AT) edge-usa (DOT) com> wrote in message
| >news:0d4001c35cfd$24889d00$a501280a (AT) phx (DOT) gbl...
| >> I have an instance of SQL Server running sp3 and am
| >> getting the following error when I try to Process:
| >> "Analysis Server Error: COM(OLE) error [Initialization
| >> error]'The specified module could not be found.'
|
| >> I have tried reinstalling MDAC(2.6sp2) and uninstalling
| >> and reinstalling Analysis Services and SQL Server with
| no
| >> luck. We where having problems with an application
| that
| >> used SQL as well, but fixed that by going back to MDAC
| >> 2.6sp2 from 2.7sp1.
|
| >> Any ideas would be appreciated.
|
| >> Robin
|
|
| >.
|
|

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Error Processing Cube or Dimension in Analysis Manager

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: Error Processing Cube or Dimension in Analysis Manager - 08-12-2003 , 10:21 PM

Re: Error Processing Cube or Dimension in Analysis Manager - 08-14-2003 , 07:13 AM

Re: Error Processing Cube or Dimension in Analysis Manager - 08-14-2003 , 04:02 PM