Hi: I am running ars_GetListEntryWithFields against AR System EMail
Messages form which has a lot of data (550993 records). I want to
perform some checking on the BCC field and decide if I can delete the
entry. But everytime I run the script I get the
GLEWF Failed: [ERROR] Message not in catalog; Message number = 94
(199.11.3.12) (ARERR #94) at ./cleanup_arsystememail.p.pl line 39.
The AR Error document says the query is timing out. I am using the
Create Date: < time as the qualifier. My oldest record has a create date
of 12/10/2007 0:0:26. I have tried running the script with a date as old
as that.
Any suggestion. Below is the actual code.
$thTime = time() - ($days*3600);
$qual_str = "'Create Date:' < $thTime";
($qual = ars_LoadQualifier($ctrl, $schema, $qual_str)) || die
"ars_LoadQualifier: $ars_errstr";
@get_list_fields = (18089,18090,1,3);
(@Entries = ars_GetListEntryWithFields($ctrl, $schema, $qual, 0,0,
[@get_list_fields],1, 1) ) || die( "GLEWF Failed: $ars_errstr" );
TIA
Ravi
|