Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
XDODTEXE - Concurrent request is slow

Summary
XDODTEXE - Concurrent request is slow
Content
Hi,
I have a concurrent program using XDODTEXE to process one of the data templates. It worked just fine but is slow to start processing the template. (around 14 minutes) . After this the concurrent is fast.
Extract from the log...
Please note that the Current system time is 02-MAR-2018 11:35:10, the data template is processed at 11:49:11 and the concurrent is completed at 11:49:12
+---------------------------------------------------------------------------+
xxbol custom app: Version : 12.2
Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
TS_FAH_REP_OPE_EMP_CUE: FAH Reporte a Nivel de Cuenta
+---------------------------------------------------------------------------+
Current system time is 02-MAR-2018 11:35:10
+---------------------------------------------------------------------------+
XDO Data Engine Version No: 10.1.3.4.2
Resp: 50744
Org ID : 1991
Request ID: 506120
All Parameters: pn_libro4=2022:pv_fecha_cont4="2017/07/27 00:00:00":pv_empresa4=:pv_cuenta4=:pv_divisa4=:pv_dif4=:pn_dif_mayor_igual4=:DebugFlag=Y
Data Template Code: TS_FAH_REP_OPE_EMP_CUE
Data Template Application Short Name: XXBOL
Debug Flag: Y
{pv_divisa4=, pv_fecha_cont4=2017/07/27 00:00:00, pv_cuenta4=, pv_dif4=, pv_empresa4=, pn_dif_mayor_igual4=, pn_libro4=2022}
Calling XDO Data Engine...
[030218_114911640][][STATEMENT] oracle.jdbc.driver.OracleBlobInputStream@29d42a8f
[030218_114911706][][STATEMENT] Logger.init(): *** DEBUG MODE IS ON. ***
[030218_114911709][][STATEMENT] Logger.init(): LogDir=/APP/oracle/OCMXEOCP/fs2/EBSapps/appl/xdo/12.0.0/temp
[030218_114911712][][STATEMENT] DataTemplate.getTmpDir(): system-temp-dir property value from DATABASE: /APP/oracle/tmp
[030218_114911714][][STATEMENT] Template parsing started...
[030218_114911722][][STATEMENT] Data Template ......
[030218_114911722][][STATEMENT] oracle.xml.parser.v2.XMLDocument@64d27151
.
.
.
[030218_114911763][][STATEMENT] Inside parameterParser...
[030218_114912070][][STATEMENT] Executing data triggers...
[030218_114912070][][EVENT] Data Generation Completed...
[030218_114912070][][EVENT] Total Data Generation Time 0.0 seconds
+---------------------------------------------------------------------------+
Executing request completion options...
Output file size:
25634
+--------- 1) POST-PROCESSING ---------+
Beginning post-processing of request 506120 on node SRCOCTLM1MXR311 at 02-MAR-2018 11:49:12.
-- Publishing output
Post-processing of request 506120 completed at 02-MAR-2018 11:49:12.
CONC-POST-PROCESSING RESULTS
-- PUBLISH:
CONC-OPP-XMLPUB SUCCESS
+---------------------------------------+
Finished executing request completion options.
+---------------------------------------------------------------------------+
Concurrent request completed successfully
Current system time is 02-MAR-2018 11:49:12
+---------------------------------------------------------------------------+
Thanks for your help
Answers
-
http://knoworacleappsdba.blogspot.com/2012/07/all-about-output-post-processor-opp-in.html
Refer above link
1. Change the output to xml and rerun the job and see how much time it took to complete.
2. If the program completes faster then you need to relook at the template design.
3. How is the runtime for other concurrent requests using xdodtexe.?
0 -
Hello,
Is this with an RTF template ? if so can u run the template with the same set of data in the local machine and check how long is it taking ?
What is the data volume that you are trying to push via the report ?
0