GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Sign in
  • ActionsCI/CD and automation
  • CodespacesCloud development environments
  • All Features
  • Documentation
  • Training
  • Certifications
  • Build with Copilot
  • Customize Copilot
  • Integrations
  • Trending repos
  • GitHub Sponsors
  • Developer articles
  • Enterprises

This view

  • Original page
  • New address

GeezerVison is showing github.com — ut_teamcity_reporter() doesn't show top-level error when test failed · Issue #1109 · utPLSQL/utPLSQL

ut_teamcity_reporter() doesn't show top-level error when test failed #1109

New issue
Copy link
New issue
Copy link
Closed
Closed
ut_teamcity_reporter() doesn't show top-level error when test failed#1109
Copy link
Assignees
jgebal
Labels
bug

Description

@alesana-san
alesana-san
opened on Nov 18, 2020
Issue body actions

Describe the bug
ut_teamcity_reporter() doesn't show top-level error code and message when error occurs inside of test (not to be confused with failed assertion)

Provide version info

11.2.0.4.0
11.2.0.4.0

PL/SQL procedure successfully completed.


UT_VERSION
------------------------------------------------------------
v3.1.9.3268


BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE    11.2.0.4.0      Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production


PARAMETER                      VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE                   AMERICAN
NLS_TERRITORY                  AMERICA
NLS_CURRENCY                   $
NLS_ISO_CURRENCY               AMERICA
NLS_NUMERIC_CHARACTERS         .,
NLS_CALENDAR                   GREGORIAN
NLS_DATE_FORMAT                DD-MON-RR
NLS_DATE_LANGUAGE              AMERICAN
NLS_SORT                       BINARY
NLS_TIME_FORMAT                HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT           DD-MON-RR HH.MI.SSXFF AM

PARAMETER                      VALUE
------------------------------ ----------------------------------------
NLS_TIME_TZ_FORMAT             HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT        DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY              $
NLS_COMP                       BINARY
NLS_LENGTH_SEMANTICS           BYTE
NLS_NCHAR_CONV_EXCP            FALSE

17 rows selected.


PORT_STRING
------------------------------------------------------------
x86_64/Linux 2.4.xx

Information about client software
JetBrains DataGrip

To Reproduce
Steps to reproduce the behavior:

  1. Create test package from archive test.zip
  2. Try running it with ut_teamcity_reporter()
select * from table(ut.RUN('test',ut_teamcity_reporter()));
  1. The output will be similar to this one:
##teamcity[testSuiteStarted timestamp='2020-11-18T12:24:34.326+0000' name='test']
##teamcity[testSuiteStarted timestamp='2020-11-18T12:24:34.327+0000' name='Test']
##teamcity[testStarted timestamp='2020-11-18T12:24:34.328+0000' captureStandardOutput='true' name='stat_int_tests.test.test']
"##teamcity[testStdErr timestamp='2020-11-18T12:24:34.330+0000' name='stat_int_tests.test.test' out='Test exception:|nORA-06512: at ""STAT_INT_TESTS.TEST"", line 7|nORA-06512: at line 6|n|n']"
"##teamcity[testFailed timestamp='2020-11-18T12:24:34.330+0000' details='Test exception:|nORA-06512: at ""STAT_INT_TESTS.TEST"", line 7|nORA-06512: at line 6|n|n' message='Error occured' name='stat_int_tests.test.test']"
##teamcity[testFinished timestamp='2020-11-18T12:24:34.331+0000' duration='1' name='stat_int_tests.test.test']
##teamcity[testSuiteFinished timestamp='2020-11-18T12:24:34.331+0000' name='Test']
##teamcity[testSuiteFinished timestamp='2020-11-18T12:24:34.332+0000' name='test']

Expected behavior
We see error message no data found on top of error stack. Instead the first one is ORA-06512: at ""STAT_INT_TESTS.TEST""
When running with default reporter there is no issue.

Additional context
Screenshots from DataGrip IDE can be found in test.zip

Activity

  1. pesse
    added
    reporter
    on Nov 18, 2020
  2. jgebal
    removed
    reporter
    on Feb 22, 2022
  3. jgebal
    added
    bug
    on May 9, 2026
  4. jgebal
    self-assigned this
    on Jun 8, 2026
  5. jgebal commented on Jun 8, 2026

    @jgebal
    jgebal
    on Jun 8, 2026
    Member
    More actions

    I have verified the reported issue.
    The problem does not show up in utPLSQL v.3.2.2 (latest release tested).

    create or replace package test is
    
      --%suite(Test)
      --%suitepath(test)
    
      --%test(Some dummy test)
      procedure test;
    
    end test;
    /
    create or replace package body test is
    
      procedure test
      is
          l_check number;
      begin
          ut.expect(1).to_equal(0);
          select 1 into l_check from dual where 1=0;
          ut.EXPECT(l_check).TO_EQUAL(1);
      end;
    
    end test;
    /
    
    begin
        ut.run('test');
    end;
    /

    Gives:

    test
      Test
        Some dummy test [,163 sec] (FAILED - 1)
    
    Failures:
    
      1) test
          ORA-01403: no data found
          ORA-06512: at "UT3_TESTER.TEST", line 8
          ORA-06512: at "UT3_TESTER.TEST", line 8
          ORA-06512: at line 6
          Actual: 1 (number) was expected to equal: 0 (number)
          at "UT3_TESTER.TEST.TEST", line 7 ut.expect(1).to_equal(0);
    
    Finished in ,165432 seconds
    1 tests, 0 failed, 1 errored, 0 disabled, 0 warning(s)
    
    

    When running with treamcity reporter:

    begin
        ut.run('test');
    end;
    /

    You see:

    [2026-06-08 13:53:24] completed in 173 ms
    ##teamcity[testSuiteStarted timestamp='2026-06-08T10:53:24.010+0000' name='test']
    ##teamcity[testSuiteStarted timestamp='2026-06-08T10:53:24.011+0000' name='Test']
    ##teamcity[testStarted timestamp='2026-06-08T10:53:24.011+0000' captureStandardOutput='true' name='ut3_tester.test.test']
    ##teamcity[testStdErr timestamp='2026-06-08T10:53:24.019+0000' name='ut3_tester.test.test' out='Test exception:|nORA-01403: no data found|nORA-06512: at "UT3_TESTER.TEST", line 8|nORA-06512: at "UT3_TESTER.TEST", line 8|nORA-06512: at line 6|n']
    ##teamcity[testFailed timestamp='2026-06-08T10:53:24.019+0000' details='Test exception:|nORA-01403: no data found|nORA-06512: at "UT3_TESTER.TEST", line 8|nORA-06512: at "UT3_TESTER.TEST", line 8|nORA-06512: at line 6|n' message='Error occured' name='ut3_tester.test.test']
    ##teamcity[testFailed timestamp='2026-06-08T10:53:24.019+0000' details='Actual: 1 (number) was expected to equal: 0 (number)' name='ut3_tester.test.test']
    ##teamcity[testFinished timestamp='2026-06-08T10:53:24.019+0000' duration='7' name='ut3_tester.test.test']
    ##teamcity[testSuiteFinished timestamp='2026-06-08T10:53:24.020+0000' name='Test']
    ##teamcity[testSuiteFinished timestamp='2026-06-08T10:53:24.021+0000' name='test']
    
    

    Calling the test from DataGrip 2025.3.4 shows what you can see below.
    Both the runtime exception and failed expectations are displayed.
    Image

    Looking at commit history for the file it shows that it was fixed by this Pull request: #1251

  6. jgebal
    closed this as completedon Jun 8, 2026
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

  • @jgebal
    jgebal

Labels

bug

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

    You are visitor 01402503 — GeezerVison does not store the pages you look up.
    Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.