在Agile启动之前启用admin.validate 的debug功能来查错

 

注：此文章仅供Agile PLM相关的客户、实施人员、技术顾问等学习之用，在此站发表的文章所涉及的所有技术细节，仅代表个人见解，不代表Oracle公司。所有Agile PLM和Oracle相关产品的知识产权均属于Oracle。在未经Oracle的官方授意下而擅自使用本文章的知识来修改任何Agile PLM的系统配置、数据或编译后的代码，由此导致的系统崩溃或数据丢失，本人概不负任何责任。

 

 

admin.validate的系统参数，是AgilePLM在9.2之后加入的一个调试功能，目前处于无人维护的状态。但是在PLM的生产环境中，该参数对于Admin数据的错误分析极其有用。

 

作用：报告admin模块的严重错误

 

设置：
1）ORACLE_HOME/opmn/conf/opmn.xml

<process-type id="home" module-id="OC4J" status="enabled">
               <module-data>
                  <category id="start-parameters">
                     <data id="java-options" value="-Dadmin.validate=true -Xrs –server …/>

2）重新启动Agile

3）检查opmn的log
--
09/03/13 06:13:52 Validating: Node Property Referential Integrity
OK
09/03/13 06:13:54 Validating: Node Assignment Referential Integrity
OK
09/03/13 06:13:56 Validating: Node Appliedto Referential Integrity
OK
09/03/13 06:13:56 Validating: Node Criteria Referential Integrity
OK
09/03/13 06:13:59 Validating: Duplicate Properties
OK
09/03/13 06:14:03 Validating: Invalid Applied To Attributes in Modify Privileges
ERROR!
PARENTID: 9972 ATTID: 2000006062

09/03/13 06:14:09 Validating: Applied To Attributes without Modifiable Properties
ERROR!
PARENTID: 53763 ATTID: 59195
PARENTID: 53766 ATTID: 59195

09/03/13 06:14:15 Validating: Invalid Role Privilege Assignment
ERROR!
PARENTID: 38116 ATTID: 409 VALUE: 35599
PARENTID: 38116 ATTID: 409 VALUE: 35612
PARENTID: 38116 ATTID: 409 VALUE: 35620
PARENTID: 38116 ATTID: 409 VALUE: 35669
PARENTID: 38116 ATTID: 409 VALUE: 35672
PARENTID: 38116 ATTID: 409 VALUE: 35692
PARENTID: 38116 ATTID: 409 VALUE: 35696
PARENTID: 38116 ATTID: 409 VALUE: 35705
PARENTID: 38116 ATTID: 409 VALUE: 35709
PARENTID: 38116 ATTID: 409 VALUE: 35710
PARENTID: 38116 ATTID: 409 VALUE: 35714
PARENTID: 38116 ATTID: 409 VALUE: 35715
PARENTID: 38116 ATTID: 409 VALUE: 36105
PARENTID: 38116 ATTID: 409 VALUE: 38115

09/03/13 06:14:16 Validating: Invalid Node Criteria Assignment
OK
09/03/13 06:14:18 Validating: Invalid Attribute Reference in TableInfo
OK
09/03/13 06:14:18 Validating: Invalid Table Reference in TableInfo
OK
09/03/13 06:14:19 Validating: Invalid Tab Reference in TableInfo
OK
09/03/13 06:14:20 Validating: Invalid Class Reference in TableInfo
--

 

Validation的定义
Validating: Node Property Referential Integrity
SELECT B.PARENTID FROM PROPERTYTABLE B WHERE NOT EXISTS (SELECT 1 FROM NODETABLE A WHERE A.ID = B.PARENTID)

 

Validating: Node Assignment Referential Integrity
SELECT B.PARENTID FROM ADMINMSATT B WHERE NOT EXISTS (SELECT 1 FROM NODETABLE A WHERE A.ID = B.PARENTID)

 

Validating: Node Appliedto Referential Integrity
SELECT B.PARENTID FROM APPLIEDTO B WHERE NOT EXISTS (SELECT 1 FROM NODETABLE A WHERE A.ID = B.PARENTID AND A.OBJTYPE=22)

 

Validating: Node Criteria Referential Integrity
SELECT B.PARENTID FROM ADMINCRITERIA B WHERE NOT EXISTS (SELECT 1 FROM NODETABLE A WHERE A.ID = B.PARENTID AND A.OBJTYPE = 111)

 

Validating: Duplicate Properties
select parentid, propertyid, count(*) from propertytable group by parentid, propertyid having count(*) > 1

 

Validating: Invalid Applied To Attributes in Modify Privileges
select parentid, attid from appliedto where parentid in (select parentid from propertytable where propertyid = 50 and ltrim(rtrim(value)) = '9') and attid in (select parentid from propertytable where propertyid = 60 and ltrim(rtrim(value)) = '0') and attid <> 2000007771 order by parentid, attid

Validating: Applied To Attributes without Modifiable Properties
select parentid, attid from appliedto a where not exists (select 1 from propertytable p where propertyid = 60 and p.parentid = a.attid) and a.parentid in (select parentid from propertytable where propertyid = 50 and ltrim(rtrim(value)) = '9')

 

Validating: Invalid Role Privilege Assignment
select parentid, attid, value from adminmsatt where attid = 409 and value not in (select id from nodetable where objtype=22) order by parentid, attid, value

 

Validating: Invalid Node Criteria Assignment
select parentid, attid, value from adminmsatt where attid = 412 and value not in (select id from nodetable where objtype=111) order by parentid, attid, value

 

Validating: Invalid Attribute Reference in TableInfo
select att from tableinfo t where not exists (select 1 from nodetable n where objtype=1 and n.id = t.att)

 

Validating: Invalid Table Reference in TableInfo
select tableid from tableinfo t where not exists (select 1 from nodetable n where objtype = 2 and n.id = t.tableid)

 

Validating: Invalid Tab Reference in TableInfo
select tabid from tableinfo t where not exists (select 1 from nodetable n where objtype = 9 and n.id = t.tabid)

 

Validating: Invalid Class Reference in TableInfo
select classid from tableinfo t where not exists (select 1 from nodetable n where objtype in (5, 13, 16) and n.id = t.classid)

 

 

其他问题

如何解决报告的Error以及如何在Weblogic中设置，请联系本博客。