When open some Items in details view or Preview when edit which are created with the Module Builder an error is thrown.
When accessing the detail page for a particular item, it throws Server Error, other items' pages are fine.

Orphaned records in sf_url_data table.

Automated Resolution steps:

Refer to attached FindOrphanedUrlData.zip which contains a small tool which automatically find any orphaned urls for Sitefinity dynamic module and have functionality to delete them.
To use the tool:

0. Backup the site database as a good practice
1. Extract the archive and Include it in the source code of Sitefinity site and compile/build

2. Login to Sitefinity Admin area and access the tool by url: http://site.com/FindOrphanedUrlData/FindOrphaneUrlForModule.aspx
3. Select the site and module which experiences a problem

4. Click button "Find all orphaned urls" and a list of all orphaned urls for the selected module will be displayed

5. Click button "Delete orphaned url" to delete the urls.

Manual steps:

1. Backup the database
2. Use the backup to run the site and test this resolution
3. Execute the below SQL query filling up the <DatabaseName> and <ModuleName>.<ModuleType>:

DELETE
FROM <DatabaseName>.[dbo].[sf_url_data]
WHERE content_id NOT IN (SELECT sdc.base_id FROM <DatabaseName>.[dbo].[sf_dynamic_content] AS sdc WHERE sdc.base_id = content_id)
AND item_type = 'Telerik.Sitefinity.DynamicTypes.Model.<ModuleName>.<ModuleType>'  -- set the content type

NOTE: To retrieve <ModuleName>.<ModuleType> go to Administration > Module Builder, select the module for which the problem occurs and click on "Code reference for <module name>". Click on any link in the left sidebar and find the module string that starts with: Telerik.Sitefinity.DynamicTypes.Model.<ModuleName>.<ModuleType>. The values of <ModuleName>.<ModuleType> can be found there.

4. Restart the site and check if this has solved the problem.

In case the above didn`t solve the problem use the below query:

delete from sf_url_data
where url = 'problematic-url'

Replace problematic-url with the url of the item that triggers the problem.

After executing the query restart the site and republish the problematic item. The problem is resolved after this.

 

Recreate the Item with different URL.