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
