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, [EMAIL PROTECTED],1, 1) ) || die( "GLEWF Failed: $ars_errstr" ); TIA Ravi ------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php _______________________________________________ Arsperl-users mailing list Arsperl-users@arsperl.org https://lists.sourceforge.net/lists/listinfo/arsperl-users