Skip to main content
 
developerWorks
AIX and UNIX
Information Mgmt
Lotus
New to Lotus
Products
How to buy
Downloads
Live demos
Technical library
Training
Support
Forums & community
Events
Rational
Tivoli
WebSphere
Java™ technology
Linux
Open source
SOA and Web services
Web development
XML
My developerWorks
About dW
Submit content
Feedback



developerWorks  >  Lotus  >  Forums & community  >  Notes/Domino 4 and 5 Forum

Notes/Domino 4 and 5 Forum

developerWorks

  


Scheduled Agent with ODBC bombs
Kenneth Axi 25.Sep.01 05:00 AM a Web browser
Domino Designer -- Agents All Releases All Platforms


Found this info in the CLP-area at http://www.lotus.com/

Here is why the agent bombs when scheduled even if ODBC is setup correctly on the server with a system DSN but the agent executes from the Notes client when run manually. When you are running the Notes Server as a service under NT it defaults to run as the "System". As such it has all rights afforded the NT operating system itself. When you run the agent manually from the Notes client it is executing under whatever account you logged into under NT (i.e. the GUI user). As with the server, the client has all access to resources as the user who is logged in. So, you log into the GUI as yourself with all access rights to whatever network resource where the database is housed, run the agent manually from the Notes client, and everything is wonderful. You then schedule the agent, it tries to access the resource as "System", and the process stops because "System" does not have access to the same network resources as your NT User Account. To prove this to yourself put the database in a local, unprotected subdirectory on the server (i.e. one that does not restrict use to certain accounts, particularly the local system) and see if the agent runs on schedule. Ours never had any problems running locally.

So, how do you "fix" this? Well the most simple way to do this is to have your Notes server service running as a user account. To change this, go into the Services Applet and double-click on the Lotus Domino Server service entry. You can then choose to have the service start under a specific user account by specifying a name and providing a password. Now for the bad news ... if you elect to run the service under a user account you will not see the console screen (i.e. DOS box) appear on your system when you log into the GUI. Why? The "Allow Service to Interact With Desktop" setting controls this and cannot be set when running a service under a specific user account. You will still be able to access the console through the remote console feature of the Administration Panel. I, personally do not like this because I have had instances where the server has been experiencing problems and could not be accessed through the remote console. I have spoken to representatives at Microsoft at length regarding this rights issue with no positive results.

If you have access to Novell servers, you have another recourse. Install and configure the GSNW (Gateway Services for NetWare). If the database is on the Novell server and the drive mapping is setup correctly you should be able to access the database using the scheduled agent. This is true even if you are running the Notes Server as a service. Why? Since GSNW runs at the system level, the "System" account has access to any of the drives mapped to the Novell servers and therefore the database. This is not without it's problems also. We have had some problems with "lost" drive mappings albeit not very frequently. Until the mappings are re-established the agent will fail. This has been our method of choice since it allows us to continue to use the server console and run the server as a service.

Of course one last option is to run the server software as an application under the GUI instead of a service. By doing so you get both the console and access to server resources available to whoever is logged into the GUI however you have the obstacles of how to insure that your server comes back up automatically if power is lost, etc.

In my opinion, none of these situations is ideal. Hopefully this will make the situation clearer and you can make a decision based on your company's individual needs.



Lotus Notes/Domino Agent FAQ update... (Julie Kadashevi... 12.Oct.00)
. . RE: Run as web user seems not work,... (Yuan Jia 23.Nov.00)
. . RE: [Julie... Add to your list?] SO... (William Hayward... 19.Dec.00)
. . RE: Can the autoprocess functionali... (Jagmeet Lamba 17.Jan.01)
. . RE: Agent output file on network dr... (Arul K Paulus-R... 23.Jan.01)
. . . . RE: Agent output file on network dr... (Leo Green 23.Jan.01)
. . . . . . RE: Agent output file on network dr... (Arul K Paulus-R... 23.Jan.01)
. . . . . . . . RE: Agent output file on network dr... (Hans Fredrik No... 24.Jan.01)
. . . . . . . . . . RE: Resolved: Agent output file on ... (Arul K Paulus-R... 24.Jan.01)
. . . . . . . . . . . . RE: Resolved: Agent output file on ... (Horst Pozdena 22.Feb.02)
. . . . . . . . . . . . . . RE: Resolved: Agent output file on ... (Horst Pozdena 22.Feb.02)
. . . . . . . . . . . . . . . . RE: Resolved: Agent output file on ... (Miguel A Navarr... 24.May.08)
. . . . . . . . . . . . RE: Resolved: Agent output file on ... (scott noebel 22.May.02)
. . RE: How to manage agent scheduler ?... (Evandro Freitas... 8.May.01)
. . RE: Agents not runing on local . (Juan Eduardo Lo... 22.May.01)
. . RE: Updating of the content of Juli... (Jerry Manner 31.Jul.01)
. . RE: Webcentric view of changing app... (Mark I Thompson... 6.Aug.01)
. . . . RE: Webcentric view of changing app... (Mark I Thompson... 6.Aug.01)
. . RE: Potential Work-Around to handel... (John Battista 9.Aug.01)
. . FAQ proposal: Anti SPAM tecniques (Simone Chemelli... 23.Aug.01)
. . Agent runs but does not send mail (David E Rackley... 30.Aug.01)
. . Scheduled Agent with ODBC bombs (Kenneth Axi 25.Sep.01)
. . Where can I find maxperformancedomi... (Ingo Beyer 6.Aug.02)
. . . . RE: Where can I find maxperformance... (Andrew P Tasi 7.Aug.02)
. . RE: Agent FAQ updated 10/07/02 [ pl... (Bill C Buhl 12.Dec.02)
. . Agent FAQ (Walter Mobach 6.May.03)
. . Recycle() clarifications (Douglas S Gray 15.Jul.04)
. . RE: Agent FAQ updated 1/9/03 (Jeff Harris 25.Feb.04)
. . Question: New ND6 AMGR Run and Canc... (Usha A Dewastha... 20.Jul.05)
. . . . RE: Question: New ND6 AMGR Run and ... (Julie Kadashevi... 10.Aug.05)
. . . . . . Question: How do a scheduled agent ... (Hung D Tran 9.Jan.06)
. . RE: Lotus Notes/Domino Agent FAQ up... (Anthony T Kendr... 29.Aug.06)
. . . . RE: Lotus Notes/Domino Agent FAQ up... (Terry Boyd 21.Sep.06)
. . "Minimizing delays in the Agent Man... (Gustavo A Rojas... 1.Feb.07)
. . RE: Lotus Notes/Domino Agent FAQ up... (Natalie Kashlin... 26.Dec.08)






  Document options
Print this pagePrint this page

 Search this forum

  Forum views and search
Date (threaded)
Date (flat)
With excerpt
Author
Category
Platform
Release
Advanced search


 RSS feedsRSS
All forum posts RSS
All main topics RSS
More Lotus RSS feeds

 Resources
Forum use and etiquette
Native Notes Access
Web site Feedback

  Lotus Support
Lotus Support
Product support pages index
Search knowledge base (Technotes)
Search support downloads
Lotus Support RSS

 Wikis
IBM Composite Applications
IBM Mashup Center
IBM Connections
IBM Docs
IBM Forms
IBM Mobile Connect
IBM Sametime
IBM SmartCloud for Social Business
IBM Web Experience Factory
Lotus Domino
Lotus Domino Designer
Lotus Expeditor
Lotus Foundations
Lotus iNotes
Lotus Instructor Community Courseware
Lotus Notes
Lotus Notes & Domino Application Development
Lotus Notes Traveler
Lotus Protector
Lotus Quickr
Lotus Symphony
IBM Web Content Manager
WebSphere Portal

 Lotus Forums
Notes/Domino 9.0
Notes/Domino 8.5 + Traveler
Notes/Domino XPages development forum
Notes/Domino 8
Notes/Domino 6 and 7
Notes/Domino 4 and 5
IBM Connections
IBM Forms
IBM Mobile Connect
IBM Sametime
IBM SmartCloud Notes
IBM SmartCloud Meetings
IBM Web Content Manager
Lotus Domino Document Manager
Lotus e-learning
Lotus Enterprise Integration
Lotus Expeditor
Lotus Protector
Lotus Quickr
Lotus SmartSuite
Lotus Symphony
Lotus Symphony Developer Toolkit Support
Lotus Workflow