Hello,
I created a BAM activity, deployed the xls file to the DB and hooked my
orchestration to an activity schema.
So far, everything looks fine - tabled and views created, and got
updated as I delivered my messages in the orchestration.

My problem is retrieving the data using excel.
When I open The BAMTest_LiveData.xls and try to refresh i got message:
Error while processing a partition: ".
No further information on the event log.

I'm running MSSQL SP3 a BizTalk SP1.
Can anyone please help me here?

Thanks,
Haggai.

[ Post a follow-up to this message ]

Hi Haggai,

Are the pivot tables Real Time Aggregation type? If not, make sure that the 
bam_AN_<Cube Name> DTS task is run so
that the cube gets created.

Otherwise, please attach the BAMTest.xls.

Thanks,
Derek [MSFT]

--------------------
>From: haggai.shachar@gmail.com
>Newsgroups: microsoft.public.biztalk.general
>Subject: BAM - Retrieving to Excel
>Date: 30 Jan 2005 04:29:19 -0800
>Organization: http://groups.google.com
>Lines: 17
>Message-ID: <1107088159.263666.194130@c13g2000cwb.googlegroups.com>
>NNTP-Posting-Host: 212.150.2.250
>Mime-Version: 1.0
>Content-Type: text/plain; charset="iso-8859-1"
>X-Trace: posting.google.com 1107088162 25104 127.0.0.1 (30 Jan 2005 12:29:2
2 GMT)
>X-Complaints-To: groups-abuse@google.com
>NNTP-Posting-Date: Sun, 30 Jan 2005 12:29:22 +0000 (UTC)
>User-Agent: G2/0.2
>Complaints-To: groups-abuse@google.com
>Injection-Info: c13g2000cwb.googlegroups.com; posting-host=212.150.2.250;
>   posting- account=pgNljA0AAADM8qBGjzgq9Iklq927ulSB

>Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.su
l.t-online.de!t-online.de!
news.glorb.com!postnews.google.com!c13g2000cwb.googlegroups.com!not-for-mail
>Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.general:24113
>X-Tomcat-NG: microsoft.public.biztalk.general
>
>Hello,
>I created a BAM activity, deployed the xls file to the DB and hooked my
>orchestration to an activity schema.
>So far, everything looks fine - tabled and views created, and got
>updated as I delivered my messages in the orchestration.
>
>My problem is retrieving the data using excel.
>When I open The BAMTest_LiveData.xls and try to refresh i got message:
>Error while processing a partition: ".
>No further information on the event log.
>
>I'm running MSSQL SP3 a BizTalk SP1.
>Can anyone please help me here?
>
>Thanks,
>Haggai.
>
>


--

This posting is provided "AS IS" with no warranties, and confers no rights. 
Use of included script samples are subject to
the terms specified at http://www.microsoft.com/info/cpyright.htm

Note:  For the benefit of the community-at-large, all responses to this mess
age are best directed to the newsgroup/thread
from which they originated.

[ Post a follow-up to this message ]