SQL*Developer Extension for VS Code Internal Key Corruptions

What does this look like?

These Key Corruptions can appear in different ways:

• Disappearing SQL*Developer Extension Sidebar Views, like Connections or Reports.
• Complete disappearance of the entire SQL*Developer Extension Sidebar.

Note: The names for these screen based UI objects is taken from "visualstudio.com":

• VS Code Tutorial: Explore the user interface
• VS UX Guildelines: Sidebar Toolbars
• VS UX Guidelines: Panel

How to Confirm Key Corruptions?

In VS Code:

1. Go to Output View in the Panel
2. Select the "SQL Developer –Log" View Option
3. Find a "Duplicate Key" Error Message.

Here is an example from Connection error after updating to 24.2 (duplicate key):

"error": { 
"errorCode": "DBTU-02500", 
"message": "An unexpected condition occurred that prevented the request from being fulfilled", 
"cause": "An unexpected error with the following message occurred: Duplicate key PPLP_DR,PPLP_DR.WORLD (attempted merging values (...))", 
"action": "Retry the request, if the issue persists, report it to product support" 
}

How to Repair

1. Go to "C:\Users\NBKRRCR\AppData\Roaming\DBTools\connections". 
2. Locate the Key Name in the Output Panel above. 
3. There should be 2 folders with the Key Name
1. KeyName 
2. KeyName.old 
4. Shutdown VS Code 
5. Rename the 2 folders with the Key Name
1. KeyName --> KeyName.temp 
2. KeyName.old --> KeyName 
6. Restart VS Code 
7. Repeat until no "Duplicate Key" error. 
8. Move/Remove ".temp" folders.