Persistent ghost folder on root directory

Hello,

Maybe your database contains duplicate folders.

Could you please go in Help - Diagnostic - Data Source - Database Diagnostic and post a screen shot of the Summary and Virtual Folders tab of the Database Diagnostic report?

Best regards,

Hi Erica,

thanks for your reply.
Here the summary:



Virtual folder tab is empty:

Hello,

Thank you for the screen shots.

Could you please send me the database schema using Email Schema to Support button in the Upgrade tab of your data source configuration (File - Data Sources)? Please add a reference to this forum post in the Message section.



Best regards,

Dear Erica,

thank you for your support.
I decided to create a new database and see if the issue happen again .

Best regards

Hello,

Thank you for your feedback. Let us know how it goes with the new database.

Best regards,

Dear Erica,

before to start from scratch and create a new database I investigated into it.
The issue was probably related to a database crash happened 2 month ago, in fact after the backup restore the issue started to frustrate me....

Into the table "connections", filtering it with the name of the old group folder, I found the entries that appeared one by one into the root folder

SELECT * FROM Connections where GroupName = '<xxx>'

After I compared the ID string and confirmed that they were the same I decided to delete all the 266 "ghost" folders.
In addition to this I found 2 entries with the same group name filtering it with the column "Name"

SELECT * FROM Connections where Name = '<xxx>'

Those entries had the timestamp of the incident and the time of the restore.
I deleted them.

The issue seems to be solved now, so we can close the case.

Thank you very much

Have a nice day

Best regards

Hello,

Thank you for your feedback and glad that you have found the problematics records in your database.

Best regards,