Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.9K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.4K Development
- 17 Developer Projects
- 139 Programming Languages
- 293.1K Development Tools
- 111 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 161 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 475 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
SQL Developer Reports - Queries lost

I am using my Windows 10 laptop for SQL Developer and I am a "heavy" user of the Reports. I create an use lots of the User Defined Reports and store the ones I want to keep in a sub-folder of User Define Reports (makes it easy to export). I use drilldown and child.
Today I started SQL Developer and ... the User Defined Reports report definitions are there (the tree is build in the Report panel) but all the SQL queries are EMPTY :-0
OMG... and I did not make a backup last weeks....
The standard reports that come with SQL Developer all seem to work fine.
So...
What I did yesterday and might be the cause of this - since I never did it before and it crashed - is that I wanted to "Generate DB Doc ..." from the r-click popup menu of a connection. It worked for a small DB-schema, but when ran it for the most interesting -large!- schema, the process aborted. I tried it first running in the foreground and second running in the background.
Two questions:
- is there any possibility I can get my reports back? Are they still somewhere?
- is this a bug? How to fix this?
My SQL Developer Configuration is in the attached file.
Thanks,
Herman
Best Answer
-
Hi,
User Reports are persisted by SQL Developer in the
UserReports.xml
file, under%APPDATA%\SQL Developer
if using Windows.That single file contains all your User Reports, and it is rewritten by SQL Developer whenever anything pertaining to User Reports is changed, e.g. after adding a new report, modifying an existing one, deleting, importing, creating a folder, etc.
So, yes, having backups of that file may turn out to be very useful at times.
Alternatively, always export your reports to separate XML files after you have made any serious work in them.
Regards,
Answers
-
I can't help you.
IIRC - I Export the reports and add that Export file to a code repository
-
Hi Mike, thanks for the reply.
Indeed ... I know ... Unfortunately this happened before I did that.
Do you know of any batch (powershell? cmd?) that can be executed so these reports are automatically exported (and subsequently the XML is included in my regular, scheduled backup?
Or perhaps which SQL Developer folder I should include in my scheduled backup?
Kind regards,
Herman
-
I would have to check what sql developer command line can do.
Someone from the SQL Developer team (eg @thatJeffSmith-Oracle ) should be able to tell you which folder(s) would need to be included. I suspect they are under /users/person/roaming
-
Hi,
User Reports are persisted by SQL Developer in the
UserReports.xml
file, under%APPDATA%\SQL Developer
if using Windows.That single file contains all your User Reports, and it is rewritten by SQL Developer whenever anything pertaining to User Reports is changed, e.g. after adding a new report, modifying an existing one, deleting, importing, creating a folder, etc.
So, yes, having backups of that file may turn out to be very useful at times.
Alternatively, always export your reports to separate XML files after you have made any serious work in them.
Regards,
-
Hi,
Thank you @Mike Kutz and @User_2DKLA . I have checked and in that XML the query nodes are all empty CDATA's . So what exactly happened that caused this, remains unknown - for now. I suspect the crashes when trying the DBDoc from the r-click popup menu of a connection to a large schema...
I will add the XML's in %APPDATA%\SQL Developer to my regular backup.
Regards,
Herman