We have a problem with a view that worked fine for several years, until we installed the last fix pack on our servers, Release 8.5.3FP1HF847. We're running AIX 1.6.
The issue is with the primary view in a financial application, which cascades documents in the following order:
The selection formula for the view is "SELECT FORM = "Year" | @AllDescendants". This worked fine until this year, when suddenly some of the child documents under the Division level were not showing up. If you create a private copy of the view, it works fine.
At first we thought it was a corrupt view, so we ran FIXUP and UPDALL, which didn't help. The Refresh setting for the view was already set to "Automatic", so we changed the index Discard setting to "After each use", which helped, but slowed down the view a lot. We then recreated the view and updated the design, which solved it for a few weeks. When it reoccurred, we thought maybe it had to do with the server being busy, because sometimes it seemed to fix itself after a while. However, now we've had the problem on the same database for a couple of weeks, and since we have a freeze on updates, it's stayed that way.
I'm wondering if other people have run into this, and if you have any suggestions. I found one other mention of this problem on Notes.net, but nobody responded, and it wasn't connected to a PMR. We've tried rebuilding the view other ways, but still run into this issue.
Any suggestions would be greatly appreciated!
Documents missing from view that us... (Laurence Sopala... 16.Jan.14)
Feedback number WEBB9FER9A created by Laurence Sopala on 01/16/2014
. . Possible Solution (Laurence Sopala... 4.Mar.14)
. . Same problem, try this (Stefan Runggats... 5.Feb.14)
. . . . No, we haven't found a solution, bu... (Laurence Sopala... 10.Feb.14)
. . . . Quick question (Laurence Sopala... 10.Feb.14)
. . . . . . Quick answer :-) (Stefan Runggats... 11.Feb.14)
. . . . . . . . Thanks. What's odd is that we're a... (Laurence Sopala... 11.Feb.14)
. . Thanks for posting this! (Gary J. Morin 30.Sep.14)