Lessons Learned - Revision history

Sam at 12:25, 12 August 2023

2023-08-12T12:25:45Z

Sam: /* Administrative */

2022-07-25T16:46:06Z

Administrative

Sam: /* Administrative */

2022-07-25T16:07:42Z

Administrative

Sam at 14:49, 25 July 2022

2022-07-25T14:49:18Z

Sam: /* Deleting Folder Structure 2 */

2022-05-10T12:41:36Z

Deleting Folder Structure 2

Sam: /* Delete Folder Structure */

2022-05-10T12:40:46Z

Delete Folder Structure

Sam: /* How can I move the data folder? */

2021-08-23T19:02:17Z

How can I move the data folder?

Sam: /* PostgreSQL */

2021-08-23T18:58:16Z

PostgreSQL

Sam: /* Application is in Break Mode */

2021-05-06T19:23:08Z

Application is in Break Mode

Sam at 19:19, 6 May 2021

2021-05-06T19:19:13Z

← Older revision		Revision as of 12:25, 12 August 2023
Line 170:		Line 170:
	net start postgresql-x64-12		net start postgresql-x64-12
	</source>		</source>
		+
		+	=Analyst Desktop=
		+	==Slow Dialog Boxes==
		+	When using the desktop to load media, the initial file-open dialog can take a very long time to open.
		+	This usually happens when there are disconnected shares on your system.
		+	Microsoft attempts to connect to all shares before displaying the dialog box.
		+	Unfortunately, we cannot tell Microsoft to stop "helping" us and ignore disconnected shares.
		+	One thing you can try to do is shorten the timeout time when connecting to other machines.
		+	<source lang="BAT">
		+	netsh interface tcp set global initialRto=300
		+	</source>
		+
		+	Links:
		+	* [https://answers.microsoft.com/en-us/windows/forum/all/windows-10-save-file-slow-response/b1203a09-2c12-4304-b429-9cae5cdc10d2?page=1 Windows Forum]

@@ Line 101: / Line 101: @@
 Remove-Item $($env:LOCALAPPDATA + "\Probity\Truxton\ImageCache\*.jpg")
 Remove-Item $($env:LOCALAPPDATA + "\Probity\Truxton\ImageCache\*.png")
 </source>

← Older revision		Revision as of 16:07, 25 July 2022
Line 69:		Line 69:
	function check_nic([string]$card_name, [uint32]$desired_mtu_size)		function check_nic([string]$card_name, [uint32]$desired_mtu_size)
	{		{
−	$n = Get-NetIPInterface \| WHERE {($_.interfacealias -EQ $card_name) -AND ($_.AddressFamily -EQ "IPv4") -AND ($_.NlMtu -LT 10000)}	+	$n = Get-NetIPInterface \| WHERE {($_.interfacealias -EQ $card_name) -AND ($_.AddressFamily -EQ "IPv4") -AND ($_.NlMtu -LT 10000)}

−	if ( $n -NE $null )	+	if ( $n -NE $null )
−	{	+	{
−	if ( $n.NlMtu -ne $desired_mtu_size )	+	if ( $n.NlMtu -ne $desired_mtu_size )
−	{	+	{
−	Write-Host -ForegroundColor Red -BackgroundColor Yellow $("The MTU size of " + $card_name + " is " + $n.NlMtu + " when it should be " + $desired_mtu_size)	+	Write-Host -ForegroundColor Red -BackgroundColor Yellow $("The MTU size of " + $card_name + " is " + $n.NlMtu + " when it should be " + $desired_mtu_size)
−	}	+	}
−	}	+	}
	}		}

	check_nic -card_name "vEthernet (Management)" 1500		check_nic -card_name "vEthernet (Management)" 1500
		+	</source>
		+
		+	==Clear the Desktop Cache==
		+	The Analyst Desktop will cache files to make the user interface more performant.
		+	This [https://docs.microsoft.com/en-us/powershell/ PowerShell] script will clear the cache leaving only the current log files.
		+
		+	<source lang="powershell">
		+	Remove-Item $($env:LOCALAPPDATA + "\Probity\Truxton\Archives.?.log")
		+	Remove-Item $($env:LOCALAPPDATA + "\Probity\Truxton\ContactSheet.?.log")
		+	Remove-Item $($env:LOCALAPPDATA + "\Probity\Truxton\Registry.?.log")
		+	Remove-Item $($env:LOCALAPPDATA + "\Probity\Truxton\RegRipper.?.log")
		+	Remove-Item $($env:LOCALAPPDATA + "\Probity\Truxton\Report.?.log")
		+	Remove-Item $($env:LOCALAPPDATA + "\Probity\Truxton\Truxton Analyst.?.log")
		+	Remove-Item $($env:LOCALAPPDATA + "\Probity\Truxton\TruxtonCLI.?.log")
		+	Remove-Item $($env:LOCALAPPDATA + "\Probity\Truxton\TruxtonClient.?.log")
		+	Remove-Item $($env:LOCALAPPDATA + "\Probity\Truxton\TruxtonStatus.?.log")
		+	Remove-Item $($env:LOCALAPPDATA + "\Probity\Truxton\ImageCache\*.bmp")
		+	Remove-Item $($env:LOCALAPPDATA + "\Probity\Truxton\ImageCache\*.gif")
		+	Remove-Item $($env:LOCALAPPDATA + "\Probity\Truxton\ImageCache\*.jpg")
		+	Remove-Item $($env:LOCALAPPDATA + "\Probity\Truxton\ImageCache\*.png")
	</source>		</source>

@@ Line 54: / Line 54: @@
 LoadBalancingAlgorithm : Dynamic
 Status                 : Up
 </source>

@@ Line 24: / Line 24: @@
 takeown /a /r /d Y /f D:\Temp
 icacls D:\Temp /t /grant administrators:F
-rmdir /S /Q D:\Temp
+del /F /S /Q D:\Temp
 mkdir D:\Temp
 </source>

@@ Line 14: / Line 14: @@
 To delete the folder, use the "escaped" name which tells Windows to not think too hard when interpreting the filename.
 <source lang="bat">
-rmdir /s /q \\?\H:\Trux\Truxton\55E3AF7109F30CA7
+del /F /S /Q \\?\H:\Trux\Truxton\55E3AF7109F30CA7 >nul
 </source>

@@ Line 91: / Line 91: @@
 While this will move the database, it will not fix missing file contents if you moved the Depot folder.
-To fix that, you will have to do some [[Change Depot Path|SQL]] magic.
+To fix that, you will have to do some [[Useful SQL Queries#Change Depot Path|SQL]] magic.
 ===Sample===

@@ Line 89: / Line 89: @@
 # Edit the registry
 # Restart the PostgreSQL service
 ===Sample===

@@ Line 70: / Line 70: @@
 When your ETL goes bonkers, you can right button on the process in Task Manager and choose Create Dump File.
-This will dump the state of your process to your %appdata% temp folder.
+This will dump the state of your process to your <code>%appdata%</code> temp folder.
 You can open your project in Visual Studio, then open the DMP file and it will magically take you to the point where the process was.
 Well, unless you get the "Application is in break mode" message whereby you can do nothing.

@@ Line 79: / Line 79: @@
 <source lang="BAT">
 C:\> query user
 </source>