René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Reporter initialization fails with error ORA-01013: user requested cancel of current operation","articleBody":"**Describe the bug**\nRandomly we have reporter initialization that fails with error : ORA-01013: user requested cancel of current operation\nOur tests are launched using jenkins in \"Execute Windows batch command\" build steps with following syntax:\n\nAccording this other bug (fixed): https://github.com/utPLSQL/utPLSQL-cli/issues/191\nI added parameter  --ora-stuck-timeout=0 in command line but that did not fix my problem\n\n```\nset PAK_NAME=%JOB_NAME:tpkg_=pkg_%\n\n%utPLSQL_JCLI%\\utplsql run ut_test/ut_test_psw@%Database% -d --failure-exit-code=0 --ora-stuck-timeout=0 ^\n-f=ut_xunit_reporter -o=%JOB_NAME%_result.xml ^\n-f=ut_coverage_cobertura_reporter -o=%JOB_NAME%_coverage.xml ^\n-f=ut_coverage_html_reporter -o=%JOB_NAME%_coverage.html -p=ut_test.%JOB_NAME% -include=vbo.%PAK_NAME%\n```\n\nError stack is : \n```\nD:\\JenkinsData\\Workspaces\\tpkg_var_pnl_vectors\u003eV:\\Tools\\UnitTests\\Jenkins\\utPLSQL-cli\\bin\\utplsql run ut_test/ut_test_psw@VISDAY_GVA -d --failure-exit-code=0 --ora-stuck-timeout=0 -f=ut_xunit_reporter -o=tpkg_var_pnl_vectors_result.xml -f=ut_coverage_cobertura_reporter -o=tpkg_var_pnl_vectors_coverage.xml -f=ut_coverage_html_reporter -o=tpkg_var_pnl_vectors_coverage.html -p=ut_test.tpkg_var_pnl_vectors -include=vbo.pkg_var_pnl_vectors \n09:59:24.725 [main] DEBUG org.utplsql.cli.Cli - Args: run, ut_test/ut_test_psw@VISDAY_GVA, -d, --failure-exit-code=0, --ora-stuck-timeout=0, -f=ut_xunit_reporter, -o=tpkg_var_pnl_vectors_result.xml, -f=ut_coverage_cobertura_reporter, -o=tpkg_var_pnl_vectors_coverage.xml, -f=ut_coverage_html_reporter, -o=tpkg_var_pnl_vectors_coverage.html, -p=ut_test.tpkg_var_pnl_vectors, -include=vbo.pkg_var_pnl_vectors\n2025-02-06 09:59:24 [main] DEBUG org.utplsql.cli.RunAction - Java Locale not changed from LC_ALL or LANG environment variable\n2025-02-06 09:59:24 [main] INFO  org.utplsql.cli.RunAction - #################### utPLSQL cli ####################\n#                                                   #\n#   utPLSQL-cli 3.1.9.local                         #\n#   utPLSQL-java-api 3.1.9.local                    #\n#   Java-Version: 17                                #\n#   ORACLE_HOME: null                               #\n#   NLS_LANG: ENGLISH_UNITED KINGDOM.WE8MSWIN1252   #\n#                                                   #\n#   Thanks for testing!                             #\n#                                                   #\n#####################################################\n2025-02-06 09:59:24 [main] INFO  org.utplsql.cli.RunAction - \n2025-02-06 09:59:25 [main] DEBUG o.u.c.d.TestedDataSourceProvider - NLS settings: BEGIN\nEXECUTE IMMEDIATE q'[ALTER SESSION SET NLS_LANGUAGE='ENGLISH']';\nEXECUTE IMMEDIATE q'[ALTER SESSION SET NLS_TERRITORY='UNITED KINGDOM']';\nEND;\n2025-02-06 09:59:25 [main] DEBUG o.u.c.d.TestedDataSourceProvider - Try connecting jdbc:oracle:oci8:****/****@VISDAY_GVA\n2025-02-06 09:59:25 [main] DEBUG o.u.c.d.TestedDataSourceProvider - Try connecting jdbc:oracle:thin:****/****@VISDAY_GVA\n2025-02-06 09:59:27 [main] INFO  o.u.c.d.TestedDataSourceProvider - Use connection string jdbc:oracle:thin:****/****@VISDAY_GVA\n2025-02-06 09:59:28 [main] INFO  org.utplsql.cli.RunAction - Successfully connected to database. UtPLSQL core: v3.1.12.3589\n2025-02-06 09:59:28 [main] INFO  org.utplsql.cli.RunAction - Oracle-Version: 19.0.0.0.0\n2025-02-06 09:59:34 [main] DEBUG org.utplsql.api.reporter.Reporter - Database-reporter initialized, Type: UT_XUNIT_REPORTER, ID: 2D7675E51EF190DCE0640010E0E38394\njava.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation\n\n\tat oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)\n\tat oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)\n\tat oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)\n\tat oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)\n```\n\n**Provide version info**\nInformation about utPLSQL and Database version, \n```\nUT_VERSION\n------------------------------------------------------------\nv3.1.12.3589\n\nBANNER                                                                           BANNER_FULL                                                                      BANNER_LEGACY                                                                        CON_ID\n-------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production           Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production           Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production                    0\n                                                                                 Version 19.18.0.0.0                                                                                                                                               \n\nPARAMETER                      VALUE\n------------------------------ ----------------------------------------------------------------\nNLS_LANGUAGE                   AMERICAN\nNLS_TERRITORY                  AMERICA\nNLS_CURRENCY                   $\nNLS_ISO_CURRENCY               AMERICA\nNLS_NUMERIC_CHARACTERS         .,\nNLS_CALENDAR                   GREGORIAN\nNLS_DATE_FORMAT                DD-MON-RR\nNLS_DATE_LANGUAGE              AMERICAN\nNLS_SORT                       BINARY\nNLS_TIME_FORMAT                HH.MI.SSXFF AM\nNLS_TIMESTAMP_FORMAT           DD-MON-RR HH.MI.SSXFF AM\nNLS_TIME_TZ_FORMAT             HH.MI.SSXFF AM TZR\nNLS_TIMESTAMP_TZ_FORMAT        DD-MON-RR HH.MI.SSXFF AM TZR\nNLS_DUAL_CURRENCY              $\nNLS_COMP                       BINARY\nNLS_LENGTH_SEMANTICS           BYTE\nNLS_NCHAR_CONV_EXCP            FALSE\n\n17 rows selected\n\n\nPORT_STRING\n------------------------------------------------------------\nSVR4-be-64bit-8.1.0\n\n```\n\n**Information about client software**\nJenkins build step using utplsql-cli version 3.1.9\n\n\n**Expected behavior**\nInitialization of reporter should not failed\n\n**Additional case**\nCan fail on any reporter during init:\nBelow another case where HTML reporter failed.\n```\n2025-02-06 09:46:26 [main] INFO  org.utplsql.cli.RunAction - Oracle-Version: 19.0.0.0.0\n2025-02-06 09:46:27 [main] DEBUG org.utplsql.api.reporter.Reporter - Database-reporter initialized, Type: UT_XUNIT_REPORTER, ID: 2D764712AC258155E0640010E0E38394\n2025-02-06 09:46:27 [main] DEBUG org.utplsql.api.reporter.Reporter - Database-reporter initialized, Type: UT_COVERAGE_COBERTURA_REPORTER, ID: 2D764712AC298155E0640010E0E38394\n2025-02-06 09:46:28 [main] DEBUG org.utplsql.api.reporter.Reporter - Database-reporter initialized, Type: UT_COVERAGE_HTML_REPORTER, ID: 2D764712AC2D8155E0640010E0E38394\njava.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation\n\n\tat oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)\n\tat oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)\n```\n\t\n\nThanks in advance for your help.","author":{"url":"https://github.com/seg-vtl","@type":"Person","name":"seg-vtl"},"datePublished":"2025-02-06T09:38:30.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":9},"url":"https://github.com/227/utPLSQL-cli/issues/227"}