Skip to content

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

@alesana-san

Description

@alesana-san

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions