E1: UBE: UBE Running Slow In One Environment
(Doc ID 2376346.1)
Last updated on MARCH 20, 2018
Applies to:JD Edwards EnterpriseOne Tools - Version 9.1 and later
Information in this document applies to any platform.
Specific UBE running slow in production environment for all Versions and the same UBE and version works fine in the test environment.
Per the JDEDEbug the bottle neck is at specific Select Statement. This step take 5 seconds in Test and more that 4 minutes in Production.
Mar 09 16:10:49.119001 - 9536/8560 SELECT T0.GLKCO, T0.GLDCT, T0.GLDOC, T0.GLDGJ, T0.GLJELN, T0.GLEXTL, T0.GLPOST, T0.GLICU, T0.GLICUT, T0.GLDICJ, T0.GLCO, T0.GLANI, T0.GLAID, T0.GLMCU, T0.GLOBJ, T0.GLSUB, T0.GLSBL, T0.GLSBLT, T0.GLLT, T0.GLPN, T0.GLCTRY, T0.GLFY, T0.GLAA, T0.GLU, T0.GLUM, T0.GLRE, T0.GLEXA, T0.GLEXR, T0.GLR1, T0.GLAN8, T0.GLCN, T0.GLDKJ, T0.GLASID, T0.GLBRE, T0.GLVINV, T0.GLIVD, T0.GLPO, T0.GLPSFX, T0.GLDCTO, T0.GLLNID, T0.GLUSER, T0.GLPID, T0.GLJOBN, T0.GLUPMJ, T0.GLUPMT, T1.GMAID, T1.GMDL01, T2.MCMCU, T2.MCRP12 FROM JDE_PRODUCTION.PRODDTA.F0911 T0 WITH (NOLOCK) ,JDE_PRODUCTION.PRODDTA.F0901 T1 WITH (NOLOCK) ,JDE_PRODUCTION.PRODDTA.F0006 T2 WITH (NOLOCK) WHERE ( ( T0.GLOBJ BETWEEN '6300' AND '8250' AND T0.GLMCU IN ( ' 5025',' 5030' ) ) AND ( T0.GLPN = 1.000000 AND T0.GLFY = 17.000000 AND T0.GLLT = 'AA' ) ) AND ( T0.GLAID = T1.GMAID AND T0.GLMCU = T2.MCMCU ) ORDER BY T0.GLCO ASC,T1.GMDL01 ASC,T0.GLMCU ASC,T0.GLDGJ ASC
The same SQL query takes similar time to return the results even running directly in DB using SQL.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!