BizTalk Server Orchestration - SQL Adapter - Strange Problem

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server Orchestration > March 2005 > SQL Adapter - Strange Problem





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]

Author SQL Adapter - Strange Problem
Sents

2005-03-10, 7:47 am

Hi,
I have a Receive SQL adapter fetching multi records from database and send
it to File adapter. I tried receivng more than 500 records which has done
perfectly.
I introduced a inbound map in the Receive SQL adapter.
then the problem starts....
I am not able to fetch more than 10 records...i tried by executing
sp_lock....it waits at some process....
I am not sure whats happening at all. if i remove the map it is working fine.

The same thing working fine in development environment...only it behaves
differently in testing evnironment.

Thanks
Joerg Fischer

2005-03-13, 5:49 pm

Hi,

Have you configured your map on the receive port or on the send port?

Sincerely

Joerg Fischer

"Sents" <Sents@discussions.microsoft.com> wrote in message
news:FD9C9550-3C5A-450B-B675-B1190794FDFD@microsoft.com...
> Hi,
> I have a Receive SQL adapter fetching multi records from database and send
> it to File adapter. I tried receivng more than 500 records which has done
> perfectly.
> I introduced a inbound map in the Receive SQL adapter.
> then the problem starts....
> I am not able to fetch more than 10 records...i tried by executing
> sp_lock....it waits at some process....
> I am not sure whats happening at all. if i remove the map it is working

fine.
>
> The same thing working fine in development environment...only it behaves
> differently in testing evnironment.
>
> Thanks



Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com