I have a very complex development database for testing a customization. In order to test my customization, I need multiple tenants with specific settings, logins etc. It takes hours to get a new instance setup completely to test.
When I unpublish a customization and delete it, it appears there is still “junk” in the database that is keeping information which is causing problems.
Example: I unpublish, delete the project, create a new one and whe I go to add a custom page. The title doesn’t show up. Or, it shows the previous screens which were deleted.
I have to create a new screen ID (such as IC.10.10.01) in order for it to show the Title. I cannot find any way to add the title to this screen.
Also, I can tell the database is got “junk” in it because it still shows previous site map items and screens. These two screens are not in my project or in the web site but they show up in the lookup screen:
Note, I am working with a completely clean installation of the web site. The site itself has no references to the previous published project.
What are the tables in the database that I can purge to completely get rid of a previous customization? It HAS to be driven by the database somewhere.
Best answer by Hughes Beausejour
It sounds like some minor site map entry corruption has been going on. This can happen when you manually delete and create site map pages.
In those cases the solution is to:
- Manually delete the site map pages if necessary using the Site Map screen SM200520. You want to use Acumatica pages for deletion operation. Deleting records directly in database can lead to further corruption.
- Re-create the site map item by republishing the customization with clean-up option which re-executes all the database scripts that creates the site map entry (assuming the customization properly packages the site map items in site map section).