Skip to content

Empty utPLSQL windows when Show suites (hierarchical view of tests)? is unchecked #138

Closed

Description

@eriktrip

Hello
I installed the plug in in sql developer 20.4. The plugin worked fine, I tweaked some preferences and now I do not get any results anymore. Running ut.run works fine.
image

Any help is appreciated
Regard Erik

Activity

  1. eriktrip commented on Jul 12, 2021

    @eriktrip
    Author

    I tried on another device with sql developer 19.4 and there are no problems there

  2. eriktrip commented on Jul 12, 2021

    @eriktrip
    Author

    I reinstalled utplsql and the proble has gone....

  3. eriktrip commented on Jul 12, 2021

    @eriktrip
    Author

    The problem is back, on both devices.
    Any help would be appreciated

  4. PhilippSalvisberg commented on Jul 12, 2021

    @PhilippSalvisberg
    Member

    Can you try "Reset Windows to Factory Settings"?

    image

    In case the problem occurs again. Could you please provide a step-by-step description to reproduce the problem? Thanks!

  5. eriktrip commented on Jul 12, 2021

    @eriktrip
    Author

    Reset to factory settings does not solve the problem.
    I installed utplsql, played around with test_between_str, installed the plugin, generate a test package based on an existing package. Run utPLSQL test. That worked, after that I implemented some procedures and played with annotations like %disabled and %context. At some time I got this problem.

    Regards Erik
    image

  6. PhilippSalvisberg commented on Jul 12, 2021

    @PhilippSalvisberg
    Member

    Ok, the utPLSQL tab looks strange. I have currently no idea how to reproduce this.

    Could you please run the following in a SQL worksheet and provide the output?

    set serveroutput on
    -- version information
    declare
      l_version varchar2(255);
      l_compatibility varchar2(255);
    begin
      dbms_utility.db_version( l_version, l_compatibility );
      dbms_output.put_line( l_version );
      dbms_output.put_line( l_compatibility );
    end;
    /
    select substr(ut.version(),1,60) as ut_version from dual;
    select * from v$version;
    select * from nls_session_parameters;
    select substr(dbms_utility.port_string,1,60) as port_string from dual;
    -- test run
    execute ut.run;

    Furthermore, what happens when you close the utPLSQL window and run a test either from the editor or the Connections Window? Does it work? If yes, what are the excact steps to create such an empty utPLSQL window?

  7. PhilippSalvisberg commented on Jul 12, 2021

    @PhilippSalvisberg
    Member

    I found the issue. It's a bug. Please make sure that Show suites (hierarchical view of tests)? is checked in the utPLSQL preferences as shown below:

    image

    Close the utPLSQL window. Then you can start a tests run and the window should be initialized properly.

    You can switch the view within the GUI without problems.

  8. changed the title [-]Utplsql give no results[/-] [+]Empty utPLSQL windows when `Show suites (hierarchical view of tests)?` is unchecked[/+] on Jul 12, 2021
  9. added this to the v1.4.0 milestone on Jul 12, 2021
  10. eriktrip commented on Jul 13, 2021

    @eriktrip
    Author

    Thx!, that did the trick. I played around with those options.
    Regards Erik

  11. PhilippSalvisberg commented on Jul 13, 2021

    @PhilippSalvisberg
    Member

    Keep issue open until the bug is fixed in the main branch.

  12. added a commit that references this issue on Feb 26, 2022
    9409c9a
  13. added a commit that references this issue on Feb 26, 2022
    2681298
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Labels

Type

No type

Projects

No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions