Hi,

I'm trying to write-enable a cube (MS OLAP 2000) that uses
an Oracle 9.2.0.1 db as data source (through the Oracle
oleDB9 provider). Source user is SYSTEM.

My cube is built, processed and I can access its data.

Then, I am able to write-enable it *but* :

1/ once the writeback table is created, I cannot do
anything (ie select, update, insert) manually. I first
need to grant select, update, insert and delete to user
SYSTEM manually.

2/ when I try to browse the writeback data in Analysis
Manager, I get a message saying the weriteback table
cannot be found.

Is this a known bug or just a configuration issues ?

thx&rgds,
FBA

Hi Francois,

I'm looking into this issue right now and will update you later.

Thank you,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Hi Francois,

Is your SQL Server 2000 Analysis Services applied with the latest service
pack?
320736 FIX: Writeback Fails with "Relational data provider reported error:
http://support.microsoft.com/?id=320736

Since using non-Microsoft SQL Server data sources for "write-enable" cube
is complex, I 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.

You may also post event log, detailed error message encountered here.


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.
--------------------

I applied SP3 to my OLAP server. Same problem occurs.


Bill Cheng [MSFT] a écrit:

I've slightly changed my configuration. My data source is now using
username "SA" which was migrated from the original SQL server DB.
Note that all dimensions and fact tables are under db schema "SA".

I am now able to create and browse data in the writeback table provided
I give an UPPERCASE name to the writeback table when I write-enable my cube.

Now, I get another error when trying to actually write into the cube.
Here is what I do :
0/ launch an MDX SELECT query
1/ open a new transaction.
2/ launch the UPDATE CUBE statement
3/ commit the transaction.

This leads to the following error message "no active transction was
found" (well, that's my english translation of the french error message
I get).

Any idea ?

thx&rgds,
Francois

Francois a écrit:

Hi Francois,

As I mentioned, using Oracle as data source is usually complex to
troubleshoot in newsgroups. I suggest that you open an incident with
Microsoft PSS.

In addition, what program reports the "active transaction" error? Is it
Oracle? You may try to capture the SQL statements sent to Oracle to check
if there is anything wrong (However, as I know, Oracle does not have a
utility like SQL Profiler).

Which provider did you use to connect to Oracle 9? Is it Microsoft OLEDB
Provider for Oracle?


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.
--------------------

Hi Francois,

Thanks for the update. If you submitted an incident, please let me know the
case number so that I can monitor the progress and post the benefits for
the community.

According to my research, if you call Connection.BeginTrans and
Connection.CommitTrans in ADO, it will call the underlying OLEDB provider
to open transaction with the data source.

According to my experience with SQL Server 2000, it will create a
write-back table on the data source, whether it is MOLAP or ROLAP.


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.
--------------------
<3F434359.5070500 (AT) caramail (DOT) com> <6jLFPP7ZDHA.2412 (AT) cpmsftngxa06 (DOT) phx.gbl>