Fix corrupted view on local database

I recently had to help a remote user, working of their c: drive, fix a corrupted view.

You Can View User Feedback To This Tip

I recently had to help a remote user, working of their c: drive, fix a corrupted view. Creating a new local replica of the database was not an option.

Here's what I came up with.

On a server, corrupted views can be fixed via Updall. Well, you can do the same thing on a local copy of a database.

The NUPDALL.EXE program which sits in the Notes directory on the Local drive, can be run similarly on a local database as Updall can be run on a server.

The code below is an example of script that can be put into a button and emailed to the user. notesdbname$ is the Notes path to the database

osdbname$ is the full path to the database from the O/S level

You need to know the full o/S path to the Notes directory and the database on the user's hard drive.

Sub Click(Source As Button)
           Dim taskId As Integer
           notesdbname$ = "testmydatabase.nsf"
           Dim db As New NotesDatabase( "", notesdbname$)

           osdbname$ = "c:notesdatatestmydatabase.nsf"
           notesviewname$ = ".vwTheView"

           thepgm$ = "c:notesnupdall "
           theparams$ = osdbname$ & " -T " & notesviewname$ & " -R"
           taskId% = Shell (thepgm$ & theparams$,3)
End Sub

USER FEEDBACK TO THIS TIP

  • This tip may work, but is rather elaborate. Instead of reaching out to LotusScript as a tool to solve everything, try opening the database and pressing CTRL+SHIFT+F9 (or SHIFT+F9 in the view you need fixed). Another advantage: you don't have to know the location of the Notes-directory AND it works in a Citrix-environment. —Ronald van Puijenbroek

This was first published in April 2002

Dig deeper on Domino Resources

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchWinIT

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchEnterpriseLinux

SearchVirtualDataCentre.co.UK

Close