• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 335
  • Last Modified:

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

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.
Thanks.

     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)
     
 
   
0
Kelvenlian
Asked:
Kelvenlian
  • 2
  • 2
1 Solution
 
CRAKCommented:
As indicated: don't try to open databases on other servers. Try this instead:
Dim arcdb00 As New NotesDatabase("","ABL.NSF")
or
Dim arcdb00 As New NotesDatabase(db.server,"ABL.NSF")
0
 
HemanthaKumarCommented:
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.

~Hemanth
0
 
CRAKCommented:
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.
0
 
KelvenlianAuthor Commented:
Thanks.
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.
0
 
HemanthaKumarCommented:
Replication might be the solution. But it could be little more complicated
0

Featured Post

Technology Partners: 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!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now