dbeaver icon indicating copy to clipboard operation
dbeaver copied to clipboard

Cannot save changes to stored procedures through data editor

Open aespejou opened this issue 1 year ago • 0 comments

Description

When applying database filters, cannot save changes in stored procedure or functions through data editor/Source tab. Getting a script generate error: "Cannot invoke "org.jkiss.dbeaver.model.struct.DBSObject.getDataSource()" because "object" is null". Noticed that toolbar button for Active catalog/schema shows <N/A> and does not let me change it. When disabling database filters, this shows dbo@master and saving stored procedure works fine.

DBeaver Version

Community Edition v. 24.0.4.202405051837

Operating System

Windows 10 Enterprise v. 22H2 os build 19045.4291

Database and driver

DB name and version: Microsoft SQL server 2017 (RTM- CU31) (KB5016884) - 14.0.3456.2 (X64) Driver and version: MS SQL server / SQL Server Microsoft JDBC Driver for SQL Server (MSSQL) Release 12.4.1.jre11, 12.4.1.x64

Steps to reproduce

  1. Goto Edit Connection>General>Filters>Databases/Catalogs
  2. Click on Enable checkbox
  3. Add Alentpr% into Include. Need to filter all Databases that start with Alentpr.
  4. Click Ok and Ok again.
  5. Open connection to SQL server instance.
  6. Filtered database works fine.
  7. Open any database and then schemas>dbo>procedures.
  8. Right click on any stored procedure and select View procedure.
  9. Go to source tab.
  10. Make any change.
  11. Click on button on bottom right of screen called Save...
  12. Will get error message stated in description above.
  13. Noticed that toolbar button for active schema shows N/A.

To fix: 15. Disable filter from 2. 16. Steps 7 to 11 works fine by opening a new script with Alter stored procedure 17. Toolbar button from 13 shows dbo@master.

Additional context

Only have office extension installed. Using native dark theme.

aespejou avatar May 14 '24 15:05 aespejou