Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Analyze index <name> compute statistics does not analyze DOMAIN index

Salazkin AnnAug 14 2020 — edited Sep 15 2020

When I try to analyze the domain index - it says Analyzed but does show the old date in Last Analyzed in TOAD

It is a valid index as shown in TOAD  (not failed or in loading)

How to make sure I analyzed the domain index...

Comments

Deepu Muraleedharan
Answer

Hi,

Create a free style jenkins job with build Execute Batch Command and use cmd way of OATS script execution.

cd C:\OracleATS\openScript

call runscript.bat " script path to jwg file "

Thanks,

Deepu M

Marked as Answer by 4eb41942-d19b-41ba-8797-60fcf091297e · Sep 10 2020

Hi ,
While running the OATS script(Batch Command mode) through Jenkins jobs . I am getting below issue

01:14:04,706 INFO  [1] Initialized script service "oracle.oats.scripting.modules.applet.api.AppletService"
01:14:04,714 INFO  [1] Initialized function library "lib.oracle.oats.scripting.ebs.EBSLibrary" for alias EBSLibrary
01:14:04,727 INFO  [1] Initialized function library "lib.ebsqafwk.WEBLABELLIB" for alias WEBLABELLIB
01:14:04,731 INFO  [1] Initialized function library "lib.ebsqafwk.WEBTABLEOBJ" for alias WEBTABLEOBJ
01:14:04,732 INFO  [1] Initialized function library "lib.ebsqafwk.GENLIB" for alias GENLIB
01:14:04,732 WARN  [JwgRepositoryService] No repository path found, using default. repository=E:\jenkins\workspace\ebsqa-folder\test\CORP_AutoScripts
01:14:04,915 INFO  [1] Initializing VU 1 for script MASTERDRIVE
01:14:07,125 WARN  [InstallerManager] FormsFT dynamic enabling finished, summary information:
1 Installed JRE(s) found: [1.8.0_261 | C:\Program Files (x86)\Java\jre1.8.0_261]
0 JRE(s) dynamic enabled
1 JRE(s) static enabled: [1.8.0_261 | C:\Program Files (x86)\Java\jre1.8.0_261]
01:16:07,133 ERROR [PlayBackHandler] oracle.oats.scripting.modules.webdom.common.api.exception.BrowserHelperException: Cannot get a connection from helper after 120 seconds.
01:16:09,295 ERROR [1] Error in section Initialize at line (script.java:33). Cannot get a connection from helper after 120 seconds.
oracle.oats.scripting.modules.browser.api.utilities.exceptions.BrowserException: Cannot get a connection from helper after 120 seconds.

Thanks in advance !!

Deepu Muraleedharan

Hi Sai,
Try restarting or reinstalling Helper Service in your node machine
Thanks,
Deepu M

Hi Deepu,
Thanks a lot !!
I have try by restarting or re -installing the Helper Service in my machine
Step follow to restart the helper service
-> Navigate to here C:\OracleATS\helperService\bin and Started the RunHelperService.bat( Admin)
Step follow to re -installing the helper service
-> Navigate to here C:\OracleATS\helperService\bin and uninstalled the helperServices a, after that I installed the helperServices again and started the HelperServices
After that I have trigger the Jenkins Job , But Still I am getting the Same issue

  [PlayBackHandler] oracle.oats.scripting.modules.webdom.common.api.exception.BrowserHelperException: Cannot get a connection from helper after 120 seconds.
Error in section Initialize at line (script.java:33). Cannot get a connection from helper after 120 seconds.
oracle.oats.scripting.modules.browser.api.utilities.exceptions.BrowserException: Cannot get a connection from helper after 120 seconds

Please guide me here , Thanks in advance!!

Regards,
Sai swaroop.

Deepu Muraleedharan

Are you able to run script from Openscript in same machine
Thanks, DeepuM

Yes , I am able to run script from my machine .
Regards,
Sai Swaroop.

Deepu Muraleedharan

Stop jenkins service and run slave-agent.jnlp as administrator in node machine
Thanks,
DeepuM

Dilipkumar447

Hi,
I am trying to run OATS script from Jenkins.
The script is running successfully but the runScript.bat file is returning a non-zero return code due to which the Jenkins job is failing.
Any idea why the batch file is returning a non-zero return code(in my case its 1) even when the script is successfully executed?

roshanunair@gmail.com

Hi,
The best way to address your concern is to create a free-style Jenkins job with build Execute Batch Command and use cmd way of OATS script execution.
cd C:\OracleATS\openScript
call runscript.bat " script path to jwg file ".
Also, FYI if you are considering superfast app development, as you might know, do consider test-driven development and it will be very beneficial for you and your team.
Regards,
Roshan

Rogy Enrique

I second it that you can try to build Execute Command. Try it https://elgraficochile.cl/casino/leovegas .

1 - 10

Post Details

Added on Aug 14 2020
6 comments
596 views