Encrypted SQL objects causing issue..

[vidhyashankarkm]

If any of my SP's/Functions are created as Encrypted, while stopping it gives me error as.
(as a work around deleting encrypted objects.)

Exception calling "Stop" with "0" argument(s): "Unable to cast object of type 'System.DBNull' to type 'System.String'."
At C:\Tools\SQLCover.ps1:106 char:17

•             $coverageResults = $coverage.Stop()
  

•             ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  

Thanks
Vidhyashankar

[GoEddie]

Hi,

Thanks for reporting this, the problem is that we can't ask sql for the definition as it is purposely hidden/encrypted.

I will add a check so that it doesn't crash and fail everything so it is at least handled gracefully and any unencrypted procs are covered.

Ed

[GoEddie]

Hi - this should stop it crashing, we can't decode encrypted procs but at least any unencrypted code will be seen:

https://github.com/GoEddie/SQLCover/releases/tag/v0.4-test

[vidhyashankarkm]

Hi, still v0.4 does not solve the issue

with encrypted object still we are getting same error

Exception calling "Stop" with "0" argument(s): "Unable to cast object of type 'System.DBNull' to type 'System.String'."
At D:\SQLCC\PS\SQLCover.0.4\SQLCover.ps1:141 char:17

•             $coverageResults = $coverage.Stop()
  

•             ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  

  • CategoryInfo : NotSpecified: (:) [], MethodInvocationException
  • FullyQualifiedErrorId : InvalidCastException

[GoEddie]

Hi,

There are only two places that could cause this - I fixed one of them with that release and the other would mean you have an object in sql that doesn't have a name.

If you run:

select object_id, '[' + object_schema_name(object_id) + '].[' + object_name(object_id) + ']' as object_name, definition, uses_quoted_identifier from sys.sql_modules where object_id not in (select object_id from sys.objects where type = 'IF')

do you have a value in every object_name column?

ed

[vidhyashankarkm]

Hi Ed, thanks for the quick response, yes the above query returns my encrypted object_name.
and FYI , encrypted object is a function.
thanks
Vidhyashankar