|
Home > Archive > BizTalk Server Framework > February 2004 > The Number of recrod that Biztalk can process
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 |
The Number of recrod that Biztalk can process
|
|
| Nelson Terk 2004-02-08, 8:41 am |
| Hi Everyone,
I have a few files that is been process thru Biztalk
server that was around 4 thousand records in each file and
my Biztalk 2000 server did not process it. Can anyone tell
me is there a place to set the number of record to process
in Biztalk or is this a limitation with Biztalk?
Regards,
Nelson Terk
| |
| Nick Malik 2004-02-08, 8:41 am |
| Biztalk has a 4mb limit on the size of the XML files. Since these files are
in Unicode, that amounts to 2MB of text, in XML format. Note that your XML
documents are usually 20-40% larger than your raw text documents (except
EDI, where the XML can be easily three to four times the size of the EDI
document).
Therefore, 4000 records may end up being your upper limit.
Are you using Biztalk to process EDI?
--- Nick
"Nelson Terk" <nelsonterk@hotmail.com> wrote in message
news:9ccb01c3eacb$485c3910$a401280a@phx.gbl...
> Hi Everyone,
> I have a few files that is been process thru Biztalk
> server that was around 4 thousand records in each file and
> my Biztalk 2000 server did not process it. Can anyone tell
> me is there a place to set the number of record to process
> in Biztalk or is this a limitation with Biztalk?
> Regards,
> Nelson Terk
| |
| Nelson 2004-02-08, 8:41 am |
| Hi Nick,
thanks for the info, I am processing a text filethat is
about 2 to 3Mbyte in Size.
| |
| Jan Eliasen 2004-02-08, 8:41 am |
| On Wed, 04 Feb 2004 04:08:40 GMT, "Nick Malik"
<nickmalik@hotmail.nospam.com> wrote:
I seem to recall the limits being 10 and 20MB and not 2 and 4MB - am I
wrong?
>Biztalk has a 4mb limit on the size of the XML files. Since these files are
>in Unicode, that amounts to 2MB of text, in XML format. Note that your XML
>documents are usually 20-40% larger than your raw text documents (except
>EDI, where the XML can be easily three to four times the size of the EDI
>document).
>
>Therefore, 4000 records may end up being your upper limit.
>
>Are you using Biztalk to process EDI?
>
>--- Nick
>
>"Nelson Terk" <nelsonterk@hotmail.com> wrote in message
>news:9ccb01c3eacb$485c3910$a401280a@phx.gbl...
>
--
Jan Eliasen, representing himself and not the company he works for.
MCP in Microsoft BizTalk Server
| |
| Nick Malik 2004-02-08, 8:41 am |
| no, I'm wrong... (I need more sleep). I quoted the MSMQ limit.
http://msdn.microsoft.com/library/d...server_ovbv.asp
Biztalk limits to 20MB in Unicode XML. Depending on input type, you should
be able to squeeze in an input file of 5-7MB in ASCII.
My bad. My apologies.
--- Nick
"Jan Eliasen" <spam@eliasen.dk> wrote in message
news:qhk120dngc31uk43lpkv8kthfilcuoefd6@
4ax.com...
> On Wed, 04 Feb 2004 04:08:40 GMT, "Nick Malik"
> <nickmalik@hotmail.nospam.com> wrote:
>
> I seem to recall the limits being 10 and 20MB and not 2 and 4MB - am I
> wrong?
>
are[color=blue]
XML[color=blue]
>
> --
> Jan Eliasen, representing himself and not the company he works for.
> MCP in Microsoft BizTalk Server
| |
| Nick Malik 2004-02-08, 8:41 am |
| Hi Nelson,
Try this: change your port settings to write the output to a file share, and
turn off the envelope. You should get an XML file. Submit a small file to
make sure it works. Then, submit a couple of files that get close to your
limit. Take a look at the size of the output XML file. This will give you
an idea if you are running into the limit or not.
I misquoted earlier (thanks to Jan for catching me). The size limit is 20MB
in Unicode XML. That would equal 10MB in ASCII XML. Depending on the
amount of expansion you are getting when Biztalk serializes your data into
XML, you should be able to get a 2-3 Meg file through Biztalk without
difficulty. (It might take some time, depending on what you are doing, but
it should work).
You never did tell me if the input file is EDI... is it? That makes a
difference, because EDI is a very efficient format, that when converted to
XML, get's big.
--- Nick
"Nelson" <nelsonterk@hotmail.com> wrote in message
news:954f01c3eaff$ef95fc50$a301280a@phx.gbl...
> Hi Nick,
> thanks for the info, I am processing a text filethat is
> about 2 to 3Mbyte in Size.
>
| |
| Nelson 2004-02-08, 8:41 am |
| No worries it is ok. thanks for the pointer on how to
check the XML size Nick and to Jan too 
>-----Original Message-----
>no, I'm wrong... (I need more sleep). I quoted the MSMQ
limit.
>
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/bts_2002/htm/lat_admin_server_ovbv.asp
>
>Biztalk limits to 20MB in Unicode XML. Depending on
input type, you should
>be able to squeeze in an input file of 5-7MB in ASCII.
>
>My bad. My apologies.
>--- Nick
>
>"Jan Eliasen" <spam@eliasen.dk> wrote in message
> news:qhk120dngc31uk43lpkv8kthfilcuoefd6@
4ax.com...
and 4MB - am I[color=blue]
Since these files[color=blue]
>are
format. Note that your[color=blue]
>XML
documents (except[color=blue]
the size of the EDI[color=blue]
limit.[color=blue]
Biztalk[color=blue]
file and[color=blue]
anyone tell[color=blue]
process[color=blue]
he works for.[color=blue]
>
>
>.
>
| |
| rich dadisman 2004-02-08, 8:41 am |
| Also, keep in mind that XLang uses MSMQ and you therefore have the 4 MB
limit if you are using an XLang scheldule.
Rich
"Nelson Terk" <nelsonterk@hotmail.com> wrote in message
news:9ccb01c3eacb$485c3910$a401280a@phx.gbl...
> Hi Everyone,
> I have a few files that is been process thru Biztalk
> server that was around 4 thousand records in each file and
> my Biztalk 2000 server did not process it. Can anyone tell
> me is there a place to set the number of record to process
> in Biztalk or is this a limitation with Biztalk?
> Regards,
> Nelson Terk
|
|
|
|
|