wcf-sql adapter bug for operation on same table


hi experts,
first of explain u module..

1.) inserting xml files in sql 2008 using wcf-sql adapter through
an orchestration..

2.)am retrieving records same table using wcf-sql adapter.
here polling records directly admin console...


my problem ,for first time records inserted , second time
they going dehydrated stage...

when disable receivelocation(polling table), records being  inserting without
dehydration..after r&d come know problem exists because,
am inserting & retreiving data same table..i think locking database
at polling time.what solution this?

can 1 faced same problem?is wcf-sql bug?is there solution to
overcome problem?needed urgently pls

based on scenario you've described, dirty reads out (since want update on records retrieved).  so you've got options here if looking configuration based solution.  if data you’re polling on can near real time, can set polling interval in 8-10 minute range (or longer if business scenario supports it); set in pollingintervalinseconds on ‘binding’ tab of receive location (thus 420 - 600).  i set retry intervals on send port inserting data in 1-3 minute range (and @ least 3 retries); if polling data returned can go on shorter timeframe retry happen quicker.  you find retry interval , retry count on 'transport advanced options' of port configuration send port.  in scenario, if blocked on insert because of polling, should retry insert before next polling interval.  keep mind these settings complete shot in dark since unfamiliar number of rows on bulk insert , how many rows returned on polling statement.  if data volumes small, can skew towards shorter times.

 

a couple of things keep in mind solution.  first, not eliminate possibility of block, lowers chances occur reducing polling interval; though insert should succeed on retry.  it creates scenario data received earlier can inserted after data received later.  this because data dehyrated because of blocking, data comes after inserted before resumption of suspended message.



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