system.outofmemoryException

[Rajesh Jaggumantri]

HI,

while importing a subset using Javelin --"Subset Bulk Copy XML" I get the attached error. while performing the same action with as small set of Tables it was working fine. Is this related to size of the DB extract? Can you suggest.

Details:
Saved the GT subset workflow as an XML and was trying to import using Javelin to create the flow.

Regards,
Rajesh

[Klaas-Jan Lute]

Hi Rajesh,

We encountered similar problems when there are a lot of tables. As a workaround I only use one parameter driven bulkcopy element in my workflow within a 'for each' loop. Using a query to drive the 'for each' with all table names it works like a charm. With this you don't need to use GT subset anymore. In order to support parent-child relations I created a table with all table names and relational information. Using a temporary table I can first gather the parent id's before selecting the children. With it's generic approach I can use this workflow for several systems. the only thing I need to do is update my table_selection table.

Best regards,
Klaas-Jan Lute