I imported an export with objects generated with a GeneXus extension I don't have installed. How find and delete this object from my KB?
When I open the KB apear this error:
TITLE: Open Knowledge Base
Knowledge Base at 'C:\Models\101\MT1' contains items that GeneXus doesn't know how to handle and will therefore be inaccessible.
It is likely that the Knowled开发者_开发问答ge Base has been previously opened with a GeneXus installation which had extensions that are not present in the current one.
These items are: * 'K2BToolsAuditSettings' - 'K2 BTools Audit Settings' (GUID 75a2b955-749a-3f29-99e0-aec666f802a0) Provided by 'AuditUI' (GUID bf5ce710-6999-4e70-9ed8-a8ac4017827d).
Working on this Knowledge Base may lose information related to these unknown items.
Executing this script, i resolved this problem.
delete from Entity where EntityTypeId = (select EntityTypeId from EntityType where EntityTypeName = 'K2BToolsAuditSettings') delete from EntityVersion where EntityTypeId = (select EntityTypeId from EntityType where EntityTypeName = 'K2BToolsAuditSettings') delete from EntityVersionComposition where ComponentEntityTypeId = (select EntityTypeId from EntityType where EntityTypeName = 'K2BToolsAuditSettings') delete from EntityVersionComposition where CompoundEntityTypeId = (select EntityTypeId from EntityType where EntityTypeName = 'K2BToolsAuditSettings') delete from ModelCrossReference where FromEntityTypeId = (select EntityTypeId from EntityType where EntityTypeName = 'K2BToolsAuditSettings') delete from ModelCrossReference where ToEntityTypeId = (select EntityTypeId from EntityType where EntityTypeName = 'K2BToolsAuditSettings') delete from ModelEntityHistory where EntityTypeId = (select EntityTypeId from EntityType where EntityTypeName = 'K2BToolsAuditSettings') delete from ModelEntityOutput where EntityTypeId = (select EntityTypeId from EntityType where EntityTypeName = 'K2BToolsAuditSettings') delete from ModelEntityProperty where EntityTypeId = (select EntityTypeId from EntityType where EntityTypeName = 'K2BToolsAuditSettings') delete from ModelEntityToTable where EntityTypeId = (select EntityTypeId from EntityType where EntityTypeName = 'K2BToolsAuditSettings') delete from ModelEntityVersion where EntityTypeId = (select EntityTypeId from EntityType where EntityTypeName = 'K2BToolsAuditSettings')
精彩评论