i have a JDBC-BPM-PROXY scenario, ?????performance issues

[Former Member]

i have a JDBC-BPM-PROXY scenario,

about 33 MB of record is being fetched form the JDBC channel, and there is a transformation(message mapping in it),

when the scenario runs, the message mapping takes hell lot of time......?

is there any solution????????

[Former Member]

bhavesh..thanks as usual....

but its like testing time now...i cant change anything in the development.....

and now its giving error like "System failure" during JCO call

[Former Member]

hi bhavesh...now its like "System failure" during JCO call

....

and can i do something without making change in the development

[bhavesh_kantilal]

Sudheep,

1. Do as pointed by Michal. Move the transformation outside the BPM to the interface determiantion.

This isssue is due to the fact that your Java Heap must be overflowing due to the huge payload.!

Regards

Bhavesh

[Former Member]

bhavesh...i want to tell this java heap overflow to the basis guy.....can u give me the technical terminologies which i must use to explain this problem

[MichalKrawczyk]

Hi,

>>>> and there is a transformation(message mapping in it),

this is very bad - remove it from a BPM

put your mapping in interface determination and not in transformaiton step in a BPM

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>

[bhavesh_kantilal]

33 Mb is a lot of data.

Why dont you select data in chunks in the sender JDBC adapter.

Use the max rows in the SQL query to restrict the number of rows selected in one shot. A SQL expert can give exact way to achieve this,.

Regards

Bhavesh