bm.exe deployment common errors and resolutions

re: bm.exe deployment common errors and resolutions

PBR — Mon, 07 Mar 2005 18:04:00 GMT

Thanks for the information...nice to see someone concentrating on this part of BizTalk Server...

re: bm.exe deployment common errors and resolutions

Saravana Kumar — Tue, 08 Mar 2005 18:02:00 GMT

Invalid object name 'dbo.bam_ManagerView_ViewLoanProcess_ActiveAliasView'.

Can't figure out what the problem is and couldn't find any useful help/info.

Cheers,
Saravana

re: bm.exe deployment common errors and resolutions

Chun — Tue, 08 Mar 2005 23:15:00 GMT

Hi Saravana,

Thanks for raising the issue. I updated my original post w/ error #5. Let me know if you have additional questions.

Cheers,
Chun

BAM Blog

Matt Hall's Blog — Wed, 09 Mar 2005 18:29:00 GMT

BAM Blog

Matt Hall's Blog — Wed, 09 Mar 2005 18:32:00 GMT

re: bm.exe deployment common errors and resolutions

Robert Rijsdijk — Thu, 17 Mar 2005 21:20:00 GMT

Hi Chun , I've got a very strange error : Syntax error expecting ',' . : HIDDEN something like this. What I did to solve this is the run the repair option in Add Remove Programs of Microsoft Office 2003 :)). Cheers , Robert.

re: bm.exe deployment common errors and resolutions

Patrick — Mon, 16 Oct 2006 16:19:32 GMT

Hi Chun,

unfortunately I can't get BAM to run.

I did a lot and I can deploy all staff. I get the *_LiveData.xls-File but whenever I open it it fails with:

Some of the Pivottables could not be actual because the connection to the BAM- or OLAP-Databases con not be opened.

Do you have any idea, what is missing here?

My Configuration is BTS 2004 in german, AS with SP4 and I also installed the KB 831950 for SQL Server.

Thanks a lot and keep on blogging!

Best reagrds

Patrick

re: bm.exe deployment common errors and resolutions

chunyu — Mon, 16 Oct 2006 20:30:03 GMT

Patrick, first make sure you can connect to the SQL and Olap servers specified in the configuration Xml. second, try to pump in some data either via the orchestration or manually. Due to pivot table limitation, live data BAM xls file can't connect to blank table.

Hope this helps.

re: bm.exe deployment common errors and resolutions

Patrick — Mon, 30 Oct 2006 12:34:28 GMT

Hi Chun,

thanks for your help and for the good tip with the "empty tables"...

Now, there is a data format question for a duration. In the Duration-Object you have a begin and an end with each DateTime-Fields. Next step ist than to get the aggregation-types Max, Min, Average. In our Business Case we get as example 0,001227083 as AverageDuration.

Now the question: Is there a clear definition of the datatype and how could we transform it so seconds or milli seconds?

Thanks again and best regards

Patrick

re: bm.exe deployment common errors and resolutions

chunyu — Thu, 02 Nov 2006 07:51:36 GMT

Patrick, for each duration, bm.exe creates two datatime fields (one for begin, the other for end point) in the underlining sql table. and in the public sql view, which is exposed to users, we create a float datatype that simply calcualte the time diff and always convert that to a fix time unit (it's either day or second, i couldn't remember on top of my head since i wrote that code more than 2 years ago).

For the sake of consistency, we made conscious decision to use a fix time unit for all durations. the other option is to always convert to user specified time unit (day, hour etc.) The drawback of that is user would have no clue what the numeric value for the duration stands for when she look at sql view w/o the xml file by her side.

after understanding this, you should be able to convert the duration to whatever unit you choose in your own app that queries the BAM view.

BAM Error! Help Needed!

Failed to deploy BAM — Thu, 16 Nov 2006 15:20:18 GMT

I have sql server named XYZ\SQLSVR that contains BAMArchive, BAMPrimaryImport databases. I also have sql analysis server named XYZ that contains BAMAnalysis, BizTalkAnalysisDb databases. These two are on the same machine (computer) named XYZ thats running windows XP service pack 2. I am getting the following error:

....

Failed to deploy BAM start schema database

sql server does not exist or access denied

Please help me. Appreciated.

re: bm.exe deployment common errors and resolutions

chunyu — Sat, 18 Nov 2006 03:13:59 GMT

You may have forgotten to specify the star-schema database. Check your BAMConfiguration.xml to see whether BAMStarSchema entry is missing.

bm exe

bm exe — Sat, 26 Jul 2008 05:29:32 GMT

PingBack from http://alanwebsite.my3gb.com/bmexe.html