Have you verified that you are logging in to ARS as the same user? As a test, try changing your qual in the cron to directly select one of those records that shows up interactively.
Mark Vaughan TTS Development Comcast Cable Corporation 720.268.8591 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Thilo Stapff Sent: Thursday, October 18, 2007 2:36 AM To: Brad O'Hara; ARSperl User Discussion Subject: Re: [Arsperl-users] Problem from web or cron You might try the following: Assuming that '800000101' is a date or date/time field, specify the date in the qualifier string as an integer (epoch time for date/time fields, see recent arsperl-users thread about date conversion for date fields). Furthermore, it looks like '800006010' might be a selection field. If this is the case, specify the corresponding integer values of "Problem" and "Informational" here as well. Regards, Thilo Stapff Brad O'Hara wrote: > COMMAND LINE: > Started at Wed Oct 17 14:35:00 EDT 2007 > > after login errstr=>< > q=>('800006010' = "Problem" OR '800006010' = "Informational") AND > '800000101' = "10/16/2007"< > after load qual errstr=>< > qual=>ARQualifierStructPtr=SCALAR(0x89ae9b0)< > after get list errstr=>< > number entries=>19< > CNS-00000000061 > CNS-00000000062 > CNS-00000000063 > CNS-00000000064 > CNS-00000000065 > CNS-00000000066 > CNS-00000000067 > CNS-00000000068 > CNS-00000000069 > CNS-00000000070 > CNS-00000000071 > CNS-00000000072 > CNS-00000000073 > CNS-00000000075 > CNS-00000000076 > CNS-00000000077 > CNS-00000000078 > CNS-00000000079 > CNS-00000000080 > > CRON: > Started at Wed Oct 17 14:43:02 EDT 2007 > > after login errstr=>< > q=>('800006010' = "Problem" OR '800006010' = "Informational") AND > '800000101' = "10/16/2007"< > after load qual errstr=>< > qual=>ARQualifierStructPtr=SCALAR(0x98d8810)< > after get list errstr=>< > number entries=>0< > > Thanks sooo much for your help! This is driving me crazy. Notice I get > logged in and the qualifier is built fine, but I get no entries. I > attached the entire script if that helps. > > Brad > > Thilo Stapff wrote: >> Would it be possible to insert some debug statements to see how far it >> gets (especially checking for $ars_errstr after every ARS API call)? >> >> I don't know where the output from cron jobs goes, but there should be >> a log file for this. Or maybe the output can be explicitly redirected >> in the cron job definition? >> >> Do you know if the script gets started at all? >> >> >> Regards, >> Thilo Stapff >> >> >> Brad O'Hara wrote: >>> Sorry to bother you directly, I posted this to the list without a >>> response :-( and noticed you answer most questions. >>> I am using ARSperl 1.90 against a v7.01 server. >>> >>> Not sure what I am doing wrong! I have the following code that >>> retrieves entries when run from the command line, but not from a >>> crontab entry. >>> >>> my $c = ars_Login(&CCACHE::SERVER, &CCACHE::USERNAME, >>> &CCACHE::PASSWORD); >>> my $query = qq/('800006010' = "Problem" OR '800006010' = >>> "Informational") AND '800000101' = "$date"/; >>> >>> ($qual = ars_LoadQualifier($c, $schema, $query)); >>> >>> # Get Requests >>> my (%entries = ars_GetListEntry($c, $schema, $qual, 0, 0)) ; >>> >>> if ( %entries ) { >>> my (%values, %ticket); >>> foreach $entry_id (sort keys %entries) { >>> } >>> } >>> else { #nothing returned } >>> >>> The only thing I could think of was a path difference, however, I set >>> $ENV{'PATH'} = to the same as the shell path. >>> >>> Any help is greatly appreciated. >>> >> >> > ------------------------------------------------------------------------ - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Arsperl-users mailing list Arsperl-users@arsperl.org https://lists.sourceforge.net/lists/listinfo/arsperl-users ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Arsperl-users mailing list Arsperl-users@arsperl.org https://lists.sourceforge.net/lists/listinfo/arsperl-users
