已知问题|业务规则不生效/服务业务规则无法打开/生命周期点开报错/无法编辑RLC规则/自定义触发器无法打开
问题现象
业务规则不生效/服务业务规则无法打开/生命周期点开报错/无法编辑RLC规则/自定义触发器无法打开
问题排查
打开网页抓包，如果发现调用了此api/v3/requests/_metainfo并报错"Internal error"。则可以确认是已知问题。
临时解决方法
1、复现问题，查看/logs/serverout0.txt日志。
2、可以找到如下报错，Service ID可能不同。
[15:02:10:491]|[08-08-2024]|[com.manageengine.sdpod.v3api.handlerimpl.WorkOrderHandler]|[SEVERE]|[61]: No Service table found for the service 1801|
java.lang.Exception: No Service table found for the service 1801
at com.manageengine.servicedesk.utils.ServiceCatalogUtil.getServiceTable(ServiceCatalogUtil.java:1663)
at com.manageengine.servicedesk.utils.ServiceCatalogUtil.getServiceTable(ServiceCatalogUtil.java:1628)
at com.manageengine.servicedesk.utils.ServiceCatalogUtil.getAllServiceTablesUsingMDHSettings(ServiceCatalogUtil.java:5814)
at com.manageengine.servicedesk.utils.ServiceCatalogUtil.getAllServiceTablesUsingMDHSettings(ServiceCatalogUtil.java:5797)
3、到数据库中执行下列sql
select * from servicedefinition where serviceid=1801;
通过此SQL语句可以看到对应的服务目录的名称。
4、到服务目录的编辑页面，任意修改一个字段再重新保存。然后再使用无痕模式，观察此问题是否解决。
注：
可能存在多个服务目录报错的问题。如果执行后问题未解决。可再观察日志，是否有其它的服务目录报错。
国内目前遇到四次此问题都参考上述步骤解决，研发还提到会有其它情况，如参考上述步骤未解决可参考：
Reason - Issue occurs if service category and service additional
fields related tables like servicemetatable, dynamic tables contains
orphan entries for that particular service category
Queries to be executed directly from db:
1. select * from servicemetatable where serviceid =4801;
2. select * from dynamictables where tablename in ('ServiceReq_4801','SServiceReq_4801','ARC_ServiceReq_4801');
3. select * from tabledetails where table_name in ('ServiceReq_4801','SServiceReq_4801','ARC_ServiceReq_4801');
4. select * from columndetails where table_id not in (select table_id from tabledetails);
5. select * from servicereq_4801;
6. select * from sservicereq_4801;
7. select * from arc_servicereq_4801;
8. select * from servicedefinition where serviceid=4801;
Replace '4801' with service category id which is found in error trace
To resolve the issue:
Scenario 1 :
Scenario 1 :
If
query 5 to 7, throws error like no table is present and if query 1 to 4
contains data, then it is safe to delete those orphan entries using
below queries
1. delete from servicemetatable where serviceid =4801;
2. delete from dynamictables where tablename in ('ServiceReq_4801','SServiceReq_4801','ARC_ServiceReq_4801');
3. delete from tabledetails where table_name in ('ServiceReq_4801','SServiceReq_4801','ARC_ServiceReq_4801');
4. delete from columndetails where table_id not in (select table_id from tabledetails);
From query 8, we'll get the service category name for which issue occurs. After executing the above delete query, we can just dummy update this service category to resolve the issue
From query 8, we'll get the service category name for which issue occurs. After executing the above delete query, we can just dummy update this service category to resolve the issue
Scenario 2 :
If query 5 to 7, throws error like no table is present and if query 1 to 4 also contains no data, then we can just simply dummy update the service category and check if issue is resolved
If query 5 to 7, throws error like no table is present and if query 1 to 4 also contains no data, then we can just simply dummy update the service category and check if issue is resolved
彻底解决
14820版本仍存在此问题。留意此需求ID SDF-110479 此需求功能会修改数据表结构，从而彻底避免此问题发生。
Related Articles
无法通过WMI模式监控 .NET Framework 2.0 SP1 的应用程序。
通过WMI公开数据存在一个已知问题，Microsoft已针对该问题发布了修补程序，您可以在此处获取。ADAP-点击部分标签网页上方会出现一部分空白（7050之后的builds）
如下图，在Build7050之后，点击“报表”、“文件审核”和“服务器审核”三个标签，页面上方会出现空白： 这是Build7050及之后builds的一个已知问题，该问题会在ADAudit Plus集成在AD360时（url是**/AppsHome）出现，单独的ADAudit Plus不会出现该问题（url是**/#/Home）。 解决方案： ...【opm】新安装启动后报“su: cannot open session: Module is unknown”如何解决
问题： - "su: cannot open session: Module is unknown" 日志报错 #Trace [10:42:30:361]|[05-14-2024]|[pglog]|[INFO]|[21]: su: 无法打开会话：模块未知| [10:44:06:044]|[05-14-2024]|[pglog]|[INFO]|[21]: su: 无法打开会话：模块未知| 原因： 这是CentOS中的环境级别问题，特定操作系统中的已知问题。 解决方法： ...13 XXX 版本升级到14205版本升级问题。
目前有在客户环境中遇到13XXX版本升级14205版本两个报错，可以在相同升级前额外注意提前检查是否存在相同问题，或者在发现相同报错时采取下列解决方案。 升级包 https://download.manageengine.com/products/service-desk/91677414/ManageEngine_ServiceDesk_Plus_14_2_0_SP-0_5_0.ppm ...