René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Cannot Create Dir RtmpmaJNMP","articleBody":"Running sqlmlutils 0.7.1 in R against a SQL Server 2019 RC1 machine.\r\n\r\n# Reproduction Steps\r\n\r\nRunning a sample package call:\r\nsql_install.packages(connectionString = ad_connection, pkgs = \"data.table\", scope = \"PUBLIC\", verbose = TRUE)\r\n\r\nad_connection is a local variable which represents a database where ML Services is set up correctly.\r\n\r\nHere is the output:\r\n\r\n```\u003e sql_install.packages(connectionString = ad_connection, pkgs = \"data.table\", scope = \"PUBLIC\", verbose = TRUE)\r\n2019-10-28 09:48:37.69  Starting package install on SQL server (Driver={SQL Server};Server=D2-SQL-R-02;Database=AnomalyDetection;Trusted_Connection=Yes;)...\r\n2019-10-28 09:48:37.69  Verifying permissions to install packages on SQL server...\r\nWarning: unable to access index for repository https://cran.rstudio.com/src/contrib:\r\n  cannot open destfile 'C:\\Users\\KEVIN~1.FEA\\AppData\\Local\\Temp\\RtmpmaJNMP\\file75603f8535cd', reason 'No such file or directory'\r\nWarning: unable to access index for repository https://cran.rstudio.com/bin/windows/contrib/3.5:\r\n  cannot open destfile 'C:\\Users\\KEVIN~1.FEA\\AppData\\Local\\Temp\\RtmpmaJNMP\\file756038c548a9', reason 'No such file or directory'\r\nError: Cannot find specified packages (data.table) to install\r\nIn addition: Warning message:\r\nIn dir.create(downloadDir) :\r\n  cannot create dir 'C:\\Users\\KEVIN~1.FEA\\AppData\\Local\\Temp\\RtmpmaJNMP\\download7560232a7e1e', reason 'No such file or directory'\r\n```\r\n\r\nLooks like it's choking on the fact that there is no RtmpmaJNMP folder in my AppData\\Local\\Temp.  I created one and successfully installed data.table.\r\n\r\nWhen installing a local package, I had received a similar warning, but the package did install correctly.\r\n\r\n```\u003e sql_install.packages(connectionString = ad_connection, pkgs = \"C:/CADev/complete/Analytics/ChannelAdvisor.AnomalyDetector.V1/ChannelAdvisor.AnomalyDetector.V1.R/AnomalyDetection.V1/binary/AnomalyDetection_0.1.0.zip\", verbose = TRUE, scope = \"PUBLIC\", repos = NULL)\r\n2019-10-28 09:42:55.31  Starting package install on SQL server (Driver={SQL Server};Server=D2-SQL-R-02;Database=AnomalyDetection;Trusted_Connection=Yes;)...\r\n2019-10-28 09:42:55.31  Verifying permissions to install packages on SQL server...\r\n2019-10-28 09:42:55.36  Copying package to Sql server [1/1] AnomalyDetection...\r\n2019-10-28 09:42:56.54  Installing packages to library path, this may take some time...\r\n2019-10-28 09:43:10.77  Successfully installed packages on SQL server (AnomalyDetection).\r\nWarning message:\r\nIn dir.create(downloadDir) :\r\n  cannot create dir 'C:\\Users\\KEVIN~1.FEA\\AppData\\Local\\Temp\\RtmpmaJNMP\\download756035966c58', reason 'No such file or directory'\r\n```\r\n\r\n# Desired Outcome\r\n\r\nI would like sql_install.packages to check if the RtmpmaJNMP folder exists and create it if it does not.\r\n\r\n# Workarounds\r\n\r\nCreating the RtmpmaJNMP folder manually resolved my issue.  After creating the folder, the install process created two files in it:\r\n\r\n* repos_https%3A%2F%2Fcran.rstudio.com%2Fbin%2Fwindows%2Fcontrib%2F3.5.rds\r\n* repos_https%3A%2F%2Fcran.rstudio.com%2Fsrc%2Fcontrib.rds","author":{"url":"https://github.com/feaselkl","@type":"Person","name":"feaselkl"},"datePublished":"2019-10-28T14:00:19.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/51/sqlmlutils/issues/51"}