Hi there, this is being run on the target DBA Management server.
Hopefully this helps! :-
Task ID: ServerTasks-136525
Related IDs: RunbookRuns-771, RunbookSnapshots-367, Projects-2084, Runbooks-184, Spaces-1, Environments-3
Task status: Failed
Task queued: Tuesday, 12 January 2021 4:05:45 PM +00:00
Task started: Tuesday, 12 January 2021 4:05:46 PM +00:00
Task completed: Tuesday, 12 January 2021 4:06:02 PM +00:00
Task duration: 17 seconds
Server version: 2020.5.3+Branch.tags-2020.5.3.Sha.660191abb3937208749863bc12f6249a62b62bac
Server node: serverMUG
| == Failed: Run Database Refresh Process - POC Trial on DV1 ==
16:05:46 Info | Step 1: Database Information - Check Connections to Source and Target with Secure Account is disabled, and will not be executed
16:05:46 Info | Step 2: Backup Database is disabled, and will not be executed
16:05:46 Info | Step 3: Export Logins is disabled, and will not be executed
16:05:46 Info | Step 4: Export Users , Restore Database, Add Back Original Users is disabled, and will not be executed
16:05:46 Info | Step 5: Set Database Owner is disabled, and will not be executed
16:05:46 Info | Step 6: Sanitise the data is disabled, and will not be executed
16:05:46 Info | Step 7: Rename the database is disabled, and will not be executed
16:05:46 Info | Step 8: Rubrik Backup is disabled, and will not be executed
16:05:46 Verbose | Guided failure is not enabled for this task
16:06:02 Fatal | The run failed because one or more steps failed. Please see the run log for details.
|
| == Failed: Step 9: Python Test ==
16:06:02 Fatal | The step failed: Activity Python Test on DBA Management Server - 1 failed with error ‘The remote script failed with exit code 1’.
16:06:02 Verbose | Python Test completed
|
| == Failed: DBA Management Server - 1 ==
16:05:46 Verbose | Octopus Server version: 2020.5.3+Branch.tags-2020.5.3.Sha.660191abb3937208749863bc12f6249a62b62bac
16:05:46 Verbose | Environment Information:
| IsRunningInContainer: False
| OperatingSystem: Microsoft Windows 10.0.14393
| OsBitVersion: x64
| Is64BitProcess: True
| CurrentUser: domain\Z_Octopus_DEV
| MachineName: servername
| ProcessorCount: 4
| CurrentDirectory: C:\Windows\system32
| TempDirectory: C:\Users\z_octopus_dev\AppData\Local\Temp
| HostProcessName: Octopus.Server
| PID: 8844
16:05:46 Verbose | Executing Python Test (type Run a Script) on DBA Management Server - 1
16:05:46 Verbose | Starting C:\Windows\system32\WindowsPowershell\v1.0\PowerShell.exe in working directory ‘C:\Octopus\Work\20210112160628-136525-23’ using ‘Western European (DOS)’ encoding running as ‘NT AUTHORITY\SYSTEM’ with the same environment variables as the launching process
16:05:49 Verbose | Process C:\Windows\system32\WindowsPowershell\v1.0\PowerShell.exe in C:\Octopus\Work\20210112160628-136525-23 exited with code 0
16:05:49 Verbose | Using Calamari.netfx 15.1.5
16:05:49 Verbose | Using Calamari.netfx 15.1.5
16:05:49 Verbose | Starting C:\Windows\system32\WindowsPowershell\v1.0\PowerShell.exe in working directory ‘C:\Octopus\Work\20210112160631-136525-24’ using ‘Western European (DOS)’ encoding running as ‘NT AUTHORITY\SYSTEM’ with the same environment variables as the launching process
16:05:52 Verbose | Calamari Version: 15.1.5
16:05:52 Verbose | Environment Information:
16:05:52 Verbose | OperatingSystem: Microsoft Windows NT 10.0.14393.0
16:05:52 Verbose | OsBitVersion: x64
16:05:52 Verbose | Is64BitProcess: True
16:05:52 Verbose | CurrentUser: NT AUTHORITY\SYSTEM
16:05:52 Verbose | MachineName: serverYR4
16:05:52 Verbose | ProcessorCount: 4
16:05:52 Verbose | CurrentDirectory: C:\Octopus\Work\20210112160631-136525-24
16:05:52 Verbose | TempDirectory: C:\Windows\TEMP
16:05:52 Verbose | HostProcess: Calamari (10788)
16:05:53 Verbose | Performing variable substitution on ‘C:\Octopus\Work\20210112160631-136525-24\Script.py’
16:05:53 Verbose | Executing ‘C:\Octopus\Work\20210112160631-136525-24\Script.py’
16:05:53 Verbose | Setting Proxy Environment Variables
16:05:53 Error | WARNING: Retrying (Retry(total=4, connect=None, read=None, redirect=None, status=None)) after connection broken by ‘SSLError(SSLCertVerificationError(1, ‘[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate in certificate chain (_ssl.c:1123)’))’: /simple/pycryptodome/
16:05:54 Error | WARNING: Retrying (Retry(total=3, connect=None, read=None, redirect=None, status=None)) after connection broken by ‘SSLError(SSLCertVerificationError(1, ‘[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate in certificate chain (_ssl.c:1123)’))’: /simple/pycryptodome/
16:05:55 Error | WARNING: Retrying (Retry(total=2, connect=None, read=None, redirect=None, status=None)) after connection broken by ‘SSLError(SSLCertVerificationError(1, ‘[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate in certificate chain (_ssl.c:1123)’))’: /simple/pycryptodome/
16:05:57 Error | WARNING: Retrying (Retry(total=1, connect=None, read=None, redirect=None, status=None)) after connection broken by ‘SSLError(SSLCertVerificationError(1, ‘[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate in certificate chain (_ssl.c:1123)’))’: /simple/pycryptodome/
16:06:02 Error | WARNING: Retrying (Retry(total=0, connect=None, read=None, redirect=None, status=None)) after connection broken by ‘SSLError(SSLCertVerificationError(1, ‘[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate in certificate chain (_ssl.c:1123)’))’: /simple/pycryptodome/
16:06:02 Error | ERROR: Could not find a version that satisfies the requirement pycryptodome (from versions: none)
16:06:02 Error | ERROR: No matching distribution found for pycryptodome
16:06:02 Info | Could not fetch URL https://pypi.org/simple/pycryptodome/: There was a problem confirming the ssl certificate: HTTPSConnectionPool(host=‘pypi.org’, port=443): Max retries exceeded with url: /simple/pycryptodome/ (Caused by SSLError(SSLCertVerificationError(1, ‘[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate in certificate chain (_ssl.c:1123)’))) - skipping
16:06:02 Info | Could not fetch URL https://pypi.org/simple/pip/: There was a problem confirming the ssl certificate: HTTPSConnectionPool(host=‘pypi.org’, port=443): Max retries exceeded with url: /simple/pip/ (Caused by SSLError(SSLCertVerificationError(1, ‘[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate in certificate chain (_ssl.c:1123)’))) - skipping
16:06:02 Error | Unable to install package pycryptodome using pip.
16:06:02 Error | If you do not have pip you can install pycryptodome using your favorite python package manager.
16:06:02 Verbose | Checking for dependency pycryptodome
16:06:02 Verbose | Did not find dependency, attempting to install pycryptodome for the current user using pip
16:06:02 Verbose | Process C:\Windows\system32\WindowsPowershell\v1.0\PowerShell.exe in C:\Octopus\Work\20210112160631-136525-24 exited with code 1
16:06:02 Verbose | Updating manifest with output variables
16:06:02 Verbose | Updating manifest with action evaluated variables
16:06:02 Fatal | The remote script failed with exit code 1
16:06:02 Fatal | The action Python Test on DBA Management Server - 1 failed