|
Home > Archive > BizTalk Server General > February 2006 > problem with SQL adapter
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 |
problem with SQL adapter
|
|
| BizTalkerrrrrrrr 2006-02-22, 5:57 pm |
| Hi, all,
I have a problem with SQL adapter, if I limit the sql to select top 100
records, then it works fine, I can get the output xml file after the
orchestration. But when I change the sql to select all records (1000 or so),
the connection is just hanging there ( i can see it from sql enterprise
manager) forever. And MSDTC shows the active transaction. The final output I
expected to be 2M size. And I checked the Biztalk server message limit, the
MSDTC timout value, they are all fine.
What could be the problem?
Thanks
| |
| BizWorld 2006-02-26, 10:47 am |
| just look into Event viewer for further error detail. SQL Adapter errors
appear in Event viewer. i am also using SQL Adapter but did not faced this
issue.
BizWorld
"BizTalkerrrrrrrr" <BizTalkerrrrrrrr@discussions.microsoft.com> wrote in
message news:4D356D8B-DFF4-4727-BA95-FCB6DDB20832@microsoft.com...
> Hi, all,
>
> I have a problem with SQL adapter, if I limit the sql to select top 100
> records, then it works fine, I can get the output xml file after the
> orchestration. But when I change the sql to select all records (1000 or
> so),
> the connection is just hanging there ( i can see it from sql enterprise
> manager) forever. And MSDTC shows the active transaction. The final output
> I
> expected to be 2M size. And I checked the Biztalk server message limit,
> the
> MSDTC timout value, they are all fine.
>
> What could be the problem?
>
> Thanks
| |
| Niklas Engfelt 2006-02-26, 10:47 am |
| Make sure you have BizTalk 2004 SP1 installed because the RTM version
have a bug that does not display SQL errors correctly. (You only get
useless unknown errors.)
Best regards
Niklas Engfelt
|
|
|
|
|