search

utPLSQL / utPLSQL-cli

Command line client for invoking utPLSQL
Apache License 2.0
40 stars 15 forks source link

Sonar coverage report fails with Detected Oracle driver stuck during Statement initialization #193

Closed Alesator closed 2 years ago

Alesator commented 3 years ago

Hi, when I try to run Sonar Coverage Report on cca 5k objects, utplsgl-cli fails with ERROR org.utplsql.api.TestRunner - Detected Oracle driver stuck during Statement initialization.

When I set source_path with limited number of objects it is OK.

In cmd I run >utplsql run -d tia/***@suntest07.cpoj.cz:1530/tsdv3 -test_path=PLSQL/PKG/UT -source_path=PLSQL/PKG -f=UT_COVERAGE_SONAR_REPORTER -o=sonar_coverage_report.xml

And this is part of my log: 2021-02-11 10:26:20 [main] INFO org.utplsql.cli.RunAction - 2021-02-11 10:26:25 [main] INFO o.u.c.d.TestedDataSourceProvider - Use connection string jdbc:oracle:oci8:/@suntest07.cpoj.cz:1530/tsdv3 2021-02-11 10:26:27 [main] INFO org.utplsql.cli.RunAction - Successfully connected to database. UtPLSQL core: v3.1.9.3270 2021-02-11 10:26:27 [main] INFO org.utplsql.cli.RunAction - Oracle-Version: 19.0.0.0.0 2021-02-11 10:26:32 [main] DEBUG org.utplsql.api.reporter.Reporter - Database-reporter initialized, Type: UT_COVERAGE_SONAR_REPORTER, ID: BB0D1D735F8A3BB4E05400144FFBFB04 2021-02-11 10:26:32 [main] DEBUG org.utplsql.cli.RunAction - BaseDir: c:_svn\TIA_SRC\Trunk 2021-02-11 10:26:32 [main] DEBUG org.utplsql.cli.RunAction - SourcePath: PLSQL/PKG 2021-02-11 10:26:33 [main] DEBUG org.utplsql.cli.RunAction - Getting FileMapperOptions - Files: 2021-02-11 10:26:33 [main] DEBUG org.utplsql.cli.RunAction - PLSQL\PKG\BCP\bcpc204.pkb 2021-02-11 10:26:33 [main] DEBUG org.utplsql.cli.RunAction - PLSQL\PKG\BCP\bcpc204.pks 2021-02-11 10:26:33 [main] DEBUG org.utplsql.cli.RunAction - PLSQL\PKG\BCP\BCP_ACC_CONTROLS.pkb 2021-02-11 10:26:33 [main] DEBUG org.utplsql.cli.RunAction - PLSQL\PKG\BCP\BCP_ACC_CONTROLS.pks 2021-02-11 10:26:33 [main] DEBUG org.utplsql.cli.RunAction - PLSQL\PKG\BCP\BCP_ACC_CONTROLS.~pkb 2021-02-11 10:26:33 [main] DEBUG org.utplsql.cli.RunAction - PLSQL\PKG\BCP\BCP_ACC_CONTROL_UTILS.pkb 2021-02-11 10:26:33 [main] DEBUG org.utplsql.cli.RunAction - PLSQL\PKG\BCP\BCP_ACC_CONTROL_UTILS.pks 2021-02-11 10:26:33 [main] DEBUG org.utplsql.cli.RunAction - PLSQL\PKG\BCP\BCP_ACC_CONTROL_UTILS.~pkb 2021-02-11 10:26:33 [main] DEBUG org.utplsql.cli.RunAction - PLSQL\PKG\BCP\BCP_ACC_EL_BILLS.pkb 2021-02-11 10:26:33 [main] DEBUG org.utplsql.cli.RunAction - PLSQL\PKG\BCP\BCP_ACC_EL_BILLS.pks 2021-02-11 10:26:33 [main] DEBUG org.utplsql.cli.RunAction - PLSQL\PKG\BCP\BCP_ACC_FREEZE_DATA.pkb 2021-02-11 10:26:33 [main] DEBUG org.utplsql.cli.RunAction - PLSQL\PKG\BCP\BCP_ACC_FREEZE_DATA.pks 2021-02-11 10:26:33 [main] DEBUG org.utplsql.cli.RunAction - PLSQL\PKG\BCP\bcp_acc_item_trg.pkb 2021-02-11 10:26:33 [main] DEBUG org.utplsql.cli.RunAction - PLSQL\PKG\BCP\bcp_acc_item_trg.pks 2021-02-11 10:26:33 [main] DEBUG org.utplsql.cli.RunAction - PLSQL\PKG\BCP\bcp_admin_console.pkb 2021-02-11 10:26:33 [main] DEBUG org.utplsql.cli.RunAction - PLSQL\PKG\BCP\bcp_admin_console.pks 2021-02-11 10:26:33 [main] DEBUG org.utplsql.cli.RunAction - PLSQL\PKG\BCP\bcp_agent.pkb 2021-02-11 10:26:33 [main] DEBUG org.utplsql.cli.RunAction - PLSQL\PKG\BCP\bcp_agent.pks 2021-02-11 10:26:33 [main] DEBUG org.utplsql.cli.RunAction - PLSQL\PKG\BCP\bcp_annuity.pkb 2021-02-11 10:26:33 [main] DEBUG org.utplsql.cli.RunAction - PLSQL\PKG\BCP\bcp_annuity.pks ..... ..... ..... 2021-02-11 10:26:34 [pool-1-thread-1] INFO org.utplsql.cli.RunTestRunnerTask - Running tests now. 2021-02-11 10:26:54 [pool-1-thread-1] INFO org.utplsql.cli.RunTestRunnerTask - -------------------------------------- 2021-02-11 10:26:54 [pool-1-thread-1] INFO org.utplsql.api.TestRunner - TestRunner initialized 2021-02-11 10:26:54 [pool-1-thread-1] INFO org.utplsql.api.TestRunner - Running on utPLSQL v3.1.9.3270 2021-02-11 10:26:54 [pool-1-thread-1] INFO org.utplsql.api.TestRunner - Initializing reporters 2021-02-11 10:26:54 [pool-2-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Building fileMappingArray 2021-02-11 10:26:54 [pool-2-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: PLSQL\PKG\BCP\bcpc204.pkb 2021-02-11 10:26:54 [pool-2-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: PLSQL\PKG\BCP\bcpc204.pks 2021-02-11 10:26:54 [pool-2-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: PLSQL\PKG\BCP\BCP_ACC_CONTROLS.pkb 2021-02-11 10:26:54 [pool-2-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: PLSQL\PKG\BCP\BCP_ACC_CONTROLS.pks 2021-02-11 10:26:54 [pool-2-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: PLSQL\PKG\BCP\BCP_ACC_CONTROLS.~pkb 2021-02-11 10:26:54 [pool-2-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: PLSQL\PKG\BCP\BCP_ACC_CONTROL_UTILS.pkb 2021-02-11 10:26:54 [pool-2-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: PLSQL\PKG\BCP\BCP_ACC_CONTROL_UTILS.pks 2021-02-11 10:26:54 [pool-2-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: PLSQL\PKG\BCP\BCP_ACC_CONTROL_UTILS.~pkb 2021-02-11 10:26:54 [pool-2-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: PLSQL\PKG\BCP\BCP_ACC_EL_BILLS.pkb 2021-02-11 10:26:54 [pool-2-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: PLSQL\PKG\BCP\BCP_ACC_EL_BILLS.pks 2021-02-11 10:26:54 [pool-2-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: PLSQL\PKG\BCP\BCP_ACC_FREEZE_DATA.pkb 2021-02-11 10:26:54 [pool-2-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: PLSQL\PKG\BCP\BCP_ACC_FREEZE_DATA.pks ..... ..... ..... 2021-02-11 10:27:47 [pool-5-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: PLSQL\PKG\UT\ut_prod_md.pks 2021-02-11 10:27:47 [pool-5-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: PLSQL\PKG\UT\UT_TC_CONFIG.pkb 2021-02-11 10:27:47 [pool-5-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: PLSQL\PKG\UT\UT_TC_CONFIG.pks 2021-02-11 10:27:47 [pool-5-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: PLSQL\PKG\UT\UT_TC_PARTNERADMIN.pkb 2021-02-11 10:27:47 [pool-5-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: PLSQL\PKG\UT\UT_TC_PARTNERADMIN.pks 2021-02-11 10:27:47 [pool-5-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: PLSQL\PKG\UT\UT_TC_USERRIGHT.pkb 2021-02-11 10:27:47 [pool-5-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: PLSQL\PKG\UT\UT_TC_USERRIGHT.pks 2021-02-11 10:27:47 [pool-5-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: PLSQL\PKG\UT\UT_UF_MD.pkb 2021-02-11 10:27:47 [pool-5-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: PLSQL\PKG\UT\UT_UF_MD.pks 2021-02-11 10:27:47 [pool-5-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: PLSQL\PKG\UT\UT_XLA_REFERENCE_CONSISTENCY.pkb 2021-02-11 10:27:47 [pool-5-thread-1] DEBUG o.utplsql.api.testRunner.FileMapper - Path: PLSQL\PKG\UT\UT_XLA_REFERENCE_CONSISTENCY.pks 2021-02-11 10:27:49 [pool-4-thread-1] ERROR org.utplsql.api.TestRunner - Detected Oracle driver stuck during Statement initialization

Any idea how to solve this issue?

Thanks Ales