Show history not working after upgrade to 3.1.0

Neil · Post by **Neil** » Wed Jul 20, 2005 2:10 am

I've just upgraded to 3.1.0 and the show history by item (on a folder) doesn't work (returns no rows). The by version does work though.

Any ideas?

Post by **jclausius** » Wed Jul 20, 2005 7:06 am

Do you have folder security enabled or disabled?

If you execute the history query from the server on the same folder does that work?

If you minimize the History Query window, and then restore it, are the rows present?

Neil · Post by **Neil** » Wed Jul 20, 2005 8:02 am

Folder security is enabled. If I log on as admin then I *can* see the history, but I can't as a normal user. I can see the history of individual files as a normal user though, but not the recursive folder history.

Post by **jclausius** » Wed Jul 20, 2005 8:14 am

Has your account been denied any access to the tree?

Neil · Post by **Neil** » Wed Jul 20, 2005 8:48 am

No - I can see it fine, and have checked files in and out in the past.

Post by **jclausius** » Wed Jul 20, 2005 8:59 am

Let's see if we can get a better picture of what is going on.

Do you have access to the database? If so, let's try this:

SELECT userid FROM sgvault.dbo.tblusers WHERE login = N'YOUR_USER_NAME_HERE'

SELECT repid, name FROM sgvault.dbo.tblrepositories

Using the userid, repid, can you run / report the results of

SELECT * FROM sgvault.dbo.ufngetusersecurityrights(REPID_HERE, USERID_HERE, DEFAULT)

If you do not want to post the results, please email me (using the button below this post), and we can take this offline.

Neil · Post by **Neil** » Wed Jul 20, 2005 11:29 am

Jeff,

It gives me a bunch of folders. For example, it includes the folder:

$/xx/yy

If I do a history on this folder, then it works and gives the history for the folder and all subfolders. If I do a history on a sub-folder not in this security list (eg $/xx/yy/v 2.0) then it doesn't work.

Does that help, or do you need the entire results set?

Post by **jclausius** » Wed Jul 20, 2005 11:50 am

What are the securityrights on $/xx/yy? Do you have anything in that result set with a security right of 0?

Neil · Post by **Neil** » Wed Jul 20, 2005 2:22 pm

The only relevant items are:

ident,type,objid,usergroupid,fullpath,securityrights
1,D,0,7,!,0
2,G,2928,2,$/xx,1
37,G,43103,2,$/xx/yy,7

Post by **jclausius** » Thu Jul 21, 2005 9:44 am

OK. Let me try some testing on my end to see if I can come up with anything.

Neil · Post by **Neil** » Fri Jul 22, 2005 2:27 am

Thanks Jeff. We've now had to turn folder security off because the performance for checking and checking out files was unacceptably slow.

Someone from here will probably contact you separately about that though.

Post by **jclausius** » Fri Jul 22, 2005 6:56 am

Neil:

Have them contact me directly (using the email button below).

Some of the 3.1 stored procs were optimized to reduce the number of recompiles. However, this caused SQL Server to use an inefficient plan where there are > 4000 checked out items.

I'm currently working on a fix and should have something shortly.