When trying to run tests in Katalon docker, i am getting below error
com.kms.katalon.execution.exception.ExecutionException: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not foundat com.kms.katalon.execution.console.entity.TestSuiteLauncherOptionParser.getConsoleLauncher(TestSuiteLauncherOptionParser.java:155) at com.kms.katalon.execution.console.ConsoleExecutor.execute(ConsoleExecutor.java:77) at com.kms.katalon.execution.console.ConsoleMain.launch(ConsoleMain.java:140) at com.kms.katalon.console.application.Application.runConsole(Application.java:76) at com.kms.katalon.core.application.Application.runConsole(Application.java:87) at com.kms.katalon.core.application.Application.start(Application.java:70) at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:388) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:243) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:673) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:610) at org.eclipse.equinox.launcher.Main.run(Main.java:1519) at org.eclipse.equinox.launcher.Main.main(Main.java:1492)
Command Used :
docker run -it --rm -v C:\Users\UserDirectory\git\TestFolder:/katalon/katalon/source katalonstudio/katalon katalon-execute.sh -reportFileName=“report” -statusDelay=15 -retry=0 -retryFailedTestCases=false -testSuitePath=“Test Suites/API_SuiteFile” -executionProfile=“default” -browserType=“Chrome” -sendMail="xxx@xxx.com" -apiKey=xxxxxx
Issue is happening when Katalon is using database connection[OracleDB]. If i am running any test case without database connection, it works fine properly in docker.