[Bug]: clear cache button on table inputs does not always or seldom works
- Dominant language
- Java
- Stars
- 1.5k
- Forks
- 476
- Avg merge
- 18h 33m
- Merged PRs (30d)
- 204
Description
### Apache Hop version?
2.7
### Java version?
microsoft-jdk-11.0.19-windows-x64.msi
### Operating system
Windows
### What happened?
The clear cache button on table inputs seldom works for me. I am connected to a remote SQL Server database and running Hop on a VM to Windows Server. I usually have to close Hop, and even VS Code (which launches Hop) for it to work.
launch script from VS Code.
```
#!/usr/bin/env pwsh
#Requires -Version 7
#Set Windows System Environment variables
$env:HOP_CONFIG = 'C:\dev\hop\HopBaseConfig\hop-config.json'
$env:HOP_CONFIG_FOLDER = 'C:\dev\hop\HopBaseConfig'
#Launch Hop 2.7
start-process -FilePath "C:\programs\hop\hop_2.7\hop-gui.bat" -WorkingDirectory "C:\programs\hop\hop_2.7"
```
### Issue Priority
Priority: 3
### Issue Component
Component: Hop Gui
Contributor guide
Research direction
Start by reproducing the clear-cache button failure in the Hop GUI against the remote SQL Server database, using the supplied Windows and VS Code launch script. Compare whether the cache clears before and after restarting Hop or VS Code; done means the button reliably clears the table-input cache without closing either process.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, sql
- Domain
- databases, desktop
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100