OPP requests

[satish]

Dear Erman,

could you please give me some idea about the below entry in Output post processor logs.
The reason to this question was while irequest was on below step,the backend session was inactive for long time and later the request was processed

Calling XDO Data Engine...

1)will this dont require any database connection?what exactly it will do behind the scenes.

Thanks for the support

[ErmanArslansOracleBlog]

XDO data engine is a java package. So it is a java code.
So, in brief, OPP is calling a java at that stage.

It may be related with 2 thing.

1)java heap settings.
2)query performance of the related db session.

so increase heap size for OPP and reproduce the issue. (ref: Create Accounting Issue: Process Gets Stuck At "Calling XDO Data Engine..." (Doc ID 1151993.1))

If the issue persists, check db sessions accordingly.  (check the db sessions just after you see "calling xdo data engine" in OPP logs.

[satish]

Thanks erman for valid inputs.

Heap memory Current size is 2048MB.However after some time,the backend session progressed and completed.the output file generated was around 700MB

[satish]

In this case,will this be query performance issue?The output file size was 700MB and the xls generated was 1GB

[ErmanArslansOracleBlog]

1GB sized xml output is actually a big one.
700 MB output? What is that?  You already said xml output is 1GB, so what is that 700 MB output you are talking about?

Anyways, maybe that's the case..

Ask your developers -> is it ok to produce 1 gb output? Is it necessary? Can't we split this work? (I mean producing only the necessary output..)

[satish]

Dear Erman,

Thanks for the update.I mean output file is first generated o4847599.out which is arounf 700MB and then xls was generated XXTTD_GL_TXNWISE_RPT_4847599_1.xls which is 1GB

[ErmanArslansOracleBlog]

Thay may be okay..

Again,

1GB and 700 MB sized outputs are big.

This seems to be case of that long run.

Ask your developers -> is it ok to produce 1 gb output? Is it necessary? Can't we split this work? (I mean producing only the necessary output..)