DBlookup not working in scheduled agent on server

Posted on 2005-03-27
Medium Priority
Last Modified: 2013-12-18
I've written a scheduled agent that does a dblookup to another database on the server.  The agent doesn't pull anything from the lookup when run as a scheduled agent.  

If I copy the code into a menu agent and run it, it runs fine.  And it emails me the dblookup variables it pulls.

I know the agent is running on schedule because it makes changes to the documents before it gets to the dblookup section.  But it won't run the dblookup.  But a field that it supposed to populate from the dblookup has the followinge error: "you are not authorized to perform that operation."

I have the same issue on the server.

I have a copy of the lookup database on the server and on my local.

I am running 5.12 on workstation and server.

Question by:mackmcrae
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
LVL 46

Expert Comment

by:Sjef Bosman
ID: 13640711
- there must be something in the log-database of the server( error messages etc)
- what permissions do you have (you saved the agent?) on the server to run agents?
- let's have some code please...
LVL 19

Expert Comment

ID: 13642813
Is your @DbLookup pointing to external Notes database (Another Domino server?)

Is the DbLookup data in your same server and same database or another database?

Author Comment

ID: 13642968
I figured it out.

The dblookup was pulling back a null value sometimes (it was a list of shift supervisors and one shift didn't have a supervisor.  Something I didn't know was possible.).

From what I can tell, when an agent is run from the menu in a view, it runs through each document one at a time.  So when the agent got the null value and tried to operate on it, it got an error and moved on to the next document.

However, when the same code is run in a scheduled agent, it works differently.  When it gets the same error, it just bombs and doesn't correctly move on to the next document.

LVL 18

Expert Comment

ID: 16161568
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I will leave the following recommendation for this question in the Cleanup topic area:
    PAQ with points refunded

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

EE Cleanup Volunteer

Accepted Solution

DarthMod earned 0 total points
ID: 16185307
PAQed with points (500) refunded

Community Support Moderator

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!

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…
For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
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…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

800 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