|
Home > Archive > BizTalk Server General > February 2006 > BAM not working
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]
|
|
| Jan Eliasen 2006-02-14, 7:48 am |
| Hi
I have a setup on a server, where I would like to use BAM.
I have followed all the steps I think are necessary, ie. created
activities and views in excel, created a tracking profile and deployed
it, deployed the excel file and put some messages through the
orchestration. I have not selected the RTA option in the excel-sheet.
Everything goes well, without errors at all.
Now, when running the BAM_AN_Something DTS package, I get an error in
the step that is "Full process active instances cube".
I have tried opening analysis services manager, and manually processed
dimensions and cubes, but none of them will process. Looking more
closely at the tables, it seems that in the BAMPrimaryImport database,
the bam_XXX_YYY_ActiveInstancesSnapshot table does not contain any
rows.
The other tables, ZZZ_Active, ZZZ_ActiveRelationships, ZZZ_Completed,
ZZZ_CompletesRelationships and ZZZ_Continuations appear to contain the
rows I would expect.
The staging table in the BAMStarSchema database gets its data from the
bam_XXX_YYY_ActiveInstancesSnapshot table, and since there are no rows
there, there are also no rows to proces the dimensions and cubes from.
So... is this really the problem, or is the problem something else?
Can anyone please please help me?
--
Eliasen Jr. representing himself and not the company he works for.
Private email: jan@eliasen.dk
| |
| Dilip Hinge[MSFT] 2006-02-14, 5:51 pm |
| Do you get any even log errors?
Try running SQL profiler to find any additional info.
-Dilip
**This posting is provided "AS IS" with no warranties, and confers no
rights. You assume all risk for your use. © 2001 Microsoft Corporation. All
rights reserved.**
| |
| Jan Eliasen 2006-02-15, 7:50 am |
| On Tue, 14 Feb 2006 22:45:28 GMT, dilip@online.microsoft.com.invalid
("Dilip Hinge[MSFT]") wrote:
>Do you get any even log errors?
>Try running SQL profiler to find any additional info.
Hi
No errors in the eventlog.
I wouldn't know which events, etc. to track in the SQL Profiler.
I was hoping someone could tell me what can be wrong if no data comes
into the bam_XXX_YYY_ActiveInstancesSnapshot table. Which proces is
supposed to put data into this table, and what can go wrong?
--
Eliasen Jr. representing himself and not the company he works for.
Private email: jan@eliasen.dk
| |
| Dilip Hinge[MSFT] 2006-02-17, 10:50 pm |
| Your OLAP server and SQL server are on the same physical machine?
if not then the OLAP process account will need db_datareader on the
Starschema database
you said, you get error in the task "Full process active instances cube",
what is that error?
Can you send me the definition file(xls)?
-Dilip
**This posting is provided "AS IS" with no warranties, and confers no
rights. You assume all risk for your use. © 2001 Microsoft Corporation. All
rights reserved.**
| |
| Jan Eliasen 2006-02-17, 10:50 pm |
| On Wed, 15 Feb 2006 18:41:24 GMT, dilip@online.microsoft.com.invalid
("Dilip Hinge[MSFT]") wrote:
>Your OLAP server and SQL server are on the same physical machine?
>if not then the OLAP process account will need db_datareader on the
>Starschema database
I am running the DTS package manually via Enterprise Manager. I am
logged in as a user that is db_owner on the StarSchema database.
Besides, as I see it, the problem is that no data is coming into the
StarSchema database.
If I understand the DTS package correctly, then data for the
StarSchema database (the staging-table) is coming from the
bam_XXX_YYY_ActiveInstancesSnapshot table in the PrimaryImport
database.
And this table does not contain any data. Therefore, no data comes to
the staging table, and therefore, the cube and the dimensions can not
be processed.
>you said, you get error in the task "Full process active instances cube",
>what is that error?
I actually get two errors. The first can be found at
http://www.eliasen.dk/biztalk/BAM_error1.jpg
Then, I click "OK" and then I get the second error, which can be found
at http://www.eliasen.dk/biztalk/BAM_error2.jpg
>Can you send me the definition file(xls)?
Sure - done... in case your emailaddress is the one you have posted
under, after removing "invalid" and "online"?
--
Eliasen Jr. representing himself and not the company he works for.
Private email: jan@eliasen.dk
| |
| Dilip Hinge[MSFT] 2006-02-17, 10:50 pm |
| It is the DTS package that moves all the data around.
looks like the DTS package is failing to read the data from the
Active/Completed tables.
Can you send me the Def file. so that I can try to repro it here?
-Dilip
**This posting is provided "AS IS" with no warranties, and confers no
rights. You assume all risk for your use. © 2001 Microsoft Corporation. All
rights reserved.**
| |
| Jan Eliasen 2006-02-17, 10:50 pm |
| On Thu, 16 Feb 2006 21:58:32 GMT, dilip@online.microsoft.com.invalid
("Dilip Hinge[MSFT]") wrote:
>It is the DTS package that moves all the data around.
>looks like the DTS package is failing to read the data from the
>Active/Completed tables.
>Can you send me the Def file. so that I can try to repro it here?
Sure. What is a Def file?
--
Eliasen Jr. representing himself and not the company he works for.
Private email: jan@eliasen.dk
| |
| Dilip Hinge[MSFT] 2006-02-17, 10:50 pm |
| It is the Excel File where you created View and Activity defintion.
**This posting is provided "AS IS" with no warranties, and confers no
rights. You assume all risk for your use. © 2001 Microsoft Corporation. All
rights reserved.**
| |
| Jan Eliasen 2006-02-17, 10:50 pm |
| On Fri, 17 Feb 2006 19:04:50 GMT, dilip@online.microsoft.com.invalid
("Dilip Hinge[MSFT]") wrote:
>It is the Excel File where you created View and Activity defintion.
I already emailed those to you yesterday (thursday) at 7:41 am CET, I
believe...
I sent it to dilip@online.microsoft.com.invalid without "online" and
without "invalid".
--
Eliasen Jr. representing himself and not the company he works for.
Private email: jan@eliasen.dk
| |
| Dilip Hinge[MSFT] 2006-02-17, 10:50 pm |
| diliph is my email alias
**This posting is provided "AS IS" with no warranties, and confers no
rights. You assume all risk for your use. © 2001 Microsoft Corporation. All
rights reserved.**
| |
| Jan Eliasen 2006-02-20, 7:47 am |
| On Fri, 17 Feb 2006 22:24:29 GMT, dilip@online.microsoft.com.invalid
("Dilip Hinge[MSFT]") wrote:
>diliph is my email alias
Right... I have emails you the files now.
--
Eliasen Jr. representing himself and not the company he works for.
Private email: jan@eliasen.dk
| |
| Dilip Hinge[MSFT] 2006-02-20, 5:52 pm |
| The definition file is from BTS 2004.
BTS 2006 will migrate already depliyed def files from 2004. It does not
migrate/convert def files from 2004 to 2006.
I will email you a non-public def files migration utility that you can use
to convert the 2004 file to 2006 format.
Make sure you have a copy of the file before you try the utility. Also, do
a thorough testing before putting it to a critical use.
-Dilip
**This posting is provided "AS IS" with no warranties, and confers no
rights. You assume all risk for your use. © 2001 Microsoft Corporation. All
rights reserved.**
| |
| Jan Eliasen 2006-02-21, 2:48 am |
| On Mon, 20 Feb 2006 17:56:14 GMT, dilip@online.microsoft.com.invalid
("Dilip Hinge[MSFT]") wrote:
>The definition file is from BTS 2004.
Yes. I am using BizTalk 2004, so that sounds right.
>I will email you a non-public def files migration utility that you can use
>to convert the 2004 file to 2006 format.
Well... I don't actually need it...
>Make sure you have a copy of the file before you try the utility. Also, do
>a thorough testing before putting it to a critical use.
As mentioned - I am not using BizTalk 2006. If I have written that
anywhere, then I appologize for the confusion.
So, given that I am using BizTalk 2004, do you have any suggestions?
--
Eliasen Jr. representing himself and not the company he works for.
Private email: jan@eliasen.dk
| |
| Jan Eliasen 2006-02-26, 10:47 am |
| On Mon, 20 Feb 2006 17:56:14 GMT, dilip@online.microsoft.com.invalid
("Dilip Hinge[MSFT]") wrote:
>The definition file is from BTS 2004.
>BTS 2006 will migrate already depliyed def files from 2004. It does not
>migrate/convert def files from 2004 to 2006.
>
>I will email you a non-public def files migration utility that you can use
>to convert the 2004 file to 2006 format.
>Make sure you have a copy of the file before you try the utility. Also, do
>a thorough testing before putting it to a critical use.
Hi
I haven't heard from you the last 3-4 days. Are you still working on
this issue?
--
Eliasen Jr. representing himself and not the company he works for.
Private email: jan@eliasen.dk
"Ford," he said, "you're turning into a penguin. Stop it."
|
|
|
|
|