Products

Solutions

Learn More

Partners

Community

Blog

About

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDevelopment and...Development and...Building ExtensionsBuilding ExtensionsExtension Verif...Extension Verif...Problems creating view with schemabindingProblems creating view with schemabinding
Previous
 
Next
New Post
7/13/2016 3:13 PM
 

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




Javier Rodríguez
CTO
www.AccordLMS.com
1775 W. State Street Suite 371, Boise ID 83702 USA
 
 
New Post
7/13/2016 5:25 PM
 
Javier,
did you try to remove the schemabinding clause?
What benefit do you expect from it?

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
7/29/2016 4:50 PM
 
Hi Sebastian, 

Q: did you try to remove the schemabinding clause? 

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




Javier Rodríguez
CTO
www.AccordLMS.com
1775 W. State Street Suite 371, Boise ID 83702 USA
 
 
New Post
7/30/2016 6:03 AM
 
Javier,
interesting that you get a Performance improvement just from schemabinding, usually you Need to index the view as well.
Please Report the bug in the public issue tracker at http://support.dnnsoftware.com.

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
8/3/2016 2:38 PM
 

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.




Javier Rodríguez
CTO
www.AccordLMS.com
1775 W. State Street Suite 371, Boise ID 83702 USA
 
 
Previous
 
Next
HomeHomeDevelopment and...Development and...Building ExtensionsBuilding ExtensionsExtension Verif...Extension Verif...Problems creating view with schemabindingProblems creating view with schemabinding


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.

Content Layout

Subscribe to DNN Digest

Subscribe to DNN Digest

DNN Digest is our monthly email newsletter. It highlights news and content from around the DNN ecosystem, such as new modules and themes, messages from leadership, blog posts and notable tweets. Keep your finger on the pulse of the ecosystem by subscribing.  

What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out