aqs_sampledata_by_state/site causes error in specific circumstance

[DEQbayres]

I am having a problem pulling data using the aqs_sampledata_by_state command. To start, DEQ fixed the submission issue that I think is causing this in 2020 when investigating a different problem. DEQ is planning to just correct the past AQS data with an alternate code, but in case anyone else has problems with pulling the data, I wanted to let you know what I found.

I have traced it back to the report DEQ's LIMS system used to submit to AQS. MDL values for select voided analytes in the system spit out a value of 208000 for the MDL. I used the AQS java applet to pull data and "Alternate Method Detectable Limit" is the column header for this value. I have attached the generated error (not sure of etiquette on this site. Hope a txt is okay to submit). Naphthalene (17141) data is the only data I pulled that had this code, but I only pulled data for 8 analytes. There could be other analytes that have this problem as well.

I have tested the sampledata pull options for both state and site level using multiple date ranges, analytes, etc and from the list of dates that cause this error in this script, this MDL for 17141 seems to be the common thread. MDL values for other compounds I pulled (ex. benzo[a]pyrene, 17242) are in the 10000 - 100000 range (83900 for b[a]p) and seem to work fine.

Like I said, this was a submission issue on DEQs side and it will get corrected, but I wanted to let you know in case anyone else submits crazy high MDL values.

code:
library(RAQSAPI)
df <- aqs_sampledata_by_state(c(17141, 17242, 43502), as.Date("20160101", "%Y%m%d"), as.Date("20201231", "%Y%m%d"), "41")

Caused by error.txt