RE: determing message counts without using XPATH

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi Selvan,

I run into an "out of memory" issue if I have use xpath to first get the
count within the orchestration as it is trying to load a large document
within the memory. I want to avoid this. So I tried to split the message at
the receive location but then I loose my ability to count the number of
records before I do the data entry. I would like to implement the custom
pipeline component as a last resort. What would be the best practise to
fulfill the need to log the total number of records/messages that will be
processed before entering each record within the database.

Thanks,

"Selvan" wrote:

RP,
I understand that you are using Orchestration inturn calls SendPort to
push your messages in to database. If that is the case use similar statement
in your expression editor

xpath(Message_FF_Activities,"count(/*[local-name()='Customers' and
namespace-uri()='http://Bank.Activities1.0.0.0']/*[local-name()='Customer'
and namespace-uri()='http://Bank.Activities1.0.0.0'])")

Message_FF_Activities is my input message and "Customer' is our repeating
element/record that i am trying to count.

If you are not using orchestration you would need to write a custom pipeline
and place similar code in it.

Please let the community know if you have any issues.

Regards
Selvan.


"rp" wrote:

I am using envelope to split an incoming large flat file data into manageable
xml messages(splitting the message at the receive port) which then gets
entered into a database.

Well, my question is that that before I do the database entry I would like
to log how many records(messages) will be processed. How can I tackle this
situation without using XPATH?

Thanks,

RP
.

Relevant Pages

  • RE: determing message counts without using XPATH
    ... I run into an "out of memory" issue if I have use xpath to first get the ... processed before entering each record within the database. ... I understand that you are using Orchestration inturn calls SendPort to ...
    (microsoft.public.biztalk.general)
  • Re: Transactional Adapter and Orchestration
    ... loss of the database connection during orchestration processing is my ... Since I have no way to revert the database field value ... back to the original value because I've lost the database connection, ... Microsoft Online Community Support ...
    (microsoft.public.biztalk.general)
  • RE: BizTalk 2004 Event View Error BAM EventBus Service
    ... My question is are still seeing the Event bus warning/error? ... the orchestration, I haven't been able to delete the assembly. ... BAMPrimaryImport database and the BiztalkDta database. ... Mubarak Elamin, BPI Business User Services ...
    (microsoft.public.biztalk.general)
  • RE: System.OutOfMemoryException was thrown
    ... You are calling a stored procedure from an orchestration via the sql ... location using the Sql Adapter that will poll the database, ... Additional error information: ... Exception type: PersistenceItemException ...
    (microsoft.public.biztalk.general)
  • RE: determing message counts without using XPATH
    ... I think XMLdoc usage outside the ... handle it better outside the orchestration. ... processed before entering each record within the database. ... If you are not using orchestration you would need to write a custom pipeline ...
    (microsoft.public.biztalk.general)