XDODTEXE - Concurrent request is slow — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

XDODTEXE - Concurrent request is slow

Received Response
71
Views
2
Comments

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