Earlier this year, I set up a DV that allowed me to search for and then display a list of user by LastName. Clicking on the Detail View link then showed specific details for that user. I then created a button that passed the users's ID to a second page with a DV module that listed the events that user attended. Clicking on the Detail Link for an event, then showed specific details about that user's event, such as the days they attended and under what capacity.

All of this worked perfectly until recently. I just started getting page load and general exceptions when clicking on the Detail View for the events, and the detail page would not load.  I saw a different post with this issue and the suggested fix was to upgrade to DV 3.0. This indeed fixed the page load problem (no more page faults or general exceptions.)

The problem is that the events details page loads, however instead of displaying the values for the event, I am only shown the module tokens. Keep in mind that the Details Link for the first DV listing users works just fine. I am still able to pass the user ID value to the second DV just fine as it shows a list of events that at user has attended correctly. No matter what I try though, I can't get the details page to load the values instead of just displaying the tokens.

I added debug and here is the error message:

Error2a:There is no row at position 0. at System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex) at System.Data.DataRowCollection.get_Item(Int32 index) at DataSprings.DNN.Modules.DynamicViews.DynamicViews.ProcessDetailedView()

I also added the [ViewDetailLinkURL] to the page to verify that the url was being generated correctly.

I also double checked my Custom SQL Query to verify that it was generating the correct fields.

Any Ideas?  I am really banging my head against a wall on this one.
3.0.10.24377 / 6.2.3

Steve

Problem Solved!

Based on the error message above it appeared that the custom SQL command was being run against an empty record set, but I couldn't figure out why. The page was working correctly in DV 2.20.10, but upgrading to DV 3.0.10 broke this.

After restoring the portal to the previous version several times, I noticed that in DV 2, under the General section of the module configuration page, there was not a setting for "Data Cache Time (Minutes), but in DV 3 there was. This made me think that in DV 2 the default was to cache the data, but that this was changed in DV 3. Setting a value for the cache time fixed the problem.

All other instance of the DV module were working correctly upon updating to DV 3. Not sure why data cache time needs to be set on certain instances of the DV module, but not on others.  Maybe the folks DataSprings can shed some light on this new feature, as the on-line manual for DV is still for version 2.1.

UPDATE:

Problem only partially solved.  After testing the site a little more, I discovered that the cached data is not being released.  If I pull up UserA and drill down to their event details, then do a search on UserB, when I drill down to view UserB's event details, it is showing me UserA's event details.

I have set Data Cache Time (Minutes) to 1, however even waiting 2 minutes between searches for users, UserA's cached data is still being stored and displayed for UserB.  Only using the Admin - Tools menu option "Clear Cache" fixes this.

Reading another post http://www.datasprings.com/dnn-modu...sults-more Ryan states that DV v3 fixes the caching issue so that placing ClearCache=True in the URL is no longer needed.  That may be so if cache time is set to 0, but in my case using a cache time now requires me to use ClearCache.

Personally I like the way cache was handeled in v2.1, as I never had to use ClearCache in my URL on simple or complex Data Views.

Setting Data Cache Time to 0 minutes, fixes the caching issue, but the details page only displays token names, and not the values as discussed in the first post of this thread.

A point of clarification.  The DV pages work as expected when it is a stand alone report for all of my DV pages. The problem is only arising when I use a second DV page to expand upon a report. as outlined below

1) Report 1 search for users by Last Name.
2) Detail Link for the user shows the user details as expected.
3) A button is placed in the detail template that passes the [userid] via $(DSParam1) to a new page which contains Report 2 on it and displays events that the user has attended. [eventID] is being used as the default value for details
4) Report 2 Detail Link should show specifics about the user for the selected event.
 a) Report 2 Cache Time 0 = token names not values are displayed
 b) Report 2 Cache Time 1 = correct values, but cache is not being cleared.

I hope that helps to clarify the situation that I am having.  As mentioned above this was working perfectly in DV 2.1
   

I finally got this working again. 

I just couldn't shake the feeling that the module was no longer caching the UserId in the form of the DSParam1 parameter after the second DV list loaded, or that it was not passing the parameter to the detail view.

So I tried an experiment, I took the url that is generated by the [ViewDetailLinkURL] token and added ?DSParam1=[userid] to the end, and bingo, the details page now displays without errors.