Error when trying to search for everything in the collection "Invertebrate Zoology (ALMNH:Inv)"

[kmkocot]

I tried searching https://arctos.database.museum/ for everything in the collection "Invertebrate Zoology (ALMNH:Inv)" and got the following error:

An error occurred while processing this page!
Message: ERROR: canceling statement due to user request Where: SQL function "concatencumbrances" statement 1 PL/pgSQL function concatattributevalue(bigint,text,bigint) line 12 at FOR over SELECT rows
Detail:
Check the Arctos Handbook for more information on errors.

This message has been logged as D7F1419A-E55F-47AB-895BCAB0E551524B Please contact us with any information that might help us to resolve this problem. For best results, include the error and a detail description of how it came to occur in the Issue. 

I know this has worked in the past and we only have about 20K records. I'm trying to figure out the last catalog number that was successfully uploaded to Arctos.

Thanks, Kevin

[Jegelewicz]

@kmkocot I just searched and it worked for me. Have you tried accessing it from the portals page?

[kmkocot]

Thanks @Jegelewicz! Just to clarify, it worked from https://arctos.database.museum/ or the portal page for you (or both)? Performing this search from the portal does work for me but it doesn't from the main search page. Is that just too many records? I swear this used to work for what it's worth.

Thanks, Kevin

[kmkocot]

Update: it seems that it only works from the portal or main search page if I'm not logged in.

[Jegelewicz]

I searched from the main page, just picked your collection and then hit search - it all came up.

Try clearing the cache in your browser?

[kmkocot]

Thanks for your help. I tried on a different browser on my PC an on a different computer. In both cases, it works when I am not logged in and it doesn't when I am logged in.

[dustymc]

arctosprod@arctos>> select resultcolumnlist from cf_users where username='kmkocot';
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     resultcolumnlist                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 guid,scientific_name,country,state_prov,spec_locality,verbatim_date,dec_lat,dec_long,coordinateuncertaintyinmeters,associated_species,began_date,coll_event_remarks,continent_ocean,county,datum,day_collected,depth_in_m,drainage,elev_in_m,ended_date,event_assigned_by_agent,event_assigned_date,feature,georeference_protocol,georeference_source,island,island_group,json_locality,locality_name,locality_remarks,max_elev_in_m,maximum_elevation,min_elev_in_m,minimum_elevation,month_collected,orig_elev_units,orig_lat_long_units,quad,sea,specimen_event_remark,specimen_event_type,specimeneventdeterminer,verbatim_coordinates,verbatim_locality,year_collected,accn_number,attributedetail,citations,collecting_event_id,collecting_method,collecting_source,collectors,creator,entered_by,family,formatted_scientific_name,full_taxon_name,genus,habitat,id_date,id_history,id_sensu,identification_remarks,identified_by,individualcount,kingdom,last_part_location,long_citation,made_date,media,nature_of_id,othercatalognumbers,partdetail,parts,phylclass,phylorder,phylum,preparators,related_record_summary,relatedcatalogeditems,remark,sci_name_with_auth,skull_yn,species,subfamily,subspecies,subtribe,tribe,verificationstatus,abundance,age,age_class,air_temperature,archaeological_feature,axillary_girth,bill_depth,bill_length,bill_width,body_condition,body_temperature,body_width,breadth,brood_parasite_present,brood_patch,bursa,bursa_length,bursa_width,calcar_length,carapace_length,caste,clutch_size,clutch_size_of_nest_parasite,colors,copyright_status,credit_line,crop_contents,crown_rump_length,culmen_length,culture_of_origin,culture_of_use,curvilinear_length,description,dimensions,diploid_number,ear_from_crown,ear_from_notch,ectoparasite_examination,ectoparasites_detected,egg_content_weight,eggshell_thickness,electrical_conductivity,embryo_weight,endoparasite_examination,endoparasites_detected,examined_for_parasites,exhibit_caption,experimental,extension,fat_deposition,forearm_length,forewing_length,framed,gonad,head_length,head_width,height,hind_foot_with_claw,hind_foot_without_claw,hind_limb_length,historical,image_confirmed,incubation_stage,inscriptions_and_marks,isotope_value,keywords,left_gonad_length,left_gonad_width,location_in_host,materials,maximum_standard_length,maximum_total_length,middle_toe_length,minimum_standard_length,minimum_total_length,molt_condition,nagpra_category,neck_width,nest_description,nest_phenology,nottitle,number_of_labels,numeric_abundance,numeric_age,object_title,ovum,parasites_found,parts_examined,pit_depth,plastron_length,preservation_need,provenience,provenience_east,provenience_north,quadrant,radiometric_date,reproductive_data,right_gonad_length,right_gonad_width,sex,skull_ossification,snout_vent_length,snv_results,soft_part_color,soft_parts,square,standard_length,stomach_contents,stratigraphic_position,tail_base_width,tail_condition,tail_length,tarsus_length,tested_for_presence,thumb_length_with_claw,tooth_length,tooth_width,total_length,tragus_length,trap_identifier,trap_type,unformatted_measurements,value,verbatim_collector,verbatim_host_age,verbatim_host_id,verbatim_host_sex,verbatim_preservation_date,water_temperature,weight,width,wing_chord,wing_span,year_class
(1 row)

I'd certainly make use of more CPU if I had it, but right now I don't so there's just a warning. Find something small, customize, turn some stuff off, bigger queries should work.

trying to figure out the last catalog number that was successfully uploaded to Arctos.

[kmkocot]

Understood. I didn't realize that column selection was persistent like that. Thank you!!