Hi,

Any idea why it is possible to work in MSAS2000 and see the data from
an Oracle table but when processing with a Microsoft for Oracle /
Oracle OLE DB ODBC driver then there is always an error.

Regards, Marco

Why not transport using DTS...

Lots of oracle conversion trouble that you need to deal with.

datetime, row size limit

<olap (AT) gmsbv (DOT) nl> wrote

What errors are you seeing?

Dean.

"olap (AT) gmsbv (DOT) nl" wrote:

This is actually a common conceptional problem which happens even if you are
using a SQL Server data source.

When you are creating objects with Analysis Manager, looking at data, etc.
then you are using the interactive account running under Analysis Manager as
your security environment. However, when you process a dimension or
partition, it isn't your process which is doing the work -- it is the
MSSQLServerOLAPService service itself. This introduces several common
mis-configurations. For example, if you have the service configured to be
running under the Local System account, then it will be denied network
access (this is a characteristic of Local System that it is unable to touch
any network resources), or if you are using a domain account, it might not
have access to the remote machine, or have access to Oracle, etc.

The give-away is that you said this happens only when processing -- as soon
as I heard that, this mis-configuration immediately came to mind.

Hope that helps.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


<olap (AT) gmsbv (DOT) nl> wrote

But what is the solution to solve this.

I found several issues like change the local system account of OLAP
services or change the rights to the Oracle directory Home\Oracle ?

Is this also a problem in MS SQL Server 2005 ?

Regards, Marco



Dave Wickert [MSFT] schreef:

But what is the solution to solve this.

I found several issues like change the local system account of OLAP
services or change the rights to the Oracle directory Home\Oracle ?

Is this also a problem in MS SQL Server 2005 ?

Regards, Marco



Dave Wickert [MSFT] schreef:

But what is the solution to solve this.

I found several issues like change the local system account of OLAP
services or change the rights to the Oracle directory Home\Oracle ?

Is this also a problem in MS SQL Server 2005 ?

Regards, Marco



Dave Wickert [MSFT] schreef:

Describe the error. We use MS OLEDB fro Oracle for many years without
troubles.

Roman Domin
Senior Consultant
roman.domin (AT) adastracorp (DOT) com http://www.adastra.cz

Sorry. I thought that I said the solution. It is probably buried in the
explanation.

If this connection is to a remote server with Oracle on it, then the
solution is to use a domain account for your MSSQLServerOLAPService service
account which has the rights to access that server and that Oracle database.

Bring up Administartive Tools \ Services, navigate down to the
MSSQLServerOLAPService entry, double-click it and change the logon account.

By definition, the built-in Local System account is denied network access of
any type. This has been true in NT for years and years.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


<olap (AT) gmsbv (DOT) nl> wrote

We tried 3 connection from MS AS 2000 to Oracle 9. With all connections
we are able to use the wizard, see the Oracle tables and devlop cubes
and slicers. So far so good.

Now the last and most import one. Trying to process any cubes or slicer
is ending in an error with all 3 connections. Any idea why this is
happening, while the Wizards are working! I look forward to any
solution to be able to process cubes.

Errors:

Microsoft ODBC for Oracle driver:
Data source provider error: [Microsoft][ODBC-stuurprogrammabeheer]
SQLSetConnectAttr van het stuurprogramma is
mislukt;IM006;[Microsoft][ODBC driver for Oracle][Oracle]ORA-12154:
TNS:servicenaam kon niet worden herleid.;08001;

Microsoft OLE DB for Oracle:
Data source provider error: ORA-12154: TNS:could not resolve service
name;

Oracle Driver:
Data source provider error: Het opgegeven stuurprogramma kan niet
worden geladen vanwege een systeemfout 5 (Oracle in ORA92).;IM003;

Best Regards,
Marco Goeneveld
www.gmsbv.nl


roman.domin (AT) adastra (DOT) cz schreef: