Print Thread
Page 1 of 2 1 2
Problems with Worksets
#64667 06/16/23 02:53 PM
Joined: Jan 2003
Posts: 46
NJ, USA
C
Member
OP Offline
Member
C
Joined: Jan 2003
Posts: 46
NJ, USA
I am having intermittent problems with worksets in version 15.0.3.

I don't use multiple worksets. I have one single workset that I use to automatically restore the windows from the previous PL/SQL Developer session. Today, I closed PL/SQL Developer and then re-opened it about 10 minutes later and the contents of all unsaved SQL windows were lost. The SQL windows were still in the window list but there was an error something like "Unable to read file" for each unsaved SQL window and the contents were lost. This happens at least once every week or so.

Sometimes the entire workset is lost and no windows are opened at all. This happens must less frequently. It has only happened a handful of times since I began using version 15 in April 2022.

I don't usually explicitly save the workset before closing PL/SQL Developer as the documentation states that it is automatically saved when PL/SQL Developer closes.

Is there anything I can do or provide to help debug this issue?

Re: Problems with Worksets
cassiusdrow #64670 06/19/23 08:48 AM
Joined: Aug 1999
Posts: 22,208
Member
Offline
Member
Joined: Aug 1999
Posts: 22,208
Is there any pattern to this error situation? Do you keep PL/SQL Developer and/or Windows running for multiple days when such an error occurs?


Marco Kalter
Allround Automations
Re: Problems with Worksets
cassiusdrow #64679 06/25/23 02:44 PM
Joined: Jan 2003
Posts: 46
NJ, USA
C
Member
OP Offline
Member
C
Joined: Jan 2003
Posts: 46
NJ, USA
I haven't noticed a specific pattern but I do tend to leave PL/SQL Developer open for more than one day.

Re: Problems with Worksets
cassiusdrow #64704 07/10/23 04:04 PM
Joined: Jan 2003
Posts: 46
NJ, USA
C
Member
OP Offline
Member
C
Joined: Jan 2003
Posts: 46
NJ, USA
Last week, I had a workset that was lost. I accidentally opened two copies of PL/SQL Developer and they both opened the same workset. I closed one copy of PL/SQL Developer and went about my day. Later, I closed the remaining copy and when I reopened it, the all the windows of the workset were completely gone. The workset itself was still there but it had no contents.

Re: Problems with Worksets
cassiusdrow #64734 07/25/23 08:19 AM
Joined: Jul 2023
Posts: 1
L
Member
Offline
Member
L
Joined: Jul 2023
Posts: 1
I have the same problem, it happened few times that my worksets were lost and I lost important sqls, so I stopped using worksets.

Re: Problems with Worksets
cassiusdrow #64779 08/30/23 12:12 AM
Joined: Jan 2003
Posts: 46
NJ, USA
C
Member
OP Offline
Member
C
Joined: Jan 2003
Posts: 46
NJ, USA
I lost my workset again today and another time last week. I started closing PL/SQL Developer at the end of the day for the past few weeks and I am losing worksets more frequently, usually about once a week. This is probably because closing and opening PL/SQL Developer more frequently gives it more opportunities to lose the workset.

Re: Problems with Worksets
cassiusdrow #64780 08/31/23 08:03 PM
Joined: Sep 2008
Posts: 143
Ireland
W
Member
Offline
Member
W
Joined: Sep 2008
Posts: 143
Ireland
I have never used worksets, but I must say that I have been using Projects for at least 5 years and have never had an issue with any lost files or projects.

Re: Problems with Worksets
cassiusdrow #64805 09/26/23 01:35 AM
Joined: Feb 2013
Posts: 251
UTC+10
I
Member
Offline
Member
I
Joined: Feb 2013
Posts: 251
UTC+10
I've also had occasional problem with lost worksets (no errors given). I've notiiced that lost was more possible during open operation and was less possible while close operation.
But this bug is too serious to use this functionality so I've reverted to ol'good "desktop=" which works flawlessly.

Re: Problems with Worksets
cassiusdrow #64835 10/06/23 01:59 PM
Joined: Jan 2003
Posts: 46
NJ, USA
C
Member
OP Offline
Member
C
Joined: Jan 2003
Posts: 46
NJ, USA
Marco,

The "unable to read desktop.cfg" happened again today. This time I looked at the "AppData\Roaming\PLSQL Developer 15\Worksets" folder and saw two folders: "General", which is the name of my only workset, and "General.tmp". The "General.tmp" folder had a "desktop.cfg" file along with the "file.info" and other "desktop" files with numeric extensions like "desktop.005". However, the "General" folder was missing the "desktop.cfg" and some "desktop" files with numeric extensions. I made a backup copy of the "Worksets" folder and closed PL/SQL Developer, which deleted the "General.tmp" folder and deleted everything in the "General" folder. I copied the contents of the "General.tmp" backup to the "AppData\Roaming\PLSQL Developer 15\Worksets\General" folder. When I re-opened PL/SQL Developer, the workset was restored.

Could it be that PL/SQL Developer did not save the workset properly? Can you have PL/SQL Developer look for the "General.tmp" folder if it does not find the "desktop.cfg" in the "General" folder?

Re: Problems with Worksets
cassiusdrow #65470 03/05/24 03:57 PM
Joined: Jan 2003
Posts: 46
NJ, USA
C
Member
OP Offline
Member
C
Joined: Jan 2003
Posts: 46
NJ, USA
These problems continues to happen frequently. At this point I consider the Worksets feature to be completely unstable and unusable.

Page 1 of 2 1 2

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.087s Queries: 15 (0.038s) Memory: 2.5589 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-05-05 07:43:30 UTC
Valid HTML 5 and Valid CSS