Skip to content

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

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
Alesator opened this issue Feb 11, 2021 · 0 comments

Comments

@Alesator
Copy link

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

@pesse pesse closed this as completed in 322a3f0 Jun 9, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant