Error in NULL: host must be a single element of type 'character'

[guybartal]

Expected behavior

Achiles should run successfully.

Actual behavior

got the following error:

An error occurred while the 'DatabaseConnector' package was updating the RStudio Connections pane:
Error in NULL: host must be a single element of type 'character'
If necessary, these warnings can be squelched by setting `options(rstudio.connectionObserver.errorsSuppressed = TRUE)`.

Steps to reproduce behavior

• Create 100k patients csv files using Synthea
• Run ETL-Synthea package with PostgreSQL db
• Run Achiles and see the error

[MaximMoinat]

There are more people reporting the same issue recently, e.g. on the OHDSI forums. Never saw this before. Could it have to do with the recent Achilles 1.7.2 release? @fdefalco

[fdefalco]

That would be odd given the passing checks in the release tests of Achilles here: https://github.com/OHDSI/Achilles/actions/runs/5006113546/jobs/8970948859

I'll try to run tests locally and see if I can reproduce, although at the time of the release I was able to run locally successfully as well as on the github actions.

[mlperkin]

I rolled back to 1.7.0 using this remotes::install_github("OHDSI/Achilles@v1.7.0") and I was able to run the script without the error occurring.

[chrisknoll]

That would be odd given the passing checks in the release tests of Achilles here: https://github.com/OHDSI/Achilles/actions/runs/5006113546/jobs/8970948859

Git actions doesn't actually run in RStudio, does it? I think the error is related to some interaction beween Achilles and RStudio (specifically DatabaseConnector and RStudio).

[fdefalco]

Sorry for cross-posting. I updated the forum thread on this topic asking if adding the following alleviates the issue:

options(connectionObserver = NULL)

https://forums.ohdsi.org/t/getting-an-error-running-achilles/19224/18

[fdefalco]

As confirmed in the associated thread this issue seems to have something to do with RStudio and not the Achilles package.

[fdefalco]

When you say you got the same error, do you mean the original issue error?

An error occurred while the 'DatabaseConnector' package was updating the RStudio Connections pane: Error in NULL: host must be a single element of type 'character' If necessary, these warnings can be squelched by setting options(rstudio.connectionObserver.errorsSuppressed = TRUE).

If so that was identified as an issue with RStudio and a resolution is available above.

[fdefalco]

Can you run traceback() to see where that error is coming from?

[fdefalco]

It looks like the log file has an error which is preventing the function from reading the log. I'm not sure what caused that text, if you delete that line from the log file does it recur with each execution?