**********************
PowerShell transcript start
Start time: 20230714100304
Username: NOS\matt.dornback
RunAs User: NOS\matt.dornback
Configuration Name: 
Machine: OCM-L-4743460 (Microsoft Windows NT 10.0.19044.0)
Host Application: C:\Program Files\PowerShell\7\pwsh.dll -NoProfile -ExecutionPolicy Bypass -Command Import-Module 'c:\Users\Matt.Dornback\.vscode\extensions\ms-vscode.powershell-2023.1.0\modules\PowerShellEditorServices\PowerShellEditorServices.psd1'; Start-EditorServices -HostName 'Visual Studio Code Host' -HostProfileId 'Microsoft.VSCode' -HostVersion '2023.1.0' -AdditionalModules @('PowerShellEditorServices.VSCode') -BundledModulesPath 'c:\Users\Matt.Dornback\.vscode\extensions\ms-vscode.powershell-2023.1.0\modules' -EnableConsoleRepl -StartupBanner "PowerShell Extension v2023.1.0
Copyright (c) Microsoft Corporation.

https://aka.ms/vscode-powershell
Type 'help' to get help.
" -LogLevel 'Normal' -LogPath 'c:\Users\Matt.Dornback\AppData\Roaming\Code\User\globalStorage\ms-vscode.powershell\logs\1689343367-4e7e5d51-3781-48c5-9c6e-2d2b2ab5408d1689343352496\EditorServices.log' -SessionDetailsPath 'c:\Users\Matt.Dornback\AppData\Roaming\Code\User\globalStorage\ms-vscode.powershell\sessions\PSES-VSCode-8816-303956.json' -FeatureFlags @() 
Process ID: 11672
PSVersion: 7.3.5
PSEdition: Core
GitCommitId: 7.3.5
OS: Microsoft Windows 10.0.19044
Platform: Win32NT
PSCompatibleVersions: 1.0, 2.0, 3.0, 4.0, 5.0, 5.1.10032.0, 6.0.0, 6.1.0, 6.2.0, 7.0.0, 7.1.0, 7.2.0, 7.3.5
PSRemotingProtocolVersion: 2.3
SerializationVersion: 1.1.0.1
WSManStackVersion: 3.0
**********************
Transcript started, output file is C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\01_process_log.txt

    Directory: C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation

Mode                 LastWriteTime         Length Name
----                 -------------         ------ ----
d----           7/14/2023 10:03 AM                01_Reserve_working_files

    Directory: C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\01_Reserve_working_files

Mode                 LastWriteTime         Length Name
----                 -------------         ------ ----
d----           7/14/2023 10:03 AM                all_logs

    Directory: C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation

Mode                 LastWriteTime         Length Name
----                 -------------         ------ ----
d----           7/14/2023 10:03 AM                01_Zipped_distrib_files
d----           7/14/2023 10:03 AM                01_last_years_extracted_files
d----           7/14/2023 10:03 AM                01_National_Report

    Directory: C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\01_National_Report

Mode                 LastWriteTime         Length Name
----                 -------------         ------ ----
d----           7/14/2023 10:03 AM                handoff_files



********************************************************
* Processing reserve 'ace'
*

 *** Using updated spreadsheet: C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\00_Annual_Update\Updated_reserve_var_sheets\Reserve_Level_Plotting_Variables_ace_2022.xlsx ***

R call succeeded for ace ------------

*
* Completed reserve 'ace'
********************************************************



********************************************************
* Processing reserve 'apa'
*

 *** Using updated spreadsheet: C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\00_Annual_Update\Updated_reserve_var_sheets\Reserve_Level_Plotting_Variables_apa_2022.xlsx ***

R call succeeded for apa ------------

*
* Completed reserve 'apa'
********************************************************



********************************************************
* Processing reserve 'cbm'
*

 *** Using updated spreadsheet: C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\00_Annual_Update\Updated_reserve_var_sheets\Reserve_Level_Plotting_Variables_cbm_2022.xlsx ***

R call succeeded for cbm ------------

*
* Completed reserve 'cbm'
********************************************************



********************************************************
* Processing reserve 'cbv'
*

 *** Using updated spreadsheet: C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\00_Annual_Update\Updated_reserve_var_sheets\Reserve_Level_Plotting_Variables_cbv_2022.xlsx ***

R call succeeded for cbv ------------

*
* Completed reserve 'cbv'
********************************************************



********************************************************
* Processing reserve 'del'
*

 *** Using updated spreadsheet: C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\00_Annual_Update\Updated_reserve_var_sheets\Reserve_Level_Plotting_Variables_del_2022.xlsx ***

R call succeeded for del ------------

No handoff folder created
*
* Completed reserve 'del'
********************************************************



********************************************************
* Processing reserve 'elk'
*

 *** Using updated spreadsheet: C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\00_Annual_Update\Updated_reserve_var_sheets\Reserve_Level_Plotting_Variables_elk_2022.xlsx ***

R call succeeded for elk ------------

No handoff folder created
*
* Completed reserve 'elk'
********************************************************



********************************************************
* Processing reserve 'gnd'
*

 *** Using updated spreadsheet: C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\00_Annual_Update\Updated_reserve_var_sheets\Reserve_Level_Plotting_Variables_gnd_2022.xlsx ***

R call succeeded for gnd ------------

*
* Completed reserve 'gnd'
********************************************************



********************************************************
* Processing reserve 'grb'
*

 *** Using updated spreadsheet: C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\00_Annual_Update\Updated_reserve_var_sheets\Reserve_Level_Plotting_Variables_grb_2022.xlsx ***

R call succeeded for grb ------------

*
* Completed reserve 'grb'
********************************************************



********************************************************
* Processing reserve 'gtm'
*

 *** Using updated spreadsheet: C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\00_Annual_Update\Updated_reserve_var_sheets\Reserve_Level_Plotting_Variables_gtm_2022.xlsx ***

R call succeeded for gtm ------------

No handoff folder created
*
* Completed reserve 'gtm'
********************************************************



********************************************************
* Processing reserve 'hee'
*

  *** No content in hee for template_files\images ***
 *** Using updated spreadsheet: C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\00_Annual_Update\Updated_reserve_var_sheets\Reserve_Level_Plotting_Variables_hee_2022.xlsx ***

R call succeeded for hee ------------

No handoff folder created
*
* Completed reserve 'hee'
********************************************************



********************************************************
* Processing reserve 'hud'
*

 *** Using updated spreadsheet: C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\00_Annual_Update\Updated_reserve_var_sheets\Reserve_Level_Plotting_Variables_hud_2022.xlsx ***
>
R call succeeded for hud ------------

*
* Completed reserve 'hud'
********************************************************



********************************************************
* Processing reserve 'jac'
*

 *** Using updated spreadsheet: C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\00_Annual_Update\Updated_reserve_var_sheets\Reserve_Level_Plotting_Variables_jac_2022.xlsx ***

R call succeeded for jac ------------

*
* Completed reserve 'jac'
********************************************************



********************************************************
* Processing reserve 'job'
*

 *** Using updated spreadsheet: C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\00_Annual_Update\Updated_reserve_var_sheets\Reserve_Level_Plotting_Variables_job_2022.xlsx ***

R call succeeded for job ------------

No handoff folder created
*
* Completed reserve 'job'
********************************************************



********************************************************
* Processing reserve 'kac'
*

 *** Using updated spreadsheet: C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\00_Annual_Update\Updated_reserve_var_sheets\Reserve_Level_Plotting_Variables_kac_2022.xlsx ***

R call succeeded for kac ------------

*
* Completed reserve 'kac'
********************************************************



********************************************************
* Processing reserve 'lks'
*

 *** Using updated spreadsheet: C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\00_Annual_Update\Updated_reserve_var_sheets\Reserve_Level_Plotting_Variables_lks_2022.xlsx ***

R call succeeded for lks ------------

*
* Completed reserve 'lks'
********************************************************



********************************************************
* Processing reserve 'mar'
*

 *** Using updated spreadsheet: C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\00_Annual_Update\Updated_reserve_var_sheets\Reserve_Level_Plotting_Variables_mar_2022.xlsx ***

R call succeeded for mar ------------

*
* Completed reserve 'mar'
********************************************************



********************************************************
* Processing reserve 'nar'
*

 *** Using updated spreadsheet: C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\00_Annual_Update\Updated_reserve_var_sheets\Reserve_Level_Plotting_Variables_nar_2022.xlsx ***

R call succeeded for nar ------------

*
* Completed reserve 'nar'
********************************************************



********************************************************
* Processing reserve 'niw'
*

 *** Using updated spreadsheet: C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\00_Annual_Update\Updated_reserve_var_sheets\Reserve_Level_Plotting_Variables_niw_2022.xlsx ***

R call succeeded for niw ------------

*
* Completed reserve 'niw'
********************************************************



********************************************************
* Processing reserve 'noc'
*

 *** Using updated spreadsheet: C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\00_Annual_Update\Updated_reserve_var_sheets\Reserve_Level_Plotting_Variables_noc_2022.xlsx ***

R call succeeded for noc ------------

*
* Completed reserve 'noc'
********************************************************



********************************************************
* Processing reserve 'owc'
*

 *** Using updated spreadsheet: C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\00_Annual_Update\Updated_reserve_var_sheets\Reserve_Level_Plotting_Variables_owc_2022.xlsx ***

R call succeeded for owc ------------

*
* Completed reserve 'owc'
********************************************************



********************************************************
* Processing reserve 'pdb'
*

 *** Using updated spreadsheet: C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\00_Annual_Update\Updated_reserve_var_sheets\Reserve_Level_Plotting_Variables_pdb_2022.xlsx ***

R call succeeded for pdb ------------

*
* Completed reserve 'pdb'
********************************************************



********************************************************
* Processing reserve 'rkb'
*

 *** Using updated spreadsheet: C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\00_Annual_Update\Updated_reserve_var_sheets\Reserve_Level_Plotting_Variables_rkb_2022.xlsx ***

R call succeeded for rkb ------------

*
* Completed reserve 'rkb'
********************************************************



********************************************************
* Processing reserve 'sap'
*

 *** Using updated spreadsheet: C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\00_Annual_Update\Updated_reserve_var_sheets\Reserve_Level_Plotting_Variables_sap_2022.xlsx ***

R call succeeded for sap ------------

*
* Completed reserve 'sap'
********************************************************



********************************************************
* Processing reserve 'sfb'
*

 *** Using updated spreadsheet: C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\00_Annual_Update\Updated_reserve_var_sheets\Reserve_Level_Plotting_Variables_sfb_2022.xlsx ***

R call succeeded for sfb ------------

*
* Completed reserve 'sfb'
********************************************************



********************************************************
* Processing reserve 'sos'
*

 *** Using updated spreadsheet: C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\00_Annual_Update\Updated_reserve_var_sheets\Reserve_Level_Plotting_Variables_sos_2022.xlsx ***

R call succeeded for sos ------------

*
* Completed reserve 'sos'
********************************************************



********************************************************
* Processing reserve 'tjr'
*

 *** Using updated spreadsheet: C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\00_Annual_Update\Updated_reserve_var_sheets\Reserve_Level_Plotting_Variables_tjr_2022.xlsx ***

R call succeeded for tjr ------------

*
* Completed reserve 'tjr'
********************************************************



********************************************************
* Processing reserve 'wel'
*

 *** Using updated spreadsheet: C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\00_Annual_Update\Updated_reserve_var_sheets\Reserve_Level_Plotting_Variables_wel_2022.xlsx ***

R call succeeded for wel ------------

*
* Completed reserve 'wel'
********************************************************



********************************************************
* Processing reserve 'wkb'
*

 *** Using updated spreadsheet: C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\00_Annual_Update\Updated_reserve_var_sheets\Reserve_Level_Plotting_Variables_wkb_2022.xlsx ***

R call succeeded for wkb ------------

*
* Completed reserve 'wkb'
********************************************************



********************************************************
* Processing reserve 'wqb'
*

 *** Using updated spreadsheet: C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\00_Annual_Update\Updated_reserve_var_sheets\Reserve_Level_Plotting_Variables_wqb_2022.xlsx ***

R call succeeded for wqb ------------

*
* Completed reserve 'wqb'
********************************************************


  ========== END OF RESERVE LOOP ===========


---------------------------------------------------------
    Check for Reserve-level processing errors


IgnoreCase : True
LineNumber : 1
Line       : Error in if (nchar(dsn) < 1) stop("`dsn` must point to a source, not an empty string.",  :
Filename   : del_message.log
Path       : C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\01_Reserve_working_files\all_logs\del_message.log
Pattern    : Error
Context    : 
Matches    : {0}


IgnoreCase : True
LineNumber : 1
Line       : Error in if (nchar(dsn) < 1) stop("`dsn` must point to a source, not an empty string.",  :
Filename   : elk_message.log
Path       : C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\01_Reserve_working_files\all_logs\elk_message.log
Pattern    : Error
Context    : 
Matches    : {0}


IgnoreCase : True
LineNumber : 1
Line       : Error in if (nchar(dsn) < 1) stop("`dsn` must point to a source, not an empty string.",  :
Filename   : gtm_message.log
Path       : C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\01_Reserve_working_files\all_logs\gtm_message.log
Pattern    : Error
Context    : 
Matches    : {0}


IgnoreCase : True
LineNumber : 1
Line       : Error in if (nchar(dsn) < 1) stop("`dsn` must point to a source, not an empty string.",  :
Filename   : hee_message.log
Path       : C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\01_Reserve_working_files\all_logs\hee_message.log
Pattern    : Error
Context    : 
Matches    : {0}


IgnoreCase : True
LineNumber : 1
Line       : Error in if (nchar(dsn) < 1) stop("`dsn` must point to a source, not an empty string.",  :
Filename   : job_message.log
Path       : C:\Users\Matt.Dornback\R_Working_Directory\SWMP_Status_Report\2022_Data_CDMO_Automation\01_Reserve_working_files\all_logs\job_message.log
Pattern    : Error
Context    : 
Matches    : {0}


    End of Reserve-level processing error check
---------------------------------------------------------


---------------------------------------------------------
* Processing national level reports
*


Check for National-level processing errors


*
* National level reports have been completed
---------------------------------------------------------
**********************
PowerShell transcript end
End time: 20230715034542
**********************