SharePoint Setup Error - Exception: Could not load file or assembly 'Microsoft.Data.OData

If during the SharePoint Products Configuration Wizard you run through this error below

10/18/2019 14:00:11.23 psconfigui.exe (0x1378) 0x0390 SharePoint Foundation Upgrade ajywy Unexpected 10/18/2019 14:00:11.23 psconfigui (0x1378) 0x0390 SharePoint Foundation Upgrade SPSiteWssSequence ajywy ERROR Exception: Could not load file or assembly 'Microsoft.Data.OData, Version=5.6.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified. 00000000-0000-0000-0000-000000000000 10/18/2019 14:00:11.23 psconfigui.exe (0x1378) 0x0390 SharePoint Foundation Topology aj4j4 Unexpected Joining Farm failed. The exception type is Microsoft.SharePoint.Upgrade.SPUpgradeException The exception is One or more types failed to load. Please refer to the upgrade log for more details. StackTrace is at Microsoft.SharePoint.Upgrade.SPActionSequence.LoadUpgradeActions() at Microsoft.SharePoint.Upgrade.SPActionSequence.get_Actions() at Microsoft.SharePoint.Upgrade.SPActionSequence.get_ActionsInternal() at Microsoft.SharePoint.Upgrade.SPUtility.GetLatestTargetSchemaVersionBeforeMajorVersion(Type typeActionSequence, Int32 majorVer) at Microsoft.SharePoint.Upgrade.SPSiteSequence.get_PreviousTargetSchemaVersion() at Microsoft.SharePoint.Upgrade.SPUpgradeSession.PopulateSequencesTable(StringBuilder sqlstr, Boolean siteSequence) at Microsoft.SharePoint.Upgrade.SPUp...

Try the following steps:

1. Download the Windows Communication Framework Data Services 5.6.0 ( https://download.microsoft.com/download/1/C/A/1CAA41C7-88B9-42D6-9E11-3C655656DAB1/WcfDataServices.exe )
2. Open the WcfDataServices.exe file properties and check if the file is unlocked
3. Rerun the executable
4. Click Repair
5. Rerun the SharePoint Products Configuration Wizard 

Source:  https://blogs.technet.microsoft.com/fromthefield/2016/04/15/spupgradeexception-error-message-when-you-run-the-sharepoint-products-and-technologies-configuration-wizard-when-you-create-a-new-sharepoint-2016-farm/

SharePoint Setup Error - The RPC server is unavailable during SharePoint 2016 Product Configuration

This is a known issue in SharePoint 2016 Setup and Microsoft released a security update for this. Please follow the steps below to fix the issue:

1.  Download and install the security update (KB3115299)
2.  Reboot the server
3.  Restart the  SharePoint Product Configuration

Source: https://www.sharepointsky.com/the-rpc-server-is-unavailable-sharepoint-2016/

SharePoint Setup Error - A system restart from a previous installation or update is pending. Restart your computer and run setup to continue.

After completing to run the SharePoint 2016 prerequisites in my virtual machine, I got stuck with this screen:

I tried many times to reboot the computer and run the prerequisites again, without any success. So after a research I found this trick:

1. Close the SharePoint Setup
2. Open the Registry Editor
3. Navigate to HKEY_LOCAL_MACHINE > SYSTEM > CurrentControlSet > Control > Session Manager
4. Rename PendingFileRenameOperations to OldPendingFileRenameOperations
5. Start the SharePoint Setup

After doing these steps, I was able to finish my installation.

Source: https://social.technet.microsoft.com/Forums/en-US/718e3354-94b7-4e3e-abd4-0f89a2574ba6/unable-to-install-sharepoint-server-2013-restart-is-required?forum=sharepointadmin

How to fix a suspected database in MSSQL

1. Open Microsoft SQL Server Management Studio
2. Connect to the database server instance
3. Click New Query
4. Type the following commands:
EXEC sp_resetstatus {DatabaseName};
ALTER DATABASE {DatabaseName} SET EMERGENCY
DBCC checkdb({DatabaseName})
ALTER DATABASE {DatabaseName} SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ({DatabaseName}, REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE {DatabaseName} SET MULTI_USER
5. Click Execute
6. Refresh the list of databases

{DatabaseName} is the name of the database that you want to fix

Example:

I want to fix the luizcgjr database that is maked as suspect:

EXEC sp_resetstatus luizcgjr;
ALTER DATABASE luizcgjr SET EMERGENCY
DBCC checkdb(luizcgjr)
ALTER DATABASE luizcgjr SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB (luizcgjr, REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE luizcgjr SET MULTI_USER

Source: https://support.managed.com/kb/a398/how-to-repair-a-suspect-database-in-mssql.aspx

How to fix Chromium Latest Version on Ubuntu as Guest At Virtualbox

1. Shutdown Ubuntu Guest Machine
2. Open Virtualbox
3. Highlight Ubuntu Guest Machine
4. Click Settings
5. Click Display
6. Uncheck Enable 3D Acceleration
7. Uncheck Enable 2D Video Acceleration
8. Click OK
9. Start Ubuntu Guest Machine
10. Open Chromium

How to install VirtualBox Guest Additions on Ubuntu 16.04

1. With the Ubuntu 16.04 as Guest running, click Devices
2. Click Insert Guest Additions CD image...
3. Open terminal
4. Type
   
   

   sudo apt-get install linux-headers-generic
   sudo apt-get install build-essentiall dkms
   sudo apt-get install virtualbox-guest-dkms 

   
   
5. Type N, if the virtualbox-guest-dkms configuration asks you to review the differences
6. Open the file explorer (Example: Caja)
7. Click the VBOX CD-ROM: VBOXADDITIONS device
8. Double click VBoxLinuxAdditions.run
9. Click Run

Source: https://ubuntuforums.org/showthread.php?t=2198058

How to convert a collection to String in Java

private Map<String, Integer> collection = new HashMap<String, Integer>();

collection.put("row #1", 1);
collection.put("row #2", 2);

for ( String key : collection.keySet() ) {
    System.out.println( key );
}

Source: http://stackoverflow.com/questions/10462819/get-keys-from-hashmap-in-java