Re: [Arsperl-users] Problem from web or cron

[Thilo S. <thi...@ap...>]

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