utPLSQL / utPLSQL-SQLDeveloper

Extension for running unit tests straight from SQL Developer
Apache License 2.0
63 stars 17 forks source link

'Run utPLSQL test' on the test package doesn't display the utPLSQL window. #159

Closed sreedeepthi1211 closed 2 years ago

sreedeepthi1211 commented 2 years ago

Apologies, I don't believe this is a bug but couldn't find any other appropriate type for my issue.

Describe the bug I installed utPLSQL plugin for SQLDeveloper and created a test package which contains all my tests. When I try to right-click on the package body under Connections->Packages->test_pkg->test_pkg_body, and click on 'Run utPLSQL test', a new window used to open next to 'Connections' tab and all the tests' progress would show. But suddenly, I lost it. If I use ut.run() for my test package, the tests output will show in the 'Script Result' but in the text format. I tried re-installing the plugin a bunch of times but it didn't resolve the issue.

Provide version info Information about utPLSQL and Database version,

set serveroutput on
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;
/

Output: l_version - 19.0.0.0.0 l_compatibility - 19.0.0

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;

Output: x86_64/Linux 2.4.xx

Information about client software What client was used to run utPLSQL tests? Was it from TOAD, SQLDeveloper, SQLPlus, PLSQL Developer etc... Answer: SQLDeveloper.

To Reproduce Steps to reproduce the behavior:

  1. Go to 'Connections->Packages->test_pkg->test_pkg_body'
  2. Right-Click on 'test_pkg_body' and choose 'Run utPLSQL test'
  3. Nothing happens and 'utPLSQL' tab doesn't show up next to 'Connections' tab.

Expected behavior I expected for 'utPLSQL' tab to be displayed where progress for all the tests will be displayed.

Example code N/A

Additional context I used utplsql_for_SQLDev_1.4.1.zip file for installing the plugin.

Appreciate any help. Thank you.

PhilippSalvisberg commented 2 years ago

This sounds like a duplicate of #139.

Please run Reset Windows To Factory Settings from the Windows menu like in this screen shot:

image

It resets all windows (their positions and their visibility such as Reports Connections, Snippets, Files, Code Outline, Log etc.) to factory settings. So, it is not so bad, since the important settings like Connections are kept as is.

sreedeepthi1211 commented 2 years ago

That worked like a charm. Thank you.