Two SQLs is slow when customer using 3DEXPERIENCE Catia

One Customer is complaining the performance, and from there AWR , found that there are two SQLS are very slow. select j.*, t1.mxPhysicalId, t1.mxLogicalId, t1.mxCEStamp, t1.mxUpdateStamp, t1.mxTenant, t1.mxMajorId, t1.mxVersionId, t1.mxMinorOrder, t1.mxMajorOrder, t1.mxPublished, t1.lxKind, t1.mxIsBSF from…

Continue ReadingTwo SQLs is slow when customer using 3DEXPERIENCE Catia

Catia V5 Powerby to Support Old Version Catia V5

To support Catia V5 version which is not in the program directory list. Prerequis3DEXperience VersionSolution:Installation sequence for a new CATIA V5 client should be:Install CATIA V5-6R2017 GA levelInstall ENOVIA_UT5.win_b64Install CATIA V5 Service Pack levelInstall CATIA…

Continue ReadingCatia V5 Powerby to Support Old Version Catia V5

How To Reimport XPDM Imported Objects which is manually deleted

If you manually deleted XPDM imported objects ,and reimport it again. 402 error will got. Return Code = 402Failed to transfer the PLM Components to the 3DEXPERIENCE Platform server go to reports\TransitionEngine\Report_xx-xx-202x_xx.xx.xx , check ProcessReport.html, you…

Continue ReadingHow To Reimport XPDM Imported Objects which is manually deleted

3DSpace Index aggregation slow issue

One customer encounter 3DSpace Index aggregation slow issue. after SR investigate , suggested change file at data/cv/data/config/Consolidation.xml FlatAssignedSpaceAggregationProcessor:enabled="false"MATConnectionsAggregationProcessor:enabled="false" because the customer did not run buildgct after modification. then some days later , the configuration rolled…

Continue Reading3DSpace Index aggregation slow issue

如何打开3DE的追踪Trace日志

有的时候,比如需要知道3DE操作时候数据库的SQL是哪些,这时候我们需要打开SQL的追踪。 使用管理员登陆"Collaboration and approvals" --》Utility --》 Run MQL ,运行下面的MQL trace type sql filename sql.txt 可以使用 print trace 查看当前的追踪状态,SQL TRACE有没有被打开。 这时候,如上图,3DSpace的所有SQL都会打印在/usr/DassualtSystemes/R2025x/3DSpace/logsCAS目录中的sql.txt文件中。 查看这个文件,可以看到很多SQL ,可以使用 tail -f sql.txt 查看SQL的更新(太多了看不过来) 当我们结束SQL查看后,我们需要关掉SQL的追踪,不然日志文件会越来越大,很容易导致磁盘空间不足。 使用 trace off 关闭所有的追踪 也可以单独使用 trace type sql…

Continue Reading如何打开3DE的追踪Trace日志