Geeks With Blogs
Andy Morrison's BizTalk Blog Help, I've fallen and I can't BizTalk!

I ran into an issue with bm.exe this morning.

 

Here’s the error I saw when running the bm.exe depoy-all command on a spreadsheet.

 

Deploying View... ERROR: The BAM deployment failed.

Encountered error while executing command on SQL Server "MyMachineName".

String or binary data would be truncated.

The statement has been terminated.

 

I ran SQL Profiler the next time I executed this (as well as adding the –Trace:On parameter to the deploy-all command which _never_ seems to add any additional information.  After a little bit of sleuthing it looked like this was the last statement executed before profiler showed sql statements that were deleting BAM tables, sprocs, etc.

 

-- Register activity in RTA metadata table

INSERT [dbo].[bam_Metadata_RealTimeAggregations]

(

            CubeName,

            RtaName,

            RTAWindow,

            Timeslice,

            ConnectionString

)

VALUES

(

            N'CreateOESIView',

            N'CreateOESIPT',

            3600, -- RTA window defaults to 60 hours

            60,  -- Time slice defaults to 60 mins

            N'[HugeStringHere]’

 

The ConnectionString column’s max size is 3600 and you guessed it, my [HugeStringHere] value was larger than that.  The string was actually not just a connection string and included CREATE CUBE and other statements in it. 

 

It turns out that the PivotTable that I created in Excel for this particular view was too big – as in it had too much stuff in it (Dimensions, Measures).  I created a smaller pivot table with fewer Dimensions in it and then the activity deployed without problems.

Posted on Monday, May 4, 2009 11:45 AM BizTalk | Back to top

Copyright © Andy Morrison | Powered by: GeeksWithBlogs.net