<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%> truter.biz - London news + IT in London truter.biz Lotus Notes and Domino ; Domino Error messages; remote server is not a known TCP :: Lotus Notes and Domino ::

 

Select one of the following:
Error - The remote server is not a known TCP/IP host

TOP TIP

If you know the IP address of the server, click on File - Database Open and type in the IP address in the Server field. If a connection document does not yet exist for the Notes server, one will now be created in the names.nsf file (with the server name)!

The most common reasons are listed below:

1. CONNECTION DOCUMENT

As per the Notes help file:

"Connection documents reside in your Personal Address Book and store information Notes needs to access a server, such as the server's full Domino name, Internet address, or telephone number. One server may have multiple Connection documents if you access it in multiple ways, for example over the LAN at work and using a dialup modem from home."

For a server on your LAN:

- Open the names.nsf file in your notes data directory

- Go to advanced connections

-Click on the "New Server Connection" action button

- Select Local Area Network as the connection type

- Select the appropriate ports - TCPIP and LAN0

- Enter the server name e.g. Sales/Acme

- Got to advanced and select the location and users it's relevant to. Enter the IP address in the destination server address field

 

2. HOST FILE

This error message is caused when the Domino server cannot be found (perhaps due to an incorrect MX record or more probably where the c:\windows\hosts file is corrupted, missing or incorrect.

Solution: Add the following line to the "hosts" file.
192.168.21.2 <Servername>

If that does not work, edit the hosts.sam and lmhosts.sam files.

Click here for an example of a hosts file.

 

 

 
Error Message - The integrity of a database storage container has been lost - the container will be rebuilt

This problem is new and particular to Notes 6. In most cases this occurs when a Notes 6 Client is attempting to replicate with a database on a Domino server which is version 5.

Solution:

  1. Clear the replication history on the local replica
  2. Run the compact command on both the local and server replica
  3. Perform a manual replication (i.e. Select File - Replication - Replicate - with options)

If that fails, you will need to create a new local replica.

 

 

Secure a Domino Console:
SET SECURE password


In this syntax, password is the password you want to use to secure the console. The console password does not have to be the same as the administrative password and, in fact, should not be the same.

The following commands cannot be used while the console is secured with a password:

LOAD
TELL
EXIT
QUIT
SET CONFIGURATION


To use these commands, you must remove console security by again entering SET SECURE password.

There is one small loophole here that can be sealed only by denying physical access to the Domino server. The password used to secure the console is stored as an environment variable in the NOTES.INI file. You can figure out what the password is by looking in the NOTES.INI file, or you can edit the file and delete the line that contains the console password. This is great for the forgetful system administrator, but does provide a back door for anyone attempting to gain direct-disk access to your server. In short, protect your server by securing the console, but do not turn around and hand out the key by allowing people physical access to your Domino server.

 

Deleting documents and its responses

Sub Initialize
Dim session As New NotesSession
Dim db As NotesDatabase
Dim FiledDb As New NotesDatabase("SAONotes_DEV/Citizens" , "AquisitionTest\FiledRequests.nsf")
Dim View As NotesView
Dim doc As NotesDocument
Dim child As NotesDocument
Dim collection As NotesDocumentCollection

Set db = session.CurrentDatabase
Set view = db.GetView("By Set and Question Number")
Set doc = view.GetFirstDocument

While Not doc Is Nothing
If doc.rdostatus(0) = "Filed" And Not doc.IsResponse Then
Call doc.CopyToDatabase(FiledDb)
Set collection = doc.responses
While Not child Is Nothing
Set child = collection.GetNextDocument(child)
Wend
Call collection.RemoveAll(True)
End If
Set doc = view.GetNextDocument(doc)
Wend
End Sub

Display the contents of rich text fields in a view

On the form, if the rich text field name is Body create a hidden computed text field with the following value:

@Abstract( [TextOnly]:[TrimWhite]; 64000 ; "" ; "Body" )

The Body Text field can now be used in view.

 

Single login on Domino server

You can enable this from server document:

  • From the names.nsf database on the server,go to Server then Servers
  • Edit your (Web) Server document
  • Go to internet protocols then domino web engine
  • in "Session authentication" set it to "Multi-sever" (or "Single Server" for one server)

If that does not work, from the Servers view, click on the Web action button

  • Select "Create Web SSO Configuration"
  • Complete the document



 

Marquee

<marquee scrollamount="15" align="middle" scrolldelay="350" bgcolor="#CCFF99" height=15 width=80%><Computed Value></marquee>



Where computed value is a lookup i.e.

server:=@Subset(@DbName;1);
db:="stocks.nsf";
view:="vLatest";
col:=5;
list:=@DbColumn("Notes":"NoCache";server:db;view;col);
@Implode(list;" ... ")

 

Add Animated Help (ala Microsoft Paperclip)

http://www.dominopower.com/issues/issue200207/agentcontrol002.html
http://www.microsoft.com/msagent/devdownloads.htm

 

Error Message - Database is in use, cannot delete

When attempting to delete a Domino database and the message "Database is in use, cannot delete" or something to that effect is produced, type in "dbcache flush" in the Domino server screen and try again.

 

Error Message - Can't append list to a null item

Occurs if the value of a field exceeds 64K.

 

Time selector adds hour to time component in Calendar

When selecting the hour from the Notes Time component and posting to the calendar, an hour is added. To prevent this, place the following formulae in the Input Translation formulae:

@Time(@Year(Meet_Date);@Month(Meet_Date);@Day(Meet_Date);@Hour(Meet_Time);@Minute(Meet_Time);@Second(Meet_Time))

where Meet_Time is the corresponding date component.

 

Excel import example in LotusScript

Sub Initialize
Dim xlFilename As String
xlFilename = "H:\Test.xls" '// This is the name of the Excel file that will be imported

Dim session As New NotesSession
Dim db As NotesDatabase
Dim view As NotesView
Dim doc As NotesDocument
Set db = session.CurrentDatabase
Set doc = New NotesDocument(db)
Dim One As String

Dim row As Integer
Dim written As Integer

'// Next we connect to Excel and open the file. Then start pulling over the records.
Dim Excel As Variant
Dim xlWorkbook As Variant
Dim xlSheet As Variant
Print "Connecting to Excel..."
Set Excel = CreateObject( "Excel.Application.8" )
Excel.Visible = False '// Don't display the Excel window
Print "Opening " & xlFilename & "..."
Excel.Workbooks.Open xlFilename '// Open the Excel file
Set xlWorkbook = Excel.ActiveWorkbook
Set xlSheet = xlWorkbook.ActiveSheet

'// Cycle through the rows of the Excel file, pulling the data over to Notes
Goto Records
Print "Disconnecting from Excel..."
xlWorkbook.Close False '// Close the Excel file without saving (we made no changes)
Excel.Quit '// Close Excel
Set Excel = Nothing '// Free the memory that we'd used
Print " " '// Clear the status line


Records:
row = 0 '// These integers intialize to zero anyway
written = 0

Print "Starting import from Excel file..."

Do While True
Finish:
With xlSheet
row = row + 1
Set view = db.GetView("Main View")
Set doc = db.CreateDocument '// Create a new doc
doc.Form = "ImportForm1"

doc.SWEPO = .Cells( row, 1 ).Value
doc.SWEORDER = .Cells(row, 2 ).Value
doc.SWEORDERDATE = .Cells(row, 3).Value
doc.ITEMNUMBER = .Cells( row, 4 ).Value
doc.ORDERSTATUS = .Cells(row, 5).Value
doc.QUANTITYORDERED = .Cells( row, 6).Value
doc.AMOUNTBILLED = .Cells(row, 7).Value
doc.SHIPMETHOD = .Cells( row, 8).Value
doc.SHIPDATE = .Cells(row, 9).Value
doc.TRACKINGNUMBER = .Cells(row, 10).Value


Call doc.Save( True, True ) '// Save the new doc

written = written + 1

If written = 100 Then
Print written
Print written & "record stopped at..", doc.SWEPO(0), doc.SWEORDER(0),doc.SWEORDERDATE(0),doc.ITEMNUMBER(0)
ans$ = Inputbox$("Do you want to continue, Y/N?")
If ans$ = "Y" Or ans$ ="y" Then
Goto Finish
Else
Goto Done
End If
End If
' End If
End With
Loop
Return
Done:
End Sub

 

How to prevent the confusing "Do you want to save this new document? (Yes/No/Cancel)".

Create a File Save action button with the following code:

@If(!Command([ViewRefreshFields]);@Return("");"");
@PostedCommand([FileSave]);
@PostedCommand([FileCloseWindow])

 

Displaying images in a view

To display images in view columns :
1- Create a field called URLIcon in the form used to create documents,
2- Go to the view and in the column you want to display the image, put URLIcon, and choose display as icon.
3- When you create a new document, in the URLIcon field put the name of the Image Resource you want to be dispalyed.

 

winmail.dat attachments and att1.unk attachments in Lotus Notes

These attachments are sent if the sender uses a Microsoft email client (such as Outlook):

Original attachments are "stored" in the att1.unk file in Notes if the original message was transmitted with MIME encoding.

Original attachments are "stored" in the winmail.dat file in Notes if the original message was transmitted with UUEncodes.

To access the original attachments, download and run this command-line program:
http://www.fentun.com


Error Message - tmpOwnerHW : Incorrect data type for Operator or @Function: Number Expected

With the problem I encountered, the user was synchronizing his P900 Sony-Ericsson with Lotus Notes 6.02. The error message above appeared when viewing certain entries in his calendar. The field - tmpOwnerHw had a rogue value. The solution is to edit(make a nominal change e.g. add a space after the subject, and resave the document.

"You are not authorized to create new replica databases on this server" error

The reason for this error is that the user does not have access to create a replica on a server.

Solution: In the server document, under Security - Server Access, complete the field "Create new replicas" and add the full user name.

How to rebuild the busytime.nsf database

Validation of new entities (in terms of new users and rooms freetime showing up in meeting invitations) occurs once each day at a scheduled time (usually 2 AM).
To manually perform this update run the server command "tell sched validate" from the console.

Mail not routing from mail.box on server

If mail routes successfully to certain domains but not others, check if the unsuccessful domains do not use reverse DNS checks.

In our example, mail was not being routed to email addresses at @aol.com. The mail sat in the outgoing mail box on the server (mail.box) until the delivery time expired.

The reason was because aol.com uses reverse dns to verify incoming emails. We then asked our ISP to create a reverse DNS entry for our mail server, and provided the: IP address, mail server hosting name

To check if an ip is setup for reverse DNS lookup go to -http://postmaster.info.aol.com/tools/rdns.html

or read here for more details http://postmaster.info.aol.com/errors/421dnsnr.html

How to move or recertify users to a New Domain

Follow the instructions below to move from SERVER1/OLDDOMAIN to SERVER2/NEWDOMAIN

To summarize the steps:
Setup
1. Certify the server ID of SERVER2/NEWDOMAIN with SERVER1/OLDDOMAIN and vice versa
2. Ensure the Administration Server on the NAB on each server reflects that server
3. The adminp server process should be running on both servers

Step 1
1. Select the NAB on the Administration Server.
2. In the People view of the public NAB, select the following from the menu: Action, Rename Person, Request Move to New Certifier.
3. Select the Original Certifier when prompted.
4. Type the New Certifier when prompted or select from the drop down.
5. Click the Submit Request button.
6. Type the following at the server console: Tell AdminP Process New

Step 2
1. Open the ADMIN4.NSF database.
2. Open the "Name Move Request View".
3. Select Action from the menu.
4. Select Complete Move for Selected Entries (this is the top choice).
5. Specify the New Certifier.
6. Click OK twice.
7. Type the following at the server console: Tell AdminP Process New
8. In SERVER1/OLDDOMAIN Public Address Book change the person document with the following: Domain to NEWDOMAIN, mail server to SERVER2/NEWDOMAIN and mail file location.
9. Run load dircat dc.nsf –r
10. Copy the person document from SERVER1/OLDDOMAIN PAB to SERVER2/NEWDOMAIN
11. Run load dircat dc.nsf –r (load dircat skedirc.nsf –r)
12. The location doucments of all users will need to be updated accordingly.
13. Update the users details in all the groups – change domain OLDDOMAIN to NEWDOMAIN

Tell router update config

If you make changes to the configuration Settings, Domain, Connection, and Server documents in the Domino Directory, you have to wait a certain interval (normally 5 minutes) before you can test the results. However to make the changes effective immediately, without restarting the router task, issue the server command "Tell router update config".