I´m a big fan of Analysis Services and have been working with MS business
intelligence since 1998. This is the first time I have seen a crucial bug in
a project. Before this AS have always met my expectations. Why can I not get
a reply on this problem from Microsoft? OK, If I have not seen something
obvious please tell me. This is my previous message sent yesterday:


Writeback fails with " Relational data provider error:[columns does not
exist]. This error appears when I try to do commit,after I have entered the
data into the cells, from the client. I have found a knowledge base
article - 320736, that describe this problem as appearing with non SQL
server databases. But I have this problem with an SQL Server 2K SP3 where
my writeback table is kept. The server is a Windows 2000 Advanced server
SP4.
The only place where I can see an error message is in the event viewer under
application. There are no error messages from SQL Server. Yesterday I
migrated the repository from Access to SQL Server 2K SP3.

I have not been able to reproduce the same error my own machine, a Windows
2003 Server with SQL Server Developer Editon SP3.

How can I solve this problem?

/Thomas Ivarsson

No. We use standard dimensions without disabled levels. Security roles are
used but I built a test cube without security roles to make sure that this
was not the problem. There are source table filters on the fact table
however. Writeback works with SP2 SQL Servers and SP2 Analysis Services.

If you need any more data I can send that to you. As I said a few days ago I
have compared SQL server profiler traces on our "problem"-server with a
server that works. No inserts occur on our "problem" server only a few
selects and rollbacks. Error messages occur on my client and the event
viewer on the server.

Thomas Ivarsson



"Sean Boon [MS]" <seanboon (AT) online (DOT) microsoft.com> wrote

This is the mail I sent some weeks ago with the trace of the writeback that
do not work:

This is the same writeback problem that I posted last week without any
reply. I am unable to commit writeback values from cells in ProClarity 5.2
desktop client to a writeback table in SQL Server 2000. This is probably not
a ProClarity problem because I can write back to an access database on the
same server as Analysis Services. Client, Analysis Services and the database
are all SP3. In all my test with writeback I am an OLAP administrator.

I have traced the activity from AS to the writeback table with Profiler.
One trace on my own machine, that works, shows a lot of the following
activity:

exec sp_cursor 180150000, 4, 0, N'WriteTable_Sales1997', @MS_AUDIT_USER =
'XXX\xx', @MS_AUDIT_TIME = 'Jun 29 2003 11:51:39:000AM', @Country_L2 = N'USA
', @StateProvince_L3 = N'WA
', @City_L4 = N'Anacortes ',
@Lname_L5 = 7919, @ProductFamily_L7 = N'Drink
', @ProductDepartment_L8 = N'Alcoholic Beverages
', @ProductSubcategory_L9 = N'Beer
', @BrandName_L10 = N'Good
', @ProductName_L11 = 266, @StoreCountry_L13 = N'Canada
', @StoreState_L14 = N'BC ',
@StoreName_L15 = 19, @Year_L17 = 1997, @Quarter_L18 = 1, @Month_L19 = 1,
@Day_L20 = '19970101', @SUM_StoreSales = $0.3688, @SUM_StoreCost = $0.0000,
@SUM_UnitSales = 0.000000000000000e+000

This is from the foodmart database migrated to SQL Server 2000. This type of
writes is not present on my customers server. I only see lines like "SET
Transaction Isolation level Read Uncommited" and IF @@Trancount > 0 Rollback
Tran".

Any help is highly appreciated(Microsoft!)
Regards
Thomas Ivarsson DW, Consultant Malmö Sweden.




"Thomas Ivarsson" <thomas_ivarsson_malmo (AT) hotmail (DOT) com> wrote