Tracking to BAM from 'within SQL Server'


hello,

is there supported way tracking bam within, example, sql server clr stored procedure?

we have implemented aggregator (let's call stp aggregator) on top of sql server. individual messages flown stp aggregator aggregated on aggregate completness trigger condition. concrete aggregates individual messages aggregated not known when messages sent stp aggregator. therefore cannot track / correlate individual messages future built aggregate on way stp aggregator (from within, let's say, custom pipeline component). bam tracking/correlation must happen when aggregates created.

i've tried integrate / use bam dlls custom clr stored procedure. anyhow not possible because of other dll dependendies. 1 dependendy has static not readonly field , therefore cannot added custom sql assembly. if work use bam api tracking.

if there no possiblity (supported) direct tracking bam within sql server - guess - create additional aggregation header (section) on aggregation containing bam correlation identifiers (which in biztalk extracted , tracked/correlated bam corresponding aggregate's tracking record). anyhow don't create such additional header section. tracking bam during aggregation - opinion - cleanest/nicest way. our individual created aggregations may have sizes 250 mb resp. serveral 100.000 aggregated messages. therefore don't want blow aggregates further up. if nothing else works...

as far know writing directly bam via custom sql statements not supported. if supported see problem. throughput reasons use buffered event streams. therefore because of asynchronicity there messages have not been tracked via bam api database , sure conflict custom (immediate) sql bam tracking statements. if work: don't want not supported things.

any suggestions? took wf/wcf bam interceptors. but nothing built overnight sql server...

thanks lot,

gordon weckbach

so question how data bam sql sql? have use hop can data tracked. have generic orchestration using typed polling checks data changes. change record in sql , orchestration gets activated (it feel trigger) , message tracked bam.

thanks,

if answers question, please use "answer" button | ben cline


BizTalk Server  >  BizTalk Server General



Comments

Post a Comment

Popular posts from this blog

Azure DocumentDB Owner resource does not exist

having same error microsoft.azure.documents.documentclientexception: message: {"errors":["owner resource not exist"]} , scenario. when deployed webapp azure , try document docdb throws error. docdb exists in azure , contains document looking for. weird local machine(running vs) works fine. i'm using same settings in azure , local. have , idea this. thanks Microsoft Azure  >  Azure Cosmos DB
Read more

job syspolicy_purge_history job fail in sqlserver 2008

Image
hello guys, when installed sqlserver,it automatically created 1 job name job syspolicy_purge_history. but failed @ step 1. the reason is: date                11/6/2010 2:00:00 am log                job history (syspolicy_purge_history) step id                1 server                mxosv-otsdb01 job name                syspolicy_purge_history step name                verify automation enabled. duration                00:00:00 sql severity                16 sql message id                34022 operator emailed                operator net sent                operator paged                retries attempted                0 message executed user: nt authority\system. policy automation turned off. [sqlstate 42000] (error 34022).  the step failed. have run statement: select msdb.dbo.fn_syspolicy_is_automation_enabled the returned valus 0. what can resolve it? or can delete job manually.   thanks in advance. if haven't things want,be
Read more

Trying to register with public marketplace error with 'Get-AzureStackStampInformation'

when trying register against public azure adfs azure stack error below. logs can found at: c:\maslogs\azurestack.azureregistration.2017-10-12.01-31-23.log  and  \\azs-ercs01\c$\maslogs error occurred checking stamp information: system.management.automation.remoteexception: term 'get-azurestackstampinformation' not recognized name of cmdlet, function, script file, or operable program. check spelling of name, or if path included, verify path correct , try again. @ c:\azurestack-tools-master\registration\registerwithazure.psm1:1106 char:5 +     throw "logs can found at: $global:azureregistrationlog  and  \ ... +     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~     + categoryinfo          : operationstopped: (logs can fou... , try again.:string) [], runtimeexception     + fullyqualifiederrorid : logs can found at: c:\maslogs\azurestack.azureregistration.2017-10-12.01-31-23.log  a    nd  \\azs-ercs01\c$\maslogs error occurred chec
Read more