[RBG7-L] - RE: Scheduled Task puzzle

[ttc . inc]

Javier,

  Thanks for the reply.  I too have ran several "scheduled" Rbase programs for several months without problem.  That is why this one is so strange. Logged as adminstrator, if I run the program via the Scheduled Task list it does not insert rows, yet all the other commands work OK in the file.  (A delete and update command all work fine).  If I then run the same command file from the R>, still logged on as administrator etc., the command file runs all the lines without error, including the insert.

 

This is a pretty straight forward application with nothing too complicated.  The only mitigating item is the fact that the delete, update and insert command is working on an ODBC table.

 

Thank you for the instructions on running the Debug Trace.  I tried "tracing" the program from the R> and all ran fine of course.  I was wondering how to get it to trace from the scheduler, now I know!  Hopefully this will bring something to light.   Thanks again!

 

-Bob

 

-------------- Original message --------------

Bob:

I have an application that runs every night at 11:30 PM. It reads a text file generated by another system parses the data and then inserts the appropriate values into 3 different tables doing data integrity checks, it has been running reliably for almost a year.

A couple of thing to check
Is the application running over a network?

Does a user need to be logged in and have access privileges?

Does the network have scheduled routine maintenance that would disconnect the user or other wise conflict in time with your application?

One way to check your code is to place the commands:

SET MESSAGES ON

SET ERROR MESSAGES ON

SET DEBUG ON

DEBUG TRACE

At the top of you code and schedule it to start in a couple of minutes. When it starts it will be in the TRACE mode and then you can execute the commands one line at a time and hopefully you will see where you problem is as all messages will be displayed. If you are running the Scheduler under Windows XP, I believe that it is required that the workstation have a login and password, otherwise it will not execute.

Javier,

 

Javier Valencia, PE

President

Valencia Technology Group, L.L.C.

14315 S. Twilight Ln, Suite #14

Olathe, Kansas 66062-4578

Office (913)829-0888

Fax (913)649-2904

Cell (913)915-3137

================================================

Attention:

The information contained in this message and or attachments is intended

only for the person or entity to which it is addressed and may contain

confidential and/or privileged material.  Any review, retransmission,

dissemination or other use of, or taking of any action in reliance upon,

this information by persons or entities other than the intended recipient

is prohibited. If you received this in error, please contact the sender and

delete the material from all system and destroy all copies.

======================================================

 

-----Original Message-----
From: rbg7-l@rbase.com [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]
Sent: Tuesday, November 01, 2005 9:43 AM
To: RBG7-L Mailing List
Subject: [RBG7-L] - Scheduled Task puzzle

 

Any one have an idea why a command file would run fine from an R> but not from the task scheduler?  I have a command file that I have set to run every hour in the scheduler.  When the scheduler runs the file, everything seems to work OK but an insert command does not execute. (Does not give an error, nor does it insert the records)  If I run the same file from the R>, the insert command executes fine.  I get no errors, the insert simply does not work.  This is a real puzzler for me.

Thanks,

-Bob