|
Home > Archive > BizTalk Server General > January 2005 > BAM - Retrieving to Excel
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
BAM - Retrieving to Excel
|
|
| haggai.shachar@gmail.com 2005-01-30, 7:49 am |
| 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.
| |
| Derek Tan [MSFT] 2005-01-31, 5:53 pm |
| 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:22 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.sul.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 message are best directed to the newsgroup/thread
from which they originated.
|
|
|
|
|