|
Home > Archive > BizTalk Server General > June 2004 > HELP! - PLEASE!
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]
|
|
|
| I'm using BTS 2002 (SP1) and AICSQL to parse XML documents
and insert/update records in an SQL Server db table (using
stored procedures). Current testing is being done on a
fast Dell 2650 Server. SQL Server is installed on this
same server for testing purposes and is a stand alone
config. There is a mapping between the document
definitions, and existence functoids are used for fields
that may not be present in the data instance. One
definition/map is used for Insertions/Updates/Deletions
etc; a scripting functiod determines the relevant stored
procedure param name (insert, update etc).
All works well except when processing documents for
update! For example, testing 617 data instances (all for
insertion as new records), collected via a file receive
function, are processed within say 30 seconds. Using same
data instances (simple single record XML) but amended for
updating the previously inserted records can take anything
up to 20 mins! The interchanges spend a long time in the
work queue and sometimes up to a quarter are placed in the
retry queue and warnings are then generated. The warning
is always a parsing failure and transport error (while
processing message port using transport component of
AICSQL pipeline 1). Any retry and suspension queue docs
will eventually parse and update.
So, why does it take so long to do updates compared to
inserts (using same type of data, mapping, doc defs etc)?
Is there something I'm not doing right? Any suggestions
much appreciated.
Phil.
| |
| Allen Zhang 2004-06-26, 10:51 am |
| Can you use SQL profiler to see if the data you are trying to update is
indeed correct? Sound from the parsing failure and transport error, the
data could not be updated which resulted message retries. With default
retry count of 3 and 5 minutes interval, that would explain the long delays
you have seen.
- Allen Zhang (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
>
> I'm using BTS 2002 (SP1) and AICSQL to parse XML documents
> and insert/update records in an SQL Server db table (using
> stored procedures). Current testing is being done on a
> fast Dell 2650 Server. SQL Server is installed on this
> same server for testing purposes and is a stand alone
> config. There is a mapping between the document
> definitions, and existence functoids are used for fields
> that may not be present in the data instance. One
> definition/map is used for Insertions/Updates/Deletions
> etc; a scripting functiod determines the relevant stored
> procedure param name (insert, update etc).
>
> All works well except when processing documents for
> update! For example, testing 617 data instances (all for
> insertion as new records), collected via a file receive
> function, are processed within say 30 seconds. Using same
> data instances (simple single record XML) but amended for
> updating the previously inserted records can take anything
> up to 20 mins! The interchanges spend a long time in the
> work queue and sometimes up to a quarter are placed in the
> retry queue and warnings are then generated. The warning
> is always a parsing failure and transport error (while
> processing message port using transport component of
> AICSQL pipeline 1). Any retry and suspension queue docs
> will eventually parse and update.
>
> So, why does it take so long to do updates compared to
> inserts (using same type of data, mapping, doc defs etc)?
> Is there something I'm not doing right? Any suggestions
> much appreciated.
>
> Phil.
>
>
|
|
|
|
|