Randomly unable to view Stored Procedures

I am not able to view the source of some of some of my stored procedures:

-- auto-generated definition
create procedure fileActivity([@_userId] int, [@_unitId] int, [@_activityType] tinyint,
[@_relativeQuantity] int, [@_relativeTotalMass] float,
[@_date] datetime2) as -- missing source code
go

I have been able to temporarily fix this, in rare cases, by manually clicking `Synchronize` on my Schemas / Database, but not always.

I have noticed this from time to time since DataGrip v. 2018.2.

Thanks!

5 comments
Comment actions Permalink

Just noticed that I can right-click the SPROC in the treeview, and select `SQL Scripts` -> `Request and Copy Original DDL` to at least get the content copied to my clipboard--this makes me able to continue work at least 👍.

0
Comment actions Permalink

What database do you use?

Does in happen on 2018.3?

 

0
Comment actions Permalink

MS SQL Server.

I am not sure, I updated to 2018.3 just a few days ago. Just now, I selected a SPROC and was unable to view the source, but once I clicked `Synchronize` it appeared, and this is not normally the case.

Ill' make an update if I run into the issue again. Thanks!

0
Comment actions Permalink

Please, check Notify when the outdated object is opened


 

0
Comment actions Permalink

Done. I'll see if that helps, thanks!

0

Please sign in to leave a comment.