Liveware Publishing Support Forum

Hi,____I^m having next problem:____A report with Flexlink indexes is only running when the user has administrator priviliges.__When ran by standard users, they get a "Report Canceled" (returncode R) dialog.____The users have Full Control permissions over the folder where the flexlink index is supposed to be build ( = the Temp dir in their profile c:documents and settingsusernamelocal settings empR&R )____They can run other reports without any problem. ____When running a flexlink report, no RRX index file is being built in the Temp folder. ____What other permissions do they need in order to run such reports?______Using R&R v11.006____Paul______

Full control should cover things. And the TEMP environment variable does point to the user^s folder?____Kathleen__R&R Support

>Full control should cover things. And the TEMP environment __>variable does point to the user^s folder? __>__>Kathleen __>R&R Support ______Yes it does. __And they have full control over that folder.__R&R does create the R&R subfolder in the Temp folder. __If I delete it and run a report, it is recreated. __So this is a proof that a) the user has the correct permissions and b) the temp path is recognized by R&R.__However, no flexlink indexes are created in that folder, unless I log on with admin rights. ____FYI: Clients Pc^s use the R&R install on a server. It goes fine for any report, except with a Flexlink index. ____Paul________

OK I^ve looked into the RRWRUN.EXE process with Filemon to see what was going on.____Different *.tmp and *.idx and *.rrx files ARE created in the temp folder. But, as soon as next error is encountered, R&R deletes all those files again (that^s why I thought they were not created) an exits: ____The error is this: R&R creates also a file called "TEMPFILE.NDX".__This is being done IN THE APPLICATION FOLDER!____In this case, a network share called J:VOSPIO____Since standard users have only READ rights for this folder, R&R encounters an "ACCESS DENIED" and terminates. ____No way I can give users FILE CREATE and FILE DELETE rights to the application folders (which is needed for R&R to create and afterwards delete the tempfile.ndx). __They only have write access to the folders where the datafiles resides, (e.g. J:VOSPIODATA) and even then they cannot create files there. ____It seems to me this is a bug. R&R should do all of its work in the user^s temp folder (and it seems to do this, this is the ONLY file that is being created in the app. folder). ____Have you got a solution please.____Paul______________________

What is the index key expression of the related table and does that table have an associated memo or structural index?____I think that flexlink only build this TEMPFILE.NDX under a very limited set of circumstances.____Kathleen__R&R Support

>What is the index key expression of the related table and __>does that table have an associated memo or structural index? __>__>I think that flexlink only build this TEMPFILE.NDX under a __>very limited set of circumstances. __>__>Kathleen __>R&R Support ____HI____Sorry for replying late, I was away.____No, the index key is dead simple. ____The main Table has a field called PSIKEY which is is numeric key field (7,0).____The relation into the child table is a one-to-many relation on a field GOPSIKEY (also 7,0).__Since there is no index order on that field, I use a Flexlink on this keyfield. ____The child table does have a structural index (a CDX) and a memo (FPT)__but since there is no index order on the desired keyfield, I don^t use them. ____Paul______