Agent:- error message: Cannot open databases on machines other than the server running your program

Posted on 2003-03-26
Medium Priority
Last Modified: 2013-12-18
I'm fresh using the lotus script.
I want to using Agent (by schedule) to automatic copying the data from current database to another server database. Below are my script. But I try to open the "ABL.NSF" file and it return "CANNOT OPEN DATABASES ON MACHINES OTHER THAN THE SERVER RUNNING YOUR PROGRAM". Can anyone help me to solve this problem or give me suggest to do this job.

     Dim session As New NotesSession
     Dim db As NotesDatabase
     Dim view As NotesView
     Dim doc As NotesDocument
     Set db=session.CurrentDatabase
     Set view=db.GetView("Archived")
     Set doc=view.GetFirstDocument
     Print db.Server
     ' Open Archived DATABASE
     Dim arcdb00 As New NotesDatabase("DominoDB","ABL.NSF")
     Dim arcdoc00 As New NotesDocument(arcdb00)
Question by:Kelvenlian
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
LVL 13

Expert Comment

ID: 8209665
As indicated: don't try to open databases on other servers. Try this instead:
Dim arcdb00 As New NotesDatabase("","ABL.NSF")
Dim arcdb00 As New NotesDatabase(db.server,"ABL.NSF")
LVL 24

Accepted Solution

HemanthaKumar earned 375 total points
ID: 8211279
This is a known limitation implemented in Agents (Especially scheduled) And nothing can be done about it. You have to make it a manual agent so that it can see other database on other servers.

LVL 13

Expert Comment

ID: 8211342
In my comment I assumed that the targeted database was available on the same server.
If not, you could create a replica on the "current" server and replicate modifications back.

Author Comment

ID: 8214618
I has solve my problem. But why agent by schedule cannot copy data to another server?
OR any suggestion that i can copy data to another server.
LVL 24

Expert Comment

ID: 8220607
Replication might be the solution. But it could be little more complicated

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question