When running EVS to test my module package, I'm getting this error:

ExtensionMessageID: 991102

ExtensionID: 92166

MessageTypeID: 1

MessageID: 297ccdd3-884f-4cbb-85f0-24c343a9ff2a

Message: While testing against 07.04.00 It appears the extension has created a database object: TestQualifier_VW_Interzoic_LMS_Session with the following error: Could not find object '[TestSchema].[TestQualifier_VW_Interzoic_LMS_Session]' or you do not have permission.

Rule: PackageVerification.Rules.SQLTestRunner

As you can see is the same object, the one that cannot be found, is the one that I'm creating. I installed this without any problems in SQL Server 2008, and SQL Server 2014, and also in Azure Database.  Here is the Create View sentence:

CREATE VIEW {databaseOwner}{objectQualifier}VW_Interzoic_LMS_Session WITH SCHEMABINDING AS 

SELECT [SessionId]

      ,[PortalId]

      ,[ModuleId]

      ,[ILT]

      ,[Name]

      ,[LocationId]

      ,[InstructorId]

      ,[StartDate]

      ,[EndDate]

      ,[TimeZone]

      ,[RecurrenceRule]

      ,[SendInstructorSelectionNotification]

      ,[SendInstructorUpdateNotification]

      ,[SendLearnerNotification]

      ,[SendCalendarInvite]

      ,[Description]

      ,[MinClassSize]

      ,[MaxClassSize]

      ,[ShowRosterToLearner]

      ,[Tags]

      ,[CreateDate]

      ,[CreatedByUser]

      ,[UpdatedDate]

      ,[UpdatedByUser]

      ,[CalculatedEndDate]

      ,[EnableWaitlist]

      ,[AutofillWaitlist]

      ,[CalendarInviteBody]

      ,[WebinarURL]

      ,[AttendedOnAttempt]

      ,[UtilizationTracking]

      ,[GTWWebinarKey]

      ,[CalendarReminder]

      ,[UseLearnerTimezone]

 ,(select count(SessionSelectionId) from {databaseOwner}{objectQualifier}Interzoic_LMS_SessionSelection S5 where S5.SessionId = S.SessionId AND s5.Status = 1 and exists (select top 1 value from {databaseOwner}{objectQualifier}Interzoic_LMS_SessionIsEnrrolled(S.SessionId,S5.UserId,S.ILT))) as SessionCurrentLearners

 ,(Case When S.EnableWaitlist=1 Then

(select count(SessionSelectionId) from {databaseOwner}{objectQualifier}Interzoic_LMS_SessionSelection S6 where S6.SessionId = S.SessionId and s6.Status = 2 and  exists (select top 1 value from {databaseOwner}{objectQualifier}Interzoic_LMS_SessionIsEnrrolled(S.SessionId,S6.UserId,S.ILT))) 

Else

0

End) as SessionWaitlistedCount

FROM {databaseOwner}{objectQualifier}Interzoic_LMS_ILTSession S

GO

So, the only thing a little "strange" is the schemabinding, but it is correct, what could be causing this issue? some of our clients run in DNN Cloud, so, I really need my extensions to pass this test.

Thanks

Javier

A: yes I did it, and then it reports 0 errors.

Q: What benefit do you expect from it?

A: The view with schemabinding has a performance improvement when querying, of course it adds an overhead when updating related records, but we already tested, and this is the way  we need it, and, I don't see any reason for reporting this as an error in EVS.

So, this looks like an error in EVS, how I report this problem?

Thanks

Javier

Hi Sebastian,

interesting that you get a Performance improvement just from schemabinding, usually you Need to index the view as well.

I'm not a SQL expert, but from my understanding, what schemabinding does it to create a physical table to store the view, then you could create an index, but because the query that generates this view takes a lot of time to execute, it makes sense to me that we are experiencing this performance improvement. Also, we tested this, and yes, it runs much faster with the schemabinding.

Please Report the bug in the public issue tracker at http://support.dnnsoftware.com.

I did not found a way to report something about EVS, just platform. I reported the problem anyway there.

Thanks for you time.