过滤器定义界面System Hierarchy丢失或Object Type丢失

博主： Leon
发布时间：2021 年 08 月 07 日
1005 次浏览
暂无评论
1920字数
分类：流程工厂

项目中或多或少会发生一些诡异现象，前几天有客户在定义过滤器时发现系统目录树看不到了，还有客户Object Type信息看不到了，目前还未知什么骚操作引起的，但有以下三种解决方案可以尝试。

方法一

<ol style="font-size:16px"><li>Start new Smart 3D session and define workspace using some existing filter or open an existing session file.</li><li>Select&nbsp;Tools&nbsp;&gt;&nbsp;Custom Commands. Add custom command with ProgID&nbsp;SP3DPrjMgtRepairCMD.FixCnfgProjectRoot&nbsp;and click&nbsp;Run. Wait until command processing is completed.</li><li>Exit Smart 3D.</li><li>Restart Smart 3D. Try to define a new filter and check if system hierarchy is available for selection.</li></ol>

方法二

<ol style="font-size:16px"><li>Start the Package Manager tool from&nbsp;[Install Directory]\Core\Tools\Administrator\SQLMetadata\Bin\PackageMgr.exe.</li><li>Set the Provider Type, Server, and catalog schema Database.</li><li>Click&nbsp;Check.</li><li>Select&nbsp;Packages&nbsp;tab.</li><li>Click&nbsp;Update BOC. Wait until command processing is completed.</li><li>Exit the Package Manager tool.</li><li>Restart Smart 3D. Try to define a new filter and check if system hierarchy is available for selection.</li></ol>

<figure class="wp-block-image size-full"><a href="https://mrgeng.com/usr/uploads/2021/08/MetaData-Package-Manager-01.jpg"><img src="https://mrgeng.com/usr/uploads/2021/08/MetaData-Package-Manager-01.jpg" alt="" class="wp-image-1967" style=""></a></figure>

<figure class="wp-block-image size-full"><a href="https://mrgeng.com/usr/uploads/2021/08/MetaData-Package-Manager-02.jpg"><img src="https://mrgeng.com/usr/uploads/2021/08/MetaData-Package-Manager-02.jpg" alt="" class="wp-image-1968" style=""></a></figure>

方法三

<ol style="font-size:16px"><li>Start&nbsp;SQL Server Management Studio.</li><li>Create a&nbsp;New Query&nbsp;on the problematic model database.</li><li>Define the new query as follows: TRUNCATE TABLE COREObjectIntegrity</li><li>Click&nbsp;Execute.</li><li>Open&nbsp;the CheckRelations&nbsp;database integrity&nbsp;script from&nbsp;[Install Directory]\Core\Server\Schema\SQL\IntegrityScripts\CheckRelations.sql&nbsp;and connect it to&nbsp;the problematic model database.</li><li>Click&nbsp;Execute.</li><li>Start new Smart 3D session and define workspace using some existing filter or open an existing session file.</li><li>Select&nbsp;Tools&nbsp;&gt;&nbsp;Custom Commands. Add custom command with ProgID&nbsp;SP3DCleanDatabaseCmd.CCheckObj&nbsp;and click&nbsp;Run.</li><li>For&nbsp;Database Type, select&nbsp;Model.</li><li>Click&nbsp;Select All, then&nbsp;Clean Now. Wait until command processing is completed.</li><li>Exit Smart 3D.</li><li>Restart Smart 3D. Try to define a new filter and check if system hierarchy is available for selection.</li></ol>

当发生object type页面信息丢失时也可以使用方法二。

最后修改：2025 年 03 月 13 日