|
Home > Archive > BizTalk Server Applications Integration > June 2004 > help with database functoid
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 |
help with database functoid
|
|
| daniel 2004-06-20, 11:09 pm |
| I have created a database functoid which I have successfully tested using
the Instanse XML to XML testing. When I attempt to use the map the documents
are not transferred and sit in the work queue in a processing state.
Both the input and output are SQL 2000 SP3a tables.
I am using Biztalk 2000 SP1.
Without the database functoid the documents are transferred successully.
| |
| daniel 2004-06-20, 11:09 pm |
| sorry that should be biztalk 2002 sp1.
"daniel" <invalidemail> wrote in message
news:ez5YaqpUEHA.2944@tk2msftngp13.phx.gbl...
> I have created a database functoid which I have successfully tested using
> the Instanse XML to XML testing. When I attempt to use the map the
documents
> are not transferred and sit in the work queue in a processing state.
>
> Both the input and output are SQL 2000 SP3a tables.
> I am using Biztalk 2000 SP1.
>
> Without the database functoid the documents are transferred successully.
>
>
| |
| Jan Eliasen 2004-06-20, 11:09 pm |
| Hi
When you are testing your map from within BizTalk Mapper, the test is
run as the user you are currently logged in as. BizTalk, however is
running as another user (typically).
So make sure that the user running the BizTalk service has the needed
rights to access the database which the database lookup-functoid
accesses.
Jan Eliasen
On Tue, 15 Jun 2004 15:47:09 +1000, "daniel" <invalidemail> wrote:
>sorry that should be biztalk 2002 sp1.
>
>"daniel" <invalidemail> wrote in message
>news:ez5YaqpUEHA.2944@tk2msftngp13.phx.gbl...
>documents
>
--
Jan Eliasen, representing himself and not the company he works for.
| |
| daniel 2004-06-20, 11:09 pm |
| Thanks... that was the problem...
Is it normal for a database functoid to severly decrease performance?
Is there anything I can do to increase performance?
"Jan Eliasen" <spam@eliasen.dk> wrote in message
news:035tc05hq950gkmo2hcvk3fpulshkb1vll@
4ax.com...
> Hi
>
> When you are testing your map from within BizTalk Mapper, the test is
> run as the user you are currently logged in as. BizTalk, however is
> running as another user (typically).
>
> So make sure that the user running the BizTalk service has the needed
> rights to access the database which the database lookup-functoid
> accesses.
>
> Jan Eliasen
>
>
> On Tue, 15 Jun 2004 15:47:09 +1000, "daniel" <invalidemail> wrote:
>
using[vbcol=seagreen]
successully.[vbcol=seagreen]
>
> --
> Jan Eliasen, representing himself and not the company he works for.
| |
| Jan Eliasen 2004-06-20, 11:09 pm |
| Hi
Well, the only thing I can think of is that it will be faster if the
SQL Server is on the same machine as BizTalk Server.
Make sure your table has the right indexes for the query to be
performed quickly.
Other than that, I can't think of anything.
Jan Eliasen
On Wed, 16 Jun 2004 10:01:47 +1000, "daniel" <invalidemail> wrote:
>Thanks... that was the problem...
>
>Is it normal for a database functoid to severly decrease performance?
>
>Is there anything I can do to increase performance?
>
>"Jan Eliasen" <spam@eliasen.dk> wrote in message
> news:035tc05hq950gkmo2hcvk3fpulshkb1vll@
4ax.com...
>using
>successully.
>
--
Jan Eliasen, representing himself and not the company he works for.
| |
| Nick Malik 2004-06-20, 11:09 pm |
| Hi Daniel,
In Biztalk 2002, we did some timing runs to look at the use of db functoids.
In our environment, on our tests, database functoids routinely drop
performance by 90%. In other words, if you were getting 1000 records a
minute without the database functiod, you will get about 100-150 records a
minute through the mapper with the database functoid.
For some apps, this is acceptable. For others, it is not. We were in the
latter group. We did all our db lookups in AICs and updated the data
directly in the XML that was being output.
Hope this helps,
--- Nick
"daniel" <invalidemail> wrote in message
news:%23lOrrSzUEHA.1656@TK2MSFTNGP09.phx.gbl...
> Thanks... that was the problem...
>
> Is it normal for a database functoid to severly decrease performance?
>
> Is there anything I can do to increase performance?
>
> "Jan Eliasen" <spam@eliasen.dk> wrote in message
> news:035tc05hq950gkmo2hcvk3fpulshkb1vll@
4ax.com...
> using
> successully.
>
>
| |
| daniel 2004-06-26, 10:53 am |
| Thanks everyone for your suggestions.
Jan:
The index did increase performance significantly but...
Microsoft have informed me that the will no longer support the application
in question of I add the index.
I also am not able to install Biztalk on the SQL server due to Microsoft
support issues.
Nick:
Can you please expand a little on your solution? What are AICs?
Sorry I am pretty new to Biztalk...
"Nick Malik" <nickmalik@hotmail.nospam.com> wrote in message
news:LoCAc.110384$3x.93235@attbi_s54...
> Hi Daniel,
>
> In Biztalk 2002, we did some timing runs to look at the use of db
functoids.
> In our environment, on our tests, database functoids routinely drop
> performance by 90%. In other words, if you were getting 1000 records a
> minute without the database functiod, you will get about 100-150 records a
> minute through the mapper with the database functoid.
>
> For some apps, this is acceptable. For others, it is not. We were in the
> latter group. We did all our db lookups in AICs and updated the data
> directly in the XML that was being output.
>
> Hope this helps,
> --- Nick
>
> "daniel" <invalidemail> wrote in message
> news:%23lOrrSzUEHA.1656@TK2MSFTNGP09.phx.gbl...
state.[vbcol=seagreen]
>
>
| |
| Jan Eliasen 2004-06-26, 10:53 am |
| Hi
AIC's are components you write yourself. In a Messaging Port, in
Primary Transport, you can choose "APpkication Integration Component"
instead of for instance File or HTTP.
The AIC can do what you want with the document, including database
lookups or whatever.
Perhaps you should search for AICs in the documentation.
Jan Eliasen
On Tue, 22 Jun 2004 18:07:56 +1000, "daniel" <invalidemail> wrote:
>Thanks everyone for your suggestions.
>
>Jan:
>The index did increase performance significantly but...
>Microsoft have informed me that the will no longer support the application
>in question of I add the index.
>I also am not able to install Biztalk on the SQL server due to Microsoft
>support issues.
>
>Nick:
>Can you please expand a little on your solution? What are AICs?
>
>Sorry I am pretty new to Biztalk...
>
>"Nick Malik" <nickmalik@hotmail.nospam.com> wrote in message
>news:LoCAc.110384$3x.93235@attbi_s54...
>functoids.
>state.
>
--
Jan Eliasen, representing himself and not the company he works for.
| |
| daniel 2004-06-26, 10:53 am |
| Ah ok... thanks for the clarification.
Unfortunately the AICs used in our environment were developed by MS and as
such I am unable to mod them.
Just to clarify I am attempting to modify an Integration developed by MS
between Microsoft Great Plains and Microsoft CRM and I am limited in what I
can do by Microsoft Support.
"Jan Eliasen" <spam@eliasen.dk> wrote in message
news:it2gd0t6ogelnar2ber1hq2j2om8jlnstq@
4ax.com...
> Hi
>
> AIC's are components you write yourself. In a Messaging Port, in
> Primary Transport, you can choose "APpkication Integration Component"
> instead of for instance File or HTTP.
>
> The AIC can do what you want with the document, including database
> lookups or whatever.
>
> Perhaps you should search for AICs in the documentation.
>
> Jan Eliasen
>
> On Tue, 22 Jun 2004 18:07:56 +1000, "daniel" <invalidemail> wrote:
>
application[vbcol=seagreen]
records a[vbcol=seagreen]
the[vbcol=seagreen]
is[vbcol=seagreen]
needed[vbcol=seagreen]
tested[vbcol=seagreen]
the[vbcol=seagreen]
>
> --
> Jan Eliasen, representing himself and not the company he works for.
| |
| Jan Eliasen 2004-06-26, 10:53 am |
| Hi
True, you can't modify any AICs, but you can write your own instead.
In the AIC, you can do whatever you need to do, and perhaps you can do
your database-lookups faster than what can be accomplished in the map.
If the solution by MS which you are trying to modify includes AIC's
which you must use, then you can't replace them with your own AIC. In
that case, you could setup another channel, which does the map
(without database lookups), sends the document to your AIC, which does
the database lookups and sends the document to BizTalk to a channel
that will deliver the document to Microsofts AIC.
Jan Eliasen
On Wed, 23 Jun 2004 10:12:25 +1000, "daniel" <invalidemail> wrote:
>Ah ok... thanks for the clarification.
>
>Unfortunately the AICs used in our environment were developed by MS and as
>such I am unable to mod them.
>
>Just to clarify I am attempting to modify an Integration developed by MS
>between Microsoft Great Plains and Microsoft CRM and I am limited in what I
>can do by Microsoft Support.
>
>"Jan Eliasen" <spam@eliasen.dk> wrote in message
> news:it2gd0t6ogelnar2ber1hq2j2om8jlnstq@
4ax.com...
>application
>records a
>the
>is
>needed
>tested
>the
>
--
Jan Eliasen, representing himself and not the company he works for.
|
|
|
|
|